GitHub user ossDataEngineer edited a discussion: "Error decoding password using AES" - occurs intermittently
Hello Apache Hop Community, I have parameterized metadata element for RDBMS, where I source the database connection details from Hop environment. The password is saved as encoded AES2 string. I have noticed that Hop sometimes fails with error: "Error decoding password using AES". Why does this fail sometimes? I have proper system env variables set HOP_PASSWORD_ENCODER_PLUGIN and HOP_AES_ENCODER_KEY. ```java 2025/08/22 09:16:04 - Insert POC_TABLE.0 - ERROR: An error occurred initializing this transform: 2025/08/22 09:16:04 - Insert POC_TABLE.0 - Error occurred while trying to connect to the database 2025/08/22 09:16:04 - Insert POC_TABLE.0 - 2025/08/22 09:16:04 - Insert POC_TABLE.0 - Error connecting to database: (using class oracle.jdbc.driver.OracleDriver) 2025/08/22 09:16:04 - Insert POC_TABLE.0 - Error decoding password using AES 2025/08/22 09:16:04 - Insert POC_TABLE.0 - ERROR: Error initializing transform [Insert POC_TABLE] 2025/08/22 09:16:05 - map_poc_table_pipeline - ERROR: Transform [Insert POC_TABLE.0] failed to initialize! 2025/08/22 09:16:05 - Insert POC_TABLE.0 - ERROR: Unexpected error rolling back the database connection. 2025/08/22 09:16:05 - Insert POC_TABLE.0 - ERROR: org.apache.hop.core.exception.HopDatabaseException: 2025/08/22 09:16:05 - Insert POC_TABLE.0 - Unable to get database metadata from this database connection 2025/08/22 09:16:05 - Insert POC_TABLE.0 - 2025/08/22 09:16:05 - Insert POC_TABLE.0 - Error connecting to database [] 2025/08/22 09:16:05 - Insert POC_TABLE.0 - 2025/08/22 09:16:05 - Insert POC_TABLE.0 - 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.core.database.Database.getDatabaseMetaData(Database.java:2897) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.core.database.Database.rollback(Database.java:737) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.core.database.Database.rollback(Database.java:729) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.pipeline.transforms.tableoutput.TableOutput.emptyAndCommitBatchBuffers(TableOutput.java:648) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.pipeline.transforms.tableoutput.TableOutput.dispose(TableOutput.java:568) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.pipeline.Pipeline.prepareExecution(Pipeline.java:1056) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.pipeline.engines.local.LocalPipelineEngine.prepareExecution(LocalPipelineEngine.java:232) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.workflow.actions.repeat.Repeat.executePipeline(Repeat.java:294) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.workflow.actions.repeat.Repeat.executePipelineOrWorkflow(Repeat.java:243) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.workflow.actions.repeat.Repeat.execute(Repeat.java:193) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:751) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:902) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:902) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:902) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:902) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:902) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:453) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.workflow.Workflow.startExecution(Workflow.java:313) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.workflow.engines.local.LocalWorkflowEngine.startExecution(LocalWorkflowEngine.java:249) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.ui.hopgui.file.workflow.HopGuiWorkflowGraph.lambda$start$15(HopGuiWorkflowGraph.java:3755) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at java.base/java.lang.Thread.run(Thread.java:842) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - Caused by: org.apache.hop.core.exception.HopDatabaseException: 2025/08/22 09:16:05 - Insert POC_TABLE.0 - Error connecting to database [] 2025/08/22 09:16:05 - Insert POC_TABLE.0 - 2025/08/22 09:16:05 - Insert POC_TABLE.0 - at org.apache.hop.core.database.Database.getDatabaseMetaData(Database.java:2890) 2025/08/22 09:16:05 - Insert POC_TABLE.0 - ... 20 more ``` I have **map_poc_table_pipeline** which runs as a repeating pipeline. Few iterations work properly and data is inserted using DB Transform. But intermittently, I get this error for next iterations. Is this problem because of JVM GC? GitHub link: https://github.com/apache/hop/discussions/5636 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
