org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT A.OPERATEID, A.OPERATETYPE, A.PKEYCHANGED, A.id_NEW, A.id_OLD,B.* FROM tb_user_sync A LEFT JOIN tb_user B ON B.id = A.id_NEW WHERE SUBSTRING(LPAD(CONV(A.OPERATESTATUS ,10,2),10,'0'),9,1) = 0 AND SYNCTIMES < 10 'CONV' 不是可以识别的 函数名。

pentahochina.com | 2 months ago
  1. 0

    Pentaho 中国爱好者社区 kettle数据同步的问题,请大家帮帮忙! - Kettle 的使用和开发. Pentaho中国爱好者社区

    pentahochina.com | 2 months ago
    org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT A.OPERATEID, A.OPERATETYPE, A.PKEYCHANGED, A.id_NEW, A.id_OLD,B.* FROM tb_user_sync A LEFT JOIN tb_user B ON B.id = A.id_NEW WHERE SUBSTRING(LPAD(CONV(A.OPERATESTATUS ,10,2),10,'0'),9,1) = 0 AND SYNCTIMES < 10 'CONV' 不是可以识别的 函数名。
  2. 0

    SymmetricDS / Discussion / Help:Sql server 2000 Error

    sourceforge.net | 1 year ago
    java.sql.SQLException: 'SCHEMA_NAME' is not a recognized function name.
  3. 0

    Solved : JTDS MSSQL Pagination problem. (JDBC and Relational Databases forum at Coderanch)

    coderanch.com | 5 months ago
    java.sql.SQLException: Incorrect syntax near the keyword 'ORDER'.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Sql server 2000 Error

    symmetricds | 7 years ago | neoscopio
    java.sql.SQLException: 'SCHEMA_NAME' is not a recognized function name.
  6. 0

    Config problem in postgresql-sqlserver2000

    symmetricds | 8 years ago | sushantabhowmik
    org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select SCHEMA_NAME()]; nested exception is java.sql.SQLException: 'SCHEMA_NAME' is not a recognized function name.

    3 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      'CONV' 不是可以识别的 函数名。

      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic()
    2. jTDS
      JtdsStatement.executeQuery
      1. net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
      2. net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
      3. net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
      4. net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
      5. net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
      6. net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1301)
      6 frames
    3. org.pentaho.di
      Database.openQuery
      1. org.pentaho.di.core.database.Database.openQuery(Database.java:1783)
      1 frame