Question

12
Replies
451
Views
Close popover
Indu Shekhar (sheki1)
PEGA
Senior Solutions Engineer
Pegasystems Inc.
IN
sheki1 Member since 2014 1 post
PEGA
Posted: February 17, 2016
Last activity: May 9, 2016
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.