Hello,
Using ASE 15.0.3 ESD#3 AIX and  ASE WS, when mapping method
:

sp_webservices 'add',
'http://intranetweb40/sitiosinternos/WSERP/ServiciosERP/ServiciosERP.asmx?WSDL'

two  rows appear in sysobjcts , but, the method did not
exist before, i.e:

select * from  sysobjects   where name like "WS_%"
go
--------------------
WS_ExisteCtaAuxMnd
WS_ExisteCtaAuxMnd1

We know This is the normal behaviour if the method
previuosly existed, but in ths case it didn't and we tried
with sp_webservices "remove" before adding it, but the
result was the same.

IS this some known issue?
Thanks
JMT

On 13 Jan 2011 07:36:04 -0800, Jose-Miguel Torres wrote:

According to the doc. this would be the case if the proxy table
already existed. Was there some activity where the there was possibly
and add/remove but the proxy table still exists?

Jay 


>Hello,
>Using ASE 15.0.3 ESD#3 AIX and  ASE WS, when mapping method
>:
>
>sp_webservices 'add',
>'http://intranetweb40/sitiosinternos/WSERP/ServiciosERP/ServiciosERP.asmx?WSDL'
>
>two  rows appear in sysobjcts , but, the method did not
>exist before, i.e:
>
>select * from  sysobjects   where name like "WS_%"
>go
>--------------------
>WS_ExisteCtaAuxMnd
>WS_ExisteCtaAuxMnd1
>
>We know This is the normal behaviour if the method
>previuosly existed, but in ths case it didn't and we tried
>with sp_webservices "remove" before adding it, but the
>result was the same.
>
>IS this some known issue?
>Thanks
>JMT

Thanks Jay,
Not sure. I'll check that and come back

Regards
JMT
> On 13 Jan 2011 07:36:04 -0800, Jose-Miguel Torres wrote:
>
> According to the doc. this would be the case if the proxy
> table already existed. Was there some activity where the
> there was possibly and add/remove but the proxy table
> still exists?
>
> Jay
>
>
> >Hello,
> >Using ASE 15.0.3 ESD#3 AIX and  ASE WS, when mapping
> method >:
> >
> >sp_webservices 'add',
> >'http://intranetweb40/sitiosinternos/WSERP/ServiciosERP/S
> erviciosERP.asmx?WSDL' >
> >two  rows appear in sysobjcts , but, the method did not
> >exist before, i.e:
> >
> >select * from  sysobjects   where name like "WS_%"
> >go
> >--------------------
> >WS_ExisteCtaAuxMnd
> >WS_ExisteCtaAuxMnd1
> >
> >We know This is the normal behaviour if the method
> >previuosly existed, but in ths case it didn't and we
> tried >with sp_webservices "remove" before adding it, but
> the >result was the same.
> >
> >IS this some known issue?
> >Thanks
> >JMT
>

Jay,
 Yes. The mapped methods existed previously and were
removed. Then each time they are added they appear with
proxy_table<digit>.
Even though they are dropped and then re-added the same
behaviour persists.

Thank you

JMT

> Thanks Jay,
> Not sure. I'll check that and come back
>
> Regards
> JMT
> > On 13 Jan 2011 07:36:04 -0800, Jose-Miguel Torres wrote:
> >
> > According to the doc. this would be the case if the
> > proxy table already existed. Was there some activity
> > where the there was possibly and add/remove but the
> > proxy table still exists?
> >
> > Jay
> >
> >
> > >Hello,
> > >Using ASE 15.0.3 ESD#3 AIX and  ASE WS, when mapping
> > method >:
> > >
> > >sp_webservices 'add',
> >
> >
> >'http://intranetweb40/sitiosinternos/WSERP/ServiciosERP/S
> > erviciosERP.asmx?WSDL' > >two  rows appear in sysobjcts
> > , but, the method did not >exist before, i.e:
> > >
> > >select * from  sysobjects   where name like "WS_%"
> > >go
> > >--------------------
> > >WS_ExisteCtaAuxMnd
> > >WS_ExisteCtaAuxMnd1
> > >
> > >We know This is the normal behaviour if the method
> > >previuosly existed, but in ths case it didn't and we
> > tried >with sp_webservices "remove" before adding it,
> > but the >result was the same.
> > >
> > >IS this some known issue?
> > >Thanks
> > >JMT
> >

I don't work with any sort of web services software (other than as a dumb browser user) so fwiw ...

I looked at the source code for sp_webservices ($SYBASE/WS-15_0/bin/installws) and found it doing the following:

==============================================
- create a temporary proxy table to be used to pull results from the WS's get_mappings stored proc

- pull WS's mappings and put into a #temp table

- for each row in the mappings #temp table do:

      - generate a new object with a given name

      - validate that the desired name is unique

          - if not unique, add a sequential number on end of the name
==============================================

Sooo, I'm thinking the get_mappings call is returning 2 records, which in turn causes 2 passes through the looping 
construct, which in turn creates the 2 new objects ... one with the desired name, one with the desired name + '1'.

 From the sp_web services source code it looks like you may be able to issue the get_mappings call manually with 
something like the following:

exec <WS_name>...get_mappings 'http://intranetweb40/sitiosinternos/WSERP/ServiciosERP/ServiciosERP.asmx?WSDL' [, NULL]

Where <WS_name> is your webservices name as it appears in sysservers.

If you can get the get_mappings call to work manually, do you get 1 or 2 rows in the result set?  do the results make sense?

At this point I'm gonna go out on a limb and guess that if the get_mappings call is returning 2 rows, then either a) the 
URL does in fact require 2 objects to reference it or b) there's a bug/problem with at the URL ("Duh, Mark!" ?).

Apologies if I botched the terminology! ;-)



Jose-Miguel Torres wrote:
> Jay,
>  Yes. The mapped methods existed previously and were
> removed. Then each time they are added they appear with
> proxy_table<digit>.
> Even though they are dropped and then re-added the same
> behaviour persists.
> 
> Thank you
> 
> JMT
> 
>> Thanks Jay,
>> Not sure. I'll check that and come back
>>
>> Regards
>> JMT
>>> On 13 Jan 2011 07:36:04 -0800, Jose-Miguel Torres wrote:
>>>
>>> According to the doc. this would be the case if the
>>> proxy table already existed. Was there some activity
>>> where the there was possibly and add/remove but the
>>> proxy table still exists?
>>>
>>> Jay
>>>
>>>
>>>> Hello,
>>>> Using ASE 15.0.3 ESD#3 AIX and  ASE WS, when mapping
>>> method >:
>>>> sp_webservices 'add',
>>>
>>> 'http://intranetweb40/sitiosinternos/WSERP/ServiciosERP/S
>>> erviciosERP.asmx?WSDL' > >two  rows appear in sysobjcts
>>> , but, the method did not >exist before, i.e:
>>>> select * from  sysobjects   where name like "WS_%"
>>>> go
>>>> --------------------
>>>> WS_ExisteCtaAuxMnd
>>>> WS_ExisteCtaAuxMnd1
>>>>
>>>> We know This is the normal behaviour if the method
>>>> previuosly existed, but in ths case it didn't and we
>>> tried >with sp_webservices "remove" before adding it,
>>> but the >result was the same.
>>>> IS this some known issue?
>>>> Thanks
>>>> JMT

ps - if you can't get the manual get_mappings call to work, you should be able to manually perform the same steps as 
they appear in the sp_webservices stored proc, with the idea being to access the get_mappings call via the temporary 
proxy table front end; alternatively, modify sp_webservices to dump the contents of that temp table the get_mappings 
call has completed; alternatively, use sqldbgr to step through sp_webservices to obtain the results of the get_mappings call

Mark A. Parsons wrote:
> I don't work with any sort of web services software (other than as a 
> dumb browser user) so fwiw ...
> 
> I looked at the source code for sp_webservices 
> ($SYBASE/WS-15_0/bin/installws) and found it doing the following:
> 
> ==============================================
> - create a temporary proxy table to be used to pull results from the 
> WS's get_mappings stored proc
> 
> - pull WS's mappings and put into a #temp table
> 
> - for each row in the mappings #temp table do:
> 
>      - generate a new object with a given name
> 
>      - validate that the desired name is unique
> 
>          - if not unique, add a sequential number on end of the name
> ==============================================
> 
> Sooo, I'm thinking the get_mappings call is returning 2 records, which 
> in turn causes 2 passes through the looping construct, which in turn 
> creates the 2 new objects ... one with the desired name, one with the 
> desired name + '1'.
> 
>  From the sp_web services source code it looks like you may be able to 
> issue the get_mappings call manually with something like the following:
> 
> exec <WS_name>...get_mappings 
> 'http://intranetweb40/sitiosinternos/WSERP/ServiciosERP/ServiciosERP.asmx?WSDL' 
> [, NULL]
> 
> Where <WS_name> is your webservices name as it appears in sysservers.
> 
> If you can get the get_mappings call to work manually, do you get 1 or 2 
> rows in the result set?  do the results make sense?
> 
> At this point I'm gonna go out on a limb and guess that if the 
> get_mappings call is returning 2 rows, then either a) the URL does in 
> fact require 2 objects to reference it or b) there's a bug/problem with 
> at the URL ("Duh, Mark!" ?).
> 
> Apologies if I botched the terminology! ;-)
> 
> 
> 
> Jose-Miguel Torres wrote:
>> Jay,
>>  Yes. The mapped methods existed previously and were
>> removed. Then each time they are added they appear with
>> proxy_table<digit>.
>> Even though they are dropped and then re-added the same
>> behaviour persists.
>>
>> Thank you
>>
>> JMT
>>
>>> Thanks Jay,
>>> Not sure. I'll check that and come back
>>>
>>> Regards
>>> JMT
>>>> On 13 Jan 2011 07:36:04 -0800, Jose-Miguel Torres wrote:
>>>>
>>>> According to the doc. this would be the case if the
>>>> proxy table already existed. Was there some activity
>>>> where the there was possibly and add/remove but the
>>>> proxy table still exists?
>>>>
>>>> Jay
>>>>
>>>>
>>>>> Hello,
>>>>> Using ASE 15.0.3 ESD#3 AIX and  ASE WS, when mapping
>>>> method >:
>>>>> sp_webservices 'add',
>>>>
>>>> 'http://intranetweb40/sitiosinternos/WSERP/ServiciosERP/S
>>>> erviciosERP.asmx?WSDL' > >two  rows appear in sysobjcts
>>>> , but, the method did not >exist before, i.e:
>>>>> select * from  sysobjects   where name like "WS_%"
>>>>> go
>>>>> --------------------
>>>>> WS_ExisteCtaAuxMnd
>>>>> WS_ExisteCtaAuxMnd1
>>>>>
>>>>> We know This is the normal behaviour if the method
>>>>> previuosly existed, but in ths case it didn't and we
>>>> tried >with sp_webservices "remove" before adding it,
>>>> but the >result was the same.
>>>>> IS this some known issue?
>>>>> Thanks
>>>>> JMT