Unable to submit candidates!

Have a question about Bullhorn's HTTP based APIs? You've found the right place.

API Update [posted on December 13, 2012]:

This version of the Bullhorn APIs should no longer be used.

All new work should be done using Bullhorn's REST or Web Services APIs. For more information please visit: http://developer.bullhorn.com/documentation

Bullhorn REST API provides a simpler and faster way for developers to build applications that interact with the Bullhorn platform and is used by Bullhorn Inc. to develop features of the Bullhorn ATS/CRM application.

Of the BullhornSTAFFING HTTP API interfaces listed below, our analysis shows that the following are most commonly used by developers:

Resume Parsing API
Published Job Data (XML)
The interface to these will continue to work as is because Bullhorn will replace the back end to use REST API. The URLs for these 2 specific APIs may change in the 2nd half of 2013; developers may require to update their applications to use the new URLs.

Moderators: StaffingSupport, s.emmons

jnovich
User
Posts: 5
Joined: Wed Dec 31, 1969 8:00 pm

Unable to submit candidates!

Post by jnovich » Fri Nov 05, 2010 10:05 am

We're getting this error this morning.
There were no changes to our code for weeks.
Would last night's rollout affect this?

<FORM ACTION="/SendErrorToSupport.cfm" method="post">
<input type="hidden" name="pageName" value="BHStaffing-HelpError">
<input type="hidden" name="hostname" value="SL4APP1">
<tr>
<td valign="top">
<div style="padding:10px;">

<br>
We're sorry, but there was an problem with your request. Please try again. If the problem continues, you can check <a target="_blank" href="http://status.bullhorn.com">http://status.bullhorn.com</a> for up to the minute system status, including notices from our support and operations team.
<br>
<br>
If you require assistance with this issue, please contact Bullhorn Support using <a href="/BullhornStaffing/ResourceCenter/Redirect.cfm?externalApplication=RightNow">The Bullhorn Resource Center</a> available under the Support menu.
<br>
<br>

</div>
</td>
</tr>
<tr class="ButtonBar">
<Td align="right">
<input type="Button" value="Try Again" class="Button" onClick="window.location.reload();">


</TD>
</tr>
<tr>
<td>
<br>
<br>

<textarea id="errorDiagnostics" cols="90" rows="40" name="errorDiagnostics" readonly wrap="soft" style="font-size:10px; border:0; display:none;">

Server: SL4APP1<br>


Datasource: BULLHORN_LG426<br>


Database: BULLHORN1812<br>

URL: /BullhornStaffing/Update/AddUserProfilesAPI.cfm?<br>
Refererring URL: <br>
<br>
Diagnostics:<br>
Invalid data for CFSQLTYPE CF_SQL_INTEGER. <br>The error occurred on line 176.<br>
<br>

<br>
Rootcause:<br>
Invalid data for CFSQLTYPE CF_SQL_INTEGER.<br>
<br>



Detail: <br>
<br>


Raw Trace:<br>

C:\jrun4\servers\Bullhorn_1\cfusion-ear\cfusion-war\BullhornSTAFFING\Update\AddUserProfilesAPI.cfm
<br>

C:\jrun4\servers\Bullhorn_1\cfusion-ear\cfusion-war\BullhornSTAFFING\Update\AddUserProfilesAPI.cfm
<br>

C:\jrun4\servers\Bullhorn_1\cfusion-ear\cfusion-war\BullhornSTAFFING\Update\AddUserProfilesAPI.cfm
<br>

<br>


</textarea>


</td>
</tr>
</FORM>

sunlightstudios
User
Posts: 69
Joined: Wed Dec 12, 2007 1:16 pm
Contact:

Re: Unable to submit candidates!

Post by sunlightstudios » Fri Nov 05, 2010 10:54 am

I also have multiple clients that are having problems with submitting candidates via the legacy api.
Jessica Hennessey
jessica@sunlightstudios-icd.com
AIM: jmh963
Skype: sunlightjess

jnovich
User
Posts: 5
Joined: Wed Dec 31, 1969 8:00 pm

Re: Unable to submit candidates!

Post by jnovich » Fri Nov 05, 2010 11:01 am

Without context, I'd surmise they've changed the datatype of a column.

sunlightstudios
User
Posts: 69
Joined: Wed Dec 12, 2007 1:16 pm
Contact:

Re: Unable to submit candidates!

Post by sunlightstudios » Fri Nov 05, 2010 11:25 am

They clearly changed something.
Jessica Hennessey
jessica@sunlightstudios-icd.com
AIM: jmh963
Skype: sunlightjess

tesdev
User
Posts: 10
Joined: Fri Jun 05, 2009 6:30 am

Re: Unable to submit candidates!

Post by tesdev » Fri Nov 05, 2010 11:33 am


gokonski
User
Posts: 78
Joined: Thu Nov 13, 2008 2:21 pm
Location: Opole, PL
Contact:

Re: Unable to submit candidates!

Post by gokonski » Fri Nov 05, 2010 11:54 am

same here, same error. started to work like this this morning. new api works fine, the problem is with old captureCandidate function. Please advice asap.

marshalldavis
User
Posts: 8
Joined: Wed Dec 31, 1969 8:00 pm

Re: Unable to submit candidates!

Post by marshalldavis » Fri Nov 05, 2010 12:20 pm

We are getting the same error,

Invalid data for CFSQLTYPE CF_SQL_INTEGER. The error occurred on line 176
Rootcause:
Invalid data for CFSQLTYPE CF_SQL_INTEGER.

from Firebug response to POST, and the following also came up, the SAME EXACT ERROR as when the API had problems last time -

Caught an exception, type = Expression
Element EMAIL is undefined in CLIENT.

Please advise.

tesdev
User
Posts: 10
Joined: Fri Jun 05, 2009 6:30 am

Re: Unable to submit candidates!

Post by tesdev » Fri Nov 05, 2010 12:38 pm

Working again here!

marshalldavis
User
Posts: 8
Joined: Wed Dec 31, 1969 8:00 pm

Re: Unable to submit candidates!

Post by marshalldavis » Fri Nov 05, 2010 12:43 pm

Well, it's a different error now, but the same error as last time the API was messed up. This is from FireBug, a response to POST to http://sl1api.bullhornstaffing.com/Bull ... lesAPI.cfm :

Caught an exception, type = Expression
Element EMAIL is undefined in CLIENT
The contents of the tag stack are
1 ??
(853,0) C:\jrun4\servers\Bullhorn_1\cfusion-ear\cfusion-war\WEB-INF\cfusion\CustomTags\BullhornPro\User\BHUpdateUserMessageImpl.cfm

rluncasu
User
Posts: 1
Joined: Fri Nov 05, 2010 12:52 pm

Re: Unable to submit candidates!

Post by rluncasu » Fri Nov 05, 2010 12:56 pm

Same problem here but I did find the change.

I am using https://cls6.bullhornstaffing.com/Bullh ... lesAPI.cfm
Apparently now the form will work only if you have previously logged into the application.Probably it is using cookies.
That's wrong! I use the form embedded.No cookies or login rights for someone using the form.

Please fix the problem.

Radu

tdonohue
User
Posts: 32
Joined: Wed Dec 31, 1969 8:00 pm

Re: Unable to submit candidates!

Post by tdonohue » Fri Nov 05, 2010 1:01 pm

I wanted to at least acknowledge this issue. Bullhorn Technical Operations team is aware of the issue and will be rolling out a fix very soon.

Please continue to use the correct URLs that you have been using and do not change them as this will introduce other issues.
Timothy Donohue
Engineering Services
B U L L H O R N

tdonohue
User
Posts: 32
Joined: Wed Dec 31, 1969 8:00 pm

Re: Unable to submit candidates!

Post by tdonohue » Fri Nov 05, 2010 1:36 pm

A production update has been deployed to address this issue. Please retest. Thanks for your patience while we worked to get this fixed.
Timothy Donohue
Engineering Services
B U L L H O R N

marshalldavis
User
Posts: 8
Joined: Wed Dec 31, 1969 8:00 pm

Re: Unable to submit candidates!

Post by marshalldavis » Fri Nov 05, 2010 1:50 pm

Still seeing the following in Firebug response to POST using http://sl1api.bullhornstaffing.com/Bull ... lesAPI.cfm :




Caught an exception, type = Expression<BR>
<BR>

Element EMAIL is undefined in CLIENT.<BR>
<BR>

The contents of the tag stack are:<BR>


<BR>1 ??
(853,0) C:\jrun4\servers\Bullhorn_1\cfusion-ear\cfusion-war\WEB-INF\cfusion\CustomTags\BullhornPro\User\BHUpdateUserMessageImpl.cfm


<BR>2 CF_BHUPDATEUSERMESSAGEIMPL
(1,0) C:\jrun4\servers\Bullhorn_1\cfusion-ear\cfusion-war\WEB-INF\cfusion\CustomTags\BullhornPro\User\BHUpdateUserMessageImpl.cfm


<BR>3 CFMODULE
(59,0) C:\jrun4\servers\Bullhorn_1\cfusion-ear\cfusion-war\WEB-INF\cfusion\CustomTags\BullhornPro\User\BHUpdateUserMessage.cfm


<BR>4 CFMODULE
(93,0) C:\jrun4\servers\Bullhorn_1\cfusion-ear\cfusion-war\WEB-INF\cfusion\CustomTags\BullhornPro\Tools\BHSendAutomatedEmailImpl.cfm

sunlightstudios
User
Posts: 69
Joined: Wed Dec 12, 2007 1:16 pm
Contact:

Re: Unable to submit candidates!

Post by sunlightstudios » Fri Nov 05, 2010 2:04 pm

still getting error
Jessica Hennessey
jessica@sunlightstudios-icd.com
AIM: jmh963
Skype: sunlightjess

EBrochu
User
Posts: 6
Joined: Wed Dec 31, 1969 8:00 pm

Re: Unable to submit candidates!

Post by EBrochu » Fri Nov 05, 2010 2:54 pm

We are also having problems with some automation we built using the following legacy API's:

JobApplications.cfm
GetProfileAPI.cfm
AddUserProfilesAPI.cfm

Not sure yet which API(s) causing our problems.

Erik Brochu
CoreMedical Group
(603)893-4515 x1515

Locked