Hi all,
First I want to thank all the people who contributes and collaborates in this forum trying to help the WMs users. 
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.