Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jens_leysen
New Contributor III

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
mwoolf
Honored Contributor II

Re: Unknown Error

Have you tried stepping through the load with debug?