Candidates unable to be entered through our website

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

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

Candidates unable to be entered through our website

Post by JCiferri » Wed Feb 16, 2011 5:04 pm

Can someone give me direction and assistance with the following issue:

Just recently there seems to a problem with the way our API is setup to submit the Candidate resume into Bullhorn. BH Support recommended posting a question on the Support Forum for the Legacy APIs. They said the BH engineers monitor this forum and will be the best resource to help resolve this problem. They said our web developer may need to make some changes in the way it is submitting information into Bullhorn. (We no longer have such a person).

In my post,I have included the page of the API we are using to perform the upload of the file. I have also included the error message which is occurring when submitting the resume, below:

Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = S0002 (Base table not found)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'CGLOBAL'.
Date/Time: 02/11/11 11:50:02
Browser: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET4.0C; .NET4.0E)
Remote Address: 172.16.0.37

HTTP Referrer: http://www.davidwoodpersonnel.com/find_ ... s_123.html
Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator).

Thank you in advance for your assistance.

apsmith
Site Admin
Posts: 2051
Joined: Wed Dec 31, 1969 8:00 pm

Re: Candidates unable to be entered through our website

Post by apsmith » Thu Feb 17, 2011 9:54 am

JCiferri,

Can you confirm what URLs you are calling that throw this error? The full domain and path please.
Andrew Smith
Director, Technical Operations
Developer Forum Admin

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

Re: Candidates unable to be entered through our website

Post by JCiferri » Thu Feb 17, 2011 5:52 pm

Some Additional Information: Please note the URL (address) of the error-This appears to be a bullhorn error? See message below and attached


Date/Time: 02/16/11 20:35:00
Remote Address: 172.16.0.37
Browser: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; MDDC; .NET4.0C; InfoPath.2)
Template: C:\INETPUB\WWWROOT\BULLHORNSTAFFING\UPDATE\ADDUSERPROFILESAPI.CFM
Query String:
HTTP Referer: http://davidwoodpersonnel.com/find_job/easy_as_123.html
Server: WEBSERVER2
Datasource: BULLHORN_LG129
Database: BULLHORN93
Diagnostics:
ODBC Error Code = IM002 (Data source not found and no default driver specified)<P> [Microsoft][ODBC Driver Manager] Data source 'BULLHORN_LG129' not found and no default driver specified<P><B>Hint</B>: In order to use ODBC data sources with Cold Fusion you must create the data source using the Data Sources page of the Cold Fusion Administrator. In addition, if you are running under Windows NT you must make sure that the Data Source is created as a System DSN in order for it to be available to ColdFusion.<P><P>SQL = "SELECT b.userID defaultRecruiterUserID,
a.name name,
a.title title
FROM BH_PrivateLabel a
INNER JOIN BH_User b
ON a.defaultRecruiterUserID = b.masteruserID
WHERE a.privateLabelID = _CF_:?_"<P>
Query Parameter Value(s) - <P>Parameter #1 = 216
<P>Data Source = "BULLHORN_LG129"<P><p>The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (102:5) to (102:121) in the template file C:\INETPUB\WWWROOT\BULLHORNSTAFFING\UPDATE\ADDUSERPROFILESAPI.CFM.</p>





Here is a key piece of code from our website that may assist BH in determining theissue. Its the lead in to the FORM code that the DWPClient fills out to enter themselves into the database.

<FORM NAME="EditCandidateProfileForm" ACTION="https://www.bullhorn.com/BullhornStaffi ... lesAPI.cfm" METHOD=POST onSubmit="return _CF_checkEditCandidateProfileForm(this)" ENCTYPE="multipart/form-data">

<input type="Hidden" name="privateLabelID" value="216" />

<input type="Hidden" name="returnToURL" value="http://www.davidwoodpersonnel.com/find_ ... s_123.html" />

<input type="Hidden" name="parameterPrefix" value="" />

<input type="hidden" name="notify" value="joanciferri@davidwoodpersonnel.com" />

Look forward to your reply/help
Attachments
error_msg_from_BH.jpg
error_msg_from_BH.jpg (121.25 KiB) Viewed 13152 times

apsmith
Site Admin
Posts: 2051
Joined: Wed Dec 31, 1969 8:00 pm

Re: Candidates unable to be entered through our website

Post by apsmith » Fri Feb 18, 2011 10:41 am

JCiferri,

This is happening because you are using an older URL.

You are using https://www.bullhorn.com/BullhornStaffing/...., please change this to https://www.bullhornstaffing.com/BullhornStaffing/...
Andrew Smith
Director, Technical Operations
Developer Forum Admin

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

Re: Candidates unable to be entered through our website

Post by JCiferri » Fri Feb 18, 2011 10:53 am

And this would have changed in the last few weeks?

I am not sure I know where/how I need to change this. Will investigate.

apsmith
Site Admin
Posts: 2051
Joined: Wed Dec 31, 1969 8:00 pm

Re: Candidates unable to be entered through our website

Post by apsmith » Fri Feb 18, 2011 10:56 am

JCiferri,

We posted that all API users should change their URLs quite a while ago. (Tue Feb 10, 2009)

Recent changes may have caused these URLs to finally begin to fail.
Andrew Smith
Director, Technical Operations
Developer Forum Admin

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

Re: Candidates unable to be entered through our website

Post by JCiferri » Fri Feb 18, 2011 3:01 pm

Yeah! That did the trick.

Thanks!

Locked