Error importing repository: could not insert NodeProperty

[Alexires]

Alright, so I'm guessing I need to do the following:

I need to alter the default settings so that when an item is imported the default size for "TextArea" is 2048 instead of the standard 512. Each property group is inserted as its row in "OKM_NODE_PROPERTY" but I don't know what to enter in the database query. I'm pretty sure it is something like this:

Code: Select all

ALTER TABLE OKM_NODE_PROPERTY ALTER COLUMN NPG_VALUE [i]something[/i] 2048

I just don't know what I have to type in where something is. Please help?

[jllort]

which database do you have ? on Mysql will be something like varchar(number);

[Alexires]

Standard database (derby?). I worked it out and that was what I used:

Code: Select all

ALTER TABLE OKM_NODE_PROPERTY ALTER COLUMN NPG_VALUE VARCHAR(2048)

Repository import seems to be working fine, although the program seems to just crash randomly...

[jllort]

The problem with derby is that you can not have a client connected to derby and openkm started. With tomcat stopped you can connect with derby with some databaseclient like datastudio ( it's a great database client ) and ensure you have changed the table.

For better perfomance, take only as a suggestion, you should consider migrate all data to repository with mysql ( you'll get more database control and performance ). I ignore the number of documents you got, but from 25-50k documents is good idea jump to mysql ( in your case is needed export repository from administration and import -> the major work you will have is migrate user -> you can use database scripts ( selects -> to create inserts )).

something like it ( really these are for migrating 5.x users table to 6.x:

Code: Select all

SELECT 'INSERT INTO OKM_USER (USR_ID, USR_NAME, USR_PASSWORD, USR_EMAIL, USR_ACTIVE) VALUES (''' + USR_ID + ''', ''' + USR_NAME + ''', ''' + USR_PASSWORD + ''', ''' + USR_EMAIL + ''', ''' + USR_ACTIVE + ''');' FROM OKM_USER;
SELECT 'INSERT INTO OKM_ROLE (ROL_ID, ROL_ACTIVE) VALUES (''' + ROL_ID + ''', ''' + ROL_ACTIVE + ''');' FROM OKM_ROLE;
SELECT 'INSERT INTO OKM_USER_ROLE (UR_USER, UR_ROLE) VALUES (''' + UR_USER + ''', ''' + UR_ROLE + ''');' FROM OKM_USER_ROLE;

About application crash depending the load of system ( number of users, what are doing, the extraction queue, which kind of files you're uploading etc... ) you need more or less memory and cpu resources. 2CPU and 2048MB for tomcat and 1MB for OS is good starting scenario. If your OpenKM shares the server with other applications that could be a problem too. And finally with Windows OS you'll get less performance and control of your applications ( that could be a problem too, but not necessary we have middle size repositories 100-200k docs in windows environments without problems ).

[Alexires]

In MySQL5.5, the command is

Code: Select all

ALTER TABLE OKM_NODE_PROPERTY MODIFY NPG_VALUE VARCHAR(4096);