Submitted by 335 on
Symptom
Missing linked lookup code crashes IIS - this issue has been reported on an attribute record(s) where attribute_type lookup code has been deleted
 
Cause
The issue has been confirmed as a product defect and has been reported to our Research and Development team.
Resolution
While a full resolution is unavailable currently, we offer the following workaround(s) in the meantime

1. Identify all missing/deleted lookup codes

Use milldata;
go
Select attrtype, count(*) from attribute where not exists (Select * from attribute_types where attrtype=table_code) group by attrtype order by arrttype
 

2. Insert all missing attribute_types into the attribute_types lookup table



Status:  Please refer to KB article 4771-Scheduled fixes  to see if this is scheduled for a fix.
 
Article Type
Product Issue
Product Line
Millennium
Product Module/Feature
Installation
Settings
Setup and Configuration
Technical
Technical Issues
Product Version
2014.0
Ranking
No votes yet