Error Running Migrated PDI to Hop Project: Works Locally but Fails Remotely

[ravamo]

I checked a project migrated from PDI to Hop using the tool, and everything seems fine. However, when I execute it as mentioned in the thread , I get this error, and I don’t know why. I searched for this error on Google and found this thread , but it's not clear to me why it happens, especially since it runs perfectly fine locally.

Starting action
Opening pipeline: [/servers/hop/server/resources/etl/repository/setExecutionTime.hpl]
Starting pipeline...(file=/servers/hop/server/resources/etl/repository/setExecutionTime.hpl, name=Set Execution time, repinfo=null)
ERROR: Unable to open pipeline:
This action needs a run configuration to use to execute the specified pipeline
ERROR: org.apache.hop.core.exception.HopException:
This action needs a run configuration to use to execute the specified pipeline
        at org.apache.hop.workflow.actions.pipeline.ActionPipeline.execute(ActionPipeline.java:491)
        at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:745)
        at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:888)
        at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:447)
        at org.apache.hop.workflow.Workflow.startExecution(Workflow.java:307)
        at org.apache.hop.workflow.engines.local.LocalWorkflowEngine.startExecution(LocalWorkflowEngine.java:248)
        at java.base/java.lang.Thread.run(Thread.java:833)
 mainRedmineLoadDatalake - Starting action [Error Handling]
 mainRedmineLoadDatalake - exec(5, 0, Error Handling)
Starting action
Opening pipeline: [/servers/hop/server/resources/etl/repository/errorHandling.hpl]
Starting pipeline...(file=/servers/hop/server/resources/etl/repository/errorHandling.hpl, name=Error Handling, repinfo=null)
ERROR: Unable to open pipeline:
This action needs a run configuration to use to execute the specified pipeline
ERROR: org.apache.hop.core.exception.HopException:
This action needs a run configuration to use to execute the specified pipeline
         at org.apache.hop.workflow.actions.pipeline.ActionPipeline.execute(ActionPipeline.java:491)
         at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:745)
        at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:888)
         at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:447)
         at org.apache.hop.workflow.Workflow.startExecution(Workflow.java:307)
       at org.apache.hop.workflow.engines.local.LocalWorkflowEngine.startExecution(LocalWorkflowEngine.java:248)
         at java.base/java.lang.Thread.run(Thread.java:833)
 mainRedmineLoadDatalake - Starting action [Abort job]

[bamaer]

It looks like your mainRedmineLoadDatalake workflow has a pipeline action for /servers/hop/server/resources/etl/repository/errorHandling.hpl that doesn't have a run configuration or one that the server doesn't recognize.

[bamaer]

yes, just create a backup of that failing workflow, open it in Hop Gui, select the run config for that pipeline action, save your workflow and compare that last version's XML to the XML from the backup and you'll know if that is the issue

[ravamo]

Well, I deleted everything and recreated it manually, and it seems to be working now—or at least I’m getting new errors because I set everything to debug mode. Now I’m dealing with this error:

ERROR: Error initializing transform [Salida Tabla]
ERROR: java.lang.NullPointerException: Cannot invoke "org.apache.hop.core.database.DatabaseMeta.getIDatabase()" because "this.data.databaseMeta" is null
         at org.apache.hop.pipeline.transforms.tableoutput.TableOutput.init(TableOutput.java:482)
         at org.apache.hop.pipeline.transform.TransformInitThread.run(TransformInitThread.java:66)
         at java.base/java.lang.Thread.run(Thread.java:833)
repository\setExecutionTime - Transform [Información de sistema.0] initialized flawlessly.

But the datasoure was defined .. i'm lost right now

[bamaer]

it looks like that database connection isn't known on the server though

[ravamo]

yep looks list a problem with rdbs , but I added the JSON that I created locally (it’s parameterized) to the folder hop/config/projects/default/metadata/rdbms, and then I added the path in the XML file before starting the server:

<metadata_folder></metadata_folder>

[bamaer]

not something I use frequently myself, but I would avoid the metadata folders for the samples and default projects for your own metadata. anyway, this is now a configuration issue and no longer a PDI migration issue.

[ravamo]

Yes, but now I’m lost... Honestly, I’m not sure what tests I can run. I think it’s better if I close this one and open a new one for this issue, right?

[bamaer]

yes, that's probably better to avoid having two separate topics in a single discussion