ROW-00060: Internal error: [dainsert,16]
I posted the below question yesterday to the following Microsoft forum and was directed to this Oracle forum. The responder to my post believes it has something to do with the Oracle driver I am using.
http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/99fc215c-5976-4d95-b474-a7400ddf2a30
I am encountering the following error trace when I attempt to insert 617K records into Oracle via a (SQL Server) linked server connection. At this time I know that I can insert up to 88K records. Is there a setting in SQL Server 2005 that I need to set to allow the insert to complete? I've googled for this error to no avail. I believe it is a buffer issue. I could program a solution (developement s/w VFP) and insert blocks of records, but I would perfer finding a solution through the SQL server before coding a workaround. Any help or advice is appreciated.
Regards,
Joe
05/26/2009 16:12:21 -- INSERT INTO OPSDB..IBMSPMA.PMA_TPHASE_T ( BATCHNO, BURDEN, CAWPID, CECODE, CLASS, DF_DATE, DIRECT, FRBENEFIT, FRPAIDLV, FRVAC, FTE, GENLBURD, HOURS, LBURDEN, MPS, PROGRAM, STATUS, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY )SELECT BATCHNO, BURDEN, CAWPID, CECODE, CLASS, DF_DATE, DIRECT, FRBENEFIT, FRPAIDLV, FRVAC, FTE, GENLBURD, HOURS, LBURDEN, MPS, PROGRAM, 'S', GETDATE(), 'ANNELI', GETDATE(), 'ANNELI' FROM TPHASE WHERE PROGRAM = '403423'
05/26/2009 16:12:21 -- [1,1] 1526
05/26/2009 16:12:21 -- [1,2] Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider "OraOLEDB.Oracle" for linked server "OPSDB" returned message "ROW-00060: Internal error: [dainsert,16]".
05/26/2009 16:12:21 -- [1,3] [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider "OraOLEDB.Oracle" for linked server "OPSDB" returned message "ROW-00060: Internal error: [dainsert,16]".
05/26/2009 16:12:21 -- [1,4] 01000
05/26/2009 16:12:21 -- [1,5] 7412
05/26/2009 16:12:21 -- [1,6] 1
05/26/2009 16:12:21 -- [1,7]
05/26/2009 16:12:21 -- [2,1] 1526
05/26/2009 16:12:21 -- [2,2] Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider "OraOLEDB.Oracle" for linked server "OPSDB" returned message "ROW-00060: Internal error: [dainsert,16]".
05/26/2009 16:12:21 -- [2,3] [Microsoft][ODBC SQL Server Driver][SQL Server]The OLE DB provider "OraOLEDB.Oracle" for linked server "OPSDB" could not INSERT INTO table "[OPSDB]..[IBMSPMA].[PMA_TPHASE_T]".
05/26/2009 16:12:21 -- [2,4] 37000
05/26/2009 16:12:21 -- [2,5] 7343
05/26/2009 16:12:21 -- [2,6] 1
05/26/2009 16:12:21 -- [2,7]