Not able to create objects for XML RR pair

Article Id: 140255

Status: Published

Updated On: 15-11-2019 08:39

Products:

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction:

Trying to Register RR pairs and create generator for XML RR pairs .

It is throwing an error saying "Exception while updating the status of the shredder project to Default".

Cause:

Permissions issue

com.microsoft.sqlserver.jdbc.SQLServerException: The EXECUTE permission was denied on the object 'AddSchema', database 'SCRAMBLE', schema 'dbo'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)

Environment:

Portal version is Version 4.4.0.10.

Data maker version is Version 4.4.0.10

Resolution:

Permissions issue.

Need the EXECUTE rights to the SCRAMBLE database and schema as stated in the error. DBA needs to set that up for you.