Error :ORA-01792

System

Hi,
I am using Teamsite5.5.2 and Datadeploy5.6

If i have more than 1000 records in my table while updating it is giving the ORA-01792 Error. Is there any workaround for this.


Issue: If i have more than 1000 rows in my dcr while inserting it is deploying . While i am updating dcr it is failing by giving the following error ORA-01792


Error:

SQLException occured in TDbSchemaGroupInfoNode
Exception Message: ORA-01795: maximum number of expressions in a list is 1000

Vendor Error Code: 1795
SQL state: 42000


In my table if i have less than 1000 rows it is working fine.

Is there any way to avoid this issue??

I am attaching my datacapture.cfg.log ,datadeployconfig and dcr



Thanx in advance