Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Error while importing PDFSServicePack.jar due to "::text" in DDL

SA-20086

Summary



User is trying to install Pega Marketing for Financial Services 7.13 on Pega 7.1.9 and while importing the PDFSServicePack.jar file, user is getting the ORA-00920 error.

Error Messages



Database-General Problem executing SQL to update database schema 920 42000 ORA-00920: invalid relational operator


Steps to Reproduce



1. Run the Import wizard. 
2. Install PDFSServicePack.jar file.


Root Cause



When the view is exported from Postgres it appends ::text option. When trying to import the same in Oracle, system throws exception where ::text was not getting replaced. 


Resolution



Perform the following local-change steps:

1) Import PDFSServicePack.jar through Import Wizard. 
2) While Importing, one can see "Schema" screen with two options "Automatic" and "Manual".
3) Select "Manual" option. Click "View/Download SQL DDL" button to download the DDL. 
4) Open the DDL in text file and remove '::text' which one can find in four places. 
     Ex: ((((pbx.productinstanceid)::text = (pdi.productinstanceid)::text) AND ((pdi.prodinstancestatus)::text <> 'Open-Activated'::text)))) 
5) Apply the edited DDL manually. 
6) Now continue the import wizard till finish.

Suggest Edit

Published March 3, 2016 - Updated December 2, 2021

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us