OAS 2025:Error:"Log could not be retrieved" when clicking View Log in Administration>Manage Sessions

RanaAshutosh-Oracle

In OAS 2025, When attempting to view the detailed session log in the UI Console (Sessions and Query Logs) by clicking the "View Log" link for a specific session, the following errors occur:

Error Messages:

Log Could Not Be Retrieved
Error during query processing (SQLExecDirectW)

Error Details:

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS [ecid:xxxxxxx].
State: HY000. Code: 43261. [nQSError: 43261] Log Viewer process failed to convert obis1-query.json to obis1-query.log: jq is not installed. Please install jq before running this script.

This issue is an internal product defect. In OAS 2025, BI Server logs generate only in JSON format (obis1-query.json, obis1-diagnostic.json), with the standard log format missing.

While checking logconfig.xml file (located at <<Domain Home>>/config/fmwconfig/biconfig/OBIS/) reveals the following :

Element: /server/ServerInstance/Log/Format
OAS 2025: Set to JSON

Element: /server/ServerInstance/UserLog/Format
OAS 2025: Set to JSON

To resolve the issue, update the logconfig.xml file in the OAS 2025 environment by setting Format = ODL-TEXT,JSON.

Then, restart the OAS 2025 environment.

After this update, both log formats should be generated in <<Domain Home>>/servers/obis1/logs/, and the "View Log" functionality in the UI Console (Sessions and Query Logs) should work correctly without errors.