Statement not executed or executed statement has no resultset

[Narmada Karthika]

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

[Narmada Karthika]

correcting the yml formatting

- 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

[Dick Visser]

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

Sent from Gmail Mobile

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/05b03769-32fb-427b-889c-e5ade3b7767bn%40googlegroups.com.

[Narmada Karthika]

I don’t think so, I see some others also had this issue on stack overflow, but that solution is giving me another error character max size.

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAF8BbLas02MKGvLjoy0_ixB-4oWo0_wWZRYkif_xbggLsjvppQ%40mail.gmail.com.

[Dick Visser]

What does the server side logs look like? I would increase log verbosity there

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CABdF8S1ZFz7H%3D4F3esOE7fwhKxNK5qr5iDg1G3Q0BDw%3DGM4kzA%40mail.gmail.com.

[Narmada Karthika]

I am able to run the same playbook on jenkins server directtly, not using jenkins job

my pymssl : 2.2.7

[Narmada Karthika]

Any other suggestions?

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/66fbe235-81cd-4f1b-bf77-97359be154d0n%40googlegroups.com.

--

 Thanks,

Narmada Karthika Chitturi

 

[Dick Visser]

On Mon, 4 Dec 2023 at 17:15, Narmada Karthika <chitt...@gmail.com> wrote:

I am able to run the same playbook on jenkins server directtly, not using jenkins job

Then problem is with 'using jenkins job', ie how ansible is invoked, not with ansible itself.

Also, what did the logs on the server side tell you?

[Narmada Karthika]

I think I fixed the issue I added ;Select 1 this at the end of the insert statement and that fixed the issue when running mssql module to run an Insert query through jenkins console