{"record":{"id":"182f4d7501b145e0","repo":"pentaho/pentaho-kettle","slug":"unable-to-load-job-entry-from-the-repository-for-id-jobentry","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/hl7mllpack/HL7MLLPAcknowledge.java","lineNumber":113,"sourceCode":"      super.loadXML( entrynode, databases, slaveServers );\n\n      server = XMLHandler.getTagValue( entrynode, \"server\" );\n      port = XMLHandler.getTagValue( entrynode, \"port\" );\n      variableName = XMLHandler.getTagValue( entrynode, \"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      variableName = rep.getJobEntryAttributeString( idJobentry, \"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(), \"variable\", variableName );\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\n    try {\n","sourceCodeStart":95,"sourceCodeEnd":131,"githubUrl":"https://github.com/pentaho/pentaho-kettle/blob/f3058517a153da500bf4551f46d79b91bf8ec552/plugins/hl7/core/src/main/java/org/pentaho/di/job/entries/hl7mllpack/HL7MLLPAcknowledge.java#L95-L131","documentation":"HL7MLLPAcknowledge.loadRep() reads the entry's attributes (server, port, variable) from the Pentaho repository. A KettleDatabaseException while fetching these attributes is caught and rethrown as a KettleException: 'Unable to load job entry from the repository for id_jobentry=<id>' with the database error as cause.","triggerScenarios":"Calling loadRep when rep.getJobEntryAttributeString(idJobentry, ...) throws — typically because the r_jobentry_attribute rows for that id_jobentry are missing or the repository database is unreachable/errors out.","commonSituations":"Repository row corruption or partial save; connecting to a repository where the job exists but its attributes do not; repository database connectivity/authentication failures; orphaned job entries after failed migrations.","solutions":["Check the chained KettleDatabaseException cause for the actual repository DB error","Verify the repository database is reachable and credentials are valid","Inspect r_jobentry_attribute for rows with the given id_jobentry; re-save the job entry if missing","Re-create the job entry in the repository if its attributes 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":["Monitor repository DB health before batch job loads","Avoid manual deletes in r_jobentry_attribute","Back up the repository before migrations"],"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"}