IBM Support

JR62249: Salesforce Connector cannot extract records in Bulk Mode when the alias is 'c' in the query

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Salesforce Connector cannot extract records in Bulk Mode when
    the alias is 'c' in the query.
    
    SOQL Query to Salesforce
    :
    Select c.Id, c.ContentDocumentId, .... From ContentVersion
    c.
    
    Error :
    Message ID: IIS-CONN-SALESFORCEJC-00015
    Message:
    main_program: Fatal Error: INFO: error code: 8
    error message:
    Unable to find object: ContentVersion c
     Stack Trace:
    	com.sforc
    e.async.BulkConnection.parseAndThrowException(BulkConnection.jav
    a:182)
    	com.sforce.async.BulkConnection.createOrUpdateJob(BulkCo
    nnection.java:166)
    	com.sforce.async.BulkConnection.createOrUpda
    teJob(BulkConnection.java:134)
    	com.sforce.async.BulkConnection.
    createJob(BulkConnection.java:124)
    	com.ibm.is.erp.salesforce.co
    re.SalesForceRestConnection.createJob(SalesForceRestConnection.j
    ava:313)
    	com.ibm.is.erp.salesforce.jcconnector.CC_SALESFORCEJCC
    onnection.connect(CC_SALESFORCEJCConnection.java:560)
    

Local fix

  • change alias to another character like 'd'.
    

Problem summary

  • Salesforce Connector cannot extract records in Bulk Mode when
    the alias is 'c' in the query
    

Problem conclusion

  • Issue is fixed
    The issue is see when we have the following characters as the
    alias "c,f,k,l,m,q,v,x,z"
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR62249

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    B71

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-04-19

  • Closed date

    2020-08-06

  • Last modified date

    2020-08-06

  • 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

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

Document Information

Modified date:
12 August 2020