Updateable BAQ Repot Error

Kinetic ERP
1

Hi Guys

In Epicor11 Kinetic Version , I have created an Updateable BAQ and used that UBAQ in BAQ Report Designer.

While running the report, sometimes report is launching without any error and some times report is launching with error.

In System Monitor, for error records it throws error as “Updatable query doesn’t have any settings specified” for that BAQ…

Let me know if any one faced this issue or any solution for this issue??

Regards,
Thameem

2

Hi
Is this UBAQ include linked tables ? Probably - there is a kind of locking on the table that you want to update. Check if any Lock applied on Table while you are getting this error .

Regards

3

Hi Yasir,

In my UBAQ , I am using “Advanced BPM Update” to update the data.

In advanced BPM, I am using a table with lock.

I have given it like “Db.TableName.With(LockHint.NoLock)”

Is this the problem??

4

Try removing this and review the error !

5

I removed that… then also I am getting that error…

6

ok - compare your other UBAQ that are running without error with the problematic one. find the differences.

7

UBAQ’s are working if we use them in dashboard… if we use that BAQ in BAQ report Designer, then only we are getting this error.