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 DM: Upgrade 14.1.0 error ORA-01720: grant option does not exist for SYS.NLS_DATABASE_PARAMETERS
During an upgrade, in the portion that upgrades PCMS_SYS schema to 14.1.0, get an error like:
CMS-XML DimCM: Upgrade: DBI4502373E [Microsoft][SQL Server Native Client 11.0][SQL Server]The specified schema name "SCHEMANAME" either does not exist or you do not have permission to use it
When performing a DMDBA upgrade command to Dimensions 14.4, the following error may occur: -- Preparing to upgrade PCMS_SYS to 14.3.3.. DBI0004538E DBIO: Database I/O error occurred
CMS-XML KM DimCM: pcms_sys.user_sequences view incorrect for PostGreSQL
For older versions you can run the following as pcms_sys or postgres to recreate the view correctly drop view pcms_sys.user_sequences; commit;
CMS-XML DBI4502580E DBC:-9999-FATAL: password authentication failed for user "pcms_sys" error during Dimensions CM 14.4 command-line installation on Linux with PostgreSQL
During Dimensions 14.4 install on Linux with -console option it prompts user for PCMS_SYS password, twice. User entered 'pcms_sys' both times as the password. Continued with the install, it started installing the app but then returned errors.
CMS-XML DimCM: PostgreSQL: How to tell if extensions are installed
Password valid until infinity pcms_sys Password valid until infinity
CMS-XML Dim10: Install on UNIX errors when specifying Oracle database on remote server.
SQL>create user pcms_sys identified by pcms_sys default tablespace pcms_data temporary tablespace pcms_temp; SQL> grant connect,resource,dba to pcms_sys ; Once install completes user should revoke DBA from pcms_sys
CMS-XML DMCM: How to re-create the PCMS_SYS user
SQL> create user pcms_sys identified by pcms_sys; SQL> grant connect, resource to pcms_sys ; Log into DMDBA as system and then as PCMS_SYS, so the connection to PCMS_SYS has the correct privileges:
CMS-XML KM-Dim9: When adding or editing the Item Library in Admin Console, the following error occurs: "element '-AdmAttrNames.library_node_name' not found"
This error will sometimes occur when the basedatabase has been imported from another server. The root cause is due to pcms_sys not having permissions to query the basedatabase tables.
CMS-XML DIM10: How to unlock or change PCMS_SYS password
sqlplus> alter user pcms_sys account unlock; sqlplus> grant connect, resource to pcms_sys ; sqlplus> commit;
CMS-XML User gets "Error: The schema PCMS_SYS does not exist on this database." trying to logon to DMDBA as PCMS_SYS
The error is caused by PCMS_SYS schema not having SELECT privilege on SYS.ALL_USERS 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:
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs