Getting the error while reserving the data
search cancel

Getting the error while reserving the data

book

Article ID: 247046

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

    Getting the internal server 404 errror while reserving the data in the one specific data model.

ERROR:

 [WARN ] [http-nio-8080-exec-20    ] --- [U:Automation][M:POST][P:/api/ca/v1/reservations]                           c.z.h.p.ProxyConnection:  CITIDIRECT_UAT1 - Connection oracle.jdbc.driver.T4CConnection@79b274b7 marked as broken because of SQLSTATE(72000), ErrorCode(1013)
oracle.jdbc.OracleDatabaseException: ORA-01013: user requested cancel of current operation

 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
 ... 152 common frames omitted
Wrapped by: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation

 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)

Environment

Release : 4.10

Component : Web Portal - Find & Reserve

Cause

From TDMDatareservation logs, capture the query that is throwing an error and execute in SQL Server management studio.

This query is taking lot of time to retrieve the details. Because of this, TDM is closing the connection and throwing an error.

Resolution

Work with your database team to improve the query response time.

Powered by Wolken Software