Setup Xtraction Unable to create/update database tables

Article Id: 111411

Status: Published

Updated On: 16-08-2018 04:58

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:

Install of Xtraction failed

Install of Xtraction

On the "Xtraction setup" window, you will see this popup message

<<
unable to create update database table
format of the initialization string does not conform to specification starting at index 147
>>

Environment:

Release:
Component: XTR4SM

Resolution:

This error message from Xtraction is about the write permission.

-> In sql studio management, open the properties of the Xtraction database owner.

Right click on property of the Xtraction owner, "user mapping", in list of "database role membership for master:" check on
db_datareader and dbdatawriter

Additional Information:

Recommendation for Xtration user

db_datareader to the mdb
and
db_datareader + db_datawriter to the Xtraction database