topic Script Execution Halt's in between in QlikView

Script Execution Halt's in between

amars — Wed, 08 Sep 2010 11:01:10 GMT

Hi all,

I have a Qlikview Dashboard, in which if I Debug my script & load limited data like 10. Than my script executes properly. But if I try to reload the whole data, it get's hanged or halts in between. I don't know what to do in this case. Please suggest.

With Regards

Amar

Script Execution Halt's in between

Miguel_Angel_Baeyens — Wed, 08 Sep 2010 11:09:06 GMT

Hello Amar,

Did you debug step by step your script withouth limiting data so you can see when the script fails?

Regards

Script Execution Halt's in between

Wed, 08 Sep 2010 11:26:35 GMT

When you say its hanging is it because the data being loaded is forcing Qlikview to generate lots of complex synthetic keys perhaps? Have a look at the table viewer after doing a load with the limited data volume.

Regards,

Gordon

Script Execution Halt's in between

amars — Wed, 08 Sep 2010 12:49:10 GMT

Hi,

I tried to reload the dashboard without putting the limit on the no of records but still it is getting hanged at a particular point. Also I can reload it with limited no of records (ie. 10 records). & it doesn't form any loops in the structure , so also I don't feel that there is any problem with that. I also tried changing the queries to simple queries but nothing helped. Please suggest something.

Thanks & Regards

Amar

Script Execution Halt's in between

suniljain — Wed, 08 Sep 2010 13:02:04 GMT

Dear Amar,

Pls check Data Modelling. There is loop in data modelling and because of that execution goes in infinite loop.

Regards

Sunil.

Script Execution Halt's in between

amars — Wed, 08 Sep 2010 13:13:06 GMT

No , I there is no loop. I have checked it .

Script Execution Halt's in between

Miguel_Angel_Baeyens — Wed, 08 Sep 2010 15:27:20 GMT

When do the script stop? (what instruction: loading, storing, populating a variable, executing something...) What version of QlikView are you using? Are you QVD documents stored in places where the user running QlikView has permissions to write? Just in case, delete all QVD files in that directory and check that permissions are right.

Does QlikView show any error? Is it using lots of memory when it hangs?

Script Execution Halt's in between

amars — Thu, 09 Sep 2010 07:14:23 GMT

Hi Migul,

I checked , where my execution stopped & found that a query is quite complex. So it is not getting executed. I have a ORACLE database & my query is like

Select wbs.PARENT_ID wbsId_Task
,wbs1.PARENT_ID wbsId_Phase
,'Task' wbsType
,Sum(Case When (ROLE_NAME = 'Designer' or ROLE_NAME = 'Team Member') and SUBSTR(ho.name,1,6)<>'Rework' Then cost.ROLLEDUP_ACTUAL_DURATION Else 0 End) Total_Designer_actMinutes
,Sum(Case When (ROLE_NAME = 'Designer' or ROLE_NAME = 'Team Member') and SUBSTR(ho.name,1,6)='Rework' Then cost.ROLLEDUP_ACTUAL_DURATION Else 0 End) Total_Designer_Rework_actMin
,Sum(Case When (ROLE_NAME = 'Designer' or ROLE_NAME = 'Team Member') and SUBSTR(ho.name,1,6)<>'Rework' Then cost.ROLLEDUP_ESTIMATED_DURATION Else 0 End) Total_Designer_EstMinutes
,Sum(Case When (ROLE_NAME = 'Designer' or ROLE_NAME = 'Team Member') and SUBSTR(ho.name,1,6)='Rework' Then cost.ROLLEDUP_ESTIMATED_DURATION Else 0 End) Total_Designer_Rework_EstMin

,Sum(Case When (ROLE_NAME = 'Reviewer' or ROLE_NAME = 'Team Leader') and SUBSTR(ho.name,1,6)<>'Rework' Then cost.ROLLEDUP_ACTUAL_DURATION Else 0 End) Total_Reviewer_actMinutes
,Sum(Case When (ROLE_NAME = 'Reviewer' or ROLE_NAME = 'Team Leader') and SUBSTR(ho.name,1,6)='Rework' Then cost.ROLLEDUP_ACTUAL_DURATION Else 0 End) Total_Reviewer_Rework_actMin
,Sum(Case When (ROLE_NAME = 'Reviewer' or ROLE_NAME = 'Team Leader') and SUBSTR(ho.name,1,6)<>'Rework' Then cost.ROLLEDUP_ESTIMATED_DURATION Else 0 End) Total_Reviewer_EstMinutes
,Sum(Case When (ROLE_NAME = 'Reviewer' or ROLE_NAME = 'Team Leader') and SUBSTR(ho.name,1,6)='Rework' Then cost.ROLLEDUP_ESTIMATED_DURATION Else 0 End) Total_Reviewer_Rework_EstMin

from INCATPROD.workproject wp, INCATPROD.Hawkobject ho, INCATPROD.Hawkobject rootproj,
INCATPROD.WBSHierarchy wbs, INCATPROD.ObjectRelationship obr, INCATPROD.ProgramCosting cost,
INCATPROD.HawkUser hu
,INCATPROD.role,INCATPROD.OBJECTDATA od, INCATPROD.attribute att,
INCATPROD.OBJECTDATA od1, INCATPROD.attribute att1,
INCATPROD.HawkObject ho1, INCATPROD.WBSHierarchy wbs1
where rootproj.OBJECT_TYPE='Program'
and rootproj.OBJECT_ID=wbs.ROOT_PROJECT_ID and wbs.WBS_ID=ho.OBJECT_ID
and ho.OBJECT_ID=wp.PROJECT_ID and wp.PROJECT_ID=cost.PROJECT_ID
and ho.OBJECT_TYPE in ('SubTask') and ho.OBJECT_ID=obr.FROM_OBJECT_ID and obr.RELATIONSHIP_TYPE in ('TaskMember','SubTaskMember')
and obr.TO_OBJECT_ID = hu.USER_ID
and wp.role_id = role.role_id
and rootproj.OBJECT_ID=od.OBJECT_ID and od.ATTRIBUTE_ID=att.ATTRIBUTE_ID
and att.ATTRIBUTE_ID ='5vhkiqa091200090000221e096'AND
rootproj.OBJECT_ID=od1.OBJECT_ID and od1.ATTRIBUTE_ID=att1.ATTRIBUTE_ID
and att1.ATTRIBUTE_ID ='7sreuo6091200010000221e096'
and wbs.PARENT_ID = ho1.OBJECT_ID
and wbs.PARENT_ID = wbs1.WBS_ID
and (ROLE_NAME = 'Designer' or ROLE_NAME = 'Reviewer' or ROLE_NAME = 'Team Leader' or ROLE_NAME = 'Team Member')
Group by
wbs.PARENT_ID ,wbs1.PARENT_ID;

It is getting executed in ORACLE but getting hanged in Qlikview can u tell some reason. I have 4 such queries so I don't want to break it into again more no of queries to make is simpler. Please Suggest.

Thanks & Regards

Amar