Blue Prism Product

 View Only
last person joined: yesterday 

This community covers the core Blue Prism RPA product.

  • 1.  Insert on SQL Server

    Posted 11-06-2019 22:48
    Hello friends !!

    I'm facing a serious issue, and I depends to this to keep in my job? Please someone can Help?

    I'm trying to input some datas in an SQL table, but its nor working. Follows below my query:

    into dbo.dbP4FResultado (cpf,situacaoCadastral,dataHoraComprovante,protocolo,document,status,mensagemFinal,enviado,dob,fullName,leveshtein,jarow)
    values ('"&[CPF]&"','"&[Situação Cadastral]&"','"&[tmstp]&"','"&[Protocolo]&"','"&[Binario PDF]&"','"&[processado] &"','"&[mensagemFinal]&"','0',''"&[Data de Nascimento]&"','"&[Nome]&"','"&[leveshtein]&"','"&[jarow]&"');"

    For god sake, someone can help me?

    Thank you very much.

    Jeferson Romão
    Lyo Solutions

  • 2.  RE: Insert on SQL Server

    Posted 11-06-2019 23:21
    Hey Jeferson

    Could you please let us know what issue you are getting while inserting the data into the table? If there is any SQL error, could you please share the same?

    Karan Sareen

    Karan Sareen
    Solution Support Engineer

  • 3.  RE: Insert on SQL Server

    Posted 11-07-2019 18:23
    Hello dear community !!

    I'd like to thank you all that send some answer! My issue was solved.

    Thank you!!!

    Jeferson Romão
    Lyo Solutions

  • 4.  RE: Insert on SQL Server

    Posted 11-07-2019 10:11
      |   view attached


    Two suggestions:

    1. Error in the SQL you Posted

    Part of the insert has an extra inverted comma, on line 25 in the attached image. when you are inserting the value: [Data de Nascimento].

    Look at the image attached, using a IDE or some application to illustrate these kinds of problems can be very useful.  I am using MS SQL Server.

    But NotePad++ is an excellent option to help with this as you can select from many languages and simple errors like this will appear immediately.

    If this does not work, please post the actual error you are getting.

    2. Confirm all the data types are correct
    Make sure the data being entered in each column of the SQL table matches the datatype in the Blue Prism.  I have no way of seeing either your Blue Prism datatypes or the MS SQL table.

    Also good luck with the job thing.  Look at a few free courses on Udemy or Codecademy.

    Kind regards,

    Also used Google translate to help because you might be stressing out and English is not your first language but generally I believe this forum is for English only.

    Em português (google translate), há uma vírgula invertida extra onde você está inserindo o valor "[Data de Nascimento]". Exclua a vírgula invertida extra e a consulta SQL estará correta. Ainda pode haver outros problemas, como tipos de dados que não estão corretos.

    Ben Kirimlidis
    RPA Developer and Data Analyst

  • 5.  RE: Insert on SQL Server

    Posted 11-07-2019 13:49
    You have an extra single quote (') before "&[Data de Nascimento]&", and I do not use the ; at the end when using SQL inside Blue Prism so I am not sure if that could also be causing an issue.  If this is not the solution, post the error message you are getting.

    Derek Turner
    Applications Advisor

Welcome to the Blue Prism RPA Product Community!

Whether you’re looking to manage a complex infrastructure, maintain security and compliance, bring new products to market faster, or gain operational speed and agility in an uncertain economy, Blue Prism delivers — with the flexibility you need to create the business you want. From deployment on-premise, through a cloud service provider or as SaaS, to a skillful and adaptable digital workforce that continually expands to meet your enterprise needs, you can gain enhanced operational insight and control while your people reclaim the time they need to focus on great work.

Product PageKnowledge BaseBlue Prism Training Offering
Product Research ProgramUpdates, Releases & Announcements


Blue Prism is intelligent automation — business-developed, no-code automation that pushes the boundaries of robotic process automation (RPA) to deliver value across any business process in a connected enterprise.

A combination of RPA with expanded cognitive and AI capabilities, Blue Prism is different than other automation technology on the market. With one Blue Prism license, you gain instant access to an already AI equipped digital workforce, along with the tools you need to build and delegate automations. Click here for more information on Blue Prism and Intelligent Automation.
To learn more about how Blue Prism RPA can help your organization and how much it will cost to get started, please Contact our Sales department.
Blue Prism RPA can be downloaded from our customer portal. If you would like to consume or download any material it is necessary to create an account on the Portal. Once you have registered, you can access the download options for Blue Prism here.
Yes! Installed on your own machine and supported by our training materials and product documentation, you can use all the features of the full enterprise product for free with our Blue Prism Trial – giving you the opportunity to learn the basics before moving to a full production implementation. Click here for more information and to download the trial.
Yes! You can access our known issue list for Blue Prism from our Support Portal.
Regardless of your industry, Blue Prism’s Digital Workforce can adhere to strict governance and compliance standards without limiting productivity. Click here for more information on how your industry can benefit from Blue Prism.