11-07-23 12:30 PM
We use Common - OLEDB - ExecuteQuery, with an update query. This causes , memory error, specifically, a C0000005 error is an access violation error caused by a buffer overrun. What could be the solution to this ? Is there any alternative to this ?
11-07-23 01:46 PM
Hi Gnana,
If you could describe what you're trying to do, then we can have a look at either improving it or finding an alternative.
------------------------------
Happy coding!
---------------
Paul
Sweden
By all means, do not mark this as the 'Best answer'!
------------------------------
12-07-23 11:53 AM
Hi Paul,
The process reads data from an Excel file, it runs a query to exclude some of this data from the main update to the database. This is what we do. Since the no. of records have exceeded 5000 with 20 fields per row, this error occurred.
Thanks
GG
------------------------------
Developer
BNP
------------------------------
12-07-23 12:29 PM
Hi G,
5k rows is not much, not even for 20 columns. OLEDB should be able to handle this without any problems.
12-07-23 02:16 PM
Hi Paul, The sql query is this
"UPDATE [Sheet1$] SET [Sheet1$].[IGNORE] = 'T' WHERE [Sheet1$].[AGREEMENT ID] = '" & [Agreements To Exclude Collection.AGREEMENT ID] & "'".
We hve not checked with the few rows.
13-07-23 08:18 AM
Hi Gracy,
I don't think you'll be needing to repeat the [Sheet1$] on each part of the SQL. So I reckon the following should do:"UPDATE [Sheet1$] SET [IGNORE] = 'T' WHERE [AGREEMENT ID] = '" & [Agreements To Exclude Collection.AGREEMENT ID] & "'".
On the other hand it seems the use of ' and " in the SQL do not really add up. You may have a look at that.
18-07-23 02:53 PM
Hi Paul, We are still stuck up with the above query and get the error. Is there anything else you feel not quite right here ?
Internal : Could not execute code stage because exception thrown by code stage: No value given for one or more required parameters.
Thanks,
GG
18-07-23 02:55 PM
The quotes seems to be right, the expression evaluates to
UPDATE [Sheet1$] SET [IGNORE] = 'T' WHERE [AGREEMENT ID] = '709392' (Text)
19-07-23 11:47 AM
Hi Paul,
Any updates on this please ?
-GG
19-07-23 12:15 PM
Hi
I gave try from my end with same query , it is working with only modification done is removed single quote for number
UPDATE [Sheet1$] SET [IGNORE] = 'T' WHERE [AGREEMENT ID] = 709392
Created dummy data with same column names
Regards