We're trying to solve is that we've been given an oracle Tablespace for the AA database. But the reporting functionality wants a separate Tablespace for the reporting table. What configuration files house the settings to tell the system where the reporting database is at so that we can set up reporting?
Release : 9.1
Component : AuthMinder(Arcot WebFort)
Product also had capability to use the Default Table space but that is not generally used by customers now a days, if you want to test here are the steps to do that -
Reports should work without requiring Tablespace creation privilege.
Description:
Arcot common database scripts need the privilege to create Tablespace for generating reports. If this privilege is not available,
the default tablespace can be used based on a configuration setting.
Resolution:
A (hidden) configuration knob can be specified in arcot/report/config section of adminserver.ini file to use default tablespace.
If 'create tablespace' privilege is not available for reports, follow the steps below:
1. Make a section with following entries in adminserver.ini file (available at ARCOT_HOME/conf) at the end
[arcot/report/config]
UseDefaultTableSpace=true
2. Restart the application server.
Note: If the knob is true, it will use the default table space.