GitHub user ravamo added a comment to the discussion: Connection Issue with
RDBMS Configuration in Server Mode
* Json File :
/servers/hop/hop/resources/proyect/metadata/rdbms/DB_Dl_SAMPLE.json, this
config file in my local works ..
```json
{
"rdbms": {
"POSTGRESQL": {
"databaseName": "${DATABASE_NAME}",
"pluginId": "POSTGRESQL",
"accessType": 0,
"hostname": "${DATABASE_HOST}",
"password": "${DATABASE_PASSWORD}",
"pluginName": "PostgreSQL",
"port": "${DATABASE_PORT}",
"attributes": {
"SUPPORTS_TIMESTAMP_DATA_TYPE": "Y",
"QUOTE_ALL_FIELDS": "N",
"SUPPORTS_BOOLEAN_DATA_TYPE": "Y",
"FORCE_IDENTIFIERS_TO_LOWERCASE": "N",
"PRESERVE_RESERVED_WORD_CASE": "Y",
"SQL_CONNECT": "",
"FORCE_IDENTIFIERS_TO_UPPERCASE": "N",
"PREFERRED_SCHEMA_NAME": ""
},
"manualUrl": "",
"username": "${DATABASE_USER}"
}
},
"name": "DB_Dl_SAMPLE"
}
````
* This is prohect part of config/hop-config.json
``` json
"projectsConfig" : {
"enabled" : true,
"projectMandatory" : false,
"environmentMandatory" : false,
"environmentsForActiveProject" : false,
"defaultProject" : null,
"defaultEnvironment" : null,
"standardParentProject" : null,
"standardProjectsFolder" : null,
"defaultProjectConfigFile" : "project-config.json",
"projectConfigurations" : [ {
"projectName" : "load-datalake",
"projectHome" : "/servers/hop/hop/resources/proyect",
"configFilename" : "project-config.json"
} ],
"lifecycleEnvironments" : [ {
"name" : "datalake-local",
"purpose" : "Development",
"projectName" : "load-datalake",
"configurationFiles" : [ ]
} ],
"projectLifecycles" : [ ]
}
```
``` less
root@coetl:/servers/hop/hop# sh hop-run.sh -j redmine-load-datalake
-f/servers/hop/hop/resources/proyect/load-datalake/repository/main.hwf -r local
2024/12/16 13:27:33 - HopRun - Enabling project 'load-datalake'
2024/12/16 13:27:33 - HopRun - Starting workflow:
/servers/hop/hop/resources/load-datalake/repository/main.hwf
2024/12/16 13:27:33 - mainRedmineLoadDatalake - Start of workflow execution
2024/12/16 13:27:33 - mainRedmineLoadDatalake - Starting action [Set variables
2]
2024/12/16 13:27:33 - mainRedmineLoadDatalake - Starting action [Eliminar
registros erroneos]
2024/12/16 13:27:34 - mainRedmineLoadDatalake - Starting action [Borrar
ficheros temporales]
2024/12/16 13:27:34 - Borrar ficheros temporales - File
[/servers/hop/data-integration/resources/redmine-load-datalake/repository/tmp/totales.csv]
already deleted or did not exist.
2024/12/16 13:27:34 - Borrar ficheros temporales - File
[/servers/hop/hop/resources/load-datalake/repository/tmp/urls.csv] already
deleted or did not exist.
2024/12/16 13:27:34 - mainRedmineLoadDatalake - Starting action [Set Execution
time]
2024/12/16 13:27:34 - Set Execution time - Using run configuration [local]
2024/12/16 13:27:34 - repository\setExecutionTime - Executing this pipeline
using the Local Pipeline Engine with run configuration 'local'
2024/12/16 13:27:34 - repository\setExecutionTime - Execution started for
pipeline [repository\setExecutionTime]
2024/12/16 13:27:35 - Salida Tabla.0 - ERROR: Error initializing transform
[Salida Tabla]
2024/12/16 13:27:35 - Salida Tabla.0 - ERROR: java.lang.NullPointerException:
Cannot invoke "org.apache.hop.core.database.DatabaseMeta.getIDatabase()"
because "this.data.databaseMeta" is null
2024/12/16 13:27:35 - Salida Tabla.0 - at
org.apache.hop.pipeline.transforms.tableoutput.TableOutput.init(TableOutput.java:482)
2024/12/16 13:27:35 - Salida Tabla.0 - at
org.apache.hop.pipeline.transform.TransformInitThread.run(TransformInitThread.java:66)
2024/12/16 13:27:35 - Salida Tabla.0 - at
java.base/java.lang.Thread.run(Thread.java:833)
2024/12/16 13:27:35 - repository\setExecutionTime - ERROR: Transform [Salida
Tabla.0] failed to initialize!
2024/12/16 13:27:35 - Set Execution time - ERROR: Unable to prepare for
execution of the pipeline
2024/12/16 13:27:35 - Set Execution time - ERROR:
org.apache.hop.core.exception.HopException:
2024/12/16 13:27:35 - Set Execution time - We failed to initialize at least one
transform. Execution can not begin!
2024/12/16 13:27:35 - Set Execution time -
2024/12/16 13:27:35 - Set Execution time -
2024/12/16 13:27:35 - Set Execution time - at
org.apache.hop.pipeline.Pipeline.prepareExecution(Pipeline.java:1087)
2024/12/16 13:27:35 - Set Execution time - at
org.apache.hop.pipeline.engines.local.LocalPipelineEngine.prepareExecution(LocalPipelineEngine.java:231)
2024/12/16 13:27:35 - Set Execution time - at
org.apache.hop.pipeline.Pipeline.execute(Pipeline.java:527)
2024/12/16 13:27:35 - Set Execution time - at
org.apache.hop.workflow.actions.pipeline.ActionPipeline.execute(ActionPipeline.java:542)
2024/12/16 13:27:35 - Set Execution time - at
org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:745)
2024/12/16 13:27:35 - Set Execution time - at
org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:888)
2024/12/16 13:27:35 - Set Execution time - at
org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:888)
2024/12/16 13:27:35 - Set Execution time - at
org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:888)
2024/12/16 13:27:35 - Set Execution time - at
org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:888)
2024/12/16 13:27:35 - Set Execution time - at
org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:447)
2024/12/16 13:27:35 - Set Execution time - at
org.apache.hop.workflow.Workflow.startExecution(Workflow.java:307)
2024/12/16 13:27:35 - Set Execution time - at
org.apache.hop.workflow.engines.local.LocalWorkflowEngine.startExecution(LocalWorkflowEngine.java:248)
2024/12/16 13:27:35 - Set Execution time - at
org.apache.hop.run.HopRun.runWorkflow(HopRun.java:438)
2024/12/16 13:27:35 - Set Execution time - at
org.apache.hop.run.HopRun.runWorkflow(HopRun.java:389)
2024/12/16 13:27:35 - Set Execution time - at
org.apache.hop.run.HopRun.run(HopRun.java:206)
2024/12/16 13:27:35 - Set Execution time - at
org.apache.hop.run.HopRun.main(HopRun.java:930)
2024/12/16 13:27:35 - mainRedmineLoadDatalake - Finished action [Set Execution
time] (result=[false])
2024/12/16 13:27:35 - mainRedmineLoadDatalake - Finished action [Borrar
ficheros temporales] (result=[false])
2024/12/16 13:27:35 - mainRedmineLoadDatalake - Finished action [Eliminar
registros erroneos] (result=[false])
2024/12/16 13:27:35 - mainRedmineLoadDatalake - Finished action [Set variables
2] (result=[false])
2024/12/16 13:27:35 - mainRedmineLoadDatalake - Workflow execution finished
2024/12/16 13:27:35 - mainRedmineLoadDatalake - Workflow duration : 1.512
seconds [ 1.512" ]
HopRun exit.
````
i don't know if you need anything else ..
GitHub link:
https://github.com/apache/hop/discussions/4700#discussioncomment-11581261
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]
