MyDocumentum

You can use API to do DQL query using the following API command

1

 ?,c,<DQL query>

For example,

1
2
3
4
5
6

API> ?,c,select r_object_id from dmc_jar where object_name = ' BPM Runtime'
r_object_id
----------------
090004d280000bda
(1 row affected)
 

Basically the output result will be the same as DQL query.

Problem:

Error "The password does not meet Windows policy requirements because it is not complex enough." was occured when try to create new repository in Windows 2008 server.

-- Error log in (C:\Documentum\dba\config\DEMO\dm_CreateTableSpace.out) --

Changed database context to 'master'.
CREATE DATABASE DM_DEMO_docbaseON ( NAME = DM_DEMO_docbase,FILENAME = C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\dm_DEMO20100201072704_data1,SIZE = 180MB)
LOG ON ( NAME =DM_DEMO_log,FILENAME = C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\dm_DEMO20100201072704_log1,SIZE = 54MB)
ALTER DATABASE DM_DEMO_docbase SET READ_COMMITTED_SNAPSHOT ON
Processing user DEMO ...
Msg 15118, Level 16, State 1, Server DEMOSRV, Line 1
Password validation failed. The password does not meet Windows policy requirements because it is not complex enough.
sp_defaultdb 'DEMO',DM_DEMO_docbase
Msg 15007, Level 16, State 1, Server DEMOSRV, Procedure sp_defaultdb, Line 41
'DEMO' is not a valid login or you do not have permission.
USE DM_DEMO_docbase
Changed database context to 'DM_DEMO_docbase'.
sp_changedbowner 'DEMO'
Msg 15151, Level 16, State 1, Server DEMOSRV, Line 1
Cannot find the principal 'DEMO', because it does not exist or you do not have permission.
USE master
Changed database context to 'master'.
sp_grantdbaccess 'DEMO'
Msg 15007, Level 16, State 1, Server DEMOSRV, Line 1
'DEMO' is not a valid login or you do not have permission.
Complete.
--

Solution:

Disable complex password requirement,

1. Go to Start - Administrative Tools - Local Security Policy
2. Look for Account Policies - Password Policy node
3. Disable "Password must meet complexity requirement"