Transactionscope ? - "Unable to get error message (6107) {0}"

L

L. Scott M.

Oracle 9i
Windows 2000 SP4
Visual Studio 2005
NET Framework 2.0 Configuration (version 2.0.50727.42)

We are getting:

"Unable to get error message (6107)
System.Runtime.InteropServices.ExternalException
{System.Data.OracleClient.OracleException}"

- after processing around 10000 +- 500 out of 39000 text inserts to
an Oracle database when we looped through the records using a Table
Adapter insert method. When we used the the insert method with a
datatable we recieve an Oracle message that it rolled back,
"ORA-24761: transaction rolled back" which does not help with our
diagnosis. No errors thrown by Oracle that show up in its logs.

Unfortunatly this is actual users data being imported from a file,
which means that the user could provide such a document again.

Thanks for the consideration,
Scott M.
 
L

L. Scott M.

Oracle 9i
Windows 2000 SP4
Visual Studio 2005
NET Framework 2.0 Configuration (version 2.0.50727.42)

We are getting:

"Unable to get error message (6107)
System.Runtime.InteropServices.ExternalException
{System.Data.OracleClient.OracleException}"

- after processing around 10000 +- 500 out of 39000 text inserts to
an Oracle database when we looped through the records using a Table
Adapter insert method. When we used the the insert method with a
datatable we recieve an Oracle message that it rolled back,
"ORA-24761: transaction rolled back" which does not help with our
diagnosis. No errors thrown by Oracle that show up in its logs.

Unfortunatly this is actual users data being imported from a file,
which means that the user could provide such a document again.

Thanks for the consideration,
Scott M.

Apparently from a couple of e-mails we are not alone with this issue.
In our case we trap the error that does occur and inform the user to
reduce the size of the data in the file being loaded, not the best
solution but for us it was an extreme test as the Excel files should
not be that size.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top