Integration

Get Involved. Join the Conversation.

Posts

  • 1-6 of 6
  • Robert Cruickshank
    OICS Salesforce Adapter Core Upsert Operation limitation of...2
    Topic posted July 27, 2019 by Robert CruickshankGreen Ribbon: 100+ Points, tagged Adapters, Integration, Mapping, Salesforce 
    Title:
    OICS Salesforce Adapter Core Upsert Operation limitation of max 200 records
    Summary:
    When using CORE Upsert operation in Salesforce Adapter there is a 200 record limitation
    Content:

    So when passing records to a CORE - Upsert operation via the Salesforce adapter, if more than 200 records are passed in one go salesforce will return upsert error :

    EXCEEDED_ID_LIMIT: record limit reached. cannot submit more than 200 records into this call

    I realise this is an UPSERT limitation on the Salesforce side, and I can most likely cater for it, but splitting into batches smaller than 200 with the integration. Would do a for-each loop with an XSL to do this.

    But is there anything out of box with the adapter in OICS that could handle this batching for me?

    PS. I also know I could update the integrations to use the Bulk APIs, but I would rather not do that, since payloads of 200 records or more will be rare, but nevertheless need to be handled.

    Many Thanks


    Rob

    Version:
    Version: 19.3.1.0.0 (190624.1100.29532)
  • Mike Harrison
    Salesforce Integration FinalBatch errorAnswered5
    Topic posted July 24, 2019 by Mike HarrisonRed Ribbon: 250+ Points, tagged API, Integration, Salesforce 
    Title:
    Salesforce Integration FinalBatch error
    Summary:
    Bulk Data load to Salesforce fails
    Content:

    Hi,

    I am trying to upload a CSV file to Salesforce through the Salesforce Adapter and the Bulk Data upsert operation. The upsert seems to work fine and generates the proper XML to send to salesforce, but when it reaches my FinalBatch operation, it fails with "invalid JobID" coming back from Salesforce.

    I am using a similar flow to what is shown in the Oracle documentation here:

    ttps://docs.oracle.com/en/cloud/paas/integration-cloud/sforce-adapter/handle-huge-data-sets-asynchronously-different-bulk-operations.html

    Attached is a picture of my integration flow. It fails at FinalBatch. The "mapping to FinalBatch" is not doing anything because there is nothing I can use from the upsert to send a jobID to the final batch operation. 

    Am I missing something? Do I need to create a Job ID first somehow? 

    This is the last part of the diagnostic log:

    ]]
    [2019-07-24T19:34:37.570+00:00] [oicyyz3I_server_2] [ERROR] [] [oracle.soa.adapter] [tid: [ACTIVE].ExecuteThread: '67' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xxxx] [ecid: 9287e245-2972-42c6-8df1-72487b165c7e-00196901,1:20730:3] [partition-name: DOMAIN] [tenant-name: GLOBAL] [oracle.soa.tracking.FlowId: 60] [oracle.soa.tracking.InstanceId: 3532] [oracle.soa.tracking.SCAEntityId: 434] [composite_name: SITE_ID_CATALOGUE!01.00.0000] [FlowId: 0000Mk_UItgEwG55zRs1yW1TA0NF0000pc] JCABinding <outbound> Integration Payload : [[
     <finalBatch xmlns="http://xmlns.oracle.com/cloud/adapter/salesforce/FinalBatch_REQUEST"/>

    ]]
    [2019-07-24T19:34:37.572+00:00] [oicyyz3I_server_2] [ERROR] [OSB-381990] [oracle.osb.transports.jca.jcatransport] [tid: [ACTIVE].ExecuteThread: '67' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xxxx] [ecid: 9287e245-2972-42c6-8df1-72487b165c7e-00196901,1:20730:3] [partition-name: DOMAIN] [tenant-name: GLOBAL] [oracle.soa.tracking.FlowId: 60] [oracle.soa.tracking.InstanceId: 3532] [oracle.soa.tracking.SCAEntityId: 434] [composite_name: SITE_ID_CATALOGUE!01.00.0000] [FlowId: 0000Mk_UItgEwG55zRs1yW1TA0NF0000pc] Invoke JCA outbound service failed with application error, exception: <genericRestFault><errorCode>400</errorCode><errorPath><![CDATA[POST https://xxxx.***.xx.my.salesforce.com/services/async/46.0/job/7503D0000039sPFQAY/batch returned a response status of 400 Bad Request]]></errorPath><instance><![CDATA[<?xml version="1.0" encoding="UTF-8"?><error[[
       xmlns="http://www.force.com/2009/06/asyncapi/dataload">
     <exceptionCode>InvalidJob</exceptionCode>
     <exceptionMessage>Invalid job id: 7503D0000039sPFQAY</exceptionMessage>
    </error>]]></instance></genericRestFault>
    ]]
    [2019-07-24T19:34:39.043+00:00] [oicyyz3I_server_2] [ERROR] [ESS-07004] [oracle.as.ess] [tid: ESS Execute Thread [RequestId:3581]] [userId: <WLS Kernel>] [ecid: 9287e245-2972-42c6-8df1-72487b165c7e-00196901,0:140:1:100009653] [APP: ESSAPP] [partition-name: DOMAIN] [tenant-name: GLOBAL] [ESS_JobMetadataID: JobDefinition://oracle/apps/ess/seeded/ics/IcsFlowJob] [ESS_RequestID: 3581] [FlowId: 0000Mk_UItgEwG55zRs1yW1TA0NF0000pc] [ESS_Module: Processor] Execution error for request 3581. Reason: ESS-07033 Job logic indicated a system error occurred while executing an asynchronous java job for request 3581. Job error is: com.oracle.bpel.client.BPELFault: faultName: {{http://schemas.oracle.com/bpel/extension}remoteFault}[[
    messageType: {{http://schemas.oracle.com/bpel/extension}RuntimeFaultMessage}
    parts: {{
    CODE=<code>{http://schemas.oracle.com/bpel/extension}remoteFault</code>
    ,SUMMARY=<summary>ICS runtime execution error</summary>
    ,DETAIL=<DETAIL><detail><ICSfaultVar/><reason>Error sending bytes: Sending salesforce batch file failed with an error.
    :Application Error</reason><operation>finalBatch</operation></detail></DETAIL>}
    cause: {null}
    .
    ]]

    Image:
  • Kumar Sundarraj
    Error While Creating Connection in OICS3
    Topic posted July 2, 2019 by Kumar Sundarraj, tagged Connection, ERP Cloud, Integration, Salesforce 
    Title:
    Error While Creating Connection in OICS
    Summary:
    CASDK error while creating a connection and testing it
    Content:

    I am trying to create a sample Soap connection with no security option using a public provided end Point

    I am getting an error unable to create connection with Cause as CASDK errors.

    Any idea?

    Service Type: Oracle Integration Classic

    Bring Your Own License (BYOL): false
     
    Version:
    19.3.1.0.0
  • Kannan Ranganathan
    Getting Response error while integrating Salesforce and...4
    Topic posted February 22, 2019 by Kannan RanganathanGreen Ribbon: 100+ Points, tagged Cloud, Integration, Mapping, PaaS, Sales Cloud, Salesforce 
    Title:
    Getting Response error while integrating Salesforce and Engagement cloud
    Summary:
    Response mapping error between Salesforce and Engagement cloud account sync
    Content:

    Dear folks,

      I am integrating Salesforce and Engagement cloud Account entity using Oracle Integration cloud, request mapping happened successful, response mapping failing with below error message, will someone pls. let me know how to fix it.

    Client received SOAP Fault from server : Unable to find a deserializer for the type common.api.soap.wsdl.QueryResult Error Id: 1285309289-28170 (-1896990142)Cause : Problem could be in the request mapping. Solution : All mapped elements should belong to the parent object.

    Thanks & Regards,

    Kannan Ranganathan

    Image:
  • Kannan Ranganathan
    Getting Response error while integrating Salesforce and...4
    Topic posted February 19, 2019 by Kannan RanganathanGreen Ribbon: 100+ Points, tagged Integration, Mapping, PaaS, Salesforce 
    Title:
    Getting Response error while integrating Salesforce and Engagement cloud
    Summary:
    Response mapping error between Salesforce and Engagement cloud account sync
    Content:

    Dear folks,

      I am integrating Salesforce and Engagement cloud Account entity, request mapping happened successful, response mapping failing with below error message, will someone pls. let me know how to fix it.

    Client received SOAP Fault from server : Unable to find a deserializer for the type common.api.soap.wsdl.QueryResult Error Id: 1285309289-28170 (-1896990142)Cause : Problem could be in the request mapping. Solution : All mapped elements should belong to the parent object.

    Thanks & Regards,

    Kannan Ranganathan

     

     

     

  • Moon Ray Lo
    OIC Exception/Error Handling & Recoverable InstanceAnswered65.0
    Topic posted February 5, 2019 by Moon Ray LoSilver Medal: 2,000+ Points, tagged Adapters, Agent, API, Case Management, Cloud, Connection, Database, E-Business Suite, Eloqua, ERP Cloud, Events, Integration, Mapping, NetSuite, Orchestration, PaaS, Primavera, Process, REST, RightNow, Sales Cloud, Salesforce, SAP, Siebel, SOACS, SOAP, Taleo, Tip, Web Services, Workday 
    Title:
    OIC Exception/Error Handling & Recoverable Instance
    Summary:
    Oracle Integration Cloud's Exception/Error Handling & Recoverable Instance
    Content:

    Hi Team,

     

    I have noticed that NOT ALL instances that faulted can be recovered or resubmitted for reprocessing - based from y experience, I have resubmitted/recovered some (scheduled integration) and unable for others (app-driven integration)

     

    I'd like to know as to which specific conditions would an instance considered as recoverable when fault encountered.

     

    Thanks ahead,

    Moon

    Version:
    19.1.3.0.0 (190129.1200.23460)