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/CAF8BbLZAG-2uQdROaoBLFSAQwMHpsSF-Ci%2Bu6Jcf4M28vetyeQ%40mail.gmail.com.
