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 Dim2009R2: SQL Server: Unable to delete a stream
When attempting to delete a stream, the following error occurs: [Microsoft][SQL Native Client][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "item_deployment_history_k3". The conflict occurred in database "DIM10", table 'CM_TYPICAL.item_deployment_history", column 'workset_uid'.
CMS-XML Dim10: Error delete post scripts from deployment area configuration
Unable to delete any script which has been entered previously into the deployment area. The user needs to keep either pre, post or fail script entry or the below error is returned: [Microsoft][ODBC SQL Server Driver][SQL Server] DELETE statement conflicted with COLUMN REFERENCE constraint 'area_catalogue_fk'. The conflict occurred in database 'DIM10', table 'area_catalogue', column ' transfer_script_set_uid'. 9505- Failed to delete from table AREA_SCRIPT_SETS
CMS-XML Incorrect error messages when deleting a project with related baselines on SQL Server
[Microsoft][SQL Server Native Client 10.0][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "bln_wset_rels_k2". The conflict occurred in database "cm_typical", table "cm_typical.BLN_WSET_RELS", column 'related_uid'.
CMS-XML Dim12: Upgrade: SQL Server: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "ws_ide_projects_fk3". The conflict occurred in database "Dimensions", table "CM_TYPCIAL.WS_CATALOGUE", column 'obj_uid'.
delete from <basedatabase>.ws_ide_info where ide_dm_uid = <value returned in the query from Step 2>; 4. When done, rerun Step 2 until no rows are returned. 5. When complete with the above steps, rerun the upgrade command.
CMS-XML Dim cm 14.4 with Postgres database : crdb with Oracle export file fails with this error : insert or update on table "cm_promote_history" violates foreign key constraint "ch_promote_history_k2"
... Oracle database the constraint ch_promote ... ... not contain a statement to disable the ... ... add the missing constraint to the Oracle ... ... _history drop constraint ch_promote ... ... _history add constraint ch_promote ... _uid) references ws_catalogue ... uid) on delete cascade; ... objectexists(" constraint ", & ... echo Dropping constraint "CH_ ... ... _HISTORY drop constraint CH_PROMOTE ... if objectexists(" constraint ", &constraintName) ... echo Dropping constraint "CH_PROMOTE_HISTORY_K2 ... alter table &SCHEMA..CM_PROMOTE_HISTORY drop constraint CH_PROMOTE_HISTORY_K2
CMS-XML KM-Dim8: Merant Dimensions 8.0.5.0 Service Pack for Windows
... 5.5 Restrictions Using RUR Reports ... ... 2005 Merant International Limited . Delete the work You must delete the work directory ... ... Due to a limitation of shared memory ... ... 2005 Merant International Limited . ... Due to a limitation of shared memory ... ... the Developer's Toolkit Reference Guide, ... For recommendations and restrictions on running external ... ... Dimensions Developer's Toolkit Reference Guide. ... DB2, eliminates reliance on unixODBC ... ... 5.5 Restrictions Using RUR Reports ... statement in its entirety ... ... subject to the restrictions set forth in ... NOTICE OF RESTRICTED RIGHTS ... to the licensing restrictions set forth in ...
CMS-XML KM-Dim7: PVCS Dimensions 7.0 SP2 for Win32
... 2001 MERANT International Limited . ... , renaming or deleting any files in ... ... "Resolve Merge Conflicts " with extracted ... 1222703 - Problem in xpcmsprofile file After installing Dimensions 7.0, the xpcmsprofile file incorrectly contains a reference 'release=x2_5'. ... DBA --- 1087671 - create_pcms_index_script on NT refers to $PCMS_DBASE The script create_pcms_index_script.sql contained references to the $PCMS_DBASE environment variable as used on UNIX.
CMS-XML Database with much history may encounter locks and deadlocks on create or delete request operations
The Dimensions database contains several foreign key constraints (aka referential integrity constraint) with an "On Delete" clause. This means that when an object is removed from the table containing the constraint , a corresponding row or rows may be deleted from the referenced table. In some situations, the key used to look up these rows to be removed is on a column that is not indexed.
CMS-XML DM2009R1/12.1 - Integrity Constraint error when attempting to rename a file (ORA-02291)
Set Filename - [Microsoft][SQL Server Native Client 10.0][SQL Server]The UPDATE statement conflicted with the FOREIGN KEY constraint "ws_files_k3". The conflict occurred in database "dim12", table "cm_typical.WS_DIRS".
PDF Database Administrator’s Guide
The <basedb>_USER role is granted limited privileges on base tables, comprising delete , insert, select and update privileges, but excluding alter, index and references privileges. Hence users with this role may examine and modify table data, but they cannot modify any table definitions. This role is also granted select privilege on all the Dimensions views (both in-built views and those provided for reporting such as the Dimensions Published Views).
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Product Demos

Dimensions CM: Delivering changes from a work area to a stream (demonstration)
This demonstration shows you how to deliver changes from a work area to a stream in Dimensions CM, restrict the deliver to specific folders in the work area, and relate a new item to the correct design part.
Dimensions CM: Resolving conflicts (demonstration)
This demonstration shows you how to resolve conflicts between your work area files and the item tip revisions in a stream in Dimensions CM

Additional Assistance

  • Submit a Case Online
  • FAQs