Unable to terminate excel application
Hi,I am getting below error while dealing with Excel application. It is an intermittent issue, but sometimes it is coming frequently. Can anyone please help me with possible reasons?Thanks,Dipin Dev P
Forum Posts
Resolved! Excel - Sensitivity Label
Hi Experts,Please help me on below query!While I am trying to Save data after copying it from one Excel file to another (newly created) using MS Excel VBO actions, below popup comes.Is there any option to handle this (to set a label or cancel it) wit...
Resolved! Error on OLEDB Execute stage
Hello,I have an excel file in the xlsx format. I need to do a find and replace function so it finds all the comma's and replace it with a blank space.I am using the OLEDB actions - the OLEDB 'Set Connection' and 'Open' action work - however i am gett...
C# code stage system.data defaults to old version
I get the following error Compiler error at line 0: The type name 'DataTable' could not be found in the namespace 'System.Data'. This type has been forwarded to assembly 'System.Data.Common, Version=0.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11...
Auto archiving competing for SQL table locks
Hi all, we have been having a problem which has become more frequent recently, where the auto archiving process built in to Blue Prism, is competing for table lock with our regular SQL maintenance job. This is impacting several schedules as they are ...
Excel - Print (Fit to Page) Code Stage
Hi All,Has anyone ever created a code stage for Excel to fit to pages when printing (e.g fit to 1 page wide/tall)? Thanks!
Connection Failed SQL Server Blue Prism Hub 4.7
Is there any way to install Blue Prism Hub 4.6 or earlier without using SSL Encryption CA? I need to run some tests in my test environment to load data into the Blue Prism queue through API. Thank you in advance!Blue Prism Enterprise
OLEDB - Data type mismatch in criteria expression
Hi, I was trying to fetch data from an Excel using OLEDB with below query but getting an error - Could not execute code stage because exception thrown by code stage: Data type mismatch in criteria expression.SELECT [No],[Resp (3&4)] FROM [Call Sheet$...
Resolved! Looking for a suggestion regarding the connection of Blue Prism Database and Power BI
Hi,I have connected the Blue Prism database to Power BI to get an overview of all our bots. I just have to click on the “ Update ” button in Power BI. The data is automatically transferred from the database. I have noticed that uploading the data to ...
Resolved! To add data line by line in a Text Data Item
Hi,Is there any way to add data to a text data item line by line? I need to add data from a collection column into a single text data item in the below format. Is there any option to append line breaks or any other methods available to achieve this?A...
Facing issue while importing the form in Blueprism hub: Refreshing queues failed. 106
Hi Community,Hope you are doing well.I am trying to import interact form from blueprism test region to production region and while importing the form into production region and selecting the work queue by typing the work queue name in text box. i can...
Capture - Bprelease not exporting when custom template is fed
Hello - i followed below steps - for exporting bp release from capture- step 3 is failing.once i click on restore exports to defaults. step 3 is working fine.Step 1 - Create or edit a BP release templateStep 2 - Load that template in BP Capture >Sett...
Receiving Junk data from HTTP/API Response
Hi All,We create orders through API requests / HTTP requests (using the POST Method) by sending JSON files and saving the API response in text format.But we are receiving junk data like below from the Response in HTTP and API. Below is the blue prism...
IBM Personal Communicator : Unable to specify Environment variable as Session file Path
Hello all, I am trying to specify the session file path (.WS) for an IBM Personal Communicator (COM API) Emulator through an environment variable and when I use the Navigate/Launch stage with the data item in the path, I get the following error mess...
Excel Operations logic help
Hi,I am requesting a logic help here which I need to handle with Excel VBO in Blue Prism. It would be great, if someone can share ideas on how to implement it.Please check the attached Excel file Images, in which there are 2 sets of data with ID 111...
