Pentaho

 View Only

 Linux Upgrade Pentaho CE 9.2 to 9.4 Transform Load Issues

Steven Kienle's profile image
Steven Kienle posted 04-26-2023 10:42

We tried upgrading our Linux Pentaho CE server from v9.2 to v9.4 from a clean install of v9.4.  The server came up cleanly, we are able to log in and browse files.

But when we try to run a transform in background on the server or load a transform into PDI via this server, we get this error:

- Unable to load transformation with id [org.pentaho.repo.extension.RepositoryOpenSaveExtensionPoint$ $Lambda$ 447/1622066826@1b7404c1]
  Client received SOAP Fault from server: exception while getting version information for file with id "58060fa2-3a1b-4e85-9d77-b58c8a886b34" and version id "null"  
    - Reference number: f826d844-a394-438e-bf05-6f7f947c2065 Please see the server log to find more detail regarding exact cause of the failure.

To make things odd, when I installed Pentaho v9.4 on a Windows machine, I can run and open the transform without that error.

Has anyone seen this and have a solution or ideas as to what is happening?

Thanks,
Steve

Petr Prochazka's profile image
Petr Prochazka

Hi Steven,
are you using default HSQL storage?

More information can be in tomcat/logs/pentaho.log or tomcat/logs/localhost-<date>.log. There would be stacktrace of error.

Steven Kienle's profile image
Steven Kienle

Petr,

I did forget to include that information.  We are using PostgreSQL as our repository server.

Attached is the relevant section of the log.  I am not a Java guru or have even looked at Pentaho's code, so any help would be appreciated.

Thanks!

Attachment  View in library
Failure.log 14 KB
Petr Prochazka's profile image
Petr Prochazka

This looks like version problem of file.

Check if you can download file from repository via web or run directly in Browse Files. Or try upload trans again and replace file in directory.

Steven Kienle's profile image
Steven Kienle

Petr,

Thank you.  In digging into the log more, we realized that the pentaho-solutions/system/jackrabbit/repository.xml file had an error in it.

Petr Prochazka's profile image
Petr Prochazka

Good news. :-) You are welcome.