5 Replies Latest reply on Dec 19, 2016 3:29 PM by Bill Robinson

    How to change defult path of STAGING_DIR while deploying

    Syam Chilakala

      Is there any way to change the default path of staging directory while deploying a package ?

       

      My server default STAGING_DIR set to C:\TEMP\stage on every windows servers. While deploying the package BSA creating 3 long-name subfolders inside c:\temp\stage folder which some times causing the setup to fail. So, I would like my BSA package to run from C:\TEMP\stage\<pkg_Name> rather then  C:\Temp\stage\ XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX \ XXXXXXX.X\MSI\setup.exe.

        • 1. Re: How to change defult path of STAGING_DIR while deploying
          Bill Robinson

          why do you think the log path name is causing the install to fail ?  do you have an error indicating this ?

          • 2. Re: How to change defult path of STAGING_DIR while deploying
            Syam Chilakala

            Error 65011 - %DATE_TIME% UTC - SQL Server 2014 Client Tools 12.0.4459.0 installation failed, please check the log files at C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log.

            Once changed the STAGING_DIR to c:\temp\pkg, the deployment is successful.

             

            • 3. Re: How to change defult path of STAGING_DIR while deploying
              Bill Robinson

              ok, and what's in the log file ?  the path limit is 256 characters on windows iirc - is that being exceeded ?

              • 4. Re: How to change defult path of STAGING_DIR while deploying
                Syam Chilakala

                Hi Bill, Yes the path limit is 275 here as below.

                C:\Temp\stage\f41ed2401ae23378ae753700ba3d4643\6440143.1\MSI\Install\setup.exe /Q /ACTION=install /FEATURES=Tools,BC,BOL,Conn,SSMS,ADV_SSMS /UpdateEnabled=TRUE /UpdateSource="C:\temp\SQL2014\Updates"  /HIDECONSOLE /IACCEPTSQLSERVERLICENSETERMS /SKIPRULES=RebootRequiredCheck

                 

                After shorting the path, deployment is getting success.

                <C:\Temp\SQL2014 \Install\setup.exe> /Q /ACTION=install /FEATURES=Tools,BC,BOL,Conn,SSMS,ADV_SSMS /UpdateEnabled=TRUE /UpdateSource="C:\temp\SQL2014\Updates"  /HIDECONSOLE /IACCEPTSQLSERVERLICENSETERMS /SKIPRULES=RebootRequiredCheck

                 

                So is there any way we can control from BSA side ?

                 

                - Thank You.

                • 5. Re: How to change defult path of STAGING_DIR while deploying
                  Bill Robinson

                  the 'path' of the setup.exe' is not 275 characters.  it's 78:

                  % echo "C:\Temp\stage\f41ed2401ae23378ae753700ba3d4643\6440143.1\MSI\Install\setup.exe" | wc -c

                        78

                   

                  now, the entire set of args is over the 250 limit:

                  cyclonus% echo "C:\Temp\stage\f41ed2401ae23378ae753700ba3d4643\6440143.1\MSI\Install\setup.exe /Q /ACTION=install /FEATURES=Tools,BC,BOL,Conn,SSMS,ADV_SSMS /UpdateEnabled=TRUE /UpdateSource="C:\temp\SQL2014\Updates"  /HIDECONSOLE /IACCEPTSQ

                  LSERVERLICENSETERMS /SKIPRULES=RebootRequiredCheck" | wc -c

                       269

                   

                  so if that's an issue, why don't you 'cd' into the install directory first before running the setup.exe?  you should be able to do:

                   

                  cd ??SOURCE??\MSI\Install

                  setup.exe /Q /ACTION=install /FEATURES=Tools,BC,BOL,Conn,SSMS,ADV_SSMS /UpdateEnabled=TRUE /UpdateSource="C:\temp\SQL2014\Updates"  /HIDECONSOLE /IACCEPTSQLSERVERLICENSETERMS /SKIPRULES=RebootRequiredCheck

                   

                  where ??SOURCE?? will resolve to C:\Temp\stage\f41ed2401ae23378ae753700ba3d4643\6440143.1\