Created On:  15-04-2010


After upgrading to SilkCentral Test Manager 2009 (or above) the error “java.sql.SQLEXCEPTION: Incorrect syntax near the keyword 'WITH'” occurs when accessing the Test Plan’s ‘Grid View’ or while viewing the Activities page.

java.sql.SQLException: Incorrect syntax near the keyword 'WITH'.
 at com.borland.bca.webgui.ui.components.extjs.Grid$1.requestPerformed(
 at com.borland.bca.webgui.internal.html.internal.RequestDispatcher.invokeRequestListenersOfComponent(
 at com.segue.scc.webgui.component.HtmlServletPage.dispatchRequest(
 at com.segue.scc.webgui.component.HtmlServletPage.display(


As of SilkCentral Test Manager 2009 there is no longer support for Microsoft SQL Server 2000 ( see release notes section “Technology Updates” at )

A supported database (per the release notes ) must be used.

Microsoft SQL Server 2005 SP2
Microsoft SQL Server 2008
Oracle 9i (version or later)
Oracle 10g (version

Incident #00252343