Post reply

Zip job keeps failing

  • September 23, 2004 at 5:55 am

    #109652

    Hi,

    I have a DTS job (written by somebody else) which runs some SQL & then outputs this to a CSV file. The last part of the process compresses the file into a zip file using the following command.

    C:\Progra~1\WinZip\Winzip32.exe -a -ex using Wscript.shell (method Run)

    The Sqlserver installation is on a 2 node cluster on Windows 2003. When running on one node, everything is fine. When running on the other node the job will not run the zip part of the process.

    I have confirmed on both nodes that Winzip is installed & I have also run the DTS package manually (which works ok).

    I have also checked permissions & everything seems ok.

    Just to make sure it wasn't a problem with Winzip I installed another zip utility 7z I then created a quick & dirty DTS package which ran the zip using the 7z.exe command line (using an execute task). This also runs fine when running interactivally. But as soon as I run it as a batch job the process just continuelly runs.

    Any ideas?

     

    Many thanks

    Pete

  • September 23, 2004 at 6:14 am

    #524137

    It sounds like your style of cluster is the type that does not share a physical hard drive since you had to make sure Winzip was installed on both machines. Is the CSV file always being written to the 1st node's hard drive? Is the compression being requested against a path relative to the local hard drive? If so then the second node will not see the file on the first node.

    Since you were able to run the command outside of the DTS package this probably isn't the cause of the problem, but depending on exactly how you did that test it could still be the problem.

    I'm not familiar with Wscript.shell and so can't speak to its compatibility with launching GUI applications or any tricks it may require. Sorry about that.

     

  • September 23, 2004 at 6:23 am

    #524140

    Hi Aaron,

    Thanks for your reply, sorry I didn't say... The directory is on a SAN which is attached to both nodes (F: drive)

    What is strange is that the DTS job doesn't fail. It just keeps on running.

    There are no error messages in the application log or the DTS package logs.

    Regards

    Pete

  • September 24, 2004 at 10:01 am

    #524366

    Not sure about your configuration, but you may need to use UNC convention  (\\server\path\file.ext)

  • September 24, 2004 at 10:10 am

    #524367

    Ah ok, I'll give that a go, I assumed because the F: drive was mounted from the SAN on both servers (one node offline one node online) that Iwould be ok.

    I'm not in the office at the moment, I will try that on Monday.

    Thanks

    Pete

  • September 24, 2004 at 2:28 pm

    #524394

    This might sound like a stupid question, but are you sure a registered copy of winzip is on the second node?  Even if you have all the switches right and you're using the winzip commandline utility, the unregistered version will always throw up a prompt that requires user interaction.  I'm not sure how this works with a wscript shell command... I've always used xp_cmdshell to initiate winzip from sql server.  Good luck.

  • September 26, 2004 at 10:27 am

    #524431

    HI Robert,

    Thanks for the reply.. Yep I have logged onto both nodes & manually performed the winzip operation manually (switching the node at the same time)

    Pete

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply