|
|
|
## 起因
|
|
|
|
daily clearance json 過早處理
|
|
|
|
![image](uploads/81042f62dde54233cd626ed7661748bb/image.png)
|
|
|
|
|
|
|
|
transaction 未搬晒去 transactionArchive,pre processing 就做咗
|
|
|
|
![image](uploads/5e2658afe83432409f851d9e89097417/image.png)
|
|
|
|
|
|
|
|
而引起嘅錯數
|
|
|
|
![WhatsApp_Image_2023-05-18_at_09.04.24](uploads/ffe0d376be89af172aeb2c1c5857210a/WhatsApp_Image_2023-05-18_at_09.04.24.jpg)
|
|
|
|
![image](uploads/5d0cb33326008e88b634e2d5eee1ba54/image.png)
|
|
|
|
|
|
|
|
|
|
|
|
## 解決方法
|
|
|
|
直接駁 cloud report db
|
|
|
|
用以下嘅 SQL statement
|
|
|
|
http://gitlab.web-on.com/-/snippets/39
|
|
|
|
替換其中嘅 shop code
|
|
|
|
|
|
|
|
再 remote 去 cloud report VM
|
|
|
|
用以下 command 行多次 pre processing
|
|
|
|
![image](uploads/2e92fcc93ab239f524b7cc19f4e223eb/image.png)
|
|
|
|
|
|
|
|
就可以解決呢個問題
|
|
|
|
![image](uploads/0b3acb1bda7c80ab5b48111e38920ed2/image.png) |
|
|
|
\ No newline at end of file |