Error creating JDBC Adapter with "StoredProcedureWithSignarute"

Hi all,

First I want to thank all the people who contributes and collaborates in this forum trying to help the WMs users. :slight_smile:

I’ve create a JDBC adapter selecting the option “StoredProcedureWithSignarute”, but when I select any store procedure that uses “user defined types” i get this error:

[COLOR=“Red”] com.wm.app.b2b.server.ServiceException: [ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log.
null
on procedureSignature.colIndexes [Ljava.lang.String;@fbed1b

java.lang.Exception: Adapter values are not available.[/color]

I’m using the following software and versions:

  • WebMethods v7.1.2.0
  • MS SQL Server 2008
  • JDBC Driver 4.0 for SQL Server 2008 (sqljdbc.jar)

This is the error trace written in “server.log”:

2011-04-19 12:37:45 CEST [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log.
null

And this is the info in the error log:
Service Name: wm.art.metadata:resourceDomainLookupValues
Error message: com.wm.pkg.art.error.DetailedServiceException: [ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log. null
Stack Trace:
com.wm.pkg.art.error.DetailedServiceException: [ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log.
null
at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:125)
at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:116)
at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:103)
at com.wm.pkg.art.metadata.InteractionMetadataService.resourceDomainLookupValues(InteractionMetadataService.java:255)
at sun.reflect.GeneratedMethodAccessor160.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:403)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:631)
at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:40)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:241)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:228)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:624)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:536)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:381)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:237)
at com.wm.app.b2b.server.comm.DefaultServerRequestHandler.handleMessage(DefaultServerRequestHandler.java:119)
at com.wm.app.b2b.server.HTTPMessageHandler.process(HTTPMessageHandler.java:152)
at com.wm.app.b2b.server.HTTPDispatch…

It seems that the “User defined type tables” created in SQL Server 2008 (that are part of the signature of the “StoredProcedure”) cannot be resolved. Do you know how can i make this work?

I though it could be related with the grants configured in the database, but i after changing them the problem still persist.

Any help will be appreciated.

Regards.

Hi,
It seem to me that there is some permission issue with the user name that you’re using/configuring in you JDBC adapter.
The issue is related to the ownership of the stored procedures on the DB.
Do you get any error when you create a StoreProcedure adapter service?