Hi Ronald,
That issue got fixed by rebuilding the index for client_key. we need a root cause or a log determining the same.
Yes that was because of an Upgrade. How to check this particular this with regard to sql /ssgupgrade or sql/ssg upgrade schema. Please help us to figure out the same because we'll be doing this upgrade from 9.2 to 9.4 across PROD environment.
Sorry to bother. please help us out.
Thanks in advance :)
Original Message:
Sent: 03-12-2020 03:44 AM
From: Ronald Dsouza
Subject: CA API Gateway- OAuth Manager - Error
The other thing I can remember was a missing table or column... Was an upgrade done recently, if yes did you run the upgrade scripts? Also If you enable debugging it should assist you in catching the error.
------------------------------
Pre-Sales Consultant
CA Southern Africa
Original Message:
Sent: 03-12-2020 03:30 AM
From: Pavansai C
Subject: CA API Gateway- OAuth Manager - Error
Yes Ronald, db is active - We are able to connect to MySQL from Policy manager.
Original Message:
Sent: 03-12-2020 03:24 AM
From: Ronald Dsouza
Subject: CA API Gateway- OAuth Manager - Error
Is your database active.. You need to set up a valid db connection to MySQL have the OTK tables. Its a JDBC issue
------------------------------
Pre-Sales Consultant
CA Southern Africa
Original Message:
Sent: 03-12-2020 03:22 AM
From: Pavansai C
Subject: CA API Gateway- OAuth Manager - Error
Hi Joe,
Sorry for confusion.. That error is from OAuth Manager Portal. any idea on a fix for this?
Original Message:
Sent: 03-11-2020 07:16 AM
From: Joe Dascole
Subject: CA API Gateway- OAuth Manager - Error
Hi Pavansai,
I would check the connectivity to the database and that the ID is unique. This error generates as the result of a failure in the 'Perform JDBC query' assertion and I usually see that fail when the ID is in use.
Regards,
Joe
Original Message:
Sent: 03-11-2020 06:46 AM
From: Pavansai C
Subject: CA API Gateway- OAuth Manager - Error
Hey there,
Am getting the following error while registering the new client in the oauth manager...
{ "error":"invalid_request", "error_description":"Client(_id) value could not be persisted" }
can someone help me resolving this?