We have installed a demo version of the Wildfire 3.1.0 server on Windows 2003 SP1 connecting to SQL Server 2005. I have generated a demo license and tried to use some of the enterprise features. I have found that message archiving, managed URL links, and group chat bookmarks are not working. These features did work with the embedded DB, but not SQL Server.
I have verified that the embedded DB has the tables:
CREATE MEMORY TABLE ENTBOOKMARK(BOOKMARKID BIGINT NOT NULL,BOOKMARKTYPE VARCHAR(50) NOT NULL,BOOKMARKNAME VARCHAR(255) NOT NULL,BOOKMARKVALUE VARCHAR(1024) NOT NULL,GLOBAL INTEGER NOT NULL,CONSTRAINT ENTBOOKMARK_PK PRIMARY KEY(BOOKMARKID))
CREATE MEMORY TABLE ENTBOOKMARKPERM(BOOKMARKID BIGINT NOT NULL,BOOKMARKTYPE INTEGER NOT NULL,NAME VARCHAR(255) NOT NULL,CONSTRAINT ENTBOOKMARKPERM_PK PRIMARY KEY(BOOKMARKID,NAME,BOOKMARKTYPE))
CREATE MEMORY TABLE ENTBOOKMARKPROP(BOOKMARKID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE LONGVARCHAR NOT NULL,CONSTRAINT ENTBOOKMARKPROP_PK PRIMARY KEY(BOOKMARKID,NAME))
When i look over the SQL DB script i do not see any of those tables created.
These I get error messages like the following example when trying to use any of the features:
2006.10.25 18:44:12 Connection 0 had warnings: java.sql.SQLWarning: Preparing the statement failed: Invalid object name ‘‘entConversation’’.
2006.10.25 18:57:42 Connection 0 had warnings: java.sql.SQLWarning: Preparing the statement failed: Incorrect syntax near the keyword ‘‘external’’.
2006.10.25 18:57:42 Connection 1 had warnings: java.sql.SQLWarning: Preparing the statement failed: Invalid object name ‘‘entMessageArchive’’.
2006.10.25 19:13:47 [com.jivesoftware.wildfire.enterprise.archive.ConversationManager$ArchivingTask .run(ConversationManager.java:547)
]
java.sql.BatchUpdateException: Invalid object name ‘‘entMessageArchive’’.
2006.10.25 14:22:11 Connection 0 had warnings: java.sql.SQLWarning: Preparing the statement failed: Invalid object name ‘‘entBookmark’’.
2006.10.25 14:25:41 Connection 0 had warnings: java.sql.SQLWarning: Preparing the statement failed: Invalid object name ‘‘entConversation’’.
2006.10.25 14:33:11 Connection 0 had warnings: java.sql.SQLWarning: Preparing the statement failed: Invalid object name ‘‘entBookmark’’.
2006.10.25 15:02:59 Autocreating jiveID row for type ‘‘50’’
2006.10.25 17:40:11 Connection 0 had warnings: java.sql.SQLWarning: Preparing the statement failed: Invalid object name ‘‘entBookmark’’.
Is there an updated SQL Script that has all of the needed tables in it that is available for download?