Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using QV11.2 SR11. My app consisting of 50qvds. While reloadig the applicaion it is getting stuck on progress, if i press on abort then QV applicaion is going to the not responding state.
Is there any solution to completing the reload successsully.
Thanks in advance
It is much easier to add tables one at a time and fix any synthetic key / circular references before adding more tables.
If you add all the tables and then try to resolve the issues you cannot easily see the actual cause of the problem.
Add an extra tab to your load script that contains the following
trace ;
trace ######## EXIT SCRIPT ######## ;
exit script ;
Then you can promote / demote this tab through your script to test the load using debug mode with a limited load of 10 rows. Start with the exit script tab, after the first table load, and then move it through the script until the issues are resolved.
Hi,
Initially debug it with limited load take 10 records->then check is their any synthetic key or circular loop created.
Also check that did you join any two table which dont have common field.
REgards,
Hi,
Synthatic keys and circular references are there. To get snapshot of the Source DataModel I am loading the data.
Any suggestion/tool to capture source datamodel.
Thanks
Hi,
Click Ctrl+ T then you can find Copy Image/Export Image/Export Structure Option on the top.
Regards
Hi,
Synthetic Key and Circular Reference is the reason for your issue.
Avoid it by Renaming Field/ creating Link Table/ Creating Key
Regards
As of now we haven't loaded the data into QV application.
I think we can do that once we have clear picture about all the fields and tables. So once I have loaded the data then I can do that right.
Actually you can't. The QlikView application is not "not responding", it is busy calculating the synthetic keys and circular references.
Even i got the same issue earlier . structure of datamodel might be one reason and synthetic keys and circular loops also cause the problem . check the fields in datamodel .
Hi hari. can u send me ur mail ID