I encounter some troubles executing a powershell script during deployment.
My goal is to use SqlPlus to execute some sql scipts on my DB, but, because i got some special chars, I must set a specific code page and nls_lang…
I am able to make this work when i’m connected remotly to my server, but when i copy my powershell script on an octopus powershell process, some commands don’t work :
Invoke-Expression “chcp”
this command should print the current Active code page but i can’t retrieve the value neither set the new one.
It might be due to the account executing the script while deploying?
Can anyone give me an hint on that please?
Welcome to the community Are you able to send me the error you get while running that command? Perhaps the task logs as well.
I just tried running it myself on a test server and it worked OK. I doubt it would be a permissions issue. Here are some screenshots of the output + config of how I ran the command.
OK, no worries. Here’s a couple of ideas we can try. Instead of using Invoke-Expression, can you tell me if either of these variants give you any output?