R42565 running for a longer time
Hi,
R42565 Acknowledgment version is running for a longer time, even for a smaller data set ( 2 records). It is running for 30 seconds no matter whether the data selection is for 1 record or 100 records.
Log says below statements are repeated and taking 1 sec for each set of statements. Pls check the attached Log file for more details. Can some one help me to understand these statements and suggest a solution.
Apr 24 11:38:45.569447 - 4452/3624 Entering DBPerformRequest
Apr 24 11:38:45.569448 - 4452/3624 ODBC:S DBPerformRequest req=09DCB300,con=075EFF98,env=01137348,dbc=011373C8,spid=831 JDEDBP1 A (JDE@JDEDBP1)
Apr 24 11:38:46.578000 - 4452/3624 ODBC[jdbodbc.C,7556] wSQLExecute failure. rc = -1
Apr 24 11:38:46.578001 - 4452/3624 ODBC[jdbodbc.C,7556] STMT:00 [HYT00][0] [Microsoft][SQL Server Native Client 11.0]Query timeout expired