We have an external .net application feeding data to our DWH system. While doing inserts/updates with more than 1 record sometimes we are getting the below error :-
6908 Iterated request: Multi-statement requests not supported.
Under what circumstances will the error occur, and why is it that sometimes the inserts run fine and other times they do not? Is there any parameter within the database which we can alter to prevent this error? Any options/suggestions on how to resolve the same are welcome.
I don't know what is there beginning and end of the entire process. I have not seen your code code.
I m suggesting that maybe you can try stuffing your INSERTS/UPDATES if for the same table in BT/ET.
Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.
It appears that parameter arrays are in use. It is not allowed to send a multi-statement request when parameter array is used - that is what this error is saying. The code will need to be reviewed to see how the two are being combined.
We have an external .net application feeding data to our DWH system. While doing inserts/updates with more than 1 record sometimes we are getting the below error :-
6908 Iterated request: Multi-statement requests not supported.
Under what circumstances will the error occur, and why is it that sometimes the inserts run fine and other times they do not? Is there any parameter within the database which we can alter to prevent this error?
Any options/suggestions on how to resolve the same are welcome.