What to do when VR Bid Email receipt fails

1. Make sure there is no new entries in the table 'VR_Bid_Preference_Submission' which is found in Subways_Prod_VRSTAA or  Subways_Prod_VRSTAC DB 15 mins prior to starting this process.
   select * from VR_Bid_Preference_Submission order by 1 desc
   

            

1. To check if any email is not sent run the below query for both STAA and STAC in Kezava_System_Subways_Prod_VRSTAA.dbo.emailalertservice -
   select * from emailalertservice where isnull([email status],'')!='yes'
   If there are any rows then wait for the mail to go.

            

1. Disconnect from the DFS from all 3 pick servers - 51,52,53
   Open services> Stop 'DFS Replication'.
   Once DFS is disconnected in all 3 servers, open the below path in file management and delete all the PDFS in all 3 servers.
   F:\Program Files\IntelliVIEW\IntelliviewNXT\Kezava10\Web\Temp\AppArchive\ExportStandardReport

            

      

      

1. Then open the below path in each of the server, sort the date modified to recently created and select all the folders except the first IVNX file. Also Unselect the folders that are created for the current date. Now delete the selected folders. Do this for both VRSTAA and VRSTAC folder.
   Note: If you delete the IVNX file, the entire VR mail system will be corrupted.
   F:\Program Files\IntelliVIEW\IntelliviewNXT\Kezava10\Web\Temp\StandardReports\VRSTAC.

            

1.  Once these folders and files are deleted in all 3 servers. Start the 'DFS Replication' in all 3 servers and check if it is running in the task manager.
   
2. After starting DFS in all 3 servers disconnect from all servers and check if the VR bid receipt comes for new bidding. To know if there are any new bidding run the below query in VRSTAA and VRSTAC and check for created on time.
   select * from VR_Bid_Preference_Submission order by 1 desc
   If we don't get VR Bid receipts for new entries please contact L2.

• Related Articles

• When a VR employee is not able to bid -

  Try logging in the VR bid link for that employee using his credentials. Check if the employee is active in employee master. Check the current job assignment details in employee master. If the select pick is Open Job Bid, then the employee is no more ...

• When job numbers are missing from VR Bid week/Posting report –

  Check the job effective date and end date in the backend. If the job end date is before the VR bid week and if it is open job, then that job won’t appear in the posting report. It can be manually added to the VR Bid week. Check if the jobs are Extra ...

• Removing permissions for the VR Bid Applications

  1. Login to STAA/STAC, -A page as author. 2. Click on the Permissions. 3. Navigate to the VR Bid application. 4. Click on the VR Bid applictaion name. 5. Uncheck the all user groups in the center panel. 6. Save the Permissions. NOTE: we stopped using ...