AnsweredAssumed Answered

Provision command not picking up Job Variable

Question asked by Paul Cherrier on Nov 6, 2018
Latest reply on Nov 6, 2018 by Boris Lekumovich

I have Select node that generates a random password and sets it as a Job variable. However when I go to reference that variable in the Provision command, the command fails with an oracle error. Is there a standard way to reference these variables beside ${jobUserData_***?

 

Root Exception stack trace: java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) + 3 more (set debug level logging or '-Dmule.verbose.exceptions=true' for everything) 

 

I set the variable in the log statement so I know it's populated.

 

 

Example node query

 

 

Provision Command

Outcomes