topic QVD Refresh time is not coming in QlikView

QVD Refresh time is not coming

Anonymous — Tue, 19 Mar 2013 15:17:42 GMT

Hi ,

I tried to retrieve the qvd refresh time by using below command. but I am always getting null value?.

LET vQVDLastRefresh = QvdCreateTime('D:\tmp\3_QVD\Layer_2\AUM_Journey_DB_Test_March_18_Final_backup_18Mar2013.QVD');

Any Idea?.

Thanks

Dasu.G

jonathandienst — Tue, 19 Mar 2013 15:25:26 GMT

Well just some guesses:

The file does not exist.
Although it as a qvd extemsion it is not actually a qvd (ie internal format is not QVD and does not contain XML header).
The security context under which the script is running does not have access to the QVD location.

I suspect the second as the most likely.

Jonathan

Anonymous — Tue, 19 Mar 2013 16:12:41 GMT

File exists and I checked there is an XML header. I am running it from my local machine.. Still issue exists..

Wed, 20 Mar 2013 07:30:22 GMT

Hi,

use,

LET vQVDLastRefresh= timestamp(QvdCreateTime('D:\tmp\3_QVD\Layer_2AUM_Journey_DB_Test_March_18_Final_backup_18Mar2013.QVD'));

Regards,

Snehal Nabar

Anonymous — Fri, 22 Mar 2013 19:34:27 GMT

Hi I am trying to use below still vQVDLastRefresh time is coming as null.

LET vQVDLastRefresh= timestamp(QvdCreateTime($(vQVDLevel2Path)Journey.QVD));

But below path is working fine..

LET vQVDLastRefresh= timestamp(QvdCreateTime('D:\tmp\3_QVD\Layer_2AUM_Journey_DB_Test_March_18_Final_backup_18Mar2013.QVD'));