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' 不是可以识别的 函数名。

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via pentahochina.com by Unknown author, 1 year ago
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'
via Pentaho BI Platform Tracking by Alexander Thiel, 11 months ago
An error occurred executing SQL: SELECT ID_JOB, CHANNEL_ID, JOBNAME, STATUS, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, STARTDATE, ENDDAT E, LOGDATE, DEPDATE, REPLAYDATE FROM WHERE STATUS = 'end' AND JOBNAME = ? ORDER BY REPLAYDATE ERROR: syntax error at or near "WHERE" Position: 193
via Pentaho BI Platform Tracking by Alexander Thiel, 1 year ago
An error occurred executing SQL: SELECT ID_JOB, CHANNEL_ID, JOBNAME, STATUS, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, STARTDATE, ENDDAT E, LOGDATE, DEPDATE, REPLAYDATE FROM WHERE STATUS = 'end' AND JOBNAME = ? ORDER BY REPLAYDATE ERROR: syntax error at or near "WHERE" Position: 193
via Pentaho BI Platform Tracking by Scott Gustafson, 1 year ago
An error occurred executing SQL: SELECT * FROM acerLog WHERE TRANSNAME LIKE ? OR TRANSNAME LIKE ? ORDER BY ID_BATCH desc Invalid object name 'acerLog'.
via Pentaho BI Platform Tracking by Jens Bleuel, 11 months ago
An error occurred executing SQL: SELECT ID_JOB, STATUS, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, STARTDATE, ENDDATE, LOGDATE, DEPDATE, REPLAYDATE, LOG_FIELD, EXECUTING_SERVER, EXECUTING_USER, START_JOB_ENTRY, CLIENT FROM log_table4_5_test WHERE JOBNAME LIKE ? ORDER BY ID_JOB DESC Unknown column 'EXECUTING_SERVER' in 'field list'
via Pentaho BI Platform Tracking by Jens Bleuel, 1 year ago
An error occurred executing SQL: SELECT ID_JOB, STATUS, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, STARTDATE, ENDDATE, LOGDATE, DEPDATE, REPLAYDATE, LOG_FIELD, EXECUTING_SERVER, EXECUTING_USER, START_JOB_ENTRY, CLIENT FROM log_table4_5_test WHERE JOBNAME LIKE ? ORDER BY ID_JOB DESC Unknown column 'EXECUTING_SERVER' in 'field list'
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' 不是可以识别的 函数名。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at org.pentaho.di.core.database.Database.openQuery(Database.java:1783)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
72 times, 5 months ago
Samebug visitor profile picture
Unknown user
Once, 6 months ago
23 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.