Multiple-step OLE DB operation during publishing

Question

I am getting this error when publishing to specific targets. I could not find any info in logs.

We are using Oracle DB and SDL Tridion 2011 SP1 version. This error is temporary and recurring.

Error: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

Any help on this would help me a lot.

"I could not find any info in logs." Which logs have you looked at? Did you set the loglevel of the deployer to DEBUG? Does the publish transaction even reach the deployer? — Bjørn van Dommelen, Feb 13 '15 at 9:00
I checked event system logs. Now I am planning to enable Publisher log and set logback.xml to debug mode to see if I can find any more information. Thanks — Patan, Feb 13 '15 at 10:52
Event system is generally unhelpful with Tridion content delivery errors as Tridion content delivery is a java application which uses SLF4J to configure its logging. — Bjørn van Dommelen, Feb 13 '15 at 10:54

Community · Accepted Answer · 2017-05-23 12:37:18Z

What you have is a database error that is not specific to Tridion, but the layers underneath. So do a search for:

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available.

Here are a couple of links suggesting that the error is typically due to a bad connection string:

1 Answer 1