hi would like to ask, i had this error during query processing to do full outer joint via datablend and count distinct from each table : (SQLExecDirecW) . State:HY000. code: 10058. [NQODBC]. is it because the buffer sizing limit? Thank you
Hi,
As you can imagine from the message you see on screen, it's an extremely generic message that doesn't really say anything (the BI Server error codes aren't as precise as Oracle Database error codes for example, that are often quite explicit).
Therefore you will need to provide more context: a product name and version, what you are doing when getting that message, the query involved etc.
I suspect, by the minimal info you provided so far, that you may have some privacy and confidentiality issues, and can't provide all the required details to understand what's going on. If this is the case, then a public forum isn't going to be able to help you much, and instead you should consider raising a SR with Oracle via the support site, a secure space between you and Oracle, covered by the contracts you signed with Oracle.
Still not sure what product you are using, so let's assume it is maybe OAS…
It looks like you are abusing your BI Server to work on a lot of data, something it isn't really good at because it isn't a database.
Your query is requiring more disk space than what it can use as temporary files.
There are a number of parameters that control those things. For example https://docs.oracle.com/en/middleware/bi/analytics-server/migrate-upgrade-oas/t_fmw_12c_-nqserror-46168-operation-rawfile-checksoftlimit-failed.html mention 2 settings that could potentially be involved in your issue. But increasing them isn't the final solution, it's mostly a workaround while you consider real solution (the BI Server is not a database, working with files datasets and doing complex queries requires the BI Server to do all the work, which is very slow and can hit limitations like the one you had).
@User_1WDE0 Welcome to Oracle Analytics Community!
Please provide us the complete error message.
it says
SQLExecDirecW) . State:HY000. code: 10058. [NQODBC] [SQL_STATE:HY000] [nQSError:10058]
general error has occured
Are you using WITH clause? If yes, below might be applicable for your scenario as well:
OAS Manual Query Error [nQSError: 10058] — Oracle Analytics
Thanks.
the details error are as below:
Error during query processing (SQLExecDirectW).State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. Please have yourservice administrator review this error. (HY000)State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS [ecid: ts:2025-05-29T16:07:36.106+08:00]. Please have yourservice administrator review this error. (HY000)State: HY000. Code: 43119. [nQSError: 43119] Query Failed:Please have yourservice administrator review this error. (HY000)State: HY000. Code: 46235. [nQSError: 46235] Error occurred while executing operator with node ID <<67316055>>. Please have yourservice administrator review this error. (HY000)State: HY000. Code: 46017. [nQSError: 46017] Sort has no work space in the work directory. Please have yourservice administrator review this error. (HY000)State: HY000. Code: 46234. [nQSError: 46234] Operation AFileWrapper::CompressBufferToFile failed, during creation of temp file: D:\xxxx\xxxx\Oracle_Home\user_projects\domains\bi\servers\obis1\tmp\nQS_SQ_16232_119_78de00fc_28913465.TMP, as it'll exceed the current configured limit. Current configured size limit in MB: 5120Please have yourservice administrator review this error. (HY000)SQL Issued: SET VARIABLE ENABLE_DIMENSIONALITY = 1; XSA_ROLE XSA('00124782'.'Transacted_Titan_v2') AS HUB, XSA('00124782'.'Transacted_MT_v2') AS HUB SELECT0 s_0,XSA('00124782'.'Login_Mobile_v2')."Login_w16"."end_date" s_1,XSA('00124782'.'Login_Mobile_v2')."Login_w16"."start_date" s_2,XSA('00124782'.'Transacted_Titan_v2')."Transacted_Titan_v2"."week_of_year" s_3,COUNT(DISTINCT COALESCE(XSA('00124782'.'Transacted_Titan_v2')."Transacted_Titan_v2"."Client who transacted >1 (by user)",XSA('00124782'.'Transacted_MT_v2')."Transacted_MT_w16v2"."Client who transacted >1 (by user)")) s_4,COUNT(distinct XSA('00124782'.'Transacted_MT_v2')."Transacted_MT_w16v2"."Client who transacted >1 (by user)") s_5,COUNT(distinct XSA('00124782'.'Transacted_Titan_v2')."Transacted_Titan_v2"."Client who transacted >1 (by user)") s_6FROM XSA('00124782'.'Transacted_Titan_v2')FETCH FIRST 6000001 ROWS ONLY
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
What is wrong with this code
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: 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…
There is no option for legend title in many visualization types.
