sql

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...

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?

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?

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...

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...

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...

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...

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...