API DatabaseError - custom fields sometimes being added properly, sometimes not

API Q&A
1

I’m using the XMLRPC API. Utilizing the iSDK from Infusionsoft. We are trying to add some additional custom fields to our contacts. Sometimes those details come through fine. Sometimes they do not. When they don’t, I get an error that makes no sense to me. In the example below, the contact got created, but the custom fields “_Affiliate”, “_AffiliateCode” and “_AffiliateCodeDesc” did not populate correctly. I feel like the error message might tell me what I need to fix, if only I knew what it meant.

The error is “[DatabaseError]Error adding: [DatabaseError]Error adding: null”. Full request/response below:

REQUEST and RESPONSE:

    <methodCall>
      <methodName>ContactService.add</methodName>
      <params>
        <param>
          <value><string>XX</string></value>
        </param>
        <param>
          <value>
            <struct>
              <member>
                <name>FirstName</name>
                <value><string>Lpppl7</string></value>
              </member>
              <member>
                <name>LastName</name>
                <value><string>Lpppl7</string></value>
              </member>
              <member>
                <name>Email</name>
                <value><string>lpppl7@lpppl7.com</string></value>
              </member>
              <member>
                <name>Phone1</name>
                <value><string>(888) 777-6666</string></value>
              </member>
              <member>
                <name>Phone1Type</name>
                <value><string>Work</string></value>
              </member>
              <member>
                <name>_REDXLeadId</name>
                <value><string>2956066</string></value>
              </member> 
              <member>
                <name>_signedupby1</name>
                <value><string>Online</string></value>
              </member>
              <member>
                <name>_Affiliate</name>
                <value><string>Aff_Darryl Davis Seminars</string></value>
              </member>
              <member>
                <name>_AffiliateCode</name>
                <value><int>9765</int></value>
              </member>
              <member>
                <name>_AffiliateCodeDesc</name>
                <value><string>9765: T(EFOS) - S Call In 30 Day Trial (Everything excluding ONYX)</string></value>
              </member>
            </struct>
          </value>
        </param>
      </params>
    </methodCall>


<?xml version="1.0" encoding="UTF-8"?>
    <methodResponse>
        <fault>
            <value>
                <struct>
                    <member>
                        <name>faultCode</name>
                        <value>
                            <i4>4</i4>
                        </value>
                    </member>
                    <member>
                        <name>faultString</name>
                        <value>[DatabaseError]Error adding: [DatabaseError]Error adding: null</value>
                    </member>
                </struct>
            </value>
        </fault>
    </methodResponse>
2

If you have an app name and a timeframe I might be able to check the logs.