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
Resolution
Workaround: Minimum of 9 characters in each access field.
Fixed in Abila Millennium 2014 version
Article Type
Product Defect
Product Line
Millennium
Product Module/Feature
Relation
Product Version
2013.5
2013.4
Database Engine
SQL Server 2008 R2
Web Browser
Internet Explorer 9
Ranking