Pentaho

 View Only

 Error running scheduled jo: RDBMS access to transformation not allowed when repository type is 'files'

Jump to Best Answer
Claudio Battaglino's profile image
Claudio Battaglino posted 06-28-2023 16:49

Hi,

when I execute "Run now" on a scheduled job, on the web interface of a Pentaho Server, I have this error :

6:58,393 ERROR [KettleComponent] 8725a00b-15f3-11ee-bad9-a288d66c0349:COMPONENT:context-452996252-1687984618369:j_load_accademici_datamart.xactionKettle.ERROR_0019 
- [it_368] RDBMS access to transformation not allowed when repository type is 'files'. 
20:36:58,393 ERROR [SolutionEngine] 8725a00b-15f3-11ee-bad9-a288d66c0349:SOLUTION-ENGINE:/public/xxx/Etl/accademici/j_load_accademici_datamart.xaction/j_load_accademici_datamart.xaction: 
Action Sequence execution failed, see details below
2023-06-28T20:36:58.393648658Z | Error Time: mercoledì 28 giugno 2023 20.36.58 UTC
2023-06-28T20:36:58.393654316Z | Session ID: claudio@xxx.it
2023-06-28T20:36:58.393659000Z | Instance Id: 8725a00b-15f3-11ee-bad9-a288d66c0349
2023-06-28T20:36:58.393667660Z | Action Sequence: j_load_accademici_datamart.xaction
2023-06-28T20:36:58.393671146Z | Execution Stack:
EXECUTING ACTION: Pentaho Data Integration Job (KettleComponent)
2023-06-28T20:36:58.393677459Z | Action Class: KettleComponent
2023-06-28T20:36:58.393680301Z | Action Desc: Pentaho Data Integration Job
2023-06-28T20:36:58.393683049Z | Loop Index: N/A
2023-06-28T20:36:58.393686155Z Stack Trace:org.pentaho.platform.api.engine.ActionValidationException: RuntimeContext.ERROR_0035 - 
Action validation failed.
2023-06-28T20:36:58.393689351Z 	at org.pentaho.platform.engine.services.runtime.RuntimeContext.validateComponents(RuntimeContext.java:533)
2023-06-28T20:36:58.393692078Z 	at org.pentaho.platform.engine.services.runtime.RuntimeContext.validateSequence(RuntimeContext.java:477)
2023-06-28T20:36:58.393694939Z 	at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:352)
2023-06-28T20:36:58.393697769Z 	at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:284)
2023-06-28T20:36:58.393700537Z 	at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:181)
2023-06-28T20:36:58.393711405Z 	at org.pentaho.platform.plugin.action.builtin.ActionSequenceAction.execute(ActionSequenceAction.java:89)
	at org.pentaho.platform.scheduler2.action.ActionRunner.callImpl(ActionRunner.java:176)

I migrated this schedulation from a Pentaho Server CE 9.2 to a Pentaho Server Ce 9.4.

On the previous server it works.

What does mean that "RDBMS access to transformation not allowed when repository type is 'files'" ?

Thank you

Claudio

Claudio Battaglino's profile image
Claudio Battaglino posted 06-29-2023 04:15 Best Answer

I've found this solution:

"

Pentaho Data Integration Tool A: To enable the option, open options dialog box by selecting Edit- >Options from the menu bar and check the display tool tip Q13: How to resolve the following error? Kettle.ERROR_ RDBMS access to transformation not allowed when repository type is 'files A:

 open the settings.xml file located in the pentaho-solutions/system/kettle directory 

1. Set the content of the repository.type element to rdbms. If you want to use a PDI repository. 
2. Put the name of the repository you want to use in the repository.name element. Same as existing repository defined in PDI s repositories.xml file. 
3. Set the repository.name element to the name of the repository user that is to connect to the repository. 
4. Set the repository.password element to the password of the repository user. 

"

Related Content