Find Answers

Filter Search Results
All Operating Systems:
All Products:

All Solution Types:
Ask a Question
Example: "Database could not be verified"  
Tips | Start Over | Solutions | Alerts | Patches | Defects  
Pages [Next]
CMS-XML 10.x / 2009Rx / 12.x : is Dimensions integrated with Oracle SQL Developer ?
10.x / 2009Rx / 12.x : is Dimensions integrated with Oracle SQL Developer ?
CMS-XML Unable to perform TBI in Dimensions 2009R1 - SQL-917(12194) ORA-00917: missing comma
Dimensions CM 2009 R1
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
Dimensions 9 data was imported and the command "upgrade <basedb> /force" was run to upgrade the schema to Dimensions 10. The following error was produced:
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
For instance, in looking at the upgradedb_141. sql script, it can be verified which index that is attempting to be created and the tablename. In the above example, the indexes on the table of area_catalogue were attempting to be created.
CMS-XML KM-Dim9: Unix installation using Install script - Error: An SQL error was detected trying to check for PCMS_IDX
The user is trying to install Dimensions 9.1.0 on a Solais 9 machine.
CMS-XML KM-Dim9: How to determine from SQL if a FILE FORMAT is ascii or binary
To do this from SQL, access the following Base table: CPL_CATALOGUE Please note that this can change in future versions of Dimensions .
CMS-XML KM-Dim9: Automatic (SQL Script) to rename of OS user account in Oracle
The Dimensions installation includes the SQL script file to update record when the user renamed their user account in OS level. You can find the SQL script in following location of Dimensions installation directory.
CMS-XML KM-Dim9: How to run SQL open queries against the base databases (Dim 7, Dim 8 and Dim 9)
Dimensions 7 with Oracle 8 Precede the tablename with the base database in question when running an open query as SYSTEM. In order to query on specific base database information directly through SQLPLUS, you will need to precede the table with the basedb name.
CMS-XML Dim9 and Dim10: SQL Script to list out the Item Type, Item Format mappings
1. This is not an officially supported script 2.The script may not work on other versions of Dimensions . 3. An Oracle client needs to be installed.
CMS-XML KM-Dim9:12025-ART_SQL_ERROR sql error (%s): %d %s
Please gather any applicable information from the list below and contact Dimensions Support for help with this error message. What you need to troubleshoot:
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs