Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 195 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.5K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 68 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Manual Query Error Code:10058
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
Best Answers
-
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.
2 -
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 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).
1
Answers
-
@User_1WDE0 Welcome to Oracle Analytics Community!
Please provide us the complete error message.
0 -
it says
SQLExecDirecW) . State:HY000. code: 10058. [NQODBC] [SQL_STATE:HY000] [nQSError:10058]
general error has occured
0 -
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.
1 -
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 ONLY0 -
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 ONLY0
