Open Source Document Management System | OpenKM

2011-02-22 15:02:05,903 ERROR [STDERR] javax.naming.NamingException: [LDAP: error code 1 - 000020D6: SvcErr: DSID-031006CC, problem 5012 (DIR_ERROR), data 0
]; remaining name 'o=dgt.es'

1)
ALTER TABLE [dbo].[OKM_ACTIVITY]
     ALTER COLUMN [ACT_ITEM] varchar(MAX)

2)
ALTER TABLE [dbo].[OKM_EXTENSION]
ALTER COLUMN [EX_DESCRIPTION] varchar(MAX)

3)
CREATE TABLE OKM_PROFILE (
        PRF_ID int identity NOT NULL,
        PRF_NAME varchar(255) NOT NULL,
        PRF_ACTIVE tinyint NOT NULL,
        PRF_MSC_ADVANCED_FILTERS tinyint DEFAULT 0 NULL,
        PRF_MSC_USER_QUOTA numeric(19,0) DEFAULT 0 NULL,
        PRF_MSC_WEB_SKIN varchar(255) DEFAULT 'default' NULL,
        PRF_MSC_PRINT_PREVIEW tinyint DEFAULT 1 NULL,
        PRF_CHT_CHAT_EN tinyint DEFAULT 0 NULL,
        PRF_CHT_AUTO_LOGIN_EN tinyint DEFAULT 0 NULL,
        PRF_WZRD_KEYWORDS_EN tinyint DEFAULT 0 NULL,
        PRF_WZRD_CATEGORIES_EN tinyint DEFAULT 0 NULL,
        PRF_STCK_TAXONOMY_VIS tinyint DEFAULT 1 NULL,
        PRF_STCK_CATEGORIES_VIS tinyint DEFAULT 1 NULL,
        PRF_STCK_THESAURUS_VIS tinyint DEFAULT 1 NULL,
        PRF_STCK_TEMPLATES_VIS tinyint DEFAULT 1 NULL,
        PRF_STCK_PERSONAL_VIS tinyint DEFAULT 1 NULL,
        PRF_STCK_MAIL_VIS tinyint DEFAULT 1 NULL,
        PRF_STCK_TRASH_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_DESKTOP_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_SEARCH_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_DASHBOARD_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_ADMIN_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_DOC_PROPS_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_DOC_SECURITY_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_DOC_NOTES_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_DOC_VERSIONS_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_DOC_PREVIEW_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_DOC_PROP_GRPS_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_FLD_PROPS_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_FLD_SECURITY_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_FLD_NOTES_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_ML_PROPS_VIS tinyint DEFAULT 1 NULL,
        PRF_TB_ML_SECURITY_VIS tinyint DEFAULT 1 NULL,
        PRF_DB_USER_VIS tinyint DEFAULT 1 NULL,
        PRF_DB_MAIL_VIS tinyint DEFAULT 1 NULL,
        PRF_DB_NEWS_VIS tinyint DEFAULT 1 NULL,
        PRF_DB_GENERAL_VIS tinyint DEFAULT 1 NULL,
        PRF_DB_WORKFLOW_VIS tinyint DEFAULT 1 NULL,
        PRF_DB_KEYWORDS_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FILE_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_EDIT_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_TOOLS_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_BOOKMARKS_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_HELP_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_CREATE_FLD_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_FIND_FLD_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_GO_FLD_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_DOWNLOAD_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_DOWNLOAD_PDF_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_ADD_DOC_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_START_WORKFLOW_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_REFRESH_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_SCANNER_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_UPLOADER_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_PURGE_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_PURGE_TRASH_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_RESTORE_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_EXPORT_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_CREATE_FROM_TPL_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_SEND_DOC_LINK_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_FI_SEND_DOC_ATTACH_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_LOCK_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_UNLOCK_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_CIN_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_COUT_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_CANCEL_COUT_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_DELETE_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_RENAME_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_COPY_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_MOVE_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_ADD_PROP_GRP_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_REM_PROP_GRP_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_ADD_SUBS_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_ED_REM_SUBS_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_BM_MNG_BOOKMARKS_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_BM_ADD_BOOKMARK_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_BM_SET_HOME_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_BM_GO_HOME_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_TL_LANGS_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_TL_SKIN_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_TL_DEBUG_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_TL_ADMIN_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_TL_PREFS_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_HLP_DOC_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_HLP_BUG_TRACKING_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_HLP_SUPPORT_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_HLP_FORUM_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_HLP_CHANGELOG_VIS tinyint DEFAULT 1 NULL,
        PRF_MN_HLP_WEB_SITE_VIS tinyint DEFAULT 1 NULL,
        PRF_MNU_HLP_ABOUT_VIS tinyint DEFAULT 1 NULL,
        PRIMARY KEY (PRF_ID)
);
 
ALTER TABLE OKM_USER_CONFIG ADD constraint FK7798F4E88FDAFE34 FOREIGN KEY (UC_PROFILE) REFERENCES OKM_PROFILE;
 
INSERT INTO OKM_USER (USR_ID, USR_NAME, USR_PASSWORD, USR_EMAIL, USR_ACTIVE) 
VALUES ('okmadmin', 'Administrator', ' ', 'okmadmin@bancobsf.com.ar', 1);
 
INSERT INTO OKM_ROLE (ROL_ID, ROL_ACTIVE) VALUES ('AdminRole', 1);
INSERT INTO OKM_ROLE (ROL_ID, ROL_ACTIVE) VALUES ('UserRole', 1);
INSERT INTO OKM_USER_ROLE (UR_USER, UR_ROLE) VALUES ('okmadmin', 'AdminRole');
INSERT INTO OKM_PROFILE (PRF_NAME, PRF_ACTIVE) VALUES ('Default', 1);

4)
ALTER TABLE [dbo].[OKM_PROFILE]
ADD  [PRF_WZRD_PROPERTY_GROUPS] VARCHAR(255) DEFAULT ''

5)
ALTER TABLE [dbo].[OKM_PROFILE]
add [PRF_WZRD_WORKFLOWS] VARCHAR(255) DEFAULT ''