Closed
We recently migrated from Chordiant 6.3 to 6.7.After migration we see errors in systemerr.log on fluximpl .
This log gets printed continuously starting from server start up and also when user is accessing the application.This creates huge log
Show More
This log gets printed continuously starting from server start up and also when user is accessing the application.This creates huge log
[12/1/17 13:19:29:746 CET] 00000058 SystemErr R com.microsoft.sqlserver.jdbc.SQLServerException: The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.
[12/1/17 13:19:29:746 CET] 00000058 SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
[12/1/17 13:19:29:746 CET] 00000058 SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
[12/1/17 13:19:29:746 CET] 00000058 SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
[12/1/17 13:19:29:746 CET] 00000058 SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
[12/1/17 13:19:29:746 CET] 00000058 SystemErr R at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4874)
[12/1/17 13:19:29:746 CET] 00000058 SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
[12/1/17 13:19:29:746 CET] 00000058 SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
[12/1/17 13:19:29:746 CET] 00000058 SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
[12/1/17 13:19:29:746 CET] 00000058 SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283)
[12/1/17 13:19:29:746 CET] 00000058 SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1110)
[12/1/17 13:19:29:746 CET] 00000058 SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:712)
[12/1/17 13:19:29:746 CET] 00000058 SystemErr R at fluximpl.database.k.executeQuery(k.java:10)
[12/1/17 13:19:29:746 CET] 00000058 SystemErr R at fluximpl.store.a.h.a(h.java:17)
[12/1/17 13:19:29:746 CET] 00000058 SystemErr R at fluximpl.store.a.g.a(g.java:13)
[12/1/17 13:19:29:746 CET] 00000058 SystemErr R at fluximpl.store.a.v.a(v.java:514)
[12/1/17 13:19:29:746 CET] 00000058 SystemErr R at fluximpl.j.q.a(q.java:120)
[12/1/17 13:19:29:746 CET] 00000058 SystemErr R at fluximpl.j.q.d(q.java:128)
[12/1/17 13:19:29:746 CET] 00000058 SystemErr R at fluximpl.j.q.run(q.java:91)
Show Less
Posted: 6 years ago
PEGA
Pegasystems Inc.
IN
Hello Shabana,
Could you pls confirm which chordiant product you are referring to.
Is it Chordiant Foudation Server or Chordiant Decision Management.?
Posted: 6 years ago
PEGA
Pegasystems Inc.
IN
Hi Shabana,
From the logs I understand you are using sqlserver and error is coming from a query failure in sqlserver.
Could you please confirm if you are using sqlserver or any other DB?