Symptoms
Upgrade order fails with error
Table Service Gate doesn't contain row with id Int32(NULL).
Cause
Feature FEA_SetResourcesInOneCall is activated in PBA-E.
pba=> SELECT * FROM "Features" WHERE "FeatureName" = 'FEA_SetResourcesInOneCall';
FeatureName | Container | MethodToCheck | IsActive | UserArc | DateArc
---------------------------+-----------+---------------+----------+---------+---------
FEA_SetResourcesInOneCall | | | 1 | 0 | 0
(1 rows)
In this case PBA-E is not able to handle Composite Resources properly during sales orders and upgrade/downgrade orders.
Such behavior is confirmed as bug #PBA-54403
Resolution
The issue is fixed in PBA-E 5.5.4. Please upgrade PBA-E to latest version.