August 26, 2010 at 8:56 am
Hi everyone,
I am loading data from sql server into oracle using linked server and getting these error:
OLE DB provider "OraOLEDB.Oracle" for linked server "SERVERNAME" returned message "ROW-00060: Internal error: [dainsert,16]4".
I have searched many forums but didn't get exact solution even sql server central says if the length of the oracle table columns is less than the sql server table we will get this error ,i saw the definition of the oracle table it has more length specified than the sql server table..........
Onething i am not getting is we are testing this in dev instance which is not refreshed from monday and i tested it on tuesday inserting 124,000 rows into Oracle it worked ,but when i tried to do same thing with same number of rows yesterday and today i am getting this error ..
and i am sure it is the same data,but unable to do it because of the error i got.
August 31, 2010 at 1:21 pm
I was unable to find what exactly the error means ,but i no longer get the error .
As i told that i was working in Development server and there is no change in data when it ran good before and now ,so i had to reboot the server and everything worked fine.our development server has so much load and i was thinking the memory is not sufficient to transfer the load to oracle.and now i am testing everything in Test server by scheduling the job which works fine now...
I will update this topic when i exactly find what the error means...........
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply