Items need to be restarted when data source is changed.

This is a very strange issue that we have faced during our testing.
We created a data source and were testing in dev environment.

Everything was working fine and then came the need to change the data source.

We just went to the admin console and edited the existing data source to point to the new connection pool.

Once we made and saved the changes it said " 1 Item need to be restarted"

Not sure of what exactly we did mistake we tested our interface and we found that it is not actually pointing to the new connection poll.

Well the reason are not yet known to me as in my local environment i can not see this issue of changing the data source however in the business box we faced this issue.

So a plane solution for this issue is to restart the server and this will behave normally however we came across one new solution which might help the admin guy not to restart the server.

That is to untarget and target the data source.



Go to the data source which you have changed.

deselect the server to which the data source is targetted and save the changes.




Once the changes are save, Again target your data source to the server and save the changes.



You are now done with the changes. If you will test now the process will point to the new connection pool.