Identify Staging Problems
To troubleshoot issues with replicating from a staging environment to a production or development environment, follow this process.
When staging problems occur, isolating problem causes can help formulate a
solution.
Note: This example covers staging from the Staging environment to
Production, but the same steps apply to any staging process running from staging to
development.
- Monitor the job status of the data replication process on the Staging instance.
- If it fails, look at the staging logs for failure messages.
- Look at the staging logs of the Staging instance first.
-
Look at the most recent staging log file. A single staging log
often contains several days' worth of staging events in one
file.
https://staging.web.customerName.demandware.net/on/ demandware.servlet/webdav/Sites/Logs
This only works with Firefox. Microsoft Internet Explorer isn't supported. -
Look for the beginning of the replication process in the logs. It
will have a similar timestamp to the data replication task you
started. (individual tasks created in Business Manager)
[2007-01-15 21:17:12.848 GMT] ISH-CORE-2250: New replication task "1168895828901" in domain "Sites-Site" successfully created. [2007-01-15 21:18:34.171 GMT] ISH-CORE-2250: New replication task "1168895910472" in domain "Sites-customerName" successfully created. [2007-01-15 21:21:13.574 GMT] ========================================================================== [2007-01-15 21:21:13.574 GMT] ReplicationPublication process created. [2007-01-15 21:21:13.575 GMT] Start date: Mon Jan 15 21:21:12 GMT 2007 [2007-01-15 21:21:13.575 GMT] TargetSystem: Production (http://216.75.207.174:80) [2007-01-15 21:21:13.575 GMT] Process uuid: bcvh6iaalTxJYaaacowN3YFqCG) [2007-01-15 21:21:13.575 GMT] --------------------------------------------
-
Scroll down through the log file. You will see the job go through
steps such as gathering stats for all tables:
[2007-01-15 21:27:06.602 GMT] ISH-CORE-2070: SQL (64ms, rows=1): begin dbms_stats.gather_table_stats(user, 'PRODUCTOPTION_AV$1', method_opt => 'for all indexed columns', cascade => TRUE); end; [2007-01-15 21:27:06.654 GMT] ISH-CORE-2070: SQL (52ms, rows=1): begin dbms_stats.gather_table_stats(user, 'PRODUCTOPTION$1', method_opt => 'for all indexed columns', cascade => TRUE); end; [2007-01-15 21:27:06.826 GMT] ISH-CORE-2070: SQL (171ms, rows=1): begin dbms_stats.gather_table_stats(user, 'BUNDLEASSIGNMENT$1', method_opt => 'for all indexed columns', cascade => TRUE); end; [2007-01-15 21:27:06.869 GMT] ISH-CORE-2070: SQL (43ms, rows=1): begin dbms_stats.gather_table_stats(user, 'PRODUCTOPTIONPRICE_AV$1', method_opt => 'for all indexed columns', cascade => TRUE); end; [2007-01-15 21:27:06.869 GMT] ISH-CORE-2067: Starting new transaction... [2007-01-15 21:27:06.872 GMT] ISH-CORE-2069: Commit transaction. [2007-01-15 21:27:06.882 GMT] ISH-CORE-2067: Starting new transaction..
-
Next you will see the rsynch running which gets the actual file
system directories ready for copying to the target instance
2007-01-15 21:27:08.317 GMT] StagingGroup: Site specific content search index (Relative directory: search/content) [2007-01-15 21:27:08.317 GMT] ISH-CORE-2486: Synchronize Files of unit 'Sites-customerName-Site' in site 'Sites-customerName-Site' to exchange directory at '/remote/aaas/staging/stg'. [2007-01-15 21:27:08.318 GMT] Executing command: /build/2.0.0/system/bin/synchronize.sh /remote/aaas/aaas_stg/sharedata/sites/Sites-customerName-Site/1/search/content/ /remote/aaas/staging/stg/Sites-customerName-Site/search/content/ () [2007-01-15 21:27:08.402 GMT] rsync debug (/usr/bin/rsync -tr --delete /remote/aaas/aaas_stg/sharedata/ sites/Sites-customerName-Site/1/search/content/ /remote/aaas/staging/stg/Sites-customerName-Site/ search/content/) [2007-01-15 21:27:08.476 GMT] ISH-CORE-1956: Files in path 'search/content' of site 'Sites-customerName-Site' are successfully prepared
-
The final step on the Staging instance should be a handoff to the target
(Production server). Its staging log entry resembles the following line.
[2007-01-15 21:27:09.783 GMT] Staging pipeline in live system successfully called.
-
If you don't see this success message, look for errors such as
the following and follow the recommended steps.
ISH-CORE-2491: Setting state of process with uuid='dC8KAANna1AAAAEOTN9h9md4' from 'StartingStagingProcess' to 'ErrorAcquiringEditingLocks
Infocenter Retirement: On June 30, 2023, the Infocenter was retired, and documentation currently hosted on the Infocenter will be published to Salesforce Help, Commerce Cloud Developer Center, and Salesforce B2C Commerce Developer Documentation Resources. For more information, see the release note.