tracker issue : CFB-3752892

select a category, or use search below
(searches all categories and all time range)

SQL Editor window not loading available Datasource names for selection

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/

Reporter/Name(from Bugbase): Mitch Scimemi / mes829 (Mitch Scimemi)

Created: 04/30/2014

Components: Editor Features

Versions: 3.0

Failure Type:

Found In Build/Fixed In Build: PublicBeta /

Priority/Frequency: Major / All users will encounter

Locale/System: English / Windows 7 SP1 64-bit

Vote Count: 0

Problem Description:  SQL Editor window not loading available Datasource names.

Steps to Reproduce:  Connect to web server running Coldfusion 10 Enterprise via RDS.  Open or create new CFM page. Right click on page and select SQL Editor from popup window. When SQL Editor window opens the Server name drop down selection box is populated with existing servers added via RDS configuration.  

Actual Result: When clicking the Datasource drop down selection box there are NO datasources to choose from when there should be many available.  Selecting a different server has no effect on the datasource drop down selection box as none ever populate.

Expected Result:  Expectations are to see the available datasources in the drop down selection box.

Any Workarounds:  NONE

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3752892

External Customer Info:
External Company:  
External Customer Name: mes829
External Customer Email:  
External Test Config: My Hardware and Environment details:

PC Hardware/Software: Intel Core i7 CPU 970 @ 3.20 GHz with 12 GB RAM running Windows 7 Professional - 64bit

ColdFusion Builder 3.0.0 Build 289860



This issue is found in the released production version of Coldfusion Builder 3.0.
Comment by External U.
27113 | April 30, 2014 08:02:26 AM GMT
The scenario is like this - if server is not up while trying datasource code assist, it does not get refreshed even after starting and connecting to the server. The datasource code assist still does not show anything, even though server is connected and has datasources (that can be viewed in RDS view). (Comment added from ex-user id:dsarkar)
Comment by Adobe D.
27114 | May 15, 2014 03:59:20 AM GMT
I can't reproduce this issue. Make sure you have following settings on in the Preferences ->ColdFusion->Server Settings. Select 'Build server settings' and all remaining options (or if you just want to build server settings when server is started then select only one option - 'Server started')
Comment by Ram K.
27115 | July 14, 2014 03:59:56 AM GMT
In case your RDS Connection is all fine and the server has been started after the SQL Editor dialog window was open, you might need to click on "Refresh" to see the data sources. Else, it should work just fine. (Comment added from ex-user id:prk)
Comment by Adobe D.
27116 | October 28, 2015 03:26:28 AM GMT
Closing this bug. In case, you are still facing the issue, please let us know, we will reopen this bug. Thanks, Priya. (Comment added from ex-user id:prk)
Comment by Adobe D.
27117 | December 22, 2015 12:26:46 AM GMT