{"record":{"id":"ee46eca1b751820b","repo":"pentaho/pentaho-kettle","slug":"unable-to-load-job-entry-of-type-create-file-from-the","errorCode":null,"errorMessage":"Unable to load job entry of type 'create file' from the repository for id_jobentry=${id_jobentry}","messagePattern":"Unable to load job entry of type 'create file' from the repository for id_jobentry=(.+?)","errorType":"exception","errorClass":"KettleException","httpStatus":null,"severity":"error","filePath":"engine/src/main/java/org/pentaho/di/job/entries/createfile/JobEntryCreateFile.java","lineNumber":114,"sourceCode":"      super.loadXML( entrynode, databases, slaveServers );\n      filename = XMLHandler.getTagValue( entrynode, \"filename\" );\n      failIfFileExists = \"Y\".equalsIgnoreCase( XMLHandler.getTagValue( entrynode, \"fail_if_file_exists\" ) );\n      addfilenameresult = \"Y\".equalsIgnoreCase( XMLHandler.getTagValue( entrynode, \"add_filename_result\" ) );\n\n    } catch ( KettleXMLException xe ) {\n      throw new KettleXMLException( \"Unable to load job entry of type 'create file' from XML node\", xe );\n    }\n  }\n\n  public void loadRep( Repository rep, IMetaStore metaStore, ObjectId id_jobentry, List<DatabaseMeta> databases,\n    List<SlaveServer> slaveServers ) throws KettleException {\n    try {\n      filename = rep.getJobEntryAttributeString( id_jobentry, \"filename\" );\n      failIfFileExists = rep.getJobEntryAttributeBoolean( id_jobentry, \"fail_if_file_exists\" );\n      addfilenameresult = rep.getJobEntryAttributeBoolean( id_jobentry, \"add_filename_result\" );\n\n    } catch ( KettleException dbe ) {\n      throw new KettleException(\n        \"Unable to load job entry of type 'create file' from the repository for id_jobentry=\" + id_jobentry, 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(), \"filename\", filename );\n      rep.saveJobEntryAttribute( id_job, getObjectId(), \"fail_if_file_exists\", failIfFileExists );\n      rep.saveJobEntryAttribute( id_job, getObjectId(), \"add_filename_result\", addfilenameresult );\n\n    } catch ( KettleDatabaseException dbe ) {\n      throw new KettleException( \"Unable to save job entry of type 'create file' to the repository for id_job=\"\n        + id_job, dbe );\n    }\n  }\n\n  public void setFilename( String filename ) {\n    this.filename = filename;","sourceCodeStart":96,"sourceCodeEnd":132,"githubUrl":"https://github.com/pentaho/pentaho-kettle/blob/f3058517a153da500bf4551f46d79b91bf8ec552/engine/src/main/java/org/pentaho/di/job/entries/createfile/JobEntryCreateFile.java#L96-L132","documentation":"JobEntryCreateFile.loadRep throws this KettleException when loading the 'create file' job entry's attributes from the Pentaho repository fails for the given id_jobentry. It wraps KettleException (typically database errors) raised by rep.getJobEntryAttributeString/Boolean.","triggerScenarios":"Calling loadRep when reading 'filename', 'fail_if_file_exists' or 'add_filename_result' attributes fails — repository connection error, missing R_JOBENTRY_ATTRIBUTE rows, or DB-level failure for that id_jobentry.","commonSituations":"Repository DB temporarily unreachable when opening a job; rows purged/corrupted in the repository; schema version mismatch after upgrading Pentaho; restored repository backup missing recent rows.","solutions":["Check repository database connectivity and retry opening the job.","Re-save the job entry in Spoon to recreate missing attribute rows.","Verify repository schema version matches the Pentaho version (repair/upgrade repository).","Inspect the chained cause for the underlying SQL error."],"exampleFix":null,"handlingStrategy":"try-catch","validationCode":"if (id_jobentry == null || id_jobentry.getId() <= 0) throw new IllegalArgumentException(\"id_jobentry must be a saved object id\");\nif (!rep.isConnected() && !rep.connect()) throw new IllegalStateException(\"Repository DB unreachable\");","typeGuard":null,"tryCatchPattern":"try {\n  jobEntry.loadRep(rep, metaStore, id_jobentry, databases, slaveServers);\n} catch (KettleException e) {\n  logError(\"Repo load failed for create-file entry \" + id_jobentry + \": \" + e.getCause(), e);\n  // reconnect and retry once, then apply defaults\n}","preventionTips":["Confirm DB reachability before opening jobs from the repository","Run repository repair after failed saves to remove partial rows","Keep Pentaho client and repository schema versions in sync","Restore missing rows by re-saving the job in Spoon"],"tags":["pdi","kettle","repository","database"],"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"}