Session log timeout

[MeghanStark]

We have several automated processes, and only one has an issue when the production team attempts to export the session log.

"An error occurred while retrieving the logs. The request channel times out while waiting for a reply after 00:00:59. Increase the timeout value passed to the call Request or increase the Send Timeout value on the Binding. The time alotted to this operation may have been a portion of a longer timeout."

Any ideas how we can resolve this? Thank you!

[Ben.Lyons1]

Hi Meghan,

That must frustrating, but there are a couple of additional methods to extract the logs. You may need IT support for these, depending on database access and your level of comfort using command line or SQL. Given the potential ways this could impact your environments performance, please ensure you discuss with your IT team before trying either method.

1) So the first option is using command line, there's a long list of commands available here. But I think the one you're after is /getlog <sessionid>.

The page mentioned above has some instructions of how to use, but if you run into difficulties, there's a troubleshooting guide.

2) Next up is running SQL code, which can be done in Blue Prism if you have a credential with at least read access to the database. 
You need to have the "Data - SQL Server" VBO imported, then follow these steps:
- Data - SQL Server > Configure
- Data - SQL Server > Set Connection
- Data - SQL Server > Get Collection 
Using this code in the final stage

SELECT TOP (10000) [logid]
      ,[sessionnumber]
      ,[stagename]
      ,CONVERT(VarChar(10),[stagetype]) 'stagetype'
      ,[processname]
      ,[pagename]
      ,[objectname]
      ,[actionname]
      ,[result]
      ,[startdatetime]
      ,[enddatetime]
      ,[attributexml]
      ,[targetappname]
      ,[targetappworkingset]
      ,[attributesize]
  FROM [BPASessionLog_NonUnicode]
  WHERE sessionnumber = '$$$$'​

You'll need to replace the $$$$ with the session number and I've limited it to 10,000 rows.

You can then export this to Excel or similar.

If you're not sure with any of this, please raise a support ticket and the team will be more than happy to assist.

Thanks

Ben