Question

Crystal Report Error in CWS

  • 18 January 2024
  • 4 replies
  • 93 views
N
Rank
Badge +3

Hi comunity,

I have a testing Layout for Crystal installation.

The  layour works properly in Crystal Development tool with IFSPRINT user but, when i try into IFS CLOUD… I have this error:

 

18/01/2024 12:36:46[IFSCRCFG]-[GetDbInfoFromXml] Decrypted.
18/01/2024 12:36:46[IFSCRCFG]-[GetDbInfoFromXml] Decrypted.
18/01/2024 12:36:46[IFSCRCFG]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-CFGPDB AppOwner-IFSAPP IALOwner-IFSINFO
18/01/2024 12:36:46[IFSCRCFG]-[GetDbInfoFromXml] Decrypted.
18/01/2024 12:36:46[IFSCRCFG]-[GetDbInfoFromXml] Decrypted.
18/01/2024 12:36:46[IFSCRCFG]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-CFGPDB AppOwner-IFSAPP IALOwner-IFSINFO
18/01/2024 12:36:46[IFSCRCFG]-[GetSavedPDFReport] Exporting the report in PDF format.
18/01/2024 12:36:46[IFSCRCFG]-[GetSavedPDFReport] File Name : C:\inetpub\wwwroot\IFSCRCFG\tmp\en\0dfcd464-9972-4012-8b34-5763f4676973.rpt
18/01/2024 12:36:46[IFSCRCFG]-[GetSavedPDFReport] ParameterValues : 43 ,LangCode = en
18/01/2024 12:36:46[IFSCRCFG]-[base64Encode] for 43
18/01/2024 12:36:46[IFSCRCFG]-[base64Encode] Encoded value : NDM=
18/01/2024 12:36:46[IFSCRCFG]-[base64Decode] for NDM=
18/01/2024 12:36:46[IFSCRCFG]-[base64Decode] Decoded to 43
18/01/2024 12:36:46[IFSCRCFG]-[GetDbInfoFromXml] Decrypted.
18/01/2024 12:36:46[IFSCRCFG]-[GetDbInfoFromXml] Decrypted.
18/01/2024 12:36:46[IFSCRCFG]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-CFGPDB AppOwner-IFSAPP IALOwner-IFSINFO
18/01/2024 12:36:46[IFSCRCFG]-[OpenReport] File Name : C:\inetpub\wwwroot\IFSCRCFG\tmp\en\0dfcd464-9972-4012-8b34-5763f4676973.rpt
18/01/2024 12:36:46[IFSCRCFG]-[IsFileNameValid] fileName : C:\inetpub\wwwroot\IFSCRCFG\tmp\en\0dfcd464-9972-4012-8b34-5763f4676973.rpt
18/01/2024 12:36:46[IFSCRCFG]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
18/01/2024 12:36:46[IFSCRCFG]-[IsFileNameValid] decodedFileName : C:\inetpub\wwwroot\IFSCRCFG\tmp\en\0dfcd464-9972-4012-8b34-5763f4676973.rpt
18/01/2024 12:36:46[IFSCRCFG]-[IsFileNameValid] basePathDB : C:\inetpub\wwwroot\IFSCRCFG\tmp\
18/01/2024 12:36:46[IFSCRCFG]-[IsFileNameValid] basePathServer : C:\Reports
18/01/2024 12:36:46[IFSCRCFG]-[IsFileNameValid] rptFullpath : C:\inetpub\wwwroot\IFSCRCFG\tmp\en\0dfcd464-9972-4012-8b34-5763f4676973.rpt
18/01/2024 12:36:46[IFSCRCFG]-[IsFileNameValid] canonicalPath : C:\inetpub\wwwroot\IFSCRCFG\tmp\en\0dfcd464-9972-4012-8b34-5763f4676973.rpt
18/01/2024 12:36:46[IFSCRCFG]-[IsFileNameValid] returning true
18/01/2024 12:36:46[IFSCRCFG]-[OpenReport] The file C:\inetpub\wwwroot\IFSCRCFG\tmp\en\0dfcd464-9972-4012-8b34-5763f4676973.rpt is found
18/01/2024 12:36:46[IFSCRCFG]-[LoadInfoServiceReport] Loading infoServe report : C:\inetpub\wwwroot\IFSCRCFG\tmp\en\0dfcd464-9972-4012-8b34-5763f4676973.rpt
18/01/2024 12:36:46[IFSCRCFG]-[LoadInfoServiceReport] DBUser = IFSPRINT ,DBPassword : ******* ,DBServerName : CFGPDB ,AppOwner : IFSAPP
18/01/2024 12:36:46[IFSCRCFG]-[LoadInfoServiceReport] Setting up logon information for each database object.
18/01/2024 12:36:46[IFSCRCFG]-[SetTableLocation] Set appropriate post-fixes for MODULE_REP\
18/01/2024 12:36:46[IFSCRCFG]-[SetDatabaseLocation] Generating fully qualified database object name for MODULE_REP\
18/01/2024 12:36:46[IFSCRCFG]-ERROR in [LoadInfoServiceReport] Error in loading infoServices report.
18/01/2024 12:36:46[IFSCRCFG]-Error en el archivo 0dfcd464-9972-4012-8b34-5763f4676973 2312_4004_{2F431556-3C5A-4CD8-8A9E-EA4C8A5281C9}.rpt:
No se pudo cargar la información de la base de datos.   en CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.SetTableLocation(ISCRTable CurTable, ISCRTable NewTable)
   en CrystalDecisions.CrystalReports.Engine.Table.set_Location(String value)
   en Ifs_ReportService.SetDatabaseLocation(String databaseLocation, Table table) en c:\inetpub\wwwroot\IFSCRCFG\App_Code\Service.cs:línea 1755
   en Ifs_ReportService.SetTableLocation(Table crTable, String UserId, String AppOwner, String IALOwner) en c:\inetpub\wwwroot\IFSCRCFG\App_Code\Service.cs:línea 1727
   en Ifs_ReportService.LoadInfoServiceReport(String path, String DBUser, String DBPassword, String DBServerName, String AppOwner) en c:\inetpub\wwwroot\IFSCRCFG\App_Code\Service.cs:línea 1550

 

I only work with one view (_REP view).

 

Please, can you help me?

 

Thanks.! KR

 

4 replies

C
Rank
Userlevel 3
Badge +10

Hi,

Are other reports working? 

Might be totally off base here...but...

The one thing that sticks out to me above is that the appowner user is still IFSAPP

Normally that is changed to be unique per company….something like 3 letters company name 1APP.

To change to your unique appowner username go to your inetpub folder (C:\inetpub\wwwroot\IFSCRWebProd)  and modify the ifs-crystal-config.xml with your unique appowner user.

 

Also in the same area there is a Web.Config file that will need to be edited to be the path of your reports folder (where you are placing your reports) Edit this key value.

<appSettings>
        <add key="OpenReportPath" value="C:\IFS\Reports"/>
    </appSettings>

You will also need to enter the path into System Parameters.

TIA, Cindy
P
Rank
Userlevel 2
Badge +8

I have a similar issue. My log just reports this bit:

18/01/2024 12:36:46[IFSCRCFG]-[GetDbInfoFromXml] Decrypted.
18/01/2024 12:36:46[IFSCRCFG]-[GetDbInfoFromXml] Decrypted.
18/01/2024 12:36:46[IFSCRCFG]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-CFGPDB AppOwner-IFSAPP IALOwner-IFSINFO

On screen I get Error in retrieving the parameters

 

Thanks,

Alex

N
Rank
Badge +3

Hi @chajash 

Thanks for your response.

My Apllication OWNER is ifsapp.

In the other hand, in IFS Cloud, you upload your rpt file into IFS. This is a change with the old versions.

I think that the problem is in other way.

 

Thanks!

 

 

N
Rank
Badge +3

When I make the test with IIS WebService, I have an error:

 

 

 

Any idea?

 

thanks!

Reply


Terms & ConditionsCookie settings