idempiere-rest release 10 facing issue randomly - Get POs with exception: No PK nor FK

[Syed]

Dear Team,

Please let me know the reason for the following issue while creating new record using rest api.  Sometimes this error is resolved after cache rest and sometimes this error comes even after cache reset.   

Get POs with exception: No PK nor FK - TF_EmpShiftAssignment"

I really appreciate your help in resolving this issue permanently.

Thanks in advance

Regards,

Syed.

[Gaurav Sontakke]

Hi 

Is TF_EmpShift foreign key ?

Ideally it should end with _ID & check share the column definition from the application dictionary. 

Regards

Gaurav

On 17 Jul 2025, at 7:01 PM, Syed <sy...@syvasoft.com> wrote:

Dear Team,

Please let me know the reason for the following issue while creating new record using rest api.  Sometimes this error is resolved after cache rest and sometimes this error comes even after cache reset.   

<idempiere-rest.png>

Get POs with exception: No PK nor FK - TF_EmpShiftAssignment"

I really appreciate your help in resolving this issue permanently.

Thanks in advance

Regards,

Syed.

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/idempiere/294c4e49-99da-42c3-9494-18e2ffac86dbn%40googlegroups.com.
<idempiere-rest.png>

[Jesús Castillo]

Hi, 

It happens when tables don´t have any ID column. For example TF_EmpShiftAssignment_ID

 

Atte: Jesus Castillo.

To view this discussion visit https://groups.google.com/d/msgid/idempiere/B37AC0DA-8775-460F-BB82-CB78244789DB%40shaik.net.

[Syed Vaisul Karne M]

 

TF_EmpShift is the table name.

It says that this doesn’t have PK or FK though it has primary key in standard naming convention 

Kind regards,

Syed,

MD
SyvaSoft Business Solutions Pvt Ltd

Mobile: +91 9941335361
www.syvasoft.com

You received this message because you are subscribed to a topic in the Google Groups "iDempiere" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/idempiere/P_siJaZ9R94/unsubscribe.
To unsubscribe from this group and all its topics, send an email to idempiere+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/idempiere/B37AC0DA-8775-460F-BB82-CB78244789DB%40shaik.net.

[Syed Vaisul Karne M]

Hi Jesus,

These two tables (TF_EmpShift and TF_EmpShiftAssignment) have their primary key as per iDempiere standard. 

Records are created through webui interface. These FK PK errors occasionally happen while calling through rest api. Please note that this error is not always happening, but only sometimes through rest api. After resetting cache, sometimes this issue is resolved.

My observation is that PO Cache is not loading properly these table Application Dictionary definitions because this sceanrio, the highlighted error are occurred.

Kind regards,

Syed,

MD
SyvaSoft Business Solutions Pvt Ltd

Mobile: +91 9941335361
www.syvasoft.com

You received this message because you are subscribed to a topic in the Google Groups "iDempiere" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/idempiere/P_siJaZ9R94/unsubscribe.
To unsubscribe from this group and all its topics, send an email to idempiere+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/idempiere/CAFAT%3DLTgTei687uY%2BXws4kSA8PogJNbT4U%2B8dWCaS3StcRx86g%40mail.gmail.com.

[Luis Amesty]

Hi Syed
You need a Model Factory Plugin with X_TF_EmpShift, I_TF_EmpShift , X_TF_EmpShiftAssignment and I_TF_EmpShiftAssignment
This necessary for Api rest.
Do you have it ?

Regards

[Syed]

Hi Team,

In the following query, the primary key column record is sometimes skipped, which results in the error: “NO PK, nor FK”.

Upon investigation, it appears that the isKey column marked as 'Y' is not being interpreted correctly, causing the primary key column to be ignored during processing.

Interestingly, when I manually select AD_Client_ID as the Parent Link Column, the issue is resolved. This suggests that the primary key metadata might be inconsistent.

It's worth noting that the key column data appears suspicious after the pack-in process, likely because the original configuration was done in a different iDempiere instance.

SQL for Load PO Info

SELECT

t.TableName, c.ColumnName,c.AD_Reference_ID,
c.IsMandatory,c.IsUpdateable,c.DefaultValue,
e.Name,e.Description, c.AD_Column_ID,
c.IsKey,c.IsParent,
c.AD_Reference_Value_ID, vr.Code,
c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated,
t.AccessLevel, c.ColumnSQL, c.IsEncrypted,
c.IsAllowLogging,c.IsAllowCopy,t.IsChangeLog
FROM AD_Table t
INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID)
LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID)
INNER JOIN AD_Element  e  ON (c.AD_Element_ID=e.AD_Element_ID)
WHERE
t.AD_Table_ID=1000502
 AND c.IsActive='Y'
 ORDER BY c.AD_Column_ID

[Syed]

What could be the reason that the getter and setter are not able to load the column definitions sometimes?

usually it works and sometimes I get the following error randomly while using trekglobal rest api.

Looks like trekglobal rest api disturbs the PO Cache because of this cache issue, we got the following error. After resetting cache, it works fine.

Can you suggest the any concrete solution?

[Syed]

[Heng Sin Low]

Hi, you are not getting suggestions because there's no one else facing the same issue.

To view this discussion visit https://groups.google.com/d/msgid/idempiere/e937fdcd-65a9-4094-ae2b-6582cf18cc34n%40googlegroups.com.

[Syed]

Hi Hengsin,

What could be your approach if you face this kind of unique issue?

Let me give it a try.

[Carlos Antonio Ruiz Gomez]

You can try this:

- Create the table in test.idempiere.org and see if it fails there

- that way other people can take a look to your table definition and most probably will be something misconfigured

and sometimes is worthy to add validations in core to protect against that misconfiguration

On 8/2/25 09:02, Syed wrote:

Hi Hengsin,

What could be your approach if you face this kind of unique issue?

Let me give it a try.

On Friday, August 1, 2025 at 5:18:32 PM UTC+5:30 hengsin wrote:

Hi, you are not getting suggestions because there's no one else facing the same issue.

On Fri, Aug 1, 2025 at 6:32 PM Syed <sy...@syvasoft.com> wrote:

What could be the reason that the getter and setter are not able to load the column definitions sometimes?

usually it works and sometimes I get the following error randomly while using trekglobal rest api.

Looks like trekglobal rest api disturbs the PO Cache because of this cache issue, we got the following error. After resetting cache, it works fine.

Can you suggest the any concrete solution?

[Syed]

Hi Carlos,

In the test server, it is working fine, but not in my production server with my custom tables and columns.

Mentioned all the above issues, such as PK - FK and Column Not Found, are the outcome of the same reason.

Newly added columns to the core table and certain columns from the custom tables are skipped randomly from POInfo Cache 

After cache reset in both client side and system side, I get all the columns of my table from POInfo Cache

It is still unpredictable.

Your ideas are welcome to find out the root cause of this problem.

[Heng Sin Low]

1. Do you deploy using the installer from the official iDempiere jenkins build or using the build from your fork repository?

2. If you are using build from your fork repository, did your team make any changes to core or idempiere-rest ?

3. Either way, you also need to keep your deployment up to date with the official idempiere repository.

--

You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.

To view this discussion visit https://groups.google.com/d/msgid/idempiere/cd7aa540-fc5e-4f84-9513-4a45d674c703n%40googlegroups.com.

[Jesús Castillo]

Hi, Syed

I think this is an issue related to the language of sessión. Try to log language from context before the error.

 

Atte: Jesus Castillo.

To view this discussion visit https://groups.google.com/d/msgid/idempiere/CAC%3D6jXEex5qUzK2JxyLQzj2DFFnqLgnNH-uZxgc0DH6rxOtSMQ%40mail.gmail.com.

[Jesús Castillo]

 Sorry, in my last email I didn't specify that the error might be due to the session having a language without translations, which prevents the columns from loading.

Atte: Jesus Castillo.

[Carlos Antonio Ruiz Gómez]

This sounds like a problem in release 10 that has been solved in subsequent releases. My recommendation would be to upgrade your installation.

AFAIR, you must do a cache reset when adding new tables or columns.  You can try also this. 

Regards, 

Carlos Ruiz

[Syed]

I have figured it out by myself after debugging the POInfo SQL in my Dev Environment then came here,  It's good that  Atte: Jesus Castillo. also faced the same issue.

I have fixed the issue by adding the missing translations for en_IN

In WebUI, en_SG is the base language. en_SG has all the translations, but in rest API, I have mistakenly used en_IN, which has fewer translations for the Elements because of this scenario, few columns are excluded.

Thank you guys for the support