At a time how many rows we can update using Documentum update DQL query?

Question

While updating more rows i.e 1,00,000 rows at a time in Documentum table , That time i am getting below error.

Error :

[DM_SESSION_E_NON_EXIST_OBJ]error: "The object identified by SET_PUSH_OBJECT_STATUS does not exist."; ERRORCODE: 100; NEXT: null

At a time how many rows we can update using Documentum update DQL query ?

Answer 1

AFAIK the underlying database will set the limits. If you run the query in DA or eg. FME dqMan you are able to see the generated SQL that are run. If you run into problems it might be due to inconsistencies in the repository- in that case you might want to run the Consistency Checker job to ensure your repo is in good shape before doing large updates.

Answer 2

Your error is caused by incorrect implementation in DFC, which limits the maximum length of DQL queries to ~63800 bytes