Profile

John Craig

Henry Schein One

Contact Details

Henry Schein One

My Content

1 to 6 of 6 total
Posted By John Craig 01-26-2023 12:46
Found In Egroup: Pentaho
\ view thread
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). ...
Posted By John Craig 01-26-2023 12:15
Found In Community: Pentaho
\ view thread
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 ...
Posted By John Craig 01-26-2023 11:52
Found In Egroup: Pentaho
\ view thread
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 ...
Posted By John Craig 01-25-2023 19:06
Found In Egroup: Pentaho
\ view thread
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 ...
Posted By John Craig 01-25-2023 18:43
Found In Community: Pentaho
\ view thread
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 ...
Posted By John Craig 01-24-2023 14:26
Found In Community: Pentaho
\ view thread
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 ...