topic Re: Error updating database - ORA-03120 in Alfresco Archive

Error updating database - ORA-03120

mmaker1234 — Tue, 17 Sep 2013 07:28:29 GMT

Hello Activiti developers,We are using Activiti 5.13 on Oracle 11g database. Yesterday we observed the following error on one of our production systems:### Error updating database. Cause: java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow### The error may involve org.ac

Re: Error updating database - ORA-03120

jbarrez — Thu, 26 Sep 2013 13:53:14 GMT

Seems to be an Oracle internal error, right: http://www.dba-oracle.com/t_ora_03120_two_task_conversion_routine_integer_overflow.htm

Do you see that error happening multiple times?

Re: Error updating database - ORA-03120

mmaker1234 — Mon, 30 Sep 2013 12:52:28 GMT

Hello Joram,

It seems the error happened only once (at that day). Unfortunately I can not check all the logs (since the beginning of the month for example) as the access to them is restricted.

Re: Error updating database - ORA-03120

jbarrez — Fri, 04 Oct 2013 07:14:55 GMT

Damn dba's

But without much more information I'm afraid I can't say more

Re: Error updating database - ORA-03120

mmaker1234 — Mon, 07 Oct 2013 07:40:12 GMT

I could try to provide the information you need.

Unfortunately, as I already mentioned above, the server is a production one and the only thing we could do is to monitor/query its current state. We can not change its configuration (the logging level for example) as it would require a server restart.

Until now the server run flawlessly with several versions (and upgrades) of Activiti. We also didn't observed the above error since its first occurrence.

Re: Error updating database - ORA-03120

frederikherema1 — Wed, 09 Oct 2013 12:48:09 GMT

I think we can blame this one on random bit switched due to solar flares