I'm upgrading from BI-Apps220.127.116.11 to 18.104.22.168.
When I migrate the data into the Upgraded Data Warehouse (which is described at 22.214.171.124 in e35270.pdf(upgrade guide doc)),
I cannot run the workflow ( which name is UPGRADE_DIMENTION and is set by 7964_UPG_PARAM.txt) for migrating in Informatica workflow manager,
(I select the "Start Workflow" right-clicked menu on UPGRADE_DIMENTION in workflow manager, but there is no run task in workflow monitor)
In the document,
"Before running the Upgrade Dimentions, First make sure you have given PROPER Source and Target Connections in Workflow Manager"
There is a PARAM_OLAP( this is for target) and PARAM_OLTP_ORAR12 (this is for source)
in both Workflow manager Relational Connection Browser and 7964_UPG_PARAM.txt.
And informatica help says that Connect String in Relational Database Connectioins is same as TNSNAMES entry(*1).
But I don't know "PROPER connections" at where should I use.
Where should I use the TNS entry?(Informatica server? DAC Server? Informatica Client?)
Does anyone met a similar situation?
(*1)In my environment, RDBMS is ORACLE both source and target.
If you are not able to see the workflow running in the monitor after you use the 'start workflow' in the workflow manager then you would see the reason for that in the output window of the workflow manager.
The other option is to directly substitute the source and target connections (Connection in the Menu of the Workflow Manager and Click on Relational) instead of using the parameter values.
Try this and let us know.
Pls mark if it helps.
Thank you for your information.
I successfully ran the UPGRADE_DIMENTION and UPGRADE_FACTS workflow.
When I selected "Start workflow" at workflow level, the workflow didn't run.
But I selected "Start workflow from task" at "START" Task under the workflow, the workflow ran.