On Monday, February 26, 2018 at 9:46:50 AM UTC-6, Kai Stian Olstad wrote:
>
> On Monday, 26 February 2018 07.15.27 CET Raja Shekar wrote:
> > - debug: var=groups_out.stdout_lines
> >
> > - name: Update the Client Schema
> > shell: source ~/.bash_profile && sqlplus -S '{{ item.1.groups_out
> }}/{{
> > item.2.groups_out }}@{{ item.4.groups_out }}'
> > @"roles/oracle-sql/files/Scripts/client_hotfix.sql" {{ item.0.groups_out
> }}
> > sudo: no
> > with_items: "{{ groups_out.stdout_lines }}"
> >
> >
> > Failing with below error message
> >
> > fatal: [10.202.98.198]: FAILED! => {"failed": true, "msg": "The task
> > includes an option with an undefined variable. The error was: 'unicode
> > object' has no attribute 'groups_out'\n\nThe error appears to have been
> in
> > '/etc/ansible/playbooks/database/roles/oracle-sql/tasks/main.yml': line
> 57,
> > column 5, but may\nbe elsewhere in the file depending on the exact
> syntax
> > problem.\n\nThe offending line appears to be:\n\n\n - name: Update the
> > Schema info\n ^ here\n\nexception type: <class
> > 'ansible.errors.AnsibleUndefinedVariable'>\nexception: 'unicode object'
> has
> > no attribute 'groups_out'"}
>
> It says item.X.groups_out do not exist.
> You would need to show you the content of groups_out.stdout_lines
>
> g
> --
> Kai Stian Olstad
>
Hello Kai,
Thanks for looking into this. here is the content of
"groups_out.stdout_lines"
"groups_out.stdout_lines": [
"\"DB_SCHEMA\",\"SYSTEM_USER\",\"SYSTEM_PASSWORD\",\"TNS_NAME\",\"TNS_DESCRIPTION\"",
"\"Client_Schema1\",\"user\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
"\"Client_Schema2\",\"user\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
"\"Client_Schema3\",\"user\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
"\"Client_Schema4\",\"user\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
"\"Client_Schema5\",\"user\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
"\"Client_Schema6\",\"user\"password\",\"TNS_NAME\",\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\"",
]
}
--
You received this message because you are subscribed to the Google Groups
"Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/e24215d2-fe0a-48f0-86d3-c3530ed03ed3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
