Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
My Qliview is keep on failing even after completing last part of execution after the last execution it show the synthetic count and then message pops up that script execution failed to load
Can you attach the document and/or task log so we can see where the script is failing? Has this worked previously? If so, were there any changes in the script or environment before it started failing?
Thanks,
Josh
Qlik Support
This is the log generated. every single query completed but at last failed with General Script Error. Below is not full log..
2019-05-30 19:12:42 1615 Facts:
2019-05-30 19:12:42 1616 Load
2019-05-30 19:12:42 1617 *
2019-05-30 19:12:42 1618 Resident BadDebt
2019-05-30 19:12:52 39 fields found: UseDate, JournalType, Value, ValueEvent, ValueType, PolicyKey, ClientRef, VersionRef, BandRef, BusEvent, ExecFact, ExecOffice, OrigExecName, Handler, Insurer, Product, Status, EffectiveDate, RenewalListDate, RenewalDate, InvoiceDate, InceptionDate, LatestPrem, Prem, Comm, Introducer, Policy Type, Debt Value, Debt Type, Direct to insurer, Debt Age, Debt Status, Debt Days, FactSource, Debt Snapshot Date, Debt Snapshot Period, Debt Value Snapshot, %FactKey, %ExeclinkKey,
2019-05-30 19:12:52 380,818 lines fetched
2019-05-30 19:12:52 1620 Concatenate (Facts)
2019-05-30 19:12:52 1621
2019-05-30 19:12:52 1622 Load *
2019-05-30 19:12:52 1623 Resident DataQuality
2019-05-30 19:13:04 20 fields found: Main_PK, DQExecOffice, Error Code, ErrorDescription, DQStatus, DQCompFlag, Main Group, Sub Group, Points, UniqueCount, ValueEvent, ValueType, ClientRef, ExecFact, Entity, UseDate, Last Updated, FactSource, %FactKey, %ExeclinkKey,
2019-05-30 19:13:04 1,183,842 lines fetched
2019-05-30 19:13:04 1625 Concatenate (Facts)
2019-05-30 19:13:04 1626
2019-05-30 19:13:04 1627 Load *
2019-05-30 19:13:04 1628 Resident Outstanding
2019-05-30 19:13:04 28 fields found: Main_PK, ClientRef, UseDate, Value, Renewed Value, ValueEvent, VersionRef, BusEvent, BandRef, ExecID, ExecFact, ExecOffice, OrigExecName, Handler, Provider, Product, Status, RenewalListDate, RenewalDate, Renewal Processed Desc, Acturis Band Lapse, Renewed Policy Link, Remarket, Remarket Value, Entity, FactSource, %FactKey, %ExeclinkKey,
2019-05-30 19:13:04 1,183,842 lines fetched
2019-05-30 19:13:04 1630 Concatenate (Facts)
2019-05-30 19:13:04 1631
2019-05-30 19:13:04 1632 Load *
2019-05-30 19:13:04 1633 Resident Income
2019-05-30 19:13:33 73 fields found: Main_PK, Main_LastUpdate, UseDate, IncomeDate, InvoiceDate, JournalType, NominalCode, AccountingCentre, Value, Euro, EuroRate, Dollar, DollarRate, Zloty, ZlotyRate, ValueEvent, ValueType, PolicyKey, ClientRef, VersionRef, BandRef, BusEvent, ExecID, EmailTest, ExecFact, ExecOffice, OrigExecName, Handler, Insurer, Product, Status, EffectiveDate, RenewalListDate, RenewalDate, InceptionDate, LatestPrem, Prem, Comm, RPT_NewBusReason, RPT_MTAReason, RPT_LapseReason, RPT_CancelReason, Introducer, AcceptedByUser, Entity, Accounting Entity, IncomeTeam, IncomeTeam JIP Remap, IncomeTeam Cost Centre, P_LastUpdate, Renewable, < 12 Month Policy, LapseReason, CancelReason, RatingMethod, PostUser, ActurisJIP, ActurisRBS, ActurisJIB, ActurisJEB, ActurisHS, RenewalSort, RenewalMonth, RenewalPeriod, RenewalYear, CurrentExec, FactSource, %FactKey, Email, %ExeclinkKey, Original_ValueEvent, BFPolicyKey, LapseCancelReason,
2019-05-30 19:13:33 General Script Error
2019-05-30 19:13:34 Execution Failed
2019-05-30 19:13:35 Execution finished.
It appears you have a problem with the last concatenate against the larger resident table, and an easy thing to do is use the Script Debugger in the Desktop client to limit the number of rows fetched across every load to see if things complete, as if they do, then most likely you are hitting either a resource limit or some other limitation. If you do have synthetic keys/tables, you really do need to properly control those, as unexpected things can happen when you do not control the links etc.
https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634
That Design Blog post will shed some light upon things regarding those. General script errors are generally logic errors, just FYI, so I would venture best path forward is to use debugger to run limited load and see what you get that way, if things complete, then it would appear the data model cannot properly generate itself with the full load etc. for some reason... Sorry I do not have something better, but hopefully this lets you move forward further.
Regards,
Brett
Hi,
I can't see anything wrong with the log...
What it got my attention is that you aren't dropping any of the resident tables you are using. Maybe this is a possible cause for your error. 🙂