Error while committing the transaction

Forum for users and developers of Bullhorn's Webservices API suite

Moderators: StaffingSupport, s.emmons, BullhornSupport

Post Reply
mguterl
User
Posts: 25
Joined: Wed Apr 11, 2012 9:52 am

Error while committing the transaction

Post by mguterl » Thu Jun 07, 2012 11:10 am

When attempting to save a candidate DTO we're getting "Error while committing the transaction"

https://raw.github.com/gist/de372d7e17d ... tfile1.txt

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

Re: Error while committing the transaction

Post by jroorda » Fri Jun 08, 2012 2:54 pm

Hi mguterl,
This is Justin with Bullhorn Support.
We were unable to identify all of the issues with your DTO.
The candidate DTO is sensitive in that you have to resave all of the fields even if you only make one edit.
There are also required fields that have to have information in them we refer to these fields as Not-Nullable. All of the Not-Nullable fields must have valid information in them.
For a list of most of the fields you can see this page:

http://developer.bullhorn.com/doc/versi ... didate.htm
Also but not included in the documentation are:
<userTypeID>129</userTypeID>
<password>value</password>
<username>value</username>
Furthermore for the description field you must specify the html with a header for proper formatting.
<description><![CDATA[<DIV>…html… </DIV>]]></description> Below is an example of a properly formated DTO:

Code: Select all

<dto xsi:type="ns4:candidateDto" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns4="http://candidate.entity.bullhorn.com/">

               <address>
                  <address1/>
                  <address2/>
                  <city/>
                  <countryID></countryID>
                  <state/>
                  <zip/>
               </address>
               <customFloat1>0.0</customFloat1>
               <customFloat2>0.0</customFloat2>
               <customFloat3>0.0</customFloat3>
               <customInt1>0</customInt1>
               <customInt2>0</customInt2>
               <customInt3>0</customInt3>
               <customText1/>
               <customText10>1</customText10>
               <customText11/>
               <customText12>U</customText12>
               <customText13/>
               <customText14/>
               <customText15/>
               <customText16/>
               <customText17/>
               <customText18/>
               <customText19/>
               <customText2>Kangaroo</customText2>
               <customText20/>
               <customText3>French</customText3>
               <customText4/>
               <customText5/>
               <customText6/>
               <customText7/>
               <customText8/>
               <customText9/>
               <dateLastComment>2012-04-13T11:49:40.310-04:00</dateLastComment>
               <email>hello@world.com</email>
               <email2/>
               <email3/>
               <fax/>
               <fax2/>
               <fax3/>
               <firstName>Hot</firstName>
               <isDayLightSavings>true</isDayLightSavings>
               <isDeleted>false</isDeleted>
               <isLockedOut>false</isLockedOut>
               <lastName>Fire</lastName>
               <massMailOptOut>false</massMailOptOut>
               <middleName/>
               <mobile/>
               <name>Hot Fire</name>
               <namePrefix/>
               <nameSuffix/>
               <nickName/>
               <occupation/>
               <pager/>
               <phone/>
               <phone2/>
               <phone3/>
               <smsOptIn>false</smsOptIn>
               <timeZoneOffsetEST>0</timeZoneOffsetEST>
               <userID>5129055</userID>
               <userTypeID>129</userTypeID>
               <username>hotfire_664950</username>
               <categoryID>45</categoryID>
               <certifications/>
               <comments>Test One Note Each Candidate</comments>
               <companyName/>
               <companyURL/>
               <customTextBlock1>test</customTextBlock1>
               <customTextBlock2/>
               <customTextBlock3/>
               <customTextBlock4/>
               <customTextBlock5/>
               <dateAdded>2012-04-02T14:29:17.370-04:00</dateAdded>
               <dayRate>0.0000</dayRate>
               <dayRateLow>0.0000</dayRateLow>
               <degreeList/>
               <description/>
               <desiredLocations/>
               <disability></disability>
               <educationDegree>Not Specified</educationDegree>
               <employeeType/>
               <employmentPreference/>
               <ethnicity>Unknown</ethnicity>
               <experience>0</experience>
               <externalID/>
               <gender>_</gender>
               <hourlyRate>0.0000</hourlyRate>
               <hourlyRateLow>0.0000</hourlyRateLow>
               <isEditable>true</isEditable>
               <numCategories>1</numCategories>
               <numOwners>1</numOwners>
               <ownerCorporationID>44</ownerCorporationID>
               <ownerID>5119858</ownerID>
               <password>345detroit</password>
               <preferredContact/>
               <recentClientList/>
               <referredBy/>
               <salary>0.0000</salary>
               <salaryLow>0.0000</salaryLow>
               <secondaryAddress>
                  <address1/>
                  <address2/>
                  <city/>
                  <countryID>1</countryID>
                  <state/>
                  <zip/>
               </secondaryAddress>
               <skillSet/>
               <source>Referral</source>
               <ssn/>
               <status>New Lead</status>
               <taxID/>
               <travelLimit>0</travelLimit>
               <type/>
               <veteran>U</veteran>
               <willRelocate>false</willRelocate>
               <workAuthorized>false</workAuthorized>
               <workPhone/>
            </dto>

Post Reply