I am trying to create and run schedules job on SAS EG 7.13. Code is very basic as the current goal is to ensure that I am able to run scheduled jobs
The job is not running and the history tab has the error with Launch Failure.
I tried to run the vb script directly from the saved location and get the below error
Error # 80004003
In Function Container.Run
Object Reference not set to an instance of an object
I have already tried various things from online with no success. Any suggestions are appreciated
I solved my problem that was exactly the same as yours, I have this error for months.
I run the same SAS process every day, once in the morning and once in the afternoon and every day I have different results.
Sometimes I only get the error in the morning, sometimes I only get the error in the afternoon, sometimes I don't get error and sometimes I get the error in the morning and afternoon .
The solution is very simple but to get there was very hard:
- Step 1
Open SAS in the project that you want to schedule, change the name of "Process Flow" to any something like "MyProcess", "MyFlow" , "MainProcess" or "Main", a name of your choice, right-clicking on Process Flow to change the name or select option rename.
Now you can save and close SAS project.
- Step 2
Now change the vbs script to be with the same name that we gave above:
Example: Change the name "Process Flow" to-> "MainProcess"
Open vbs and change line with the line code ->
containerName = "Process Flow" 'Container Name
to
containerName = "MainProcess" 'Container Name
Save the script.
If it doesn't work I will explain later how I get the solution, I think it will helps you to solve the problem.
Hi @Pranav_
Not sure if you are still experiencing the described issue, if yes let me try to help you.
First, did you get a chance to review Usage Note 56648 (Tips for scheduling a SAS® Enterprise Guide® project)?
This would be the starting point, assuming the project runs successfully interactively.
Also, please enable the log as per Usage Note 55414 (Enabling logging in SAS® Enterprise Guide® 7.1 and later).
When you try to execute the scheduled project, do you see further details in the log ?
Are you able to run another *.vbs file, not created by EG ?
If that works, go back to the script created by EG, edit it (with Notepad for instance) and enable the error message box that is commented out at the end of the file. Remove the single quote before the line: MsgBox strmsg. If any messages appear in a pop-up dialog box, please share it with us.
Hope that helps.
Cheers,
Damo
Hi @Damo
Thank you for the response. I have tried the suggestions and had done the : MsgBox strmsg as well earlier.
Please see the error message attached
Error "
80004003
In Function Container.Run
Object reference not set to an instance of an object
Hi @Pranav_
Thanks.
What about other points I mentioned (the 2 SAS-Notes and testing a sample vbs not created by EG ?
Cheers,
Damo
Hi @Damo
Yes , I have run the other steps(SAS notes) as well and verified the same. I am able to create a vb script directory and run it
The error remains same as in the previous post
Regards:
Pranav Goel
Hi @Pranav_
In that case, i would encourage you to raise a track with your local Technical Support.
You can share logs, review Event Viewer, etc.
Cheers,
Damo
I solved my problem that was exactly the same as yours, I have this error for months.
I run the same SAS process every day, once in the morning and once in the afternoon and every day I have different results.
Sometimes I only get the error in the morning, sometimes I only get the error in the afternoon, sometimes I don't get error and sometimes I get the error in the morning and afternoon .
The solution is very simple but to get there was very hard:
- Step 1
Open SAS in the project that you want to schedule, change the name of "Process Flow" to any something like "MyProcess", "MyFlow" , "MainProcess" or "Main", a name of your choice, right-clicking on Process Flow to change the name or select option rename.
Now you can save and close SAS project.
- Step 2
Now change the vbs script to be with the same name that we gave above:
Example: Change the name "Process Flow" to-> "MainProcess"
Open vbs and change line with the line code ->
containerName = "Process Flow" 'Container Name
to
containerName = "MainProcess" 'Container Name
Save the script.
If it doesn't work I will explain later how I get the solution, I think it will helps you to solve the problem.
In step 2 you can also delete your schedule in SAS and create a new one instead of changing the vbs.
Choosing this step is no longer necessary to change the script, SAS will create a new VBS script and change your process flow name for you in the script, it's a good option for those who are not comfortable with VBS.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: