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
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