Issue with a BAQ - JobOpDtl

Kinetic ERP
1

Following the last update, I get the following error with one BAQ : Severity: Exception, Table: JobOpDtl, Field: , RowID: fd06f939-4793-4ff2-a1a4-0e8855868843, Text: Value cannot be null. (Parameter ‘fromItem’)
Query returned 1 row(s).

The error happens when in my BAQ I activate the “Released” field that comes from JobHead and update. I can update any other field without issue, even other fields located in the JobOpDtl table that are not check boxes.

With our consultant, we found an issue with the checkbox01 UD field located in the JobOpDtl UD table.

They tested by copying the BAQ and removing the field checkbox01 from the BAQ and that solved the issue for this BAQ copy. However we need a checkbox for our process.

I created a new UD field in JobOpDtl called Confirmation_c and integrated it in the BAQ. I tested the BAQ again and still got the same issue.

I created a new UD field in JobHead called Confirmation_c and integrated it in the BAQ. I tested the BAQ again and still got the same issue.

I verified the settings of the field to make sure it’s all ok.

After more testing, it seems, the BAQ will crash when updating two tables (JobHead + JobOpDtl). This is a new behavior with our BAQ.

I have multiple fields to update in the JobOpDtl table and then release the job via JobHead. When I do all of them and save, it crashes.

If I change the JobOpDtl fields first (chose the resource, set date and time for the appointment), save, then check “release” and save, this works.

2

Hi Tobby,
Have you found any workaround for this case? I’m having the same issue.
Thanks,
Ahmad

3

Hi Adam,

Unfortunately no. I was able to resolve part of the issue. However, I still can’t save the BAQ when changing fields in the JobHead + JobOpDtl table at the same time; well at least, I can’t release the job at the same time as I update a field in JobOpDtl.
Next option on my list is to rebuild the BAQ. Since this is a big BAQ used on 2 dashboards, I will try to build a small BAQ, test the basic save and if that works build the rest of the connections and re-build the dashboard.
We are currently working and testing the new Kinetic interface before deployment to employees so this issue is on the backburner for me currently since we have a work around.

1 Like
4

Thanks for the update.

5

Hi Adam

FYI I built a small BAQ with the following tables:
JobHead
JobAsmbl
JobOper
JobOpDtl

I selected fields from JobHead and JobOpDtl to update and it worked. So the logic works. Now I will investigate again in my other BAQ what could be the issue and let you know if I find something.

1 Like