OAS 2025:"Log Could Not Be Retrieved" Error When Clicking View Log in Administration>Manage Sessions
In OAS 2025, 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 results in the following errors:
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
toobis1-query.log
: jq is not installed. Please install jq before running this script.Cause:
This issue is an internal product defect. In OAS 2025, BI Server logs are generated only in JSON format (
obis1-query.json
,obis1-diagnostic.json
), while the standard log format is missing.A review of the logconfig.xml file (located at <<Domain Home>>/config/fmwconfig/biconfig/OBIS/) reveals the following:
- Element:
/server/ServerInstance/Log/Format
OAS 2025: Set toJSON
- Element:
/server/ServerInstance/UserLog/Format
OAS 2025: Set toJSON
Solution:
To resolve this issue:
- Update the logconfig.xml file in the OAS 2025 environment by setting Format = ODL-TEXT,JSON.
- Restart the OAS 2025 environment.
After this update, both log formats will 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.