DF-M17079-Lookup maintenance-Error inserting/updating relation pair with limited Access
Symptom
If you try to limit Millennium User Group Access on a relation pair record, an error occurs on insert or update.
Error Message -- Update
UPDATE relation_pairs SET relp_mgp2 = '67108863.0 ', relp_whose = 'la ', relp_amt2 = 0.00, relp_agp1 = '1'000000, relp_amt1 = 0.00, relp_isa = 'am ', relp_agp2 = '1'000000, relp_comm = '', relp_mgp1 = '67108863.0 ', relp_actv = 'Y' WHERE relp_key = 5046
SQL_ERROR
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '000000'.
Error Code 102
UPDATE relation_pairs SET relp_mgp2 = '67108863.0 ', relp_whose = 'la ', relp_amt2 = 0.00, relp_agp1 = '1'000000, relp_amt1 = 0.00, relp_isa = 'am ', relp_agp2 = '1'000000, relp_comm = '', relp_mgp1 = '67108863.0 ', relp_actv = 'Y' WHERE relp_key = 5046
SQL_ERROR
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '000000'.
Error Code 102
Product Line