I am able to run the same playbook on jenkins server directtly, not using jenkins job my pymssl : 2.2.7
On Friday, December 1, 2023 at 11:50:16 PM UTC-8 Dick Visser wrote: > What does the server side logs look like? I would increase log verbosity > there > > On Sat, 2 Dec 2023 at 08:05, Narmada Karthika <[email protected]> wrote: > >> 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 >> >> <https://groups.google.com/d/msgid/ansible-project/CABdF8S1ZFz7H%3D4F3esOE7fwhKxNK5qr5iDg1G3Q0BDw%3DGM4kzA%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/66fbe235-81cd-4f1b-bf77-97359be154d0n%40googlegroups.com.
