Skip to main content
D
DJ Smith
Inspiring
March 7, 2011
Question

Query Viewer not working

  • March 7, 2011
  • 2 replies
  • 2101 views

New install of CFB 2 on Win 7 32bit with CF901.

When right clicking on a database table in RDS Dataview I get an error , I get the error "/MyProject/.rdsTempFiles/RDS Query Viewer  does not exist". The same is happening when trying to open the RDS Query Viewer.

This works correctly in CFB 1.

Any suggestions what is going on? Is it a permissions issue or something similar? The .rdsTempFiles directory is created in the /MyProject folder and shows up in the Navigator.

Thanks

Doug

This topic has been closed for replies.

2 replies

C
ccsimmons
Inspiring
January 24, 2012

Answer posted here: http://www.cfchimp.com/wordpress/2012/01/rds-query-viewer-not-working/ as well.

I have had this issue for a while and it finally made me crazy enough to try to figure it out.  It appears that this error occurs when the "RDS Query Viewer" file does not exist in the .rdsTempFiles folder within your project.

On Mac

  1. Open Terminal
  2. Navigate to the directory where your project is located.  For example type: cd /Applications/ColdFusion9/wwwroot/YOURPROJECTFOLDER and hit <enter>
  3. If the ".rdsTempFiles" directory does not exist type: mkdir .rdsTempFiles and hit <enter>
  4. If the "RDS Query Viewer" file does not exist type: touch ".rdsTempFiles/RDS Query Viewer" and hit <enter>.  BE SURE TO SURROUND THE COMMAND WITH THE DOUBLE QUOTES BECAUSE THE FILE NAME HAS SPACES.
  5. Refresh the "RDS Query Viewer" view.  RDS Query View should work now.

On Windows

  1. Open DOS
  2. Navigate to the directory where your project is located.  For example type: cd C:\ColdFusion9\wwwroot\YOURPROJECTFOLDER and hit <enter>
  3. If the ".rdsTempFiles" directory does not exist type: mkdir .rdsTempFiles and hit <enter>
  4. If the "RDS Query Viewer" file does not exist type: fsutil file createnew "RDS Query Viewer" 0 and hit <enter>.  BE SURE TO SURROUND THE COMMAND WITH THE DOUBLE QUOTES BECAUSE THE FILE NAME HAS SPACES.
  5. Refresh the "RDS Query Viewer" view.  RDS Query View should work now.
D
DJ SmithAuthor
Inspiring
March 7, 2011

The RDS error may be caused by having a project with

a name made up of two or more words. For example, "My

Project" causes the problem, but "MyProject" does not.

Could someone else test this?

Thx

K
Kiran Sakhare
Participating Frequently
March 7, 2011

Hi

We are aware of this issue. We are currently investigating this issue.

Thanks

Kiran Sakhare

https://blogs.adobe.com/cfbuilder/

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices