April 2, 2021
COLDFUSION 2021 MIGRATION FROM COLDFUSION 11 ISSUE
Comments
(1)
April 2, 2021
COLDFUSION 2021 MIGRATION FROM COLDFUSION 11 ISSUE
Newbie 2 posts
Followers: 1 people
(1)

I am trying to go from ColdFusion 11 to ColdFusion 2021 and I am having issues with the Datasource connection in the Administrator.  I can verify that the datasource is working and connecting properly to my Oracle database but when I try and select the edit button I get the following error:

Element urlmap.servicename is undefined in STDSN.  The specific sequence of files included or processed is f:coldfusion2021/cfusion/wwwroot/administrator/datasources/oracle.cfm, line:653.

When I try and open this file it shows that it is encrypted and I cannot read the data.

1 Comment
2021-04-05 22:17:35
2021-04-05 22:17:35

Yes, there is a “fix” for this (at least a workaround).  To be clear, the problem is not in the cfm file you were looking at (Adobe encodes their templates so that they are not readable). Instead, the problem is in the underlying XML file that holds information about your datasource. And it seems to be a bug related to importing settings from an earlier version. Can you confirm if you or someone did that?

Anyway, the “good” news is that this same issue was raised about a month ago as a question in the Community forums (you have asked here instead in the CF portal, which is fine), and the author of that eventually shared a workaround that worked for him, in one of his last comments. (See a follow-on comment I just added there, right after his, which may help you as you parachute into that thread, to try his solution.)

FWIW, he also opened an Adobe Tracker bug report on the issue, but it is as yet not resolved (or even acknowledged by Adobe), so it does NOT seem to be in the CF2021 update 1 that came out a couple of weeks ago.

Let us know if that work-around works for you. It’s a bit fiddly. If you feel unsafe doing it, you can hire someone to help (myself included, at carehart.org).

Like
Add Comment