"ORA-00942: table or view does not exist" error during creating a FTGroup Appspace
Article ID: KB0077921
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | 6.x |
Description
Creating a FTGroup Appspace fails with following error:
bwadmin[admin]> config -d domain_name -a Appspace_name -cf tibco/bw-6.3.5/bw/6.3/domains/domain_name/appspaces/Appspace_name/config.ini
11:57:46.678 ERROR [main] c.t.b.t.m.p.rdbms.BWRDBMSDataManager - handling error in operation [createCommandHistory]
11:57:46.680 ERROR [main] c.t.b.t.m.p.rdbms.BWRDBMSDataManager -
SQLState : 42000
ErrorCode: 942
Message : ORA-00942: table or view does not exist
TIBCO-BW-ADMIN-CLI-500215: Configured AppSpace [Appspace_name] in Domain [domain_name]. Restart AppSpace to apply changes.
bwadmin[admin]> config -d domain_name -a Appspace_name -cf tibco/bw-6.3.5/bw/6.3/domains/domain_name/appspaces/Appspace_name/config.ini
11:57:46.678 ERROR [main] c.t.b.t.m.p.rdbms.BWRDBMSDataManager - handling error in operation [createCommandHistory]
11:57:46.680 ERROR [main] c.t.b.t.m.p.rdbms.BWRDBMSDataManager -
SQLState : 42000
ErrorCode: 942
Message : ORA-00942: table or view does not exist
TIBCO-BW-ADMIN-CLI-500215: Configured AppSpace [Appspace_name] in Domain [domain_name]. Restart AppSpace to apply changes.
Issue/Introduction
Creating a FTGroup Appspace failed with the following error, "TIBCO-BW-ADMIN-CLI-500215: Configured AppSpace [Appspace_name] in Domain [domain_name]. Restart AppSpace to apply changes"
Environment
All
Resolution
User may see this error if Oracle 11g is being used as the bwagent Database. To resolve the issue, please run the "oracle11g_create.sql" script under "<BW_HOME>\bw\6.x\config\dbscripts" and restart the bwagent.
Feedback
Yes
No
Powered by
