Question

12
Replies
449
Views
sheki1 Member since 2014 1 post
PEGA
Posted: 4 years ago
Last activity: 4 years 4 months ago
Closed
Solved

Issue with creating a Product rule in an instance running on Postgres

Hi All,

In our application there is a VIEW created in DB.

When I create a Product rule in an instance running on DB2 it generates XML as shown below, notice the snippet in BOLD

-----------------------------------------------------------------------------------------

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<database catalogName="" databaseName="PegaDATA" schemaName="" type="2">

<view description="View FSP_INACTIVEPRODUCTSINBUNDLES" name="FSP_INACTIVEPRODUCTSINBUNDLES" ruleset="Pega-RULES">

<select>CREATE VIEW pega.FSP_INACTIVEPRODUCTSINBUNDLES AS

SELECT pbx.productbundleid, pbx.productinstanceid, pdi.prodinstancestatus FROM

(pega.fsp_prodbundlexref pbx JOIN pega.fsp_productinstance pdi ON

((((pbx.productinstanceid) = (pdi.productinstanceid)) AND ((pdi.prodinstancestatus) &lt;&gt; 'Open-Activated'))))</select>

</view>

</database>

-----------------------------------------------------------------------------------------

But when I create a Product rule in an instance running on Postgres it generates XML with a slight difference,

-----------------------------------------------------------------------------------------

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<database catalogName="" databaseName="PegaDATA" schemaName="" type="2">

<view description="View FSP_INACTIVEPRODUCTSINBUNDLES" name="FSP_INACTIVEPRODUCTSINBUNDLES" ruleset="Pega-RULES">

<select>CREATE VIEW pega.FSP_INACTIVEPRODUCTSINBUNDLES AS

SELECT pbx.productbundleid, pbx.productinstanceid, pdi.prodinstancestatus FROM

(pega.fsp_prodbundlexref pbx JOIN pega.fsp_productinstance pdi ON

((((pbx.productinstanceid)::text = (pdi.productinstanceid)::text) AND ((pdi.prodinstancestatus)::text &lt;&gt; 'Open-Activated'::text))))</select>

</view>

</database>

-----------------------------------------------------------------------------------------

As we can see that the XML generated by PRPC on Postgres instance is appending ::text

Because of this when we are trying to import this Product rule(with ::text in the XML script) in an instance running on Oracle, the import is failing with error: Invalid relational operator.

Please share your thoughts.

-InduShekhar

Data Integration System Administration
Moderation Team has archived post
Share this page LinkedIn