BookmarkSubscribeRSS Feed
DinnarHooda
Calcite | Level 5

Hi ,

I am using SAS AML 6.1 with ECM 2.3. During AGP execution i found one error stating :

ERROR: CLI execute error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot update identity column 'id'.

This is originated from a macro :

%fcf_get_ecm_sequence_ids

whose source is not provided in the package.

My research shows that it can be solved by using ignore_read_only_columns = yes

But unfortunately that library is assigned in that macro. Is there any way i can resolve the issue?

1 REPLY 1
SASKiwi
PROC Star

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.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Discussion stats
  • 1 reply
  • 1936 views
  • 0 likes
  • 2 in conversation