| |
Results |
|
DM_restore issue: Fails with: Error: Unable to connect to the database specified
|
1. Use CRDB to create a new basedb called HR 2. Run dm_backup to back up the HR database 3. Used DLDB to drop the HR schema
|
|
|
|
DMCM: How to restore "missing" user registration data following upgrade
|
There are occasions following an upgrade from an earlier version of Dimensions where user registration information may be "incomplete" due to the differences in the storage of user registration information in the database . This is particularly the case when customers have upgraded from versions of Dimensions prior to version 7.
|
|
|
|
KM-Dim7: How to Enable Oracle ArchiveLog mode on a Dimensions Database.
|
ArchiveLog is an Oracle function that allows the DBA to recover data up to the time of failure instead of restoring the database to the time of the last logical or cold backup.
|
|
|
|
Dim 9.1.3.16 : when creating or browse item : Error: Attempt to reactivate an active session
|
Caching the workset structure is a performance feature introduced in Dimensions 9.1.2. The idea behind the caching was to load the entire workset directory structure into system memory and then query the cache rather than the database when performing item operations. This works fine on simple workset structures but on complex workset structures querying the cache is more time intensive and error-prone than querying the database itself.
|
|
|
|
DIM CM 2009 R1: Error when creating a base database on SQL Server 2005
|
- install SQL Server 2005 - restore a Dimensions Database backup on this SQL Server instance - install Dimensions 2009 R1 or 2009 R2
|
|
|
Database Administrator’s Guide
|
For example, if an unexpected power outage abruptly terminates database operation, data in memory cannot be written to the datafiles and the data is lost. However, any lost data can be recovered when the database is opened, after power is restored. By applying the information in the most recent redo log files to the database's datafiles, Oracle restores the database to the time at which the power failure occurred.
|
|
|
|
KM-Dim9: How to delete a base database
|
It is not possible to delete a base database while any Dimensions users are connected to it. In addition, it is important to remember that once the command has been completed it cannot be ‘undone’ except by performing a restore from backup. It is our recommendation to have a current backup before running the below commands.
|
|
|
|
KM-Dim9: Disaster Recovery Setup - Library Netwrok Node Specifications
|
When setting up a disaster recovery system that will contain a fully restored database and library, all the meta-data contained in the database points to the library location of the original server. This requires a new network node being created for the recovery server and all the libraries to be updated to reflect this new network node. Is it possible to setup the recovery server to not have to do this?
|
|
|
|
Dim14: Deliver: VRS3202062E Name store state is inconsistent
|
The above problem can be caused if the cache on the Dimensions Server is not synchronized with the database. For instance, if you have performed a restore of the database , this error can occur on a delivery. The VRS Cache was added in Dimensions 14.2.0.1.
|
|
|
|
Dim10: What are the steps for migrating Dimension schemas between different SQL Servers?
|
Any procedures you have in place for moving databases would be acceptable, (backup/ restore , sp_detach_db/sp_attach_db, export/import).
|
|
|
