Find Answers

Filter Search Results
All Operating Systems:
All Products:

All Solution Types:
Source:
 
Ask a Question
Example: "Database could not be verified"  
Tips | Start Over | Solutions | Alerts | Patches | Defects  
Pages [Next]
  Results
CMS-XML Dim10: Error SQL-1408(1105daef0) ORA-01408: such column list already indexed occurs running the upgrade command
Dim10: Error SQL-1408(1105daef0) ORA - 01408 : such column list already indexed occurs running the upgrade command
CMS-XML ORA-01408: such column list already indexed error when upgrading from TT 6.6.1 to SBM 09 R4
When upgrading an Oracle database from TT 6.6.1 to SBM 09 R4 you may get the following error: Warning occurred in file:
CMS-XML Dim14: Upgrade: SQL-1408(00000000024AECE0) ORA-01408: such column list already indexed Error detected in C:\Serena\Dimensions14.1\CM\dbms\upgrade\upgradeb_141.sql, line 2114
Dim14: Upgrade: SQL-1408(00000000024AECE0) ORA - 01408 : such column list already indexed Error detected in C:\Serena\Dimensions14.1\CM\dbms\upgrade\upgradeb_141.sql, line 2114
CMS-XML DIM CM: Running Upgrade All /Force fails when upgrading from 14.1.0.1 to 14.1.0.2
Upgrade may fail with: SQL-1408(000000000250CC60) ORA - 01408 : such column list already indexed
CMS-XML Dim CM 10: Upgrade from Dimensions 9 to 10 produces error SQL-2270(018725C0) ORA-02270: no matching unique or primary key for this column-list
Dim CM 10: Upgrade from Dimensions 9 to 10 produces error SQL-2270(018725C0) ORA -02270: no matching unique or primary key for this column - list
CMS-XML Dim10: When performing an upgrade, an error of SQL-1404(1007efb20) ORA-01404: ALTER COLUMN will make an index too large occurs
This error occurs if the db_block parameter size is too small within the Oracle instance. It is recommended that a new Oracle instance be created using the create_ora_inst script and using the relevant template file, either dim10Oracle10g.dbt or dim10Oracle9i.dbt, as referenced in our Installation Guide starting on Page 337.
CMS-XML KM-Dim7: Error: ORA-01795 maximum number of expressions in a list is 1000
Using the PC Client v2.8 column sorting feature against a Dimensions 7.1 database may cause the following error if there are more than 1000 items in the item display. Error: ORA-01795 maximum number of expressions in a list is 1000
CMS-XML Dim: During upgrade to 14.1.0.2 get error no matching unique or primary key for this column-list
During an upgrade of the database from 12.2.2.x to 14.1.0.2 an error may be received similar to: SQL-2270(0000000002AF4A90) ORA -02270: no matching unique or primary key for this column - list Error detected in D:\Serena\CM\dbms\upgrade\upgradedb_141.sql, line 231
CMS-XML Oracle database upgrade error from TT 6.6.1 to 2009 R4 - "Number of bound columns exceeds the number of result columns"
Resource Msg Id = IDS_F2_MSG_DB_CANNOTREADRECORDLISTWITHSELECT The record list with the 'select distinct TS_PROJECTID from TS_FIELDPRIVILEGES where TS_PROJECTID > 0' select statement could not be read from the 'Projects' table. Number of bound columns exceeds the number of result columns.
CMS-XML Dim2009R1: Addressing General Oracle Performance Problems for a Dimensions database
Where <basedb1> and <basedb2> are the two base databases. The Showdbdiffs command will compare all tables, table columns , indices , index columns , constraints and views between the two databases listed and produce a report of differences. Whenever there are indices that are missing or if there is uncertainty, please contact Serena Support for additional assistance in interpreting the report results and in formulating corrective steps.
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs