Support forum

Oracle error ORA-03113 indicates that the connection to the database closed unexpectedly. However, it is a very generic error message from the OLEDB driver and it can also be caused by other seemingly unrelated issues with the OLEDB driver or the database.

In your situation, it looks like it that the database transaction completes successfully but that the OLEDB driver does not get a confirmation (in time) that the transaction is finished. After a timeout, Diafaan SMS Server gets an error from the OLEDB driver and tries to roll back the database transaction, but that triggers an error as well.

The first thing you can try is to add ';Connection Lifetime=180;Connection Timeout=60' to the OLEDB connection string, this increases the timeout value and that could solve the problem.

It is also possible that there is a problem with the OLEDB driver, installing a new version of the OLEDB driver, or using an ODBC driver for the Oracle database instead, can also make a difference.

The problem could also be caused by an unreliable internet connection to the database, but if that is the case it will be very hard to solve.

Normally, I would expect that this error causes lost messages. But if that is not the case than you can also choose to ignore the error messages in the event log.

Regards, Henk

Hello Budiharto,

This error indicates that something goes wrong with a database transaction to the the Oracle database. And when Diafaan SMS Server tries to invalidate and roll back the transaction, the roll back fails as well. There should be an additional error in the event log that shows the root cause of the issue.

I would like to see the configuration file of Diafaan SMS Server (menu options 'File-Export-Configuration') and the event log (menu options 'File-Export-Event log').

You can send these files to email address dms@diafaan.com.

Regards, Henk