CSC Cloning/returns Failing with Connection time out

There is bug that has been introduced in ATG 11 pertaining to CSC Clone order. If we try to clone order which has coupons associated with it, It will fail to copy most of the times.

When Performing returns/Copy order we generally perform Cloning of the Order in CSC and Work on the Cloned order. When doing this operation it generally takes more time and it fails if it was not able to fetch the details in Specific time frame.

Below is the error that is been Seen in the logs.

Error Tue Nov 29 16:29:59 EST 2016 1480454999909 /atg/dynamo/servlet/pipeline/RequestScopeManager/RequestScope-103429/atg/commerce/custsvc/returns/StartReturnExchangeProcess Caused by (#5):java.lang.RuntimeException: CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_NOTA start() failed on resource 'SwitchB': XAER_NOTA : The XID is not valid 
Error Tue Nov 29 16:29:59 EST 2016 1480454999909 /atg/dynamo/servlet/pipeline/RequestScopeManager/RequestScope-103429/atg/commerce/custsvc/returns/StartReturnExchangeProcess oracle.jdbc.xa.OracleXAException 
Error Tue Nov 29 16:29:59 EST 2016 1480454999909 /atg/dynamo/servlet/pipeline/RequestScopeManager/RequestScope-103429/atg/commerce/custsvc/returns/StartReturnExchangeProcess at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1110) 

Error Tue Nov 29 16:29:59 EST 2016 1480454999909 /atg/dynamo/servlet/pipeline/RequestScopeManager/RequestScope-103429/atg/commerce/custsvc/returns/StartReturnExchangeProcess at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:240)

The above error Occurs when we are trying to Interact with Multiple Datasources. In our case it will be ProductionDS and SwitchBDS.

We all know that the Order is present in ProductionDS not in the CatalogSchema so when we try to clone the order then we will try to interact with single DataSource. But there is External repository references like PriceLists, pricingModels which often Point to external repositories like Catalog repositories which requires External Database interaction.

This action may take long time to retrieve the results in a single transaction and throws this exception.

This external interactions are been removed from cloning in earlier versions of ATG but was not done in ATG11.

Solution:
In CSC config path add below properties.
/atg/commerce/custsvc/returns/CloneReturnWorkingOrder 

excludedOrderProperties=\ 
itemPriceInfo=priceList,\ 
pricingAdjustment=coupon|pricingModel 

This Bug is Specifically in ATG 11.X and this is fixed in Earlier versions of ATG. 

 

Comments

Post a Comment

Popular posts from this blog

ATG Database Tables

Most Important Tables that is required when analysing ATG related things are been listed below with all the description. The below list of tables is been divided based on the schemas in which they reside. The schemas that have been classified is based in Switching Database Architecture. For nonSwitching it a bit different which you will get to know when you reach the end. Schemas are : Production Schema Catalog Schema(SwitchA/CatA/SwitchB/CatB) Publishing Schema Production Schema :       User: DPS_USER - Has all the User details, whoever registers their account in ATG will have its entry its here. DPS_CREDIT_CARD - Contains all the User profile save cards info. This is been linked to DPS_USER table with linking table(DPS_USR_CREDITCARD). DPS_CONTACT_INFO - All the User saved addresses will be saved here like firstname, lastname, Address1, City, State, Phone Number. This table is linked with DPS_USER table using DPS_USER_ADDRESS. DCS_USER - Thi...
Read more

ATG BCC Users Roles

Each and Every person Who ever Login's to the ATG System Should have Users created in ProfileRepositoy. Their accesses to perform different Actions/Activities depends on the kind of Roles assigned to that User. Below are the Different roles that User Should Possess for Accessing BCC. User Role Description EPub-User Business User Who Creates and manages Assets. He Cannot Review them or Deploy them. EPub-Manager User Who Reviews and Approves the Assets created by ‘EPub-User’ and can deploy the same on Staging and Production. He can also create New Assets and Move them between the Targets. EPub-Admin Users Can Create new Users and grant Access to different users. Can create new users. Can assign new Responsibilities/remove responsibilities  to/from existing User. He is Same as Epub-user in case of Assests creation. He can just create/manage but cannot move them between targets. EPub-Super-Admin Has all the permissions. of the Above three...
Read more

Resetting the Dynamo Admin password

Facing difficulty in Logging in to dynamo admin or Forgot Password for the same. NO PROBLEM. Please Follow below Steps to reset it. 1) Delete all the rows from table das_account . 2) Restart the server instance. This Creates all the rows in das_account with default Values. 3) LOGIN to dyn/admin with default credentials admin/admin . 4) After Login DYN ADMIN ask to reset the password. Reset to the desired Value. Hope this Helps.
Read more