Error while opening process

[Neel1]

Hello,

Done some changes in process then BP got hanged and goes into not responding state. On reopening BP, received below error but not able to recover the latest changes done in process.

suggestion needed  on why this come how to recover up to date code 

Error loading: Exception while loading process : Input string was not in a correct format

------------------------------
Neeraj Kumar
Technical Architect
------------------------------

[Tejaskumar_Darji]

Hello Neeraj,

Did you enable the Auto backup option?


Trying to see if we can recover the last auto saved XML.

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------

[Neel1]

Hello Tejas- yes this is enabled.

whenever trying to use first option - it throw that error. finally used the 2nd option, but all work was found lost.
wondering whether that work was ever saved in Db or not



------------------------------
Neeraj Kumar
Technical Architect
------------------------------

[Tejaskumar_Darji]

BP stores all auto backups in the BPAProcessBackup table.

If you have access to DB please try to grab XML from this DB table and see if it helps.

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------

[devneetmohanty07 · Accepted solution]

Hi Neeraj,

If you have the access to the database, copy the XML and paste it in some notepad file with .XML format and you can reimport the object after executing the following query:

SELECT [eventdatetime]
      ,[sNarrative]
      ,[gTgtProcID]
      ,[comments]
      ,[EditSummary]
      ,[oldXML]
      ,[newXML]
  FROM [blueprism].[dbo].[BPAAuditEvents] INNER JOIN [blueprism].[dbo].[BPAProcess] 
  ON [blueprism].[dbo].[BPAAuditEvents].gTgtProcID = [blueprism].[dbo].[BPAProcess].processid
  WHERE [newXML] IS NOT NULL AND [blueprism].[dbo].[BPAProcess].name = 'Order System - Enter Order'
  ORDER BY [eventdatetime] DESC

Replace the <YOUR PROCESS NAME> attribute with the name of the process which you can see in the 'BPAProcess' table for which you need the XML. Here the top most record will give you your desired XML value from the [newXML] column



------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------