[ansible-project] 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

-- 
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-project+unsubscr...@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.