TDoD: Exception occurred while validating license- Error loading server key

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Our TDoD service has stopped and these errors are in the log file:

FATAL GTWCFHost.GTWCFHost - Exception occurred while validating license 
FATAL GTWCFHost.GTWCFHost - Exception Code: licence_error_loading_server_key. Exception Message: Error loading server key: Error executing: select pk_gtrep_lic.f_get_clob (:lClobID) 
from dual:\r\nORA-03113: end-of-file on communication channel 
Process ID: 15073908 
Session ID: 1120 Serial number: 12961 
FATAL GTWCFHost.GTWCFHost - Stack Trace: at GT.TDMoD.Services.Security.Licence.ReturnServerLicence(String lsServerLicence) 
at GT.TDMoD.Services.Security.Licence.TestServerLicence() 
at GTWCFHost.GTWCFHost.licenseTimer_Elapsed(Object sender, ElapsedEventArgs e) 
FATAL GTWCFHost.GTWCFHost - Closing service host 
FATAL GTWCFHost.GTWCFHost - Service host closed

Cause

This error is usually caused by an interruption in service to the repository database. 

Environment

CA Test Data Manager (TDM)- Test Data on Demand (TDoD)

Resolution

Usually a restart of the TDoD service resolves this issue. 

 

If the TDoD service is not able to access the back-end database, the service (by default) will shut down, and this is by design. However, since TDoD is implemented as a Windows service, you can make a change to the service itself to restart the service if it goes down. Below is a link that talks about setting this up if needed- https://serverfault.com/questions/48600/how-can-i-automatically-restart-a-windows-service-if-it-crashes

Additional Information

If you experience any further issues, please open a support case by going to https://www.ca.com/us/services-support/ca-support/contact-support.html.