on 09-18-2015 2:53 PM
Hi All,
I am receiving the below error when updating control parameter table using the method: i_eai-eh_model->update_control_params.
ERROR: Open SQL array insert produces duplicate records in the database. (termination: RABAX_STATE)
Upon debugging the standard program, the SEQ number is not being updated therefore leading to this error. Can anyone suggest of other standard methods to use?
Regards,
Melvin
Hi Melvin,
Is this happening on Control parameters update?
I think this should happen when sequence number mismatch sequence no between /SAPTRX/EH_HDR and /SAPTRX/EH_STHST.
Check this discussion.
Runtime Error : DBSQL_DUPLICATE_KEY_ERROR | SCN
Can you tell us how your are updating control parameter like custom activity or method or using standard activity or method in ruleset.
Regards
GGOPII
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Melvin,
From where are you calling this method? Ruleset with custom activity? If from ruleset, use the activity PARAMETER_CHANGE_NEW.
Also, are you building sequence numbers explicitly?
Let me know how you build your parameters and from where and how are you trying to updating the parameters.
Thanks,
Vishnu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.