Remote server class definition setting

Include the following in the “Troubleshooting Issues” section of Chapter 7, “Troubleshooting” in the Adaptive Server Enterprise Web Services User’s Guide.

Issue

The sp_webservices add command may return the following error when generating proxy tables:

Warning: Row size (3347 bytes) could exceed row size limit, which is 1962
bytes.
Msg 208, Level 16, State 1:
Server 'JMALVARADO', Line 1:
tempdb..ws_4338e6e122cd4ef0a not found. Specify owner.objectname or uses to
check whether the object exists (sp_help may produce lots of output).
No proxy tables were created for the WSDL URL:
[http://www.xignite.com/xquotes.asmx?WSDL]
(return status = 0)

This error occurs because the remote server representing the Web Services Consumer has been added using sp_addserver with a class other than “sds.” To verify that this is so, use sp_helpserver in isql:

1> sp_helpserver ws
2> go

Here, ws is the name of the Web Services Consumer. This is the default. The remote server class is returned in the indicated column of the result:

name network_name class ...
---- ------------ ----- ...
ws   ws           null  ...

User action

Change the class of the remote server to “sds” by using sp_dropserver and sp_addserver in isql:

1> sp_dropserver ws_name
2> go
...
1> sp_addserver ws_name, sds, ws_name
2> go

Here, ws_name is the name chosen for the Web Services Consumer.

Copyright © 2005. Sybase Inc. All rights reserved.

View this release bulletin as PDF