{"record":{"id":"ecf4bd7f0bad7495","repo":"pentaho/pentaho-kettle","slug":"failed-to-load-cache","errorCode":null,"errorMessage":"Failed to load cache","messagePattern":"Failed to load cache","errorType":"exception","errorClass":"KettleException","httpStatus":null,"severity":"error","filePath":"plugins/palo/core/src/main/java/org/pentaho/di/trans/steps/palo/dimoutput/PaloDimOutput.java","lineNumber":97,"sourceCode":"          numRow = -1;\n          this.logDebug( \"Consolidation factor was left to the default\" );\n        } else {\n          numRow = getInputRowMeta().indexOfValue( consolidationFieldName );\n          if ( numRow < 0 ) {\n            throw new KettleException( \"DimOutput: failed to find input row meta for \".concat( meta.getLevels().get( i )\n              .getConsolidationFieldName() ) );\n          }\n          this.logDebug( meta.getLevels().get( i ).getConsolidationFieldName() + \" has index: \" + numRow );\n        }\n        data.indexes[( i * 2 ) + 1] = numRow;\n      }\n      data.helper.manageDimension( meta.getDimension(), meta.getCreateNewDimension(), meta.getClearDimension(), meta\n        .getClearConsolidations(), meta.getRecreateDimension() );\n      try {\n        data.helper.loadDimensionCache( meta.getDimension(), meta.getEnableElementCache(), meta\n          .getPreloadElementCache() );\n      } catch ( Exception e ) {\n        throw new KettleException( \"Failed to load cache\", e );\n      }\n    }\n\n    if ( r != null ) {\n      rowCount++;\n\n      try {\n\n        ConsolidationElement parent = null;\n        for ( int i = 0; i < data.indexes.length; i++ ) {\n          if ( i % 2 == 0 ) {\n            if ( r[data.indexes[i]] == null ) {\n              continue;\n            }\n\n            data.elementNamesBatch.add( r[data.indexes[i]].toString() );\n          } else {\n            /* Default weight to 1 if it was left to default */","sourceCodeStart":79,"sourceCodeEnd":115,"githubUrl":"https://github.com/pentaho/pentaho-kettle/blob/f3058517a153da500bf4551f46d79b91bf8ec552/plugins/palo/core/src/main/java/org/pentaho/di/trans/steps/palo/dimoutput/PaloDimOutput.java#L79-L115","documentation":"After managing the dimension, the step calls PaloHelper.loadDimensionCache() inside a try/catch and rethrows any exception (from the PALO/Olap4j connection while enabling or preloading the element cache) wrapped as 'Failed to load cache'. The root cause is on the Palo server/connection side, not the transformation data.","triggerScenarios":"Enable/preload element cache is checked and loadDimensionCache() throws: Palo server unreachable, dimension missing on the server, insufficient rights, or connection dropped mid-load.","commonSituations":"Palo/Olap server restarted or down during run; dimension name typo or dimension deleted on server; firewall/timeout when preloading a large dimension; credentials lacking read rights to the dimension.","solutions":["Verify the Palo connection works (test in the connection dialog) and the server is up","Confirm the dimension name in the step exists on the Palo server and the user has read access","Uncheck 'Preload element cache' to reduce load requirements, or disable element cache if not needed","Inspect the wrapped cause (e) in the log for the underlying Palo/network error"],"exampleFix":"// before\nhelper.loadDimensionCache(\"Budget_Dim\", true, true); // dim missing on server\n// after\nhelper.loadDimensionCache(\"Budget\", true, false); // correct dim name; preload off","handlingStrategy":"try-catch","validationCode":"// pre-flight: verify Palo connectivity\ntestConnection(databaseMeta); // fails fast if server unreachable\nverifyDimensionExists(databaseMeta, meta.getDimension());","typeGuard":null,"tryCatchPattern":"try { helper.loadDimensionCache(dim, enableCache, preload); } catch (Exception e) {\n  logError(\"Cache load failed: \" + e.getCause(), e); setErrors(1); stopAll(true);\n}","preventionTips":["Test the Palo connection before running the transformation","Confirm the dimension exists on the server and user has read rights","Avoid preloading very large dimensions over slow links","Monitor Palo server availability in production runs"],"tags":["palo","cache","connection","olap"],"backgroundTag":"cache-load-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"}