topic SAS AML in Fraud, AML and Security Intelligence https://communities.sas.com/t5/Fraud-AML-and-Security/SAS-AML/m-p/190904#M8 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>I am using SAS AML 6.1 with ECM 2.3. During AGP execution i found one error stating :</P><P>ERROR: CLI execute error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot update identity column 'id'.</P><P></P><P>This is originated from a macro :</P><P>%fcf_get_ecm_sequence_ids</P><P></P><P>whose source is not provided in the package.</P><P></P><P>My research shows that it can be solved by using ignore_read_only_columns = yes</P><P></P><P>But unfortunately that library is assigned in that macro. Is there any way i can resolve the issue?</P></BODY></HTML> Mon, 20 Oct 2014 09:37:16 GMT DinnarHooda 2014-10-20T09:37:16Z SAS AML https://communities.sas.com/t5/Fraud-AML-and-Security/SAS-AML/m-p/190904#M8 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>I am using SAS AML 6.1 with ECM 2.3. During AGP execution i found one error stating :</P><P>ERROR: CLI execute error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot update identity column 'id'.</P><P></P><P>This is originated from a macro :</P><P>%fcf_get_ecm_sequence_ids</P><P></P><P>whose source is not provided in the package.</P><P></P><P>My research shows that it can be solved by using ignore_read_only_columns = yes</P><P></P><P>But unfortunately that library is assigned in that macro. Is there any way i can resolve the issue?</P></BODY></HTML> Mon, 20 Oct 2014 09:37:16 GMT https://communities.sas.com/t5/Fraud-AML-and-Security/SAS-AML/m-p/190904#M8 DinnarHooda 2014-10-20T09:37:16Z Re: SAS AML https://communities.sas.com/t5/Fraud-AML-and-Security/SAS-AML/m-p/190905#M9 <HTML><HEAD></HEAD><BODY><P>Have you opened a track with SAS support? Since the error you are getting is from a SAS-supplied macro they would be in the best position to advice you how to fix the error.</P></BODY></HTML> Mon, 20 Oct 2014 19:20:26 GMT https://communities.sas.com/t5/Fraud-AML-and-Security/SAS-AML/m-p/190905#M9 SASKiwi 2014-10-20T19:20:26Z