IBM Support

JR59580: CANNOT CREATE NEW RECORD WHEN THE REFERENCE FIELD IS NULL USING SALESFORCE CONNECTOR

A fix is available

Download the mod pack for IBM InfoSphere Information Server 11.7.1.0 In-Place Upgrade

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Cannot create new record when the reference field is null using
Salesforce Connector

Local fix

  • 



Problem summary


    

  • Cannot create new record when the reference field is null using
Salesforce Connector

    



Problem conclusion


    

  • User needs to set the environment variable
"SF_CREATE_USE_DEFAULT_FOR_NULL" as "false", re-compile and
re-run the job. Working for this functionality is that when the
value of the reference field is null or empty field, then still
the record will be created. This is to overcome the default
behavior of Salesfoforce, which does not allow to create new
record when the reference field is null

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR59580
    • 

  • Reported component name
    WIS DATASTAGE
    • 

  • Reported component ID
    5724Q36DS
    • 

  • Reported release
    B50
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2018-05-22
    • 

  • Closed date
    2018-07-26
    • 

  • Last modified date
    2018-07-26
    • 





    

  • 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
    WIS DATASTAGE
    • 

  • Fixed component ID
    5724Q36DS
    • 



Applicable component levels


    

  • RB50  PSY
       UP
    • 








      
              
                            

              

              [{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            03 September 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback