ATG 10.1.2 Bug in the Submit Order Pipeline
Perhaps I can save some people a lot of aggravation. about 1 month ago we got reports from customers that they would get an order confirmation screen but no confirmation emails and when they called customer support their order was not in the fulfillment system.
After checking the logs we noticed that there was always the same error in the logs when this happened. "atg.commerce.fulfillment.SubmitOrder; rolling back the transaction". This after more tracing and debugging we came to a dead end and decided to open a Severity 1 ticket with Oracle. After much back and forth the conclusion was that there is a bug in the Oracle code base and that we needed to turn off caching on 2 elements of the ProfileAdapterRepository, ItemDescriptor 'user'. they are: user.individualScenarios and user.promotionStatus. Here is the XML I put into our localconfig/atg/userprofilling/userProfile.xml
Be Cool use ATG!
<user>CodingJunky</user>
After checking the logs we noticed that there was always the same error in the logs when this happened. "atg.commerce.fulfillment.SubmitOrder; rolling back the transaction". This after more tracing and debugging we came to a dead end and decided to open a Severity 1 ticket with Oracle. After much back and forth the conclusion was that there is a bug in the Oracle code base and that we needed to turn off caching on 2 elements of the ProfileAdapterRepository, ItemDescriptor 'user'. they are: user.individualScenarios and user.promotionStatus. Here is the XML I put into our localconfig/atg/userprofilling/userProfile.xml
<item-descriptor expert="false" display-name-resource="itemDescriptorUser" id-separator=":" writable="true" cache-mode="simple" content="false" folder="false"
default="false" sub-type-property="userType" hidden="false" name="user" display-property="login" use-id-for-path="false">
<table name="dps_user_scenario" id-column-name="id" type="multi">
<property xml-combine="replace" expert="true" category-resource="categoryScenarios" component-item-type="individualScenario" column-name="ind_scenario_i
d" display-name-resource="scenarioInstances" data-type="set" cascade="update,delete" name="scenarioInstances" cache-mode="disabled">
<attribute name="resourceBundle" value="atg.scenario.UserProfileTemplateResources"/>
</property>
</table>
<table name="dcs_usr_actvpromo" id-column-name="id" multi-column-name="sequence_num" type="multi" shared-table-sequence="1">
<property xml-combine="replace" expert="false" readable="true" category-resource="categoryCommercePromotions" component-item-type="promotionStatus" display-na
me-resource="activePromotions" writable="true" cache-mode="disabled" column-name="promo_status_id" data-type="list" cascade="update,delete" hidden="false" nam
e="activePromotions" required="false" queryable="true">
<attribute name="resourceBundle" value="atg.commerce.UserProfileTemplateResources"/>
</property>
</table>
Be Cool use ATG!
<user>CodingJunky</user>
