1. M

    SQL Query Ran Through Blueprism Not Returning Results

    I have a Blueprism object which opens an Oracle database connection and runs a SQL script. This object has been working correctly for the past 12 months. I am developing a new process and the object isn't bringing back any results. If I run the SQL select against the database it returns results...
  2. M

    Run SQL Pivot Query

    Hi All, I have a process which will run a SQL query and put the output into a collection. I need to run a SQL pivot query. The job just runs and outputs blank results. Is there anyway to have Blueprism put the pivot table into some sort of variable or else right it to a file?
  3. S

    calling stored procedure from a BP action

    hi, I need to automate a process which calls a stored procedure and enters data to a database using Blue Prism. can anyone brief me with the process?
  4. W

    SQL - can't convert system.guid

    Hi, when I try to use SQL VBO and Get Collection action, i'm receving following error: Unexpected error can't convert system.guid to a blue prism data type I think it's releated to NULL values within database, I read some post on stack, but didn't find any solution for that issue. Have any of...
  5. U

    Error Related to Database when size Increases

    Hi Team, When we started designing the solution the size was 500 MB along with the log file, after completion its size increased to 1.6 GB with the log. Now the solution was in production and its size is 1.96 GB, now the size was increased so much so that the solution has become very slow, and...
  6. D

    Export All Process Logs from Audit - Process Logs

    From System - Audit - Process Logs, I have several years' worth of process logs. I can view or export each log individually, but I would like to be able to export them all at once (to a SQL Server preferably). I have access to the database that the Blue Prism server is connected to. Are there...
  7. R

    Rui Costa's Introduction

    Hi everyone, I'm from Portugal and a newbie in RPA, I'm still doing the official training. I've been a web developer for 18 years and in my last 10 years I've developed always with C#, ASP.NET Web Forms and ASP.NET MVC. My main technical experience: on ASP.NET, C#, HTML, Javascript and CSS...
  8. gracylayla

    Performance of our work in the pega is measured using

    DBTrace: DBTrace is a feature in the Performance Analysis Tool (PAL) that creates a detailed log of calls to the PegaRULES database. DBTrace displays SQL statements sent to the database and the time spent for each operation. PAL: This data is stored in “PAL counters” or “PAL readings.” PAL...