Skip to main content
Question

23r1 crystal reports setup error


Forum|alt.badge.img+1

Hi all, 

Having issues setting up crystal reports on ifs cloud 23r1.

I have the crystal web service setup and configured and i have communication from the environment to the cws (able to fetch, clear, configure logs).

I can communicate from the ifsapp-reporting-cr pod using ‘curl -v http://x.x.x.x/IFSCRWebSetup/Ifs_ReportService.asmx’

CWS asks for an IFSPRINT password during setup, but that doesnt appear to be configurable?

Any help is greatly appreciated, its driving me nuts! Heres the report logs.

 

08/02/2024 12:36:44[IFS]-[GetDbInfoFromXml] Decrypted.
08/02/2024 12:36:44[IFS]-[GetDbInfoFromXml] Decrypted.
08/02/2024 12:36:44[IFS]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSPDB AppOwner-IFSAPP IALOwner-IFSINFO
08/02/2024 12:36:44[IFS]-[GetDbInfoFromXml] Decrypted.
08/02/2024 12:36:44[IFS]-[GetDbInfoFromXml] Decrypted.
08/02/2024 12:36:44[IFS]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSPDB AppOwner-IFSAPP IALOwner-IFSINFO
08/02/2024 12:36:44[IFS]-[GetSavedPDFReport] Exporting the report in PDF format.
08/02/2024 12:36:44[IFS]-[GetSavedPDFReport] File Name : C:\inetpub\wwwroot\IFS\tmp\en\805f8180-6d4f-4230-838a-204dc7934067.rpt
08/02/2024 12:36:44[IFS]-[GetSavedPDFReport] ParameterValues : 313 ,LangCode = en
08/02/2024 12:36:44[IFS]-[base64Encode] for 313
08/02/2024 12:36:44[IFS]-[base64Encode] Encoded value : MzEz
08/02/2024 12:36:44[IFS]-[base64Decode] for MzEz
08/02/2024 12:36:44[IFS]-[base64Decode] Decoded to 313
08/02/2024 12:36:44[IFS]-[GetDbInfoFromXml] Decrypted.
08/02/2024 12:36:44[IFS]-[GetDbInfoFromXml] Decrypted.
08/02/2024 12:36:44[IFS]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSPDB AppOwner-IFSAPP IALOwner-IFSINFO
08/02/2024 12:36:44[IFS]-[OpenReport] File Name : C:\inetpub\wwwroot\IFS\tmp\en\805f8180-6d4f-4230-838a-204dc7934067.rpt
08/02/2024 12:36:44[IFS]-[IsFileNameValid] fileName : C:\inetpub\wwwroot\IFS\tmp\en\805f8180-6d4f-4230-838a-204dc7934067.rpt
08/02/2024 12:36:44[IFS]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
08/02/2024 12:36:44[IFS]-[IsFileNameValid] decodedFileName : C:\inetpub\wwwroot\IFS\tmp\en\805f8180-6d4f-4230-838a-204dc7934067.rpt
08/02/2024 12:36:44[IFS]-[IsFileNameValid] basePathDB : C:\inetpub\wwwroot\IFS\tmp\
08/02/2024 12:36:44[IFS]-[IsFileNameValid] basePathServer : 
08/02/2024 12:36:44[IFS]-[IsFileNameValid] rptFullpath : C:\inetpub\wwwroot\IFS\tmp\en\805f8180-6d4f-4230-838a-204dc7934067.rpt
08/02/2024 12:36:44[IFS]-[IsFileNameValid] canonicalPath : C:\inetpub\wwwroot\IFS\tmp\en\805f8180-6d4f-4230-838a-204dc7934067.rpt
08/02/2024 12:36:44[IFS]-[IsFileNameValid] returning true
08/02/2024 12:36:44[IFS]-[OpenReport] The file C:\inetpub\wwwroot\IFS\tmp\en\805f8180-6d4f-4230-838a-204dc7934067.rpt is found
08/02/2024 12:36:44[IFS]-[LoadInfoServiceReport] Loading infoServe report : C:\inetpub\wwwroot\IFS\tmp\en\805f8180-6d4f-4230-838a-204dc7934067.rpt
08/02/2024 12:36:44[IFS]-[LoadInfoServiceReport] DBUser = IFSPRINT ,DBPassword : ******* ,DBServerName : IFSPDB ,AppOwner : IFSAPP
08/02/2024 12:36:44[IFS]-[LoadInfoServiceReport] Setting up logon information for each database object.
08/02/2024 12:36:44[IFS]-[SetTableLocation] Set appropriate post-fixes for PURCHASE_ORDER_PRINT_REP_A
08/02/2024 12:36:44[IFS]-[SetDatabaseLocation] Generating fully qualified database object name for PURCHASE_ORDER_PRINT_REP_A
08/02/2024 12:36:44[IFS]-ERROR in [LoadInfoServiceReport] Error in loading infoServices report.
08/02/2024 12:36:44[IFS]-Error in File 805f8180-6d4f-4230-838a-204dc7934067 5740_6964_{D9BCD169-DF7D-4FF3-9123-DE52EC350D94}.rpt:
Unable to connect: incorrect log on parameters.
Details:  [Database Vendor Code: 1005 ]   at CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.SetTableLocation(ISCRTable CurTable, ISCRTable NewTable)
   at CrystalDecisions.CrystalReports.Engine.Table.set_Location(String value)
   at Ifs_ReportService.SetDatabaseLocation(String databaseLocation, Table table) in c:\inetpub\wwwroot\IFS\App_Code\Service.cs:line 1756
   at Ifs_ReportService.SetTableLocation(Table crTable, String UserId, String AppOwner, String IALOwner) in c:\inetpub\wwwroot\IFS\App_Code\Service.cs:line 1728
   at Ifs_ReportService.LoadInfoServiceReport(String path, String DBUser, String DBPassword, String DBServerName, String AppOwner) in c:\inetpub\wwwroot\IFS\App_Code\Service.cs:line 1551

 

Thanks

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings