Hello, I’m trying to send an SQL query, captured as a String on Jenkins to Octopus but getting an issue when trying to deploy the release from command line. I’m getting below error from Jenkins:
Creating release… Release 12 created successfully! INFO: deployReleaseExpression: /opt/Octo/Octo deploy-release --project=MARS_UTILITY --releaseNumber=12 --deployto=Qualification --server=http://10.20.0.113 --apiKey=API- --deploymenttimeout=00:01:00 --variable=SqlQuery:“select * from dso.t_user where id_user=‘8a9483ef5621e47701562702beed0164’;” --progress Octopus Deploy Command Line Tool, version 1.0.0
Unrecognized command arguments: CICDTools, from, dso.t_user, where, id_user=‘8a9483ef5621e47701562702beed0164’;" Exit code: -1
However, I have to issue to deploy the release, created by command line from Jenkins via the Octopus admin console.
Kindly advise at your earliest as we are blocked by this issue.