After cloning a Live environment into Test and upgrading its Oracle database, for example from 12c to 19c, every Crystal Report fails with 'No PDF report returned from Crystal Web Service,' even though system parameters correctly point at the new Test environment, IFSPRINT's permissions are confirmed correct, and opening the same report directly in Crystal Reports Designer connects and runs fine. The Crystal Web Service log shows a database error with Vendor Code 12154 ('failed to open the connection').

All FAQ questions / Developer Studio, deployment, and upgrades

Answer

Vendor Code 12154 specifically indicates a TNS/service-name resolution failure at the Oracle client level on the Crystal Web Service server — after an Oracle version upgrade, especially one that introduces or changes a pluggable-database (PDB) architecture, check the tnsnames.ora file used by the Crystal Web Service server for a missing or incorrect entry for the new database's actual PDB service name. Adding or correcting that PDB entry in tnsnames.ora on the Crystal Web Service server resolves this specific connection failure, even when every other configuration, like system parameters and IFSPRINT permissions, is already correct.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Developer Studio, deployment, and upgrades questions