Running the Rest API to retrieve the users having error "ORA-00942: table or view does not exist"

Products

• CA Harvest Software Change Manager
• CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

After login successfully with Rest API, we tried to obtain the list of users and received an error:

GET http://<servername>:<port>/harvest-scm/rest/users HTTP/1.1
{
   "timestamp": "2023-05-16T17:08:44.899+0000",
   "status": 400,
   "errors": ["E03020003: Database error [CA Harvest SCM][ODBC 20101 driver][Oracle]ORA-00942: table or view does not exist\nSQLSTATE=53."],
   "path": "/harvest-scm/rest/users"
}

What could be causing the problem?

 

 

 

Environment

Release : 13.0.4 and up

Resolution

RestAPI support starts from Harvest v13.0.4 only.

A new table is included in 13.0.4  HARUSRGRPLISTTEMP, which is used when user related APIs are fetching data.

An SQL script will be found in the 13.0.4  installation (Database folder) to create this table.

The customer needs to upgrade to 13.0.4, run the script, and retry the scenario.

Install CA Harvest SCM Refresh Pack V13.0.4 on Windows