FIX_SYNC_MASTER_STWNSPOOR-19

SELECT * FROM p_rcv_log ORDER BY  rcv_log_id DESC LIMIT 10

SELECT * FROM p_rcv_data_log WHERE rcv_log_id = 563 AND flg_process = 'FAIL'

SELECT * FROM p_rcv_data_log WHERE rcv_log_id = 563 AND type_data = 'Product'

"Error key : merge.fail.data.not.uptodate with params [org.jleaf.erp.master.entity.ProductUngeneratedId(org.jleaf.erp.master.entity.ProductUngeneratedId(m_product))]
    at org.jleaf.core.dao.BaseDaoImpl.merge(BaseDaoImpl.java:107)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    at org.springframework.aop.framework.R"

"{"id":1673,"tenantId":10,"code":"PIT 002","name":"PITMAN ARM.ICHIBAN.45401-29195.TOYOTA KIJANG SUPER (RHD)","ctgrProductId":16,"subCtgrProductId":23,"brandId":49,"baseUomId":10,"uomId1":10,"uomId2":10,"uomId3":10,"flagBuy":"Y","flagSell":"Y","minQty":0.0,"maxQty":0.0,"classProduct":"FASTMOVING","active":"Y","activeDateTime":"20150901000000","nonActiveDateTime":" ","createUserId":-1,"createDateTime":"20150901000000","updateUserId":115,"updateDateTime":"20171017130831","version":1}"

SELECT * FROM m_product WHERE product_id = 1672

--SELECT data_log::json->>'id' FROM p_rcv_data_log WHERE rcv_log_id = 561 AND type_data = 'Product'

SELECT SUBSTRING(data_log FROM '^"{"id":\w+' ) FROM p_rcv_data_log WHERE rcv_log_id = 563

SELECT SUBSTRING(data_log FROM '^\w[0-9]*' ) FROM p_rcv_data_log WHERE rcv_log_id = 563

SELECT substring(data_log from '(?:"id":)([\d\.]*)') FROM p_rcv_data_log WHERE rcv_log_id = 563

CREATE TABLE m_product_20171031 AS SELECT * FROM m_product

BEGIN

    UPDATE m_product SET version = 1 WHERE product_id = 1673

    UPDATE m_product Z
    SET version = substring(A.data_log from '(?:"version":)([\d\.]*)')::bigint
    FROM p_rcv_data_log A
    WHERE A.rcv_log_id = 563
        AND A.type_data = 'Product'
        AND Z.product_id = substring(A.data_log from '(?:"id":)([\d\.]*)')::bigint

END