Archiving not working

[TobiasArnold]

​Hi all,

I need help archiving old logs.
If I go to System -> Archiving there is a wrong, not writeable path, preset. After a short while there is a good Chance that a "BluePrim didn't working anymore" message box occurs.
Randomly I can change the "Archive Folder", but if I press the "Save" button another meassage box occurs "AutomateConfig isn't working ..."

So I switched to the command line:

C:\Program Files\Blue Prism Limited\Blue Prism Automate>AutomateC.exe /sso /setarchivepath "H:\BPArchive\"
results in
Failed to set archive path - Failed to find the automateconfig named pipe 'automateconfig-server-15164'

Inspecting the event log there a two entries (sorry, german OS :-))

Name der fehlerhaften Anwendung: AutomateConfig.exe, Version: 6.4.0.8445, Zeitstempel: 0x5be497dd
Name des fehlerhaften Moduls: KERNELBASE.dll, Version: 6.1.7601.24511, Zeitstempel: 0x5d3fa9ff
Ausnahmecode: 0xe0434352
Fehleroffset: 0x000000000000b87d
ID des fehlerhaften Prozesses: 0x30d0
Startzeit der fehlerhaften Anwendung: 0x01d572acf6ff6734
Pfad der fehlerhaften Anwendung: C:\Program Files\Blue Prism Limited\Blue Prism Automate\AutomateConfig.exe
Pfad des fehlerhaften Moduls: C:\WINDOWS\system32\KERNELBASE.dll
Berichtskennung: 34d3d619-dea0-11e9-bda5-005056ba7128


AND

Anwendung: AutomateConfig.exe
Frameworkversion: v4.0.30319
Beschreibung: Der Prozess wurde aufgrund einer unbehandelten Ausnahme beendet.
Ausnahmeinformationen: System.Security.Principal.IdentityNotMappedException
   bei System.Runtime.Remoting.Channels.Ipc.IpcServerChannel.StartListening(System.Object)
   bei System.Runtime.Remoting.Channels.Ipc.IpcServerChannel..ctor(System.Collections.IDictionary, System.Runtime.Remoting.Channels.IServerChannelSinkProvider, System.Security.AccessControl.CommonSecurityDescriptor)
   bei BluePrism.Config.ConfigWriterBackgroundForm..ctor(Int32)
   bei BluePrism.Config.AutomateConfig.HandleDaemon(Int32)
   bei BluePrism.Config.AutomateConfig.Main(System.String[])


BPVersion is 6.4 and I have no administrative rights

Any suggestions?

Greetings
toarnold

------------------------------
Tobias Arnold
RPA Developer
ITERGO GmbH
Europe/Duesseldorf
------------------------------

[jegendra]

Hi Tobias,

What's the current size of the top ten tables from the Blue Prism Database?
If the tables are oversized, you may need to execute housekeeping scripts.
These scripts can be obtained from the Blue Prism Customer Support by raising a ticket at support@blueprism.com.

------------------------------
Jega Avinasinathan
Customer Support Engineer
Blue Prism
------------------------------

[TobiasArnold]

Hi Jega,
thanks for your support. The BPA_Sessionlog_NonUnicode ist more than 1TB in size!
I have filed a supporticket now.

​

------------------------------
Tobias Arnold
RPA Developer
ITERGO GmbH
Europe/Duesseldorf
------------------------------

[Walter.Koller]

Your session log is more than 1 Terabyte in size?
How is working with Blue Prism with this amount of log data?

I am wondering because we had to set-up regular archiving to move away everything older than three weeks because Blue Prism became very unresponsive. 
Even now it takes 'noticeable' amount of time to do open objects and work in general.
We run other instances on the same server/DB which much less activities on it, therefore smaller session logs, and they response much better, so it is not related to our HW.



------------------------------
Walter Koller
Solution Manager
Erste Group IT International GmbH
Europe/Vienna
------------------------------

[TobiasArnold]

Hi Walter,

Thanks for your hint, BP is running smooth with this amount of data 😉
We have a three tier ​architecture, with dedicated database and application servers.


------------------------------
Tobias Arnold
RPA Developer
ITERGO GmbH
Europe/Duesseldorf
------------------------------

[GopalBhaire]

In response to Walter.

I wonder how your Blue Prism became unresponsive due to large session logs table. In theory we are not reading from session logs tables when opening a object or process and insert queries to session logs shouldn't affect the performance drastically. I suspect the issue is something else.

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------