Problem Creating Proxy Tables for Webservices

[jonathanchan]

Hello,

Actually I've posted the following question in the
"ase.general" group for more than a month. However maybe
that was not the right place for Webservices matters, so I
got no reply so far.

Hope I may have some luck here...

TIA,
Jonathan
------

Hi,

I was looking for a news group for the ASE WebServices but
found none, so I post my problem here.

I'm using ASE 15.0.2 and have installed the requried
components for Web Services and now my producer and consumer
services are running.

I've created a webservice method as below:

create service getDetails
secure clear,
userpath 'myservices'
type xml @arg1 char(3)
as
select * from mydb..my_table where cde = @arg1

I then deployed the service with:
sp_webservices 'deploy', 'getDetails'

I tested out the wsdl generated and it looked ok.

I wanted to test the service in the same ASE server, so I
tried to create a proxy table for this service:

sp_webservices 'add',
'http://myhost:48181/services/mydb/myservices?wsdl'

However, my proxy table cannot be created, with a message
logged in the webservice.log file.

2007-10-25 11:54:52.574 INFO [Thread-87] - Begin parsing
WSDL File: [http://myhost:48181/services
/mydb/myservices?wsdl]
2007-10-25 11:54:52.646 ERROR [Thread-89] - Skipped
operation [getDetails]
2007-10-25 11:54:52.647 INFO [Thread-87] - Completed
parsing WSDL File:
[http://myhost:48181/services/mydb/myservices?wsdl]

So my question is, why is the "getDetails" operation skipped
in the parsing of the wsdl file? Do I miss anything?

TIA,
Jonathan

[A. M.]

Jonathan Chan wrote:
>
> Actually I've posted the following question in the
> "ase.general" group for more than a month. However maybe
> that was not the right place for Webservices matters, so I
> got no reply so far.

It might be because not many are familiar with this product yet.

Since sp_webservices is a stored prcedure, I'd start
by looking at its source and work out what its doing.
Its probably making XP calls to external functions.

-am © 2007

[jonathanchan]

Thanks, A.M.

Yes, this error happens when making an external call to
ws...get_mappings. Any further tracing would you suggest?

[A. M.]

Jonathan Chan wrote:
>
> Yes, this error happens when making an external call to
> ws...get_mappings. Any further tracing would you suggest?

I'm not sure what that is. It looks odd. Can you post
the actual code from the sproc around that line?

Can you also post the output of sp_helpserver? May also
need to see the interfaces file. We need to figure out
what "ws" is or what it refers to. Obviously, it looks
like ws stands for webservices. However, its the
definition of ws that we need to examine. It appears
to be an Open Server application along the lines of XP
Server.

-am © 2007

[jonathanchan]

Excerpt from sp_help sp_webservices:

/* Move the results of the proxy table into the
*/
/* temporary table. Make sure to take the skipped
column */
/* information as well. */

select @strtoexec = "insert into #wsvalues select
cetsql, operation, tablename, skipped from tempdb.." +
@wsdltabname + " where _wsdl='" + @wsdluri + "'" + " and
_overrides='" + @proxy_overrides + "'"
exec(@strtoexec)

In my case, when executing up to this line, @wsdltabname is
'ws_120707c337e142f4a', and @wsdluri is
'http://myhost:48181/services/mydb/myservices?wsdl'.

so the actual codes running should be:

select * from tempdb..ws_120707c337e142f4a where _wsdl =
'http://myhost:48181/services/mydb/myservices?wsdl' and
_overrides = null

tempdb..ws_120707c337e142f4a is actually a proxy table
created to link to ws...get_mappings (created by some
previous codes in sp_webservices).

The error I got from isql is:
Server Message: Number 3621, Severity 10
Server 'MYSERVER', Line 1:
Command has been aborted.
Server Message: Number 15200, Severity 20
Server 'ws', Line 1:
No web methods mapped to proxy tables for the WSDL URI
[http://myhost:48181/services/mydb/myservices?wsdl].

While @@error is 15200.

Output from "sp_helpserver ws"

ws MYSERVER_WS sds timeouts, no net
password encryption, writable , rpc security model A

11 1000

I can connect to ws(passthru mode) from my ASE server to ws
(through CIS) without problem.

Thanks.

[A. M.]

Jonathan Chan wrote:
>
> so the actual codes running should be:
>
> select * from tempdb..ws_120707c337e142f4a where _wsdl =
> 'http://myhost:48181/services/mydb/myservices?wsdl' and
> _overrides = null
>
> tempdb..ws_120707c337e142f4a is actually a proxy table
> created to link to ws...get_mappings (created by some
> previous codes in sp_webservices).
>
> The error I got from isql is:
> Server Message: Number 3621, Severity 10
> Server 'MYSERVER', Line 1:
> Command has been aborted.

I looked up this error number online. The write up
was useless.

> Server Message: Number 15200, Severity 20
> Server 'ws', Line 1:
> No web methods mapped to proxy tables for the WSDL URI
> [http://myhost:48181/services/mydb/myservices?wsdl].

What does this URL map to? A physical file on your
server or is it something internal to ws?

> Output from "sp_helpserver ws"
>
> ws MYSERVER_WS sds timeouts, no net
> password encryption, writable , rpc security model A
>
> 11 1000
>
> I can connect to ws(passthru mode) from my ASE server to ws
> (through CIS) without problem.

OK, so that works. I'm not sure what else to try.
Perhaps create the proxy table manually (give it
a simpler name to save you typing too much) and
then try a simple select statement. If you get
error 3621, its either the proxy table or the ws.
Perhaps just a "select * from" it to see what
it actually has. The URL might just be malformed.

Does anything show up in ASE's error log?

I gather you've already tried the logging with the
diagnostic tool -

http://infocenter.sybase.com/help/topic/com.sybase.dc10061_1500/html/wbsrvcs/CHDHCJFB.htm

-am © 2007