BAQ Personalize Columns

Hi,

When I have a personalize columns in a BAQ, it seems affect how BAQ runs even the column is from a different table.

For example, when I only want to display job numbers from JobHead. The query adds the PONum from POHeader because it is on the personalize columns.


o

Does anyone know how to turn this off? I tried to click “Reset to Default” but got an error says, “At least one column should be marked as Active”. I tried to select JobNum as my active column, then this column will stay in my query no matter how different the display columns are.

Thank you in advance for any recommendations!

In 2024.1 there does not appear to be a Personalize Columns in the BAQ Studio and there probably shouldn’t be.

You should be adding/removing fields in the BAQ under the Query Designer, and then Display Fields button.

Hi Chad,

Thank you for replying!

Yes, I always have been using the Display Fields to add/remove fields. I was experimenting some features on Kinetic the other day, and I cannot get this to stop every time when I run a query. :rofl:

Is it interfering with all of your BAQ’s or just this one?

If you were on the smart client I would suggest personalization purge and/or clear client cache.

It is interfering with all my BAQs even when I make a new one unless I manually inactivate/deactivate personalize columns.

I assume the “personalize columns” in BAQ are not consider as a personalization, therefore there isn’t a personalization I can chose when trying the purge. I also tried clear client cache, and it didn’t work.

Anything else I can try?
Thank you for your help, Chad.

I had a similar issue I ran the datafix previously received from support for another issue - FX_Del_XXXDef_KineticPersonalization
I ran it and removed all associated with my username and ErpBAQStudioHome surprisingly they did exist although I do not recall creating any personalization in that module, this corrected the problem.

Hi Melinda,

Thank you for the advice.
How do I run FX_Del_XXXDef_KineticPersonalization? I saw another post about using a dashboard to delete personalization. Do I need to install the dashboard first?

Yikes, this issue is still persisting for me in 2024. If anyone has any other feedback for resolving that would be appreciated!

Hi Grant,

I ended up submitting an Epicor support ticket and they had me run a data fix on the Data Fix Workbench. This was the same solution that Melinda suggested, and it resolved my problem.

2 Likes