Query Database Smart Service rdbms.pwd error

Hi All,

I am using the Query Database smart Service where i have placed the URL, username and pwd in the smart service.It works well in one environment ,but when we try t o deploy to a higher environment it doesnot deploy and shows the below error.

[Non-nullable input ACP(s) for unattended node(s) must not be null: ~rdbms.pwd, Non-nullable custom ACP(s) for unattended node(s) must not be null: ~rdbms.pwd] 

Please help