We were getting some weird errors in our database that uses the cdata and cglobal tables for client variables. At the bottom of each CF page a “500 Error finding database …” would appear, so it wasn’t writing client variables to the database. The specific oracle error was ORA-01654.

Here is the java error:
03/07 15:08:48 error Operation failed on the data source named “datasource”.
coldfusion.runtime.ClientScopeDBException: Operation failed on the data source named “datasource”.
at coldfusion.runtime.JDBCHelper.Store(PersistenceFactory.java:222)
at coldfusion.runtime.ClientScopeServiceImpl.PersistClientVariables(ClientScopeServiceImpl.java:204)
at coldfusion.runtime.ClientScopeServiceImpl.PersistClientVariablesForRequest(ClientScopeServiceImpl.java:192)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:32)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

Our dba fixed it by increasing the tablespace that was association with that table like so:

SQL> select table_name, tablespace_name from dba_tables
2 where table_name = ‘CDATA’;

TABLE_NAME TABLESPACE_NAME
—————————— ——————————
CDATA USERS

SQL> select file_name, tablespace_name, bytes
2 from dba_data_files;

FILE_NAME
——————————————————————————–
TABLESPACE_NAME BYTES
—————————— ———-
/u01/oracle/databaseSID/system_database.dbf
SYSTEM 54525952

/u01/oracle/databaseSID/rbs01.dbf
RBS 23068672

/u01/oracle/databaseSID/temp01.dbf
TEMP 12582912

FILE_NAME
——————————————————————————–
TABLESPACE_NAME BYTES
—————————— ———-
/u01/oracle/databaseSID/tools.dbf
TOOLS 2097152

/u01/oracle/databaseSID/users.dbf
USERS 57671680

/u01/oracle/databaseSID/user_i01.dbf
USER_INDEX 23068672

6 rows selected.

SQL> l
1* alter database datafile ‘/u01/oracle/databaseSID/users.dbf’ resize 100m
SQL> /

Database altered.

SQL> alter system flush shared_pool;

System altered.

And that did it. Stupid oracle tablespace issues.

I used some of the information from this post: http://www.petefreitag.com/item/47.cfm