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

  • 1.  DB Store Node - iSeries DB2 file

    Employee
    Posted 02-10-2011 07:01

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

    Originally posted by: stunelson

    Hi,
    Trying to output LAE data to a DB2 file - not tried this before so not sure about the individual settings within the node but when I try to run the node I'm getting the following error:
    ""Error getting column information for table: P02CRP"

    P02CRP is the DB2 file on the iSeries that I have created.

    Any help would be appreciated.

    Thanks.


  • 2.  RE: DB Store Node - iSeries DB2 file

    Employee
    Posted 02-10-2011 07:41

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

    Originally posted by: stunelson

    Okay - I think I have overcome the initial issue (not sure whether it was related to the ODBC setup or syntax that I was using). Now all my data is flowing through the node but as ErroredData?


  • 3.  RE: DB Store Node - iSeries DB2 file

    Employee
    Posted 02-10-2011 07:48

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

    Originally posted by: stonysmith

    Check the log for this node.. you should have gotten some kind of message back about what the problem is.. Could be most anything like trying to store a string value into a integer column, etc.


  • 4.  RE: DB Store Node - iSeries DB2 file

    Employee
    Posted 02-10-2011 07:57

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

    Originally posted by: stunelson

    Ah....
    "Error while commiting row"
    "conversion exception"
    "statement is already locked"

    is showing in the log. I've seen another thread with this issue but no published resolution?

    Any ideas?


  • 5.  RE: DB Store Node - iSeries DB2 file

    Employee
    Posted 02-10-2011 08:15

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

    Originally posted by: stunelson

    I think I have sorted the problem. Again related to the OBDC configuration. The DB2 is not being journalled, and the update is being run within a transaction.

    So, I've set the "Commit mode" within the ODBC Advanced Configuration Options to *NONE and the LAE data is now being loaded into the DB2 file.