JR37758: QUERY IN SALESFORCE.COM PACK IS RETURNING INCORRECT NULL VALUES FOR ALL COLUMNS WHEN ONE COLUMN HAS A NULL VALUE

APAR status

• Closed as program error.

Error description

• Query using Salesforce.com Pack is returning null values for all
  columns (even though these have non null values) when one of the
  columns has a null value. Removing the null column with the null
  value shows the actual values.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Salesforce Pack 1.5
  ****************************************************************
  PROBLEM DESCRIPTION:
  In a Salesforce Query, if a field is having null values in
  Salesforce, but when unloaded from Salesforce Connector is
  making all the other selected fields as null
  ****************************************************************
  RECOMMENDATION:
  Install the patch
  ****************************************************************
  

Problem conclusion

• Handled the exception when the child element of a parent object
  has no children and added the result to the query output
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  IS PCK SALESFOR

• Fixed component ID

  5724T6800

Applicable component levels

• R100 PSY

     UP