Warning in sm.alert.log
I have this kind of warning in the sm.alert.log :
RTE I Mapping-3-datadict,localizedTable, SQL Query incomplete because field (localizedTable) not mapped in file (datadict)
Do you how to fix that ?
Did you recently upgrade to SM 9.x? The localizedTable field was added to the datadict dbdict between SM 7.1x and SM 9.2x.
The message means there are queries against the datadict file which use the localizedTable field but it is not individually mapped. In this particular case, the datadict file is a SQL System Table (sqlsystemtable) which means only keyed fields are individually mapped. All other fields in the dbdict are stored in the descriptor BLOB.
If you decide to address this message/warning in TEST/DEV, the datadict dbdict will need to be updated by adding a Nulls & Duplicates key for the localizedTable field and then verifying the SQL Mapping properly maps the field to the RDBMS.
SM 9.21 datadict on Oracle - localizedTable field is mapped as follows:
SQL Name: LOCALIZEDTABLE
SQL Type: CHAR(1)
SQL Table: m1
Thanks for your help. We are migrating from 7.1 to 9.3 and when I check in 9.3 this field is not mapped in SQL Server but a key exist as you described.
Do you think this situation can have an impact in term of performance in our production server ?