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?
Release : 13.0.4 and up
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