Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

No responce on reloading QVDs

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

1 Solution

Accepted Solutions
Highlighted

Re: No responce on reloading QVDs

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.

View solution in original post

14 Replies
Highlighted

Re: No responce on reloading QVDs

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,

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
Creator III
Creator III

Re: No responce on reloading QVDs

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

Highlighted

Re: No responce on reloading QVDs

Hi,

Click Ctrl+ T then you can find Copy Image/Export Image/Export Structure Option on the top.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted

Re: No responce on reloading QVDs

Hi,

Synthetic Key and Circular Reference is the reason for your issue.

Avoid it by Renaming Field/ creating Link Table/ Creating Key

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
Creator III
Creator III

Re: No responce on reloading QVDs

As of now we haven't loaded the data into QV application.

Highlighted
Creator III
Creator III

Re: No responce on reloading QVDs

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.

Highlighted
Creator III
Creator III

Re: No responce on reloading QVDs

Actually you can't. The QlikView application is not "not responding", it is busy calculating the synthetic keys and circular references.

Highlighted
Specialist
Specialist

Re: No responce on reloading QVDs

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 .

Highlighted
Creator II
Creator II

Re: No responce on reloading QVDs

Hi hari. can u send me ur mail ID