A General Error Has Occurred. Nqserror 43113
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring nqserror 43113 message returned from obis developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask nqserror 43113 in obiee 11g Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join [nqserror: 10058] a general error has occurred. them; it only takes a minute: Sign up OBIEE Answers not showing results up vote 0 down vote favorite I recently installed OBIEE 11.1.1.6.0. I imported the repository I had from 11.1.1.5 which was working fine till now. In nqserror: 43119 the administration tool, I can query my data and update the rows, I can connect with the same credentials as the connection pool without problems in SQLPLUS. Users have the RESOURCE and CONNECT privileges. My weblogic user as all the privileges and has been granted read/write to my Subject area. I have set the environment variables, modified the instancesconfig.xml and tried all the things i could've found on the OTN but BI Answers continues to give me this ERROR
Error Codes: Opr4onwy:u9im8tac:oi2dl65p
View Display Error Odbc driver returned an error (SQLExecDirectW). Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 1017, message: ORA-01017: invalid username/password; logon denied at OCI call OCISessionBegin. [nQSError: 17014] Could not connect to Oracle database. (HY000) SQL Issued: SELECT 0 s_0, "SAP_AVIS"."Fait SAP AVIS"."Avis" s_1 FROM "SAP_AVIS" FETCH FIRST 65001 ROWS ONLY Please help, I am desperate. oracle oracle11g business-intelligence obiee share|improve this question edited Mar 6 '13 at 20:22 asked Mar 4 '13 at 19:23 P.Nichols 108127 Thanks APC for the layout. I am quite new so i don't know all the tricks. –P.Nichols Mar 6 '13 at 15:40 add a comment| 3 Answers 3 active oldest votes up vote 2 down vote accepted I have been able to resolve my OCI ORA-01017 error. The problem was caused by my connection pools. I had a connection amed "A" to access tables in a certain schema in my DB and another connection named "B" this time to access tables in another schema but in the same DB. In Oracle BI Answers (presentation), I was trying to view data whitin the connection B but strangely OBIEE Answers was using the connection A. In the end I removed/renamed the connection A and everthing worked like nothing never happ
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can
Nqserror 10058 A General Error Has Occurred. Nqserror 43113
not post a blank message. Please type your message and try again. More nqserror 10058 in obiee 11g discussions in Business Intelligence Suite Enterprise Edition All PlacesBusiness IntelligenceBusiness Intelligence FoundationBusiness Intelligence Suite Enterprise Edition This discussion is nqserror 10058 a general error has occurred in obiee archived 3 Replies Latest reply on Oct 6, 2014 7:29 AM by Rene Kuipers Evaluate Function Error 910527 Aug 21, 2014 6:57 PM Hello Experts,We created a function to calculate the person's http://stackoverflow.com/questions/15209397/obiee-answers-not-showing-results age at the database level and gave the required permissions to call. When we are calling it through OBIEE we are receiving the following error at the report level.1. We enabled to use evaluate function at NQSConfig.ini file2. the input value for parameter and output of age is INT.3. We are able to call the function at database level and run it.I am I missing https://community.oracle.com/thread/3599360 something ?SYntax:EVALUATE('FNC_GET_AGE(%1)' as INT , "Person Details"."Party ID")Error:Odbc driver returned an error (SQLExecDirectW). Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65PState: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 904, message: ORA-00904: "FNC_GET_AGE": invalid identifier at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)SQL Issued: SELECT 0 s_0, "Person"."Person Details"."Birth Date" s_1, "Person"."Person Details"."CalPERS ID" s_2, "Person"."Person Details"."Death Date" s_3, EVALUATE('FNC_GET_AGE(%1)' as INT ,"Person"."Person Details"."Party ID") s_4 FROM "Person" FETCH FIRST 5000001 ROWS ONLY Thanks,Rick. I have the same question Show 0 Likes(0) 2415Views Tags: none (add) evaluateContent tagged with evaluate, obiee 11gContent tagged with obiee 11g, evaluate obiee 11gContent tagged with evaluate obiee 11g, evaluate functionContent tagged with evaluate function This content has been marked as final. Show 3 replies 1. Re: Evaluate Function Error 2657149 Oct 3, 2014 9:10 PM (in response to 910527) Hi, I am facing the same issue, Have you got the solution for this. View Display Error Odbc driver returned an error (SQLExecDirectW). Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058]
one Analytics report on another, only to go back to the report later and https://developers.exlibrisgroup.com/forum/posts/list/129.page find that it is returning a general error. When I draft the report again (with identical parameters), it works fine. However, even when the Analytics http://www.askjohnobiee.com/2012/11/fyi-log-could-not-be-retrieved-nqserror.html report is functioning, the API returns an error when it tries to access it. I've just redrafted one of the reports: https://analytics-na01.alma.exlibrisgroup.com/analytics/saw.dll?Answers&path=%2Fshared%2FUniversity%20of%20Manitoba%2FFor%20Max%2FBlocks%2F2015.02.11%20Place%20Registrar%20Block#criteriaTab14b79b9a9e0 I've just been a general using the Explorer to try to get the results in the API. My path is: /shared/University of Manitoba/For Max/Blocks/2015.02.11 Place Registrar Block The error I get is as follows: Response-Status: HTTP/1.1 500 Internal Server Error Date: Wed, 11 Feb 2015 17:40:59 GMT Server: Apache-Coyote/1.1 p3p: CP="IDC DSP COR ADM DEVi TAIi a general error PSA PSD IVAi IVDi CONi HIS OUR IND CNT" X-Frame-Options: SAMEORIGIN Content-Type: application/xml;charset=UTF-8 Connection: close Content-Length: 380
something a little surprising with the OBIEE 11g upgrade assistant & opatch tool. After you apply a patch set (e.g. 11.1.1.6.4), core BIServer components become 'locked' or a default file privilege gets applied that is too restrictive. In fact, in my last post I covered a similar issue with Oracle Process Manager and Notification Server (OPMN) failing to start after applying a bundle patch, you can read it here. This post follows a similar issue, in that logging in OBIEE 11g is non-functional after applying a patch set: Log Could Not Be Retrieved Odbc driver returned an error (SQLExecDirectW). Error DetailsError Codes: OPR4ONWY:U9IM8TACState: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43100] Log Viewer process reported error 2:No such file or directory. (HY000) Oracle Technical Network has, unfortunately, no documentation on this issue of BIServer components file privileges becoming too restrictive. If an OBIEE Administrator wants to enable logging in their Answers environment, it is usually achieved by setting the LOGLEVEL to a value greater than 0 or less than 6: This will not work IF your Answers environment is unable to identify or access the log file or directory. So the question is: Why is access to the log file & directory disabled in my Answers environment and how do I enable access? First: Understand that Presentation Logging in OBIEE 10g and OBIEE 11g is captured in your nqquery.log file located at: $ORACLE_INSTANCE_HOME\diagnostics\OracleBIServerComponent\..\..\nqquery.log Second: The mechanism Answers uses for reading a log file is the nqlogviewer executable which is located in your $ORACLE_HOME\bifoundation\server\bin folder So the error nQSError:43113 leads me to believe that insufficient privleges has been set for the nqlogviewer executable. I assume this is true because similiarly in my previous postcore BI components nqserver, nqscheduler, etc, were all inaccessible. So to resolve this, apply the following command to your nqlogviewer : chmod 777 nqlogviwer (