CPM files not coming through to approval screen in Dynamics

Problem:
user reports an issue - https://supporthub.soteria365.com/a/tickets/7668?current_tab=details

Description

AP53 VPI file has come through to dynamics 'XML' files awaiting approval' however the CPM file has not and there is no errors.

Solution

The missing file is in the app right now, you can find it in All CPM Files Awaiting Approval, or you can follow this link:

https://accelins.crm11.dynamics.com/main.aspx?appid=e2cf52a4-c7d5-ec11-a7b6-6045bd1001c4&pagetype=entityrecord&etn=accelins_workflow&id=7486a481-34e4-ed11-8846-6045bdd2c2d1

What is the process in the background:

1. Once a XML creation is done on CPM/VPI files, the files are landing in the Unchecked folder.

2. From the Unchecked folder you have to copy-paste it to the ReadyToProcess folder.

3. Once it's in the ReadyToProcess folder the SSIS package in SQL is picking up the file and creating an SQL record from that file in the Database.

4. After it's been created in the Database, one of the Workflow app flow is picking up the file from the ReadyToProcess folder and put it to the AwaitingApproval folder

5. Once the file is there, it's appearing in the Workflow app under the right Awaiting Approval view.

Response from Pro user Elizabeth Brain on this -

I have not amended the process that I usually follow but files are not appearing.

1) Save XML file to Agency Insurer payment files, PowerBI files

2) File then appears in Settlement files, ready to process, unchecked...I do not copy and paste this.

3) I drag the files into the settlement file upload

4) I then approve them in the files awaiting approval screen

5) The CPM and VPI files then appear in AIBE, AAUB,AAIE if not errors are identified.

What caused the issue?

The issue was here, that someone deleted or moved the file from the ReadyToProcess folder until the SSIS package job run in the 3rd point above. in the 4th point above the flow tried to move the file to the Awaiting Approval folder but couldn't find the file, because it was deleted or moved to somewhere else. If it's not moved or deleted by you, we have to investigate who is moving/deleting the file from the ReadyToProcess folder. The SSIS package is running every 15 minutes, and sometimes other files are running, so it's going into a queue, so within 1 or 2 hours it should be done.

If you have any further questions please let me know.

Regards,

Denes

[2:50 PM] Dénes Riedly

ticket 7668 is resolved, the error made by a user.

[2:52 PM] Dénes Riedly

long story short people cannot move or delete files once these are in the Ready to Process folder. It seems that nothing happen but in the background many processes are running and as a result it's moving the file to the Awaiting Approval folder