Question

2
Replies
359
Views
ABHISEKSAU Member since 2012 5 posts
EY
Posted: 3 years ago
Last activity: 3 years 1 month ago
Closed

Obj-Save method setting null values

Hi,

Obj-Save method setting null values for unmapped columns. I'm using Pega 7.2.2. I've set DASS as below and restarted server but still not reflecting.

prconfig/database/databases/pegadata/skipUnmappedColumns/default as true.

Thanks in advance.

***Updated by moderator: Lochan to add Categories***

Data Integration
Close popover
Moderation Team has archived post
Posted: 3 years ago

Hi,


As per the solution provided by PEGA, you have to perform the below changes:


ou can specify 'skipUnmappedColumns' using prconfig.xml and DASS.

Unmapped columns will be ignored in DML for external tables.

The default value is 'false'.


  1. Change the setting to 'true' as shown below, replacing the database name with the database name that you have used to connect to the external database.

prconfig xml:

<env name="database/databases/${DBName}/skipUnmappedColumns" value="true" />

. restart Application Server


DASS with default classification

RuleSet: Pega-Engine

Name: prconfig/database/databases/${DBName}/skipUnmappedColumns/default

Value: true

. restart Application Server


DASS

RuleSet: Pega-Engine

Name: database/databases/${DBName}/skipUnmappedColumns

Value: true

. re-save Data-Admin-DB-Name. Need to re-save the Data-Admin-DB-Name in case of Application Server restart.


​2. Restart the server.


3. Test the Obj-Save method.

Posted: 3 years ago

Hi,


If you have already tried the above setting and its still not working, I think it is worth checking if you have a BOLB column (pzpvstream) for the unmapped columns to be saved to.
Share this page LinkedIn
Copied!