close

Filter

loading table of contents...

Content Server Manual / Version 2207

Table Of Contents

3.16 Troubleshooting

You start the server for the first time or after changes of the content type definition and an ArrayOutOfBoundsException occurs.

Possible cause:

The problem occurs when the number of content types is a multiple of 64 due to an error of the IBM XML parser used.

Possible solution:

Add an abstract dummy content type to the content type definition.

A publication is possible, but reports that no action was necessary to publish the content item. The content item, or the most recent version, does not appear on the Master Live Server.

Possible cause:

  1. The properties - in particular the URL of the live server - are incorrectly configured.

Possible solution:

  1. Check the properties. It might point to the Content Server.

  2. Restart the live server. The use of separate computers for the Content ManagementServer and Master Live Servers is recommended.

The server shows poor performance when accessing the database; in particular, it seems to be almost at a standstill every 24 hours.

Cause:

The database systems supported by CoreMedia CMS do not update their statistics data for tables and indexes automatically (except the MS SQL Server). This leads to the situation that database queries are not optimized and are therefore only processed inefficiently. Once every 24 hours, the Content Server places a query to release not referenced objects. If the statistics data and indexes are not optimized, this query cannot be processed optimally.

Solution:

Using database maintenance, update the statistics data daily for all tables and indexes of the corresponding CoreMedia database user on the production and live systems.

With an Oracle database the following SQL command must be executed, for example with sqlplus or another suitable program for each CoreMedia database user for the purpose of optimization:

call dbms_utility.analyze_schema('<Database user>', 'COMPUTE')

The commands given should be executed either under the corresponding CoreMedia database accounts or an administration account with the appropriate privileges.

Note: The standard interval of 24 hours can be modified, if necessary, with the parameter sql.store.collector.delay=<sec>, in order to set a larger or smaller time span for memory checking. However, this should usually not be necessary.

The server no longer works correctly with an Oracle database and reports the following SQL Exception:

ORA-01000 maximum open cursors exceeded

Cause:

The configuration of the database is incorrect.

Solution:

The database administrator must adjust the Oracle configuration (see Section 3.2.2, “Oracle Database”) and restart the database.

Search Results

Table Of Contents
warning

Your Internet Explorer is no longer supported.

Please use Mozilla Firefox, Google Chrome, or Microsoft Edge.