Web Service Import Sets fail with the response "soap fault: java.lang.NullPointerException"

Problem

---

If the display value of a table returns an empty value, Web Service Import Sets returns soap fault: java.lang.NullPointerException.

Note: The record import happens correctly. Only the response has a display problem.

 

Symptoms

---

Web Service Import Sets returns soap fault: java.lang.NullPointerException on the response. Notice that reference fields to the target table show "(empty)" or nothing for those records

Cause

---

Most tables have an attribute set with the Display property set to true. If a new record is created or updated and the column with the Display value is set to an empty value, the result is identified by the Display value "(empty)".

As for Web Service Import Set, the results are identified by the Display value; empty results could cause the NullPointerException error.

NOTE: Display values could be caused by newly added attributes that set Display to true accidentally.

Resolution

---

On the target table, set the Display attribute on a non-empty column (for example, Number) to true.

For more information, see the product documentation on Web service import sets.