1 Reply Latest reply: Jul 20, 2017 8:11 AM by m w RSS

    Unknown Error

    Jens Leysen

      Hello community,

       

      Since today, the reload of our datamodel fails. This is the start for all our other applications so we have to fix this asap.

      The error in the log files give this result:

       

      2017-07-19 18:47:38 1800 temp_Customer_Attributes:

      2017-07-19 18:47:38 1801 LOAD

      2017-07-19 18:47:38 1802 Customer_SX_Number_DCust,

      2017-07-19 18:47:38 1803    AM_SX_Uniq_ID_DCust,

      2017-07-19 18:47:38 1804    Comm_Seat_Code_DCust,

      2017-07-19 18:47:38 1805  AutoNumberHash128(Customer_SX_Number_DCust, 'CustomerSxNumber') as [%CustomerSxNumber],

      2017-07-19 18:47:38 1806

      2017-07-19 18:47:38 1807

      2017-07-19 18:47:38 1808

      2017-07-19 18:47:38 1809

      2017-07-19 18:47:38 1810

      2017-07-19 18:47:38 1811

      2017-07-19 18:47:38 1812

      2017-07-19 18:47:38 1813

      2017-07-19 18:47:38 1814    IF( match(APPLYMAP('Map_Format_LegalType',Type_DCust,'Format not found'),'Individual','Self-Employed') > 0 or

      2017-07-19 18:47:38 1815        len(trim(Type_DCust)) = 0 or

      2017-07-19 18:47:38 1816        len(trim(Account_Dimension_DCust)) = 0 or

      2017-07-19 18:47:38 1817        Account_Dimension_DCust = 0,

      2017-07-19 18:47:38 1818    1,

      2017-07-19 18:47:38 1819    IF(match(num(Market_Segment_Actual_DCust,'00'),'01','05') > 0,

      2017-07-19 18:47:38 1820        3,

      2017-07-19 18:47:38 1821        2

      2017-07-19 18:47:38 1822    )) as [%Ecosystem]

      2017-07-19 18:47:38 1823 FROM [lib://Connector_REPOS_CIT_COR (reporting_root)/DWHD_CUSTOMER.qvd] (qvd)

      2017-07-19 18:47:38 1824 where Is_Current_Flag_DCust = 1 and

      2017-07-19 18:47:38 1825 match(Level_DCust,'01','03')> 0

      2017-07-19 18:47:40      5 fields found: Customer_SX_Number_DCust, AM_SX_Uniq_ID_DCust, Comm_Seat_Code_DCust, %CustomerSxNumber, %Ecosystem,

      2017-07-19 18:47:40      General Script Error

      2017-07-19 18:47:40      Execution Failed

      2017-07-19 18:47:40      Execution finished.



      Most of the community posts about a general script error involve the STORE procedure. This is not the case here.

      There have not been any adjustments to the script and since he finds the 5 fields in the load statement, we have no idea how to fix this.

       

      All suggestions or ideas are welcome!

       

      Kind regards,

      Jens