Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Powershell execution error Expand / Collapse
Author
Message
Posted Wednesday, December 19, 2012 7:59 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, December 4, 2013 12:31 PM
Points: 52, Visits: 359
Greetings,

I have a script that was executing a powershell script from within a batch file with the following syntax:
"“powershell.exe -NoLogo -Noninteractive -Command "& \"%~dp0ScriptName.ps1\" %1; exit "

Everything was working fine until the OS team patched the server and upgraded Powershell to version 3 (it had version 2). After Powershell was upgraded the script failed with the error:

"powershell.exe' is not recognized as an internal or external command, operable program or batch file"

For the time being I have "fixed" the issue by executing powershell with an explicit path:
"C:\Windows\SysWOW64\WindowsPowerShell\v1.0\powershell.exe -NoLogo -Noninteractive -Command "& \"%~dp0ScriptName.ps1\" %1; exit"

Now, this change may make my script functional again, but I don't understand what exactly is going on. What changed when Powershell was upgraded that made the way I was calling the script invalid?

Any information or good links to information would be greatly appreciated.

Thanks!
Kim
Post #1398741
Posted Monday, December 24, 2012 1:47 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:57 AM
Points: 7,080, Visits: 12,571
Chances are the path "%systemroot%\System32\WindowsPowerShell\v1.0\" was removed from the PATH system environment variable. Removing the path to powershell.exe from the PATH variable made it impossible for you to refer to powershell.exe from any random command line location without fully qualifying it.

As a side note the explicit path you decided to prefix your command with, "C:\Windows\SysWOW64\WindowsPowerShell\v1.0\", is the path to the 32-bit version of powershell.exe on 64-bit OS'es. Prior to the upgrade it is likely you were executing your script using the 64-bit version. Chances are it is not making a difference since you said the script is working but I thought it was worth pointing out.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1399990
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse