SCSM 2012 Data Warehouse jobs keep failing

re: SCSM 2012 Data Warehouse jobs keep failing

Doug — Wed, 03 Oct 2012 19:25:14 GMT

No worries Thomas. I reached out to Microsoft about it. Looks like the SCSM 2012 code checks for the SQL version and if it's Enterprise, the process automatically runs the PROCESS INCREMENTAL.

"1) Our code checks the version of SQL (Enterprise or Standard) and takes a different path based on the edition. In case of Enterprise it will automatically do Incremental processing. Nothing needs to be configured on the SQL server."

re: SCSM 2012 Data Warehouse jobs keep failing

Thomas Ellermann — Tue, 02 Oct 2012 11:56:15 GMT

Hi Doug

I'm sorry but I'm not a SQL expert and don't know how to configure SQL to do the incremental updates instead of full. I do know that SQL Enterprise edition has that feature, compared to standard edition.

The script above is a workaround to have the cubes fully processed. If you're looking for a way to have them processed incremental on a daily basis, you have to go for the SQL documentation :-)

Thanks

Thomas

re: SCSM 2012 Data Warehouse jobs keep failing

Doug — Mon, 01 Oct 2012 15:45:14 GMT

Thomas,

Great article but need to know how to set the cubes to only run the PROCESS UPDATE instead of PROCESS FULL (number 2). How do I set the feature in SQL Enterprise?

Thanks!