{"record":{"id":"4431aae27fbea00c","repo":"pentaho/pentaho-kettle","slug":"unable-to-load-job-entry-for-type-file-exists-from-the-4431aa","errorCode":null,"errorMessage":"Unable to load job entry for type file exists from the repository for id_jobentry=","messagePattern":"Unable to load job entry for type file exists from the repository for id_jobentry=","errorType":"exception","errorClass":"KettleException","httpStatus":null,"severity":"error","filePath":"plugins/palo/core/src/main/java/org/pentaho/di/job/entries/palo/JobEntryCubeDelete/PaloCubeDelete.java","lineNumber":104,"sourceCode":"    try {\n      super.loadXML( entrynode, databases, slaveServers );\n\n      this.setDatabaseMeta( DatabaseMeta.findDatabase( databases, XMLHandler.getTagValue( entrynode, \"connection\" ) ) );\n      this.setCubeName( XMLHandler.getTagValue( entrynode, \"cubeName\" ) );\n    } catch ( KettleXMLException xe ) {\n      throw new KettleXMLException( \"Unable to load file exists job entry 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      this.databaseMeta =\n          rep.loadDatabaseMetaFromJobEntryAttribute( id_jobentry, \"connection\", \"id_database\", databases );\n      this.setCubeName( rep.getStepAttributeString( id_jobentry, \"cubeName\" ) );\n\n    } catch ( KettleException dbe ) {\n      throw new KettleException( \"Unable to load job entry for type file exists from the repository for id_jobentry=\"\n          + id_jobentry, dbe );\n    }\n  }\n\n  public void saveRep( Repository rep, IMetaStore metaStore, ObjectId id_job ) throws KettleException {\n    try {\n\n      rep.saveDatabaseMetaJobEntryAttribute( id_job, getObjectId(), \"connection\", \"id_database\", databaseMeta );\n      rep.saveStepAttribute( id_job, getObjectId(), \"cubeName\", this.getCubeName() );\n\n    } catch ( KettleDatabaseException dbe ) {\n      throw new KettleException(\n          \"unable to save jobentry of type 'file exists' to the repository for id_job=\" + id_job, dbe );\n    }\n  }\n\n  public Result execute( Result prevResult, int nr ) throws KettleException {\n","sourceCodeStart":86,"sourceCodeEnd":122,"githubUrl":"https://github.com/pentaho/pentaho-kettle/blob/f3058517a153da500bf4551f46d79b91bf8ec552/plugins/palo/core/src/main/java/org/pentaho/di/job/entries/palo/JobEntryCubeDelete/PaloCubeDelete.java#L86-L122","documentation":"Thrown by PaloCubeDelete.loadRep() when reading the entry's attributes from the repository raises a KettleException (wrapped as 'Unable to load job entry for type file exists from the repository for id_jobentry=<id>'). 'file exists' is a stale message; the failing entry is the Palo Delete cube entry.","triggerScenarios":"loadRep called for an id_jobentry whose 'connection'/'id_database' or 'cubeName' attributes cannot be loaded via loadDatabaseMetaFromJobEntryAttribute or getStepAttributeString due to repository errors.","commonSituations":"Missing r_jobentry_attribute rows; broken id_database reference after connections were deleted; repository connectivity problems; schema mismatch after upgrade.","solutions":["Check the wrapped KettleException cause and repository health","Verify the referenced database connection (id_database) still exists in the repository","Recreate the job entry and resave its attributes","Restore missing r_jobentry_attribute rows from backup"],"exampleFix":"// before: connection referenced by 'id_database' was deleted\n// after: recreate the connection in the repository so id_database resolves, then reload the job","handlingStrategy":"try-catch","validationCode":"if ( rep.getJobEntryAttributeString( id_jobentry, \"cubeName\" ) == null ) {\n  log.warn( \"id_jobentry \" + id_jobentry + \" missing cubeName; check r_jobentry_attribute rows\" );\n}","typeGuard":null,"tryCatchPattern":"try { entry.loadRep( rep, metaStore, id, databases, slaves ); } catch ( KettleException e ) { log.error( \"Repository load failed for PaloCubeDelete id_jobentry=\" + id, e ); throw e; }","preventionTips":["Never delete database connections referenced by job entries without remapping","Back up repository tables before upgrades","Check repository health after partial restores"],"tags":["kettle","pdi","repository","palo","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"}