Outstanding Contributor.. JimiT Outstanding Contributor..
Outstanding Contributor..
127 views

RPA Designer error 500 request_token filenotfound

Hi All,

I've installed RPA 2019.07 following the install guide, (btw the guide seems to have many mistakes) and have problems while trying to access RPA Workflow designer. I get Internal Server error 500 when I try.

https://localhost:8449/oo-designer/

I have installed all the software on the same server for testing POC purposes.

The log file shows the following exception occurs when I attempt to access, I suspect this might be due to one of the steps I hadn't saved the token to a file, I skipped this step, not sure if it was required.  If by missing the save to file option is the cause, how can I generate a new token and save it to the file for Workflow Designer to work?

2019-07-29 09:25:20,180 [https-jsse-nio-8449-exec-8] (IdMAuthenticationEntryPoint.java:130) ERROR - Exception getting request token from <a href="https://rpa.jst.local:8449/idm-service/idm/v0/api/token/request_token" target="_blank">https://rpa.jst.local:8449/idm-service/idm/v0/api/token/request_token</a>
com.hp.ccue.identity.rp.CCUERPConnectionException: java.io.FileNotFoundException: <a href="https://rpa.jst.local:8449/idm-service/idm/v0/api/token/request_token" target="_blank">https://rpa.jst.local:8449/idm-service/idm/v0/api/token/request_token</a>
	at com.hpe.webstudio.idm.OoRpHttpConnectionImpl.getResponse(OoRpHttpConnectionImpl.java:170)
	at com.hpe.webstudio.idm.OoRpHttpConnectionImpl.getRequestToken(OoRpHttpConnectionImpl.java:44)
	at com.hp.ccue.identity.rp.spring.IdMAuthenticationEntryPoint.commence(IdMAuthenticationEntryPoint.java:127)
	at org.springframework.security.web.access.ExceptionTranslationFilter.sendStartAuthentication(ExceptionTranslationFilter.java:203)
	at org.springframework.security.web.access.ExceptionTranslationFilter.handleSpringSecurityException(ExceptionTranslationFilter.java:177)
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:133)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.authentication.<a href="http://www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158" target="_blank">www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158</a>)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:100)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at com.hpe.webstudio.security.RefererHeaderFilter.doFilterInternal(RefererHeaderFilter.java:61)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263)
	at sun.reflect.GeneratedMethodAccessor478.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:282)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:279)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAsPrivileged(Subject.java:549)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:314)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:253)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191)
	at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:47)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:149)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:145)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at sun.reflect.GeneratedMethodAccessor478.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:282)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:279)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAsPrivileged(Subject.java:549)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:314)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:253)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191)
	at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:47)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:149)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:145)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at com.hpe.webstudio.security.CacheControlFilter.doFilterInternal(CacheControlFilter.java:19)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at sun.reflect.GeneratedMethodAccessor478.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:282)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:279)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAsPrivileged(Subject.java:549)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:314)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:253)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191)
	at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:47)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:149)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:145)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.io.FileNotFoundException: <a href="https://rpa.jst.local:8449/idm-service/idm/v0/api/token/request_token" target="_blank">https://rpa.jst.local:8449/idm-service/idm/v0/api/token/request_token</a>
	at sun.reflect.GeneratedConstructorAccessor243.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at sun.net.<a href="http://www.protocol.http.HttpURLConnection$10.run(HttpURLConnection.java:1944" target="_blank">www.protocol.http.HttpURLConnection$10.run(HttpURLConnection.java:1944</a>)
	at sun.net.<a href="http://www.protocol.http.HttpURLConnection$10.run(HttpURLConnection.java:1939" target="_blank">www.protocol.http.HttpURLConnection$10.run(HttpURLConnection.java:1939</a>)
	at java.security.AccessController.doPrivileged(Native Method)
	at sun.net.<a href="http://www.protocol.http.HttpURLConnection.getChainedException(HttpURLConnection.java:1938" target="_blank">www.protocol.http.HttpURLConnection.getChainedException(HttpURLConnection.java:1938</a>)
	at sun.net.<a href="http://www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1508" target="_blank">www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1508</a>)
	at sun.net.<a href="http://www.protocol.http.HttpURLConnection.access$200(HttpURLConnection.java:91" target="_blank">www.protocol.http.HttpURLConnection.access$200(HttpURLConnection.java:91</a>)
	at sun.net.<a href="http://www.protocol.http.HttpURLConnection$9.run(HttpURLConnection.java:1484" target="_blank">www.protocol.http.HttpURLConnection$9.run(HttpURLConnection.java:1484</a>)
	at sun.net.<a href="http://www.protocol.http.HttpURLConnection$9.run(HttpURLConnection.java:1482" target="_blank">www.protocol.http.HttpURLConnection$9.run(HttpURLConnection.java:1482</a>)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessController.doPrivilegedWithCombiner(AccessController.java:782)
	at sun.net.<a href="http://www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1481" target="_blank">www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1481</a>)
	at sun.net.<a href="http://www.protocol.https.HttpsURLConnectionImpl.getInputStream(HttpsURLConnectionImpl.java:263" target="_blank">www.protocol.https.HttpsURLConnectionImpl.getInputStream(HttpsURLConnectionImpl.java:263</a>)
	at com.hpe.webstudio.idm.OoRpHttpConnectionImpl.getResponse(OoRpHttpConnectionImpl.java:159)
	... 107 more
Caused by: java.io.FileNotFoundException: <a href="https://rpa.jst.local:8449/idm-service/idm/v0/api/token/request_token" target="_blank">https://rpa.jst.local:8449/idm-service/idm/v0/api/token/request_token</a>
	at sun.net.<a href="http://www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1890" target="_blank">www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1890</a>)
	at sun.net.<a href="http://www.protocol.http.HttpURLConnection.access$200(HttpURLConnection.java:91" target="_blank">www.protocol.http.HttpURLConnection.access$200(HttpURLConnection.java:91</a>)
	at sun.net.<a href="http://www.protocol.http.HttpURLConnection$9.run(HttpURLConnection.java:1484" target="_blank">www.protocol.http.HttpURLConnection$9.run(HttpURLConnection.java:1484</a>)
	at sun.net.<a href="http://www.protocol.http.HttpURLConnection$9.run(HttpURLConnection.java:1482" target="_blank">www.protocol.http.HttpURLConnection$9.run(HttpURLConnection.java:1482</a>)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessController.doPrivilegedWithCombiner(AccessController.java:782)
	at sun.net.<a href="http://www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1481" target="_blank">www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1481</a>)
	at java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
	at sun.net.<a href="http://www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:347" target="_blank">www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:347</a>)
	at com.hpe.webstudio.idm.OoRpHttpConnectionImpl.getResponse(OoRpHttpConnectionImpl.java:135)
	... 107 more

 

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution. Don't forget to Kudo!!
0 Likes
6 Replies
HristoKacarov
Visitor.

Re: RPA Designer error 500 request_token filenotfound

Hi, did you find a solution for this issue as i am having the exact same problem? thanks!

0 Likes
Outstanding Contributor.. JimiT Outstanding Contributor..
Outstanding Contributor..

Re: RPA Designer error 500 request_token filenotfound

Hi Hristo,

I uninstalled and then re-installed. This time I chose to have the setup create the database instead of having to run the sql files from the docs\scripts\sql.

 

The install guide really is poor - come on MF fix the documentation, not only for RPA, but for OpsBridge, COSO, for NOM, for NA. Your documentation is all over the place, not good enough for any premium product!

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution. Don't forget to Kudo!!
0 Likes
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

Re: RPA Designer error 500 request_token filenotfound

Hello @JimiT , please share the entire log (wrapper.log and general.log) for the failed Designer installation.

Please note that the recommended way is always using the provided installer procedure (instead of manually running the sql scripts). 

Additionally, you mentioned that the "Install guide" containes mistakes, could you please share more info on the matter so we could address them asap.

You can contact me directly as well to better understand the issue.

 

Regards,

Adi Dinita

0 Likes
Outstanding Contributor.. JimiT Outstanding Contributor..
Outstanding Contributor..

Re: RPA Designer error 500 request_token filenotfound

Hi Adi,
the sql scripts should be setup properly then, why even bother with manual setup if they don't work - really big waste of time trying to setup manually.

I have also been sending feedback on all mistakes that I come across, sometimes they get noticed and other times they seem to just be ignored. I really would like to see Micro Focus products excel in the market place. The documentation is just too confusing, or there is a high expectation of knowledge and some are out of order or in some other place not even part of the install guide but part of the admin guide. It need a lot more care because on this end it's hell lot frustrating.


Jim
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution. Don't forget to Kudo!!
0 Likes
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

Re: RPA Designer error 500 request_token filenotfound

Hi Jim, really appreciate your feedback, I assure you we'll do anything possible to alleviate these issues On the sql scripts, please shed more light on the scenario where it doesn't work so we can properly track it and address it asap.

On the documentation, iI would really appreciate it if you shoot me an email with the exact areas which are confusing and the mistakes that you've noticed (adrian.dinita@microfocus.com)

Regards,
Adi

0 Likes
Micro Focus Contributor
Micro Focus Contributor

Re: RPA Designer error 500 request_token filenotfound

Based on my latest installation on postgres, there are two options:

1. Installers will do the Database and Users Creation. Except for IDM, which has to be created manually (right click create DB and assign a owner)

2. Create manually the database (right click create), create users in DB (or use the same admin user), assign owner to database. At least in Postgres, I don't have to use any sql scripts in the folder

Note that Hostname FQDN (.net or .com) and DNS resolution is a must requirement. localhost will not work, you might be able to workaround with hosts file.

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