Inform Adapter ODM - "ORA-25153: Temporary Tablespace is Empty" error (Doc ID 1646156.1)

Last updated on JULY 29, 2014

Applies to:

Oracle Health Sciences InForm - Version 4.6.2.1 and later
Oracle Health Sciences InForm Adapter - Version 1.3.4.2 and later
Information in this document applies to any platform.

Symptoms

 When downloading ODM the following error occurs:

informadapter.odm.webservice[error] 0  06:19:00,211 [1656] ERROR   .InFormAdapter.Framework.Common.CRFSLog Error   .Platform.Storage.Exceptions.DBProviders.Messages.DbProviderException: Read to data table USERTHINGDATA failed. SelectSql : select ThingID as USERID, ATTRIBUTENAME, STRVALUE, NUMVALUE, FLOATVALUE from dcv_thingData where thingID in - (select userid from pf_user) and thingtypeid = (select distinct thingtypeid from pf_thingtype where typename='CBFDAB34-152F-11d4-A11F-00D0B709DF4E') order by thingid DB Provider Message : Oracle.DataAccess.Client.OracleException ORA-25153: Temporary Tablespace is Empty at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src) at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at   .Platform.Storage.Providers.ODPOracleProvider.Fill(IDbDataAdapter dbAdapter, DataTable data) in E:\ICEPlatform\AppServer\Storage\Providers\ODPOracleProvider.cs:line 181 at   .Platform.Storage.DBProvider.Fill(IDbCommand selectCommand, DataTable data) in E:\ICEPlatform\AppServer\Storage\Providers\DBProvider.cs:line 452. ---> Oracle.DataAccess.Client.OracleException ORA-25153: Temporary Tablespace is Empty at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src) at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at   .Platform.Storage.Providers.ODPOracleProvider.Fill(IDbDataAdapter dbAdapter, DataTable data) in E:\ICEPlatform\AppServer\Storage\Providers\ODPOracleProvider.cs:line 181 at   .Platform.Storage.DBProvider.Fill(IDbCommand selectCommand, DataTable data) in E:\ICEPlatform\AppServer\Storage\Providers\DBProvider.cs:line 452 --- End of inner exception stack trace --- at   .Platform.Storage.DBProvider.Fill(IDbCommand selectCommand, DataTable data) in E:\ICEPlatform\AppServer\Storage\Providers\DBProvider.cs:line 498 at   .InFormAdapter.ODM.InformDownLoad.InFormAdminAdapter.FillUserThingData(InFormAdminSet& dataset, IDBProvider provider) in D:\InformAdapter\ODM\InFormDownload\InFormAdminAdapter.cs:line 238 at   .InFormAdapter.ODM.InformDownLoad.InFormAdminAdapter.FillAdminDataSet(InFormAdminSet& dataset) in D:\InformAdapter\ODM\InFormDownload\InFormAdminAdapter.cs:line 208

 

Note that similar issues will be seen in Inform, making the trial unusable (ISE errors, performance, export issues, etc.).

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms