Error testing Reply and Target RDBMS Gateways

,
1

Hi everybody,

I made a RDBMS Target Gateway to store a record into the table Region of the database Northwind (Microsoft SQL Server).
When I test it from SMH, I get the following error:

<soapenv:Envelope xmlns:soapenv=“http://schemas.xmlsoap.org/soap/envelope/” xmlns:xsd=“XML Schema” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”>soapenv:Bodysoapenv:Faultns1:HTTP(401)Unauthorizedreturn code: 401

Apache Tomcat/4.1.24-LE-jdk14 - Error report

HTTP Status 401 -

type Status report

message

description This request requires HTTP authentication ().

Apache Tomcat/4.1.24-LE-jdk14

401

I’ve also made a Reply Gateway to select a record from Customers’ table.
When I test it from SMH, I get the following error:

<soapenv:Envelope xmlns:soapenv=“http://schemas.xmlsoap.org/soap/envelope/” xmlns:xsd=“XML Schema” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”>soapenv:Bodysoapenv:Faultsoapenv:Server.userExceptionjavax.resource.ResourceException: Invalid user / password.
Detailed Message : Unable to process request; nested exception is:
com.softwareag.fresno.persistence.ElementLoaderCreateException<ns1:hostname xmlns:ns1=“http://xml.apache.org/axis/”>sagirap04</ns1:hostname></soapenv:Fault></soapenv:Body></soapenv:Envelope>

From the XML Gateways wizard, they work fine.
I can’t understand what’s wrong with them.

Does anyone help me, please?

:frowning:

2

Hi,

Which userid and password did you use when logging into the repository?

Does it fail when you log into the repository as root/root?

Regards,

Jason

3

Hi Jason,
I log into the repository as root/root when I test the gateway into SMH and when I use the Web Service wizard.
I don’t get any errors, but the test of the web service via SMH fails as described in the last post.

Regards

Raffaele

4

Hi,

Can you make sure that you have configured Runtime User from SMH.
In SMH (Admin Console), you would see XMLGateways. Under XMLGateways, click on Runtime User node. Click on Update User and make sure user id / password are correct there.

Which version of XMLGateways are you using?

Thanks,
-Kalpesh.

5

Hi Kelpesh,

Under SMH I log to the Repository as root/root.
Now I’ve updated Runtime User as root/root too.
(It wasn’t root/root)

Unfortunately, the test of the web services fails again.

I’m using EntireX XML Gateways Version 7.2.3.1

Thanks anyway

Regards

Raffaele

6

Hi,

Can you send us the detailed exception or server.log of JBOSS. It may help us to find more hints regarding the problem.

Thanks,
-Kalpesh.

7

Hi Kalpesh,
after I’ve changed Runtime user, the errors changed too.
More exactly, when I test the target gateway, I get the following error:

<soapenv:Envelope xmlns:soapenv=“http://schemas.xmlsoap.org/soap/envelope/” xmlns:xsd=“XML Schema” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”>soapenv:Bodysoapenv:Faultns1:HTTP(401)Unauthorizedreturn code: 401

Apache Tomcat/4.1.24-LE-jdk14 - Error report

HTTP Status 401 -

type Status report

message

description This request requires HTTP authentication ().

Apache Tomcat/4.1.24-LE-jdk14

401

while, testing the reply gateway, I get the following error:

<soapenv:Envelope xmlns:soapenv=“http://schemas.xmlsoap.org/soap/envelope/” xmlns:xsd=“XML Schema” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”>soapenv:Bodysoapenv:Faultsoapenv:Server.userExceptionjavax.resource.ResourceException: Failed to connect to database. The reason is null .; nested exception is:
com.softwareag.fresno.resourceadapter.managed.ManagedAdapterConnectionException: Failed to connect to database. The reason is null .<ns1:hostname xmlns:ns1=“http://xml.apache.org/axis/”>sagirap04</ns1:hostname></soapenv:Fault></soapenv:Body></soapenv:Envelope>

I’ve attached server.log file to this post.

Regards

Raffaele
server.log (186 KB)

8

Hi Raffaele,

I noticed that the MS JDBC driver is both in \server\default\lib and
\server\default\deploy. Can you remove the driver jars from \server\default\lib restart Jboss and test the Gateways from the administration console again?

Jason