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

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.”

<Please see attached file for image>

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.

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.

Additional Information

How to configure the Xtraction connections in a fresh instalaltion