Job randomly halt when running VB6 application - VisualCron - Forum

Community forum

howard
2011-08-15T07:56:49Z
Dear all,

We are having problem on job execution in visual cron server version: 5.7.5 running Window 2008 Server R2 with SP1.

We set a few jobs in visual cron to run vb6 applications. Basically, it can work and job can be completed normally, However, sometimes the job hang-up and throw below error in the log.
-2147467238, Automation errorThe server process could not be started

Do you have any idea on it?
Support
2011-08-15T08:05:01Z
It depends on what the code does. Especially if it fails sometimes. Please note that VisualCron is better at actually capturing errors which might be one reason why you have not seen this before.

Are you running the Task with Credentials?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
howard
2011-08-15T09:20:19Z
Dear support,

It run without Credentials.

p.s. the server has been un-join and re-join another AD domain
Support
2011-08-15T09:48:35Z
Try adding a Credential who is an admin on the machine and run it with that Credential.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
tommoxi
2011-08-24T06:44:23Z
I have almost the same problems about running VB programs on windows 2008 server using Visual cron ver5.7.5 too. I have several vb programs which will call COM for pre-builted business logic and it randomly stopped from running after it was triggered by visual cron.

When I follow your suggestion and use credential for running VB program, but it FAILED again. However, if I further set the job to be run in FOREGROUND with one specific desktop session, it seems those VB programs can be ran normally so far.

Can you tell me the reason behind that?

Thanks in advance
Support
2011-08-24T06:59:57Z
Did you try running with a Credential (using option With profile in Execute settings and background mode)?

Originally Posted by: tommoxi 

I have almost the same problems about running VB programs on windows 2008 server using Visual cron ver5.7.5 too. I have several vb programs which will call COM for pre-builted business logic and it randomly stopped from running after it was triggered by visual cron.

When I follow your suggestion and use credential for running VB program, but it FAILED again. However, if I further set the job to be run in FOREGROUND with one specific desktop session, it seems those VB programs can be ran normally so far.

Can you tell me the reason behind that?

Thanks in advance



Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
tommoxi
2011-08-24T10:16:46Z
Thank for prompt reply

I did used that settings (i.e. credentials (admin right user) with profile (run with API) AND Background execution) but the problem come out again.

That's why I want to put it into FOREGROUND and try by luck to see any message come out interactively.

Please help again. Thanks

Support
2011-08-24T10:41:50Z
1. Is this something that can be easily reproduced?
2. Is it some code we could run from here?
3. What if you create a simple VB program and run it in the same Task with same settings - do you get same error then? The reason why I am wondering this is if this is related to the code or something else.

Originally Posted by: tommoxi 

Thank for prompt reply

I did used that settings (i.e. credentials (admin right user) with profile (run with API) AND Background execution) but the problem come out again.

That's why I want to put it into FOREGROUND and try by luck to see any message come out interactively.

Please help again. Thanks



Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
tommoxi
2011-08-25T01:57:34Z
Here are the reply. Thanks

Originally Posted by: Support 

1. Is this something that can be easily reproduced?

It is not easy to reproduce. I have 4 different programs running in different schedules around 20 executions per day. In the 3 days observation, only 6 executions failed but all in different programs in different schedules. Even there are two failure on the same program. but they also failed in different schedule too. Interestingly, the execution in the last failed schedule is no problem on next day.
So, I guess it is not related to program logic. More, I can rerun this visualcron successfully without any modification.

2. Is it some code we could run from here?
No, as said, need to run with COM in components services.

3. What if you create a simple VB program and run it in the same Task with same settings - do you get same error then? The reason why I am wondering this is if this is related to the code or something else.

Originally Posted by: tommoxi 

Thank for prompt reply

I did used that settings (i.e. credentials (admin right user) with profile (run with API) AND Background execution) but the problem come out again.

That's why I want to put it into FOREGROUND and try by luck to see any message come out interactively.

Please help again. Thanks



Support
2011-08-25T06:18:49Z
What about the answer on 3). Thanks.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
tommoxi
2011-09-14T09:28:59Z
As discussed, for trouble shooting, we wrote a simple vb program which call simple function of our COM. We executed that little program over 20 times a day and put it on the same problem server. After a couple week of testing, we have below findings

Findings
1) The problem can be found when it runs in background execution, no matter how we specify with credential with adminstrator user right or just left it as no credential. As said before, this problem come out quite irregularly but we can experience this problem only after around 35-60 executions if run it in background execution

2) When we looked at the testing code in detailed, the error is happened when it create a instance of our COM object and Exception is caught when run at below codes. Please also check the error message too.

Our Code which exception is occured :
"Set oMyVariableName = CreateObject("XXXNonTrade.NonTrade")"

Error Message from our exception handling logic in simple vb program :
"Automation error"
"The server process could not be started because the configured identity is incorrect. Check the username and password. "

3) Everytime when this problem come out, it can be fixed simply by rerun the job WITHOUT changing anything. i.e. It maybe not due to job/task configuration.

4) When we set it to run in Foreground mode, it seems no problem.

Thanks for your advice in advance



Support
2011-09-14T09:31:49Z
How do you handle errors - do you write to standard error or show a message box? What if you just captured all errors and wrote to standard error - maybe it works better then.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
tommoxi
2011-09-15T08:26:46Z
Originally Posted by: Support 

How do you handle errors - do you write to standard error or show a message box? What if you just captured all errors and wrote to standard error - maybe it works better then.



I handled those error very properly.
In my vb program, it wrote all error and its description into a log file. That's why I can provide error messaget to you
Support
2011-09-15T08:29:05Z
Do you have any error description or details about this in the event viewer?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
tommoxi
2011-09-15T08:58:03Z
There is no record in event viewer.
Support
2011-09-15T09:00:04Z
And you are sure you don't have any Messagebox calls in your application. For some reason your application crash handled or unhandled and it shows a messagebox. I do not know why you can't see the messagebox but maybe it works better on another operating system. It seems vital, in order to solve this case, to know what is in that message box.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
tommoxi
2011-09-15T09:39:38Z
Originally Posted by: Support 

And you are sure you don't have any Messagebox calls in your application. For some reason your application crash handled or unhandled and it shows a messagebox. I do not know why you can't see the messagebox but maybe it works better on another operating system. It seems vital, in order to solve this case, to know what is in that message box.




It should be no message box because execption handling logic in my program has already written the error into the log file.

did U get that error message from my post yesterday?
Scroll to Top