RE: Qwerky Stored Procedure issue
Larry reported an odd problem on Solaris 10 with IDS 11.50.FC7: an SPL stored procedure called via an API loads comma-delimited web data into a database, works the first few times, then silently does nothing with no error message — yet runs flawlessly when TRACE ON is enabled. Paul Watson suggested running oncheck -cDI on sysprocedures and sysprocplan, doubted extents or stale statistics were to blame, and asked whether the input file was truly identical between the failing and traced runs; he also noted the developer's TRACE OFF placed after RETURN is simply never executed. Fernando Nunes questioned the description, since SPL cannot read files itself. No resolution is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I am running two Sun servers running Solaris 10 and IDS 11.50.FC7. I have an interesting situation. I am starting to gather more information, but I was wondering if anyone may have experienced this and can give me an idea of what to look for. An application developer created a Stored Procedure that is called via API. It basically takes information gathered from a web site, comma delimited file, and inputs it into a database. The Stored Procedure may work once to a few times, but then it appears to not do anything, no data files processed, with no error messages. However, when we turn TRACE ON in the same Stored procedure, it works flawlessly. Does this ring any bells with anyone? Larry
No... but you got my attention... Does it open files?!...You mean an SPL procedure? With TRACE it works forever? Sounds weird... but witout any details I have no ideas... On Dec 3, 2013 7:23 PM, "LARRY SORENSEN" <lsorensen25@msn.com> wrote: > I am running two Sun servers running Solaris 10 and IDS 11.50.FC7. > > I have an interesting situation. I am starting to gather more information, > but > I was wondering if anyone may have experienced this and can give me an > idea of > what to look for. > > An application developer created a Stored Procedure that is called via > API. It > basically takes information gathered from a web site, comma delimited file, > and inputs it into a database. The Stored Procedure may work once to a few > times, but then it appears to not do anything, no data files processed, > with > no error messages. However, when we turn TRACE ON in the same Stored > procedure, it works flawlessly. > > Does this ring any bells with anyone? > > Larry > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0122a0865e643c04eca7cd6d
Is there a way to check the health of Stored Procedures such as oncheck with
an option or some other command?
Larry
> To: ids@iiug.org
> From: lsorensen25@msn.com
> Subject: RE: Qwerky Stored Procedure issue [32082]
> Date: Tue, 3 Dec 2013 14:22:47 -0500
>
> I am running two Sun servers running Solaris 10 and IDS 11.50.FC7.
>
> I have an interesting situation. I am starting to gather more information,
but
> I was wondering if anyone may have experienced this and can give me an idea
of
> what to look for.
>
> An application developer created a Stored Procedure that is called via API.
It
> basically takes information gathered from a web site, comma delimited file,
> and inputs it into a database. The Stored Procedure may work once to a few
> times, but then it appears to not do anything, no data files processed, with
> no error messages. However, when we turn TRACE ON in the same Stored
> procedure, it works flawlessly.
>
> Does this ring any bells with anyone?
>
> Larry
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
How do you define health ? If the SPL compliles then it exists, if it
doesn't then it doesn't.
You can run oncheck on the sysprocedures and sysprocplan
Cheers
Paul
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> LARRY SORENSEN
> Sent: Friday, December 06, 2013 12:37 PM
> To: ids@iiug.org
> Subject: RE: Qwerky Stored Procedure issue [32100]
>
> Is there a way to check the health of Stored Procedures such as oncheck
with
> an option or some other command?
>
> Larry
>
> > To: ids@iiug.org
> > From: lsorensen25@msn.com
> > Subject: RE: Qwerky Stored Procedure issue [32082]
> > Date: Tue, 3 Dec 2013 14:22:47 -0500
> >
> > I am running two Sun servers running Solaris 10 and IDS 11.50.FC7.
> >
> > I have an interesting situation. I am starting to gather more
information,
> but
> > I was wondering if anyone may have experienced this and can give me an
> idea
> of
> > what to look for.
> >
> > An application developer created a Stored Procedure that is called via
API.
> It
> > basically takes information gathered from a web site, comma delimited
file,
> > and inputs it into a database. The Stored Procedure may work once to a
> few
> > times, but then it appears to not do anything, no data files processed,
with
> > no error messages. However, when we turn TRACE ON in the same Stored
> > procedure, it works flawlessly.
> >
> > Does this ring any bells with anyone?
> >
> > Larry
> >
> >
> >
> **********************************************************
> *********************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
> **********************************************************
> *********************
> Forum Note: Use "Reply" to post a response in the discussion forum.
Are there any special options for checking the sysprocedures and sysprocplan?
Larry
> To: ids@iiug.org
> From: paul@oninit.com
> Subject: RE: Qwerky Stored Procedure issue [32101]
> Date: Fri, 6 Dec 2013 13:41:55 -0500
>
> How do you define health ? If the SPL compliles then it exists, if it
> doesn't then it doesn't.
>
> You can run oncheck on the sysprocedures and sysprocplan
>
> Cheers
> Paul
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > LARRY SORENSEN
> > Sent: Friday, December 06, 2013 12:37 PM
> > To: ids@iiug.org
> > Subject: RE: Qwerky Stored Procedure issue [32100]
> >
> > Is there a way to check the health of Stored Procedures such as oncheck
> with
> > an option or some other command?
> >
> > Larry
> >
> > > To: ids@iiug.org
> > > From: lsorensen25@msn.com
> > > Subject: RE: Qwerky Stored Procedure issue [32082]
> > > Date: Tue, 3 Dec 2013 14:22:47 -0500
> > >
> > > I am running two Sun servers running Solaris 10 and IDS 11.50.FC7.
> > >
> > > I have an interesting situation. I am starting to gather more
> information,
> > but
> > > I was wondering if anyone may have experienced this and can give me an
> > idea
> > of
> > > what to look for.
> > >
> > > An application developer created a Stored Procedure that is called via
> API.
> > It
> > > basically takes information gathered from a web site, comma delimited
> file,
> > > and inputs it into a database. The Stored Procedure may work once to a
> > few
> > > times, but then it appears to not do anything, no data files processed,
> with
> > > no error messages. However, when we turn TRACE ON in the same Stored
> > > procedure, it works flawlessly.
> > >
> > > Does this ring any bells with anyone?
> > >
> > > Larry
> > >
> > >
> > >
> > **********************************************************
> > *********************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> > **********************************************************
> > *********************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Not that I am aware of - I would just run with -cDI
Cheers
Paul
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> LARRY SORENSEN
> Sent: Friday, December 06, 2013 12:55 PM
> To: ids@iiug.org
> Subject: RE: Qwerky Stored Procedure issue [32102]
>
> Are there any special options for checking the sysprocedures and
> sysprocplan?
>
> Larry
>
> > To: ids@iiug.org
> > From: paul@oninit.com
> > Subject: RE: Qwerky Stored Procedure issue [32101]
> > Date: Fri, 6 Dec 2013 13:41:55 -0500
> >
> > How do you define health ? If the SPL compliles then it exists, if it
> > doesn't then it doesn't.
> >
> > You can run oncheck on the sysprocedures and sysprocplan
> >
> > Cheers
> > Paul
> >
> > > -----Original Message-----
> > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > > LARRY SORENSEN
> > > Sent: Friday, December 06, 2013 12:37 PM
> > > To: ids@iiug.org
> > > Subject: RE: Qwerky Stored Procedure issue [32100]
> > >
> > > Is there a way to check the health of Stored Procedures such as
oncheck> > with
> > > an option or some other command?
> > >
> > > Larry
> > >
> > > > To: ids@iiug.org
> > > > From: lsorensen25@msn.com
> > > > Subject: RE: Qwerky Stored Procedure issue [32082]
> > > > Date: Tue, 3 Dec 2013 14:22:47 -0500
> > > >
> > > > I am running two Sun servers running Solaris 10 and IDS 11.50.FC7.
> > > >
> > > > I have an interesting situation. I am starting to gather more
> > information,
> > > but
> > > > I was wondering if anyone may have experienced this and can give me
> an
> > > idea
> > > of
> > > > what to look for.
> > > >
> > > > An application developer created a Stored Procedure that is called
via
> > API.
> > > It
> > > > basically takes information gathered from a web site, comma
delimited
> > file,
> > > > and inputs it into a database. The Stored Procedure may work once to
a
> > > few
> > > > times, but then it appears to not do anything, no data files
processed,
> > with
> > > > no error messages. However, when we turn TRACE ON in the same
> Stored
> > > > procedure, it works flawlessly.
> > > >
> > > > Does this ring any bells with anyone?
> > > >
> > > > Larry
> > > >
> > > >
> > > >
> > >
> **********************************************************
> > > *********************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > >
> > >
> > >
> **********************************************************
> > > *********************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> **********************************************************
> *********************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
> **********************************************************
> *********************
> Forum Note: Use "Reply" to post a response in the discussion forum.
Thank you. I will give it a try.
Do you think having a lot of extents could be the problem, or maybe the
statistics are just out of wack for the table?
Larry
> To: ids@iiug.org
> From: paul@oninit.com
> Subject: RE: Qwerky Stored Procedure issue [32104]
> Date: Fri, 6 Dec 2013 14:00:41 -0500
>
> Not that I am aware of - I would just run with -cDI
>
> Cheers
> Paul
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > LARRY SORENSEN
> > Sent: Friday, December 06, 2013 12:55 PM
> > To: ids@iiug.org
> > Subject: RE: Qwerky Stored Procedure issue [32102]
> >
> > Are there any special options for checking the sysprocedures and
> > sysprocplan?
> >
> > Larry
> >
> > > To: ids@iiug.org
> > > From: paul@oninit.com
> > > Subject: RE: Qwerky Stored Procedure issue [32101]
> > > Date: Fri, 6 Dec 2013 13:41:55 -0500
> > >
> > > How do you define health ? If the SPL compliles then it exists, if it
> > > doesn't then it doesn't.
> > >
> > > You can run oncheck on the sysprocedures and sysprocplan
> > >
> > > Cheers
> > > Paul
> > >
> > > > -----Original Message-----
> > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > > > LARRY SORENSEN
> > > > Sent: Friday, December 06, 2013 12:37 PM
> > > > To: ids@iiug.org
> > > > Subject: RE: Qwerky Stored Procedure issue [32100]
> > > >
> > > > Is there a way to check the health of Stored Procedures such as
> oncheck> > > with
> > > > an option or some other command?
> > > >
> > > > Larry
> > > >
> > > > > To: ids@iiug.org
> > > > > From: lsorensen25@msn.com
> > > > > Subject: RE: Qwerky Stored Procedure issue [32082]
> > > > > Date: Tue, 3 Dec 2013 14:22:47 -0500
> > > > >
> > > > > I am running two Sun servers running Solaris 10 and IDS 11.50.FC7.
> > > > >
> > > > > I have an interesting situation. I am starting to gather more
> > > information,
> > > > but
> > > > > I was wondering if anyone may have experienced this and can give me
> > an
> > > > idea
> > > > of
> > > > > what to look for.
> > > > >
> > > > > An application developer created a Stored Procedure that is called
> via
> > > API.
> > > > It
> > > > > basically takes information gathered from a web site, comma
> delimited
> > > file,
> > > > > and inputs it into a database. The Stored Procedure may work once to
> a
> > > > few
> > > > > times, but then it appears to not do anything, no data files
> processed,
> > > with
> > > > > no error messages. However, when we turn TRACE ON in the same
> > Stored
> > > > > procedure, it works flawlessly.
> > > > >
> > > > > Does this ring any bells with anyone?
> > > > >
> > > > > Larry
> > > > >
> > > > >
> > > > >
> > > >
> > **********************************************************
> > > > *********************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > >
> > > >
> > > >
> > **********************************************************
> > > > *********************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> > >
> > **********************************************************
> > *********************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> > **********************************************************
> > *********************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Unlikely unless there is a bug.
Are you 100% certain that the file that fails in normal running is exactly
the same as the one you are running in debug mode
Cheers
Paul
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> LARRY SORENSEN
> Sent: Friday, December 06, 2013 1:10 PM
> To: ids@iiug.org
> Subject: RE: Qwerky Stored Procedure issue [32106]
>
> Thank you. I will give it a try.
>
> Do you think having a lot of extents could be the problem, or maybe the
> statistics are just out of wack for the table?
>
> Larry
>
> > To: ids@iiug.org
> > From: paul@oninit.com
> > Subject: RE: Qwerky Stored Procedure issue [32104]
> > Date: Fri, 6 Dec 2013 14:00:41 -0500
> >
> > Not that I am aware of - I would just run with -cDI
> >
> > Cheers
> > Paul
> >
> > > -----Original Message-----
> > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > > LARRY SORENSEN
> > > Sent: Friday, December 06, 2013 12:55 PM
> > > To: ids@iiug.org
> > > Subject: RE: Qwerky Stored Procedure issue [32102]
> > >
> > > Are there any special options for checking the sysprocedures and
> > > sysprocplan?
> > >
> > > Larry
> > >
> > > > To: ids@iiug.org
> > > > From: paul@oninit.com
> > > > Subject: RE: Qwerky Stored Procedure issue [32101]
> > > > Date: Fri, 6 Dec 2013 13:41:55 -0500
> > > >
> > > > How do you define health ? If the SPL compliles then it exists, if
it
> > > > doesn't then it doesn't.
> > > >
> > > > You can run oncheck on the sysprocedures and sysprocplan
> > > >
> > > > Cheers
> > > > Paul
> > > >
> > > > > -----Original Message-----
> > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> Of
> > > > > LARRY SORENSEN
> > > > > Sent: Friday, December 06, 2013 12:37 PM
> > > > > To: ids@iiug.org
> > > > > Subject: RE: Qwerky Stored Procedure issue [32100]
> > > > >
> > > > > Is there a way to check the health of Stored Procedures such as
> > oncheck> > > > with
> > > > > an option or some other command?
> > > > >
> > > > > Larry
> > > > >
> > > > > > To: ids@iiug.org
> > > > > > From: lsorensen25@msn.com
> > > > > > Subject: RE: Qwerky Stored Procedure issue [32082]
> > > > > > Date: Tue, 3 Dec 2013 14:22:47 -0500
> > > > > >
> > > > > > I am running two Sun servers running Solaris 10 and IDS
11.50.FC7.
> > > > > >
> > > > > > I have an interesting situation. I am starting to gather more
> > > > information,
> > > > > but
> > > > > > I was wondering if anyone may have experienced this and can give
> me
> > > an
> > > > > idea
> > > > > of
> > > > > > what to look for.
> > > > > >
> > > > > > An application developer created a Stored Procedure that is
called
> > via
> > > > API.
> > > > > It
> > > > > > basically takes information gathered from a web site, comma
> > delimited
> > > > file,
> > > > > > and inputs it into a database. The Stored Procedure may work
once
> to
> > a
> > > > > few
> > > > > > times, but then it appears to not do anything, no data files
> > processed,
> > > > with
> > > > > > no error messages. However, when we turn TRACE ON in the same
> > > Stored
> > > > > > procedure, it works flawlessly.
> > > > > >
> > > > > > Does this ring any bells with anyone?
> > > > > >
> > > > > > Larry
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > >
> **********************************************************
> > > > > *********************
> > > > > > Forum Note: Use "Reply" to post a response in the discussion
> forum.
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> **********************************************************
> > > > > *********************
> > > > > Forum Note: Use "Reply" to post a response in the discussion
forum.
> > > >
> > > >
> > > >
> > >
> **********************************************************
> > > *********************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > >
> > >
> > >
> **********************************************************
> > > *********************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> **********************************************************
> *********************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
> **********************************************************
> *********************
> Forum Note: Use "Reply" to post a response in the discussion forum.
The developer said she just oncomments the TRACE ON and TRACE OFF statements.
Beyond that, I couldn't say. One thing that I did notice is that her TRACE OFF
statement comes after her RETURN statement, but I didn't think that could be
the issue. Any thoughts?
Larry
> To: ids@iiug.org
> From: paul@oninit.com
> Subject: RE: Qwerky Stored Procedure issue [32108]
> Date: Fri, 6 Dec 2013 14:18:32 -0500
>
> Unlikely unless there is a bug.
>
> Are you 100% certain that the file that fails in normal running is exactly
> the same as the one you are running in debug mode
>
> Cheers
> Paul
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > LARRY SORENSEN
> > Sent: Friday, December 06, 2013 1:10 PM
> > To: ids@iiug.org
> > Subject: RE: Qwerky Stored Procedure issue [32106]
> >
> > Thank you. I will give it a try.
> >
> > Do you think having a lot of extents could be the problem, or maybe the
> > statistics are just out of wack for the table?
> >
> > Larry
> >
> > > To: ids@iiug.org
> > > From: paul@oninit.com
> > > Subject: RE: Qwerky Stored Procedure issue [32104]
> > > Date: Fri, 6 Dec 2013 14:00:41 -0500
> > >
> > > Not that I am aware of - I would just run with -cDI
> > >
> > > Cheers
> > > Paul
> > >
> > > > -----Original Message-----
> > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > > > LARRY SORENSEN
> > > > Sent: Friday, December 06, 2013 12:55 PM
> > > > To: ids@iiug.org
> > > > Subject: RE: Qwerky Stored Procedure issue [32102]
> > > >
> > > > Are there any special options for checking the sysprocedures and
> > > > sysprocplan?
> > > >
> > > > Larry
> > > >
> > > > > To: ids@iiug.org
> > > > > From: paul@oninit.com
> > > > > Subject: RE: Qwerky Stored Procedure issue [32101]
> > > > > Date: Fri, 6 Dec 2013 13:41:55 -0500
> > > > >
> > > > > How do you define health ? If the SPL compliles then it exists, if
> it
> > > > > doesn't then it doesn't.
> > > > >
> > > > > You can run oncheck on the sysprocedures and sysprocplan
> > > > >
> > > > > Cheers
> > > > > Paul
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> > Of
> > > > > > LARRY SORENSEN
> > > > > > Sent: Friday, December 06, 2013 12:37 PM
> > > > > > To: ids@iiug.org
> > > > > > Subject: RE: Qwerky Stored Procedure issue [32100]
> > > > > >
> > > > > > Is there a way to check the health of Stored Procedures such as
> > > oncheck> > > > > with
> > > > > > an option or some other command?
> > > > > >
> > > > > > Larry
> > > > > >
> > > > > > > To: ids@iiug.org
> > > > > > > From: lsorensen25@msn.com
> > > > > > > Subject: RE: Qwerky Stored Procedure issue [32082]
> > > > > > > Date: Tue, 3 Dec 2013 14:22:47 -0500
> > > > > > >
> > > > > > > I am running two Sun servers running Solaris 10 and IDS
> 11.50.FC7.
> > > > > > >
> > > > > > > I have an interesting situation. I am starting to gather more
> > > > > information,
> > > > > > but
> > > > > > > I was wondering if anyone may have experienced this and can give
> > me
> > > > an
> > > > > > idea
> > > > > > of
> > > > > > > what to look for.
> > > > > > >
> > > > > > > An application developer created a Stored Procedure that is
> called
> > > via
> > > > > API.
> > > > > > It
> > > > > > > basically takes information gathered from a web site, comma
> > > delimited
> > > > > file,
> > > > > > > and inputs it into a database. The Stored Procedure may work
> once
> > to
> > > a
> > > > > > few
> > > > > > > times, but then it appears to not do anything, no data files
> > > processed,
> > > > > with
> > > > > > > no error messages. However, when we turn TRACE ON in the same
> > > > Stored
> > > > > > > procedure, it works flawlessly.
> > > > > > >
> > > > > > > Does this ring any bells with anyone?
> > > > > > >
> > > > > > > Larry
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > >
> > **********************************************************
> > > > > > *********************
> > > > > > > Forum Note: Use "Reply" to post a response in the discussion
> > forum.
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > **********************************************************
> > > > > > *********************
> > > > > > Forum Note: Use "Reply" to post a response in the discussion
> forum.
> > > > >
> > > > >
> > > > >
> > > >
> > **********************************************************
> > > > *********************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > >
> > > >
> > > >
> > **********************************************************
> > > > *********************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> > >
> > **********************************************************
> > *********************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> > **********************************************************
> > *********************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Apart from it won't do anything :)
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> LARRY SORENSEN
> Sent: Friday, December 06, 2013 1:29 PM
> To: ids@iiug.org
> Subject: RE: Qwerky Stored Procedure issue [32109]
>
> The developer said she just oncomments the TRACE ON and TRACE OFF
> statements.
> Beyond that, I couldn't say. One thing that I did notice is that her TRACE
OFF
> statement comes after her RETURN statement, but I didn't think that could
> be
> the issue. Any thoughts?
>
> Larry
>
> > To: ids@iiug.org
> > From: paul@oninit.com
> > Subject: RE: Qwerky Stored Procedure issue [32108]
> > Date: Fri, 6 Dec 2013 14:18:32 -0500
> >
> > Unlikely unless there is a bug.
> >
> > Are you 100% certain that the file that fails in normal running is
exactly
> > the same as the one you are running in debug mode
> >
> > Cheers
> > Paul
> >
> > > -----Original Message-----
> > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > > LARRY SORENSEN
> > > Sent: Friday, December 06, 2013 1:10 PM
> > > To: ids@iiug.org
> > > Subject: RE: Qwerky Stored Procedure issue [32106]
> > >
> > > Thank you. I will give it a try.
> > >
> > > Do you think having a lot of extents could be the problem, or maybe
the
> > > statistics are just out of wack for the table?
> > >
> > > Larry
> > >
> > > > To: ids@iiug.org
> > > > From: paul@oninit.com
> > > > Subject: RE: Qwerky Stored Procedure issue [32104]
> > > > Date: Fri, 6 Dec 2013 14:00:41 -0500
> > > >
> > > > Not that I am aware of - I would just run with -cDI
> > > >
> > > > Cheers
> > > > Paul
> > > >
> > > > > -----Original Message-----
> > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> Of
> > > > > LARRY SORENSEN
> > > > > Sent: Friday, December 06, 2013 12:55 PM
> > > > > To: ids@iiug.org
> > > > > Subject: RE: Qwerky Stored Procedure issue [32102]
> > > > >
> > > > > Are there any special options for checking the sysprocedures and
> > > > > sysprocplan?
> > > > >
> > > > > Larry
> > > > >
> > > > > > To: ids@iiug.org
> > > > > > From: paul@oninit.com
> > > > > > Subject: RE: Qwerky Stored Procedure issue [32101]
> > > > > > Date: Fri, 6 Dec 2013 13:41:55 -0500
> > > > > >
> > > > > > How do you define health ? If the SPL compliles then it exists,
if
> > it
> > > > > > doesn't then it doesn't.
> > > > > >
> > > > > > You can run oncheck on the sysprocedures and sysprocplan
> > > > > >
> > > > > > Cheers
> > > > > > Paul
> > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf
> > > Of
> > > > > > > LARRY SORENSEN
> > > > > > > Sent: Friday, December 06, 2013 12:37 PM
> > > > > > > To: ids@iiug.org
> > > > > > > Subject: RE: Qwerky Stored Procedure issue [32100]
> > > > > > >
> > > > > > > Is there a way to check the health of Stored Procedures such
as
> > > > oncheck> > > > > > with
> > > > > > > an option or some other command?
> > > > > > >
> > > > > > > Larry
> > > > > > >
> > > > > > > > To: ids@iiug.org
> > > > > > > > From: lsorensen25@msn.com
> > > > > > > > Subject: RE: Qwerky Stored Procedure issue [32082]
> > > > > > > > Date: Tue, 3 Dec 2013 14:22:47 -0500
> > > > > > > >
> > > > > > > > I am running two Sun servers running Solaris 10 and IDS
> > 11.50.FC7.
> > > > > > > >
> > > > > > > > I have an interesting situation. I am starting to gather
more
> > > > > > information,
> > > > > > > but
> > > > > > > > I was wondering if anyone may have experienced this and can
> give
> > > me
> > > > > an
> > > > > > > idea
> > > > > > > of
> > > > > > > > what to look for.
> > > > > > > >
> > > > > > > > An application developer created a Stored Procedure that is
> > called
> > > > via
> > > > > > API.
> > > > > > > It
> > > > > > > > basically takes information gathered from a web site, comma
> > > > delimited
> > > > > > file,
> > > > > > > > and inputs it into a database. The Stored Procedure may work
> > once
> > > to
> > > > a
> > > > > > > few
> > > > > > > > times, but then it appears to not do anything, no data files
> > > > processed,
> > > > > > with
> > > > > > > > no error messages. However, when we turn TRACE ON in the
> same
> > > > > Stored
> > > > > > > > procedure, it works flawlessly.
> > > > > > > >
> > > > > > > > Does this ring any bells with anyone?
> > > > > > > >
> > > > > > > > Larry
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > >
> > >
> **********************************************************
> > > > > > > *********************
> > > > > > > > Forum Note: Use "Reply" to post a response in the discussion
> > > forum.
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > >
> **********************************************************
> > > > > > > *********************
> > > > > > > Forum Note: Use "Reply" to post a response in the discussion
> > forum.
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > >
> **********************************************************
> > > > > *********************
> > > > > > Forum Note: Use "Reply" to post a response in the discussion
> forum.
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> **********************************************************
> > > > > *********************
> > > > > Forum Note: Use "Reply" to post a response in the discussion
forum.
> > > >
> > > >
> > > >
> > >
> **********************************************************
> > > *********************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > >
> > >
> > >
> **********************************************************
> > > *********************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> **********************************************************
> *********************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
> **********************************************************
> *********************
> Forum Note: Use "Reply" to post a response in the discussion forum.
You gave us the idea that the procedure deals with files.... which SPL
can't do.... it makes me wonder...
On Dec 6, 2013 7:30 PM, "LARRY SORENSEN" <lsorensen25@msn.com> wrote:
> The developer said she just oncomments the TRACE ON and TRACE OFF
> statements.
> Beyond that, I couldn't say. One thing that I did notice is that her TRACE
> OFF
> statement comes after her RETURN statement, but I didn't think that could
> be
> the issue. Any thoughts?
>
> Larry
>
> > To: ids@iiug.org
> > From: paul@oninit.com
> > Subject: RE: Qwerky Stored Procedure issue [32108]
> > Date: Fri, 6 Dec 2013 14:18:32 -0500
> >
> > Unlikely unless there is a bug.
> >
> > Are you 100% certain that the file that fails in normal running is
> exactly
> > the same as the one you are running in debug mode
> >
> > Cheers
> > Paul
> >
> > > -----Original Message-----
> > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > > LARRY SORENSEN
> > > Sent: Friday, December 06, 2013 1:10 PM
> > > To: ids@iiug.org
> > > Subject: RE: Qwerky Stored Procedure issue [32106]
> > >
> > > Thank you. I will give it a try.
> > >
> > > Do you think having a lot of extents could be the problem, or maybe the
> > > statistics are just out of wack for the table?
> > >
> > > Larry
> > >
> > > > To: ids@iiug.org
> > > > From: paul@oninit.com
> > > > Subject: RE: Qwerky Stored Procedure issue [32104]
> > > > Date: Fri, 6 Dec 2013 14:00:41 -0500
> > > >
> > > > Not that I am aware of - I would just run with -cDI
> > > >
> > > > Cheers
> > > > Paul
> > > >
> > > > > -----Original Message-----
> > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf Of
> > > > > LARRY SORENSEN
> > > > > Sent: Friday, December 06, 2013 12:55 PM
> > > > > To: ids@iiug.org
> > > > > Subject: RE: Qwerky Stored Procedure issue [32102]
> > > > >
> > > > > Are there any special options for checking the sysprocedures and
> > > > > sysprocplan?
> > > > >
> > > > > Larry
> > > > >
> > > > > > To: ids@iiug.org
> > > > > > From: paul@oninit.com
> > > > > > Subject: RE: Qwerky Stored Procedure issue [32101]
> > > > > > Date: Fri, 6 Dec 2013 13:41:55 -0500
> > > > > >
> > > > > > How do you define health ? If the SPL compliles then it exists,
> if
> > it
> > > > > > doesn't then it doesn't.
> > > > > >
> > > > > > You can run oncheck on the sysprocedures and sysprocplan
> > > > > >
> > > > > > Cheers
> > > > > > Paul
> > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf
> > > Of
> > > > > > > LARRY SORENSEN
> > > > > > > Sent: Friday, December 06, 2013 12:37 PM
> > > > > > > To: ids@iiug.org
> > > > > > > Subject: RE: Qwerky Stored Procedure issue [32100]
> > > > > > >
> > > > > > > Is there a way to check the health of Stored Procedures such as
> > > > oncheck> > > > > > with
> > > > > > > an option or some other command?
> > > > > > >
> > > > > > > Larry
> > > > > > >
> > > > > > > > To: ids@iiug.org
> > > > > > > > From: lsorensen25@msn.com
> > > > > > > > Subject: RE: Qwerky Stored Procedure issue [32082]
> > > > > > > > Date: Tue, 3 Dec 2013 14:22:47 -0500
> > > > > > > >
> > > > > > > > I am running two Sun servers running Solaris 10 and IDS
> > 11.50.FC7.
> > > > > > > >
> > > > > > > > I have an interesting situation. I am starting to gather more
> > > > > > information,
> > > > > > > but
> > > > > > > > I was wondering if anyone may have experienced this and can
> give
> > > me
> > > > > an
> > > > > > > idea
> > > > > > > of
> > > > > > > > what to look for.
> > > > > > > >
> > > > > > > > An application developer created a Stored Procedure that is
> > called
> > > > via
> > > > > > API.
> > > > > > > It
> > > > > > > > basically takes information gathered from a web site, comma
> > > > delimited
> > > > > > file,
> > > > > > > > and inputs it into a database. The Stored Procedure may work
> > once
> > > to
> > > > a
> > > > > > > few
> > > > > > > > times, but then it appears to not do anything, no data files
> > > > processed,
> > > > > > with
> > > > > > > > no error messages. However, when we turn TRACE ON in the same
> > > > > Stored
> > > > > > > > procedure, it works flawlessly.
> > > > > > > >
> > > > > > > > Does this ring any bells with anyone?
> > > > > > > >
> > > > > > > > Larry
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > >
> > > **********************************************************
> > > > > > > *********************
> > > > > > > > Forum Note: Use "Reply" to post a response in the discussion
> > > forum.
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > **********************************************************
> > > > > > > *********************
> > > > > > > Forum Note: Use "Reply" to post a response in the discussion
> > forum.
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > **********************************************************
> > > > > *********************
> > > > > > Forum Note: Use "Reply" to post a response in the discussion
> forum.
> > > > > >
> > > > >
> > > > >
> > > > >
> > > **********************************************************
> > > > > *********************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > > >
> > > **********************************************************
> > > *********************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > >
> > >
> > > **********************************************************
> > > *********************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a11c1fdde214b0e04ece332e7
hmmmm unless.... 11.70.FC6?
On Dec 6, 2013 8:08 PM, "Fernando Nunes" <domusonline@gmail.com> wrote:
> You gave us the idea that the procedure deals with files.... which SPL
> can't do.... it makes me wonder...
> On Dec 6, 2013 7:30 PM, "LARRY SORENSEN" <lsorensen25@msn.com> wrote:
>
> > The developer said she just oncomments the TRACE ON and TRACE OFF
> > statements.
> > Beyond that, I couldn't say. One thing that I did notice is that her
> TRACE
> > OFF
> > statement comes after her RETURN statement, but I didn't think that could
> > be
> > the issue. Any thoughts?
> >
> > Larry
> >
> > > To: ids@iiug.org
> > > From: paul@oninit.com
> > > Subject: RE: Qwerky Stored Procedure issue [32108]
> > > Date: Fri, 6 Dec 2013 14:18:32 -0500
> > >
> > > Unlikely unless there is a bug.
> > >
> > > Are you 100% certain that the file that fails in normal running is
> > exactly
> > > the same as the one you are running in debug mode
> > >
> > > Cheers
> > > Paul
> > >
> > > > -----Original Message-----
> > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
> Of
> > > > LARRY SORENSEN
> > > > Sent: Friday, December 06, 2013 1:10 PM
> > > > To: ids@iiug.org
> > > > Subject: RE: Qwerky Stored Procedure issue [32106]
> > > >
> > > > Thank you. I will give it a try.
> > > >
> > > > Do you think having a lot of extents could be the problem, or maybe
> the
> > > > statistics are just out of wack for the table?
> > > >
> > > > Larry
> > > >
> > > > > To: ids@iiug.org
> > > > > From: paul@oninit.com
> > > > > Subject: RE: Qwerky Stored Procedure issue [32104]
> > > > > Date: Fri, 6 Dec 2013 14:00:41 -0500
> > > > >
> > > > > Not that I am aware of - I would just run with -cDI
> > > > >
> > > > > Cheers
> > > > > Paul
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> > Behalf Of
> > > > > > LARRY SORENSEN
> > > > > > Sent: Friday, December 06, 2013 12:55 PM
> > > > > > To: ids@iiug.org
> > > > > > Subject: RE: Qwerky Stored Procedure issue [32102]
> > > > > >
> > > > > > Are there any special options for checking the sysprocedures and
> > > > > > sysprocplan?
> > > > > >
> > > > > > Larry
> > > > > >
> > > > > > > To: ids@iiug.org
> > > > > > > From: paul@oninit.com
> > > > > > > Subject: RE: Qwerky Stored Procedure issue [32101]
> > > > > > > Date: Fri, 6 Dec 2013 13:41:55 -0500
> > > > > > >
> > > > > > > How do you define health ? If the SPL compliles then it exists,
> > if
> > > it
> > > > > > > doesn't then it doesn't.
> > > > > > >
> > > > > > > You can run oncheck on the sysprocedures and sysprocplan
> > > > > > >
> > > > > > > Cheers
> > > > > > > Paul
> > > > > > >
> > > > > > > > -----Original Message-----
> > > > > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> > Behalf
> > > > Of
> > > > > > > > LARRY SORENSEN
> > > > > > > > Sent: Friday, December 06, 2013 12:37 PM
> > > > > > > > To: ids@iiug.org
> > > > > > > > Subject: RE: Qwerky Stored Procedure issue [32100]
> > > > > > > >
> > > > > > > > Is there a way to check the health of Stored Procedures such
> as
> > > > > oncheck> > > > > > > with
> > > > > > > > an option or some other command?
> > > > > > > >
> > > > > > > > Larry
> > > > > > > >
> > > > > > > > > To: ids@iiug.org
> > > > > > > > > From: lsorensen25@msn.com
> > > > > > > > > Subject: RE: Qwerky Stored Procedure issue [32082]
> > > > > > > > > Date: Tue, 3 Dec 2013 14:22:47 -0500
> > > > > > > > >
> > > > > > > > > I am running two Sun servers running Solaris 10 and IDS
> > > 11.50.FC7.
> > > > > > > > >
> > > > > > > > > I have an interesting situation. I am starting to gather
> more
> > > > > > > information,
> > > > > > > > but
> > > > > > > > > I was wondering if anyone may have experienced this and can
> > give
> > > > me
> > > > > > an
> > > > > > > > idea
> > > > > > > > of
> > > > > > > > > what to look for.
> > > > > > > > >
> > > > > > > > > An application developer created a Stored Procedure that is
> > > called
> > > > > via
> > > > > > > API.
> > > > > > > > It
> > > > > > > > > basically takes information gathered from a web site, comma
> > > > > delimited
> > > > > > > file,
> > > > > > > > > and inputs it into a database. The Stored Procedure may
> work
> > > once
> > > > to
> > > > > a
> > > > > > > > few
> > > > > > > > > times, but then it appears to not do anything, no data
> files
> > > > > processed,
> > > > > > > with
> > > > > > > > > no error messages. However, when we turn TRACE ON in the
> same
> > > > > > Stored
> > > > > > > > > procedure, it works flawlessly.
> > > > > > > > >
> > > > > > > > > Does this ring any bells with anyone?
> > > > > > > > >
> > > > > > > > > Larry
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > >
> > > > **********************************************************
> > > > > > > > *********************
> > > > > > > > > Forum Note: Use "Reply" to post a response in the
> discussion
> > > > forum.
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > **********************************************************
> > > > > > > > *********************
> > > > > > > > Forum Note: Use "Reply" to post a response in the discussion
> > > forum.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > **********************************************************
> > > > > > *********************
> > > > > > > Forum Note: Use "Reply" to post a response in the discussion
> > forum.
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > **********************************************************
> > > > > > *********************
> > > > > > Forum Note: Use "Reply" to post a response in the discussion
> forum.
> > > > >
> > > > >
> > > > >
> > > > **********************************************************
> > > > *********************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > >
> > > >
> > > > **********************************************************
> > > > *********************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> > >
> >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a11c1fdde214b0e04ece332e7
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a resp