Error :ORA-01792

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

Find more posts tagged with

Comments

Migrateduser

Here is my datadeployconfig file

Migrateduser

Please file a report with support.

Migrateduser

Thanx for your response i will report about this issue.

I have a question about Delete Data Record and Delete options under File menu.

If some delete a DCR thorugh either of the options above how to handle?

If you have any suggestion about this ?

Is there any way to hide those options and user own customer program for delete ?

Thanx in advance

herald10

we can use triggers to handle those delete DCR and delete events.

Migrateduser

Thanx for your reply on delete event.Could pls . point me to example how to do this or any doc on this

Thanx in advance

Brief Description.docx

herald10

When a file or directory is deleted, DestroyFSE event is triggered. You can catch that event to trigger your script.
please refer to Teamsite Commadline tools documentation to find how to write command triggers and the following KB articles.
https://support.interwoven.com/kb/kb_show_article2.asp?ArticleID=1458
https://support.interwoven.com/kb/kb_show_article2.asp?ArticleID=49618