New Ranks & Badges For The Community!
Notice something different? The ranks and associated badges have gone "Star Fleet". See what they all mean HERE

Video: Robotic Process Automation (RPA) Installation - Authoring Environment

Video: Robotic Process Automation (RPA) Installation - Authoring Environment

This video contains the steps to install RPA components required for creating workflows and recording screen elements.

NOTE: This video contains no audio.

Watch Video

Labels (1)

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Comments

Hi, I am facing an error while installing RPA 2020.02 Designer. During the Designer Database Configuration, I am creating the database/schema for PostgreSQL, I have followed the instructions as in video, have input the passwords also, when I click on Test Connection button, it shows an error "The connection attempt failed". Hence I am stuck here. Can I please get the help? Thanks.

 

 

@kmahesh8 if you receive this error it means that you haven't configured correctly the database host, user/pass or you might have connectivity issues to your database server. You should check the installation log for more details.

Once the database server is reachable from the machine you install the Designer, the installer will report success on test connection and you will be able to proceed further with the installation.

@FlorinM  Thanks for the quick response. I just followed the instructions given. I do not know how to find if the database is configured correctly or not. username I gave as shown in the video, password i defined my own. Sorry since I am not allowed to attach any document, i have copy pasted the log info below. Please help.

 

2020-06-15 19:31:57,438 [INFO ] installation log initialized
2020-06-15 19:33:17,797 [INFO ] ServerSocket[addr=/0.0.0.0,localport=8445]
2020-06-15 19:33:17,799 [INFO ] ServerSocket[addr=/0:0:0:0:0:0:0:0,localport=8445]
2020-06-15 19:33:17,800 [INFO ] ServerSocket[addr=/127.0.0.1,localport=8445]
2020-06-15 19:33:17,800 [INFO ] ServerSocket[addr=/0:0:0:0:0:0:0:1,localport=8445]
2020-06-15 19:33:17,801 [INFO ] IPv4 0.0.0.0:8445 is available
2020-06-15 19:33:17,801 [INFO ] IPv4 0.0.0.1:8445 is available
2020-06-15 19:33:17,801 [INFO ] IPv6 ::0:8445 is available
2020-06-15 19:33:17,801 [INFO ] IPv6 ::1:8445 is available
2020-06-15 19:51:08,443 [INFO ] testing connection to jdbc:postgresql://rpa.microfocus.com:5432/ username: postgres
2020-06-15 19:51:11,029 [WARN ] unable to connect: The connection attempt failed.
org.postgresql.util.PSQLException: The connection attempt failed.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:257)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:159)
at org.postgresql.Driver.makeConnection(Driver.java:416)
at org.postgresql.Driver.connect(Driver.java:283)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.hpe.webstudio.wizard.commands.DbCommand.createConnection(DbCommand.java:74)
at com.hpe.webstudio.wizard.commands.TestDbConnectionCommand.canConnect(TestDbConnectionCommand.java:34)
at com.hpe.webstudio.wizard.DbPage$1.handleEvent(DbPage.java:543)
at com.microfocus.itom.wizard.controls.impl.WizardControl$EventDispatcher.fireEvent(WizardControl.java:544)
at com.microfocus.itom.wizard.controls.impl.WizardControl$EventDispatcher.handleEvent(WizardControl.java:533)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at com.microfocus.itom.wizard.core.WizardDialogImpl.open(WizardDialogImpl.java:93)
at com.hpe.webstudio.wizard.InstallerWizard.showWizard(InstallerWizard.java:260)
at com.hpe.webstudio.wizard.InstallerWizard.<init>(InstallerWizard.java:112)
at com.hpe.webstudio.wizard.RpaInstallerWizard.main(RpaInstallerWizard.java:11)
Caused by: java.net.UnknownHostException: rpa.microfocus.com
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:607)
at org.postgresql.core.PGStream.<init>(PGStream.java:61)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:129)
... 19 more
2020-06-15 19:51:11,029 [INFO ] test result: TestResult{url='jdbc:postgresql://rpa.microfocus.com:5432/RPADesigner', username='postgres', password='empty password', jdbcDriver='org.postgresql.Driver', successful=false, error='The connection attempt failed.'}
2020-06-15 19:53:40,450 [INFO ] testing connection to jdbc:postgresql://rpa.microfocus.com:5432/ username: postgres
2020-06-15 19:53:40,707 [WARN ] unable to connect: The connection attempt failed.
org.postgresql.util.PSQLException: The connection attempt failed.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:257)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:159)
at org.postgresql.Driver.makeConnection(Driver.java:416)
at org.postgresql.Driver.connect(Driver.java:283)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.hpe.webstudio.wizard.commands.DbCommand.createConnection(DbCommand.java:74)
at com.hpe.webstudio.wizard.commands.TestDbConnectionCommand.canConnect(TestDbConnectionCommand.java:34)
at com.hpe.webstudio.wizard.DbPage$1.handleEvent(DbPage.java:543)
at com.microfocus.itom.wizard.controls.impl.WizardControl$EventDispatcher.fireEvent(WizardControl.java:544)
at com.microfocus.itom.wizard.controls.impl.WizardControl$EventDispatcher.handleEvent(WizardControl.java:533)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at com.microfocus.itom.wizard.core.WizardDialogImpl.open(WizardDialogImpl.java:93)
at com.hpe.webstudio.wizard.InstallerWizard.showWizard(InstallerWizard.java:260)
at com.hpe.webstudio.wizard.InstallerWizard.<init>(InstallerWizard.java:112)
at com.hpe.webstudio.wizard.RpaInstallerWizard.main(RpaInstallerWizard.java:11)
Caused by: java.net.UnknownHostException: rpa.microfocus.com
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:607)
at org.postgresql.core.PGStream.<init>(PGStream.java:61)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:129)
... 19 more
2020-06-15 19:53:40,707 [INFO ] test result: TestResult{url='jdbc:postgresql://rpa.microfocus.com:5432/RPADesigner', username='postgres', password='empty password', jdbcDriver='org.postgresql.Driver', successful=false, error='The connection attempt failed.'}
2020-06-15 19:54:12,778 [INFO ] testing connection to jdbc:postgresql://rpa.microfocus.com:5432/ username: postgres
2020-06-15 19:54:17,267 [WARN ] unable to connect: The connection attempt failed.
org.postgresql.util.PSQLException: The connection attempt failed.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:257)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:159)
at org.postgresql.Driver.makeConnection(Driver.java:416)
at org.postgresql.Driver.connect(Driver.java:283)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.hpe.webstudio.wizard.commands.DbCommand.createConnection(DbCommand.java:74)
at com.hpe.webstudio.wizard.commands.TestDbConnectionCommand.canConnect(TestDbConnectionCommand.java:34)
at com.hpe.webstudio.wizard.DbPage$1.handleEvent(DbPage.java:543)
at com.microfocus.itom.wizard.controls.impl.WizardControl$EventDispatcher.fireEvent(WizardControl.java:544)
at com.microfocus.itom.wizard.controls.impl.WizardControl$EventDispatcher.handleEvent(WizardControl.java:533)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at com.microfocus.itom.wizard.core.WizardDialogImpl.open(WizardDialogImpl.java:93)
at com.hpe.webstudio.wizard.InstallerWizard.showWizard(InstallerWizard.java:260)
at com.hpe.webstudio.wizard.InstallerWizard.<init>(InstallerWizard.java:112)
at com.hpe.webstudio.wizard.RpaInstallerWizard.main(RpaInstallerWizard.java:11)
Caused by: java.net.UnknownHostException: rpa.microfocus.com
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:607)
at org.postgresql.core.PGStream.<init>(PGStream.java:61)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:129)
... 19 more
2020-06-15 19:54:17,267 [INFO ] test result: TestResult{url='jdbc:postgresql://rpa.microfocus.com:5432/RPAWDesigner', username='postgres', password='empty password', jdbcDriver='org.postgresql.Driver', successful=false, error='The connection attempt failed.'}
2020-06-15 19:56:57,088 [INFO ] testing connection to jdbc:sqlserver://rpa.microfocus.com:1433 username: adminuser
2020-06-15 19:57:12,002 [WARN ] unable to connect: The TCP/IP connection to the host rpa.microfocus.com, port 1433 has failed. Error: "rpa.microfocus.com. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host rpa.microfocus.com, port 1433 has failed. Error: "rpa.microfocus.com. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:234)
at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:285)
at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2431)
at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:656)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2472)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2142)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1993)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1164)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:760)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.hpe.webstudio.wizard.commands.DbCommand.createConnection(DbCommand.java:74)
at com.hpe.webstudio.wizard.commands.TestDbConnectionCommand.canConnect(TestDbConnectionCommand.java:34)
at com.hpe.webstudio.wizard.DbPage$1.handleEvent(DbPage.java:543)
at com.microfocus.itom.wizard.controls.impl.WizardControl$EventDispatcher.fireEvent(WizardControl.java:544)
at com.microfocus.itom.wizard.controls.impl.WizardControl$EventDispatcher.handleEvent(WizardControl.java:533)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at com.microfocus.itom.wizard.core.WizardDialogImpl.open(WizardDialogImpl.java:93)
at com.hpe.webstudio.wizard.InstallerWizard.showWizard(InstallerWizard.java:260)
at com.hpe.webstudio.wizard.InstallerWizard.<init>(InstallerWizard.java:112)
at com.hpe.webstudio.wizard.RpaInstallerWizard.main(RpaInstallerWizard.java:11)
2020-06-15 19:57:12,003 [INFO ] test result: TestResult{url='jdbc:sqlserver://rpa.microfocus.com:1433;databaseName=RPADesigner;sendStringParametersAsUnicode=true', username='adminuser', password='empty password', jdbcDriver='com.microsoft.sqlserver.jdbc.SQLServerDriver', successful=false, error='The TCP/IP connection to the host rpa.microfocus.com, port 1433 has failed. Error: "rpa.microfocus.com. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".'}
2020-06-15 21:08:54,123 [INFO ] testing connection to jdbc:postgresql://rpa.microfocus.com:5432/ username: postgres
2020-06-15 21:08:54,500 [WARN ] unable to connect: The connection attempt failed.
org.postgresql.util.PSQLException: The connection attempt failed.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:257)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:159)
at org.postgresql.Driver.makeConnection(Driver.java:416)
at org.postgresql.Driver.connect(Driver.java:283)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.hpe.webstudio.wizard.commands.DbCommand.createConnection(DbCommand.java:74)
at com.hpe.webstudio.wizard.commands.TestDbConnectionCommand.canConnect(TestDbConnectionCommand.java:34)
at com.hpe.webstudio.wizard.DbPage$1.handleEvent(DbPage.java:543)
at com.microfocus.itom.wizard.controls.impl.WizardControl$EventDispatcher.fireEvent(WizardControl.java:544)
at com.microfocus.itom.wizard.controls.impl.WizardControl$EventDispatcher.handleEvent(WizardControl.java:533)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at com.microfocus.itom.wizard.core.WizardDialogImpl.open(WizardDialogImpl.java:93)
at com.hpe.webstudio.wizard.InstallerWizard.showWizard(InstallerWizard.java:260)
at com.hpe.webstudio.wizard.InstallerWizard.<init>(InstallerWizard.java:112)
at com.hpe.webstudio.wizard.RpaInstallerWizard.main(RpaInstallerWizard.java:11)
Caused by: java.net.UnknownHostException: rpa.microfocus.com
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:607)
at org.postgresql.core.PGStream.<init>(PGStream.java:61)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:129)
... 19 more
2020-06-15 21:08:54,508 [INFO ] test result: TestResult{url='jdbc:postgresql://rpa.microfocus.com:5432/RPAWDesigner', username='postgres', password='empty password', jdbcDriver='org.postgresql.Driver', successful=false, error='The connection attempt failed.'}
2020-06-15 21:34:05,603 [INFO ] testing connection to jdbc:postgresql://rpa.microfocus.com:5432/ username: postgres
2020-06-15 21:34:05,748 [WARN ] unable to connect: The connection attempt failed.
org.postgresql.util.PSQLException: The connection attempt failed.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:257)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:159)
at org.postgresql.Driver.makeConnection(Driver.java:416)
at org.postgresql.Driver.connect(Driver.java:283)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.hpe.webstudio.wizard.commands.DbCommand.createConnection(DbCommand.java:74)
at com.hpe.webstudio.wizard.commands.TestDbConnectionCommand.canConnect(TestDbConnectionCommand.java:34)
at com.hpe.webstudio.wizard.DbPage$1.handleEvent(DbPage.java:543)
at com.microfocus.itom.wizard.controls.impl.WizardControl$EventDispatcher.fireEvent(WizardControl.java:544)
at com.microfocus.itom.wizard.controls.impl.WizardControl$EventDispatcher.handleEvent(WizardControl.java:533)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at com.microfocus.itom.wizard.core.WizardDialogImpl.open(WizardDialogImpl.java:93)
at com.hpe.webstudio.wizard.InstallerWizard.showWizard(InstallerWizard.java:260)
at com.hpe.webstudio.wizard.InstallerWizard.<init>(InstallerWizard.java:112)
at com.hpe.webstudio.wizard.RpaInstallerWizard.main(RpaInstallerWizard.java:11)
Caused by: java.net.UnknownHostException: rpa.microfocus.com
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:607)
at org.postgresql.core.PGStream.<init>(PGStream.java:61)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:129)
... 19 more
2020-06-15 21:34:05,765 [INFO ] test result: TestResult{url='jdbc:postgresql://rpa.microfocus.com:5432/RPAWDesigner', username='postgres', password='empty password', jdbcDriver='org.postgresql.Driver', successful=false, error='The connection attempt failed.'}
2020-06-15 21:34:06,956 [INFO ] testing connection to jdbc:postgresql://rpa.microfocus.com:5432/ username: postgres
2020-06-15 21:34:06,956 [WARN ] unable to connect: The connection attempt failed.
org.postgresql.util.PSQLException: The connection attempt failed.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:257)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:159)
at org.postgresql.Driver.makeConnection(Driver.java:416)
at org.postgresql.Driver.connect(Driver.java:283)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.hpe.webstudio.wizard.commands.DbCommand.createConnection(DbCommand.java:74)
at com.hpe.webstudio.wizard.commands.TestDbConnectionCommand.canConnect(TestDbConnectionCommand.java:34)
at com.hpe.webstudio.wizard.DbPage$1.handleEvent(DbPage.java:543)
at com.microfocus.itom.wizard.controls.impl.WizardControl$EventDispatcher.fireEvent(WizardControl.java:544)
at com.microfocus.itom.wizard.controls.impl.WizardControl$EventDispatcher.handleEvent(WizardControl.java:533)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at com.microfocus.itom.wizard.core.WizardDialogImpl.open(WizardDialogImpl.java:93)
at com.hpe.webstudio.wizard.InstallerWizard.showWizard(InstallerWizard.java:260)
at com.hpe.webstudio.wizard.InstallerWizard.<init>(InstallerWizard.java:112)
at com.hpe.webstudio.wizard.RpaInstallerWizard.main(RpaInstallerWizard.java:11)
Caused by: java.net.UnknownHostException: rpa.microfocus.com
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:607)
at org.postgresql.core.PGStream.<init>(PGStream.java:61)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:129)
... 19 more
2020-06-15 21:34:06,964 [INFO ] test result: TestResult{url='jdbc:postgresql://rpa.microfocus.com:5432/RPAWDesigner', username='postgres', password='empty password', jdbcDriver='org.postgresql.Driver', successful=false, error='The connection attempt failed.'}
2020-06-15 21:34:19,878 [INFO ] testing connection to jdbc:postgresql://rpa.microfocus.com:5432/RPAWDesigner username: RPAWDesigner
2020-06-15 21:34:19,901 [WARN ] unable to connect: The connection attempt failed.
org.postgresql.util.PSQLException: The connection attempt failed.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:257)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:159)
at org.postgresql.Driver.makeConnection(Driver.java:416)
at org.postgresql.Driver.connect(Driver.java:283)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.hpe.webstudio.wizard.commands.DbCommand.createConnection(DbCommand.java:74)
at com.hpe.webstudio.wizard.commands.TestDbConnectionCommand.canConnect(TestDbConnectionCommand.java:34)
at com.hpe.webstudio.wizard.DbPage$1.handleEvent(DbPage.java:543)
at com.microfocus.itom.wizard.controls.impl.WizardControl$EventDispatcher.fireEvent(WizardControl.java:544)
at com.microfocus.itom.wizard.controls.impl.WizardControl$EventDispatcher.handleEvent(WizardControl.java:533)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at com.microfocus.itom.wizard.core.WizardDialogImpl.open(WizardDialogImpl.java:93)
at com.hpe.webstudio.wizard.InstallerWizard.showWizard(InstallerWizard.java:260)
at com.hpe.webstudio.wizard.InstallerWizard.<init>(InstallerWizard.java:112)
at com.hpe.webstudio.wizard.RpaInstallerWizard.main(RpaInstallerWizard.java:11)
Caused by: java.net.UnknownHostException: rpa.microfocus.com
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:607)
at org.postgresql.core.PGStream.<init>(PGStream.java:61)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:129)
... 19 more
2020-06-15 21:34:19,901 [INFO ] test result: TestResult{url='jdbc:postgresql://rpa.microfocus.com:5432/RPAWDesigner', username='RPAWDesigner', password='empty password', jdbcDriver='org.postgresql.Driver', successful=false, error='The connection attempt failed.'}
2020-06-15 21:34:21,425 [INFO ] testing connection to jdbc:postgresql://rpa.microfocus.com:5432/RPAWDesigner username: RPAWDesigner
2020-06-15 21:34:21,435 [WARN ] unable to connect: The connection attempt failed.
org.postgresql.util.PSQLException: The connection attempt failed.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:257)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:159)
at org.postgresql.Driver.makeConnection(Driver.java:416)
at org.postgresql.Driver.connect(Driver.java:283)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.hpe.webstudio.wizard.commands.DbCommand.createConnection(DbCommand.java:74)
at com.hpe.webstudio.wizard.commands.TestDbConnectionCommand.canConnect(TestDbConnectionCommand.java:34)
at com.hpe.webstudio.wizard.DbPage$1.handleEvent(DbPage.java:543)
at com.microfocus.itom.wizard.controls.impl.WizardControl$EventDispatcher.fireEvent(WizardControl.java:544)
at com.microfocus.itom.wizard.controls.impl.WizardControl$EventDispatcher.handleEvent(WizardControl.java:533)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at com.microfocus.itom.wizard.core.WizardDialogImpl.open(WizardDialogImpl.java:93)
at com.hpe.webstudio.wizard.InstallerWizard.showWizard(InstallerWizard.java:260)
at com.hpe.webstudio.wizard.InstallerWizard.<init>(InstallerWizard.java:112)
at com.hpe.webstudio.wizard.RpaInstallerWizard.main(RpaInstallerWizard.java:11)
Caused by: java.net.UnknownHostException: rpa.microfocus.com
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:607)
at org.postgresql.core.PGStream.<init>(PGStream.java:61)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:129)
... 19 more
2020-06-15 21:34:21,435 [INFO ] test result: TestResult{url='jdbc:postgresql://rpa.microfocus.com:5432/RPAWDesigner', username='RPAWDesigner', password='empty password', jdbcDriver='org.postgresql.Driver', successful=false, error='The connection attempt failed.'}

@kmahesh8 the video only demonstrates how you should install the RPA component. You should not use the same hostnames, users or passwords that are referenced in the video. As a prerequisite, you should install your own database server, which will have it's own hostname / IP address. The logs clearly show that you are using rpa.microfocus.com as your database hostname. This is just wrong, since this value was used to record the demo and you should replace this with your own database server hostname.

Please refer to the more detailed information on the installation process here: https://docs.microfocus.com/itom/Robotic_Process_Automation:2020.02/InstallCleanDesigner

Hello,

I followed the youtube video to install RPA Authoring tools. Tools were installed successfully.
When I am trying to browse through the oo-designer...

1) I am prompted the login screen, I enter the same credentials which I entered in the installation wizard. And click Login.
2) Get "HTTP Status 401 – Unauthorized"

Can anyone guide, what could be possible root cause of the problem.

Thanks!

@Ashish Thakur can you please specify what user you are trying to login with?

Hello @FlorinM I am trying to logging with admin user specified during designer installation.

The URL that you need to access to open the Workflow Designer is https://<hostname>:<port>/oo-designer/ , where hostname should be the server/vm FQDN and the port is the chosen port during installation. By default, the port is 8445.

Can you please confirm this is the URL you are accessing?

What RPA version have you installed?

@FlorinM,

Yes, I am accessing the OO-designer using https://<fqdn>:8445/oo-designer thats why I am getting login screen. After entering admin credentials, I get 401 error (seems there is no way to share screenshot)

Thanks - Ashish

@Ashish Thakur I am suggesting you take a look at the logs in the <installation_folder>/designer/var/logs/ and see if there are relevant errors that might point you in the right direction. 

It is also recommended that you open a support ticket to get this problem reviewed. It might be a configuration problem.

@FlorinM , as per your suggestion I reviewed server.log (sharing log below), Reviewing this do you have some suggestion for me..  

2020-09-25 08:38:07,488 [WrapperStartStopAppMain] (AbstractEventsBuffer.java:48) WARN - Debugger execution events: - init buffer with capacity: 100000, with bulkSize:5000
2020-09-25 08:38:08,144 [WrapperStartStopAppMain] (LWSSOConfigurationServiceImpl.java:53) WARN - "InitString" cannot be shorter than 12 characters.
2020-09-25 08:38:08,488 [WrapperStartStopAppMain] (LWSSOConfigurationServiceImpl.java:53) WARN - "InitString" cannot be shorter than 12 characters.
2020-09-25 12:09:51,420 [https-jsse-nio-8445-exec-1] (OoRpHttpConnectionImpl.java:138) ERROR - Connection response code returned :401
2020-09-25 12:09:51,422 [https-jsse-nio-8445-exec-1] (OoRpHttpConnectionImpl.java:147) ERROR - Connection response code returned: 401: ‹VJ-*Ê/*V²ŠVJ-,M-.Q(QH­Èæ)d+dæ•%æd¦(ÅÖ ÿÿ -~Ê09
2020-09-29 10:12:26,517 [WrapperStartStopAppMain] (AbstractEventsBuffer.java:48) WARN - Debugger execution events: - init buffer with capacity: 100000, with bulkSize:5000
2020-09-29 10:12:27,189 [WrapperStartStopAppMain] (LWSSOConfigurationServiceImpl.java:53) WARN - "InitString" cannot be shorter than 12 characters.
2020-09-29 10:12:27,564 [WrapperStartStopAppMain] (LWSSOConfigurationServiceImpl.java:53) WARN - "InitString" cannot be shorter than 12 characters.
2020-09-29 16:15:23,833 [WrapperStartStopAppMain] (AbstractEventsBuffer.java:48) WARN - Debugger execution events: - init buffer with capacity: 100000, with bulkSize:5000
2020-09-29 16:15:24,803 [WrapperStartStopAppMain] (LWSSOConfigurationServiceImpl.java:53) WARN - "InitString" cannot be shorter than 12 characters.
2020-09-29 16:15:25,256 [WrapperStartStopAppMain] (LWSSOConfigurationServiceImpl.java:53) WARN - "InitString" cannot be shorter than 12 characters.


Regards,

Ashish

@Ashish Thakur the information from this log is not sufficient. Can you please check also the idm-service.log from the same folder?

It would help if you also provide the messages that are displayed after your login attempt.

Thanks,
Florin

Hello @FlorinM,


Please find below idm-service.log after login attempt.
It says authentication is succeeded, then Why '401 Unauthorized'; error is coming.

idm-service.log...
2020-10-05 13:04:13,275 [https-jsse-nio-8445-exec-4] INFO com.hp.ccue.identity.filter.RequestTokenFilter - idm auth group: AuthGroup{organization=RPA, name=defaultauthgroupname, configurations:1}
2020-10-05 13:04:13,276 [https-jsse-nio-8445-exec-4] INFO com.hp.ccue.identity.filter.RequestTokenFilter - idm auth flow: [SEEDED, DATABASE_USER, LDAP, JAAS, AD]
2020-10-05 13:04:13,344 [https-jsse-nio-8445-exec-4] INFO com.hp.ccue.identity.filter.certificate.CertificateFilter - doFilter()
2020-10-05 13:05:48,604 [https-jsse-nio-8445-exec-10] INFO com.hp.ccue.identity.web.api.AuthenticationController - Start authentication for organization: RPA
2020-10-05 13:05:48,617 [https-jsse-nio-8445-exec-10] INFO com.hp.ccue.identity.authn.MultiTenantAuthenticationProvider - The authType is [SEEDED, DATABASE_USER, LDAP, JAAS, AD]
2020-10-05 13:05:48,857 [https-jsse-nio-8445-exec-10] INFO com.hp.ccue.identity.authn.MultiTenantAuthenticationProvider - Authentication succeeded for user admin in organization RPA

Regards,

Ashish

 

Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2020-05-15 21:03
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.