Informix DB receive data error

[Former Member]

error is :

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'o_tmm01_cigarette ' (structure 'STATEMENT'): java.sql.SQLException: FATAL ERROR: Column 'cigcd' does not exist in table 'o_tmm01_cigarette '

I'm very sure the field name is correct. not upper case or lower case either.

Anybody has experience with informix?

Thanks a lot.

Edited by: Shen Peng on Jun 3, 2009 4:29 PM

[MichalKrawczyk · Accepted solution]

hi,

maybe the table name is not correct and not the column?

Regards,

Michal Krawczyk

[Former Member]

in mapping

table = 'o_tmm01_cigarette '

there is a blankspace after the table name.

[Former Member]

Hi,

Add the schema name with table name and try it out.

Like <schema>.o_tmm01_cigarette

Regards,

Prakasu.M