This document describes how to troubleshoot an error message that is encountered on the Cisco Information Server (CIS).
You receive this error message when you query the CIS:
The identifier that starts with 'RPT_ACCOUNTS_DATA_EXTERNAL_R'
is too long. Maximum length is 28
In order to resolve this error, you must adjust the CIS settings so that it can handle the table or column name identifier length in Sybase. Use the information that is provided in this section in order to resolve this error.
By default, the CIS always quotes identifiers. However, certain Sybase releases have a limit of 30 characters for identifiers, such as table names, column names, and quotes, which are considered a part of the names when checked against this limit. Therefore, when quotes are used, you can only specify 28 characters. In order to support the maximum length limit in the Sybase releases, you must remove the delimited identifier, which causes the CIS to send identifiers without quotes.
Since the table name RPT_ACCOUNTS_DATA_EXTERNAL_R is too long, you can remove the double quote around it; however, this is a short-term fix.
Complete these steps in order to remove the delimiter quotes that are used to wrap the table name and allow for two extra characters:
- Navigate to <CIS_INSTALL_DIRECTORY> > apps > dlm > cis_ds_sybase > conf > sybase-<highest number>.capabilities.
- Comment-out these two lines:
- Restart the CIS and attempt the query again.
For a more permanent fix, Cisco recommends that you complete the steps that are described in this section, which provides a more permanent form of the resolution that is described in the previous section.
Complete these steps in order to resolve this error:
- Navigate to <CIS_INSTALL_DIRECTORY> > conf > adapters > system > sybase* > sybase*_values.xml.
- Add these tags to the XML file:
<ns455:attribute xmlns:ns455=" <http://www.compositesw.com/services/system/util
<ns456:attribute xmlns:ns456=" <http://www.compositesw.com/services/system/util
- Once you use the updated values.xml file, you must restart the CIS so that the changes are valid.