Xtraction Error: "The ConnectionString property has not been initialized."

Document ID : KB000103737
Last Modified Date : 28/06/2018
Show Technical Document Details
Issue:
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.

Xtraction Error

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)
 
Environment:
Xtraction - ANY RELEASE
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.
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.
Additional Information:
How to configure the Xtraction connections in a fresh instalaltion