dm_audittrail object is not fetched by DFC

Marwen Naceur · 2023-04-24T15:20:46+00:00

There was an error rendering this rich post.

Having this code in java dfc :

audittrail = (IDfAuditTrail) sess.getObject(vCollection.getId("r_object_id"));

i managed to catch this error with the following error message :

[DM_API_E_EXIST]error: "Document/object specified by 5f0203421cd60e3d does not exist."
Although the exact code work in another environment which is supposed to be a duplicate.

Any idea on how to solve this ?

Find more posts tagged with

Documentum

Comments

Hicham Bahi

Are you running this code as superuser ? If not it may be due to permissions issues.

Marwen Naceur

https://forums.opentext.com/forums/developer/discussion/comment/966180#Comment_966180

Hello, Thank you for the interaction,

Yes i am running this a superuser

Hicham Bahi

OK. What do you mean by "which is supposed to be a duplicate" ? Did you clone/copy your repository ? If so, how ?

Marwen Naceur

https://forums.opentext.com/forums/developer/discussion/comment/966186#Comment_966186

I mean it is a very similair environment, my code works fine so it must smth missing from content server side.

Bozon

https://forums.opentext.com/forums/developer/discussion/comment/966188#Comment_966188

You need to check if the user has the extended privilege "View audit" or higher. Even if it is a superuser those privileges are not granted by default. In order to be able to grant them you need to connect with another superuser that has them granted. The repository owner is the account you will need for that. Install owner (dmadmin) does not have the extended privileges granted by default.

Marwen Naceur

I found the reason actually and it is a common one : the reason is that the R_OBJECT_SEQUENCE for dm_audittrail passed the limit value of 2^31-1.

Bozon

https://forums.opentext.com/forums/developer/discussion/comment/966228#Comment_966228

That's a huge auditrail database!

Hicham Bahi

https://forums.opentext.com/forums/developer/discussion/comment/966227#Comment_966227

That's not quite true: a user with superuser privileges can view all audit trail entries without requiring "VIEW AUDIT" privilege. A non-superuser without "VIEW AUDIT" can see audit records related to sysobjects which he owns or for which he has at least BROWSE permission.

Hicham Bahi

https://forums.opentext.com/forums/developer/discussion/comment/966228#Comment_966228

That's strange. Which Documentum Server version are you using ? Since Documentum 4 (if I'm not mistaken), Documentum IDs are not limited to hexadecimal as they were before. So If the last 8 digits of r_object_id reach FFFFFFFF, the next ID will be G0000000 and it will continue until ZZZZZZZZ. So the maximum number of documents or audit trail objects which you can have is not 16^8 (or 2^32) but 26^8 which amounts to more than 200 billion objects (for a given type tag, e.g. 08, 09 or 5f), if my math is correct.

Hicham Bahi

My math was wrong! The correct number should be 36^8, so 2'821'109'907'456, so about 2'821 billion.

Marwen Naceur

https://forums.opentext.com/forums/developer/discussion/comment/966240#Comment_966240

I am not speaking about r_object_id i am speaking about the R_OBJECT_SEQUENCE you can find this in the dm_audittrail object for example and is limited ( you can still get data via a dql query but without fetching or dfc