I am trying to use the Process Instance and Activity Instance Smart Objects to extract infromation to a data warehouse SQL Server database for us to use in reporting through Business Objects.
I am able to run the console application (written in VB.Net) through Visual Studio, but when i try and schedule the job it won't run.
My question is, how to i check and set up access to these smart objects so the user the scheduled job runs as can have access to them? I am not getting any error messages, just no data returned from the Smart Object filter.
My code is as follows, but i believe the issue is permissions....
smo = SOClientServer.GetSmartObject("Activity_Instance_Destination")
getList = smo.ListMethods("List")
smo.MethodToExecute = getList.Name
getList.Filter = getActivityFilterEQ(<<my activity name>>)
smol = SOClientServer.ExecuteList(smo)
If smol.SmartObjectsList.Count > 0 Then
For Each so As SmartObject In smol.SmartObjectsList
... code to insert smart object into SQL Table ....
Next
End If
Any guidance appreciated!
Thanks,
Helen