you should check the Mrequest in caps database , and the connection between caps and server database , is it on premise or cloud?

if you want you can reach me on cherifbj@gmail.com i can maybe help you out

It on-premise. I have found the tables [MREQUESTS] , [MREQUEST_DATA] in CAPS Db . Could please explain how I can investigate this problem using these or compare them with Simphony server tables

if they have 3 as value in MREQUESTS it mean it failed to post to the server

Yes, I can see many records with [ReqState]=3 and a few records with 0. How we can resync with the server?
I have attached the screenshot for your reference could you tell me [RecordType],[ServiceID] and [OfflinePosting] indicating what and also tell me [ReqState]=0 what it means

https://files.engineering.com/getfile.aspx?folder=...

• https://files.engineering.com/getfile.aspx?folder=6c91b5f5-e1b9-4af5-af97-5

reqstate 3 mean that checks are not being posted , try on caps , replay checks , and see what error do you have

Thanks a lot for sharing this knowledge. If you can tell me How can I find which check number has reqstate 3. This information will help me to track and find the missing checks and start to reconcile. And also tell me what you mean by Replay checks.

try to run this sql scripts on caps server to find the checks not posting to myMicros：


select
TO_CHAR(Reqtime,'YYYY-MM-DD hh24:mi:ss') Datetime,
case when MREQUESTS.ReqState='0' then 'Pending to Post'
when MREQUESTS.ReqState='1' then 'Posted'
when MREQUESTS.ReqState='2' then 'Failed Retry Later'
when MREQUESTS.ReqState='3' then 'Failed Rejected'
end as Enterprise_Posting_Status,
ReqState,count (reqstate) as Mrequest_Count from MREQUESTS
where TO_CHAR(Reqtime,'YYYY-MM-DD')>='2022-12-25'
group by MREQUESTS.ReqState,TO_CHAR(Reqtime,'YYYY-MM-DD hh24:mi:ss')
order by TO_CHAR(Reqtime,'YYYY-MM-DD hh24:mi:ss') desc ,ReqState ;



If you can send me the egateway logs and mm logs ,I can help to fix you issue or you can try to restart the caps server & IIS.

Thank you very much for the query it is giving me the output Pending to Post and Failed Rejected. But could you tell me how can I find out which checks numbers are these

You can use select mrequest_data.id,mrequest_data.checkid from mrequest_data.id to find the check id which not posting to LOC. + where Mrequest_Data.id = Mreqeust.id
And use the checkid to find the checknum in Guest_check.