SOLVED Verify / Remediate SQL CE database is healthy

[Ketankamble3894]

On most of the workstion ccm evaluation is failing with below reason verify / remediate SQL CE database is healthy .

How we can troubleshoot the same ?

Almost 300+ clients are showing this error

Is there any wql which we can use to create a collection for all machines which are having this error in client check detail

 

[Ketankamble3894]

 

[Ketankamble3894]

select * from v_CH_EvalResults

select EvalTime,Result,ResultType,ResultDetail,ResultCode,HealthCheckDescription

from v_CH_EvalResults
GROUP BY EvalTime,Result,ResultType,ResultDetail,ResultCode,HealthCheckDescription
ORDER BY EvalTime DESC

I ran command to get all the machines with specific evaluation error , but still looking for fix for above error can anyone help ?

 

[Prajwal Desai]

Thanks for attaching that screenshot. I also see a tape access reached a file mark. This is something weird, have you restored the DB anytime ?.

 

[Ketankamble3894]

Thanks for attaching that screenshot. I also see a tape access reached a file mark. This is something weird, have you restored the DB anytime ?.

No we have not restored DB recently.

 

[Ketankamble3894]

No we have not restored DB recently.

CCMeval.log - from client machine
Evaluating health check rule : Verify/Remediate SQL CE database is healthy. CcmEval 4/29/2020 4:28:12 AM 11476 (0x2CD4)
Database 'StateMessageStore.sdf' was recently repaired. CcmEval 4/29/2020 4:28:12 AM 11476 (0x2CD4)
Result: Failed, ResultCode: 1101, ResultType: 200, ResultDetail: StateMessageStore.sdf CcmEval 4/29/2020 4:28:12 AM 11476 (0x2CD4)

 

[Ketankamble3894]

05/01/2020 11:43:47,Logon,Unknown,Service Broker login attempt failed with error: 'A previously existing connection with the same peer was detected during connection handshake. This connection lost the arbitration and it will be closed. All traffic will be redirected to the previously existing connection. This is an informational message only. No user action is required. State 80.'. [CLIENT: IP ] - SQL logs

 

[Ketankamble3894]

Still waiting for a solution for this issue

 

[Prajwal Desai]

@Ketankamble3894 - Were you able to fix this issue with help of MS support ?.

 

[Ketankamble3894]

No Not yet .

 

[Prajwal Desai]

So what was the outcome ?. You still have the issue on your prod server ?.

 

[Ketankamble3894]

Yes we are still getting this error on production workstaions. We dont have SCCM client installed on servers