Open Source Document Management System | OpenKM

Dears,

After checking many useful posts on this forum and applying the steps mentioned in the Wiki, I am still not able to get my installation to work.

Steps Taken to Install and Configure MSSQL Connectivity

1) created the two databases on MSSQL.
2) Installed JDBC driver version 1.2 - downloaded from Microsoft website
3) Altered the following configuration files as per the guidance in the wiki:
D:\openkm515\MSSQL\server\all\conf\login-config.xml
D:\openkm515\MSSQL\server\default\deploy\openkm-ds.xml
D:\openkm515\MSSQL\reposiroty.xml
4) Kept set hibernate.hbm2ddl=create for first startup
5) Corrected MSSQL server TCP/IP port and hostname in the following files:
- D:\openkm515\MSSQL\reposiroty.xml
- D:\openkm515\MSSQL\server\default\deploy\openkm-ds.xml
6) Tables were created
7) Corrected the tables as per guidance in the wiki

Problem Description:

After starting the server, no errors in the log (except couple of 'could not create table - already exist'), however while trying to login to the application, following error is presented and I am not able to browse the application:

"Error getting translations: English translation is mandatory can not be deleted"

Did anyone face this issue before?

Observations:

- Table OKM_TRANSLATION in the database is empty.

Appreciate any hint/guidance on how to overcome this issue.

Thanks to all,
Kahtan

try with openkm that we'll release this week, probably on friday, because there's a bug on creation table values. If you want to insert manually; open OpenKM.war go to WEB-INF/import.sql and execute the script file, you'll that will stop in two places.

Thanks Jillort,

When is the expected date to release the new version?

Was programed for today, but it'll be released on monday

Hi Jillort,

Apparently, 5.1.6 is released, however when I tried to download it through the link placed on http://www.openkm.com/Download.html I found 5.1.5 instead.

Any idea how to download 5.1.6?

Thanks,
Kahtan

Hi,

When I searched for openkm on sourceforge.net I was able to see find version 5.1.6. I guess the link placed on openkm.com needs to be updated.

Here is the link: http://sourceforge.net/projects/openkm/ ... p/download

Thanks,

Thanks for the information, will change the link. Sorry for the inconvenience.

I fixed the link last week.

Hi,

Just wanted to confirm that 5.1.6 actually fixed the MSSQL database issues, and big thank you for this enhancement.

Regards,

I think 5.1.6 solves the DMBS problems with creation.

here's the change log of 5.1.6
- 0001686: [Core] Create form template fails when PDF has no forms (pavila) - resuelta.
- 0001667: [Core] Refeactor workflow button definition (jllort) - resuelta.
- 0001669: [Core] Improve Oracle10g support (pavila) - resuelta.
- 0001680: [Core] Improve report parameters (pavila) - resuelta.
- 0001677: [Core] Upgrade jBPM to 3.3.1.GA (pavila) - resuelta.
- 0001675: [Core] User mail in dashboard does not show any imported mail (pavila) - resuelta.
- 0001674: [Core] Improve database metadata performance (pavila) - resuelta.
- 0001673: [Core] Create workflow form upload element (pavila) - resuelta.
- 0001672: [Core] Stamp fails when document has no extension (pavila) - resuelta.
- 0001671: [Core] Force mode multi-instance by configuration (pavila) - resuelta.
- 0001670: [Core] Improve thread concurrency (pavila) - resuelta.
- 0001664: [Frontend] problemas con acentos y eñes (pavila) - resuelta.
- 0001662: [Core] Fix forum extension field limitation (pavila) - resuelta.
- 0001665: [Core] Unify form elements management (pavila) - resuelta.
- 0001661: [Core] Implement SuggestBox as PropertyGroup form element (jllort) - resuelta.
- 0001660: [Core] Property group element as read-only (jllort) - resuelta.

I think on same ticket we solve Improve Oracle10g support we made for mssql too.

Here you can found the nightly builds http://integration.openkm.com/ ( that's future 5.1.8 )

Thanks, and this is what I am confirming after I have tested it, it works...!