Skip to Main Content

GoldenGate Free

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Error creating pipeline

When I try to create a new pipeline, I get an internal server error. I'm running on windows with 19c source and target databases (both non-CDB) using docker desktop.

Log below

2023-11-30 16:33:03 2023.11.30 16:33:03 INFO oracle.cloud.ggfe.api.impl.RecipeResourceImpl Thread[helidon-server-63,5,server]: >>>>>RecipeResourceImpl.listRecipes locale: null
2023-11-30 16:33:03 2023.11.30 16:33:03 INFO oracle.cloud.ggfe.orchestrator.recipe.RecipeManager Thread[helidon-server-63,5,server]: res://templates/Replicate_1.0.yaml
2023-11-30 16:33:03 2023.11.30 16:33:03 INFO oracle.cloud.ggfe.orchestrator.recipe.RecipeManager Thread[helidon-server-63,5,server]: res://templates/ReplicateBiDirection_1.0.yaml
2023-11-30 16:33:03 2023.11.30 16:33:03 INFO oracle.cloud.ggfe.api.impl.ConnectionResourceImpl Thread[helidon-server-65,5,server]: >>>>>ConnectionResourceImpl.listConnections filter: connector=DATABASE
2023-11-30 16:33:03 2023.11.30 16:33:03 INFO oracle.cloud.ggfe.api.impl.ConnectionResourceImpl Thread[helidon-server-65,5,server]: 2 connections
2023-11-30 16:33:03 2023.11.30 16:33:03 INFO oracle.cloud.ggfe.api.impl.ConnectionResourceImpl Thread[helidon-server-64,5,server]: >>>>>ConnectionResourceImpl.listConnections filter: connector=DATABASE
2023-11-30 16:33:03 2023.11.30 16:33:03 INFO oracle.cloud.ggfe.api.impl.ConnectionResourceImpl Thread[helidon-server-64,5,server]: 2 connections
2023-11-30 16:33:11 2023.11.30 16:33:11 INFO oracle.cloud.ggfe.api.impl.PipelineResourceImpl Thread[helidon-server-67,5,server]: >>>>>PipelineResourceImpl.listPipeline filter:name=pl1
2023-11-30 16:33:12 2023.11.30 16:33:12 INFO oracle.cloud.ggfe.api.impl.RecipeResourceImpl Thread[helidon-server-69,5,server]: >>>>>RecipeResourceImpl.getRecipe recipeId:F4D5736F-0FF2-41AF-84C9-1C3D145D8D7C
2023-11-30 16:33:12 2023.11.30 16:33:12 INFO oracle.cloud.ggfe.api.impl.RecipeResourceImpl Thread[helidon-server-69,5,server]: F4D5736F-0FF2-41AF-84C9-1C3D145D8D7C image: http://127.0.0.1:8080/oggfServices/v1.0/recipes/F4D5736F-0FF2-41AF-84C9-1C3D145D8D7C/image
2023-11-30 16:33:12 2023.11.30 16:33:12 INFO oracle.cloud.ggfe.api.impl.PipelineResourceImpl Thread[helidon-server-68,5,server]: >>>>>PipelineResourceImpl.createPipeline {"name":"pl1","description":"pl1","sourceId":"A13E79B9-C236-48A6-B4A4-B0E6A22F803D","targetId":"71E42245-34D7-4C06-844A-FE8C033F3C7C","steps":[{"name":"oracle.cloud.ggfe.orchestrator.steps.replicate.Replicate","recipeId":"F4D5736F-0FF2-41AF-84C9-1C3D145D8D7C","recipe":"Replicate","recipeVersion":"1.0","parameters":{"initialLoad":"true","includeDdl":"true","tableExistsAction":"REPLACE","initialLoadParallelDegree":"1","initialLoadJobDuraion":"1h","waitForOpenTxnsDuraion":"1h","OpenTxnsAction":"CONTINUE","extractSourceTimezone":"null","extractParams":[],"extractAutorestartEnable":"false","extractAutorestartRetries":"9","extractAutorestartDelay":"0s","extractAutorestartWindow":"1m","extractAutorestartOnlyIfFails":"true","extractAutorestartDisableOnFailure":"true","extractAutorestartFailures":"1","ddlError":"KILL","replicatError":"RETRYOP","replicatErrorMaxRetry":"1","replicatErrorDelay":"0s","replicatParams":[],"replicatAutorestartEnable":"false","replicatAutorestartDelay":"0s","replicatAutorestartDisableOnFailure":"true","replicatAutorestartFailures":"1","replicatAutorestartOnlyIfFails":"true","replicatAutorestartRetries":"9","replicatAutorestartWindow":"1m"}}],"validationMsgs":[]}
2023-11-30 16:33:12 2023.11.30 16:33:12 INFO oracle.cloud.ggfe.orchestrator.OrchestratorEngine Thread[helidon-server-68,5,server]: ============== setDefaultConfig for pipeline ==============
2023-11-30 16:33:12 2023.11.30 16:33:12 INFO oracle.cloud.ggfe.orchestrator.steps.replicate.ReplicateContext Thread[helidon-server-68,5,server]: getDBContext: Source DB
2023-11-30 16:33:12 2023.11.30 16:33:12 WARNING io.helidon.microprofile.server.JaxRsCdiExtension Thread[helidon-server-68,5,server]: Internal server error
2023-11-30 16:33:12 java.lang.NullPointerException: Cannot read field "properties" because "other" is null
2023-11-30 16:33:12 at oracle.cloud.ggfe.orchestrator.connectors.ConnectorMetadata.<init>(ConnectorMetadata.java:16)
2023-11-30 16:33:12 at oracle.cloud.ggfe.orchestrator.connectors.database.DbMetadata.<init>(DbMetadata.java:33)
2023-11-30 16:33:12 at oracle.cloud.ggfe.orchestrator.connectors.database.dialects.oracle.OracleMetadata.<init>(OracleMetadata.java:29)
2023-11-30 16:33:12 at oracle.cloud.ggfe.orchestrator.steps.replicate.ReplicateContext.getDbInfo(ReplicateContext.java:230)
2023-11-30 16:33:12 at oracle.cloud.ggfe.orchestrator.steps.replicate.ReplicateContext.getDBContext(ReplicateContext.java:295)
2023-11-30 16:33:12 at oracle.cloud.ggfe.orchestrator.steps.replicate.ReplicateContext.prepareContext(ReplicateContext.java:324)
2023-11-30 16:33:12 at oracle.cloud.ggfe.orchestrator.steps.replicate.Replicate.createContext(Replicate.java:135)
2023-11-30 16:33:12 at oracle.cloud.ggfe.orchestrator.steps.replicate.Replicate.createContext(Replicate.java:69)
2023-11-30 16:33:12 at oracle.cloud.ggfe.orchestrator.OrchestratorEngine.initPipelineExecutor(OrchestratorEngine.java:128)
2023-11-30 16:33:12 at oracle.cloud.ggfe.orchestrator.OrchestratorEngine.initPipeline(OrchestratorEngine.java:92)
2023-11-30 16:33:12 at oracle.cloud.ggfe.orchestrator.OrchestratorEngine.setDefaultConfig(OrchestratorEngine.java:241)
2023-11-30 16:33:12 at oracle.cloud.ggfe.api.impl.PipelineResourceImpl.create0(PipelineResourceImpl.java:50)
2023-11-30 16:33:12 at oracle.cloud.ggfe.api.impl.PipelineResourceImpl.create(PipelineResourceImpl.java:30)
2023-11-30 16:33:12 at oracle.cloud.ggfe.api.PipelineResource.createPipeline(PipelineResource.java:55)
2023-11-30 16:33:12 at oracle.cloud.ggfe.api.PipelineResource$Proxy$_$$_WeldClientProxy.createPipeline(Unknown Source)
2023-11-30 16:33:12 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2023-11-30 16:33:12 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
2023-11-30 16:33:12 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2023-11-30 16:33:12 at java.base/java.lang.reflect.Method.invoke(Method.java:568)
2023-11-30 16:33:12 at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52)
2023-11-30 16:33:12 at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:134)
2023-11-30 16:33:12 at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:177)
2023-11-30 16:33:12 at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:219)
2023-11-30 16:33:12 at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:81)
2023-11-30 16:33:12 at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:478)
2023-11-30 16:33:12 at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:400)
2023-11-30 16:33:12 at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81)
2023-11-30 16:33:12 at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:256)
2023-11-30 16:33:12 at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248)
2023-11-30 16:33:12 at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244)
2023-11-30 16:33:12 at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
2023-11-30 16:33:12 at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
2023-11-30 16:33:12 at org.glassfish.jersey.internal.Errors.process(Errors.java:244)
2023-11-30 16:33:12 at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265)
2023-11-30 16:33:12 at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:235)
2023-11-30 16:33:12 at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:684)
2023-11-30 16:33:12 at io.helidon.webserver.jersey.JerseySupport$JerseyHandler.lambda$doAccept$6(JerseySupport.java:339)
2023-11-30 16:33:12 at io.helidon.common.context.Contexts.runInContext(Contexts.java:117)
2023-11-30 16:33:12 at io.helidon.common.context.ContextAwareExecutorImpl.lambda$wrap$7(ContextAwareExecutorImpl.java:154)
2023-11-30 16:33:12 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
2023-11-30 16:33:12 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
2023-11-30 16:33:12 at java.base/java.lang.Thread.run(Thread.java:833)
2023-11-30 16:33:12

Comments

dvohra21

A Docker image for 19.3 is already available https://github.com/oracle/docker-images/tree/main/OracleDatabase/SingleInstance/dockerfiles/19.3.0

Maheswara Reddy

Thanks for the advice.

Please guide me, how can we push above oracle docker image to AWS ECR.

Thanks,

Maheswar

dvohra21

A Docker image on Docker Hub may be used directly in AWS ECS as explained @ https://aws.amazon.com/blogs/containers/authenticating-with-docker-hub-for-aws-container-services/

Why is image need to be transferred to AWS ECR, which may incur additional storage?

1 - 3

Post Details

Added on Nov 30 2023
1 comment
309 views