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