Hi,
I had created an Order Release in OTM via integration through element <Release> with IU option. This XML message is being generated by an external system. The same external system has a restore function which basically retrieves info from OTM back to the external system. Doing this means the order that had been restored had to be removed from OTM and made available again in the external system for modification, etc. The deletion of order at OTM is being done via a call to a stored procedure that directly purges records relevant to the order at OTM database and this works fine. The order disappears at OTM after the stored proc execution. However, when we try re-importing back the same order to OTM via integration, OTM fails the transmission with status ERROR and below is the message being thrown:
IMessageCode = TRANSACTION_EXCEPTION
IMessageText = CAUGHT THE FOLLOWING EXCEPTION WHILE PROCESSING TRANSACTION: glog.util.exception.RemoteExceptionWrapper Read_Record_Failure (cachedUser=PHL/LTL.ADMIN/null/ADMIN, class=class glog.ejb.order.ejb_OrEquipment_b8c88i_Impl, currentUserName=PHL/LTL.ADMIN, primaryContext=PHL/LTL.MKD000013 1, vpdUser=PHL/LTL.ADMIN/PHL/LTL.ADMIN/ADMIN) Unable to read {0=null} {1=null} from the database. Either the record has been removed by another user or you do not have rights to view it. (cachedUser=PHL/LTL.ADMIN/null/ADMIN, class=class glog.ejb.order.ejb_OrEquipment_b8c88i_Impl, currentUserName=PHL/LTL.ADMIN, primaryContext=PHL/LTL.MKD000013 1, vpdUser=PHL/LTL.ADMIN/PHL/LTL.ADMIN/ADMIN)
Tried checking the logs and found that the failure occurs at point when system tries to update the order release while in fact, the order was no longer existing in the database. Tried changing the Transaction code of XML to "I" (insert) and system throws another error:
IntegrationLogMessage
Now my question: Is there a way to automatically trigger a cache refresh / clear before processing an inbound XML message? Is there such configuration or property that can be set to achieve this goal?
Hoping for your kind suggestion on this.
Thanks and best regards!
I had created an Order Release in OTM via integration through element <Release> with IU option. This XML message is being generated by an external system. The same external system has a restore function which basically retrieves info from OTM back to the external system. Doing this means the order that had been restored had to be removed from OTM and made available again in the external system for modification, etc. The deletion of order at OTM is being done via a call to a stored procedure that directly purges records relevant to the order at OTM database and this works fine. The order disappears at OTM after the stored proc execution. However, when we try re-importing back the same order to OTM via integration, OTM fails the transmission with status ERROR and below is the message being thrown:
IMessageCode = TRANSACTION_EXCEPTION
IMessageText = CAUGHT THE FOLLOWING EXCEPTION WHILE PROCESSING TRANSACTION: glog.util.exception.RemoteExceptionWrapper Read_Record_Failure (cachedUser=PHL/LTL.ADMIN/null/ADMIN, class=class glog.ejb.order.ejb_OrEquipment_b8c88i_Impl, currentUserName=PHL/LTL.ADMIN, primaryContext=PHL/LTL.MKD000013 1, vpdUser=PHL/LTL.ADMIN/PHL/LTL.ADMIN/ADMIN) Unable to read {0=null} {1=null} from the database. Either the record has been removed by another user or you do not have rights to view it. (cachedUser=PHL/LTL.ADMIN/null/ADMIN, class=class glog.ejb.order.ejb_OrEquipment_b8c88i_Impl, currentUserName=PHL/LTL.ADMIN, primaryContext=PHL/LTL.MKD000013 1, vpdUser=PHL/LTL.ADMIN/PHL/LTL.ADMIN/ADMIN)
Tried checking the logs and found that the failure occurs at point when system tries to update the order release while in fact, the order was no longer existing in the database. Tried changing the Transaction code of XML to "I" (insert) and system throws another error:
IntegrationLogMessage
- ILogSeqNo = 5370809
- ITransactionNo = 6723807
- ObjectGid
- Gid
- DomainName = PHL/LTL
- Xid = MKD000013
- Gid
- WrittenBy = ReleaseInterface
- IMessageClass = E
- IMessageCode = DUPLICATE_KEY_ERROR
- IMessageText = THE ELEMENT(S) Contact.ContactGid WITH VALUE(S) PHL/SHAREDAIR_EXPORT IS A DUPLICATE PRIMARY KEY
- TimeStamp = 20090706153340
- DomainName = PHL/LTL
Now my question: Is there a way to automatically trigger a cache refresh / clear before processing an inbound XML message? Is there such configuration or property that can be set to achieve this goal?
Hoping for your kind suggestion on this.
Thanks and best regards!
Comment