M_ProductionLine has multiple columns with the same sequences - causes Pack In Error

Description

The current data dictionary has multiple columns inside the same table sharing the seqno value. M_ProductionLIne is an example. This issue causes a 2pack error when executing a Pack In. The model throws a beforesave error stating that the record is not unique.

The fix is to simple update the SeqNo to be unique in the system where you perform the Pack Out.

Here is a query to check the rest of the system for this situation. The following table have the same issue: M_ProductionLine, C_CashLine, C_PaySelectionCheck, M_PromotionLine, add M_PromotionDistribution

select * from
(
select t.ad_table_id, t.tablename, c.seqno, count
from ad_column c
join ad_table t on (c.ad_table_id = t.ad_table_id)
where isidentifier = 'Y'
group by t.ad_table_id, c.seqno
) x order by count desc, ad_table_id, seqno

Regards,
Chuck Boecking

Environment

Release 2.0 created a week ago

Activity

Show:
Orlando Curieles
August 22, 2020, 11:08 PM

Triage by Resolve as potential idea - must be discussed in the forum - I have the same problem on csv importer.

Best regards

Assignee

Orlando Curieles

Reporter

Chuck Boecking

Tested By

None

Components

Affects versions

Priority

Major
Configure