Desktop productivity for business analysts and programmers

Ubable to schedule in SAS Enterprise Guide in EG 5.1

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

Ubable to schedule in SAS Enterprise Guide in EG 5.1

Hello Team,

 

I am not able to create a schedule in SAS Enterprise Guide. I am using 5.1. When ever I am trying to schedule a project by File>Schedule Project I am getting the error.

Application Error
SAS Enterprise Guide has encountered a problem
We recommend that you save your work and restart SAS Enterprise Guide.

-------------------------------------------------------------------------------------------------------
Exception information
-------------------------------------------------------------------------------------------------------

Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))


-------------------------- Technical Information Follows --------------------------

Exception Details:
----------------------------------------
Exception type: System.UnauthorizedAccessException
Message: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
Source: SAS.EG.Utilities
Target Site: NewWorkItem

 


SAS.jpg

Accepted Solutions
Solution
‎06-30-2016 07:40 AM
SAS Super FREQ
Posts: 306

Re: Ubable to schedule in SAS Enterprise Guide in EG 5.1

If explicitly running EG as an administrator (http://www.tenforums.com/tutorials/3436-run-administrator-windows-10-a.html) does not avoid the error when scheduling, the only other workaround I can think of is to manually schedule the task in Windows Task Scheduler to run the .vbs file (default attached; you'll have to remove the .txt extension from the file name and edit the prjName property in it to point to your .egp) that runs the desired EG project.

 

The action: "Start a program"

For 32-bit EG:

Program/script: C:\Windows\SysWOW64\cscript.exe (for 32-bit EG)

Add arguments: "C:\Users\cassmi\Desktop\EGScript1.vbs" (path to .vbs file)

For 64-bit EG:

Program/script: C:\Users\cassmi\Desktop\EGScript1.vbs

View solution in original post


All Replies
Super User
Posts: 7,422

Re: Ubable to schedule in SAS Enterprise Guide in EG 5.1

[ Edited ]

This http://support.sas.com/kb/58/247.html might be of help for you.

 

As I always say, do not run a major Windows version in production until at least SP2 has been released. And the SW vendors had time to deal with the rotten-brain ideas that MS decided to put into it.

Right now the Windows version to use is 7. 10 is in open beta-test at the moment.

 

PS the link above is the first result of a google search for "sas enterprise guide schedule project Access is denied."

I have found that simply using the error message from a SAS product in connection with the product name in google will get you a good hint for the solution most of the time (>90%)

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 7

Re: Ubable to schedule in SAS Enterprise Guide in EG 5.1

Thanks Kurt for the reply. I tried this option but its not working.

SAS Super FREQ
Posts: 306

Re: Ubable to schedule in SAS Enterprise Guide in EG 5.1

I'm surprised Kurt's suggestion (explicitly running EG as an administrator) did not allow you to workaround.  Usually the "access is denied" error related to scheduling is a result of the user not having permissions to create Windows Scheduled Tasks.  As a test, I suggest opening the Windows Task Scheduler and seeing if you are able to create a simple scheduled task.

 

Casey

Occasional Contributor
Posts: 7

Re: Ubable to schedule in SAS Enterprise Guide in EG 5.1

Yes I tried creating a job from task scheduler and I can succesfully run the job. I tried running a progam SEGuide.exe. But whenever I try using SAS Enterprise Guide I am getting the error

Solution
‎06-30-2016 07:40 AM
SAS Super FREQ
Posts: 306

Re: Ubable to schedule in SAS Enterprise Guide in EG 5.1

If explicitly running EG as an administrator (http://www.tenforums.com/tutorials/3436-run-administrator-windows-10-a.html) does not avoid the error when scheduling, the only other workaround I can think of is to manually schedule the task in Windows Task Scheduler to run the .vbs file (default attached; you'll have to remove the .txt extension from the file name and edit the prjName property in it to point to your .egp) that runs the desired EG project.

 

The action: "Start a program"

For 32-bit EG:

Program/script: C:\Windows\SysWOW64\cscript.exe (for 32-bit EG)

Add arguments: "C:\Users\cassmi\Desktop\EGScript1.vbs" (path to .vbs file)

For 64-bit EG:

Program/script: C:\Users\cassmi\Desktop\EGScript1.vbs

Occasional Contributor
Posts: 7

Re: Ubable to schedule in SAS Enterprise Guide in EG 5.1

Thanks for your response. I tried modifying your vbs script. Made change in the project name and updated set app = to point to EG 5.1. I am getting an error object required. Not sure what went wrong.

 

Option Explicit
Dim app

Call dowork

'shut down the app
If not (app Is Nothing) Then
app.Quit
Set app = Nothing
End If


Sub dowork()
On Error Resume Next
'----
' Start up Enterprise Guide using the project name
'----
Dim prjName
Dim prjObject

prjName = "C:\Users\hbasheer\Desktop\Project1.egp" 'Project Name

Set app = CreateObject("SASEGObjectModel.Application.5.1")
If Checkerror("CreateObject") = True Then
Exit Sub
End If

'-----
' open the project
'-----
Set prjObject = app.Open(prjName,"")
If Checkerror("app.Open") = True Then
Exit Sub
End If


'-----
' run the project
'-----
prjObject.run
If Checkerror("Project.run") = True Then
Exit Sub
End If


'-----
' Save the new project
'-----
prjObject.Save
If Checkerror("Project.Save") = True Then
Exit Sub
End If

'-----
' Close the project
'-----
prjObject.Close
If Checkerror("Project.Close") = True Then
Exit Sub
End If

End Sub

Function Checkerror(fnName)
Checkerror = False

Dim strmsg
Dim errNum

If Err.Number <> 0 Then
strmsg = "Error #" & Hex(Err.Number) & vbCrLf & "In Function " & fnName & vbCrLf & Err.Description
'MsgBox strmsg 'Uncomment this line if you want to be notified via MessageBox of Errors in the script.
Checkerror = True
End If

End Function


error.png
Occasional Contributor
Posts: 7

Re: Ubable to schedule in SAS Enterprise Guide in EG 5.1

Casey. I am able to run the VB script now and sas project is getting executed.

c:\windows\syswow64\cscript.exe C:\Users\hbasheer\Desktop\egjob.vbs

 

Scheduling via Enterprise guide is still an issue.

 

SAS Super FREQ
Posts: 306

Re: Ubable to schedule in SAS Enterprise Guide in EG 5.1

Hi @sas_bh, glad you were able to get the VB script working, such that you have a workaround for scheduling the project.

 

I wish I could help with the issue you are encountering scheduling via EG 5.1.  The "Access denied" errors while scheduling from EG are usually due to permissions settings, which can be worked around by running EG as an administrator.  However, since that isn't helping in your case, I'm not sure what else to try.  I do know changes have been made in the way EG creates scheduled tasks (related to permissions) in our more recent releases (ex. 7.12 HF3).  There is a reasonable chance your issue is resolved in the latest version (7.12 HF3).

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 8 replies
  • 1100 views
  • 2 likes
  • 3 in conversation