When I set up a tenant environment of intra-mart Accel Documents in Oracle environment, an error occurs with a "ORA-01450: maximum key length (6398) exceeded" message.

 
[Handling methods]
When you build an environment of intra-mart Accel Documents, please check the correct Oracle setting, as below:  

■1. Privileges of Database User 
The database user needs the following privileges.

○Roles
・CONNECT
・RESOURCE

○System Privileges
・ALTER_ANY_INDEX
・ALTER_ANY_SEQUENCE
・ALTER_ANY_TABLE
・CREATE_ANY_INDEX
・CREATE_ANY_SEQUENCE
・CREATE_ANY_TABLE
・CREATE_USER
・DELETE_ANY_TABLE
・DROP_ANY_INDEX
・DROP_ANY_SEQUENCE
・DROP_ANY_TABLE
・DROP_USER
・INSERT_ANY_TABLE
・LOCK_ANY_TABLE
・SELECT_ANY_SEQUENCE
・SELECT_ANY_TABLE
・UPDATE_ANY_TABLE


■2. Change Block Size
The block size (DB_BLOCK_SIZE) needs to be at least 16 KB.
*2021 Spring or later version, you do not need to specify a block size.
-- Target ------------------------------------------------------------------------
iAP/Accel Applications/Accel Documents/All Updates
--------------------------------------------------------------------------------



FAQID:71
Was this article helpful?
0 out of 0 found this helpful
Powered by Zendesk