Xtraction Error: "The ConnectionString property has not been initialized."
book
Article ID: 103737
calendar_today
Updated On:
Products
SUPPORT AUTOMATION- SERVERCA Service Desk Manager - Unified Self ServiceCA Service Desk ManagerCA Service Management - Asset Portfolio ManagementCA Service Management - Service Desk Manager
Issue/Introduction
In a fresh new Xtraction install, after log into Xtraction interface, while trying to generate anything by dragging and dropping to the dashboard area, a message is displayed:
"An error has occurred during processing. Please try again. If this continues to occur, please contact the application administrator.”
At Xtraction log files, you might see additional details at the "Xtraction.Web.log" files:
ERROR Xtraction.Service.SqlDataEngineService - Error
System.InvalidOperationException: The ConnectionString property has not been initialized.
at System.Data.SqlClient.SqlConnection.PermissionDemand()
at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
Cause
The error at log file "The ConnectionString property has not been initialized" suggests that the connections were not set properly. This is probably because of some wrong information got from "datamodel.dat" file, or maybe it was modified and saved at wrong Xtraction install folder.
Sometimes by mistake the "datamodel.dat" file is opened in "Data Model Editor" tool from the location:
If you modify and save the datamodel.dat file to the ..\Data\Defaults\DataModel folder, after launching Xtraction, it will load the configurations from the other file located under ..\Data\Configuration folder, causing the unexpected behavior, working as if no connections configurations had been performed at all.
Environment
Xtraction - ANY RELEASE
Resolution
Check if the "datamodel.dat" file where the configurations were performed was saved at the right place. After editing it using the "Xtraction Data Model Editor" tool, when selecting the option to "Save As", make sure to select the install path: