Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Unknown Error

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

1 Reply
m_woolf
Master II
Master II

Have you tried stepping through the load with debug?