[PxPlus][ODBC Driver][PXPIO]File is busy

[Michael Greer]

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]

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]

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.