Hi everybody,
last weekend we did an upgrade of our database, which contains OWB from 11.2.0.4 to 12.1.0.2.
After that upgrade we are running into failures when we want to deploy an mapping, function or process flow.
The following errors are thrown:
RTC-5161: The Deployment cannot proceed because of an error during the generation or pre-deployment phase....
and
java.sql.SQLException: no rows found for select into statement
at sqlj.runtime.error.Errors.raiseError(Errors.java:118)
at sqlj.runtime.error.Errors.raiseError(Errors.java:60)
at sqlj.runtime.error.RuntimeRefErrors.raise_NO_ROW_SELECT_INTO(RuntimeRefErrors.java:62)
at oracle.wh.service.impl.runtime.runtime_access.RuntimeQueries.getDeploymentAdapterName(RuntimeQueries.java:1953)
at oracle.wh.service.impl.runtime.EnvironmentUtils.getDeploymentAdapterName(EnvironmentUtils.java:530)
at oracle.wh.service.impl.runtime.DeploymentSpecificationImpl.addToListCollection(DeploymentSpecificationImpl.java:866)
at oracle.wh.service.impl.runtime.DeploymentSpecificationImpl.addToListCollection(DeploymentSpecificationImpl.java:844)
at oracle.wh.service.impl.runtime.DeploymentSpecificationImpl.buildRuntimeObjectListCollection(DeploymentSpecificationImpl.java:584)
at oracle.wh.service.impl.runtime.DeploymentSpecificationImpl.<init>(DeploymentSpecificationImpl.java:101)
at oracle.wh.service.impl.runtime.RuntimePlatformServiceImpl.createDeploymentSpecification(RuntimePlatformServiceImpl.java:144)
at oracle.wh.ui.runtime.application.WHRuntimeCommandGenerateDeploy.deployAsynchronous(WHRuntimeCommandGenerateDeploy.java:441)
at oracle.wh.ui.runtime.application.WHRuntimeCommandGenerateDeploy.getValidGenerationResults(WHRuntimeCommandGenerateDeploy.java:1539)
at oracle.wh.ui.runtime.application.WHRuntimeCommandGenerateDeploy.continueDeployment(WHRuntimeCommandGenerateDeploy.java:2121)
at oracle.wh.ui.runtime.application.WHRuntimeCommandHandler.actionPerformed(WHRuntimeCommandHandler.java:444)
at oracle.wh.service.sdk.OWBConsumer.dataItemAvailable(OWBInfoBus.java:381)
at javax.infobus.DefaultController.fireItemAvailable(DefaultController.java:90)
at javax.infobus.InfoBus.fireItemAvailable(InfoBus.java:989)
at oracle.wh.service.sdk.OWBInfoBus.produce(OWBInfoBus.java:160)
at oracle.wh.service.sdk.OWBInfoBus.produce(OWBInfoBus.java:76)
at oracle.wh.ui.runtime.application.RuntimeProgressListener.notifyCompletion(RuntimeProgressListener.java:107)
at oracle.wh.service.impl.generation.service.GenerationValidationService.internalCompile(GenerationValidationService.java:172)
at oracle.wh.ui.generation.GenerationController.compile(GenerationController.java:197)
at oracle.wh.ui.runtime.application.WHRuntimeCommandGenerateDeploy$CompileThread.construct(WHRuntimeCommandGenerateDeploy.java:4257)
at oracle.wh.ui.runtime.SwingWorker$2.run(SwingWorker.java:124)
at java.lang.Thread.run(Thread.java:662)
Right now we can execute an mapping but we can't deploy anything. Also we can't execute our process flow because it seems to be hung at the function with the following error:
RPE-01008: Recovery of this request is in progress.
Can someone help me out of this?
Greetings,
Daniel