Burst Sales Report error after migrating data to PostgreSQL

[greg.banbury]

Hi,

I have just finished setting up my BI server (CE 3.7) and have migrated the data sources from the built in HSQLDB to PostgreSQL.

The server starts up just fine, but I wanted to run the Burst Sales Report to test my e-mail configuration.

When I get to stage 2 of input (where you enter your e-mail address) and hit run I get the following error:

org.pentaho.platform.api.engine.UnresolvedParameterException: RuntimeContext.ERROR_0018 - The requested parameter "EMPLOYEENUMBER" has a NULL value

I have checked the SQL in the .xaction and can run it fine when connected to the sampledata database using pgadmin.

Cheers,
Greg

[Taqua]

The error message says you have a NULL value in your resultset. And somehow I believe it would not complain if NULL values were allowed by the XAction.

[greg.banbury]

I'm a little confused. I haven't altered the xaction, just the data source of the sampledata database...?

I get that I can edit the xaction to allow NULL values, but how could it ever have worked?

When I run the SQL from the xaction directly there are no NULL values?

My concern is that I have messed up the migration to PostgreSql...

[Taqua]

Maybe PostgreSQL handles certain cases (empty strings for instance) different than HSQL. Databases and SQL are NOT a standard (and only DBAs claim so to feel important) - every vendor is different and interoperation only exists in the most simplest cases. I think we ship with a sample data script for postgres, so use that to set up your sample database to be on the safe side.

And then I would test a basic report first. But be aware that you most likely will have to edit the SQL of these reports in PRD and republish it if the text and column quoting style between HSQL and Postgres is different.