I am trying to create a select adapter service to a table on MSSQL 2008 but when i save it, it does not create output signature and when i run it, I get the following error.
2010-06-25 10:17:49 CDT [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service cb_UserDetails:test.
[ART.114.505] Error while invoking adapter service com.wm.adapter.wmjdbc.services.Select.
I am using Type 4 JDBC driver (sqljdbc4.jar) to connect to the database and there are no issues with the adapter connection. I also have the latest JDBC fix 21.