Solution : https://service.sap.com/sap/support/notes/1237190 (SAP Service marketplace login required)
Summary :
When executing a query with a temporal hierarchy join in the BI Java Web runtime, a termination error may occur due to a program error in class SAPMSSY1, specifically an uncaught exception type CX_SY_DYNAMIC_OSQL_SEMANTICS. This issue affects the leaf selection of the fixed filter within the temporal hierarchy join. The error is related to method IF_RSMD_RS_ACCESS~GET_VALUES and involves the temporal hierarchy join tags CL_RRHI_MDACCESS_TD and THJ Temporal Hierarchy Join THJTFL. To resolve, import Support Package 19 for SAP NetWeaver 7.0 BI (BI Patch 19 or SAPKW70019). In urgent cases, implement advance correction instructions after consulting Note 875986 regarding transaction SNOTE.
Key words :
terms cl_rrhi_mdaccess_td if_rsmd_rs_access~get_values thj temporal hierarchy join thjtfl reason, temporal hierarchy join, bi java web runtime, 0 bi import support package 19, class sapmssy1 method, type cx_sy_dynamic_osql_semantics occurred, solution sap netweaver 7, sap netweaver 7, bi patch 19, sapbinews bi 7
Related Notes :
| 1464244 | WJR:THJ hierarchy node selection is not retained |
| 1136884 | SAPBINews NW7.00 BI ABAP Support Package 19 |