Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

sp_webservices add duplicate proxy table

7 posts in General Discussion Last posting was on 2011-01-17 16:18:21.0Z
Jose-Miguel Torres Posted on 2011-01-13 15:36:04.0Z
Sender: 492e.4d2f19de.1804289383@sybase.com
From: Jose-Miguel Torres
Newsgroups: sybase.public.ase.general
Subject: sp_webservices add duplicate proxy table
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d2f1be4.4a04.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 Jan 2011 07:36:04 -0800
X-Trace: forums-1-dub 1294932964 10.22.241.41 (13 Jan 2011 07:36:04 -0800)
X-Original-Trace: 13 Jan 2011 07:36:04 -0800, 10.22.241.41
Lines: 24
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29855
Article PK: 79082

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


J Posted on 2011-01-13 16:33:40.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: sp_webservices add duplicate proxy table
Reply-To: J@bogusemailAddress.com
Message-ID: <4d2f261f.2074678250@forums.sybase.com>
References: <4d2f1be4.4a04.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 13 Jan 2011 08:33:40 -0800
X-Trace: forums-1-dub 1294936420 10.22.241.152 (13 Jan 2011 08:33:40 -0800)
X-Original-Trace: 13 Jan 2011 08:33:40 -0800, vip152.sybase.com
Lines: 34
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29856
Article PK: 79085

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


Jose-Miguel Torres Posted on 2011-01-13 18:09:06.0Z
Sender: 492e.4d2f19de.1804289383@sybase.com
From: Jose-Miguel Torres
Newsgroups: sybase.public.ase.general
Subject: Re: sp_webservices add duplicate proxy table
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d2f3fc2.5a03.1681692777@sybase.com>
References: <4d2f261f.2074678250@forums.sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 Jan 2011 10:09:06 -0800
X-Trace: forums-1-dub 1294942146 10.22.241.41 (13 Jan 2011 10:09:06 -0800)
X-Original-Trace: 13 Jan 2011 10:09:06 -0800, 10.22.241.41
Lines: 40
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29857
Article PK: 79086

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
>


Jose-Miguel Torres Posted on 2011-01-14 14:34:44.0Z
Sender: 64cb.4d2f5aba.1804289383@sybase.com
From: Jose-Miguel Torres
Newsgroups: sybase.public.ase.general
Subject: Re: sp_webservices add duplicate proxy table
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d305f04.211b.1681692777@sybase.com>
References: <4d2f3fc2.5a03.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 14 Jan 2011 06:34:44 -0800
X-Trace: forums-1-dub 1295015684 10.22.241.41 (14 Jan 2011 06:34:44 -0800)
X-Original-Trace: 14 Jan 2011 06:34:44 -0800, 10.22.241.41
Lines: 52
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29858
Article PK: 79088

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
> >


"Mark A. Parsons" <iron_horse Posted on 2011-01-14 21:23:02.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: sp_webservices add duplicate proxy table
References: <4d2f3fc2.5a03.1681692777@sybase.com> <4d305f04.211b.1681692777@sybase.com>
In-Reply-To: <4d305f04.211b.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d30beb6$1@forums-1-dub>
Date: 14 Jan 2011 13:23:02 -0800
X-Trace: forums-1-dub 1295040182 10.22.241.152 (14 Jan 2011 13:23:02 -0800)
X-Original-Trace: 14 Jan 2011 13:23:02 -0800, vip152.sybase.com
Lines: 85
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29859
Article PK: 79089

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


"Mark A. Parsons" <iron_horse Posted on 2011-01-14 21:29:01.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: sp_webservices add duplicate proxy table
References: <4d2f3fc2.5a03.1681692777@sybase.com> <4d305f04.211b.1681692777@sybase.com> <4d30beb6$1@forums-1-dub>
In-Reply-To: <4d30beb6$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d30c01d$1@forums-1-dub>
Date: 14 Jan 2011 13:29:01 -0800
X-Trace: forums-1-dub 1295040541 10.22.241.152 (14 Jan 2011 13:29:01 -0800)
X-Original-Trace: 14 Jan 2011 13:29:01 -0800, vip152.sybase.com
Lines: 101
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29860
Article PK: 79087

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


Jose-Miguel Torres Posted on 2011-01-17 16:18:21.0Z
Sender: 3873.4d34688c.1804289383@sybase.com
From: Jose-Miguel Torres
Newsgroups: sybase.public.ase.general
Subject: Re: sp_webservices add duplicate proxy table
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d346bcc.38dc.1681692777@sybase.com>
References: <4d30c01d$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Jan 2011 08:18:21 -0800
X-Trace: forums-1-dub 1295281101 10.22.241.41 (17 Jan 2011 08:18:21 -0800)
X-Original-Trace: 17 Jan 2011 08:18:21 -0800, 10.22.241.41
Lines: 116
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29861
Article PK: 79090

Thank you Mark,
We'll try to exec the with the syntax you suggested and
check for the # of rows. Then I'll be back with you

Regards
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/Se
> > rviciosERP.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