Pentaho

 View Only
  • 1.  PDI 9.2 : Edit jobs/transformations - 401 unauthorized

    Posted 12-19-2023 05:14

    Hello,

    We have the following installation: 

    Server side

    PDI 9.2
    Linux
    Java 8

    Client side

    Pentaho 9.2 and 9.4 client
    Windows
    Java 8

    The problem we're encountering is that from a user A's account, this user is unable to update a job. He gets this error: 

    javax.ws.rs.WebApplicationException: 401 Unauthorized
    	at com.pentaho.di.services.PentahoDiPlugin$PurRepositoryPluginApiRevision$PathIdVersioningConfiguration.getAsFileVersioningConfigurationXml(PentahoDiPlugin.java:507)
    	at org.pentaho.di.repository.pur.PurRepositorySecurityProvider.callVersioningService(PurRepositorySecurityProvider.java:152)
    	at org.pentaho.di.repository.pur.PurRepositorySecurityProvider.isVersioningEnabled(PurRepositorySecurityProvider.java:132)
    	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    	at org.pentaho.di.repository.pur.UnifiedRepositoryInvocationHandler.invoke(UnifiedRepositoryInvocationHandler.java:41)
    	at com.sun.proxy.$Proxy91.isVersioningEnabled(Unknown Source)
    	at org.pentaho.di.ui.spoon.Spoon.checkIsVersioningEnabledOnServer(Spoon.java:6949)
    	at org.pentaho.di.ui.spoon.Spoon.isVersionEnabled(Spoon.java:6934)
    	at org.pentaho.di.ui.spoon.Spoon.setShellText(Spoon.java:6973)
    	at org.pentaho.di.ui.spoon.Spoon.refreshTree(Spoon.java:6608)
    	at org.pentaho.di.ui.spoon.delegates.SpoonTabsDelegate.tabSelected(SpoonTabsDelegate.java:507)
    	at org.pentaho.di.ui.spoon.Spoon.tabSelected(Spoon.java:3407)
    	at org.pentaho.xul.swt.tab.TabSet.notifySelectListeners(TabSet.java:134)
    	at org.pentaho.xul.swt.tab.TabSet.setSelected(TabSet.java:236)
    	at org.pentaho.di.ui.spoon.delegates.SpoonTransformationDelegate.addTransGraph(SpoonTransformationDelegate.java:218)
    	at org.pentaho.di.ui.spoon.delegates.SpoonEETransformationDelegate.addTransGraph(SpoonEETransformationDelegate.java:50)
    	at org.pentaho.di.ui.spoon.Spoon.addTransGraph(Spoon.java:8987)
    	at org.pentaho.di.ui.spoon.Spoon.loadLastUsedFile(Spoon.java:8401)
    	at org.pentaho.di.ui.spoon.Spoon.loadLastUsedFileAtStartup(Spoon.java:8283)
    	at org.pentaho.di.ui.spoon.Spoon.loadLastUsedFiles(Spoon.java:8106)
    	at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9541)
    	at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:722)
    	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    	at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)

    Pentaho is linked to an LDAP/AD. User A has the same rights as the other users, who do not have this problem.

    Checking the spoon.log file on the client side, we find this error: 

    2023/12/14 13:47:39 - General - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Error registring plugin class from KETTLE_PLUGIN_CLASSES: org.pentaho.di.trans.steps.ldapinput.LDAPInputMeta
    2023/12/14 13:47:39 - General - java.lang.ClassNotFoundException: org.pentaho.di.trans.steps.ldapinput.LDAPInputMeta
    2023/12/14 13:47:39 - General - 	at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:476)
    2023/12/14 13:47:39 - General - 	at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:589)
    2023/12/14 13:47:39 - General - 	at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522)
    2023/12/14 13:47:39 - General - 	at java.base/java.lang.Class.forName0(Native Method)
    2023/12/14 13:47:39 - General - 	at java.base/java.lang.Class.forName(Class.java:315)
    2023/12/14 13:47:39 - General - 	at org.pentaho.di.core.plugins.PluginRegistry.registerType(PluginRegistry.java:629)
    2023/12/14 13:47:39 - General - 	at org.pentaho.di.core.plugins.PluginRegistry.init(PluginRegistry.java:560)
    2023/12/14 13:47:39 - General - 	at org.pentaho.di.core.plugins.PluginRegistry.init(PluginRegistry.java:545)
    2023/12/14 13:47:39 - General - 	at org.pentaho.di.core.KettleClientEnvironment.init(KettleClientEnvironment.java:118)
    2023/12/14 13:47:39 - General - 	at org.pentaho.di.core.KettleClientEnvironment.init(KettleClientEnvironment.java:81)
    2023/12/14 13:47:39 - General - 	at org.pentaho.di.core.KettleEnvironment.init(KettleEnvironment.java:134)
    2023/12/14 13:47:39 - General - 	at org.pentaho.di.core.KettleEnvironment.init(KettleEnvironment.java:101)
    2023/12/14 13:47:39 - General - 	at org.pentaho.di.core.KettleEnvironment.init(KettleEnvironment.java:82)
    2023/12/14 13:47:39 - General - 	at org.pentaho.di.ui.spoon.Spoon$1.call(Spoon.java:654)
    2023/12/14 13:47:39 - General - 	at org.pentaho.di.ui.spoon.Spoon$1.call(Spoon.java:646)
    2023/12/14 13:47:39 - General - 	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
    2023/12/14 13:47:39 - General - 	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
    2023/12/14 13:47:39 - General - 	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
    2023/12/14 13:47:39 - General - 	at java.base/java.lang.Thread.run(Thread.java:829)

    Could you give us an idea of the cause of the blockage?

    Do you think the origin of the problem lies with the Pentaho server, the Pentaho client, the LDAP or something else?

    Best regards,



    ------------------------------
    Kevin Pemonon
    ------------------------------


  • 2.  RE: PDI 9.2 : Edit jobs/transformations - 401 unauthorized

    Posted 12-20-2023 11:32

    From the client side error, I would think it could be related to caching as you shift the client between 9.2 to 9.4.   Clear the dbcache from ~/.kettle.  To allow cleaner switching between versions I use $KETTLE_HOME and change per version, so that I do not use the same ~/.kettle folder.  You can check ~/.pentaho as well, but I do not believe there is any caching there.



    ------------------------------
    Stephen Donovan
    Digital Solutions Architect
    Hitachi Vantara
    ------------------------------



  • 3.  RE: PDI 9.2 : Edit jobs/transformations - 401 unauthorized

    Posted 12-22-2023 03:41

    Hello Stephen,

    Thank you for your feedback, we will try these actions.

    Best regards



    ------------------------------
    Kevin Pemonon
    Others
    Atos
    ------------------------------