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

 Durgarao Jeeri (DurgaraoJ3422)
Coforge DPA

Coforge DPA
GB
DurgaraoJ3422 Member since 2021 2 posts
Coforge DPA
Posted: Aug 11, 2021
Last activity: Aug 12, 2021
Posted: 11 Aug 2021 18:16 EDT
Last activity: 12 Aug 2021 10:57 EDT
Closed

Delete by keys operation for Dataset in fact table is not working properly

I have written an activity where DataSet-Execute method is used to delete the fact table record by pxFactID.

The SQL is forming incorrectly during run time.

example: I'm passing the value -1460889404930039992 and it is converting to -1962713272. I have seen this in the tracer from the below lines:

 SQL      DELETE FROM ihstore.PR_DATA_IH_FACT "UD" WHERE ( ( pxfactid = ? ) )   SQL Inserts       <-1962713272>

with this, the deletion is not happening.

Can some one please help me with this, why it is behaving this way?

 

Pega version: 7.2.2

***Edited by Moderator Marissa to update Platform Capability tags****
To see attachments, please log in.
Pega Platform 7.2.2
Data Integration

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