Question
Need some Help in Pega Robotics Area.
Need some help in Pega Robotics area #needhelp . . not able to find some scenarios and overcome some errors while working with Pega Robotics Studio. . For Instance:
1.Getting 'Error 12154: ORA-12154: TNS:could not resolve the connect identifier specified' this error while connecting to DB through Pega Robotics studio. Followed steps suggested in the below link. . yet getting the same.
https://blogs.msdn.microsoft.com/dataaccesstechnologies/2010/06/30/ora-…
2.Also curious to know, whether Pega Robotics Studio have Cognitive Capabilities.
3. How to write and append the array values to text file as an output file.
Thanks,
Surya Yanamandra
@Konstantin Serditov Thanks for the reply. For DB connection I am trying OracleQuery Component from toolbox.
1. Adding OracleQuery Component.
2. To connection string, by Selecting Browse
In Provider tab of Data link Properties, selecting Microsoft OLE DB Provider for Oracle.
3. In Connection tab of Datalink properties, Giving host name near Enter a Server name option. Along with User Name and Password in Enter information to Logon to the Database Option.
4. Then on clicking of Test Connection Button, getting the above mentioned Error.
Also sometimes getting error like "ORA-12504 tns listener was not given the service_name in connect_data"
Using connector you may get these errors. so just go with script.
1. Which component do you use to connect to DB? Is it OleDBQuery or OracleQuery or script or .net library? Anyway please double check your connection string, looks like Oracle does not accept it. See if these examples are helpful: https://www.connectionstrings.com/oracle/
2. Pega Robotics itself doesn't have it, but you can integrate with Pega Platform which has wide capabilities or integrate 3rd party .net libraries.
3. Probably easiest way is to use File.AppendAllText method. You can add it to the Toolbox from Static Members tab as described here: http://help.openspan.com/80/Using_Studio/Adding_and_Removing_Toolbox_Items2.htm