My Oracle Support Banner

Error "An error occurred trying to login" and ORA-00933 when Login to OPA Hub (Doc ID 2983658.1)

Last updated on NOVEMBER 03, 2023

Applies to:

Oracle Policy Automation - Version 12.2.30 and later
Information in this document applies to any platform.


While logging into the OPA Hub Manager with admin user getting Error:

"An error occurred trying to login" error and unable to proceed further.

The issue can be reproduced at will with the following steps:
1. After New OPA installation in Production
2. Try to login to OPA Hub

In Weblogic OPA Managed server log verified following errors:

<Test "select count(*) from ROLE" set up for pool "OPA_Hub_Datasource_opaprod" failed with exception: "java.sql.SQLRecoverableException: IO Error: Socket channel is closed".>

In OPA Hub log verified following errors:


Oct 24, 2023 5:23:58 PM IST> <ERROR> <[[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)']> ( - opaprod-opa-hub - Writing JSON Fault for exception SQL exception occurred while reading user authentication
at ~[opa-hub.jar:]
at ~[opa-hub.jar:]
Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.