topic Re: Creation of QVW document from command line and Getting Error "Failed to open document" in QlikView

Creation of QVW document from command line and Getting Error "Failed to open document"

Thu, 19 Feb 2015 13:59:54 GMT

hello ,

on using the command line prompt "

C:\"Program Files <x86>"\qlikview\qv.exe /r D:\Readmission\04022015\PACRN.QVW

am getting an error "Failed to open Document" as shown in Attached doc "command_line_Qvw.docx" ..

can you please me to analyze the cause and solutions.

Re: Creation of QVW document from command line and Getting Error "Failed to open document"

mukesh24 — Thu, 19 Feb 2015 14:06:14 GMT

can u please attach QVW...

Re: Creation of QVW document from command line and Getting Error "Failed to open document"

Thu, 19 Feb 2015 14:08:37 GMT

am creating an Empty QVW file for the first time.

Re: Creation of QVW document from command line and Getting Error "Failed to open document"

Thu, 19 Feb 2015 14:10:19 GMT

hi Mukesh,

am able to create a QVW file from source control provider .

Get latest version from source control folder <PACR_Layout>.
Copied all XML/DAT files of a Qlikview document from source control folder <PACR_Layout>.

· Create a local folder with a naming model <Qlikview file name-Prj> attaching a “-Prj” Extension is a must.

e.g. PACR is the original Qlikview document name and local folder name creation should be

“< PACR-prj>”.

· Drop all XML/DAT files into the local folder “<PACR-prj>”.

· Create a new empty Qlikview document by the same name (PACR.Qvw) and save it in the same path where local directory folder got saved.

· Close the empty Qlikview document.

· Open Qlikview document again where all objects and codes will then be copied from <PACR-prj> folder.

· Reload the data manually.

but not able to do it via command line

Re: Creation of QVW document from command line and Getting Error "Failed to open document"

mukesh24 — Thu, 19 Feb 2015 14:21:25 GMT

why u creating .prj file?

Re: Creation of QVW document from command line and Getting Error "Failed to open document"

jonathandienst — Thu, 19 Feb 2015 14:56:11 GMT

Make sure that the read-only flag is not set for the files you copied from your source control system.

HTH

Jonathan

Re: Creation of QVW document from command line and Getting Error "Failed to open document"

buzzy996 — Thu, 19 Feb 2015 15:03:05 GMT

try this,

"C:\Program Files <x86>\qlikview\qv.exe" /r "D:\Readmission\04022015\PACRN.QVW"

Re: Creation of QVW document from command line and Getting Error "Failed to open document"

Fri, 20 Feb 2015 06:05:27 GMT

am getting the command line error "Filename, Directory name or volume label syntax is incorrect."

do we have to add the path in evironment variable PATH=C:\Program Files <x86>\qlikview\ '

done that , still error ...please advise

Re: Creation of QVW document from command line and Getting Error "Failed to open document"

buzzy996 — Fri, 20 Feb 2015 13:49:14 GMT

no need to add in env virable,

are u tried to place the same path and execute?

please share screenshot of ur command line?

tht should be work!

Re: Creation of QVW document from command line and Getting Error "Failed to open document"

Mon, 23 Feb 2015 04:48:58 GMT

added the error command line screenshot

Re: Creation of QVW document from command line and Getting Error "Failed to open document"

buzzy996 — Thu, 26 Feb 2015 12:56:25 GMT

are u created that .qvw locally? if not check whether ur having access or not?

check the qlikview installed in same path as u mentioned above?

check the .qvw avilable on same path as u mentioned on above?

if everything is correct,then place the above command shared by me in.bat file ans try to schedule through task scheduler and update me back wht kind of issue ur facing!

Re: Creation of QVW document from command line and Getting Error "Failed to open document"

awhitfield — Thu, 26 Feb 2015 13:06:51 GMT

HI Donesh, what do you mean by this:

"am creating an Empty QVW file for the first time."

Do you mean you are actually trying to create the .qvw from .prj by using a bat file, but the QVW currently doesn't exist?

Re: Creation of QVW document from command line and Getting Error "Failed to open document"

Fri, 27 Feb 2015 05:29:37 GMT

yes ..made a -Prj folder in the named path storing all QVW metadata files ( XML, BAT) and am creating a new QVW file via command line in the same path where -prj folder is stored., so that am expecting to open a new QVW file whereby it copies all codes and layout from -prj folder.

Re: Creation of QVW document from command line and Getting Error "Failed to open document"

awhitfield — Fri, 27 Feb 2015 09:02:59 GMT

The command you are using is to open a file that already exists, it won't actually create one.

Re: Creation of QVW document from command line and Getting Error "Failed to open document"

Peter_Cammaert — Fri, 27 Feb 2015 09:43:13 GMT

I used the same steps on a document that I knew would reload without issues. It works like a charm.

The first error you encountered seems to me about a filename mismatch. The second error ("The file name, directory name, or volume label...") only occurs if your path specification contains invalid/hidden characters.

I would suggest to try with a simplified setup. Copy your empty document and the -prj folder to a common directory like C:\Temp. Rename the QVW file so that its name contains only characters and digits. Try again until you get the reload running. At that point, it doesn't matter that the script cannot find essential data files.

Re: Creation of QVW document from command line and Getting Error "Failed to open document"

Peter_Cammaert — Fri, 27 Feb 2015 09:46:31 GMT

Where was my head? Could it be this simple?

The < and > characters are illegal in Windows paths and filenames.

Re: Creation of QVW document from command line and Getting Error "Failed to open document"

awhitfield — Fri, 27 Feb 2015 10:05:16 GMT

Hi Peter,

I read this that Donnesh is trying to CREATE the qvw, see above, it doesn't even exists, so how can it be opened and reloaded!

Re: Creation of QVW document from command line and Getting Error "Failed to open document"

Peter_Cammaert — Fri, 27 Feb 2015 10:21:31 GMT

Probably a mistake in Donnesh's post. The instructions here http://community.qlik.com/message/717410#717410 (step 5) say that you have to create an empty QVW before opening & merging the -prj objects (using the command line Donnesh is fighting with) will be possible. An empy QVW with the right file name can be obtained by a simple COPY command from an existing empty QVW.

Still, whatever he tries next will surely fail due to an illegal path spec.

Re: Creation of QVW document from command line and Getting Error "Failed to open document"

awhitfield — Fri, 27 Feb 2015 11:30:48 GMT

See the reply at 27-Feb-2015 00:29 - I ask if he was trying to create the file and the reply says yes!