Enterprise Integrator and EntUtility Adapter

Integration issues after switching Entutility adapter connection from Sybase to SQLServer database.

Error “(42000/0) [Microsoft][SQLServer 2000 Driver for JDBC]Syntax error at token }, line 0 offset 7” is generated on any transaction.

In addition, the EI shows the following errors for Entutility adapter or when EntUtility adapter is started in debug mode.

4:35:41 PM [Debug] 0 error (059) could not load integration component “createRecord”.
4:35:41 PM (058) could not load resource operation “createRecord”.
4:35:41 PM (058) could not load resource operation “createRecordOp”.
4:35:41 PM (086) Value missing for parameter “Expression”. COM.activesw.adapter.devkit.AdapterException: (086) Value missing for parameter “Expression”.
4:35:41 PM at java.lang.Throwable.fillInStackTrace(Native Method)
4:35:41 PM at java.lang.Throwable.fillInStackTrace(Compiled Code)
4:35:41 PM at java.lang.Throwable.(Compiled Code)
4:35:41 PM at java.lang.Exception.(Compiled Code)
4:35:41 PM at COM.activesw.adapter.devkit.AdapterException.(Compiled Code)
4:35:41 PM at com.wm.adapter.intdevkit.AdapterParameters.checkMinStringLength(Compiled Code)
4:35:41 PM at com.wm.adapter.intdevkit.AdapterParameters.verifyValues(Compiled Code)
4:35:41 PM at com.wm.adapter.intdevkit.ResourceOperation.setup(ResourceOperation.java:129)
4:35:41 PM at com.wm.adapter.intdevkit.AdapterMain.addResourceOperation(Compiled Code)
4:35:41 PM at com.wm.adapter.intdevkit.AdapterMain.addResourceOperation(Compiled Code)
4:35:41 PM at com.wm.adapter.intdevkit.AdapterMain.addIntegrationComponent(Compiled Code)
4:35:41 PM at com.wm.adapter.intdevkit.AdapterMain.setupIntegrationComponents(Compiled Code)
4:35:41 PM at com.wm.adapter.intdevkit.AdapterMain.startup(Compiled Code)
4:35:41 PM at com.wm.adapter.intdevkit.AdapterMain.runAdapterMain(Compiled Code)
4:35:41 PM at com.wm.adapter.intdevkit.AdapterMain.main(AdapterMain.java:5090)

4:35:41 PM [Debug] 0 EntUtilityMessageLogInser println SQL SELECT t1.OBJ_ID, t1.COMP_ID, t1.TRANX_ID, t1.WORK_UNIT_ID, t1.MSG_NBR, t1.EVENT_TYPE_NAME, t1.SEVERITY, t1.wm_rowid FROM WMB_EntUtility_EntUtilityMessageLogErrorInsertNotify t1 ORDER BY wm_rowid
4:35:41 PM [Debug] 0 error (059) could not load integration component “EntUtilityMessageLogInsertNotify”.
4:35:41 PM (058) could not load resource operation “EntUtilityMessageLogErrorInsertNotify”.
4:35:41 PM (057) Could not initialize script “EntUtilityMessageLogErrorInsertNotify”.
4:35:41 PM (309) Please select at least one column from the main table COM.activesw.adapter.devkit.AdapterException: (309) Please select at least one column from the main table
4:35:41 PM at java.lang.Throwable.fillInStackTrace(Native Method)

Do we need to install EntUtility adapter and MSSQL Adapter on Windows 2000 machine since EntUtility adapter is currently a JDBC adapter and there is no MSSQL adapter available on Unix?

Thanks for your help.

Ravi