July 10, 2008 at 4:53 am
Hi dear friends and It Professionals;
We have an important and urgent problem that we have been trying to solve for a month approximately but no luck We have an SQL Server (APP141TR) and an Oracle Server (trtplfb4) and my colleagues in the factory has made a link from SQL Server to Oracle database. They have no problems selecting or updating Oracle database even inserting into it. But there is only one insert command that does not work when the table grows bigger beyond 37.893.466 records.
INSERT INTO SFDCTEST..KORD.BESLEME_TRAN (BOBIN_NO,BES_BOBIN_NO,BES_SIRA_NO,BES_TIPI,DEGISIM_TIPI,ISLEM_SIRA_NO) VALUES('B000004260','B000004108',1,'N','R',0)
"SQL Server 2005 - Provider ran out of Memory error"
They are inserting into other tables without any problems but this one does not work after the records are increased. I have discussed this case with Microsoft Partners and they suggested that the solution should be searched on the Oracle side. What do you say? Could you assist us please?
July 11, 2008 at 7:53 am
Many possibilities here. Most likely issue is how the provider is handling data. I'd try a different provider. If you are using the MS one, it was built for Oracle 7 and hasn't really been updated. Use the oracle one, or a 3rd party. What are you using?
It may be that the there is some translation being done behind the scenes that is mapping to an incorrect data type. You'd need a trace to be sure, and they can be misleading. It could be the provider is querying something behind the scenes incorrectly, and hitting a limit. SQL is usually pretty good at not doing that.
What are the data types SQL Server sees versus the Oracle Schema def? You might be seeing a crossover of values.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply