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

Resolved DW no retrieve data with Thread was being aborted in PowerServer Error LOG

  1. Issue
0
Votes
Undo
  1. Andres Slachevsky
    Andres Slachevsky
  2. PowerServer 2020 or older (Obsolete)
  3. Thursday, 3 January 2019 17:33 PM UTC 
Hello all,
i have a working DW in client server
it takes around 15 minutes to finish in client server
when i run it in powerserver it finish with no data and no error in the browser but it get this in the errorlog
i have changed all the timeout parameters in the AEM 
but it does not seems to work 
2019-01-03 14:33:41.041 : Thread was being aborted.
   at Appeon.Server.Commands.DWRetrieveCommand.ExecuteCommand()
   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)
2019-01-03 14:33:41.057 : Thread was being aborted.
   at Appeon.Server.Commands.DWRetrieveCommand.ExecuteCommand()
   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)
2019-01-03 14:33:41.088 : 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)
The PowerServer multi-instance feature work on Pow...
Window Response & MessageBox position
Responses (5)
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Friday, 4 January 2019 00:41 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Andres,

Please refer to article below to sovle the issue.
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

And please go to AEM > Server > Resources > Data Source > [your data source] page to adjust the value of 'Command Timeout (seconds)'.

Regards,
ZhaoKai

Comment
Andres Slachevsky
  1. Andres Slachevsky
  2. Friday, 4 January 2019 16:48 PM UTC
I believe is a problema in the documentation

i try it and get and error in accesing the AEM

then i search for httpRuntime and i found

this entry



and replace the value to



i will try the execution now
  1. Helpful
There are no comments made yet.
Kevin Ridley
Kevin Ridley Accepted Answer Pending Moderation
  1. Thursday, 3 January 2019 22:05 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

You could also do like Chris said below with a Report table or PDF by executing a stored procedure asynchronously, so there's very little processing on the PowerServer side, it's all pushed to the DB.

Comment
There are no comments made yet.
Andres Slachevsky
Andres Slachevsky Accepted Answer Pending Moderation
  1. Thursday, 3 January 2019 18:57 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3

I manage to take it to 5 Minutes in Client Server

but running from powerserver i get this in the errorlog

 

 

2019-01-03 16:00:41.450 : [Application name=aportes,conn cache=cmpu,SQLOrProcedure=select nomoper = fn_nombre_completo(persona) ,    persona, moneda,       fn_categoria(persona, date('2019-1-3'),moneda) as v_categoria,            isnull(fn_utilidad_acumulada_x_rendicion(persona , date('2019-1-3'),moneda),0) as utilidad_acumulada,           isnull(fn_aporte_acumulado_x_fecha_rendicion (persona ,'19010101', date('2019-1-3'),moneda),0) as aporte_acumulada  from aportes   where tipo_fondo = 'N'   and aportes.moneda = 'GS'  and ( (not exists (select * from aportes a where a.persona = aportes.persona and a.tipo_fondo in ( 'B', 'R', 'U') and a.fecha_planilla <= date('2019-1-3') )    or persona  in( 264, 1686) )    and ((persona <> 1686 and date('2019-1-3') >= 20180604) or  date('2019-1-3') < 20180604) )  or (persona <> 10  and fn_fecha_jubilacion_a_fecha(persona,  date('2019-1-3'),moneda) < fn_fecha_ingreso_a_fecha(persona,  date('2019-1-3'),moneda))  group by persona,moneda  having utilidad_acumulada <> 0 or aporte_acumulada <> 0]Thread was being aborted.
   at System.Data.Common.UnsafeNativeMethods.SQLFetch(OdbcStatementHandle StatementHandle)
   at System.Data.Odbc.OdbcDataReader.Read()
   at Appeon.Server.Services.DataService.EonDbDataReader.Read()
   at Appeon.Server.Services.DataService.DataServiceUtil.OutputResultSet(DataWriter writer, EonDbDataReader dr, String pbVersion, CommandData commandData)
   at Appeon.Server.Commands.DWRetrieveCommand.ExecuteOneDataObject(DataWriter writer, DataObject dataObject, Object wrapper, Nullable`1 lastModifyTime)
   at Appeon.Server.Commands.DWRetrieveCommand.ExecuteDBDataObject(DataObject curDataObject)
   at Appeon.Server.Commands.DWRetrieveCommand.ExecuteCommand()
2019-01-03 16:00:41.481 : Thread was being aborted.
   at Appeon.Server.Commands.DWRetrieveCommand.ExecuteCommand()
   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)
2019-01-03 16:00:41.497 : Thread was being aborted.
   at Appeon.Server.Commands.DWRetrieveCommand.ExecuteCommand()
   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)
2019-01-03 16:00:41.512 : 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)
Comment
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 3 January 2019 18:12 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 4

A DataWindow that takes 15 minutes should not be deployed to PowerServer.  That could make the Web server really busy and prevent it from serving other requests.  

You can surely modify settings and get it to work with a single user, but once multiple users get on the PowerServer the underlying Web server will probably choke.

When moving from a 2-tier architecture to an n-tier architecture you really do have to rethink some of your heavy processes that were designed with 2-tier architecture in mind.

Comment
Andres Slachevsky
  1. Andres Slachevsky
  2. Thursday, 3 January 2019 18:19 PM UTC
thanks Armeen,

i will try to make my customer understand

and run the Reports in a Client/Server enviroment.

they have many reports that take more than 30 minutes
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 3 January 2019 18:54 PM UTC
Hi Andres;

I have done a lot of these types of long reports in many PB apps. Quite often I use a Report Table and then do a Select INTO to produce the "summary" data for the report. Then push the report out via PowerServer from the Report Table.

Another good way is to produce a PDF report file and either drop that on the Web Server's landing pad or insert this as Blob in the Report Table for extraction via the PS App when the user requires it.

By utilizing an MS-Windows scheduler or even one in the DBMS back-end - these PB Report Apps can be fired off in the wee hours of the AM so that the reports are ready for the App users when they 1st login for the day.

Food for thought.

Regards ... Chris
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 3 January 2019 17:58 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 5

Hi Andres;

  Can you tell / show us the current timeout values that you are using?

For example:

Thanks .... Chris

Comment
Andres Slachevsky
  1. Andres Slachevsky
  2. Thursday, 3 January 2019 18:10 PM UTC
Session Timeout 3600

Transaction Timeout 3600

Download Timeout 3600

Request Timeout 3600

Rollback Completion time 360

Maximum Rollback Retries 3

  1. Helpful
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.