You can verify the result of a data replication process.
Select
to view a list of all data replication processes and their statuses.Data replication processes are included in Salesforce B2C Commerce logs. Select Log Files link, and look for staging logs.
, click thehttps://
[staging_instance_name]
/on/demandware.servlet/webdav/Sites/Logs
.
Note that a single staging log can contain several days worth of
events.The following is an example of a log entry.
[2007-01-15
21:17:12.848 GMT] ISH-CORE-2250: New replication task "1168895828901" in
domain "Sites-Site" successfully created.
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;
rsync
prepared the source file system directories
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-customer-Site' in site
'Sites-customer-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-Customer-Site/1
/search/content/
/remote/aaas/staging/stg/Sites-Customer-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-Customer-Site/1
/search/content/
/remote/aaas/staging/stg/Sites-Customer-Site/search/content/)
[2007-01-15
21:27:08.476 GMT] ISH-CORE-1956: Files in path 'search/content' of
site 'Sites-Customer-Site' are successfully
prepared
[2007-01-15
21:27:09.783 GMT] Staging pipeline in live system successfully
called.
If the success message is missing, look for an error similar to the following.
ISH-CORE-2491: Setting state of
process with uuid='dC8KAANna1111EOTN9h9md4' from
'StartingStagingProcess' to 'ErrorAcquiringEditingLocks
If this staging error occurred, do the following.
https://
[target_instance_name]
/on/demandware.servlet/webdav/Sites/Logs
2007-01-15 20:29:30.321 GMT] Copy
staging process with uuid=bcFvkiaalTMxM444667bVYFqBX[2007-01-15
20:29:32.347 GMT] Starting [email protected]
(
[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
('bcIxgiaalXEYQ2223334N9rLDa')
[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
$2
temp table to the $1
source table. Errors here may indicate a problem with this last step.[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 21:31:17.434 GMT]
ReplicationPublication process finished with state
'StagingProcessCompleted'.