Not able to create objects for XML RR pair

book

Article ID: 140255

calendar_today

Updated On:

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.