Setup Xtraction Unable to create/update database tables

book

Article ID: 111411

calendar_today

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

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