TIBCO BusinessEvents 6.1.1 - Table definitions in Ignite Cache are not updated after adding new concept properties after cache has been initialized (Persistence type "Shared Nothing")
Article ID: KB0073225
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessEvents Enterprise Edition | 6.0.0/6.1.1 |
Description
You can add new properties for an existing concept and the values are available at runtime but not in SQL tool.
Issue/Introduction
SQL tool does not return concept properties and Indexes added after cache has been initialized
Environment
All Operating Systems
Resolution
The table definitions are created when we start and initialize the cache and the persistence store.
The new concept properties and new indexes are not returned by the SQL tool. The newly added properties and indexes are only available for the TIBCO BusinessEvents application.
TIBCO BusinessEvents uses cache APIs to publish the changes. The Ignite API does not publish those changes to the corresponding sql tables, so that the table changes are available for the SQL tool.
To return the new properties (table columns) with the SQL tool it is required execute an SQL DDL command and add the new column(s).
Once column created data returned correctly.
SQL:
e.g. (concept /Concepts/cptest column: cpNewText, type: varchar):
Note:
CR BE-30109 created to publish the changes to the table definitions.
The new concept properties and new indexes are not returned by the SQL tool. The newly added properties and indexes are only available for the TIBCO BusinessEvents application.
TIBCO BusinessEvents uses cache APIs to publish the changes. The Ignite API does not publish those changes to the corresponding sql tables, so that the table changes are available for the SQL tool.
To return the new properties (table columns) with the SQL tool it is required execute an SQL DDL command and add the new column(s).
Once column created data returned correctly.
SQL:
ALTER TABLE <schema>.<table> ADD COLUMN <newColumn> <type>;
e.g. (concept /Concepts/cptest column: cpNewText, type: varchar):
ALTER TABLE DEFAULT.BE_GEN_CONCEPTS_CPTEST ADD COLUMN cpNewText varchar;
Note:
CR BE-30109 created to publish the changes to the table definitions.
Feedback
Yes
No
Powered by
