0

I am trying to add an index to a document class' field, but - after some minutes - I receive the error TransactionRolledBackException.

enter image description here

I suspect that's because this class already has thousands of created objects. In fact, whenever I try to create a index for a new class, I do not receive this error. I also suspected that it was just a timeout for FEM, while the index creation proceeds in the background, but this is not true, because I tried this creation 4 days ago, with no results. Closing and reopening the FEM, the parameter always shows the missing index:

enter image description here

Is there some parameter to set in order to avoid the timeout, or is it possible to create an index directly on the DB2?

Andrea
  • 6,032
  • 2
  • 28
  • 55
  • This error doesn't seem to be from Db2, but kind of application timeout (or firewall). Do you have any Db2 driver related error? – adamitj Sep 14 '20 at 16:58
  • @adamitj: thanks for your reply, exactly, this is a message from FEM, the administrative tool of FileNet. I suspect there is a timeout for index creation on DB2. So, technically, this is not a error directly reported from DB2, but related to an operation towards it.. – Andrea Sep 19 '20 at 19:36
  • If it is related to Db2, probably FEM is hiding the real error message. Please ask to your DBA to check db2diag.log messages. If there is some sort of timeout or transaction log overflow, there you'll find the error message and a code, like SQL0911N (or -911) that will give you directions to to the fix. – adamitj Sep 21 '20 at 14:13

0 Answers0