on 03-04-2008 5:13 AM
Hi all,
Am getting the error at the receiver JDBC CC. I have checked the conceren mapping also . i t is working under test tab.
Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SAP_STG_AP_SAP_REF' (structure 'Statement'): com.sybase.jdbc3.jdbc.SybSQLException: Attempt to insert duplicate key row in object 'SAP_STG_AP_SAP_REF' with unique index 'SAP_STG_AP_SAP_REF_IX1'
Any sugestion?
Thanks,
kanan
ya issue is while updating the jdbc table ..duplicate entries are coming...I have check the maping xml also with the same data..I think I need to change the mapping -to remove the duplicate (entry in that field) using some function. Any idea which will be the function?? + please let me know how to find out which field is the error refering to in the jdbc table-- with unique index 'SAP_STG_AP_SAP_REF_IX1'
In my scenario Action is INSERT. At the mapping output, there are some entries (5-6 ACCESS) where all the fields under the ACCESS are similar
kanan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Kannan,
If you are not sure whether the call must be update or insert then use INSERT_UPDATE as Action.
raj.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The following may be the cause for the Error
1) Check whether you are trying to insert the Duplicate values
2) Make sure that you maintained the same field names in the data type creation with respect to the Database table fields( Case sensitive)
3) make sure that these also in upper case
Action=INSERT, Statement=table name
Regards
Seshagiri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
1) Check if you are inserting duplicate values for the Primary keys in the table
2) All the fields that you mention for the Receiver JDBC should be mentioned in CAPS in the Message type for the JDBC Receiver.
Hope this Helps.
Regards.
Jeet,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.