OBE   OBIEE   Tutorial     
       
          Sending Alerts using Oracle BI Delivers  

 

 

 

“Creating the Metadata for BI Answers” tutorial not found

 

Q: In the Sending Alerts tutorial it lists the tutorial “Creating the Metadata for BI Answers Using Oracle Business Intelligence Administrator” as a pre-requisite.  I can’t find it anywhere?

 

The reason why you can’t find it is because it doesn’t exist.  However, the tutorial:

 

*  Creating a Repository Using the Oracle Business Intelligence Administration Tool

 

does exist, and I suspect it is this tutorial that the authors of the “Sending Alerts” tutorial have in mind!

 

 

Can’t find “agsmail.exe”

 

Q: I’m trying to download the Mail Server Freeware from ArGoSoft for the tutorial, but I can’t find the agsmail.exe link?

 

The Oracle tutorial points to the ArGoSoft download web page.  On this page there is a download link for the “Mail Server Freeware” program.  But this link downloads file “MailServerFreeSetup.msi”, which is a different file, with different installation and configuration procedures, from that of file “agsmail.exe”, which is used in the tutorial.  But you can use this file instead.

 

To install the mail server, double click on the downloaded file name, “MailServerFreeSetup.msi”.  Then select “Next => I agree :: Next => Everyone :: Next => Next => Close”.

 

If you don’t know your domain name, look up the full computer name of the machine by navigating to “Start => Control Panel => System” and selecting the “Computer Name” tab.  Use the value of the “Full computer name” field as the domain name.  But if the full computer name ends in a “.” then add, say, “com” to form the domain name; for example if the full computer name equals “obieetest.”, then the associated domain would be “obieetest.com” (adding the “.com” extension is not necessary in order to configure the mail server and to get it to work with “Outlook Express”, but the “Delivers” component of OBIEE will refuse to accept any domain name that does not have a valid Internet extension). 

 

To configure the mail server double click on the desktop icon created during the installation procedure.  Click on the “Users and Domains” icon.  When the “User and Domains” window appears, in the “Local Domains” pane click on the “New Domain” icon, and enter the domain name of your machine.  Click on the “New User” icon in the “Users” pane.  Enter “user” in the “User name” and “Password” fields, and press “OK”.  Press the green “Start” icon to start up the mail server.

 

Follow the instructions in the tutorial to set up the corresponding email account in “Outlook Express”, except that if the full computer name ended in a “.” then the “Incoming mail (POP3)” and “Outgoing mail (SMTP)” server fields should be set to the domain name without the “.com” extension (for example, “obieetest”; note that the “E-mail address” field should still be set to the domain name, “obieetest.com”).

 

Finally, and most importantly, confirm that the SMTP mail server is working by sending an email from “Outlook Express” to the email address “user@<domain name>”.  If you’ve set everything up correctly then the email should appear almost instantaneously in your in-box the moment it’s been sent.

 

 

“No Repository” when opening Job Manager

 

Q: When I open the Job Manager it says “Job Manager - No Repository” but in the tutorial it says “Job Manager - Star”.  I’ve checked the BI Server and it’s up and the Star repository is online.  Am I missing something in the setup?

 

No, you’re not.  The tutorial shows the wrong screen dump.  The “Job Manager” can be opened directly from the “Oracle Business Intelligence” menu, or it can be opened from within the “Administration Tool” when the repository is opened in online mode.  The former will show “Job Manager - No Repository” in the window title bar, while the latter will show “Job Manager - Star”.  What you’re seeing is correct given the instructions in the tutorial.

 

 

Pivot table not displayed when “Manage Display” is pressed

 

Q: In the Delivers tutorial when it comes to displaying the report on the dashboard the tutorial says to click on Manage Display, delete the table and then the pivot table should be displayed.  When I delete the table I see nothing?

 

There’s a step missing from the tutorial.  Click on “Add View” in the toolbar and select “Pivot Table” from the drop-down list.  The display will now match that in the tutorial.

 

 

Can’t save iBot: “[nQSError: 68019] Authentication Failed”

 

Q: In “My Account” when setting up the delivery options I got an error message “System Delivery Profile not available: Error finding SA System subject area”.  I continued with the tutorial but when I tried to save the iBot I got an “Oracle BI Scheduler Error: [nQSError: 68019] Authentication Failed”?

 

These errors arise due to essential, missing configuration file entries that are not discussed in the tutorial (or, indeed, in the “Installation” tutorial either).

 

When you attempt to save an iBot, Presentation Services tries to contact the Scheduler.  In order to authenticate itself it needs to know the Scheduler username and password, each of which has been set to “Administrator”.  But, with the default setup, Presentation Services does not have access to this information.

 

To eliminate this problem you need to provide the Presentation Services with the Scheduler’s username and password.  This is done first by adding an entry to the configuration file read by the Presentation Services at startup, “instanceconfig.xml”.  This entry does not, in itself, provide the necessary information, but instead it references another file, “credentialstore.xml”, which does contain the username and password.

 

Make a backup copy of file “instanceconfig.xml”.  Edit “instanceconfig.xml” and add the following lines within the “ServerInstance” tag pair:

 

<CredentialStore>
   <CredentialStorage type="file" ...
      ... path="<oracleBI home>\web\config\credentialstore.xml"/>
</CredentialStore>

 

replacing “<oracleBI home>” with the appropriate file path for your installation.

 

Make a backup copy of file “credentialstore.xml”.  Edit “credentialstore.xml” and replace its contents with the following lines:

 

<?xml version="1.0"?>
<sawcs:credentialStore ...
   ... xmlns:sawcs="com.siebel.analytics.web.credentialStore/v1">
   <sawcs:credential type="usernamePassword" alias="admin">
      <sawcs:username>Administrator</sawcs:username>
      <sawcs:password>Administrator</sawcs:password>
   </sawcs:credential>
</sawcs:credentialStore>

 

Stop and then restart the “BI Presentation Server” process.  Now try to recreate the iBot.  You should find that the error messages have disappeared.