All Forums Database
cnaveen05 6 posts Joined 12/12
04 Apr 2014
Teradta Error 6908

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.

Raja_KT 1246 posts Joined 07/09
04 Apr 2014

Is it for the same one table? Maybe you can stuff your inserts/updates if for the same table in BT/ET
BT---Begin transaction  ET---End transaction

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.

cnaveen05 6 posts Joined 12/12
04 Apr 2014

are you saying that we add BT/ET for every single DML operation or just at the  begining and end of the entire process?

Raja_KT 1246 posts Joined 07/09
04 Apr 2014

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.

ToddAWalter 316 posts Joined 10/11
04 Apr 2014

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.

Adeel Chaudhry 773 posts Joined 04/08
08 Apr 2014

Are the statements generated at run-time or are hard-coded? Is ';' used at the end of each statement? Are the requests being sent to DB concatenated?

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.