Can some one help me to resolve this below ERROR 013-11-07 06:02:47,1

...java:59)
          at com.appiancorp.rdbms.common.search.SearchIndexSyncTimerTask.run(SearchIndexSyncTimerTask.java:57)
          at java.util.TimerThread.mainLoop(Timer.java:512)
          at java.util.TimerThread.run(Timer.java:462)
2013-11-07 06:02:47,117 [Timer-5] ERROR org.hibernate.transaction.JDBCTransaction - JDBC commit failed
com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset by peer: socket write error
          at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1368)
          at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1355)
          at com.microsoft.sqlserver.jdbc.TDSChannel.write(IOBuffer.java:1548)
          at com.microsoft.sqlserver.jdbc.TDSWriter.flush(IOBuffer.java:2368)
          at com.microsoft.sqlserver.jdbc.TDSWriter.writePacket(IOBuffer.java:2270)
          at com.microsoft.sqlserver.jdbc.TDSWriter.endMessage(IOBuffer.java:1877)
          at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:4403)
          at com.microsoft.sql...

...server.jdbc.TDSCommand.startResponse(IOBuffer.java:4389)
          at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1457)
          at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
          at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
          at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1462)
          at com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(SQLServerConnection.java:1610)
          at com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolProxy.setAutoCommit(SQLServerConnectionPoolProxy.java:85)
          at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:545)
          at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:826)
          at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConnection.java:485)
          at org.hibernat...

... e.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:166)
          at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:142)
          at com.appiancorp.rdbms.hb.search.SearchIndexManagerSessionImpl.sync(SearchIndexManagerSessionImpl.java:95)
          at com.appiancorp.rdbms.hb.search.SearchIndexManagerSessionImpl.sync(SearchIndexManagerSessionImpl.java:59)
          at com.appiancorp.rdbms.common.search.SearchIndexSyncTimerTask.run(SearchIndexSyncTimerTask.java:57)
          at java.util.TimerThread.mainLoop(Timer.java:512)
          at java.util.TimerThread.run(Timer.java:462)
2013-11-07 06:02:47,120 [Timer-5] WARN com.appiancorp.rdbms.common.search.SearchIndexSyncTimerTask - [jdbc/appianprimary] Error during search index sync. Will try again in 300000ms.
org.hibernate.TransactionException: JDBC commit failed
          at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:157)
          at com.appiancorp.rdbms.hb.search.SearchIndexManagerSessionImpl.sync(SearchIndexMana...

... gerSessionImpl.java:95)
          at com.appiancorp.rdbms.hb.search.SearchIndexManagerSessionImpl.sync(SearchIndexManagerSessionImpl.java:59)
          at com.appiancorp.rdbms.common.search.SearchIndexSyncTimerTask.run(SearchIndexSyncTimerTask.java:57)
          at java.util.TimerThread.mainLoop(Timer.java:512)
          at java.util.TimerThread.run(Timer.java:462)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset by peer: socket write error
          at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1368)
          at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1355)
          at com.microsoft.sqlserver.jdbc.TDSChannel.write(IOBuffer.java:1548)
          at com.microsoft.sqlserver.jdbc.TDSWriter.flush(IOBuffer.java:2368)
          at com.microsoft.sqlserver.jdbc.TDSWriter.writePacket(IOBuffer.java:2270)
          at com.microsoft.sqlserver.jdbc.TDSWriter.endMessage(IOBuffer.java:1877)
          at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffe...

... r.java:4403)
          at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:4389)
          at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1457)
          at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
          at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
          at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1462)
          at com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(SQLServerConnection.java:1610)
          at com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolProxy.setAutoCommit(SQLServerConnectionPoolProxy.java:85)
          at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:545)
          at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:826)
          at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(Wrapped...

... Connection.java:485)
          at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:166)
          at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:142)

The error does point to an issue with the database, but without more information, it'll be difficult to figure out the cause.

Looking at the last caused by clause:

******************************************************************************************
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset by peer: socket write error
******************************************************************************************

It seems like the application-server is unable to connect to the SQL Server instance, where you have configured your PrimaryDS. You might want to check with your DBA’s if the SQL Server instances is up and running. Once you verify that, please restart the application-server.

You may also want to grant dba privileges to the PrimaryDS user that you have configured in the datasource. I have noticed that anything shy of that throws an error when starting up the application.