How to enable DataWarehouse ETL jobs (Network Steve Forum)

How to enable DataWarehouse ETL jobs

SCSM 2012 r2 DataWarehouse ETL jobs disabled and status showing as running.

After Importing module Microsoft.EnterpriseManagement.Warehouse.Cmdlets.psd1'

When I am trying to enable Enable-SCDWJob -Jobname XXXXX is getting errors like

Enable-SCDWJob : Parse error before eof
At line:1 char:1
+ Enable-SCDWJob -JobName Extract_XXXX
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Enable-SCDWJob], QueryGrammarException
    + FullyQualifiedErrorId : Microsoft.EnterpriseManagement.Common.QueryGrammarException,Microsoft.EnterpriseManageme
   nt.Warehouse.Cmdlets.EnableSCDWJob

I checked the Eventlog and found the below:

An exception was thrown while processing GetDataWarehouseOrchestrationJobs for session ID uuid:d6be8b66-013f-4489-9cca-c2728ed32c4f;id=8.

Exception message: Parse error before eof

Full Exception: Microsoft.EnterpriseManagement.Common.QueryGrammarException: Parse error before eof

at Microsoft.EnterpriseManagement.Mom.QueryGrammar.QueryGrammarYaccClass.error(Int32 q_state, SSLexLexeme q_look)

at Microsoft.EnterpriseManagement.Mom.QueryGrammar.SSVParseLib.SSYacc.doError()

at Microsoft.EnterpriseManagement.Mom.QueryGrammar.SSVParseLib.SSYacc.parse()

at Microsoft.EnterpriseManagement.Mom.QueryGrammar.QueryGrammarParser.GetCriteriaXml(String query)

at Microsoft.EnterpriseManagement.ServiceDataLayer.DataWarehouseJobService.GetDataWarehouseOrchestrationJobs(String criteria, Int32 numberOfBatches)

Can you please help me to troubleshoot this issue.

April 10th, 2014 6:32am

I'm getting the same exact error.

Free Windows Admin Tool Kit Click here and download it now

July 12th, 2015 1:10am

Can you add this "-computername DWSRV" to the command.

July 14th, 2015 7:15pm

what about the MPSyncJob and DWMaintenance?

ETL jobs are disabled when the above two jobs are running.

you can check if there any error during the execution of these jobs by running the below commands:

get-scdwjobmodule -jobname MPSyncJob

get-scdwjobmodule -jobname DWMaintenance

Regards,

Free Windows Admin Tool Kit Click here and download it now

July 15th, 2015 3:13am

This topic is archived. No further replies will be accepted.