{"record":{"id":"5d6aa54e65d6fbef","repo":"pentaho/pentaho-kettle","slug":"jobentrymsaccessbulkload-meta-unableloadrep","errorCode":"JobEntryMSAccessBulkLoad.Meta.UnableLoadRep","errorMessage":"JobEntryMSAccessBulkLoad.Meta.UnableLoadRep","messagePattern":"JobEntryMSAccessBulkLoad\\.Meta\\.UnableLoadRep","errorType":"exception","errorClass":"KettleException","httpStatus":null,"severity":"error","filePath":"plugins/ms-access/impl/src/main/java/org/pentaho/di/job/entries/msaccessbulkload/JobEntryMSAccessBulkLoad.java","lineNumber":232,"sourceCode":"\n      // How many arguments?\n      int argnr = rep.countNrJobEntryAttributes( id_jobentry, \"source_filefolder\" );\n      source_filefolder = new String[argnr];\n      source_wildcard = new String[argnr];\n      delimiter = new String[argnr];\n      target_Db = new String[argnr];\n      target_table = new String[argnr];\n\n      // Read them all...\n      for ( int a = 0; a < argnr; a++ ) {\n        source_filefolder[a] = rep.getJobEntryAttributeString( id_jobentry, a, \"source_filefolder\" );\n        source_wildcard[a] = rep.getJobEntryAttributeString( id_jobentry, a, \"source_wildcard\" );\n        delimiter[a] = rep.getJobEntryAttributeString( id_jobentry, a, \"delimiter\" );\n        target_Db[a] = rep.getJobEntryAttributeString( id_jobentry, a, \"target_db\" );\n        target_table[a] = rep.getJobEntryAttributeString( id_jobentry, a, \"target_table\" );\n      }\n    } catch ( KettleException dbe ) {\n      throw new KettleException( BaseMessages.getString( PKG, \"JobEntryMSAccessBulkLoad.Meta.UnableLoadRep\", \"\"\n        + id_jobentry, dbe.getMessage() ), dbe );\n    }\n  }\n\n  private void displayResults() {\n    if ( log.isDetailed() ) {\n      logDetailed( \"=======================================\" );\n      logDetailed( BaseMessages.getString( PKG, \"JobEntryMSAccessBulkLoad.Log.Info.FilesToLoad\", \"\"\n        + NrFilesToProcess ) );\n      logDetailed( BaseMessages.getString( PKG, \"JobEntryMSAccessBulkLoad.Log.Info.FilesLoaded\", \"\" + NrSuccess ) );\n      logDetailed( BaseMessages.getString( PKG, \"JobEntryMSAccessBulkLoad.Log.Info.NrErrors\", \"\" + NrErrors ) );\n      logDetailed( \"=======================================\" );\n    }\n  }\n\n  public void setLimit( String limit ) {\n    this.limit = limit;\n  }","sourceCodeStart":214,"sourceCodeEnd":250,"githubUrl":"https://github.com/pentaho/pentaho-kettle/blob/f3058517a153da500bf4551f46d79b91bf8ec552/plugins/ms-access/impl/src/main/java/org/pentaho/di/job/entries/msaccessbulkload/JobEntryMSAccessBulkLoad.java#L214-L250","documentation":"KettleException thrown by JobEntryMSAccessBulkLoad.loadRep when reading the job entry's attributes from the Pentaho repository fails. The message embeds the job entry ObjectId and the database error message. The job entry cannot be loaded from the repository.","triggerScenarios":"loadRep(Repository, IMetaStore, ObjectId id_jobentry, ...) hitting a KettleDatabaseException: the repository rows for this job entry are missing/corrupt, the repository connection dropped mid-load, or attribute tables are incompatible.","commonSituations":"Repository database upgraded/downgraded between PDI versions so attribute schemas differ; broken network to the repository DB mid-session; partially deleted job entries (parent row deleted, attribute rows orphaned or vice versa); repository permissions problems.","solutions":["Test the repository connection and retry loading the job; transient DB issues are a common cause.","Verify repository tables (r_jobentry_attribute) contain consistent rows for the reported id_jobentry; repair or re-save the job entry.","Check PDI and repository schema versions match; run the repository upgrade scripts if the metadata was written by a different version.","As a workaround, re-create the MS Access Bulk Load job entry and re-save the job to the repository."],"exampleFix":null,"handlingStrategy":"try-catch","validationCode":null,"typeGuard":null,"tryCatchPattern":"try { entry.loadRep( rep, metaStore, id_jobentry, databases, slaveServers ); } catch ( KettleException e ) { logError( \"Repository load failed for entry \" + id_jobentry + \": \" + e.getCause(), e ); }","preventionTips":["Verify repository connectivity before opening jobs","Keep PDI and repository schema versions in sync","Avoid concurrent edits of the same job entry in the repository","Monitor repository DB health"],"tags":["kettle","repository","database","job-entry","metadata"],"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"}