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 User gets "Error: The schema PCMS_SYS does not exist on this database." trying to logon to DMDBA as PCMS_SYS
User needs to logon to DMDBA as PCMS_SYS in order to run grant_pcms_sys script. However, when trying to logon user gets "Error: The schema PCMS_SYS does not exist on this database." error.
CMS-XML KM-Dim10 Upgrading from Dim 8 - SQL-942(016C7218) ORA-00942: table or view does not exist Error detected in
SQL-942(016C7218) ORA-00942: table or view does not exist Error detected in C:\Program Files\Serena\Dimensions 10.1\CM\dbms\common\ grant_pcms_sys .sql, line 15 Called from C:\Program Files\Serena\Dimensions 10.1\CM\dbms\upgrade\upgradedb_8500.
CMS-XML DIM CM: Cannot create a new product in a basedb
/product=qlarius dmdba postgres/admin@dim14 grant_pcms_sys test dmdba postgres/admin@dim14 cpas test /new=test
CMS-XML CM: Create New Product returns: COR0500049E DbFailException.Database failed to load
4. DMDBA> exit 5. dmdba pcms_sys/pcms_sys@dim14 grant_pcms_sys hr 6. Login as dmsys and try and create a new product, the following is returned:
CMS-XML Dim CM: Accessing Administration Console generates the error "merant.adm.dimensions.exception.DBIOException: Column index out of range"
dmdba system/password@dsn SYSTEM> grant_pcms_sys schema_name where "schema_name" is the name of the Dimensions CM Base Database (or schema) being accessed.
CMS-XML Dim CM: Error "merant.adm.dimensions.exception.dbioexception failed to query database" attempting to connect to Web Client following Dimensions CM upgrade
dmdba system/password@dsn SYSTEM> grant_pcms_sys basedb The command should be run for all imported base databases.
CMS-XML Dim10: When running the upgrade all command, an error of "ERROR: cannot determine Dimensions node" occurs
4. After the import of these tables, log into DMDBA as the system user and run the following: @ grant_pcms_sys <basedbname> For each basedatabase.
CMS-XML Dimensions: How to export/import base databases
Once the import has completed without errors - use the dmdba utility: dmdba system/<password>@<dsn> SYSTEM> grant_pcms_sys <basedb>
CMS-XML Dim10: Error detected in /opt/serena/dimensions/10.1/cm/dbms/common/grant_pcms_sys.sql, line 45
@<SID> @ grant_pcms_sys <basedatabasename> Once done, the error should no longer occur during the above operations.
CMS-XML Dim200R2: How to make duplicate base database with different name?
Then run the command, grant_pcms_sys <new base database user> Where the new base database user is the one you created in step 3.
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs