Failed to run resourceDomainLookupValues service

, ,
1

We have installed 7.1 on AIX. I am trying to deploy our application on it. When I tried to run a JDBC service I got the following error, please look at it urgently as I cannot proceed with resolving this.

wm.art.metadata:resourceDomainLookupValues com.wm.pkg.art.error.DetailedServiceException: [ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log.

[ADA.1.322] Cannot get the list of tables. " (42000/932) ORA-00932: inconsistent datatypes: expected %s got %s " ORA-00932: inconsistent datatypes: expected %s got %s

:frowning:

2

In my JDBC service, I can’t choose table if I want to create a SelectSQL Adapter (in the Tables tab). I try with a “CustomSQL” adapter and it works.

3

As suggested here [URL=“http://advantage.webmethods.com/article/?id=SR-1-65833433”]http://advantage.webmethods.com/article/?id=SR-1-65833433[/URL]
you should try a more recent Oracle jdbc driver.

4

YES !!! Problem solved !! I have downloaded the ultimate oracle driver

5

Unable to create the EJB Adapter service - Getting the below exception

[ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log.
[ADA.640.3032] Unexpected exception looking-up resource domain: jndiNameBoxDomain
null
on jndiNameBox [Ljava.lang.String;@440a4d72[ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log.
[ADA.640.3032] Unexpected exception looking-up resource domain: jndiNameBoxDomain
null
on jndiNameBox [Ljava.lang.String;@440a4d72