Unsure of error

[Arion23]

Hi all,

Recently, any time an SQL query is performed in our ColdFusion setup, the same error is generated (an example is attached below). I can't find a problem with the CFML, our CF Admin guy can't find a problem with with the configuration (his experience is limited tho') and the Oracle guy believes this is more of a CF problem than ColdFusion.

Can anyone offer any thoughts as to what might be the cause of the problem, and suggestions on fixes?

Example error: this was generated by a simple CF page, performing a basic SELECT query on a table (with about 12 fields, 15 rows)

Oracle Error Code = 12154
Error while trying to retrieve text for error ORA-12154 

SQL = "SELECT * FROM INT_LIBFORM_MEMB"
Data Source = "INT"

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:1) to (9:40) in the template file /opt/apache/htdocs/test/libdev/dgtest.cfm.

 

[tleish]

Whenever you see an error like this, it's the database not ColdFusion. It may be that the ColdFusion code has written an incorrect query somehow, but it is not a "ColdFusion Error". Try running the query against the db directly, outside the CF environment.

I also noticed it states:
Data Source = "INT"

Is your datasource really INT, or is it not able to read the "_" in "INT_LIBFORM_MEMB"?

The other thing to check is the Oracle driver. I worked on a project recently where they put a new Oracle driver on an old site, and it broke every query in the entire site, which worked 100% before. - tleish

 

[Arion23]

Thanks for the reply.

I've done some further testing:
* Executing the same query on the same table in SQL*Plus has no problems.
* I set up a Windows ODBC entry for the database (I run Apache/CF Server 5 locally on my PC for development purposes) and executed the page locally, and found no problems.

It seems the error is only generated when the CFM page is executed off our Intranet server (Solaris and CF5) - I've asked the server admin to check the servers database connection drivers (not sure of the terminology for the solaris environment). A colleague suggested that the database connection process(?) might have hung for some reason, and all it needs is the CF process restarted.

I'll post an update on how these go, in the mean time any other suggestions would be welcome.

Thanks
Dave