Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Powershell execution error Expand / Collapse
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, March 9, 2016 11:02 AM
Points: 53, Visits: 376

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.

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



Group: General Forum Members
Last Login: 2 days ago @ 3:25 AM
Points: 7,933, Visits: 14,355
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