BAQ with Update Processing using Advance BPM Update only option enabled does not run when the BAQ report is run

Epicor ERP 10
1

Description:

I am trying to schedule a BPM to run based on a selected row criteria from the Task table. I thought I would use a BAQ with the Advance BPM option. Then use a BAQ report of the BAQ to schedule the report to run. See my list of issues below:

  1. I created a BAQ which works just fine. The BAQ returns a list of rows from the Task table.

  2. The BAQ update option is enabled but no columns are selected for update. However, only the Advanced BPM update option is selected.

  3. The BPM post processing for GetList is selected to send an email message containing ttResults table column “Key1”. The email address I selected for the email tag is my yahoo account.

  4. The BAQ - BPM is enabled.

  5. The BAQ analyze works and completes then successfully.

  6. The BAQ GetList is clicked and the resulting rows from the task table are displayed and in about 1 to 2 minutes, an email is received.

Part 2. The same BAQ is used to create a BAQ report.

Problem 1:

  1. When the report is submitted, the report runs successfully but no email is received.

Problem 2:

  1. When the email is received after running the BAQ manually clicking on the GetList (not the BAQ report), the data in the body of the email is streamed. I expected one email for each row with ttResults.Key1 column I selected. Instead, I received one email with the column I select for all rows as a stream character separated by comma.

We are running E10.1.400.17. I welcome your suggestions and advice.

2

The same reported problem occurs if the UBAQ is part of an executive query cube submitted or scheduled to run as a task within a process set. This could very well be a bug.

3

Hi Mazin,
have you seen this thread ? it might help you on the scheduled trigger bit

4

Thank you. I saw this post last night. I placed a call with Epicor Support. The analyst informed me that he is able to recreate the problem on E10.2.400.9.

5

After enabling my server log on the testing instance, I noticed that Epicor does not execute the same BOs when the BAQ is run through the designer, Executive Query (cube) or BAQ report. This explains why the BAQ BPM does not get triggered.

6

the BPM of updatable BAQ uses ExternalUpdate Method to BO’s, and should give -in theory- the exact same results as the Update one, but not all BO has this method configured.

7

I am still waiting on Epicor support to confirm if this is a known bug in 10.2.400.x.

1 Like