Support Article
Cannot execute generated SQL code
SA-92856
Summary
After creating the application, unable to import it to another environment. DB2 is the database vendor.
Error Messages
On the database side:
DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601
Steps to Reproduce
- Import the test-import.zip product.
- Execute the SQL
Root Cause
A defect in Pegasystems’ code or rules.
The Pega generated SQL syntax was incorrect.
Resolution
This feature is implemented in Pega Platform 8.1.8.
Published April 10, 2020 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.