Profile

This is an old question so probably the OP doesn't need the answer anymore, but in case anyone else does, here's my take. I've never tried importing transformations or jobs via the PUC. You can import using the PDI Client (Spoon) or using the command line data-integration/import(.bat or .sh, as appropriate). ...

A possibility, may not be a very good one, is to use either a User-defined Java Class or Java Expression step to covert the text to an array of bytes and then create the sha256sum hash on that. I haven't tried this, but if you specify String.getBytes( "UTF-16LE" ) that should get you the input you need ...

It sounds like the file is in the correct place but the configuration is not set up to identify the driver class to use. On our Windows install, the configuration info is in: D:\Pentaho-9.3\server\pentaho-server\tomcat\webapps\pentaho\META-INF\context.xml and looks like this (of course, you'll need ...

We use the MS SQL Server JDBC driver; any version of that should work with SQL Server 2016.  The last time I checked (quite a while ago), jTDS hadn't been updated in a long time, but I don't see any reason it wouldn't work either. Although we haven't tried 9.3 specifically with SQL Server 2016, I cannot ...

Thanks, Stephen. Yes, we're an enterprise customer, but being on an unsupported version of Pentaho means the available support is limited, but the idea that one of the prior tuple queries returned no results is a great place to look. What seems odd is that if the report is recreated from scratch, it ...

We are on 9.0.0.7 (still waiting to get a clean process to upgrade to 9.3 on our Linux environments). We have some reports with 7 different filters and the reports return no results (when we know there is data). When we examine the generated SQL (mondrian_sql.log), we find this very odd condition in ...