try to save a new TaskDto results in error via BH_Schedule

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

Moderators: StaffingSupport, s.emmons, BullhornSupport

Post Reply
scottcate
User
Posts: 1
Joined: Wed Sep 14, 2016 2:54 pm

try to save a new TaskDto results in error via BH_Schedule

Post by scottcate » Wed Sep 14, 2016 3:09 pm

I'm migrating data into bullhorn, and when trying to bring fwd some older tasks (todo items), I'm getting a failure.

tldr; when i try to save a new taskDto, I get the following ConstraintViolationException
Cannot insert the value NULL into column 'location', table 'BULLHORN9923.bullhorn1.BH_Schedule';
This is the soap I'm posting

Code: Select all

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <soap:Body>
    <save xmlns="http://apiservice.bullhorn.com/">
      <session xmlns="">
        <client>{removed}</client>
        <corporationId>10654</corporationId>
        <userId>2</userId>
      </session>
      <dto xmlns:q1="http://task.entity.bullhorn.com/" xsi:type="q1:taskDto" xmlns="">
        <candidateID>592</candidateID>
        <dateAdded>2013-07-05T09:17:16.567</dateAdded>
        <dateBegin>2013-07-05T00:00:00</dateBegin>
        <dateEnd>2013-07-05T00:00:00</dateEnd>
        <dateLastModified>2013-07-05T09:17:16.567</dateLastModified>
        <description>{removed - but just plain text}</description>
        <isCompleted>true</isCompleted>
        <isDeleted>false</isDeleted>
        <isPrivate>false</isPrivate>
        <notificationMinutes>0</notificationMinutes>
        <ownerID>2</ownerID>
        <subject>{removed - but just plain text}</subject>
        <type>V1_Todo</type>
      </dto>
    </save>
  </soap:Body>
</soap:Envelope>
and this is the response. truncated to show what I think is relevant.

Code: Select all

<message>Cannot insert the value NULL into column 'location', table 'BULLHORN9923.bullhorn1.BH_Schedule'; column does not allow nulls. INSERT fails.</message>
Thank you for advice!

pmularski
Bullhorn Support Staff
Posts: 906
Joined: Wed Dec 31, 1969 8:00 pm

Re: try to save a new TaskDto results in error via BH_Schedule

Post by pmularski » Tue Oct 04, 2016 10:11 am

Good Morning scottcate,

I apologize for the long silence. Are you still looking for assistance with saving a new TaskDTO?
Patrick Mularski
Senior Enterprise Support Analyst
B U L L H O R N
Staffing and Recruiting Software, On Target, On Demand
Bullhorn Support Contact Numbers
US: 617-478-9126
UK: 44 800 032 2848
Australia: 61 28 073 5089
International: 617-478-9131

Post Reply