Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have you tried stepping through the load with debug?