Passing data from ansible to service now table

Diyawary

unread,

May 20, 2020, 3:57:43 AM5/20/20

to Ansible Project

Hi Team,

I am sending data from ansible to service now using uri, data is passing to snow table but job status is not showing successful.

I am getting "The read operation timed out" error ,Please suggest me how this can be resolved

- name: Passing Data to Snow

uri:

url: "https://test.service-now.com/api/eplc/table_update_integration/create"

method: POST

Headers: "application/json"

body: '{"List":{{EPG_all}}, "Region":"NA " }'

body_format: json

user: "{{ snow_username }}"

password: "{{ snow_password }}"

force_basic_auth: yes

status_code: 200

timeout: 10

Stefan Hornburg (Racke)

unread,

May 20, 2020, 8:35:52 AM5/20/20

to ansible...@googlegroups.com

It certainly doesn't help that you reduce the timeout to 10 seconds. Also please post complete error message (without
the credentials).

Regards
Racke

> --
> 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
> ansible-proje...@googlegroups.com <mailto:ansible-proje...@googlegroups.com>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com?utm_medium=email&utm_source=footer>.

--
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration. Provisioning with Ansible.

signature.asc

Diyawary

unread,

May 20, 2020, 9:43:24 AM5/20/20

to Ansible Project

Diyawary

unread,

May 20, 2020, 9:43:46 AM5/20/20

to Ansible Project

Hi Racke,

I have already increase the timeout but still getting the same error.

"Status code was -1 and not [200]: 'The read operation timed out'"

> ansible...@googlegroups.com <mailto:ansible-project+unsub...@googlegroups.com>.

Diyawary

unread,

May 20, 2020, 9:52:29 AM5/20/20

to Ansible Project

Please find the complete tasks out put-

{

"status": -1,

"_ansible_no_log": false,

"url": "https://test.service-now.com/api/eplc/table_update_integration/create",

"changed": false,

"elapsed": 10,

"content": "",

"invocation": {

"module_args": {

"directory_mode": null,

"force": false,

"remote_src": null,

"status_code": [

"200"

],

"follow": false,

"owner": null,

"body_format": "json",

"client_key": null,

"group": null,

"use_proxy": true,

"unix_socket": null,

"unsafe_writes": null,

"serole": null,

"content": null,

"setype": null,

"follow_redirects": "safe",

"return_content": false,

"method": "POST",

"body": {

"Region": "NA - Prod",

"List": [

data

},

"url_username": "****",

"src": null,

"dest": null,

"selevel": null,

"force_basic_auth": true,

"removes": null,

"http_agent": "ansible-httpget",

"user": "",

"regexp": null,

"password": "***",

"url_password": "***",

"url": "https://test.service-now.com/api/eplc/table_update_integration/create",

"backup": null,

"seuser": null,

"client_cert": null,

"creates": null,

"headers": {

"Content-Type": "application/json"

},

"delimiter": null,

"mode": null,

"timeout": 100,

"attributes": null,

"validate_certs": true

}

},

"redirected": false,

"msg": "Status code was -1 and not [200]: 'The read operation timed out'"

Stefan Hornburg (Racke)

unread,

May 20, 2020, 11:08:16 AM5/20/20

to ansible...@googlegroups.com

I would increase the timeout to a ridiculous value like 20 minutes and test if it:

* succeeds
* stops before the timeout exceeded
* stops after the timeout exceeded

Regards
Racke

> > ansible...@googlegroups.com <mailto:ansible-proje...@googlegroups.com>.

> > To view this discussion on the web visit
> > https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com>
> >

> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com?utm_medium=email&utm_source=footer

> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com?utm_medium=email&utm_source=footer>>.
>
>
>
> --
> Ecommerce and Linux consulting + Perl and web application programming.
> Debian and Sympa administration. Provisioning with Ansible.
>

> --
> 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

> ansible-proje...@googlegroups.com <mailto:ansible-proje...@googlegroups.com>.

> To view this discussion on the web visit

> https://groups.google.com/d/msgid/ansible-project/4944655c-f631-419e-a778-7980e4e3020e%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/4944655c-f631-419e-a778-7980e4e3020e%40googlegroups.com?utm_medium=email&utm_source=footer>.

signature.asc

Diyawary

unread,

May 21, 2020, 5:41:35 AM5/21/20

to Ansible Project

Hi Rack,

As you suggested I have increased the timeout to 20 min but still getting the same error and task stops before the timeout value.

> > ansible...@googlegroups.com <mailto:ansible-project+unsub...@googlegroups.com>.

> > To view this discussion on the web visit
> > https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com>
> >
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com?utm_medium=email&utm_source=footer
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com?utm_medium=email&utm_source=footer>>.
>
>
>
> --
> Ecommerce and Linux consulting + Perl and web application programming.
> Debian and Sympa administration. Provisioning with Ansible.
>
> --
> 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

> ansible...@googlegroups.com <mailto:ansible-project+unsub...@googlegroups.com>.

Stefan Hornburg (Racke)

unread,

May 21, 2020, 5:44:49 AM5/21/20

to ansible...@googlegroups.com

On 5/21/20 11:41 AM, Diyawary wrote:
> Hi Rack,
>
> As you suggested I have increased the timeout to 20 min but still getting the same error and task stops before the
> timeout value.
>

So it is most likely that the API causes your problems. Please investigate at that end.

Regards
Racke

>

> > > ansible...@googlegroups.com <mailto:ansible-proje...@googlegroups.com <javascript:>>.

> > ansible...@googlegroups.com <javascript:> <mailto:ansible-proje...@googlegroups.com <javascript:>>.

> > To view this discussion on the web visit
> > https://groups.google.com/d/msgid/ansible-project/4944655c-f631-419e-a778-7980e4e3020e%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/4944655c-f631-419e-a778-7980e4e3020e%40googlegroups.com>
> >

> <https://groups.google.com/d/msgid/ansible-project/4944655c-f631-419e-a778-7980e4e3020e%40googlegroups.com?utm_medium=email&utm_source=footer

> <https://groups.google.com/d/msgid/ansible-project/4944655c-f631-419e-a778-7980e4e3020e%40googlegroups.com?utm_medium=email&utm_source=footer>>.
>
>
>
> --
> Ecommerce and Linux consulting + Perl and web application programming.
> Debian and Sympa administration. Provisioning with Ansible.
>

> --
> 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

> ansible-proje...@googlegroups.com <mailto:ansible-proje...@googlegroups.com>.

> To view this discussion on the web visit

> https://groups.google.com/d/msgid/ansible-project/d331da45-6315-4183-93b4-c40946e580c5%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/d331da45-6315-4183-93b4-c40946e580c5%40googlegroups.com?utm_medium=email&utm_source=footer>.

signature.asc

Diyawary

unread,

May 21, 2020, 6:20:07 AM5/21/20

to Ansible Project

thanks Rack one more thing I have observed sometimes i am getting belwo connection failure and some time Read operation timeout error.

Status code was -1 and not [200]: Connection failure: connection was closed before a valid response was received: ''"

could you please suggest what the possible reason of this two errors.? and in my ansible script has no issue.

> > > ansible...@googlegroups.com <mailto:ansible-project+unsub...@googlegroups.com <javascript:>>.

> > > To view this discussion on the web visit
> > >
> https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com>
> > <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com>>
> > >
> >
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com?utm_medium=email&utm_source=footer
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com?utm_medium=email&utm_source=footer>
>
> >
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com?utm_medium=email&utm_source=footer
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com?utm_medium=email&utm_source=footer>>>.
>
> >
> >
> >
> > --
> > Ecommerce and Linux consulting + Perl and web application programming.
> > Debian and Sympa administration. Provisioning with Ansible.
> >
> > --
> > 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

> > ansible...@googlegroups.com <javascript:> <mailto:ansible-project+unsub...@googlegroups.com <javascript:>>.

> > To view this discussion on the web visit
> > https://groups.google.com/d/msgid/ansible-project/4944655c-f631-419e-a778-7980e4e3020e%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/4944655c-f631-419e-a778-7980e4e3020e%40googlegroups.com>
> >
> <https://groups.google.com/d/msgid/ansible-project/4944655c-f631-419e-a778-7980e4e3020e%40googlegroups.com?utm_medium=email&utm_source=footer
> <https://groups.google.com/d/msgid/ansible-project/4944655c-f631-419e-a778-7980e4e3020e%40googlegroups.com?utm_medium=email&utm_source=footer>>.
>
>
>
> --
> Ecommerce and Linux consulting + Perl and web application programming.
> Debian and Sympa administration. Provisioning with Ansible.
>
> --
> 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

> ansible...@googlegroups.com <mailto:ansible-project+unsub...@googlegroups.com>.

Stefan Hornburg (Racke)

unread,

May 21, 2020, 6:33:22 AM5/21/20

to ansible...@googlegroups.com

On 5/21/20 12:20 PM, Diyawary wrote:
> thanks Rack one more thing I have observed sometimes i am getting belwo connection failure and some time Read
> operation timeout error.
> Status code was -1 and not [200]: Connection failure: connection was closed before a valid response was received: ''"
>
> could you please suggest what the possible reason of this two errors.? and in my ansible script has no issue.

For the third and last time: most likely reason is the *API itself*.

Regards
Racke

> > > > ansible...@googlegroups.com <mailto:ansible-proje...@googlegroups.com <javascript:>

> > > ansible...@googlegroups.com <javascript:> <mailto:ansible-proje...@googlegroups.com <javascript:>

> > ansible...@googlegroups.com <javascript:> <mailto:ansible-proje...@googlegroups.com <javascript:>>.

> > To view this discussion on the web visit

> > https://groups.google.com/d/msgid/ansible-project/d331da45-6315-4183-93b4-c40946e580c5%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/d331da45-6315-4183-93b4-c40946e580c5%40googlegroups.com>
> >
> <https://groups.google.com/d/msgid/ansible-project/d331da45-6315-4183-93b4-c40946e580c5%40googlegroups.com?utm_medium=email&utm_source=footer

> <https://groups.google.com/d/msgid/ansible-project/d331da45-6315-4183-93b4-c40946e580c5%40googlegroups.com?utm_medium=email&utm_source=footer>>.
>
>
>
> --
> Ecommerce and Linux consulting + Perl and web application programming.
> Debian and Sympa administration. Provisioning with Ansible.
>

> --
> 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

> ansible-proje...@googlegroups.com <mailto:ansible-proje...@googlegroups.com>.

> To view this discussion on the web visit

> https://groups.google.com/d/msgid/ansible-project/d1f54e1b-3304-44af-8ae2-7bdfb9e60851%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/d1f54e1b-3304-44af-8ae2-7bdfb9e60851%40googlegroups.com?utm_medium=email&utm_source=footer>.

signature.asc

Diyawary

unread,

May 21, 2020, 6:47:42 AM5/21/20

to Ansible Project

Thanks Racke for you help.

> > > > ansible...@googlegroups.com <mailto:ansible-project+unsub...@googlegroups.com <javascript:>

> <javascript:>>.
> > > > To view this discussion on the web visit
> > > >
> > https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com>
> > <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com>>
> > >
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com>
> > <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com>>>
> > > >
> > >
> >
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com?utm_medium=email&utm_source=footer
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com?utm_medium=email&utm_source=footer>
>
> >
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com?utm_medium=email&utm_source=footer
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com?utm_medium=email&utm_source=footer>>
>
> >
> > >
> >
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com?utm_medium=email&utm_source=footer
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com?utm_medium=email&utm_source=footer>
>
> >
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com?utm_medium=email&utm_source=footer
> <https://groups.google.com/d/msgid/ansible-project/eca3e85e-fbd2-4375-8a80-0649e4aa7103%40googlegroups.com?utm_medium=email&utm_source=footer>>>>.
>
> >
> > >
> > >
> > >
> > > --
> > > Ecommerce and Linux consulting + Perl and web application programming.
> > > Debian and Sympa administration. Provisioning with Ansible.
> > >
> > > --
> > > 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

> > > ansible...@googlegroups.com <javascript:> <mailto:ansible-project+unsub...@googlegroups.com <javascript:>

> <javascript:>>.
> > > To view this discussion on the web visit
> > > https://groups.google.com/d/msgid/ansible-project/4944655c-f631-419e-a778-7980e4e3020e%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/4944655c-f631-419e-a778-7980e4e3020e%40googlegroups.com>
> > <https://groups.google.com/d/msgid/ansible-project/4944655c-f631-419e-a778-7980e4e3020e%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/4944655c-f631-419e-a778-7980e4e3020e%40googlegroups.com>>
> > >
> >
> <https://groups.google.com/d/msgid/ansible-project/4944655c-f631-419e-a778-7980e4e3020e%40googlegroups.com?utm_medium=email&utm_source=footer
> <https://groups.google.com/d/msgid/ansible-project/4944655c-f631-419e-a778-7980e4e3020e%40googlegroups.com?utm_medium=email&utm_source=footer>
>
> >
> <https://groups.google.com/d/msgid/ansible-project/4944655c-f631-419e-a778-7980e4e3020e%40googlegroups.com?utm_medium=email&utm_source=footer
> <https://groups.google.com/d/msgid/ansible-project/4944655c-f631-419e-a778-7980e4e3020e%40googlegroups.com?utm_medium=email&utm_source=footer>>>.
>
> >
> >
> >
> > --
> > Ecommerce and Linux consulting + Perl and web application programming.
> > Debian and Sympa administration. Provisioning with Ansible.
> >
> > --
> > 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

> > ansible...@googlegroups.com <javascript:> <mailto:ansible-project+unsub...@googlegroups.com <javascript:>>.

> > To view this discussion on the web visit
> > https://groups.google.com/d/msgid/ansible-project/d331da45-6315-4183-93b4-c40946e580c5%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/d331da45-6315-4183-93b4-c40946e580c5%40googlegroups.com>
> >
> <https://groups.google.com/d/msgid/ansible-project/d331da45-6315-4183-93b4-c40946e580c5%40googlegroups.com?utm_medium=email&utm_source=footer
> <https://groups.google.com/d/msgid/ansible-project/d331da45-6315-4183-93b4-c40946e580c5%40googlegroups.com?utm_medium=email&utm_source=footer>>.
>
>
>
> --
> Ecommerce and Linux consulting + Perl and web application programming.
> Debian and Sympa administration. Provisioning with Ansible.
>
> --
> 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

> ansible...@googlegroups.com <mailto:ansible-project+unsub...@googlegroups.com>.

David Foley

unread,

May 21, 2020, 10:52:09 AM5/21/20

to Ansible Project

Is the Body Correct ? and that you aren't missing any JSON values?

Reply all

Reply to author

Forward