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".

 

Environment

Portal version is Version 4.4.0.10.

Data maker version is Version 4.4.0.10

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)

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.