{"record":{"id":"55ccdf66879c0448","repo":"pentaho/pentaho-kettle","slug":"unable-to-load-job-entry-of-type-mysql-bulk-load-to-the","errorCode":null,"errorMessage":"Unable to load job entry of type 'Mysql Bulk Load' to the repository for id_job=","messagePattern":"Unable to load job entry of type 'Mysql Bulk Load' to the repository for id_job=","errorType":"exception","errorClass":"KettleException","httpStatus":null,"severity":"error","filePath":"engine/src/main/java/org/pentaho/di/job/entries/mysqlbulkfile/JobEntryMysqlBulkFile.java","lineNumber":199,"sourceCode":"      rep.saveJobEntryAttribute( id_job, getObjectId(), \"schemaname\", schemaname );\n      rep.saveJobEntryAttribute( id_job, getObjectId(), \"tablename\", tablename );\n      rep.saveJobEntryAttribute( id_job, getObjectId(), \"filename\", filename );\n      rep.saveJobEntryAttribute( id_job, getObjectId(), \"separator\", separator );\n      rep.saveJobEntryAttribute( id_job, getObjectId(), \"enclosed\", enclosed );\n      rep.saveJobEntryAttribute( id_job, getObjectId(), \"lineterminated\", lineterminated );\n      rep.saveJobEntryAttribute( id_job, getObjectId(), \"limitlines\", limitlines );\n      rep.saveJobEntryAttribute( id_job, getObjectId(), \"listcolumn\", listcolumn );\n      rep.saveJobEntryAttribute( id_job, getObjectId(), \"highpriority\", highpriority );\n      rep.saveJobEntryAttribute( id_job, getObjectId(), \"optionenclosed\", optionenclosed );\n\n      rep.saveJobEntryAttribute( id_job, getObjectId(), \"outdumpvalue\", outdumpvalue );\n      rep.saveJobEntryAttribute( id_job, getObjectId(), \"iffileexists\", iffileexists );\n\n      rep.saveJobEntryAttribute( id_job, getObjectId(), \"addfiletoresult\", addfiletoresult );\n\n      rep.saveDatabaseMetaJobEntryAttribute( id_job, getObjectId(), \"connection\", \"id_database\", connection );\n    } catch ( KettleDatabaseException dbe ) {\n      throw new KettleException(\n        \"Unable to load job entry of type 'Mysql Bulk Load' to the repository for id_job=\" + id_job, dbe );\n    }\n  }\n\n  public void setTablename( String tablename ) {\n    this.tablename = tablename;\n  }\n\n  public void setSchemaname( String schemaname ) {\n    this.schemaname = schemaname;\n  }\n\n  public String getTablename() {\n    return tablename;\n  }\n\n  public String getSchemaname() {\n    return schemaname;","sourceCodeStart":181,"sourceCodeEnd":217,"githubUrl":"https://github.com/pentaho/pentaho-kettle/blob/f3058517a153da500bf4551f46d79b91bf8ec552/engine/src/main/java/org/pentaho/di/job/entries/mysqlbulkfile/JobEntryMysqlBulkFile.java#L181-L217","documentation":"KettleException thrown by JobEntryMysqlBulkFile.saveRep() when writing this entry's attributes to the repository fails with a KettleDatabaseException, including persisting the connection via saveDatabaseMetaJobEntryAttribute. It is a repository write failure while saving the 'Mysql Bulk Load' entry.","triggerScenarios":"Calling saveRep() when any saveJobEntryAttribute call or saveDatabaseMetaJobEntryAttribute(id_job, getObjectId(), \"connection\", \"id_database\", connection) throws — DB downtime, constraint violations, or an unsaved/unpersistable connection object.","commonSituations":"Saving during repository maintenance/downtime; repository account lost write privileges; the entry references a connection that cannot be persisted.","solutions":["Examine the wrapped KettleDatabaseException cause and fix the JDBC-level problem (connectivity, permissions, constraints).","Ensure the entry's database connection is valid and saved before saving the job.","Restore write access for the repository user on the R_* attribute tables.","Retry the save after the repository is healthy."],"exampleFix":null,"handlingStrategy":"try-catch","validationCode":"// before save: ensure rep is connected and connection is set\nif ( !rep.isConnected() ) rep.connect();\nif ( jobEntry.getDatabaseConnection() == null ) throw new KettleValidationException( \"no connection set on entry\" );","typeGuard":null,"tryCatchPattern":"try { jobEntry.saveRep( rep, metaStore, idJob ); } catch ( KettleException e ) { logError( \"Repository save failed: \" + e.getCause(), e ); /* retry after fixing DB */ }","preventionTips":["Validate the entry's database connection before saving","Maintain repository connectivity and write privileges","Schedule saves outside maintenance windows","Log full KettleDatabaseException cause chains"],"tags":["kettle","repository","database","job-entry","mysql"],"backgroundTag":"database-write-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"}