Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unfinishing executions of PowerShell scripts with ODI 11G

1533004Feb 7 2014

Hi everyone, we're trying to run a script on a Windows Server 2008 R2 with ODI11g Agent installed. If we launch any .bat script within an ODI procedure the execution finishes ok, but if what we try to launch a powershell command (by direct command or through a ps1 script) the procedure lasts forever and never ends. For instance we configure a procedure like:

%SystemRoot%\system32\WindowsPowerShell\v1.0\powershell.exe -Noninteractive -ImportSystemModules "Get-ADUser -Filter {Office -eq "Office_1"} | Set-ADUser -Department "Staff""

or

%SystemRoot%\system32\WindowsPowerShell\v1.0\powershell.exe -Noninteractive -ImportSystemModules -file PS_script.ps1

And the result is always the same: a neverending execution.

These commands run fine if we schedule them in OS or if we execute them directly.

Have anyone of you dealed with ODI and Powershell commands?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2014
Added on Feb 7 2014
#11g, #business-intelligence-applications, #data, #data-integrator, #odi, #oracle, #procedure, #system-management-and-integration
0 comments
1,281 views