search

carsonlau / ANZ_BI

To store all the report relative material.
0 stars 0 forks source link

ICS (System): Venus interface error about Indian TE Actual data #12

Closed carsonlau closed 6 years ago

carsonlau commented 6 years ago

no ticket, just error email from system. no client

Interface Identifier: QVW_SNOP_S2_TE_ACTUALS : SNOP+ TE Actuals Step 2 (From QlikView) India data uploading error in the fields 'ACT_YYYYPP', 'MATL_TDU_CODE'.

  1. 'ACT_YYYYPP' could not be null and each loading should be in same period.
  2. 'MATL_TDU_CODE' could not be null.
carsonlau commented 6 years ago

Schedule job in QMC run the qvw file, load the FPPS data from Helios, then export the csv file. ICS platform loading the data in the csv file into the Venus, but found some data not following the limit in the Venus table, then promt error.

Generator of the csv file: D:\Qlikview_QVD\Transformation\Regional_SNOP\Step_2_TE_Actuals

carsonlau commented 6 years ago

User 'McInerney, Sasha' check that she uploaded this file through ICS interface few days ago. She will update the file and reload today.