-206 sql errors in system log

[octater]

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?                                                 

[Justin Derrick]

If you're running some custom line-of-business app on top of this stacj, double check your code to make sure you're not mixing up a field name somewhere, otherwise, I suspect this is a bug somewhere inbetween CMIS / ICN / ODWEK.

You didn't mention versions, which is very important in a situation like this -- can you provide us with the versions of ICN / ODWEK / CMOD / DB2?

This will help us to help you!  :)

-JD.