{"record":{"id":"5d4e73d697c5e25f","repo":"pentaho/pentaho-kettle","slug":"unable-to-load-job-entry-from-the-repository-for-id-jobentry-5d4e73","errorCode":null,"errorMessage":"Unable to load job entry from the repository for id_jobentry={}","messagePattern":"Unable to load job entry from the repository for id_jobentry=(.+?)","errorType":"exception","errorClass":"KettleException","httpStatus":null,"severity":"error","filePath":"plugins/hl7/core/src/main/java/org/pentaho/di/job/entries/hl7mllpin/HL7MLLPInput.java","lineNumber":124,"sourceCode":"      messageVariableName = XMLHandler.getTagValue( entrynode, \"message_variable\" );\n      messageTypeVariableName = XMLHandler.getTagValue( entrynode, \"type_variable\" );\n      versionVariableName = XMLHandler.getTagValue( entrynode, \"version_variable\" );\n    } catch ( KettleXMLException xe ) {\n      throw new KettleXMLException( \"Unable to load job entry from XML node\", xe );\n    }\n  }\n\n  @Override\n  public void loadRep( Repository rep, IMetaStore metaStore, ObjectId idJobentry, List<DatabaseMeta> databases,\n      List<SlaveServer> slaveServers ) throws KettleException {\n    try {\n      server = rep.getJobEntryAttributeString( idJobentry, \"server\" );\n      port = rep.getJobEntryAttributeString( idJobentry, \"port\" );\n      messageVariableName = rep.getJobEntryAttributeString( idJobentry, \"message_variable\" );\n      messageTypeVariableName = rep.getJobEntryAttributeString( idJobentry, \"type_variable\" );\n      versionVariableName = rep.getJobEntryAttributeString( idJobentry, \"version_variable\" );\n    } catch ( KettleException dbe ) {\n      throw new KettleException( \"Unable to load job entry from the repository for id_jobentry=\" + idJobentry, dbe );\n    }\n  }\n\n  public void saveRep( Repository rep, IMetaStore metaStore, ObjectId id_job ) throws KettleException {\n    try {\n      rep.saveJobEntryAttribute( id_job, getObjectId(), \"server\", server );\n      rep.saveJobEntryAttribute( id_job, getObjectId(), \"port\", port );\n      rep.saveJobEntryAttribute( id_job, getObjectId(), \"message_variable\", messageVariableName );\n      rep.saveJobEntryAttribute( id_job, getObjectId(), \"type_variable\", messageTypeVariableName );\n      rep.saveJobEntryAttribute( id_job, getObjectId(), \"version_variable\", versionVariableName );\n    } catch ( KettleDatabaseException dbe ) {\n      throw new KettleException( \"Unable to save job entry of type 'ftp' to the repository for id_job=\" + id_job, dbe );\n    }\n  }\n\n  public Result execute( Result previousResult, int nr ) {\n    Result result = previousResult;\n","sourceCodeStart":106,"sourceCodeEnd":142,"githubUrl":"https://github.com/pentaho/pentaho-kettle/blob/f3058517a153da500bf4551f46d79b91bf8ec552/plugins/hl7/core/src/main/java/org/pentaho/di/job/entries/hl7mllpin/HL7MLLPInput.java#L106-L142","documentation":"HL7MLLPInput.loadRep() loads the entry's attributes (server, port, message_variable, type_variable, version_variable) from the Pentaho repository. A KettleException from rep.getJobEntryAttributeString(...) is caught and rethrown as 'Unable to load job entry from the repository for id_jobentry=<id>' with the original error chained.","triggerScenarios":"Calling loadRep when reading attributes for idJobentry throws — missing r_jobentry_attribute rows, repository DB unreachable, or repository API failure.","commonSituations":"Repository corruption or partial saves; jobs migrated between repositories without attribute rows; repository connectivity/authentication problems; orphaned entries after failed deletes.","solutions":["Inspect the chained cause for the underlying repository error","Confirm the repository database is reachable and credentials work","Check r_jobentry_attribute rows for the reported id_jobentry and re-save the entry if missing","Re-create the job entry if its repository rows are orphaned"],"exampleFix":null,"handlingStrategy":"try-catch","validationCode":null,"typeGuard":null,"tryCatchPattern":"try { entry.loadRep(rep, metaStore, idJobentry, dbs, slaves); } catch (KettleException e) { log.error(\"Repo load failed for id_jobentry=\" + idJobentry, e.getCause()); }","preventionTips":["Verify repository connectivity before opening jobs","Keep repositories in sync when migrating between environments","Re-save entries whose attributes fail to load"],"tags":["pdi","hl7","repository","database","job-entry"],"backgroundTag":"database-query-failed","analyzedSha":"f3058517a153da500bf4551f46d79b91bf8ec552","analyzedAt":"2026-09-13T14:04:16.340Z","contentChangedAt":"2026-09-13T14:04:16.340Z","schemaVersion":2},"datasetVersion":"2026-09-20T23:17:15.980Z"}