on 07-06-2010 5:19 AM
Dear All,
I am working on JDBC Receiver adapter Scenario.
I am getting the error in RWB
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. '' (structure 'Statement'): com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'WHERE'.
Please suggest
Best Regards
Hi Manish,
The problem is your query/stored procedure.
If you are working in Stored procedure, try to execute in Database itself.
If you are using query
Send your query what you wrote.
Thank you so much.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Satish,
I got the where statement problem solved but still I am getting the error
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. 'Z_SAP_ProjectBW_Temp' (structure 'Statement'): com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert the value NULL into column 'SAP_ProjectID', table 'BPV.dbo.Z_SAP_ProjectBW_Temp'; column does not allow nulls. INSERT fails.
In my table SAP_ProjectID is the primary key.
Best Regards
Hi Manish,
the another error comes from field called "'SAP_ProjectID' this filed it doesn't allows the null values.
Because Database side this field have set it for "not null". So we can't able to send the null value to this filed.
Either you change the database side or you can send the value to field allways.
Thank you very much.
Sateeesh
Hi Saatesh,
I have created the one table with allowing null then I am able insert the data into the table.
But In my case I have primary key in table where we cannot allow null there.
Can you please suggets me how to use INSERT statement in mapping so that I can insert data with primary key.
I took the ref from help
http://help.sap.com/saphelp_sm40/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
which says we can not use key element with INSERT Statement
Best Regards
Edited by: Manish22 on Jul 7, 2010 11:25 AM
which says we can not use key element with INSERT Statement 😞
Why would an INSERT statement need a key? key is used when you want to have condition (like for UPDATE/ DELETE).....howevere for INSERT we dont create a statement with condition for INSERT....just understand what is the need of key and what does an INSERT do.....that will answer your question on how to use a key in INSERT
Regards,
Abhishek.
Please make sure that your target structure should be in the format given below in the weblink.
http://help.sap.com/saphelp_srm40/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
I hope this helps you to fix...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Incorrect syntax near the keyword 'WHERE'.
Check how you have written the statement for where....check if you have included any unwanted syntax/ symbol/ character.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check your Target structure... your structure should be as mentioned in the below link..
http://help.sap.com/saphelp_srm40/helpdata/ru/2e/96fd3f2d14e869e10000000a155106/content.htm
Regards
Ramg
Hi,
The statement or Procedure what you have written is not valid , check your statement once,this is the issue.
Regards,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.