Announcement

Collapse
No announcement yet.

Error on Carriers Synchronization

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error on Carriers Synchronization

    Hi All,

    We installed all BPEL suitcases and create couple carriers on EBS side. We tried to run the "Shipping-Transportation Carriers Synchronization" concurrent program with a selected carrier on EBS but got an error. The concurrent log shows as below:
    Can anyone give me a direction for debugging?

    Best Regards,
    KJ

    Entering SyncRefDataToOtm.runProgram
    Entering SyncRefDataToOtm.initVariables
    paramName is CARRIER_NAME_LOW
    paramValue is TEST CARRIER
    paramName is CARRIER_NAME_HIGH
    paramValue is TEST CARRIER
    paramName is LAST_UPDATE_DATE_LOW
    paramValue is
    paramName is LAST_UPDATE_DATE_HIGH
    paramValue is
    Exiting SyncRefDataToOtm.initVariables
    Entering SyncRefDataToOtm.initSecurityInfo
    Connection object [email protected]
    Exiting SyncRefDataToOtm.initSecurityInfo
    Entering SyncRefDataToOtm.validateProfiles
    Entering SyncRefDataToOtm.isOtmInstalled
    Connection object [email protected]
    Exiting SyncRefDataToOtm.isOtmInstalled
    domain Name is DEFAULT
    country code is USA
    Exiting SyncRefDataToOtm.validateProfiles
    Entering SyncRefDataToOtm.queryAndSendEntities
    entity Type is CARRIER
    carrierNameLow TEST CARRIER
    carrierNameHigh TEST CARRIER
    lastUpdateDateLow
    lastUpdateDateHigh null
    BPEL Domain is default
    query String is SELECT HPS.PARTY_SITE_ID, HPS.PARTY_ID, HPS.LOCATION_ID FROM WSH_CARRIERS_V WC, HZ_PARTY_SITES HPS WHERE HPS.PARTY_ID = WC.CARRIER_ID AND WC.ACTIVE = 'A' AND WC.CARRIER_NAME BETWEEN :1 AND :2 AND ( ( (:3 is null or WC.LAST_UPDATE_DATE >= to_date(:4,'YYYY/MM/DD HH24:MI:SS')) AND (:5 is null or WC.LAST_UPDATE_DATE <= to_date(:6,'YYYY/MM/DD HH24:MI:SS') )) OR ( (:7 is null or HPS.LAST_UPDATE_DATE >= to_date(:8,'YYYY/MM/DD HH24:MI:SS')) AND (:9 is null or HPS.LAST_UPDATE_DATE <= to_date(:10,'YYYY/MM/DD HH24:MI:SS')))) ORDER BY WC.CARRIER_ID
    l_dateLow is null
    l_dateHigh is null
    endPoint is mycompany.com
    curCarrSiteId is 6027
    curCarrierId is 4064
    curLocationId is 230
    prevCarrierId is 0
    elementsCount is 0
    totCarrCount is 0
    totCarrSiteCount is 0
    Calling SendDocument outside the loop
    Entering SyncRefDataToOtm.sendDocument
    xml is <input xmlns="<A href="http://xmlns.oracle.com/apps/wsh/outbound/ref/WshSendRefDataStlToOtm"><entityType">http://xmlns.oracle.com/apps/wsh/outbound/ref/WshSendRefDataStlToOtm"><entityType xmlns="<A href="http://xmlns.oracle.com/apps/wsh/outbound/util/WshOtmGlobalOutbound">CARRIER</entityType><entityIdList">http://xmlns.oracle.com/apps/wsh/outbound/util/WshOtmGlobalOutbound">CARRIER</entityType><entityIdList xmlns="<A href="http://xmlns.oracle.com/apps/wsh/outbound/util/WshOtmGlobalOutbound"><entityId>6027</entityId></entityIdList><parentIdList">http://xmlns.oracle.com/apps/wsh/outbound/util/WshOtmGlobalOutbound"><entityId>6027</entityId></entityIdList><parentIdList xmlns="<A href="http://xmlns.oracle.com/apps/wsh/outbound/util/WshOtmGlobalOutbound"><entityId>4064</entityId></parentIdList><securityContext">http://xmlns.oracle.com/apps/wsh/outbound/util/WshOtmGlobalOutbound"><entityId>4064</entityId></parentIdList><securityContext xmlns="<A href="http://xmlns.oracle.com/apps/wsh/outbound/util/WshOtmGlobalOutbound"><ticket>BA2605B4E8946F018D52 D6C9162CBEFD</ticket><proxyServer">http://xmlns.oracle.com/apps/wsh/outbound/util/WshOtmGlobalOutbound"><ticket>BA2605B4E8946F018D52 D6C9162CBEFD</ticket><proxyServer /><proxyPort /><dbConn /><opCode>refOpCode</opCode><argKey>refArgKey</argKey></securityContext><appsContext xmlns="<A href="http://xmlns.oracle.com/apps/wsh/outbound/util/WshOtmGlobalOutbound"><userId">http://xmlns.oracle.com/apps/wsh/outbound/util/WshOtmGlobalOutbound"><userId /><respId /><respAppId /></appsContext></input>
    endPoint is mycompany.com
    Exception occured oracle.xml.parser.v2.XMLParseException: Whitespace required.
    Total number of loops = 1
    Total number of Warnings = 1
    Exiting SyncRefDataToOtm.queryAndSendEntities
    Completion Status false
    Exiting SyncRefDataToOtm.runProgram
    Last edited by darkside32; December 2, 2008, 18:53. Reason: error log details provided
Working...
X