Share
Report
260Hi,
I am updating CUSTNAME,CNTCPRSN,PHONE1,SLPRSNID,USERDEF1,USERDEF2 in RM00101. I am getting the below given two error's :
1) Error 1 : Sql
procedure error codes returned: Error Number = 5518 Stored Procedure taUpdateCreateCustomerRcd Error Description = The Primary Address Code is required when other address information is filled in Node Identifier Parameters:
2) Error 2 : Violation of PRIMARY KEY constraint 'PKRM00103'. Cannot insert duplicate key in object 'dbo.RM00103'. The statement has been terminated. i believe RM00103 is the Customer Master Summary table. tried looking whether there is any trigger which is fired while updating in RM00101 and its trying to insert a duplicate Primary key in RM00103 but was unable to find.
I had posted earlier on this but was able to find solution for these errors.
taUpdateCreateCustomerRcd. I am not updating ADRSCODE still its giving me this error. And if i am passing the ADRSCODE then i am getting the Error 2, but as per my requirement i dont want to pass ADRSCODE through the Econnect Service. The Storeed Procedure taUpdateCreateCustomerRcd is encrypted but i am not sure why its throwing the error. I tried looking in the SQL Server Profiler and EventViewer too, but was unable to figure out.Also tried to look into another master table RM00102 which i believe is the Customer Master Address File which has the ADRSCODE but while analyzing i found there some records were updated WITH ADRSCODE as Primary but some failed for the same ADRSCODE. Is there any way by which i can debug the Stored Procedure taUpdateCreateCustomerRcd.
*This post is locked for comments
All responses (
Answers (
