Errors returned when trying to save map
Adrian asked 7 years ago
The errors below are from LogEventLogId , I am trying to save a map file that references XSLT file.
could not insert: [eOne.SmartConnect.Connectors.Generic.XmlQueryDataSource#f32e912e-8cc8-40d2-9263-a5de00c3b73b][SQL: INSERT INTO [XmlQueryDataSource] (Path, SelectLevel, IncludeAttributes, XslPath, XmlQueryDataSourceId) VALUES (?, ?, ?, ?, ?)]
could not execute batch command.[SQL: SQL not available]
could not insert: [eOne.SmartConnect.Connectors.Generic.XmlQueryDataSource#f32e912e-8cc8-40d2-9263-a5de00c3b73b][SQL: INSERT INTO [XmlQueryDataSource] (Path, SelectLevel, IncludeAttributes, XslPath, XmlQueryDataSourceId) VALUES (?, ?, ?, ?, ?)]
could not execute batch command.[SQL: SQL not available]
Answers
Mark Anderson Staff answered 7 years ago
Are you able to save other maps? This error is pointing to not having access to the table XMLQueryDataSource in the SmartConnect SQL database where SmartConnect is installed. You either do not have permission (SQL Not Available) or there is a duplicate key issue that is causing this.