Sitemap

Amicuk Programming Answers

Cannot deploy process flow package specification from file

2015-10-11   Views:3

Advertisement

Hi, we are using owb 11gr2 on linux. We successfully managed to deploy mappings and tables into a specification file, and then deploy from that file into the target database (RAC). But when we try to deploy a process flow package we run into an error

Hi,
we are using owb 11gr2 on linux. We successfully managed to deploy mappings and tables into a specification file, and then deploy from that file into the target database (RAC). But when we try to deploy a process flow package we run into an error:
A process flow package can be deployed to a specification file. But a deployment from that specification file fails with the error: " OMB05623: Cannot deploy specification from file. Exception follows. nulll"
### SETUP
set CONN_DESIGN "xxx"
set CONN_TARGET_DESIGN "yyy"
set CONN_TARGET_RT "xxx'"
set DIR "D:\\tmp"
set RELEASE "V0_2"
set file "$DIR\\$RELEASE"
set plan "FILE_DEPLOY_$RELEASE"
### Deployment via control center: works!
OMBCONNECT $CONN_DESIGN
OMBCONNECT CONTROL_CENTER $CONN_TARGET_RT
OMBCC '/KLINGEL_DWH'
OMBCREATE TRANSIENT DEPLOYMENT_ACTION_PLAN '$plan'
OMBALTER DEPLOYMENT_ACTION_PLAN '$plan' ADD ACTION 'PF_TEST' SET PROPERTIES (OPERATION) VALUES ('REPLACE') SET REFERENCE PROCESS_FLOW_PACKAGE '/KLINGEL_DWH/WF_DWH/PF_TEST'
OMBDEPLOY DEPLOYMENT_ACTION_PLAN '$plan'
OMBDISCONNECT CONTROL_CENTER
OMBCOMMIT
OMBDISCONNECT
### Deployment via specificatin file: fails!
OMBCONNECT $CONN_DESIGN
OMBCONNECT CONTROL_CENTER $CONN_DESIGN
OMBCC '/KLINGEL_DWH'
OMBCREATE TRANSIENT DEPLOYMENT_ACTION_PLAN '$plan'
OMBALTER DEPLOYMENT_ACTION_PLAN '$plan' ADD ACTION 'PF_TEST' SET PROPERTIES (OPERATION) VALUES ('REPLACE') SET REFERENCE PROCESS_FLOW_PACKAGE '/KLINGEL_DWH/WF_DWH/PF_TEST'
OMBDEPLOY DEPLOYMENT_ACTION_PLAN '$plan' AS SPECIFICATION TO '$file.xml'
OMBDROP DEPLOYMENT_ACTION_PLAN '$plan'
OMBDISCONNECT CONTROL_CENTER
OMBCOMMIT
OMBDISCONNECT
OMBCONNECT CONTROL_CENTER $CONN_TARGET_RT
OMBDEPLOY SPECIFICATION FROM '$file.xml'
### OMB05623: Deployment von Spezifikation aus Datei nicht möglich. Exception folgt. null
###OMB05623: Cannot deploy specification from file. Exception follows. nullIf we use the operation DROP it works. But REPLACE and CREATE do not work.
We get the error regardless whether the code is executed as an expert or on the command line at a windows client.
Does anyone knows a workaround?
Deployment via a specification file is a must due to license and architecture requirements.
Thanks,
Carsten.

The replay answer
Advertisement
Its woked fine for me for OWB 10.2.0.4 .... some steps are missing from code like
when you are connecting again it should be
OMBDISCONNECT
OMBCONNECT CONTROL_CENTER $CONN_TARGET_RT
OMBDISCONNECT
OMBCC '/KLINGEL_DWH'
OMBCONNECT CONTROL_CENTER $CONN_TARGET_RTI think you can try the same on different system .
Cheers
Nawneet

Go to See the other 5 answers

Cannot deploy process flow package specification from file

Category:DefaultRelease time:2015-10-11Views:130

Hi, we are using owb 11gr2 on linux. We successfully managed to deploy mappings and tables into a specification file, and then deploy from that file into the target database (RAC). But when we try to deploy a process flow package we run into an error[More]

Error while deploying process flow

Category:DefaultRelease time:2015-10-11Views:130

hi All, i am getting below error while deploying 1 process flow. Description : Runtime User : OWBPC Started : 2011-06-02 19:18:06.0 Name Action Status Log None Error ORA-00942: table or view does not exist None Error RPE-02053: The Oracle Workflow ve[More]

Error in deploying Process flow in OWB 10.2

Category:DefaultRelease time:2015-10-11Views:130

I have migrated process flow from OWB 9.2 to OWB 10.2,but when i try to deploy the process flow i get the following error. oracle.wh.service.sdk.runtime.QueryException: null - Internal Error Unknown System Parameter MODULE_NAME for executionAdapterId[More]

Hot
I have a Mac OS X Version 10.7.5. Processor 2.66 GHz Intel Core 2 Duo; Memory 2 GB 1067 MHz DDR3. Computer is running very slow. I cleared downloads and reset Safari, emptied trash, etc. How  can I find out how much space I have left on my hard drive [More]
When using iMessage, if I start a conversation with my friend who is on her iPad2 (thesame as I am), sometimes the messages don't go to her, but to her son on his iPhone 3GS. It shows up as a continuing chat to my friend and if her son replies it aga [More]
Hi all : I tried to change the default password Cisco to other by command line but the password cannot work out. The command line I used are as below : AP#conf t Enter configuration commands, one per line.  End with CNTL/Z. AP(config)#enable pass AP( [More]
Hi, Can anyone help with this issue? Some reports are failed to open in CR XI Report Viewer when being scheduled and sent to the email.  The Error:  Problem Encountered: com.crystaldecisions.reports.common.GeneralException: Unable to load database co [More]
Hi Pat, or anyone, Can u help me to standardize a flat file format with respect to OWB? I have 15 financial source systems. The client agreed in giving the data in csv format. Now I need to standardize the feed file so that it would be easy for me ha [More]
Hi all, Can someone tell me why when I create a GTT and insert the data like the followijng ,I get insert 14 rows msg. But when I do a select statement from sqlwork shop , sometimes i get the data sometimes I don't. my understanding is this data is s [More]
I want to make an Apple ID with existing Game Center, but I don't have a credit card so it won't let me. On an article, it says that I need to make a new one in order to put no billing information, is it possible to put none for my existing Game Cent [More]
I have a linksys wireless router connected to a dsl modem and someone is jumping on the connection. I have tried repeatedly to set up a password via Linksys' web site. I followed their instructions: "Launch your Internet Explorer 5 or later version o [More]
Ok...I have a rather sizeable project going in Premiere CS3.  It contains a rather large number of animations created in Autodesk Maya (most between 10 seconds and 3 minutes long) and a large number of stills, as well as scrolling background (a .mov [More]
The video icon does not appear next to the users' names, and it is greyed out in the menu screen.  What is weird is that I was able to chat with the same buddies successfully in the past?  And sporadically, they are able to invite me.  But otherwise, [More]