Installing 5.1.5 with MSSQL Failes

[osDubai]

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

[jllort]

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.

[osDubai]

Thanks Jillort,

When is the expected date to release the new version?

[jllort]

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

[osDubai]

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

[osDubai]

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,

[jllort]

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

[pavila]

I fixed the link last week.

[osDubai]

Hi,

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

Regards,

[jllort]

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 )

[osDubai]

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