Hello All,
Been working on this for a few days now.,
I have redo my scsm setup.
I have 2 windows server 2022 as VM and all updates; i installed sql server 2016 to each one alone with server management studio 13.
I install SCSM to one on the server and the other with SCSM Data warehouse.
I set up the register with data warehouse
My problem is the sync is failing
The only thing i can find is the event log is
An exception was thrown while processing GetDataWarehouseOrchestrationJobs for session ID uuid:46f5d68b-47cf-40ac-81bd-dd726d91e174;id=46.
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.parse()
at Microsoft.EnterpriseManagement.Mom.QueryGrammar.QueryGrammarParser.GetCriteriaXml(String query)
at Microsoft.EnterpriseManagement.ServiceDataLayer.DataWarehouseJobService.GetDataWarehouseOrchestrationJobs(String criteria, Int32 numberOfBatches)
Is there any other logs i can check; as i cant see anything wrong. i not changed any settings or added anything and this is fresh out of the box.
The only find i have done is added my user id to the admin user and thats it
Can anyone help
Thanks
Andrew
PS i have dyslexia so i hope the above make seance