Question

Crystal Report Error in CWS

  • 23 January 2024
  • 1 reply
  • 56 views

Badge
  • Do Gooder (Partner)
  • 0 replies

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).

 

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

 

 

 

Please, can you help me?

 

Thanks.! KR


1 reply

Userlevel 7
Badge +15

Hi @Crls,

Is this the first time you running a crystal report? Can you validate the Crystal web service is working fine for any other report?

Reply