Skip to main content
J
joseg0005
April 23, 2021
Question

Integration Write to AZURE DB

  • April 23, 2021
  • 1 reply
  • 0 views

I am getting the following error when I try to insert a new item to my Integrated DB

An error occurred while trying to write to the entity “UMS_INTEGRATION_AAPP” [id=1af91040-2df8-4691-95b9-0a2d725ec112@11037, type=UMS_INTEGRATION_AAPP (id=4502)] (data store: UMS AZURE DS). Details: org.hibernate.exception.SQLGrammarException: could not insert: [UMSINTEGRATIONAAPPDT4539]: com.microsoft.sqlserver.jdbc.SQLServerException: 'SCOPE_IDENTITY' is not a recognized built-in function name. Data: TypedValue[it=4502,v={100054,<null>,111.0,111.0,111.0,111.0,<null>,<null>,<null>,<null>,<null>,<null>,Boston,New York,,,,,,<null>,<null>,<null>,<null>,<null>,<null>,<null>,<null>,<null>,<null>,<null>,2021-04-23 00:00:00.0,2021-04-23 00:00:00.0,Administrator,Administrator}]

however I don't get this error if I try to update an existing item on the DB

1 reply

csteward
csteward
April 23, 2021

This seems to be specific to the Azure Data Warehouse, related to the query's inability to retrieve a new primary key for an insert.  You will likely have to work this out with whatever Azure DW support you have available, as far as account permissions, DB settings, etc.

Terms & ConditionsAccessibility statement