Reconciliation Failing

[lward1]

I've recently been seeing reconciliation jobs failing. Even when I try to run reconciliation by Publisher. Does anyone have any ideas as to what could be causing a failure or things to check? Thanks in advance.

[Dushyant Singh1]

at [global] 'Schema' [sys_script_include:4e115aed73512300bb513198caf6a749]:260 (checkFieldType)
at [global] 'GlideQueryEvaluator' [sys_script_include:d52b3c8a08013300fa9b4300d8d67a76]:451 (setSingleValueToGlideRecord)
at [global] 'GlideQueryEvaluator' [sys_script_include:d52b3c8a08013300fa9b4300d8d67a76]:469 (setAllValuesToGlideRecord)
at [global] 'GlideQueryEvaluator' [sys_script_include:d52b3c8a08013300fa9b4300d8d67a76]:435 (updateMultiple)
at [global] 'GlideQuery' [sys_script_include:864c9ebf73631300bb513198caf6a721]:360 (updateMultiple)
at [global] 'SamPerCoreForMicrosoftLicenseCalculator' [sys_script_include:7b64995177b24010fdc35291a9106146]:1594 (anonymous)
at [global] 'SamLicenseCalculator' [sys_script_include:602e129eb0276300fa9b028ca0d3b864]:810 (anonymous)
at [global] 'SamLicenseCalculator' [sys_script_include:602e129eb0276300fa9b028ca0d3b864]:63 (anonymous)
at [global] 'SamLicenseCalculator' [sys_script_include:602e129eb0276300fa9b028ca0d3b864]:49 (anonymous)
at [global] 'SamsProductCalculator' [sys_script_include:8a6dbe2887522300ede6f64936cb0b2c]:143 (anonymous)
at [global] 'SamsProductCalculator' [sys_script_include:8a6dbe2887522300ede6f64936cb0b2c]:255 (anonymous)
at [global] 'SamsProductCalculator' [sys_script_include:8a6dbe2887522300ede6f64936cb0b2c]:144 (anonymous)
at [global] 'SamsProductCalculator' [sys_script_include:8a6dbe2887522300ede6f64936cb0b2c]:128 (anonymous)
at [global] 'SamsProductCalculator' [sys_script_include:8a6dbe2887522300ede6f64936cb0b2c]:119 (anonymous)
at [global] 'SamsProductCalculator' [sys_script_include:8a6dbe2887522300ede6f64936cb0b2c]:35 (anonymous)
at [global] 'SamPublisherCalculator' [sys_script_include:30bbdf9587f52300923aa75fe5cb0b97]:280 (anonymous)
at [global] 'ReconciliationEngine' [sys_script_include:6761b0dd0b1232001a17650d37673a77]:788 (anonymous)
at [global] 'ReconciliationEngine' [sys_script_include:6761b0dd0b1232001a17650d37673a77]:737 (anonymous)
at [global] 'ReconciliationEngine' [sys_script_include:6761b0dd0b1232001a17650d37673a77]:39 (anonymous)
at sys_trigger.57388820db2a385086ba51fcd3961939:1

[Kanishak]

Hi @Brian Collins1 ,

I am facing this issue in reconciliation of microsoft, as the reconciliation is failing at 75% in production. so can someone help in this matter....

these error messages showing in the Reconciliation progress table...

Select record for action: Unallocated Pass: Processing the Server (Per Instance) licenses for BackOffice Server 

Select record for action: Unallocated Pass: Processing the Server (Per Instance) licenses for Skype for Business Server

Select record for action: Unallocated Pass: Processing the Per Processor licenses for ISA Server 

Select record for action: Allocated Pass: Processing the Per Processor licenses for ISA Server

Select record for action: Wrapping up SamSubscriptionSuiteEngine for the Publisher Microsoft Corporation

Select record for action: Running the unallocated pass of SamInstallSuiteEngine for the Publisher Microsoft Corporation

[Brian Geihsler]

Hi there!

It looks like you are on the New York release. It is possible you are running into a known issue with Reconciliation on New York Patch 5 and below. Can you check this article to see if it applies to you?

https://hi.service-now.com/kb_view.do?sys_kb_id=44148a22db6a40541cd8a345ca961971

Thanks,

Brian Geihsler

[Will Young2]

Oooh I didn't know about that!