How to resolve: F_JD22A1: [' ' ('0A'X) is not a valid Teradata SQL token]

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #9613
    Simon Faas
    Keymaster

    How to resolve
    F_JD22A1: DBMS error [‘ ‘ (‘0A’X) is not a valid Teradata SQL token]. DBMS error number [-3704]. SQL State [42000]. DBMS version [15.10.0301 15.10.03.01]

    while connecting to a Teradata database

    #9614
    Simon Faas
    Keymaster

    This error is caused by an problem in the Teradata ODBC driver version 15.10

    See:
    http://community.teradata.com/t5/Database/Teradata-Error-3704-0A-X-is-not-a-valid-Teradata-SQL-token/td-p/49648

    The solution / work-around is to downgrade the ODBC driver to 15.00

    #11468
    register
    Participant

    <p style=”margin: 0px;”>F_JD22AF: DBMS error [ERROR: ROLLBACK TO SAVEPOINT may only be used in transaction blocks]. DBMS error number [3624913]. SQL State [01000]. DBMS version [PostgreSQL 8.2.15 (Greenplum Database 4.3.14.1 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Jun 28 2017 22:40:01] Last query [rollback to savepoint hvr_burst]. </p>
    <p style=”margin: 0px;”> F_JT1471: The previous error occurred while processing burst statements from queue table cheque__b. </p>
    <p style=”margin: 0px;”>F_JT04A1: The previous error occurred between slave ‘ch_gpptr’ HVR version 5.2.1/5 executable and a parent HVR version 5.1.1/6 executable [#789a].</p>
    <p style=”margin: 0px;”></p>
    <p style=”margin: 0px;”>hi Simon,</p>
    <p style=”margin: 0px;”></p>
    <p style=”margin: 0px;”>Please help us in how to resolve above  errors?</p>
    <p style=”margin: 0px;”></p>
    <p style=”margin: 0px;”>Regards</p>
    <p style=”margin: 0px;”>Sunil</p>

    #11469
    register
    Participant

    F_JT0551: Illegal netpipe [gcars_dlake1-fullchan-gcrsr-gpptr->slave|1|send] guardian state: was_disabled=0 will_be_enabled=1.

    Error caused while performing  full channel refresh from Soure Oracle to target greenplum (HVR version 5.2.1/5).

    we are using HVR 5.1 in our windows local machine ..

    Please help us in resolving this issue..

     

    Thanks

    Sunil

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.

© 2020 HVR

Test drive Contact us