Error Getting Drill Information
saw_1 FROM OLEM Error Details Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65P Odbc driver returned an error (SQLExecDirectW). State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 13015] You do not have the permission to set the value of the variable 'LOB'. (HY000) SQL Issued: {call NQSGetLevelDrillability('SET VARIABLE LOB=''APD'' SELECT item.item saw_0, valueof(nq_session.LOB) saw_1 FROM OLEM')} This is the common error, the developers get, when he try to change the value of session variable using request variable in request prefix field. ( refer how to change the value of session variable using Request Variable ). Solution : Go to properties of session variable all check the option "Enable everyone to set value" Follow the below steps : 1. Open Administration Tool. Go to Manager > Variables. 2. Select System or Non-System variable (depends on type of your variable) under the Session from left pane. Then the corresponding variables will be listed on right pane. 3. Right click on the variable(for which your getting error in presentation service when you tried to change its value) and select properties. 4. check the option "Enable everyone to set value" (by default this option is unchecked) and click OK. Now, check the request in presentation service. Log out from that session and again login to presentation services and the same report. If you get the same error again, please let me know by your comments. Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: BI Server, Errors, OBIEE 10g, Variables Newer Post Older Post Home Subscribe to: Post Comments (Atom) Google+ Followers Best Book for OBIEE Developer Labels BI Server Cache Connection Pool Dimensional Hierarchy Errors Fragmentation Log Files OBIEE 10g Performance Tuning Presentation Services R
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 miss OBIA 7.9.6.3 InstallationPosted 125 days ago What is OBIEE?Posted 1 days ago OBIEE 11G ArchitecturePosted 10 days ago Why Data warehousePosted 13 days ago Sunday, 16 February 2014 Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65P By Kashif M on 06:40 View Display Error (Error Code: nQSError: 43113, nQSError: 10058, nQSError: 27005, YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65P)Error getting drill http://obiee-oraclebi.blogspot.com/2012/06/error-nqserror-13015-you-do-not-have.html information Error DetailsError Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65POdbc driver returned an error (SQLExecDirectW).State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A 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 http://mkashu.blogspot.com/2014/02/error-codes-yqco4t56opr4onwyu9im8tacoi2.html 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 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
IOException: Error getting https://issues.apache.org/jira/browse/DRILL-3982 user info for current user, anonymousAgile http://obiee100.blogspot.com/2011/07/in-between-calendar-control-with.html Board ExportXMLWordPrintableJSON Details Type: Bug Status: Open Priority: Critical Resolution: Unresolved Affects Version/s: 1.3.0 Fix Version/s: None Component/s: Execution - Flow Labels: None Environment: 4 error getting node cluster CentOS Description ALTER SYSTEM RESET ALL command reports IOException when impersonation is enabled. git.commit.id=fab061e6 Details of user that connected to Drill [root@centos-01 bin]# id uid=0(root) gid=0(root) groups=0(root) [root@centos-01 bin]# ./sqlline error getting drill -u "jdbc:drill:schema=dfs.tmp" apache drill 1.3.0-SNAPSHOT "say hello to my little drill" 0: jdbc:drill:schema=dfs.tmp> ALTER SYSTEM RESET ALL; Error: SYSTEM ERROR: IOException: Error getting user info for current user, anonymous [Error Id: de36ec03-b4c1-4b3a-a726-ae49f068fae4 on centos-02.qa.lab:31010] (state=,code=0) Stack trace from drillbit.log 2015-10-26 23:48:40,975 [29d1443b-cff4-f7d2-9083-40a5c38f8db2:foreman] ERROR o.a.drill.exec.work.foreman.Foreman - SYSTEM ERROR: IOException: Error getting user info for current user, anonymous [Error Id: de36ec03-b4c1-4b3a-a726-ae49f068fae4 on centos-02.qa.lab:31010] org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: IOException: Error getting user info for current user, anonymous [Error Id: de36ec03-b4c1-4b3a-a726-ae49f068fae4 on centos-02.qa.lab:31010] at org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:534) ~[drill-common-1.3.0-SNAPSHOT.jar:1.3.0-SNAPSHOT] at org.apache.drill.exec.work.foreman.Foreman$ForemanResult.close(Foreman.java:742) [drill-java-exec-1.3.0-SNAPSHOT.jar:1.3.0-SNAPSHOT] at org.apache.drill.exec.work.foreman.Foreman$StateSwitch.processEvent(Foreman.java:841) [drill-java-exec-1.3.0-SNAPSHOT.jar:1.3.0-SNAPSHOT] at org.apache.drill.exec.work.foreman.Foreman$StateSwitch.processEvent(Foreman.java:786) [drill-java-exec-1.3.0-SNAPSHOT.jar:1.3.0-SNAPSHOT] at org.apache.drill.common.EventProcessor.sendEvent(EventProcessor.java:73) [drill-common-1.3.0-SN
to have recent orders or activities etc. Here recent may be 1 day or 1 week or 1 month depends on different users. Solution: To accommodate all above, I will pull report with latest 7 days i.eBetween CURRENT_DATE-7 and CURRENT_DATE and also I will give controls to user to choose between dates from page prompt so that user can get what they need. Example: Today(July 24) report will pull recent 7 days as default(July 17 to July 24) and if I access same report tomorrow , report will pull July 18 to July 25 data as default. Same time user provided with page prompt control to choose dates. (Exp. July 17 to July 30).Here are step by step to do that. At first we need to have dynamic variables so create Server Variable's for your requirement in my case startDate_ServerVariable with week ago date (SYSDATE - 7) and endDate_ServerVariable as Current date (SYSDATE).1. To do that, in RPD navigate to repository - initialization block2. Create new initialization block3. Edit Data Source4. Select Data Source Type as Database5. Edit default initialization string with "select sysdate, sysdate-7 from dual"6. Assign Connection Pool and also choose refresh rate of these variables.7. Click on test to see proper values populated and say okay8. Now click on Edit Data Target button9. Create server variables10. Click okay; close Variable Manager, Save RPD. Now create prompts with Date-Calendar control and assign default value with server variable and also create new presentation variables as shown below.Create report with filter on date column using between syntax will be like,DateColumn is between @{startDate_PVariable}{1900-01-01 12:00:00} and @{endDate_PVariable}{1900-01-01 12:00:00} For more detailed information follow these articles.Venkat posted very good article onbetween, John has posted very good solution onCalendar Control. Possible error: If you have not specified proper default values for presenation variables exp "Date".CreatedDate" is between @{startDate_PVariable} and @{endDate_PVariable} then you will end up with following error.Error getting drill information: SELECT "Date".CreatedDate" saw_0 FROM subjectarea WHERE "Date".CreatedDate" BETWEEN date '0000-00-00' AND date '0000-00-00'State: HY000. Code: 10058. [NQO