Error in CIF Manager - An SQL error occurred when executing Native SQL.

[Former Member]

Hi

In SCM Queue manager we have couple of records with error message : An SQL error occurred when executing Native SQL.

It does not get processed manually.

Could someone share any inputs or solution on the same

Thanks

Aswath.

[tibor_nagy]

Dear Aswath,

Please check if you have installed the latest LiveCache -Patch on LiveCache Server.

Because this error can have several reasons so one would need more informations. Have you checked in st22 if you have any dump there parallel for this queue error?

Regards,

Tibor

[Former Member]

Hi,

I dont have acess to check the live cache patch level.

Meantime i tired to run a Consistency check for th2at material and i got Error code 381 for stocks and 236 for sales order.

Thanks

Aswath.

[Former Member]

Hi Aswath ram,

Can you eloborate, which queues are getting the problem. Are you getting for all the transaction?

Are they are for specific material or for all the materials?

Have you checked ST22.

Regards,

Kishore K reddy