TDM Model Service Failing - Not able to work with Portal

book

Article ID: 128460

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

    We are trying to register new object using CA TDM. But table list is not getting populated for given Data source present in SQL Server.
When we did observed the network response, we can see that TDM Model Service is getting failed with below error:

    "Error deploying web application archive C:\Program Files\CA\CA Test Data Manager Portal\tomcat\webapps\TDMModelService.war"
This is happening with TDM Orchestration Service as well.

Cause

After further analysis from TDMModelservice.log file, there are error related to database schema
We noticed an error from Model service log as below. 

 [WARN ] [localhost-startStop-8 ] --- [U:][M:][P:] o.h.e.j.s.SqlExceptionHelper: SQL Error: 2797, SQLState: S0001 
 UTC [ERROR] [localhost-startStop-8 ] --- [U:][M:][P:] o.h.e.j.s.SqlExceptionHelper: The default schema does not exist. 

Environment

CA TDM 4.7
Database: SQL Server with windows authentication.

Resolution

To resolve this issue, make below changes to user account used for DB connection:
    1) Make sure user has windows folder level permissions (Read/write).
    2) For service account user, added default schema as 'dbo' on repository database GTREP.  using the query: ALTER USER [YOURDOMAIN\HotTester] WITH DEFAULT_SCHEMA=[dbo] 
GO 

Additional Information

https://stackoverflow.com/questions/3733635/facing-error-of-the-default-schema-does-not-exist-when-executing-runtime-quer