Setup Xtraction Unable to create/update database tables
book
Article ID: 111411
calendar_today
Updated On:
Products
SUPPORT AUTOMATION- SERVERCA Service Desk Manager - Unified Self ServiceKNOWLEDGE TOOLSCA Service Management - Asset Portfolio ManagementCA 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