I have a uBAQ that I’d like to automate to run at 2 am/pm.
The uBAQ fires when the BPM.GetList() runs.
I’d like to tie it to a System Agent Task but can’t figure out how to submit it.
Anything will be helpful.
@Banderson That fired the uBAQ on a schedule.
Getting a “ubaq tableset value cannot be null”, but that is not part of this issue.
Thanks for your help.
–Update: Looks like this is a known issue
I’ve looked at both and there is no fix shown.
1 Like
Do you have any data coming back? I usually just add the company table so something is returned.
Thank you for your reply.
I do:
select
[Company].[Company] as [Company_Company],
[Company].[Name] as [Company_Name]
from Erp.Company as Company
It runs correctly from BAQ and from the Dashboard, just not the Export BAQ.
If you get to a newer version (is your version correct on your profile?), you can schedule a function. I don’t know what you’re doing, so I don’t know if that’s viable or not, but that’s a little cleaner than scheduling the UBAQ.
What is the BPM doing? I am guessing adding columns and data to the BAQ. Would you be able to do that in the BAQ vs BPM?
Using a variation of this code from Joshua Giese
Thank you for your reply.
Trying to get things updated but not happening quickly.