Oracle Communities

Oracle Analytics and AI

Child Item

In FAW dashboard after apply filter returned a general error has occurred.

Please see the below error..

Error generating view. Error getting cursor in GenerateHead
Error during query processing (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
(HY000)
State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS [ecid:c2d889a5-e869-480d-92fd-9cc8ec5d749c-00027594,0:1:27 ts:2024-05-08T13:38:19.171+00:00].
(HY000)
State: HY000. Code: 27002. [nQSError: 27002] Near <">: Syntax error (HY000)
State: HY000. Code: 26012. [nQSError: 26012] . (HY000)

Please do the needful.

Thanks,

Find more posts tagged with

Fusion HCM Analytics

Accepted answers

All comments

Sumanth V -Oracle

@User_J7TV2 - Please let us know if you are using Dashboard filter in DV workbook or Dashboards from classic analytics. Also, is this happening for any selection in filter or only for specific selections. please confirm.

User_J7TV2

Hello,

I'm using Dashboard filter in DV workbook .

It seems to be happening for any selection in filter.

Thanks,

Sumanth V -Oracle

@User_J7TV2 - If you are using multiple columns in the dashboard filters, then please remove the custom calculated columns[columns under My Calculations] used first and then validate if issue still persists. If not, open each and every custom calculations created and validate the same to make sure there are no issues in it. Let us know if it helps in figuring out the cause of the issue.

Sumanth V -Oracle

@User_J7TV2 - Please let us know if the suggested approach helped in figuring out the cause of the issue.

User_J7TV2

Hello,

Still I'm getting the same error like below..

Error generating view. Error getting cursor in GenerateHead
Error during query processing (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
(HY000)
State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS [ecid:1f925cf5-29b2-40d7-9057-e65d3caf4925-0002ef44,0:1:97 ts:2024-05-09T08:03:39.050+00:00].
(HY000)
State: HY000. Code: 27002. [nQSError: 27002] Near <.>: Syntax error (HY000)
State: HY000. Code: 26012. [nQSError: 26012] . (HY000)

Sumanth V -Oracle

@User_J7TV2 - Please share the screenshot showing the error and selections in dashboard filter.

User_J7TV2

Selection Filter Error Details_Screenshot 2024-05-09 134749.png

Selection Filter Error_Screenshot 2024-05-09 134532.png

Sumanth V -Oracle

Does the tiles render value if the filter selection or filter itself is removed from filter bar?

User_J7TV2

Without Filter selection Screenshot 2024-05-09 154333.png

without filter selection value

User_6C6AA

Hi,

I have been experiencing the same issue. Any solution?