Obiee Cryptotools Error
Contents |
Intelligence (OBIEE/Siebel Analytics) OBIEE 10G/11G - BI Scheduler Configuration (for Delivers) OBIEE 10G/11G - BI Scheduler Configuration (for Delivers) Table of Contents 1 - About 2 - Articles Related 3 - The scheduler configuration obiee 11g scheduler configuration windows 4 - Database 4.1 - Database Scheduler User 4.2 - Oracle BI obiee 11g scheduler tables Scheduler Table 4.3 - Configuration 5 - General Tab 5.1 - Credential 5.1.1 - The alias 5.1.2 - The scheduler administrator job manager in obiee 11g 5.1.3 - Creation of the credential file 5.1.4 - instanceconfig.xml 5.2 - Configuring Oracle BI Presentation Services to Communicate With Oracle BI Scheduler 6 - Restart the Services 7 - Support 7.1 - Authentication scheduling reports in obiee 11g Failed 7.1.1 - When accessing delivers 7.1.2 - When saving an Ibot 7.2 - The Scheduler client connection was closed 7.3 - Location of the Log 8 - Reference 1 - About This article go through all the minimal steps that you must perform to configure BI Scheduler. The tricky step is to perform the credential link between presentation service (for use with delivers) and scheduler. If you
S_nq_job Table
don't do it, you could not save any Ibot and you will receive this error : The configurations data are stored in this file: C:\OracleBIData\scheduler\config\instanceconfig.xml 2 - Articles Related OBIEE 10G/11G - Installation / ConfigurationOBIEE 10G/11G - SA System subject areaOBIEE 10G/11G - BI SchedulerOBIEE 10G/11G - How to configure the Mail server of Scheduler/DeliversOracle Business Intelligence (OBIEE/Siebel Analytics) 3 - The scheduler configuration windows To go in the configuration windows : open the administration tool in the menu : Manage / Job the job Manager open then file configuration open 4 - Database To be able to set up the database part of the Oracle BI Scheduler configuration, we need to create : a database user some tables to store the schedule informations. 4.1 - Database Scheduler User Create an S_NQ_SCHED user with the required privileges in the database by logging in to SQL* Plus as the sys or system user: SQL> CREATE USER S_NQ_SCHED IDENTIFIED BY S_NQ_SCHED DEFAULT tablespace users TEMPORARY tablespace temp quota unlimited ON users; SQL> GRANT CONNECT, resource TO S_NQ_SCHED; 4.2 - Oracle BI Scheduler Table You will find a set of files (one by database type) in the directory: for 10g: BI_ORACLE_HOME/server/Sample/Schema for 11g: ORACLE_INSTANCE/bifoundation/Oracle
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 not
S_nq_instance
post a blank message. Please type your message and try again. More discussions s_nq_job param in Business Intelligence Suite Enterprise Edition All PlacesBusiness IntelligenceBusiness Intelligence FoundationBusiness Intelligence Suite Enterprise Edition This discussion is archived 1 obiee scheduler tables Reply Latest reply on Apr 5, 2012 4:34 PM by Satya Ranki Reddy Obiee alerts error Copter Apr 5, 2012 3:34 PM Hi All, From past few days we are facing an weird http://gerardnico.com/wiki/dat/obiee/scheduler_configuration issue in our obiee alerts. We have an ibot that goes out every morning to around 100 users and some of those users started complaining saying they are getting an error instead of the data. After doing some trouble shooting i didn't found any problem an i subscribed my self to that alert i am getting the data every morning instead of error. If you guys https://community.oracle.com/thread/2372009?tstart=0 ever faced this problem if so can you tell me what might be causing this issue. Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000) This is the error they are getting. Any help appreciated. Thanks I have the same question Show 0 Likes(0) 31Views Tags: none (add) This content has been marked as final. Show 1 reply 1. Re: Obiee alerts error Satya Ranki Reddy Apr 5, 2012 4:34 PM (in response to Copter) Hi Copter , I think you have created table for ibots in your database. Please check it if table is there are not and check it. ex:- like below. •SAJOBS.xxx.sql SQL> connect S_NQ_SCHED/S_NQ_SCHED; -- create Oracle Business Intelligence Scheduler tables. SQL>@C:\OracleBI\server\Schema\SAJOBS.Oracle.sql -- create the Accounting table SQL>@C:\OracleBI\server\Schema\SAACCT.Oracle.sql Table Name Table Description S_NQ_JOB This table is used by Scheduler to store information about scheduled jobs S_NQ_INSTANCE The S_NQ_INSTANCE table stores information about scheduled job instances S_NQ_ERR_MSG This table stores error messages for Scheduler job instances that do not complete s
Hyperion 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 Suite Top Posts Customizing OBI EE https://oraclebizint.wordpress.com/2008/04/11/oracle-bi-ee-101332-changing-administrator-passwords-impact-on-bi-scheduler-and-bi-publisher-understanding-impersonation/ - SOAP API Oracle 11g - BLOB and BFile support for SQL Plus Oracle http://obieediag.blogspot.com/2008/04/how-to-setup-obiee-scheduler-on-linux.html BI EE 10.1.3.3/2 - Bins and Groups Hyperion Essbase 11.1.1.0 - Partitioning and its use cases - Transparent, Replicated and Linked partitions - Introduction Your Questions Customizing OBI EE – GO URL Parameters Oracle BI EE 10.1.3.3/2 - Executing Stored Procedures/Functions before Reports - Before Report Triggers and Global Temporary Tables Oracle BI EE 10.1.3.3/2 - obiee 11g Conditional Formatting based on Multiple Columns Hyperion Financial Reporting - Getting Started Hyperion Essbase 11.1.1.0 - Using Java APIs - Part 1 - Viewing Outline Members Pages About Me Contact Me Workshop Series Your Questions April 2008 M T W T F S S « Mar May » 123456 78910111213 14151617181920 21222324252627 282930 Archives June 2009 May 2009 April 2009 March 2009 February 2009 January 2009 December 2008 October obiee 11g scheduler 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) Comments (RSS) Meta Register Log in Entries RSS Comments RSS WordPress.com Stats « Hyperion Essbase 9.3.1 and BI Publisher Connectivity - Using BI EE as a dataBridge Oracle BI EE 10.1.3.3.2 - Hyperion Essbase 9.3.1 Value Based Hierachies (Recursive Dimensions) and handling the
my friends ask me how to setup the OBIEE scheduler on Linux. Here are the detailed steps of setting up the OBIEE scheduler on Linux in 10.1.3.3.2. Please note that this steps may be different in earlier version of Analytics (7.8.4) as introduction of cryptotools.These are the steps to setup the SchedulerSetup the DB schema for Scheduler that is used to store the runtime dataConfigure the scheduler on LinuxConfigure the presentation service in order for it to connect to SchedulerStart the Scheduler Service1. Setup the DB schema for Scheduler that is used to store the runtime dataThe very first step in setting up the scheduler is to setup the DB schema for scheduler. The DB tables are in the SQL script$INSTALLDIR/OracleBI/server/Schema/SAJOBS.Oracle.sql. Please select the DB platform specific .sql file. This blog post assume Oracle Database as your DB platform. SQL>create user S_NQ_SCHED identified by S_NQ_SCHED; SQL>grant connect,resource to S_NQ_SCHED; SQL>alter user S_NQ_SCHED default tablespace OLAP; SQL>alter user S_NQ_SCHED temporary tablespace TEMP; SQL>alter user S_NQ_SCHED quota unlimited on OLAP; SQL>connect S_NQ_SCHED/S_NQ_SCHED; SQL>@$INSTALLDIR/OracleBI/server/Schema/SAJOBS.Oracle.sql;This will setup scheduler tables S_NQ_JOB, S_NQ_JOB_PARAM, S_NQ_INSTANCE and S_NQ_ERR_MSG under schema S_NQ_SCHED.2. Configure the Scheduler on Linux-bash-3.00$ pwd /oraclebi/product/OracleBI/setup -bash-3.00$ . ./user.sh -bash-3.00$ . ./sa-init.sh -bash-3.00$ schconfigSelect Option 1 and then EnterSelect Option 1 and then EnterSelect Option 3, Enter Data Source Name. This should match the data source in tnsnames.ora file on the Scheduler Server. Select Option 4, Enter S_NQ_SCHED and Select Option 5, Enter S_NQ_SCHED. Select 0 to Quit and Save the changes.Select Option 2 - General. Specify the Scheduler Administrator user and password. It can be same as BI Server Administrator user or you can setup a new user in RPD with the Administrator group assigned to it. Select the option 4 if you want to use a different port for scheduler rather then default port of 9705. Select 0 to quit and save the changes. Again select 0 to Quit and come back to the main menu.Select option 2 to configure the email. Select 1- General to specify the email SMTP Server details. Select option 3 and 4 to specify the SMTP host name and port. On Linux, If the SendMail application running, you can use same host name as SMTP Server and port as 25. If the SendMail or the SMTP Server you are using is configured with Authentication, select Option 8 - Authenticate against the SMTP Server and set it to TRUE and specify the Username and Password that Scheduler will use to aut