1 Reply Latest reply on Sep 24, 2020 3:30 PM by Asmita Kesarwani

    Message: Database errors occurred:  FnName: Prepare -- [Teradata][ODBC Teradata Driver][Teradata Database] Syntax error, expected something like ')' between '?' and ';' -what can be the reason for this error?

    Rajesh Nimma Active Member

      Error
      Message: Database errors occurred:

      FnName: Prepare -- [Teradata][ODBC Teradata Driver][Teradata Database] Syntax error, expected something like ')' between '?' and ';'.

       

      Our source is oracle and target Teradata. some times sessions fail with the above error while running through the Informatica PowerCenter showing a bad record. But after rerun, the session getting succeeded .Not sure
      why it getting failed with the above error - can you please help on this?

       

      Thanks

      Rajesh