• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

ColdFusion 2016 Update 17 : Websites failing with "The DataSource service is not available"

New Here ,
Mar 24, 2021 Mar 24, 2021

Copy link to clipboard

Copied

Hello CF Community,

 

Not sure if this is a bug, undocumented feature, or edge case, but let's start with the resolution (or workaround) that allowed our servers to come back online:

 

Replace <struct type="coldfusion.server.ConfigMap"> with <struct> under the <var name='CONNECTIONPROPS'> node within each datasource in neo-datasource.xml

 

Now for the problem we faced:

 

After installing Update 17 for ColdFusion 2016 we could no longer reach the ColdFusion Administrator. The 500 Internal Server Error on screen read "The DataSource service is not available." Our database driven websites were also down, but static sites were up and running.

 

On server startup, the server.log file in the ColdFusion logs had the following error:

 

"Error","localhost-startStop-1","03/23/21","10:41:42","","Unable to initialise SQL service: coldfusion.server.ServiceException: coldfusion.server.ConfigMap cannot be cast to coldfusion.runtime.Struct"

 

Comparing the <cf_root>\<cf_instance>\lib\neo-datasource.xml files from 2 different servers, both with CF2016 and update 17, one working and one not, I found the only difference to be a typecast (type="coldfusion.server.ConfigMap") on the struct tag under the CONNECTIONPROPS variable. Removing the typecast resolved the issue.

 

I am not sure how the typecast ended up in the configuration file, but I hope this helps someone in the future resolve their issue quickly.

 

- Nicholas

TOPICS
Connector , Database access , Server administration

Views

127

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 24, 2021 Mar 24, 2021

Copy link to clipboard

Copied

LATEST

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation