Created On:  19 May 2011

Problem:

After a Datamart extraction the Discussion table shows empty Body fields.

Resolution:

This is a known issue and will be addressed in a future patch.

As workaround to this issue, please download the attached SDK code.  The SDK code will create a new table in your existing Datamart database called Discussion2 and will populate the fields with the discussion data from the CaliberRM database.

You will have to edit the code slightly so that it connects to your CaliberRM server and SQL Server database:

CaliberServer server =

new CaliberServer("CaliberRM Server");
//Input you CaliberRM server details.

session = server.login( "admin", "admin");
//Input you CaliberRM server admin username and password

connection

= DriverManager.getConnection("jdbc:sqlserver://SQLServer:1433; databaseName=CaliberRM", "username", "password")
//Input your SQL Server connection details and username and password for the database.

You will also need to download the Microsoft JDBC SQLServer driver to run the code.  For more details on to download and install the driver please visit:

http://msdn.microsoft.com/en-us/sqlserver/aa937724

Incident #2516360