5 Replies Latest reply: Aug 26, 2011 5:44 AM by Kaushik Solanki RSS

    Reload of 2 OLEDB (MSSQL) Tables hangs

      Hi,

       

      I'm new to Qlikview and considering to become a partner.

      So I've downloaded the trial, done the tutorial and tried a new document on our DB's (AX 2009)

       

      This is my script :

       

      OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AX50SP1_PRISMAX;Data Source=SRV-BEKT-003\SQL2005;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=CBE110702;Use Encryption for Data=False;Tag with column collation when possible=False];

      SQL SELECT *

      FROM "AX50SP1_PRISMAX".dbo.CUSTTABLE;

       

       

      SQL SELECT *

      FROM "AX50SP1_PRISMAX".dbo.SALESTABLE;

       

      The reload starts and both tables are processed but the close button doesn't activate.

      If I choose end now or abort, QV hangs. (see screenshot)

       

      Any suggestions?

      screenshot.bmp

       

       

       

      Regards,

      Sven Peeters

        • Reload of 2 OLEDB (MSSQL) Tables hangs
          John Houston

          Hi Sven,

          Not sure if you have an answer yet but I would check my data layout for synthetic keys. Try to reload the model useing the limited load in the debug option. Keep it at 10 rows per table. This will hopefully complete the load successfully.

          You can then view your data layout and see if there is a problem with it. You will most probably find a big synthetic key that is causing your problem.