That sounds like something specific to your script, which entirely depends
on your environment


Sent from Gmail Mobile


On Sat, 2 Dec 2023 at 02:43, Narmada Karthika <[email protected]> wrote:

> I am getting below error when trying to execute an Insert mssql query, the
> row is getting inserted but somehow failing with this
> Statement not executed or executed statement has no resultset
> this is my playbook
>
> - name: Insert into sql server
>       community.general.mssql_script:
>         login_user: 'username'
>         login_password: "{{ mssql_login_password }}"
>         login_host: "{{ mssql_server }}"
>         login_port: "{{ mssql_port }}"
>         db: testdb
>         script: "insert into [Test].[RP].[ApplicationCategory] values
> (NULL,NULL,'xyz','repo',NULL,getdate(),1,NULL,'xyz',NULL,'xyz')"
>       tags: jenkinsjob
>
> --
> 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 view this discussion on the web visit
> https://groups.google.com/d/msgid/ansible-project/05b03769-32fb-427b-889c-e5ade3b7767bn%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/05b03769-32fb-427b-889c-e5ade3b7767bn%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>

-- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/ansible-project/CAF8BbLas02MKGvLjoy0_ixB-4oWo0_wWZRYkif_xbggLsjvppQ%40mail.gmail.com.

Reply via email to