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.

On Fri, Dec 1, 2023 at 10:54 PM Dick Visser <[email protected]> wrote:

> 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
> <https://groups.google.com/d/msgid/ansible-project/CAF8BbLas02MKGvLjoy0_ixB-4oWo0_wWZRYkif_xbggLsjvppQ%40mail.gmail.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/CABdF8S1ZFz7H%3D4F3esOE7fwhKxNK5qr5iDg1G3Q0BDw%3DGM4kzA%40mail.gmail.com.

Reply via email to