Skip to main content
I
iq11
Known Participant
February 14, 2019
Answered

Cold fusion error

  • February 14, 2019
  • 1 reply
  • 1130 views

Hello,

We are using Cold Fusion 2018 on a windows server 2016.

When I try to access a cfm file I get an error, the details of which tell me that I do not have access to a table( dba_data_files) in a query that is being run. When I copied and pasted the same query in my SQL editor I do have access to the table with the same user which the cfm file is supposed to access. I have double checked the data sources in cfm admin page and also the System DSN all are looking to point to the same database and the user. So what could be wrong why am I getting this error ?

Thanks

IQ

Error Executing Database Query. 

  [Macromedia][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist    
  The error occurred in C:/inetpub/wwwroot/TOPS/admin/admin_datafiles.cfm: line 20
18 : 19 : <cfif dbtype is 'oracle'> 20 : <cfquery name="Select2" datasource="#datasource#" UserName="#Session.UserName#" Password="#Session.Password#"> 21 : SELECT file_name, tablespace_name, bytes, blocks, status, autoextensible, maxbytes, maxblocks, increment_by from dba_data_files 22 : </cfquery>
    This topic has been closed for replies.
    Correct answer WolfShade

    We get this error occasionally.  Usually because the synonyms are not in place, or not pointing to the correct table.

    V/r,

    ^ _ ^

    1 reply

    WolfShade
    WolfShadeCorrect answer
    Legend
    February 14, 2019

    We get this error occasionally.  Usually because the synonyms are not in place, or not pointing to the correct table.

    V/r,

    ^ _ ^

    I
    iq11Author
    Known Participant
    February 15, 2019

    Thank you, you are right.

    WolfShade
    WolfShade
    Legend
    February 15, 2019

    Thank you for marking my answer as correct.  I do appreciate it, and I'm sure another user with the same issue will, too.

    V/r,

    ^ _ ^

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