Question

4
Replies
69
Views
Shabanas Member since 2015 4 posts
Cognizant
Posted: December 8, 2017
Last activity: January 10, 2018
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

[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)
Decision Management
Moderation Team has archived post
Share this page LinkedIn