LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
Back to discussions
Expand all | Collapse all

DB STORE issues with missing fields

  • 1.  DB STORE issues with missing fields

    Employee
    Posted 09-23-2015 06:15

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: cristi.boizas

    Hi,

    I am trying to load some data in a table using the DB store node but not all the columns of the input are defined in the table.
    I have checked to ignore missing columns in DB or missing fields in input, but still, I get the following error:

    ERROR initializing expert output:
    loading column FMC_SRC_ODSM.RECORDTYPE: cannot reconcile type differences between database type 'double' and type to be loaded 'string'
    2015-09-23 15:16:22.000; WARN: Field 'FILE_ID' (translated to 'FILE_ID') of type double not found in table
    id: 0 chain: 0 group: 0
    cppDetail: context: DBTableO

    Any ideas why?

    NEVERMIND, I didn't realized this was caused by the RECORDTYPE column.

    Thanks.