Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_TopicIcon
Rollback Exception Type: System.InvalidOperationException
sp_NewPost Add Reply sp_NewTopic Add Topic
November 23, 2020
2:57 am
Budiharto
Guest
Guests

This quite strange as we have 2 diaffan SMS server running and both writing into the same DB but different table (as Primary & Backup).
The Primary SMS server did not have such errors and this error were just occurred recently.

I will try to add the parameter below and monitor
';Connection Lifetime=180;Connection Timeout=60'

November 20, 2020
3:09 pm
Henk Helmantel
Admin
Forum Posts: 1259
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

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

November 20, 2020
11:01 am
Budiharto
Guest
Guests

Hi Henk,

Noted, will send the file. I notice we always get this event before Rollback Exception:

ORA-03113: end-of-file on communication channel
Process ID: 32759
Session ID: 734 Serial number: 24361
ORA-03113: end-of-file on communication channel
Process ID: 32759
Session ID: 734 Serial number: 24361, database transaction rollback initiated

November 20, 2020
9:58 am
Henk Helmantel
Admin
Forum Posts: 1259
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

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

November 20, 2020
7:13 am
Budiharto
Guest
Guests

Hi Support,

I keep getting the following error, although all the functionality seems normal/unafceted.

Rollback Exception Type: System.InvalidOperationException, This OleDbTransaction has completed; it is no longer usable.

What could be the issue?
Ver: 4.2.0.2
DB: Oracle/OleDB on Win 2008R2

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
3 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 594

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 990

Posts: 3399

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1259