Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved PowerServer Error running a Store Procedure (20+ minutes of execution)

  1. Issue
0
Votes
Undo
  1. Andres Slachevsky
    Andres Slachevsky
  2. PowerServer 2020 or older (Obsolete)
  3. Monday, 28 May 2018 12:40 PM UTC

I have and store procedure in MS SQL Server

Running the procedure from the PB Client Server application it takes 20-25 Minutes to RUN

i have change all the TimeOut Settings to 3600 Seconds (both in the application ->transaction-> Timeout and the the Data Cache Setting)
 

around 10 minutes running the procedure i get this error

 

 

error_timeout

 

In the Appeon server log i have this:

 

2018-05-28 08:34:14.877 : Thread was being aborted.
   at SNIReadSyncOverAsync(SNI_ConnWrapper* , SNI_Packet** , Int32 )
   at SNINativeMethodWrapper.SNIReadSyncOverAsync(SafeHandle pConn, IntPtr& packet, Int32 timeout)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
   at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
   at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at Appeon.Server.Services.DataService.Sql.EonSqlCommand.ExecuteReader()
   at Appeon.Server.Services.DataService.EonDbCommand.ExecuteCursor(SQLType sqlType, String sql)
   at Appeon.Server.Commands.EmbedSQLCommand.ExecuteCommand()
   at Appeon.Server.Commands.EmbedSQLCommand.Execute()
   at Appeon.Server.Commands.Command.ConstructAndExecute(CommandData commandData)
   at Appeon.Server.Services.Controller.JRouterImpl.ExecuteInTransaction(CommandData commandData)
   at Appeon.Server.Services.Controller.JRouterImpl.ExecuteCommand(HttpResponse response, CommandData superCommand, SessionAccessInfo session)
   at Appeon.Server.Services.Controller.JRouterImpl.Call(Int32 clientType, Object requestData, Hashtable clientContext, String& outPutStream_Key)
2018-05-28 08:34:14.893 : Thread was being aborted.
   at SNIReadSyncOverAsync(SNI_ConnWrapper* , SNI_Packet** , Int32 )
   at SNINativeMethodWrapper.SNIReadSyncOverAsync(SafeHandle pConn, IntPtr& packet, Int32 timeout)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
   at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
   at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at Appeon.Server.Services.DataService.Sql.EonSqlCommand.ExecuteReader()
   at Appeon.Server.Services.DataService.EonDbCommand.ExecuteCursor(SQLType sqlType, String sql)
   at Appeon.Server.Commands.EmbedSQLCommand.ExecuteCommand()
   at Appeon.Server.Commands.EmbedSQLCommand.Execute()
   at Appeon.Server.Commands.Command.ConstructAndExecute(CommandData commandData)
   at Appeon.Server.Services.Controller.JRouterImpl.ExecuteInTransaction(CommandData commandData)
   at Appeon.Server.Services.Controller.JRouterImpl.ExecuteCommand(HttpResponse response, CommandData superCommand, SessionAccessInfo session)
   at Appeon.Server.Services.Controller.JRouterImpl.Call(Int32 clientType, Object requestData, Hashtable clientContext, String& outPutStream_Key)
2018-05-28 08:34:14.893 : Thread was being aborted.
   at Appeon.Server.Services.Controller.JRouterImpl.Call(Int32 clientType, Object requestData, Hashtable clientContext, String& outPutStream_Key)
   at Appeon.WebLibrary.AXDispatcher.Page_Load(HttpContext Context)
  1. PowerServer
PowerServer get current Server where the applicati...
Errors passing a structure to appeonwebservicecomp...
Responses (2)
Appeon Support Team
Appeon Support Team Accepted Answer Pending Moderation
  1. Tuesday, 29 May 2018 00:45 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Andres,

Please refer to the article below to solve the Appeon Communication layer error.
http://support.appeon.com/index.php?/Knowledgebase/Article/View/49/0/how-to-resolve-the-error-occurred-in-the-appeon-communication-layer-only-for-the-iis-server

Regards,
ZhaoKai

Comment
Load more comments
Andres Slachevsky
  1. Andres Slachevsky
  2. Tuesday, 29 May 2018 12:04 PM UTC
I have changed all the values in the solution 1



now i have try the solution 1 and i get this error



Origen de configuración:



  205:



  206:



  207:



 



i will remove the extra line and edit the line 206

  1. Helpful
Andres Slachevsky
  1. Andres Slachevsky
  2. Tuesday, 29 May 2018 12:20 PM UTC
I can Confirm that the solution 1 solve the problem 



just need to change the executionTimeout

  1. Helpful
Appeon Support Team
  1. Appeon Support Team
  2. Wednesday, 30 May 2018 01:52 AM UTC
Glad to hear that.

  1. Helpful
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Monday, 28 May 2018 14:31 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

Running a stored procedure that takes that long from any client is not a good idea. You need to find a way to run it in a background thread or by a scheduler.

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.