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 | 5 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

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

    pentahochina.com | 5 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 | 2 years 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 | 8 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