ColdFusion 9 Server Manager can read everything but Datasources

Report · Jan 05, 2010

I am attempting to use the new Server Manager feature in CF9. I can connect to my webservers with Server Manager and I receive the following error:

"Failed to read the data sources from SERVERNAME. Continue to read mappings from SERVERNAME" YES/NO

If I click Yes then I can view all properties of the server, except the data sources. The strange thing is that if I create a new data source, it is successful. I can even apply the new datasource to other CF9 servers! If I log out of Server Manager and re-launch, I can no longer view the previous data source that I created.

Anyone have any ideas why I can't view my CF9 data sources from Server Manager?

Report · Jan 07, 2010

Is anyone running CF9? Have they tried using the Server Manager? Does everything work correctly?

Report · Dec 01, 2010

I am encountering the same issue. As far as I can tell I have the properties for all servers set correctly.

The default server (cfusion) is able to be fully ingested into the server manager but the other instances encounter an error when reading in the data sources.

Report · Dec 01, 2010

I initially backed up my CF MX7 data sources and imported them in to CF9. I think this caused the issue. When I literally removed every data source and readded them, I was able to manage the data sources through the new console. This was quite a pain, since I had 80+ data sources, but once done I was able to push the changes to the other CF9 servers.

Report · Apr 24, 2011

I'm having the same issue - did you re-add the Datasources via the Server Manager or via the regular ColdFusion Administrator? What a pain this is going to be.

Report · Apr 25, 2011

I added them both with Server Manager and the CF Admin page. Both worked fine AFTER I removed every single datasource and started fresh. It took forever, but I'm glad I did it since we have so many CF Servers and I will only have to make a change once going forward.

Report · Apr 25, 2011

The good news is once you add them by hand you can back them up using a CAR and have them be portable to any other instance.

I haven't tried going from CF8 to CF9, we have a limited footprint of CF8 servers.

Report · Dec 01, 2010

That is exactly how I got them into my new instance. I will have to try out your fix, thanks!