Set up an Oracle data source that looks a schema that is not the default schema

Hi

I am trying to set up an Oracle data souce that is a read only user on the database. This user has the (schema) name of ro_user and no tables or views but the schema that holds the is data_user. Whist the data souce connects and saves correctly when you open the datasource you get the following error:

Error message: Could not get contents of 'data_user' from the server.

The data source reported a failure.

InformationModelException at Spotfire.Dxp.Data:

Failed to initialize connection pool: null (HRESULT: 80131500)

Stack Trace:

   at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.ListDataSourceChildren(Guid dataSourceId, String dataSourceName)

   at Spotfire.Dxp.Forms.Data.InformationDesigner.Cache.CachedDataSource.<GetChildren>d__0.MoveNext()

   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)

   at Spotfire.Dxp.Forms.Data.InformationDesigner.Cache.CachedItem.EnsureChildrenLoaded()

   at Spotfire.Dxp.Forms.Data.InformationDesigner.VirtualMultiSelectTreeView.TreeItem.Expand()

InformationModelServiceException at Spotfire.Dxp.Services:

Failed to initialize connection pool: null (HRESULT: 80131509)

Stack Trace:

   at Spotfire.Dxp.Services.WebServiceBase`1.InvokeService[T](ServiceMethod`1 serviceMethod, ExceptionFactoryMethod exceptionFactoryMethod)

   at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.ListDataSourceChildren(Guid dataSourceId, String dataSourceName)

indicating the the tables cannot be enumerated (as there aren't any in that schema). I have tried adding a command to the open session commads to change the default schema:

     EXEC SQL ALTER SESSION SET CURRENT_SCHEMA = DATA_USER END-EXEC

However this seems to have no effect.

Short of adding a logon trigger to the ro_user to change the default schema when logging on does anyone know how to set up and oracle data source that will enumerate the tables so that the column elements can be created and hence the information links?

Thanks for you help

Jonathan

(1) Answer

Login