Skip to main content

This is about APP8 Crystal installation in Windows Server 2012 R2.

 

We installed Crystal 32 bit and Oracle client 11.2 - 32bit
Then installed Adobe Acrobat reader 32 bit.

Followed the guideline from https://docs.ifs.com/techdocs/ for page
Foundation1 / Installation Guide / Installation Options / Operational Reporting / Configure Crystal Web Service / Setup Cws / This page

IIS and .NET are installed according to the guideline.
VM restarted.


When trying to preview reports, we are getting errors.
Please look at attached error log files.

And also error from Crystal log attached.

Please suggest what needs to be done to overcome issues?

Can you share script FndSession.sql, which I cannot find?

Thanks.

Error logs attached

Managed Server log attached

 

We cannot preview IFS reports also with error 

ifs.fnd.base.SystemException: Failed Reading PDF/A configuration file

Hi @CovMayurJ,

In the Crystal Web Service log file you have attached, I can see the following error:

15/11/2022 11:29:044IFSCRWebServiceIFSL]-Failed to load database information.
Error in File SalesQuotation-Parts {1653B969-BDA2-4C70-AB44-D1B791F2FCA0}.rpt:
Failed to load database information.

This is because there is a problem with the database connection in Crystal Web Service setup. 

Please check the following:

  • Bit version of the Oracle client installed on the CWS host should match the bit version of the database. 
  • You should select the matching CWS installation zip file from the Application Server as well to match the database and Oracle client bit version above. 
  • Make sure the tnsnames.ora file is correctly updated with the TNS of the database after the installation of the Oracle Client.
  • Also make sure that that the following line is commented out in \\<ORACLE_HOME>\network\admin\sqlnet.ora file.
    # SQLNET.AUTHENTICATION_SERVICES= (NTS) 
  • Open a command line in the CWS host machine and do a tnsping for the Oracle TNS to make sure the TNS is accessible from the CWS  host machine.
    Eg: tnsping <TNS_NAME>
  • Check whether the TNS specified in the ifs-crystal-config.xml  file is correct. This can be found inside the CWS installation folder. 

Hope this helps!

Reply


Terms & ConditionsCookie settings