Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Samuel Dondapati (SamuelJD)
Accenture

Accenture
US
SamuelJD Member since 2012 4 posts
Accenture
Posted: Apr 2, 2017
Last activity: Apr 3, 2017
Posted: 2 Apr 2017 2:32 EDT
Last activity: 3 Apr 2017 5:37 EDT
Closed

Updating a bix extract rule with a new property and the target DB does not have a column added for this new property yet

Hi ,

We have an extract rule which was running fine till now. I have added a new property to be extracted, however target DB does not have the column added for this new property yet. When this extract is executed, completion is always 0% and status says " Not all rows extracted."

I think until the target DB does not get the column added, extract execution wont work properly. PRPC version we are using is 7.1.7.

Please let me know your thoughts and suggestions on this.

***Moderator Edit: Vidyaranjan | Updated Categories***

To see attachments, please log in.
Data Integration

Posted: 7 years ago
Posted: 2 Apr 2017 4:04 EDT
Neha Mittal (NehaM498)
J.P. Morgan Services India PVT Ltd
Software Engineer III
J.P. Morgan Services India PVT Ltd
IN

HI,

As you may be aware that  BIX executes INSERT statements to write this data to the target database.  

Here, Yes the target DB should also have that new property column. it is unable to find the required column in the target DB, thus, failing to insert the value and throwing the error. 

Thanks

To see attachments, please log in.

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

Pega Collaboration Center 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