PxPlus User Forum

Twitter Twitter Twitter

Author Topic: [PxPlus][ODBC Driver][PXPIO]File is busy  (Read 2054 times)

michaelgreer

  • Diamond Member
  • *****
  • Posts: 129
    • View Profile
[PxPlus][ODBC Driver][PXPIO]File is busy
« on: May 08, 2019, 11:30:48 AM »
I have an SQL query that runs for 4.5 hours or so, then posts the error referenced in the subject.  Any insight on what would cause this. This occurs at about 1:30 AM almost every day.  I have looked for other processes that might be locking a source file but am not currently aware of any.

Thomas Bock

  • Diamond Member
  • *****
  • Posts: 177
    • View Profile
Re: [PxPlus][ODBC Driver][PXPIO]File is busy
« Reply #1 on: May 09, 2019, 01:52:18 AM »
Try turning on debug mode and take a look at the logfile. Though it might be large after 4.5 hours it might also provide the information you are looking for.

Devon Austen

  • Administrator
  • Diamond Member
  • *****
  • Posts: 382
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: [PxPlus][ODBC Driver][PXPIO]File is busy
« Reply #2 on: May 09, 2019, 10:24:16 AM »
Antivirus software could be possibly doing a scan causing the file to be busy.

Backup software doing a backup could cause the file to be busy.

You may be able to split your query up until several smaller queries and if one get's an error retry it. This way it won't have to do the whole thing over again and even with the busy error it can get done. This assumes whatever is using the ODBC driver can be scripted. If not you can look into using the pxpsql command line program to do the query as this can easily be scripted. It also is generally much faster as it avoid some Microsoft ODBC overhead.
Principal Software Engineer for PVX Plus Technologies LTD.