Not able to create objects for XML RR pair

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.