Oauth Refresh token Errors - 02552990

Forum for users and developers of Bullhorn's new REST API service.

Moderators: StaffingSupport, s.emmons, BullhornSupport

lroetto
User
Posts: 2
Joined: Thu Aug 03, 2017 6:01 pm

Oauth Refresh token Errors - 02552990

Postby lroetto » Thu Aug 03, 2017 6:22 pm

I have a couple of customers that are seeing an oauth refresh token error when executing workflows. This is the error they are receiving:

Code: Select all

```<html><head><title>Apache Tomcat/7.0.27 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 500 - </h1><HR size="1" noshade="noshade"><p><b>type</b> Exception report</p><p><b>message</b> <u></u></p><p><b>description</b> <u>The server encountered an internal error () that prevented it from fulfilling this request.</u></p><p><b>exception</b> <pre>org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: I/O Error: Connection reset
    org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
    org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:577)
    org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
    org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
    org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
    org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:721)
    org.springframework.jdbc.core.JdbcTemplate.queryForMap(JdbcTemplate.java:740)
    org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForMap(SimpleJdbcTemplate.java:205)
    com.bullhorn.rest.session.SessionManager.login(SessionManager.java:495)
    com.bullhorn.rest.session.SessionManager.login(SessionManager.java:456)
    com.bullhorn.rest.session.SessionManager.login(SessionManager.java:433)
    com.bullhorn.rest.handler.security.SecurityHandler.oauthLogin(SecurityHandler.java:442)
    com.bullhorn.rest.handler.security.SecurityHandler.login(SecurityHandler.java:366)
    com.bullhorn.rest.servlet.RestDispatcher.doDispatch(RestDispatcher.java:201)
    com.bullhorn.rest.servlet.RestDispatcher.dispatch(RestDispatcher.java:140)
    com.bullhorn.rest.servlet.RestServlet.service(RestServlet.java:35)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
</pre></p><p><b>root cause</b> <pre>java.sql.SQLException: I/O Error: Connection reset
    net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1053)
    net.sourceforge.jtds.jdbc.TdsCore.submitSQL(TdsCore.java:899)
    net.sourceforge.jtds.jdbc.ConnectionJDBC2.setCatalog(ConnectionJDBC2.java:2282)
    org.apache.commons.dbcp.DelegatingConnection.setCatalog(DelegatingConnection.java:374)
    org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setCatalog(PoolingDataSource.java:333)
    com.bullhorn.common.db.BhDataSourceImpl.fixCatalog(BhDataSourceImpl.java:83)
    com.bullhorn.common.db.BhDataSourceImpl.getConnection(BhDataSourceImpl.java:102)
    org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
    org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
    org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:577)
    org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
    org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
    org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
    org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:721)
    org.springframework.jdbc.core.JdbcTemplate.queryForMap(JdbcTemplate.java:740)
    org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForMap(SimpleJdbcTemplate.java:205)
    com.bullhorn.rest.session.SessionManager.login(SessionManager.java:495)
    com.bullhorn.rest.session.SessionManager.login(SessionManager.java:456)
    com.bullhorn.rest.session.SessionManager.login(SessionManager.java:433)
    com.bullhorn.rest.handler.security.SecurityHandler.oauthLogin(SecurityHandler.java:442)
    com.bullhorn.rest.handler.security.SecurityHandler.login(SecurityHandler.java:366)
    com.bullhorn.rest.servlet.RestDispatcher.doDispatch(RestDispatcher.java:201)
    com.bullhorn.rest.servlet.RestDispatcher.dispatch(RestDispatcher.java:140)
    com.bullhorn.rest.servlet.RestServlet.service(RestServlet.java:35)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
</pre></p><p><b>root cause</b> <pre>java.net.SocketException: Connection reset
    java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)
    java.net.SocketOutputStream.write(SocketOutputStream.java:136)
    java.io.DataOutputStream.write(DataOutputStream.java:90)
    net.sourceforge.jtds.jdbc.SharedSocket.sendNetPacket(SharedSocket.java:676)
    net.sourceforge.jtds.jdbc.RequestStream.putPacket(RequestStream.java:560)
    net.sourceforge.jtds.jdbc.RequestStream.flush(RequestStream.java:508)
    net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1040)
    net.sourceforge.jtds.jdbc.TdsCore.submitSQL(TdsCore.java:899)
    net.sourceforge.jtds.jdbc.ConnectionJDBC2.setCatalog(ConnectionJDBC2.java:2282)
    org.apache.commons.dbcp.DelegatingConnection.setCatalog(DelegatingConnection.java:374)
    org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setCatalog(PoolingDataSource.java:333)
    com.bullhorn.common.db.BhDataSourceImpl.fixCatalog(BhDataSourceImpl.java:83)
    com.bullhorn.common.db.BhDataSourceImpl.getConnection(BhDataSourceImpl.java:102)
    org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
    org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
    org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:577)
    org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
    org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
    org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
    org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:721)
    org.springframework.jdbc.core.JdbcTemplate.queryForMap(JdbcTemplate.java:740)
    org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForMap(SimpleJdbcTemplate.java:205)
    com.bullhorn.rest.session.SessionManager.login(SessionManager.java:495)
    com.bullhorn.rest.session.SessionManager.login(SessionManager.java:456)
    com.bullhorn.rest.session.SessionManager.login(SessionManager.java:433)
    com.bullhorn.rest.handler.security.SecurityHandler.oauthLogin(SecurityHandler.java:442)
    com.bullhorn.rest.handler.security.SecurityHandler.login(SecurityHandler.java:366)
    com.bullhorn.rest.servlet.RestDispatcher.doDispatch(RestDispatcher.java:201)
    com.bullhorn.rest.servlet.RestDispatcher.dispatch(RestDispatcher.java:140)
    com.bullhorn.rest.servlet.RestServlet.service(RestServlet.java:35)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
</pre></p><p><b>note</b> <u>The full stack trace of the root cause is available in the Apache Tomcat/7.0.27 logs.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.27</h3></body></html>```


Has anyone seen that error code before? Any guidance is appreciated!

dfilla
User
Posts: 13
Joined: Mon May 16, 2016 2:01 pm

Re: Oauth Refresh token Errors - 02552990

Postby dfilla » Thu Aug 10, 2017 12:16 pm

Hi,

This is David with Bullhorn Support. This error can occur if in a couple different scenarios. In order to troubleshoot this, I would need the exact API call they are making when receiving this error, and information on the clients database to be able to perform some tests from my end. I have a ticket created for this on our end, and if you would be more comfortable discussing this via email, if you can provide me with your email address, I can gladly reach out and gather some information so I can run some tests on this.

Thanks!

lroetto
User
Posts: 2
Joined: Thu Aug 03, 2017 6:01 pm

Re: Oauth Refresh token Errors - 02552990

Postby lroetto » Thu Aug 10, 2017 3:14 pm

Thanks a lot for the response. My email is lewis@cloud-elements.com


Return to “REST API”

Who is online

Users browsing this forum: No registered users and 3 guests