SQL

If you update the SQL Server on your VCM install after the original installation you might run into the issue that you can't schedule any jobs anymore.

A quick fix can be achieved by the following SQL statement:


USE msdb
GRANT EXECUTE ON OBJECT::dbo.sp_add_category TO public
GRANT EXECUTE ON OBJECT::dbo.sp_add_job TO public
GRANT EXECUTE ON OBJECT::dbo.sp_add_jobschedule TO public
GRANT EXECUTE ON OBJECT::dbo.sp_add_jobserver TO public
GRANT EXECUTE ON OBJECT::dbo.sp_add_jobstep TO public
GRANT EXECUTE ON OBJECT::dbo.sp_add_schedule TO public Read more »

Have you ever recognized that a specific query runs into the Error that you need SQL_BIG_SELECTS=1.

The problem you will run into is that this is a session variable, so no chance to set it on the DB Server.

After spending multiple days with Pentaho Enterprise Support we had a chat with MySQL, they told us to set a Parameter in the connect string.

Which means the Database URL should be something like:


jdbc:mysql://DBServer:3306/datawh?defaultFetchSize=500&CursorFetch=true&sessionVariables=@@SQL_BIG_SELECTS=1


Replace DBServer with the Hostname. Read more »