Unknown Error

Anonymous — Wed, 19 Jul 2017 19:37:15 GMT

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

Re: Unknown Error

m_woolf — Thu, 20 Jul 2017 12:11:09 GMT

Have you tried stepping through the load with debug?