Error while Testing DataSource Connection

If you are getting Node Related Error and giving Invalid username and password while testing the Data Source connection.

This error is not due to invalid username and password .It occur if do not restart nodeagent and dmgr after creating DataSource.
so Recommendations before Testing newly created Data Source are.

1.restart nodeagent.
2.restart dmgr
3.Now test the DataSource connection.

Even after if you are getting Test Connection Error then problem may be with other things dig into to systemOut,systemErr logs for problem that is causing the issue.

shell script is not executing due to ^M at the end of each line in script file

This is due to unix conversion.we can see this type of ^M symbols when script file is copied from one host to other.

Run the below command

#dos2unix afile.sh afile.sh

after running the above command you will get file without ^M at the end.
Note: try to run this command using root user

Note : if you are getting ^M during execution time of script check provided environment details provided in script file are correct or not.