when querying CMOD using CMIS thru Content Navigator and odwek,we are seeing the following error in the system log:
DB Error: {DB2 FOR OS/390}{ODBC DRIVER}{DSN12010} DSNT408I SQLCODE = -206, ERROR: POLICYEFFDATE IS NOT VALID IN THE CONTEXT WHERE IT IS USED
The issue is that POLICYEFFDATE is not a column on the database, but a field in the folder that is mapped to database field POL_EFF_DT.(policyEffDate :: APA-LETTERS-AQS : POL_EFF_DT)
When I check apptune for DB2, the actual sql failing is using POLICYEFFDATE and not POL_EFF_DT, but the other fields in the query are the true column names and not folder fields. It appears that somewhere folder field names are being mixed with table column names for sql.
Has anyone else seen anything like this?