Pages

Thursday, February 2, 2012

opmnctl start: failed. Can not resolve test.oracle.com for interface any

This issue happned while installing OBIEE 11G and when the installer trying to configure the components its unable to start the opmn.
The further analysing the problem revealed its issue with the opmnctl and its unable to startup

OPMN ERROR:
----------
Can not resolve test.oracle.com for interface any
opmnctl start: failed.

SOLUTION:
---------
The issue is due to improper entries in the /etc/hosts file,
Validate your /etc/hosts and verify the loopback entries (127.0.0.1), The loopback address should be in the below format.
127.0.0.1        localhost.localdomain localhost

If still you have the issue, verify the your network adapters using ifconfig -a

Monday, January 23, 2012

Unable to determine SMTP server to use: set FND_SMTP_HOST

Outpost Processot has encoutered the below error.

This error can be found in OPP logs:
----------------------------------------
[GC 14000K->8905K(20284K), 0.0074280 secs]
ProcessorException: Unable to determine SMTP server to use: set FND_SMTP_HOST
        at oracle.apps.fnd.cp.opp.EmailDeliveryProcessor.deliver(EmailDeliveryProcessor.java:66)
        at oracle.apps.fnd.cp.opp.DeliveryProcessor.process(DeliveryProcessor.java:91)
        at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)
----------------------------------------

Solution:1. Log into System Administrator responsibility.
2. Navigate to Profile - System.
3. Query up the %smtp% profiles.
4. Set the following profile values to the defined host and port:
FND:smtp Host
FND:smtp Port

Sunday, January 22, 2012

The Output Post-processor is running but has not picked up this request.


OPP Error in the Log file:

------------------------------------------------------------------------
The Output Post-processor is running but has not picked up this request.
No further attempts will be made to post-process this request, and the request will be marked
with Warning status.
Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary.
------------------------------------------------------------------------

Solution:

A) Restart the Output Post Processor and re-test the issue

B) If the above ddint solve your issue, Increase the below profile options and re-test the issue

Concurrent:OPP Process Timeout to 600 (300*2)

Concurrent:OPP Response Timeout TO 240 (120*2)

C) If A and B didnt work, Increase the procesess of the Outpost Processor (double it i.e if you have 1 increase it to 2) from Concurrent - Manager - Define screen

and restart the OPP, That should resolve this issue.

Tuesday, January 17, 2012

Oracle Business Intellegence Analytics Installation on Linux Steps


Oracle Business Intellegence Analytics Installation on Linux Steps

OBIA works with in combination of the OBIEE,Informatica and DAC.

The below versions of the components were used to complete the OBIA 7.9.6.3 Installation and Setup.

----------------------
OBIEE 11g - 11.1.1.5
OBIA - 7.9.6.3
Informatica - 9.0.1
DAC - 7.9.6.3
Oracle DW Database - 11GR2
Oracle Database Client - 11GR2
----------------------

Installation of the Server components has been done on Linux server and the Client components was done on Windows server.

Please find the below high level steps of the installation.

THIS IS ONLY HIGH LEVEL PLAN

Server Installation on Linux
==================

1)Install the Database 11GR2 (In multinode architecture this should be done on Database node)

2)Create the schemas & objects required for OBIEE using RCU (Repository creation utility

3)Install OBIEE 11G and which will also install weblogic

4)Install Informatica server 9.0.1 on Linux

5)Install DAC server on Linux

6)Install Oracle database 11GR2 Client software (in case of DB is in different node)

Client  Installation on Windows
============================

1)Install OBIEE 11G on Client windows machine (use OBIEE windows software

2)Install OBIA on top of the OBIEE installation

3)Install DAC & Informatica client on the windows machine

4)Install OBIEE client tool.


Server Setup & Configuration:
==============================

1) Copy the rdp and catalog presentation layer components fron biapps directory to server OBIEE

2) Copy DAC metadata related files to DAC client to DAC server

3) Setup DAC server using setupserver.sh script

4) Create DAC connection and create the DAC DataWare house tables

6) Copy information source and config files from windows to linux server

How does workflow Notification Mailer IMAP (Inbound Processing) Works


How does workflow Notification Mailer IMAP (Inbound Processing) Works:

This is the inbound flow:

1. Approver sends email response which is directed to the value defined in Replyto address.
a. This address has been setup by the customer's mail administrator to route incoming mail to the IMAP Inbox folder.
2. The Workflow Inbound Agent Listener picks up the message. Only messages which are in ‘unread’ state are evaluated; the rest of the messages in the inbox are ignored.

3. The message is scanned to see if it matches entries in the TAG file . Mail tags are defined in the OAM mailer configuration pages and these list strings of text and actions to take if those strings are encountered. An example of this are 'Out of Office' replies. If the string of the message matches a mail tag and the action is 'Ignore' then nothing else will happen.

4. The message is then scanned for the presence of a Notification Id (NID). This NID is matched against valid NID for the mailer node.

5. If valid NID is not detected, (and there is no matching TAG file entry) then the message is placed into the DISCARD folder.

6. If a valid NID is detected the listener raises a subscription to the WF_NOTIFICATION_IN queue and places the mail message in the Processed folder.

7. From this point on the message is handled by the product workflow (like PO APPROVAL) . An event created by that group will monitor the WF_NOTIFICATION_IN queue and will trigger the rest of the approval workflow.