Hi Everyone,
While testing the "IBM InfoSphere Information Server salesforce Pack" in higher environments (qa)I am getting following fatal messages.The pack is working fine in lower environment and required configuration is already in place.

****************************************************************************************
main_program: Fatal Error: Information:  error code: 8 
    error message: ; nested exception is: 
    javax.net.ssl.SSLHandshakeException: Received fatal alert: handshake_failure 
AxisFault 
 faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException 
 faultSubcode:  
 faultString: javax.net.ssl.SSLHandshakeException: Received fatal alert: handshake_failure 
 faultActor:  
 faultNode:  
 faultDetail:  
    {http://xml.apache.org/axis/}stackTrace:javax.net.ssl.SSLHandshakeException: Received fatal alert: handshake_failure 
    at com.ibm.jsse2.j.a(j.java:7) 
    at com.ibm.jsse2.j.a(j.java:27) 
    at com.ibm.jsse2.qc.b(qc.java:380) 
    at com.ibm.jsse2.qc.a(qc.java:271) 
    at com.ibm.jsse2.qc.h(qc.java:714) 
    at com.ibm.jsse2.qc.a(qc.java:467) 
    at com.ibm.jsse2.h.write(h.java:28) 
    at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:94) 
    at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:152) 
    at org.apache.commons.httpclient.ChunkedOutputStream.flush(ChunkedOutputStream.java:191) 
    at org.apache.commons.httpclient.methods.EntityEnclosingMethod.writeRequestBody(EntityEnclosingMethod.java:506) 
    at org.apache.commons.httpclient.HttpMethodBase.writeRequest(HttpMethodBase.java:2114) 
    at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1096) 
    at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398) 
    at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171) 
    at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397) 
    at org.apache.axis.transport.http.CommonsHTTPSender.invoke(CommonsHTTPSender.java:196) 
    at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) 
    at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) 
    at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) 
    at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165) 
    at org.apache.axis.client.Call.invokeEngine(Call.java:2784) 
    at org.apache.axis.client.Call.invoke(Call.java:2767) 
    at org.apache.axis.client.Call.invoke(Call.java:2443) 
    at org.apache.axis.client.Call.invoke(Call.java:2366) 
    at org.apache.axis.client.Call.invoke(Call.java:1812) 
    at com.sforce.soap.partner.SoapBindingStub.login(SoapBindingStub.java:3995) 
    at com.ibm.is.erp.salesforce.core.SalesForceConnection.login(SalesForceConnection.java:638) 
    at com.ibm.is.erp.salesforce.core.SalesForceConnection.login(SalesForceConnection.java:707) 
    at com.ibm.is.erp.salesforce.core.SalesForceConnection.login(SalesForceConnection.java:707) 
    at com.ibm.is.erp.salesforce.core.SalesForceConnection.login(SalesForceConnection.java:707) 
    at com.ibm.is.erp.salesforce.core.SalesForceConnection.<init>(SalesForceConnection.java:229) 
    at com.ibm.is.erp.salesforce.core.SalesForceConnection.creatConnection(SalesForceConnection.java:287) 
    at com.ibm.is.erp.salesforce.jcconnector.CC_SALESFORCEJCConnection.connect(CC_SALESFORCEJCConnection.java:407) 
    {http://xml.apache.org/axis/}hostname:xx-xx-xxxx
*********************************************************************************************************************
I found some posts for similar error message but their integration environment is different from IBM so checking the forum for the input.
Thanks in advance.
 

Hi Everyone,
we have a integration environment Between DataStage and Salesforce .Currently we are  using data loader script (process xml) file with the reference to mapping file for "upsert operation ".my requirement is to establish a relationship between Bond (at parent object) to a Coverages(child object ) ..There is a Bond field on child object defined as  "Lookup(Bond)"..In mapping file,for updating LOOKUP (I.e.Bond)  field on child object (i.e Coverage)..I have defined as below 

Bond__r_ExternalID__c=Bond__r\:ExternalID__c

With the above mapping "Bond"field (CHILD object field )is getting updated with ExternalID of Bond record (Parent externalID)
Example :Initially Parent Object "Bond" is created with ExternalID =1234 .After that Child object "Coverages" lookup field "Bond" is updated with value Bond_ExternalID=1234" .So this way coverages are linked to the Bond (Parent object).
For the same scenario mentioned :
We would like to use "salesforce pack for datastage " .How can I define a mapping for child object (Coverages) so that (Bond) Lookup field for upsert operation is updated with Parent Bond record (Parent externalID)?

Please let me know the resolution how can I achieve above requirement to work it properly.

Thanks,
Dev

 

Hi ,
I am using the salesforce pack for "upsert " operation into Salesforce object .Do I have to use API names or Field label for mapping in DataStage ? 

When I give the API name it is giving me error saying Field is missing and record is rejected. 

Let me know any one got this issue before .

Thanks,
Dev.


 

Hi,
I have a load file having around 800000 records trying to UPSERT  through data loader for one of object Invoice__c .Load stopped in between at the record count 600000.I want to load only remaing records but how can I identify the records loaded in the loadfile .
Does the dataloader loads the records any particular order ?Does it sorts the records based on any key ?

Please let me know if any one experienced this before.

Thanks,

Hi ,
I am using the salesforce pack for "upsert " operation into Salesforce object .Do I have to use API names or Field label for mapping in DataStage ? 

When I give the API name it is giving me error saying Field is missing and record is rejected. 

Let me know any one got this issue before .

Thanks,
Dev.


 

Hi,
I have a load file having around 800000 records trying to UPSERT  through data loader for one of object Invoice__c .Load stopped in between at the record count 600000.I want to load only remaing records but how can I identify the records loaded in the loadfile .
Does the dataloader loads the records any particular order ?Does it sorts the records based on any key ?

Please let me know if any one experienced this before.

Thanks,