Support Article
Generate DDL errors during upgrade
SA-5607
Summary
The application was upgraded from PRPC 6.3 SP1 to Pega 7.1.7. An error occurred when attempting to generate the DDL using the generateDDL script.
Error Messages
[java] Error generating ddl for oracledate, pega3_owner
[java] NL Exception was generated
[java] Caused by: oracle.net.ns.NetException: NL Exception was generated
Steps to Reproduce
Run the generateDDL command-line script.
Root Cause
A configuration issue in the operating environment:
The JDBC URL was:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST= host.name)(PORT=12345))(CONNECT_DATA=(SERVICE_NAME=PEGA)))
This has an additional space in the Parameter "Host= "
Resolution
Perform the following local-change:
Remove the additional space in the JDBC URL. It should read (HOST=host.name) according to the syntax.
Published December 8, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.