|
|
## 起因
|
|
|
daily clearance json 過早處理
|
|
|
![image](uploads/083e76ee8f064f460c8f29885b08e4fb/image.png)
|
|
|
|
|
|
transaction 未搬晒去 transactionArchive,pre processing 就做咗
|
|
|
|
|
|
而引起嘅錯數
|
|
|
![WhatsApp_Image_2023-05-24_at_10.42.46](uploads/a1fb63497c66574be975992295b3d74f/WhatsApp_Image_2023-05-24_at_10.42.46.jpg)
|
|
|
|
|
|
![WhatsApp_Image_2023-05-24_at_10.42.55](uploads/05feca6bc6783c86bd06e2961e050408/WhatsApp_Image_2023-05-24_at_10.42.55.jpg)
|
|
|
|
|
|
|
|
|
## 解決方法
|
|
|
直接駁 cloud report db
|
|
|
用以下嘅 SQL statement
|
|
|
http://gitlab.web-on.com/-/snippets/41
|
|
|
替換其中嘅 `shopCode`, `archiveStaff`, `archiveDate`, `startDate`, `endDate`
|
|
|
|
|
|
再 remote 去 cloud report VM
|
|
|
用以下 command 行多次 pre processing
|
|
|
![image](uploads/c20236e4b99e76fa1ad2dfeb04f8fa54/image.png)
|
|
|
|
|
|
就可以解決呢個問題
|
|
|
![image](uploads/59edcb888714917621dba00448f6af53/image.png) |
|
|
\ No newline at end of file |