Hotfix deployed for Replication Issue.
? Executed the backup script “01_PropertyDataGet_Bkp” which will take back up of
PropertyDataGet store proc.
? Then executed the “02_PropertyDataGet” script having fix for the replication issue.
? Ask assistance to Marlon to restart the ETP Application for Store Operation and Store front.
Then tried to login and logout on the application. As per checking error encountered on ETP
Store front.
? Executing the script 03_PropertyDataGet_Rollback, successfully login on the ETP Store front.
? Then check the replication data on SQLyog of Robinson Store Database. -7 Status means the
batch files are not merge and replication will not go thru. After the fix was run this should be
converted to other status to be sent on store replication application.

? As per analysis we found that ETP Replication app have processed the batches but the batches
have stuck at -1 status which is error at Create XML process, will be checked by ETP CS.

? BATCHSTATUSMASTER :-
Table will contain description for Replication status

Status Description ConstantID
-2 Error while processing batch records CORE000570
-1 Error while posting to local queue CORE000568
0 Initial status CORE000571
1 Batch Posted to local queue CORE000567
2 Batch processed successfully CORE000569
3 No records found! CORE000572
4 Batch Uploaded CORE000575

? OUTBOUNDBATCHSTATUS :-
Once Batches are created, it will be inserted in this table.
It will create store batches which are to be replicated to EAS server.
When the Batch is processed it is uploaded or failed, Status column will be updated.