Dynamic Updates on Server

[#1]

Hi All,  I have a file with text boxes having Dynamic Update action which works great on my system. But the updates stop happening after deploying it on the server. I have checked all the options for allowing dynamic update inside the file, as well as the options in server QV Management Console. Does anyone have a clue why this may be happening. Do I require a special license for allowing updates on the server. I'm using QV version 11.20

Thanks !

[#2]

Hi Jerry, I have verified with a test that dynamic update is working on the server when I use the equality '=' condition. But it doesn't work when I use >,<,>= or <=.

The user is a part of the administrative group. The update you suggested with vUserDateMinusOne still has the > symbol so it will not work for me.

Thanks for the suggestions though.

[#3]

Hi Malek. In this case the user is in the administrators group. The dynamic update is working on the server with equality '=' condition only and not with <,<=,> or >=

Thanks

[#4]

Hi Bill, I do not have this line in my license. I guess it could be an issue but I'm still able to do dynamic updates on server when I use just the = condition

This line works on server:

UPDATE Data_Table SET Limit_Interest=$(vUserLimit) WHERE Limit_Date = '$(vUserDate)';

This doesn't work:

UPDATE Data_Table SET Limit_Interest=$(vUserLimit) WHERE Limit_Date > '$(vUserDate)';

I'm guessing that if I was restricted by license then the first line may not have worked either.

Thanks,

Varun

[maleksafa]

Hi,

there is nothing special in the license that you should have, only the user security permissions must be applied, i have already faced the same issue where it worked on the server but not from the access point, and i did open a CRM ticket with qliktech and they have only requested to add the user that is using the dynamic update to the qlikview administrator group.