The name "Internal" is not permitted in this context

[anita_r]

Hi All,

I am doing a Idoc-to-JDBC scenario. when Idoc was pushed, my receiver channel thrown an error like below.

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'AccountMasterEvent' (structure 'statement1'): com.microsoft.sqlserver.jdbc.SQLServerException: The name "Internal" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

Could any body please tell me where the problem is?

Thanks & Regards,

Anitha.

[Former Member]

Hey,

I have the same problem here - how did you solve yours?!?

Thanks

Johanna

[Former Member]

Please can you attach the payload which is sent to the JDBC adapter.

[Former Member]

Hi,

Maybe you can try restarting the JDBC Adapter from Visual Admin. One of our DB scenarios got an error intially, but after we corrected the error, the adapter did not refresh the metadata automatically. Restarting the JDBC adapter did the trick.

Please can you go through this thread

https://forums.sdn.sap.com/thread.jspa?threadID=41297

Please reward points if it helps

Thanks

Vikranth

[GabrielSagaya]

You should use executeUpdate() instead of execureQuery()

http://forum.java.sun.com/thread.jspa?threadID=5289851