Question

3
Replies
95
Views
 Surya Narayana Y V (SuryaYanamandra)
Capgemini
Pega Developer
Capgemini
IN
SuryaYanamandra Member since 2016 27 posts
Capgemini
Posted: January 23, 2019
Last activity: February 8, 2019
Posted: 23 Jan 2019 11:25 EST
Last activity: 8 Feb 2019 14:12 EST
Closed
Solved

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-12154-tns-could-not-resolve-the-connect-identifier-specified-error-while-creating-a-linked-server-to-oracle/

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

Robotic Process Automation
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.

Accepted Solution

Posted: 2 years ago
Posted: 24 Jan 2019 7:23 EST
Konstantin Serditov (Konstantin Serditov)
PEGA

Pegasystems Inc.

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
Posted: 2 years ago
Posted: 24 Jan 2019 8:52 EST
Surya Narayana Y V (SuryaYanamandra)
Capgemini
Pega Developer
Capgemini
IN

@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"