Q2 Customer Support

You were running UDM migration and from AIS Monitor mentioned the error as shown below:

.

Root Cause:

1. Check the data that has been entered into CDS_SCHEMA with the BATCH_ID to be processed and then highlight it to the DAY_SK field, with the following QUERY :

   SELECT T101.TENANT_CD AS TENANT_CD, T101.ACCOUNT_SK AS ENTITY_SK, T101.EXECUTION_BRANCH_SK AS BRANCH_SK, T103.ENTITY_SK AS TRANS_TYPE_SK, T101.TRANS_DAY_SK AS DAY_SK, T104.DATETIME AS DAY, T102.ENTITY_BUCKET AS ENTITY_BUCKET_SK, SUM(T101.QUANTITY) AS TRX_QTY, SUM(T101.ACCT_CURR_AMOUNT) AS TRX_SUM, MAX(T101.BATCH_ID) AS BATCH_ID FROM CDS_SCHEMA.V_TRANSACTIONS T101 INNER JOIN CDS_SCHEMA.V_ENTITY T102 ON T102.ENTITY_SK = T101.ACCOUNT_SK INNER JOIN CDS_SCHEMA.V_SAM_TRANS_TYPE T103 ON T103.ENTITY_SK = T101.SAM_TRANS_TYPE_SK INNER JOIN CDS_SCHEMA.V_DAY T104 ON T104.DAY_SK = T101.TRANS_DAY_SK WHERE T101.EXECUTION_BRANCH_SK IS NOT NULL AND ( COALESCE(T103.IS_EXCLUDED_FROM_PROFILE,0) ) ( 1) AND T101.BATCH_ID = 1636 GROUP BY T101.TENANT_CD, T101.ACCOUNT_SK, T101.EXECUTION_BRANCH_SK, T103.ENTITY_SK, T101.TRANS_DAY_SK, T104.DATETIME, T102.ENTITY_BUCKET

2. QUERY Results :
3. Check the maximum partition value from table SAM_PRF.SAM_PRF_AGG_MLT_BRCH_DAY_DAT
4. After checking in points 1 and 2 that the maximum DAY_SK partition key to enter is less than 7745 that the Migration process can run, At point 1 found DAY_SK 7869 and DAY/ BATCH_DATE_TIME = 18-Jul-21, because that value exceeds the maximum of HIGH_VALUE at point 2 as a result the migration process error.

Corrective Action :

1. Delete the data for BATCH_ID ='1636' AND BATCH_DATE_TIME = '18-JUL-21' which has been entered the table in CDS_SCHEMA.With the following QUERY example :

   DELETE FROM CDS_SCHEMA.TRANSACTIONS WHERE BATCH_ID ='1636' AND BATCH_DATE_TIME = '18-JUL-21 12.00.00.000000000 AM';

2. Rerun the Migration process.