Fix Staging Problems

If you identify a staging problem, follow this process.

1. Stop and restart the staging and target instance via Control Center.
2. Repeat the failed staging process with the same parameters.
3. If the staging environment log shows no errors, look at the production staging log.

   https://production-web-customerName.demandware.net/on/demandware.servlet/webdav/Sites/Logs

4. Production staging logs will start with a message that looks like this.

   2007-01-15 20:29:30.321 GMT] Copy staging process with uuid=bcFvkiaalTMxMaaaco4bVYFqBX[2007-01-15 20:29:32.347 GMT] Starting [email protected] (

5. Depending on what you are staging, you will see the database table copy begin.

   [2007-01-15 20:30:20.296 GMT] ISH-CORE-2070: SQL (123ms, rows=1): INSERT /*+ APPEND */ INTO CATALOG$1 dest SELECT CATALOGDOMAINID,ID,TYPECODE,STATUS,PROXYFLAG,STARTMAINTENANCE,
   ENDMAINTENANCE,POSITION,UUID,OCA,DOMAINID,LASTMODIFIED FROM CATALOG$S src WHERE src.DOMAINID NOT IN ('bcIxgiaalXEYQaaacmKaN9rLDa')
   [2007-01-15 20:30:20.665 GMT] ISH-CORE-2070: SQL (369ms, rows=0): TRUNCATE TABLE CATALOGSITEASSIGNMENT$1 REUSE STORAGE
   [2007-01-15 20:30:20.769 GMT] ISH-CORE-2070: SQL (100ms, rows=1): INSERT /*+ APPEND */ INTO CATALOGSITEASSIGNMENT$1

6. After copying, we switch from temp to source tables $2 to $1.

   [2007-01-15 20:35:43.935 GMT] ISH-CORE-2300: <dbms_output> Switching synonym PRODUCT_AV from PRODUCT_AV$2 to PRODUCT_AV$1...
   [2007-01-15 20:35:43.935 GMT] ISH-CORE-2300: <dbms_output> Switching synonym DELETEDPRODUCT from DELETEDPRODUCT$2 to DELETEDPRODUCT$1...
   [2007-01-15 20:35:43.935 GMT] ISH-CORE-2300: <dbms_output> Switching synonym PRODUCT from PRODUCT$2 to PRODUCT$1...
   [2007-01-15 20:35:43.935 GMT] ISH-CORE-2300: <dbms_output> Switching synonym PRODUCTLINK from PRODUCTLINK$2 to PRODUCTLINK$1...
   [2007-01-15 20:35:43.935 GMT] ISH-CORE-2300: <dbms_output> Switching synonym PRODUCTOPTION from PRODUCTOPTION$2 to PRODUCTOPTION$1

7. If it finishes successfully, you will see the following message at the end of the logs.

   [2007-01-15 21:31:17.434 GMT] ReplicationPublication process finished with state 'StagingProcessCompleted'.
   [2007-01-15 21:31:17.435 GMT] Process uuid: cfbcMiaalTlpoaaado7llYFqCL)
   [2007-01-15 21:31:17.435 GMT] End date: Mon Jan 15 21:31:16 GMT 2007
   [2007-01-15 21:31:17.435 GMT] =======================================