DAC email does not work as expected (Notification levels are ignored)

I have set up DAC to send emails to users (As per my previous entry- http://obieetips.blogspot.com/2010/02/dac-email-notification.html ), whenever the data load completes.
However, I have two problems.

1.
The email notifications do not work as expected.
Level 1 sends only failure emails but not success emails.
This is an open bug with oracle and the solution is to use Level 5 for the moment.
Level 5 works as expected- which is to send 'Running' as well as 'Failure'/'Success' emails, everytime an ETL load is started and completed.
This can be quite overwhelming for the users.
A bug already exists for this issue so we are eagerly awaiting a patch.
BUG:9133839 - DAC IGNORES NOTIFICATION LEVELS DEFINED FOR EMAIL RECIPIENTS

2.
The above email notifications are a bit too verbose for users who have limited time to check on the ETL status. Due to this I asked Oracle support if there was a way to change the email content so as to limit the amount of information to be sent over email to 'non-developers'. Unfortunately there is no way to modify the emails in version 10.1.3.4. It is part of the upcomign enhancements. I am looking forward to 11g.
ER is 7425308 / 8989562

Please let me know if you have any workarounds that we may be able to try or have any more updates on the latest from Oracle.

Thanks for reading,
Anisha

DAC Email notification

DAC can be set up to send email in just a few steps.
This is also useful when you want to send only one success email from a number of infomatica workflows which are scheduled to run through DAC.
The DAC server has a built-in login-authentication based email (SMTP) client, which connects to any SMTP login-authenticating server to send emails.

Unlike informatica which needs the outlook client installed on the server, DAC does not.
1. Set up email recipients
2. configure email sender information



1. To set up email recepients:
Launch the DAC client.

Click Setup on the DAC toolbar, and then click the Email Recipients tab.
Click New.
In the Edit tab below, enter the relevant information for the recipient

Referenced Link:
http://download.oracle.com/docs/cd/E12104_01/books/AnyInstAdm/AnyInstAdmWinInstall24.html
http://download.oracle.com/docs/cd/E10783_01/doc/bi.79/e10742/anyinstadmwininstall.htm#i1089967


2. To set up DAC to connect to the email server:
Select Tools --> DAC server setup
Select the tab: Email configuration
Enter the relevant information as the user  who the email should be sent from.
Click Send Test  Email

The email should be sent to the recipient.


Anisha

DAC custom execution plan steps

1. Create custom logical and physical folders :
Tools > seed data > task folders

2.Register the new folders : eg - Custom_mappings
Design > source system folders

3. Modify existing DAC tasks to use the custom mappings and workflows

4. Synchronize Task(s )Right click on DAC task and select synchronize. This will add the source and target tables to the task. make sure the DAC task name and informatica task name are the same.

5. Assemble the Subject Area

6. Generate execution plan(EP) parameters . EP parameters include the Infa repository folders related to the container that the EP belongs to . This could be the missing step.Execution > select EP> select Parameters sub-tab > verify/update the folder names > Generate

7. Build the EP

8. Run the EP

-A

Updating Oracle BI Apps 7.9.5.1 to 7.6

This is a compilation of information based on our current installation and based on the update and installation guide leading to a successful upgrade to 7.9.6. from 7.9.5.1.

Our source and target databases are Oracle.

This is just a synopsis of the steps we followed.

For a more detailed explanation you can visit OTN and download the relevant documentation.



1. You want to backup all existing information.

- DAC repository (thru DAC export option)

- DAC install folder

- BI Apps RPD

- BI Apps Catalogue

- Informatica repository



Remember all installation directories should be in locations which do not have a space in the location. eg: DO NOT install informatica or java in C:\Program Files. This will cause problems for DAC (which is needed to run the informatica mappings).



2. Uninstall the existing BI Applications and then restart your machine

3. Unset all informatica variables

4. Install BI apps 7.9.6

5. Install Informatica 8.6 + HotFix 4 - create integration and repository services if they do not exist. update Informatica repository

6. Install DAC - update DAC repository

7. Set parameters in DAC and Informatica to connect to databases

8. Check the pmrep and pmcmd connections

9. Build an execution plan with a single subject area (uncheck all options) to test that all connections are in place and then proceed to build with additional subject areas.

OBIEE Tips

This blog contains some of the different issues I have run into during my implementations of OBIEE and OBIApps.
Feel free to leave your comments and/or tips.

Thanks,
Anisha