Knowledgebase:
Timeout when trying to obtain Status and Processing Reports for Medicare Online
Posted by Jane Hughes, Last modified by Sinclair Hughes on 17 September 2018 06:05 PM
Response information pulled back from Medicare for Schedules (Status and Payments Reports) is saved to the database.  If the table gets excessively large, a Timeout expired may result.

The HIC Log file (Utilities - Logs - HIC Logs - SPM HIC Logs) will report something similar to that below:

14/09/2018 11:05:20 AM ******************** HIC online on Friday, 14 September 2018 at 11:05 ********************
14/09/2018 11:05:20 AM Computer:SMPC-TS
14/09/2018 11:05:20 AM UserName:andrea.briggs
14/09/2018 11:05:21 AM Started spm_HICWrapper
14/09/2018 11:05:21 AM cpu64=True java64=False HICver=6.12 PMSver=405
14/09/2018 11:05:21 AM **** cHICWrap.GetBulkBillProcessingReport **** ctrSched=1725
14/09/2018 11:05:56 AM cHICWrap.GetBulkBillProcessingReport: msg=Problem retrieving report information Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
14/09/2018 11:05:56 AM Terminating spm_HICWrapper
14/09/2018 11:05:56 AM spm_HICWrapper.Class_Terminate_ExitProc
14/09/2018 11:05:56 AM ******************** Closed at 11:05 ********************

To identify the tables that are probably chewing up the processing time, use WINFLEX (Reports – database – tables by record count).  In the above instance, two tables associated with HIC are HicReportResult and EventLogging


(1)    Open each table and identify a timestamp column.

HicReportResult has hicr_DateEntered

EventLogging has evl_Timestamp


(2)    Compose queries.

DELETE FROM HicReportResult WHERE hicr_DateEntered < ‘1 sep 2018’

DELETE FROM EventLogging WHERE evl_Timestamp < ‘1 sep 2018’

 
These MAY be able to be executed via Winflex – database – execute. They can PROBABLY be executed from SQL Management Console. However, they will probably trigger a timeout unless host computer is fairly capable.

(3)   If necessary, the query can be executed in 'chunks' with Winflex. 

  • Make sure HicReportResult is selected.       (Very important)
  • Utilities – clean data – apply sql in blocks
  • Block size = 5000 [OK]
  • Select [Wipe] - this clears the previous entry.
  • Type in query above DELETE FROM HicReportResult … 2018’
  • Select [OK]
  • Form caption at top of Winflex will show records being processed.

 (4)    Repeat for step 3 for the other table(s).