A secured or licensed column is referenced by a table relation from

Kinetic ERP
1

Recently I started getting this error in the BAQ designer.
Severity: Warning, Text: A secured or licensed column is referenced by a table relation from (PartRev Type: Table) to (PartOpr Type: Table). Associated data will not be returned

This happens when I add partrev and partop tables into my layout. I fix the issue by removing two of the pre-defined table relations. I remove AltMethod, and ProcessMfgID from the relations for both tables, and then the error goes away.

What’s going on with this?

2

Epicor added a new field ProcessMfgID as part of the key structure, but you can’t access it if you don’t have it licensed. The “fix” is to go into the join criteria and remove it. I submitted a ticket to Epicor on this, is already a known issue PRB0250431. Probably will get fixed in a future release, but for now the “workaround” is pretty quick.

5 Likes
3

Actually, this problem got closed without getting fixed. Looks like the workaround is going to be a permanent part of the solution.

4

“Functioning as expected”

5

6

If it’s documented, then I buy it.

7

I typically get “That’s by design” or “Working as expected”. LOL.