tag:blogger.com,1999:blog-10932368417773535912024-03-08T07:30:41.236-08:00Oracle Business Intelligence Diagnostics - Complete Oracle BI SolutionNeed oracle Business Intelligence Help? Find solutions from OBIEE expertUnknownnoreply@blogger.comBlogger39125tag:blogger.com,1999:blog-1093236841777353591.post-17779728585535008322017-12-01T15:17:00.001-08:002017-12-02T14:44:57.359-08:00OAC CSV download limit OAC is external PaaS Cloud application from Oracle. It does allows the customer to change some of the configuration parameters similar to on-premise OBIEE application.<br />
<br />
But good thing is that OAC automated provisioning process itself take care of setting the correct configuration parameters based on the shape of the OAC Service instance. There should not be a need for customer to change those parameters post provisioning.<br />
<br />
For example, CSV download parameter in the instanceconfig.xml are set based on the OAC shape.<br />
<br />
Based on the Shape,<br />
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "arial" , "sans-serif"; font-size: 11.0pt;">OC3M - CSV download limit is 65K<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "arial" , "sans-serif"; font-size: 11.0pt;">OC4M - CSV download limit is 500K<o:p></o:p></span></div>
<br />
<div class="MsoNormal">
<span style="color: #1f497d; font-family: "arial" , "sans-serif"; font-size: 11.0pt;">OC5M - CSV download limit is 1M<o:p></o:p></span></div>
<br />
These values get set during provisioning and there should not be a need to change it further unless really needed.<br />
<br />
OAC have two separate configuration settings for limiting excel and csv downloads, DefaultRowsDisplayedInDownload and DefaultRowsDisplayedInDownloadCSV respectively.<br />
<br />
<span style="background-color: white; color: #333333; font-family: "arial" , sans-serif; font-size: 14px;"><br /></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-15250206951041365862017-12-01T15:11:00.001-08:002017-12-01T15:11:23.885-08:00BICS report execution result in "the user request exceeded the maximum query governing execution time"Some of the reports in BICS results in following error but same report in on-premise OBIEE run successfully against the same Datawarehouse.<br />
<br />
<span id="form1:panelPage1">Odbc driver returned an error (SQLExecDirectW).<br /> Error Details<br />Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P<br />State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.<br />Please have your System Administrator look at the log for more details on this error. (HY000)<br />State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.<br />Please have your System Administrator look at the log for more details on this error. (HY000)<br />State: HY000. Code: 43119. [nQSError: 43119] Query Failed:<br />Please have your System Administrator look at the log for more details on this error. (HY000)<br />State: HY000. Code: 60009. [nQSError: 60009] The user request exceeded the maximum query governing execution time.<br />Please have your System Administrator look at the log for more details on this error. (HY000)<br />Please have your System Administrator look at the log for more details on this error. </span><br />
<span><br /></span>
<span>This is due to the Query governor set in BICS. Given that BICS is a cloud service and in cloud, user query need to be controlled in order to make sure environment is stable and can scale. This is done by introducing the query governors. Query execution timeout is set to 600 seconds and this is hard limit. Customer cannot request to change this hard limit for their BICS instance so report need to be re-design so that DB query runs within 600 seconds.</span><br />
<span><br /></span>
<span>This limitation will not be there in OAC since OAC is external PaaS and customer will be able to change the limit as per their own requirement. </span><br />
<span><br /></span>
<span><br /></span>
<br />
<span><br /></span>
<span><br /></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-39676478773322740552017-12-01T13:58:00.000-08:002017-12-01T13:58:33.210-08:00<strong><u>DAC 11.1.1.6.4 intermittent Crash</u></strong>
<br />
<br /><br />
<br />
<br />
It has been notice DAC 11.1.1.6.4 Server crash intermittently and it need to be restarted. Crash is following. <br />
<br /><br />
<br />
<br />
# A fatal error has been detected by the Java Runtime Environment:
<br />
<br />
<br />
#
# SIGSEGV (0xb) at pc=0x00007fcf752b21b0, pid=112882, tid=140528723429696
<br />
#
# JRE version: Java(TM) SE Runtime Environment (7.0_80-b15) (build 1.7.0_80-b15)<br />
# Java VM: Java HotSpot(TM) 64-Bit Server VM (24.80-b11 mixed mode linux-amd64 compressed oops)
<br />
# Problematic frame:<br />
# V [libjvm.so+0x6541b0] jni_GetLongArrayRegion+0xd0
<br />
#
# Failed to write core dump. Core dumps have been disabled. To enable core dumping, try "ulimit -c unlimited" before starting Java again<br />
#
# An error report file with more information is saved as:
# /oraclebi/DAC11G/dac/hs_err_pid112882.log
<br />
#
# If you would like to submit a bug report, please visit:<br />
# <a href="http://bugreport.java.com/bugreport/crash.jsp">http://bugreport.java.com/bugreport/crash.jsp</a><br />
#
ORA-24550: signal received: [si_signo=6] [si_errno=0] [si_code=-6] [si_int=0] [si_ptr=(nil)] [si_addr=0x4e220001b8f2]
kpedbg_dmp_stack()+362<br />
<br />
<br />
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<b><span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">Reference:</span></b></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<b><span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;"> </span></b></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<b><span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">ORA-24550 Signal Received Error From Client Based Application
(Doc ID 1284564.1)</span></b></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;"> </span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<b><span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">CAUSE</span></b></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;"> </span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">Diagnosability features which are turned on by default on Oracle
11g Release 2 causes the problem.</span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">Parameters are: </span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">DIAG_ADR_ENABLED </span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">DIAG_SIGHANDLER_ENABLED </span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">DIAG_DDE_ENABLED </span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;"> </span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<b><span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">SOLUTION</span></b></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;"> </span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">1. Such errors can occur if the "Diagnosability"
features are 'ON'.</span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">To turn off the OCI signal handler and re-enable standard
Operating System failure processing, place the following parameter setting in
sqlnet.ora:</span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">DIAG_SIGHANDLER_ENABLED=FALSE</span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">By default this parameter is set to true.</span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">If you want to see the old behavior you can simply turn off the
feature by placing the following parameter setting in your client side
sqlnet.ora file under $ORACLE_HOME/network/admin directory.</span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">2. In addition, please turn off other Diagnostics parameters as
well by placing the following entries in the client side or server sqlnet.ora
file. i.e., from where the application is run.</span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">DIAG_ADR_ENABLED=OFF</span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">DIAG_SIGHANDLER_ENABLED=FALSE</span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">DIAG_DDE_ENABLED=FALSE</span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;"> </span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">Note:</span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">Changes to client side SQLNET.ORA requires only application
restart.</span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;">Where as changes to SQLNET.ORA on Database side requires only
restart of the listener.</span></div>
<br />
<br />
<div style="margin: 0in 0in 0pt;">
<span style="color: #1f497d; font-family: "calibri" , "sans-serif"; font-size: 11pt;"> </span></div>
<br />Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-15249076299540441932009-12-17T19:36:00.001-08:002009-12-17T19:42:11.093-08:00FDM Application Migration - Page Not FoundWhen you migrate FDM application from one environment to another, one thing you need to remember to use the exactly same UNC path for the application. If the UNC path is different on the Target application, then you may see "Page Not found" error while performing the Import data file operation.<br /><br />If the source application have UNC \\HostName\Apps\FDMapp, then Target application should be \\Hostname\Apps\FDMappUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-25180627508503570932009-06-12T22:05:00.000-07:002009-06-12T22:08:37.890-07:00Testing Essbase or Planning Connection from Oracle Data Integrator (ODI) results in errorWhen testing Essbase or Planning Data Server connection from ODI results in "Driver Must be Specificed" error and below is the call stack in the error.<br /><br />ava.sql.SQLException: Driver must be specified<br /><br /> at com.sunopsis.sql.SnpsConnection.a(SnpsConnection.java)<br /><br /> at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java)<br /><br /> at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java)<br /><br /> at com.sunopsis.graphical.l.pm.o(pm.java)<br /><br /> at com.sunopsis.graphical.l.pm.r(pm.java)<br /><br /> at com.sunopsis.graphical.l.pm.g(pm.java)<br /><br /> at com.sunopsis.graphical.l.pm.a(pm.java)<br /><br /> at com.sunopsis.graphical.l.pm.a(pm.java)<br /><br /> at com.sunopsis.graphical.l.iz.actionPerformed(iz.java)<br /><br /> at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)<br /><br /> at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknown Source)<br /><br /> at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)<br /><br /> at javax.swing.DefaultButtonModel.setPressed(Unknown Source)<br /><br /> at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)<br /><br /> at java.awt.Component.processMouseEvent(Unknown Source)<br /><br /> at java.awt.Component.processEvent(Unknown Source)<br /><br /> at java.awt.Container.processEvent(Unknown Source)<br /><br /> at java.awt.Component.dispatchEventImpl(Unknown Source)<br /><br /> at java.awt.Container.dispatchEventImpl(Unknown Source)<br /><br /> at java.awt.Component.dispatchEvent(Unknown Source)<br /><br /> at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)<br /><br /> at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)<br /><br /> at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)<br /><br /> at java.awt.Container.dispatchEventImpl(Unknown Source)<br /><br /> at java.awt.Window.dispatchEventImpl(Unknown Source)<br /><br /> at java.awt.Component.dispatchEvent(Unknown Source)<br /><br /> at java.awt.EventQueue.dispatchEvent(Unknown Source)<br /><br /> at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)<br /><br /> at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)<br /><br /> at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)<br /><br /> at java.awt.Dialog$1.run(Unknown Source)<br /><br /> at java.awt.Dialog.show(Unknown Source)<br /><br /> at java.awt.Component.show(Unknown Source)<br /><br /> at java.awt.Component.setVisible(Unknown Source)<br /><br /> at com.sunopsis.graphical.l.pm.q(pm.java)<br /><br /> at com.sunopsis.graphical.l.pm.<init>(pm.java)<br /><br /> at com.sunopsis.graphical.frame.b.jh.bx(jh.java)<br /><br /> at com.sunopsis.graphical.frame.bo.w(bo.java)<br /><br /> at com.sunopsis.graphical.frame.bo.d(bo.java)<br /><br /> at com.sunopsis.graphical.frame.w.actionPerformed(w.java)<br /><br /> at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)<br /><br /> at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknown Source)<br /><br /> at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)<br /><br /> at javax.swing.DefaultButtonModel.setPressed(Unknown Source)<br /><br /> at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)<br /><br /> at java.awt.Component.processMouseEvent(Unknown Source)<br /><br /> at java.awt.Component.processEvent(Unknown Source)<br /><br /> at java.awt.Container.processEvent(Unknown Source)<br /><br /> at java.awt.Component.dispatchEventImpl(Unknown Source)<br /><br /> at java.awt.Container.dispatchEventImpl(Unknown Source)<br /><br /> at java.awt.Component.dispatchEvent(Unknown Source)<br /><br /> at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)<br /><br /> at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)<br /><br /> at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)<br /><br /> at java.awt.Container.dispatchEventImpl(Unknown Source)<br /><br /> at java.awt.Window.dispatchEventImpl(Unknown Source)<br /><br /> at java.awt.Component.dispatchEvent(Unknown Source)<br /><br /> at java.awt.EventQueue.dispatchEvent(Unknown Source)<br /><br /> at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)<br /><br /> at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)<br /><br /> at java.awt.EventDispatchThread.pumpEvents(Unknown Source)<br /><br /> at java.awt.EventDispatchThread.pumpEvents(Unknown Source)<br /><br /> at java.awt.EventDispatchThread.run(Unknown Source)<br /><br /><br />This is the expected error. You can only test the JDBC connection, not Essbase,Planning and HFM connection. <br /><br />It is ok to ingnore this error and move forward inserting the Physical Schema.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-34000969833376288692009-06-03T21:07:00.000-07:002009-06-03T21:33:58.001-07:00How to setup Hyperion BIPlus with Custom PortsWhen you deploy Hyperion application, there may be a need to deploy Hyperion BIPlus where there is firewall between Server and Client. In this case, you cannot deploy BIPlus with Default ports as BIPlus uses dynamic ports and due to Security reasons, you cannot open tons of ports through the Firewall.<br /><br />In such case, it make more sense to deploy BIPlus with Static Ports, that can be opened on Firewall. <br /><br />To Deploy Hyperion BIPLus with Static Ports<br /><br /> - Set the RMI Server port in fr_global.properties<br /><br /> RMIPort=<br /><br /> - Set the ports for FR Server in fr_repserver.properties<br /><br /> HRRepSvrPort1=<br /> <br /> HRRepSvrPort2=<br /><br /> - Run the Configuration Utility for BIPlus and set the static ports for <br /> <br /> GSM Port<br /> Core Service Port<br /> Name Service Port<br /> Service Broker Port<br /> Job Service Port<br /> Event Service Port<br /> Repository Service Port<br /><br /> - Set the Planning ADM RMI Server port in ADM.properties file under <Hyperion_Home>\common\ADM\9.3.1\lib<br /><br /> ADM_RMI_PORT=<br /> ADM_RMI_SERVER_PORT=<br /><br /> ADM_RMI_PORT will be same as RMI port in fr_global.properties file.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-19295361321558505372009-05-31T20:28:00.000-07:002009-05-31T20:47:28.811-07:00Informatica 8.1.1 install fail on WindowsInformatica 8.1.1 install on Windows 2003 may results in following error. This error occur when installer try to configure the domain. <br /><br />STDOUT: Installing the service '"Informatica Services 8.1.1"' on node ''...<br /><br />Using CURRENT_DIR: D:\Hyperion\Informatica\PowerCenter8.1.1\server\tomcat\bin<br /><br />Using INFA_HOME: D:\Hyperion\Informatica\PowerCenter8.1.1<br /><br />The service '"Informatica Services 8.1.1"' has been installed.<br /><br />The Informatica Services 8.1.1 service is starting.<br /><br /> <br /><br />STDERR: '"D:\Hyperion\Informatica\PowerCenter8.1.1\server\bin\infacmd.bat" getNodeName' is not recognized as an internal or external command,<br /><br />operable program or batch file.<br /><br />The Informatica Services 8.1.1 service could not be started.<br /><br />The service did not report an error.<br /><br /><br />More help is available by typing NET HELPMSG 3534.<br /><br />This may occur due to COMSPEC environment variable on Windows Server. If this variable is not pointing to correct CMD.exe executable, this issue may arise. Check this environment variable. It should be c:\windows\system32\cmd.exe.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-5631317713178866232009-05-31T20:06:00.000-07:002009-05-31T20:27:34.225-07:00How do I upgrade Informatica Hyperion Repository from 7.1.4 to 8.1.1During the Hyperion upgrade from System 9 to Hyperion 11.1.1.1, there may be a need to upgrade the existing Hyperion DIM repository from 7.1.4 to 8.1.1 so that it can be used with Informatica 8.1.1.<br /><br />Lets assume that you are setting up the new Hyperion 11.1.1.1 environment with DIM 8.1.1. and now you need to use the old Hyperion DIM repository that exists in System 9 environment. <br /><br /> - Export the DIM Schema from system 9 Database and import it into Target 11.1.1.1 environment<br /> - Create a new Repository Service into Target in Admin Console and associate it with imported schema from System 9<br /> - If you try to start the Repository Service, it will not start as the Repository Version is different from that shipped with Informaitca 8.1.1.<br /> - You need to upgrade the Repository first, before starting it. To upgrade the repository, click on Action -> Upgrade Content in the Admin console for the Repository Service. You need to provide the Repository UserId/PWD Administrator/Administrator to initiate the upgrade process. Once the upgrade is successful, you should be able to start the repository.<br /><br />Note: Before importing the DIM Schema from System 9 environment, DISABLE the Authentication Module. With Authentication Module turned on in the System 9 environment, you will not be able to associate the Repository Service with the DIM repository database imported from System 9 environment. You can disable the Authentication plug-in using the Repository Admin Console.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-64193970946502269422009-05-31T19:49:00.000-07:002009-05-31T19:54:58.626-07:00Importing DIM Repository with Japanese Code PageWhen you import a DIM Hyperion repository from Japanese Code Page environment to a new 8.1 ENU environment, you will see the below error.<br /><br /><br />[[REP_61082] AdminConsole's code page (MS Windows Latin 1 (ANSI), superset of Latin1) is not one-way compatible to repository Hyperion's code page (MS Windows Japanese, superset of Shift-JIS). Failed to connect to repository service [Hyperion].]<br /><br />This error indicate that Hyperion repository is with Shift-JIS code page, but the Gateway/Node running with Latin 1 code page.<br /><br />If you need to import and run the Hyperion repository with Shift-JIS code page, you need to set the PM_CODEPAGENAME environment variable in the Target environment to MS932. This environment variable indicate the code page of the Gateway/Node. After this, you can import the Hyperion repository with Shift-JIS code page into 8.1 target environment.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-50410229399951626662008-10-09T18:24:00.000-07:002008-10-09T18:28:33.365-07:00Excel Add-in crash with Excel 2007 on Win XP SP3We oberverved one issue with Excel Add-in and Excel 2007 on XP SP3.<br /><br />1. Open Excel and connect to the Essbase server.<br />2. Do Retrieve<br />3. Double click on any member. Closes the whole excel.<br />4. Appears the following message:<br /><br />" The Microsoft Office Excel found a problem and need be closed. We regret the incovenience"<br /><br />Issue specific to Windows XP SP3.<br /><br />Patch 7317818 and 7035861 resolve this issue. The fix is available in 9.3.1.2.6.Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-1093236841777353591.post-36516083662371588422008-10-03T21:06:00.000-07:002008-10-04T19:31:40.533-07:00Essbase crash on LinuxWe noticed several crash of Essbase process (ESSSRVR) on Linux, specially when users are doing restructuring and running calculations. Call Stack in the exception log look like this. <br /><br /><br />Process Type: Application<br />Application Name: XXXXX<br />Database Name: XXXXX<br />Exception Log File: /essbase/Hyperion/AnalyticServices/app/XXXX/XXXX/log00001.xcp<br />Current Thread Id: -1499931744<br />Signal Number: 0x11=Segmentation Violation<br />Signal Code: 0x-168009176=Unknown<br /><br /> <br /><br />----- Stack Trace -----<br /><br /> <br /><br />[0] /essbase/Hyperion/AnalyticServices/bin/libessutlu.so(adXcptWriteStackInfo+0x3e) [0xf73ad7de]<br />[1] /essbase/Hyperion/AnalyticServices/bin/libessutlu.so(adXcptCreateRpt+0x224) [0xf73ac8cc]<br />[2] /essbase/Hyperion/AnalyticServices/bin/libessutlu.so(adXcptHandlerDiag+0x83) [0xf73ac62b]<br />[3] /essbase/Hyperion/common/JRE/Sun/1.5.0/lib/i386/server/libjvm.so [0xf5e2ae4d]<br />[4] /essbase/Hyperion/common/JRE/Sun/1.5.0/lib/i386/server/libjvm.so [0xf5e28c7f]<br />[5] /essbase/Hyperion/common/JRE/Sun/1.5.0/lib/i386/server/libjvm.so(JVM_handle_linux_signal+0x1d8) [0xf5e2b6b8]<br />[6] /essbase/Hyperion/common/JRE/Sun/1.5.0/lib/i386/server/libjvm.so [0xf5e28ba4]<br />[7] [0xffffe600]<br />[8] /essbase/Hyperion/AnalyticServices/bin/libesssvrd.so(adCalmExec+0x64e) [0xf7bf4a5a]<br />[9] /essbase/Hyperion/AnalyticServices/bin/libesssvrd.so(adCalcCSCR+0x5fe) [0xf7bcb4b6]<br />[10] /essbase/Hyperion/AnalyticServices/bin/libesssvrd.so(adCalcCSCR+0x2040) [0xf7bccef8]<br />[11] /essbase/Hyperion/AnalyticServices/bin/libesssvrd.so(adCalcCSCR+0x6eb) [0xf7bcb5a3]<br />[12] /essbase/Hyperion/AnalyticServices/bin/libesssvrd.so(adCalcScrCalc+0xf5) [0xf7bcad01]<br />[13] /essbase/Hyperion/AnalyticServices/bin/libesssvrd.so(EpXSvrCalcExec+0x484) [0xf7d987dc]<br />[14] /essbase/Hyperion/AnalyticServices/bin/libesssvrd.so [0xf7d9ce47]<br />[15] /essbase/Hyperion/AnalyticServices/bin/libesssvrd.so(EpXSvrDispatch+0xf8) [0xf7d98350]<br /><br />We noticed that the VM for the ESSSRVR process was very high. Even for Sample application, VM was around 1.5G. That pretty high. Since Essbase is 32-bit application, it can only address 2GB of memory. Since restructuring/calc need more memory, chances are that process can go beyond 2GB, hence crash.<br /><br />We changed one of the parameter in Essbase.cfg file. Set the JvmModuleLocation to blank. <br /><br />; JvmModuleLocation /essbase/Hyperion/common/JRE/Sun/1.5.0/lib/i386/server/libjvm.so<br />JvmModuleLocation<br /><br />After this, ESSSRVR process will not load the JVM, hence the VM for the process will be low. After this change, VM for sample application was around 350M as compare to 1.5G. This will give sufficient room for the process to grow when users are doing restructuring/calc. <br /><br />After this change, we did not notice the similar crash.<br /><br />Wish we had Essbase 64-bit on Linux available so that we will not hit this limitation.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-47658675164382605812008-09-28T16:44:00.000-07:002008-09-28T16:59:13.592-07:00BI Publisher Logging fail in 10.1.3.2In out of the box OBIEE/BI Publisher configuration, logging to BI Publisher fail with default user Administrator/Administrator.<br /><br />In default configuration, it was observed that the authentication mechanism was set to OBIEE Server, instead of BI Publisher. Configuration file of BI Publisher is /oraclebi/product/OracleBI/xmlp/XMLP/Admin/Configuration. <SECURITY_MODEL> tag in this file determines the authentication mechanism for BI Publisher. Default value is BI_SERVER. <br /><br />In order to use BI Publisher authentication mechanism, set SECURITY_MODEL tag value to XDO.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-89265515753829684782008-05-27T15:42:00.000-07:002008-05-27T15:45:52.889-07:00Planning Apps not visible in WorkspaceWhen we launched the Workspace and went to Navigate -> Applications, no planning application visible. But when we use the EAS console, we can see all the application under the Essbase and they are running.<br /><br />It might happen if you have re-started the Essbase server. <br /><br />Please make sure to re-start the Planning application if you re-started the Essbase for some reasons. If you re-start Essbase, but not planning, you may see some weired behaviors.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-34741092499884690422008-05-25T17:09:00.000-07:002008-05-25T17:17:44.521-07:00Start/Stop Essbase server on LinuxSource the Essbase environment variables.<br /><br />HYPERION_HOME=/essbase/Hyperion;export HYPERION_HOME<br />ARBORPATH=/essbase/Hyperion/AnalyticServices;export ARBORPATH<br />ESSLANG=English_UnitedStates.Latin1@Binary;export ESSLANG<br />#LD_LIBRARY_PATH=$HYPERION_HOME/common/JRE/Sun/1.5.0/lib/i386/server:$HYPERION_HOME/common/JRE/Sun/1.5.0/lib/i386:$HYPERION_HOME/common/JRE/Sun/1.5.0/lib/i386/server:$HYPERION_HOME/common/JRE/Sun/1.5.0/lib/i386:$HYPERION_HOME/common/ODBC/Merant/5.2/lib:$ARBORPATH/bin:$LD_LIBRARY_PATH<br />#Use following if your deployment does not require CDF,CDM,Data mining,Single Sign-on or Triggers<br />LD_LIBRARY_PATH=$HYPERION_HOME/common/JRE/Sun/1.5.0/lib/i386/server:$HYPERION_HOME/common/JRE/Sun/1.5.0/lib/i386:$HYPERION_HOME/common/ODBC/Merant/5.2/lib:$ARBORPATH/bin:$LD_LIBRARY_PATH;export LD_LIBRARY_PATH<br />PATH=$ARBORPATH/bin:$PATH;export PATH<br />ODBCINI=$HYPERION_HOME/common/ODBC/Merant/5.2/odbc.ini<br /><br />To start the Essbase server<br /><br />$./startEssbase.sh <PWD> -b &<br /><br />To Stop the Essbase server<br /><br />$./essmsh -l asadmin <PWD><br />MAXL> alter system shutdown;Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-73872634087404352562008-05-23T20:07:00.000-07:002008-05-23T20:22:47.505-07:00PLP_GLRevnGroupAccount_A_Stage_Full Informatica ETL Mapping SlowIn one of the project, we have seen that out of the box mapping PLP_GLRevnGroupAccount_A_Stage_Full in Informaitca was taking really long time. In full ETL, this mapping took almost 30 hours. <br /><br />After reviewing the Session log, it was found that most of the time was taken in the Reader thread. Since the issue was with the source SQL, the same SQL was run from the SQLPlus and it run in 1 hour only. <br /><br />After reviewing the informatica configuration, it was found that Informatica server was forced to use some pre-sql to change the Database session settings.<br /><br />alter session set optimizer_index_cost_adj=1;<br />alter session set optimizer_index_caching=10;<br /><br />These session pre-sql change the explain plan for the optimizer and optimizer was not performing well with the Source Query. But it perform well for other mapping. <br /><br />It was advised to remove these pre-sql at the global level but use at the mapping level if they perform well with these pre-sqls.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-56565653988765234242008-05-18T19:50:00.001-07:002008-05-18T19:59:59.322-07:00DAC and serverSetupPrompt.shThere is no DAC Server setup on Unix platform. You need to setup the Analytics client on the Windows Machine first and then move the DAC folder to the Unix platform. After the DAC folder is moved and if you try to run any of the .sh script, you may see some wired behavior. For Example, when you try to run the serverSetupPrompt.sh, you may see the following error.<br /><br />Exception in thread "main" java.lang.NoClassDefFoundError: com/siebel/etl/gui/login/TextModeServerSetup <br /><br />If you try to run other .sh file, you may notice that environment variables are not setup correctly. <br /><br />When you move the DAC folder to Unix, you need to make sure to run the dos2unix utility to remove CR+LF characters from all the .sh files. If you do not run dos2unix utility, then none of the .sh file will work on the Unix platform as expected. You can download the dos2unix utility from http://www.download3k.com/Install-Dos2Unix.htmlUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-1443099385893807692008-05-18T16:57:00.000-07:002008-05-18T17:05:16.383-07:00Qserver is already bound to the portSometime when you start the DAC Server on Unix, you will notice the error in the DAC Server log.<br /><br />Qserver is already bound to the port 3141. <br /><br />It was observed that when the DAC Server was shutdown on the Linux using the stopserver.sh script, QServer JAVA Process was not went down and it was still running. <br /><br />When you shutdown the DAC Server, you need to make sure that JAVA Process QServer also went down. If not, then you have to kill the JAVA Process before starting the DAC server again.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-77196974330703773162008-05-18T16:38:00.000-07:002008-05-18T16:47:09.475-07:00MESSAGE:::Cannot run program "pmcmd": CreateProcess error=2, The system cannot find the file specifiedWhen you attempt to register the Informatica servers in DAC and click the "Test" button, the test may fail with the below error.<br /><br />SEVERE Thu Jan 11 18:52:41 EDT 2008 <br /><br /> MESSAGE:::Cannot run program "pmcmd": CreateProcess error=2, The system cannot find the file specified<br /><br />In order to troubleshoot this error, try to run the pmcmd and pmrep command from the command window and see if you can run those. If not, then it means that PATH environment is not set correctly.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-21735159367715084172008-05-18T09:24:00.000-07:002008-05-18T09:36:05.423-07:00ORA-01652: unable to extend temp segment by 32 in tablespace TEMP while running ETLYou may receive the error ORA-01652: unable to extend temp segment by 32 in tablespace TEMP while running the ETL, specially when tables are huge. If the SELECT statement is running against the tables which have 70-80 million rows, and the optimizer is doing the hash join, it will make use of TEMP and hash-area size to build the hash. If the TEMP tablespace is not big enough, then you may receive this error. There is no one value fit all the sizes, but in our case, with 100GB of space for TEMP tablespace resolve this error. You may have to set this to higher value if you have more than 100 million of rows in the tables. <br /><br />Do not change the explain plan to make use of NESTED LOOP, because initially optimizer will take more space and time to build the hash but once the hash is built, query results will be much faster and it will perform better than NESTED_LOOP.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-29837412799506742242008-05-17T14:21:00.000-07:002008-05-17T14:28:41.435-07:00Client Commands are Currently Not Being AcceptedIf you receive the error "Client Commands are Currently Not Being Accepted" while performing some operation in the Essbase Database, it seems that some restructuring is happing for the Database. It is possible that some user has started some Calc script, which is forcing the restructure of database, then you cannot run any commands on the database until restructuring completes.<br /><br />You can replicate this error with the following sequence of command.<br /><br />Force the Essbase Database Restructure<br /><br />MAXL> alter database Sample.Basic force restructure;<br /><br />And then immediately run some command against the database like ESSCMD GETDBINFO or GETDBSTATS and you will see the followinng error.<br /><br />localhost:Sample:basic:asadmin[1]->getdbinfo<br />GetDbInfo:<br /><br /><br />[Sat May 17 12:37:31 2008]localhost/Sample/basic/asadmin/Error(1013204)<br />Client Commands are Currently Not Being Accepted<br /><br />Command Failed. Return Status = 1013204Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-32764817588103449142008-05-17T14:16:00.000-07:002008-05-17T14:20:54.528-07:00Hyperion Essbase Database ValidationHow to check if Essbase database really corrupted? <br /><br />If the Essbase database really corrupted, then you will not be able to start it up. Database will not be loaded if it corrupted. If the database loaded with no problem, then you can force to restructure the database using the following MaxL command. <br /><br />alter database Sample.Basic force restructure;<br /><br />If the restructure complete successfully, then it indicate that database is not corrupted.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-14209560605264799302008-05-17T14:08:00.000-07:002008-05-17T14:14:33.829-07:00NQCMD and CacheIn one of my project, customer did not had the OBIEE Scheduler setup, so iBot was not an option to seed the cache. But still customer want to seed the cache and clear it after the ETL run finish. <br /><br />NQCMD is one of the option to achive this. We used NQCMD utility to clear the cache and then seed it by running the logical queries for the Reports. For example<br /><br />working_dir='/oraclebi/product/OracleBI'<br />cd $working_dir<br />cd setup<br />. ./user.sh<br />. ./common.sh<br />. ./sa-cli.sh<br />cd ..<br />nqcmd -d AnalyticsWeb -u Administrator -p SADMIN -s cmd.txt -o out.txt<br /><br />In the cmd.txt, use the following. <br /><br />{call SAPurgeAllCache()};<br />SELECT Time."Fiscal Quarter" saw_0, "Facts - AR Payments Due Aging"."AR Due1-30 Amount" saw_1, "Facts - AR Payments Due Aging"."AR Due 31-60 Amount" saw_2, "Facts - AR Payments Due Aging"."AR Due 61-90 Amount" saw_3, "Facts - AR Payments Due Aging"."AR Due 90+ Amount" saw_4, "Facts - AR Payments Due Aging"."Total AR Due Amount" saw_5, "Facts - AR Payments Due Aging"."AR Due 1-30 Amount to Total Due %" saw_6, "Facts - AR Payments Due Aging"."AR Due 31-60 Amount to Total Due %" saw_7, "Facts - AR Payments Due Aging"."AR Due 61-90 Amount to Total Due %" saw_8, "Facts - AR Payments Due Aging"."AR Due 90+ Amount to Total Due %" saw_9, "Facts - AR Payments Due Aging"."AR Due Amount to Total %" saw_10 FROM "Financials - AR Overview" WHERE ((Time."Fiscal Quarter" <= VALUEOF(CURRENT_FSCL_QUARTER)) AND (Time."Fiscal Quarter" > VALUEOF(FSCL_QTR_YEAR_AGO))) ORDER BY saw_0;<br />SELECT Time."Fiscal Year" FROM "Financials - AR Overview" WHERE Time."Fiscal Year" BETWEEN valueof(FILTER_FSCL_FROM_YEAR) AND valueof(FILTER_FSCL_TO_YEAR) ORDER BY 1 DESC;<br />SELECT Time."Fiscal Quarter" FROM "Financials - AR Overview" WHERE Time."Fiscal Year" BETWEEN valueof(FILTER_FSCL_FROM_YEAR) AND valueof(FILTER_FSCL_TO_YEAR) ORDER BY 1 DESC;<br /><br />The cmd.txt first clear the cache and then seed it by running all the logical queries for each report customer has.<br /><br />If you have BI on Unix Platform, you can setup this as Cron job.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-90948847287228060662008-05-14T23:51:00.000-07:002008-05-15T00:03:31.230-07:00SIL_GLRevenueFact_GL_Info_Update and SIL_ARTransactionFact_Gl_Info_UpdateI have seen some performance issues with SIL_GLRevenueFact_GL_Info_Update and SIL_ARTransactionFact_Gl_Info_Update mapping. The issue is with both Full run and Incremental run. The throughput is really low, around 90-100 rows per second. We have notice this throughput when the target table W_GL_REVN_F has 20-30 million rows.<br /><br />With 20-30 million rows in the target table, these mapping takes 48-72 hours for the full run. <br /><br />The only workaround we found was to update the target table directly in the database and setting the DAC task as Completed. You can use MERGE statement in Oracle DB to update the target table, which is more optimized than UPDATE and INSERT combination. For example<br /><br />MERGE INTO W_GL_REVN_F A USING W_GL_REVN_F_TMP B<br />ON (A.INTEGRATION_ID = B.INTEGRATION_ID AND A.DATASOURCE_NUM_ID = B.DATASOURCE_NUM_ID)<br />WHEN MATCHED THEN<br />UPDATE SET <br />A.ACCT_DOC_NUM = B.ACCT_DOC_NUM,<br />A.ACCT_DOC_ITEM = B.ACCT_DOC_ITEM,<br />A.ACCT_DOC_SUB_ITEM = B.ACCT_DOC_SUB_ITEM,<br />A.DOC_HEADER_TEXT = B.DOC_HEADER_TEXT,<br />A.LINE_ITEM_TEXT = B.LINE_ITEM_TEXT,<br />A.DOC_STATUS_WID = B.DOC_STATUS_WID,<br />A.POSTED_ON_DT_WID = B.POSTED_ON_DT_WID,<br />A.POSTED_ON_TM_WID = B.POSTED_ON_TM_WID,<br />A.GL_RECONCILED_ON_DT = B.GL_RECONCILED_ON_DT,<br />A.GL_RECONCILED_ON_PROC_WID = B.GL_RECONCILED_ON_PROC_WID,<br />A.DELETE_FLG = B.DELETE_FLG,<br />A.W_UPDATE_DT = B.W_UPDATE_DT,<br />A.ETL_PROC_WID = B.ETL_PROC_WID;<br /><br /><br />Here W_GL_REVN_F_TMP is the temp table, which was setup and it has the output of the original SIL_GLRevenueFact_GL_Info_Update mapping. This TEMP table was populated from the Source SQL of SIL_GLRevenueFact_GL_Info_Update. <br /><br />Same solution was used for SIL_ARTransactionFact_Gl_Info_Update. <br /><br />We used this workaround only for Full ETL. Incremental run is also slow for these 2 mappin but sine the insert/update are not that much, they are executing in our expeted duration of maintenance window.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-78908263841087199782008-05-14T22:15:00.001-07:002008-05-14T22:22:35.762-07:00Cannot transition the state of database [XXX_XXX] between read-write and read-only modes while other users are connected to the databaseWe have a backup script, which fire every night and make use of ESSCMD commands to take the Essbase File system backup. This script <br /><br />- Put all the database in read-only mode using BEGINARCHIVE command<br />- Take the file system backup<br />- Put all the database in read-write mode using ENDARCHIVE command<br /><br />We have notice sometime the below error.<br /><br />[Mon Dec 11 18:18:00 2006]Local/ESSBASE0///Error(1013239)<br />Cannot transition the state of database [XXX_XXX] between read-write and read-only modes while other users are connected to the database.<br /><br />This error was due to some Calulation script, end user was running at the time of the backup. Due to that calcualtion script, BEGINARCHIVE was not able to put the database into read-only mode. <br /><br />I think if you use the LOGOUTALLUSERS command just before the BEGINARCHIVE, it should logout all the users from the system, including the current Calc script running. It should suspend all the operation, users might be running at that point. Though we are educating our users not to run any database restructuring job in the scheduled backup window.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1093236841777353591.post-44146252386715165962008-05-11T19:00:00.000-07:002008-05-11T19:19:12.827-07:00OBIEE and PeopleSoftOracle Business Intelligence (OBIEE) provides out of the box RPD and Webcatalog for Peoplesoft EPM Warehouse. You can download Fusion Intelligence for Peoplesoft 9.0 or 8.9 software from the eDelivery site and this will give you out of the box RPD and Webcatalog. Just deploy this RPD and Webcatalog and change the DB connection in RPD to Peoplesoft EPM Warehouse and you are all set. No need to worry about DAC, Informatica as EPM Warehouse is using the PeopleSoft technology to populate it. You are just using OBIEE as a presentation layer against Peoplesoft EPM Warehouse. It also has the in-built data security. <br /><br />Fusion Intelligence for Peoplesoft solution is applicable for those customers who already have the EPM Warehouse and just need the OBIEE for Presentation Layer.Unknownnoreply@blogger.com4