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 Dim12: DMDBA: "Error: Could not connect to PCMS_SYS via the password specified" - when running CRDB
Dim12: DMDBA : "Error: Could not connect to PCMS_SYS via the password specified" - when running CRDB
CMS-XML Dim12: DMDBA and SQLServer: Running EXPM gets error - you do not have sufficient database privileges
When logging into DMDBA as either pcms_sys or the basedatabase user with SQL Server as the database and running the EXPM command, you receive an error of you do not have sufficient database privileges.
CMS-XML Dim12: DMDBA: dmdba upgrade of pcms_sys => Error: QLARIUS_CM is not a valid Dimensions database
When performing the DMDBA command of upgrade, the following can occur: +++ SYSTEM> upgrade PCMS_SYS
CMS-XML dmdba upgrade with MS SQL Server 2016 may hang indefinitely upgrading PCMS_SYS to 14.4
In comfiguration which uses MS SQL Server 2016 and Dimensions CM 14.5 or 14.5.1, dmdba upgrade may hang during portion that upgrades pcms_sys to 14.4. This is because of a Microsoft problem in MS SQL Server 2016 that causes database to hang when certain command is issued (see https://support.microsoft.com/en-us/help/4090966/sql-server-session-hangs-when-you-try-to-enable-snapshot-isolation
CMS-XML Dim14.4: DMDBA: SQL Server: Error: You do not have sufficient database privileges to manage Dimensions base databases.
When connecting to DMDBA and using a SQL Server database, an error occurs similar to the following when connecting as the basedatabase and/or pcms_sys user: PCMS_SYS > delv cm_typical Error: you do not have sufficient database privileges to manage Dimensions base databases.
CMS-XML 10.x / 2009Rx / 12.x : dmdba upgrade => is not a valid database for upgrade by this utility
The reason was the following step below of the import procedure had been omitted : dmdba pcms_sys / pcms_sys @<sid > @grant_pcms_sys.sql <dbname>
CMS-XML Error during DMDBA upgrade to 14.4 version on SQL Server
Connected to pcms_sys @dim14 (Microsoft SQL Server) PCMS_SYS> upgrade all /force ==========================================================
CMS-XML KM-Dim10: Reported Defect DEF106610: Running CPAS against PCMS_SYS user causes DMDBA to hang
Running CPAS against a "regular" base database works fine, but when run against PCMS_SYS, an the following error is produced and DMDBA hangs: > dmdba system/<password>@<dsn> SYSTEM> cpas pcms_sys /new_password=<new-password>
CMS-XML DIM2009R2: Dimensions DMDBA MIGRATE fails if attribute values contain ; LF
Connected to system@DM09r2 (oracle) Creating 'TRACK_CONVERT' tracking table in schema PCMS_SYS The tracking 'TRACK_CONVERT' table already exists in schema PCMS_SYS
CMS-XML User gets "Error: The schema PCMS_SYS does not exist on this database." trying to logon to DMDBA as PCMS_SYS
The best solution is to grant this privilege to PCMS_SYS and any user that will be used when invoking dmdba It is also possible to invoke dmdba with --noschemacheck as in: dmdba --noschemacheck <all other paramenters>
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs