Enhancements in CES Database Server

The new features introduced and the enhancements made in CES Database Server 9.1.9 release are explained in this this section. The topics covered are:

Enhanced Limit of Maximum CES Objects

The internal limit of maximum number of objects, which can be stored in CES Database, is increased from 2.1 billion to 999 trillion. The limit refers to CES's capability to store and refer CES objects.

The actual number of objects that can be stored in CES database depends on other factors like the amount of storage space available, capacity of database server, and so on.

When CES Object ID for User data exceeds 1.4 billion, the current object insertion is aborted and the error message The Sequence has reached its maximum value appears in the CES Java Server error log. CES Object ID range from 1.4 billion + 1 to 100 billion is reserved for internal use.

When this message is encountered, the CES database administrator must perform these steps:

  1. Log on to Database server where CES Database server is installed.

  2. Make sure all CES applications using CES Database are disconnected.

  3. Change directory to <CES_HOME>/exploreDB/dbUtil

    Where,

    <CES_HOME> is the installation directory of CES.

  4. Set the required environment to connect to the database using SQL*Plus.

  5. Connect to the CES database as cisdba user using SQL*Plus.

    For example,

    sqlplus cisdba/<password of cisdba user>

  6. Execute the script recreate_objectid_sequence.sql at the SQL prompt.

    For example,

    SQL>@recreate_objectid_sequence.sql

  7. Disconnect from the database.

  8. Re-create the packages using CES Database Manager.

New Logical Data Types

New Logical Data Types are introduced in CES Database Server in 9.1.9 release. This provides new logical data types in Logical Data Type Definitions class of CES Database Server.

 

Name

Database data type name

Data type length

Precision

SNumber20,2

NUMBER

20

2

SText400

VARCHAR2

400

 

SText800

VARCHAR2

800

 

VNum12

NUMBER

12

0

Updated Logical Data Types

The precision for Logical Data Type Definition (LDD) SMoney is increased from 4 to 6. This enables the user to create properties having higher precision, using this outof-the-box LDD type.

Any pre-existing properties using SMoney data type is not affected by the increase in precision. However, CES Database Administrator can manually modify the column or columns corresponding to such properties at the table level.

This table details the updated data types in Logical Data Type Definitions class of CES Database Server.

 

Name

Database data type name

Data type length

Precision

Comments

SMoney

NUMBER

19

6

Data type length increased from 4 to 6

SPassword

VARCHAR2

150

 

Data type length increased from 80 to 150

Support for Longer Enumerated Valid Values

CES now supports Enumerated Valid Values of length up to 120 characters. The earlier limit was 80 characters. This table provides the details of updates in the Enumerated Valid Values class.

Class Label

Name

Database data type name

Data type length

Comments

Enumerated Valid Value

S_EVV_VALUE

VARCHAR2

120

Data type length increased from 80 to 120

Enumerated Value Internal Name

S_EVV_INTERNAL_NAME

VARCHAR2

120

Data type length increased from 80 to 120