Nqserror 10058 A General Error Has Occurred. Essbase Error Hy000
Contents |
Slideshow Wallpaper Ad Full Width Page Archives Page Homepage Blog No Leaderboard Typography Business Entertainment Blogs Columnists Max Mag Staff Sports Blogs Columnists Fashion Tech Travel Food All About Data Warehousing and Business Intelligence Support Center Don't
Nqserror 43113 Message Returned From Obis
miss OBIA 7.9.6.3 InstallationPosted 125 days ago What is OBIEE?Posted 1 days ago OBIEE error codes: opr4onwy:u9im8tac:oi2dl65p 11G ArchitecturePosted 10 days ago Why Data warehousePosted 13 days ago Sunday, 16 February 2014 Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65P By Kashif M
State: Hy000. Code: 10058
on 06:40:00 View Display Error (Error Code: nQSError: 43113, nQSError: 10058, nQSError: 27005, YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65P)Error getting drill information Error DetailsError Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65POdbc driver returned an error (SQLExecDirectW).State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A error codes: yqco4t56:opr4onwy:u9im8tac:oi2dl65p general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27005] Unresolved column: "ME_MEALSEVOLUTION"."ME_ASONDATE".Please have your System Administrator look at the log for more details on this error. (HY000) Cause: What is the reason and why getting the error:1. ODBC driver error.2. Column Mis-Matches.3. Rename of the column or table or Subject areas in the RPD level.4. User may not have the rights to access the report or Subject area odbc driver returned an error (sqlexecdirectw). or tables and columns.Solution:1. Check the connection pool of the particular subject area in the RPD.2. Check the tns entries in the OBIEE folder and Oracle installed folder.3. Open the command prompt and check the tnsping of the tns entry name.4. Make sure that the tables, columns; subject area has been renamed before.5. If you made changes in the rpd level and do the same in the report or dashboard level also.6. Check the rights of the user in the rpd level.7. Check the access of the users for each and every table or columns or subject areas in the RPD level.8. If the access of the user is in "No Access" then you will get this error"view display error".Screenshots: Error DetailsCheck the connection pool:Check the connection of the database in the connection pool and status of the connection.Check the tns file and its entries from the locations:1. D:\app\XXXXXX\product\11.2.0\client_1\network\admin---Tns file.2. D:\11G\Oracle_BI1\network\admin---- Tns file.3. D:\11G\oracle_common\network\Admin --- Tns file. (if not create the Tns names as same to all the three location).Check in the command prompt whether the tns name is in connecting through command prompt or not.Command: tnsping
standing, the major things to look out for include: The Presentation Server going downThe Presentation Server being up, but the BI Server has gone downThe Scheduler is down or hasn't actually been configured properlyThe J2EE Application Server
Odbc Driver Returned An Error (sqlexecdirectw) Obiee 11g
is down whilst the OBIEE components are upThe Java Host server is down (and what nqserror: 96002 does this affect?)All of the OBIEE components are up including the J2EE server, but the source database is downAll of the above,
Nqserror 14025
but this time Essbase is downIf you're an administrator, what is the impact of these parts of the system failing (we'll ignore clustering for now), and if they are down how can you find out what's wrong? Starting http://mkashu.blogspot.com/2014/02/error-codes-yqco4t56opr4onwyu9im8tacoi2.html with the Presentation Server, in theory it shouldn't crash by itself but I've seen this happen when, for example, there is a bug in the Presentation Server code that caused a segfault when a pivot table contained too many cells. In general though, problems with the Presentation Server are generally because the process isn't actually running, and when running with WebLogic as the J2EE Application Server users will get a message like the one below http://www.rittmanmead.com/blog/2009/05/troubleshooting-obiee-connectivity-and-server-issues/ if they try and connect when the Presentation Server service isn't running: This error is caused by the J2EE Presentation Services plug-in not being able to communicate with the Presentation Services itself. If Presentation Services is running on a Windows box, a quick check in the Windows Services applet will show if the service is running OK, and as we can see in the screenshot below it's actually down. So why has it gone down? The best places to check are the log file at
$ORACLEBIDATA/web/log/sawlog0.logif the Presentation Server was up at one point but then crashed or closed down for some reason, or the Windows Event Viewer (System Log) if the service won't actually start in the first place. Unfortunately the messages in the System Log don't really tell you what the problem is (the error above was actually caused by a developer making changes in the instanceconfig.xml file but entering the details incorrectly, which stops the Presentation Server service from actually starting) but at least if you try and restart the service and find that it won't actually start, you can probably assume it's due to a change in one of the config files and the next step is to find out who's introduced the changes. In conclusion then, if users can connect to the J2EE application server but notHyperion Business Rules Hyperion DIM Hyperion Essbase Hyperion Financial Reporting Hyperion Shared Services Hyperion Web Analysis Hyperion Workspace Informatica Mapviewer OBI EE Plus OLAP Oracle 11g Oracle Data Integrator Oracle EPMA OWB Web Center https://oraclebizint.wordpress.com/2008/01/21/oracle-bi-ee-101332-connectivity-to-essbase-first-impressions/ Suite Top Posts Customizing OBI EE - SOAP API Customizing OBI EE – GO URL Parameters Hyperion Essbase 11.1.1.0 - Using Java APIs - Part 1 - Viewing Outline Members Hyperion Essbase 11.1.1.0 http://gerardnico.com/wiki/dat/obiee/oci - Partitioning and its use cases - Transparent, Replicated and Linked partitions - Introduction Oracle BI EE 10.1.3.3/2 - Bins and Groups Oracle 11g - BLOB and BFile support for SQL Plus error codes: Hyperion Financial Reporting - Getting Started Oracle BI EE 10.1.3.4.1 - Understanding Logical SQL - Part 1 Oracle BI EE 10.1.3.3/2 - Choosing Multiple Columns in a Column Selector - Varying Multiple Columns in a Report Oracle BI EE 10.1.3.3 - Configuring Delivers - iBots Pages About Me Contact Me Workshop Series Your Questions January 2008 M T W T F S S « Dec odbc driver returned Feb » 123456 78910111213 14151617181920 21222324252627 28293031 Archives June 2009 May 2009 April 2009 March 2009 February 2009 January 2009 December 2008 October 2008 September 2008 August 2008 July 2008 June 2008 May 2008 April 2008 March 2008 February 2008 January 2008 December 2007 November 2007 October 2007 September 2007 August 2007 July 2007 Bookmark About Me I am Venkatakrishnan J, a Business Intelligence enthusiast working with Rittman Mead Consulting who likes blogging about acquisitions in the BI space, technical workings of the BI tools in general and Oracle Business Intelligence tools in particular. All the views expressed here are my own and does not reflect the views of Rittman Mead Consulting or Oracle. Going forward, i would be blogging at http://rittmanmead.com/blog. Blogroll Abhinav Agarwal Adrian Ward Alex Andriy Yakushyn Antonio Romero Asktom Borkur Steingrimsson Christian Berg David Aldridge Dimitri Gielis Doug Burns Eddie Awad Frank Buytendijk Howard Rogers John Goodwin John Minkjan Jonathan Lewis Justin Kestelyn Karthik Laurent Scheider MAIA Blog Marcos Campos Michael Armstrong-Smith Oracle OLAP Blog Pawel Barut Pete Finnigan Peter Scott Ramkumar Krishnan Rittman and Jon Mead Tim Dexter Tim Hall Tom Kyte Vlamis Subscribe Entries (RSS)
Intelligence (OBIEE/Siebel Analytics) OBIEE 10G/11G - Oracle Call Interface (OCI) configuration OBIEE 10G/11G - Oracle Call Interface (OCI) configuration Table of Contents 1 - About 2 - Articles Related 3 - Prerequisites 3.1 - 10g 3.2 - 11g 4 - Connect identifier 4.1 - Net Service Name 4.2 - Easy Connect Method 4.3 - Connect Descriptor 5 - Support 5.1 - ORA-12154: TNS:could not resolve the connect identifier 5.2 - ODBC limitations 6 - Documentation / Reference 1 - About OCI stands for Oracle Call Interface (OCI). It's an Call Level Interface API (such as ODBC and JDBC but specific to Oracle) that lets you develop application and access an Oracle Database. 2 - Articles Related OBIEE - Connection PoolOBIEE 10G/11G - Event Pooling table (Event Table) to purge the cache after ETL processOBIEE - Physical LayerOBIEE - Data Source (Oracle Analytics Adapter) 3 - Prerequisites 3.1 - 10g To use it you have to install it on the BI Server machine through an Oracle Client installation (for instance an Oracle Database, an Oracle Client or an Oracle Instant). This installations will provide you the oci.dll file which is the OCI binary. And the directory of this binary must be located in the path environment variable of the user who start the BI Server (for a remote server import) or the Administration tool for a local import. 3.2 - 11g The OCI dll are shipped with the installation. cd /u01/app/oracle/product/fmw/Oracle_BI1/lib ls -l *oci* -rwxr-x--- 1 oracle oinstall 117051 Oct 14 17:12 libnmeoci.so -rw-r----- 1 oracle oinstall 0 Apr 28 2011 libnmeoci.so.0 4 - Connect identifier To configure OCI, you have to provide in the connection pool of the physical layer three parameters: the call interface. You must choose OCI. The data source name The user name and password In the data source name, you have to enter a connect identifier that can be one of the following naming methods. 4.1 - Net Service Name A Net Service Name (TnsName). This descriptor must be defined in the tnsnames.ora file. OCI localized this file with the help of the TNS_ADMIN environment variable. In 11g locally, you must set this environment variable in the file bi-init If the TNS_ADMIN environment variable is not set then the ORACLE_HOME variable must be set, and the configura