Xtraction Error: "The ConnectionString property has not been initialized."
Article ID: 103737
Updated On:
Products
SUPPORT AUTOMATION- SERVER
CA Service Desk Manager - Unified Self Service
KNOWLEDGE TOOLS
CA Service Management - Asset Portfolio Management
CA 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:
"C:\Program Files (x86)\Xtraction Software\Xtraction\Data\Defaults\DataModel"
However, when you log into Xtraction the Data Model will be loaded from another folder:
"C:\Program Files (x86)\Xtraction Software\Xtraction\Data\Configuration"
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.
Sometimes by mistake the "datamodel.dat" file is opened in "Data Model Editor" tool from the location:
"C:\Program Files (x86)\Xtraction Software\Xtraction\Data\Defaults\DataModel"
However, when you log into Xtraction the Data Model will be loaded from another folder:
"C:\Program Files (x86)\Xtraction Software\Xtraction\Data\Configuration"
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:
"C:\Program Files (x86)\Xtraction Software\Xtraction\Data\Configuration"
Note: you should not modify the filename to anything else than "datamodel.dat", otherwise it will not work.
"C:\Program Files (x86)\Xtraction Software\Xtraction\Data\Configuration"
Note: you should not modify the filename to anything else than "datamodel.dat", otherwise it will not work.
Additional Information
Attachments
Feedback
Yes
No
Powered by
