topic Re: Triggers getting deleted by itself in QlikView

Triggers getting deleted by itself

Tue, 23 Jul 2013 12:05:31 GMT

Hi,

I had written so many triggers one hour back in my file, but when i open it now, those triggers are not there in the file.

What might be the problem?

Is there any virus attack to the file?

Re: Triggers getting deleted by itself

Anonymous — Tue, 23 Jul 2013 12:07:50 GMT

Forgot to save?

Re: Triggers getting deleted by itself

Tue, 23 Jul 2013 12:09:38 GMT

May be u hv not saved mistakly..dont think about virus..it will work again create it >Apply>save..

regards-bika

Re: Triggers getting deleted by itself

Tue, 23 Jul 2013 12:38:58 GMT

I saved the file, and i had kept the back up option in settings->user preferences also.

I have two copies of my file, but in those file also i dont have those triggers.

Re: Triggers getting deleted by itself

Anonymous — Tue, 23 Jul 2013 12:49:55 GMT

That probably means that somebody/something overrode the newer version with triggers. For example, you open the file on network, and make changes, and save. Somebody else opened the same file (before you saved), and saved it (with no changes), after you.

Re: Triggers getting deleted by itself

Tue, 23 Jul 2013 16:10:15 GMT

Have you

1. Opened the file with no data?

2. Reduced data

3. Run the load script as a test and have an exit script early on (therefore removing fields from the data model)

Any of the above could cause trigger loss is those triggers are held against fields.

Re: Triggers getting deleted by itself

Wed, 24 Jul 2013 12:20:05 GMT

But i am developing the file in my local laptop. I save it in my system.

So there is no possibility of others using my file at the same time.

Re: Triggers getting deleted by itself

Wed, 24 Jul 2013 12:21:03 GMT

I have opened the file with all data, no reduced data and i did not run the load script.

But also i lost all the triggers which i had written 2hours before i checked it.

Re: Triggers getting deleted by itself

Anonymous — Wed, 24 Jul 2013 12:40:18 GMT

Complete mystery...

Re: Triggers getting deleted by itself

azimabadi — Wed, 24 Jul 2013 13:03:11 GMT

i have exactly the same Problem!

no new idea?

Re: Triggers getting deleted by itself

Tue, 15 Jul 2014 17:35:29 GMT

I am having this same issue.

I have done this:

3. Run the load script as a test and have an exit script early on (therefore removing fields from the data model)... was testing some new load code and did not want to run the full script.

If this is normal behavior in Qlikview, is there a way to "script" these triggers out without having to go through the tedious process of the UI in the document settings, thus having it saved so that it does not have to be retyped when Qlikview deletes it, but can be copied back in?

Is there another way to just have access to the Document Settings "code" and re-add it when Qlikview removes the triggers? I have superficial looked, but have not been able to find such a "code" window.

Re: Triggers getting deleted by itself

mrossoit — Thu, 19 Mar 2015 16:08:08 GMT

Hi all,

today I encountered the same problem.

I noticed that triggers defined on fields disappear only when an exit script instruction prevents the creation of mentioned fields or when the instruction/query responsible for their definition goes into error and you force the script's execution till the end.

On the contrary, opening file with no data and reducing all the data does not make triggers lost.

So I found a workaround that could help.

At the beginning of the script, before any instruction that potentially stops the execution, I created an inline table that lists all the fields with triggers defined on them:

TEMP_TRIGGER_FIELDS:

LOAD * INLINE [

F1, F2, F3

];

(where F1, F2, F3 obviously have triggers)

Then, as the last instruction of the script, I drop table TEMP_TRIGGER_FIELDS so I'm sure at all times fields having triggers will be always present in my qlikview internal database.

I hope this will be useful for anyone.

Max

Re: Triggers getting deleted by itself

Anonymous — Thu, 08 Oct 2015 13:08:55 GMT

I have the encountered the same problem with more than one application. It's not only that the triggers get lost sometimes - I just can't save them. Whenever I open the Document Properties they are already gone. I can't even change a variable values by pressing Apply.

I think it may have to do with the number of fields in an application. The first time I've encountered this problem all went well during months of development... but then it was not possible to add any more triggers. Now I have many hundred fields and QV just doesn't behave how it should.