We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

SqlQueryFieldBindings

Comments

4 comments

  • Avatar
    Ernest Jones

    What is the error?

    0
    Comment actions Permalink
  • Avatar
    Michael Waxman

    Hello:

    Error is in text attachment

     

     

    Attached files

    data360 error.txt

     

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    I'm not familiar with Teradata but the JDBC Query error appears to indicate that you may have an invalid character in your input data:

    [TeraJDBC 16.10.00.03] [Error 2621] [SQLState HY000] Bad character in format or data of crdt_app.acct_nbr.

    The SQL statement is casting the input value to a BIGINT:

     "SELECT "base_view"."acct_nbr" FROM "EDWCCDVIEWS"."crdt_app" "base_view" WHERE CAST("base_view"."acct_nbr" AS BIGINT) = 464132813965"

     

    When I did a basic test against a Teradata DB the syntax/ node configuration worked ok:

     

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    Here is the Teradata documentation on the 2621 error:

    https://www.docs.teradata.com/r/8MhLDQBmL52OycrEKPuGqg/mzvswDmIHdZK~VszhuBRtw

     

    0
    Comment actions Permalink

Please sign in to leave a comment.