ContactReview :: View topic - PLUSRUN.exe not closing when run each night via Q-File

rossg · GoldMine Apprentice

Hi All

GX7 2007-B and GM 8.01.70621 WinServer 2003

Have set up a Q-File to run a large number of conversions and imports. It is trigger by a Scheduled task. The task appears to run each night.

Trick is that it doesn't seem to close itself off when it is finished. When I get back onsite the PLUSRUN.exe is still running in the Processes of the Server. This means that the next night's import process doesn't run.

In fact each night it appears to try to run and will leave a PLUSRUN.exe running as a Process for every night it has tried. EG over a weekend it will leave 3 processes running, Firday, Sat, Sun.

Is this indicative of a GoldBox import etc I have created that is going wrong and hence locking up GX7??

Any one else seen this before?

Do you all typically trigger GX updates to run each night via a Scheduled task??

Thanks Heaps

Ross

rossg · GoldMine Apprentice

Hi

Further testing has found that the Q-File has an issue when going from Imports to creating a GoldBox View for an OrgChart update.

I added a 20 sec Pause in the Q-File but the error continues to appear.

The error is :
Program Alert
Error: In use by another: d:\apps\goldbox7\gview4th.dbf
File: d:\apps\goldbox7\gvovrflo.prg
Routine: GXCOUNTSQL
Line: 452

In the background the Org Chart process still runs. Haven't confirmed it actually updates anything as yet. It is probably this error message that is stopping the PLUSRUN.exe from closing.

Any ideas on how to stop this error???

Thanks

Ross

BobTaylor · GoldBox Guru

Obviously, it's difficult for anyone outside to really troubleshoot a Q-file, but my first guess would be that you may not be observing a rule: if a View is to be run by a Q-file, then it must be the last item in the Q-file. You can run a View in the midst of Q-file events; but to do so, you must use the Post operation of the View to run a new Q-file...sort of a tag-team thing. But if the OrgChart is the only View in the Q-file, I'd just put it at the end; the tag-team thing can be tricky to manage.

You don't indicate whether you are aware of it, so I'll mention that the Log is an important tool in trouble-shooting a Q-file; and the REM button is another. BTW, I would never run a Q-file via Scheduler without first having tested it via more than one manual run.

rossg · GoldMine Apprentice

Hi Bob

Can't say I was aware of the fact that a View must be run as the last event of a Q-File.

As it turned out I have 2 Views that are to be generated. Both just happened to be at the end of the Q-File anyway. I am guessing that because I have two Views that I should create a separate Q-File for each of them so it works like this ...

Q-File1 Main data Conversion and Import Process (Last step to jump to Q-File2)
Q-File2 Run View 1 (Next Step to jump to Q-File3)
Q-File3 Run View 2

Is this what you were meaning by Tag Team??

" the Log is an important tool in trouble-shooting a Q-file; and the REM button is another. "

I'll check the Help for further feedback on these.

"BTW, I would never run a Q-file via Scheduler without first having tested it via more than one manual run."

I have run these multiple times. I have about 20 conversion processes and 30 data imports running via the Q-File. Individually they all work fine. I have run the Q-File a number of times but as it takes 3-4 hours to run I must have missed the Views issue.

Thanks again for your help ..

Ross

BobTaylor · GoldBox Guru

Your Q-file 1 and Q-file 2 can be combined, with the last item in Q-file 1 being the View from your Q2. So you'd only need 2 Q-files. What you have as Q-file 3 would become the second Q-file, and the hand-off would be from the first View to it. I believe you'd have to make the OrgChart View the very last item of the last Q-file, because its Post operation is already used to run the OrgCharts themselves.

rossg · GoldMine Apprentice

BobTaylor · GoldBox Guru

I am trying to tell you that

a) you don't really need 3 Q-files (although it certainly won't hurt to use 3); 2 will suffice. And

b) However many Q-files you use, the OrgChart View will have to be the last item run, period. That's because its Post operation is already dedicated to running the routine that creates the OrgCharts. It cannot run anything else.

rossg · GoldMine Apprentice

The solution was to simply run the GoldBox Views as a separate Scheduled Task and not through the QFile.

Even when I add the GBX View as the last item on the QFile it still did not run correctly.

Running them via a separate Scheduled Task worked a treat.

RG

BobTaylor · GoldBox Guru

Thanks for getting back to us on that, Ross.