Re: Stored procedure SEP not stopping...

Rob,

Is the stored procedure external or SQL? If the latter, I've never been able to debug the C## service program generated by the CREATE PROCEDURE. Annoying but I don't speak C# anyway.

What debug option(s) were used when the SP was created?

How is the SP executed?

Can you debug using the green screen debugger suggested by Ken "I hate RDi SEP" Killian? (Just kidding, Ken.)

Phil

-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Robert Rogerson
Sent: Monday, September 16, 2019 12:58 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WDSCI-L] Stored procedure SEP not stopping...

CAUTION: This email originated outside of CFI. Do not click links or attachments unless you trust the sender. Report suspicious emails using Report Message add-in.


Thanks Phil. So here's what I'm trying...

- End all jobs for my profile except my workstation job
- start Rdi
- Add SEP (which starts jobs QBPHSRV and QB5ROUTER) on the server
- Confirmed Skip all Breakpoints button is not depressed
- Called my sp. Program did not break.

@Justin, @Dave. I think (but not positive) that since I ended my QB5* jobs before I started RDi there is no chance it would be accessing a program in QRPLOBJ.

@Ken, I also tried a new workspace but same result.

In the end I resorted to green screen debug which resolved my issue.

Thanks to everyone who responded. I'm getting a new SSD and upgrading in
Windoze10 in the near future so I'll have to reload everything. I won't worry about this until then. Hopefully the new install will correct this issue.

Thanks,

Rob




On Mon, Sep 16, 2019 at 12:59 PM Phil Roberts <Phil.Roberts@xxxxxxxxxxxx>
wrote:

Rob,

Although I rarely have to use debug on my programs, cough, cough, I
don't have problems with the RDi debugger and SEP.

Typically, this scenario describes my process.
- Start RDi Debug.
- Add the program(s) to SEP.
- Initiate the programs.
- When I'm finished debugging, I close all program listings and remove
the program entries in the debug console. The SEP entries are unchanged.
- Modify the program and recompile.
- In RDi Debug, refresh the SEP entry. This points it to the newly
compiled program rather than the program in QRPLOBJ.
- Initiate the programs.
- Lather, rinse, repeat.

If I'm working with a service program, it's also necessary to end the
session that initiated the service program.

Other posters have slammed RDi debug. Other than not being able to
change the contents of a monitored VARCHAR field sometimes, I've found
this tool to be very stable. I use a separate workspace for debugging.

Phil

-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Robert
Rogerson
Sent: Monday, September 16, 2019 11:06 AM
To: Rational Developer for IBM i / Websphere Development Studio Client
for System i & iSeries <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WDSCI-L] Stored procedure SEP not stopping...

CAUTION: This email originated outside of CFI. Do not click links or
attachments unless you trust the sender. Report suspicious emails
using Report Message add-in.


Thanks Greg. I confirmed that the breakpoint does exist and is
enabled but it still doesn't break. You are referring to the
Breakpoint being checked on the Breakpoints tab correct?

Thanks,

Rob

On Mon, Sep 16, 2019 at 11:10 AM Greg Wilburn < mailto:
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

Make sure you haven't disabled the breakpoints... can't tell you
how many times I've unknowingly clicked that button

-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf
Of Robert Rogerson
Sent: Monday, September 16, 2019 10:53 AM
To: Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries <mailto:wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WDSCI-L] Stored procedure SEP not stopping...

Thanks Dave.

This is a new sp. I confirmed the external program only exists in
my development library.
So the sp only exists in my dev library as does the external program.

Thanks,

Rob

On Mon, Sep 16, 2019 at 10:42 AM <mailto:dlclark@xxxxxxxxxxxxxxxx>

wrote:

"WDSCI-L" <mailto:wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> wrote on

09/16/2019

10:34:17 AM:

I have ended the debug server, restarted RDi with -clean,
cleared the

IBM i

cache and still the program doesn't stop.

Is there anywhere else I can check?

Is there more than one object by the same name? I mention
it, because this is common in my shop so when this happens to me
it is

usually

a library list issue. Meaning, one object has the SEP on it but
it is

the

other object that is getting executed.


Sincerely,

Dave Clark
--
int.ext: 91078
direct: (937) 531-6378
home: (937) 751-3300

Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331

********************************************************************
**
***********************

This email message and any attachments is for use only by the
named
addressee(s) and may contain confidential, privileged and/or
proprietary information. If you have received this message in
error, please immediately notify the sender and delete and destroy
the message and all copies. All unauthorized direct or indirect
use or disclosure of this message is strictly prohibited. No right
to confidentiality or privilege is waived or lost by any error in

transmission.

********************************************************************
**
***********************

--
This is the Rational Developer for IBM i / Websphere Development
Studio Client for System i & iSeries (WDSCI-L) mailing list To
post a message email: mailto:WDSCI-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2F
li
sts.midrange.com%2Fmailman%2Flistinfo%2Fwdsci-l&amp;data=02%7C01%7
C%
7C887e8d841c7f4888165d08d73abfcd82%7C4384ec27a8814f18be5ab93756fd6
07
5%7C0%7C0%7C637042467782836691&amp;sdata=3BvPRJDbrq5ekNPLaKYqAsryn
y3
ns4gon%2FmT3Jia540%3D&amp;reserved=0
or email: mailto:WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at

https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Farch
ive.midrange.com%2Fwdsci-l&amp;data=02%7C01%7C%7Cacc7e703711642ec9f270
8d73acf753c%7C4384ec27a8814f18be5ab93756fd6075%7C0%7C0%7C6370425350281
50330&amp;sdata=dfHNYBjMy51hDlA3ipZQWuFlI8NdrHmdBYdaYUZWPzY%3D&amp;res
erved=0
.

Help support midrange.com by shopping at amazon.com with our
affiliate
link:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2F
am
azon.midrange.com&amp;data=02%7C01%7C%7C887e8d841c7f4888165d08d73a
bf
cd82%7C4384ec27a8814f18be5ab93756fd6075%7C0%7C0%7C6370424677828466
83
&amp;sdata=2rruM1OJA5aRYhCapEdIpIO5C5ddY1GXDDwPF7%2BNVZQ%3D&amp;re
se
rved=0

--
This is the Rational Developer for IBM i / Websphere Development
Studio Client for System i & iSeries (WDSCI-L) mailing list To post
a message email: mailto:WDSCI-L@xxxxxxxxxxxxxxxxxx To subscribe,

unsubscribe,

or change list options,
visit:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fli
st
s.midrange.com%2Fmailman%2Flistinfo%2Fwdsci-l&amp;data=02%7C01%7C%7C
88
7e8d841c7f4888165d08d73abfcd82%7C4384ec27a8814f18be5ab93756fd6075%7C
0%
7C0%7C637042467782846683&amp;sdata=ZkQrGUK6BJNku7DUm2aJOurGojqwXrljc
Tr
QMid6e6w%3D&amp;reserved=0 or email:
mailto:WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at

https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Farch
ive.midrange.com%2Fwdsci-l&amp;data=02%7C01%7C%7Cacc7e703711642ec9f270
8d73acf753c%7C4384ec27a8814f18be5ab93756fd6075%7C0%7C0%7C6370425350281
50330&amp;sdata=dfHNYBjMy51hDlA3ipZQWuFlI8NdrHmdBYdaYUZWPzY%3D&amp;res
erved=0
.

Help support midrange.com by shopping at amazon.com with our
affiliate
link:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fam
az
on.midrange.com&amp;data=02%7C01%7C%7C887e8d841c7f4888165d08d73abfcd
82
%7C4384ec27a8814f18be5ab93756fd6075%7C0%7C0%7C637042467782846683&amp
;s
data=2rruM1OJA5aRYhCapEdIpIO5C5ddY1GXDDwPF7%2BNVZQ%3D&amp;reserved=0
--
This is the Rational Developer for IBM i / Websphere Development
Studio Client for System i & iSeries (WDSCI-L) mailing list To post
a message email: mailto:WDSCI-L@xxxxxxxxxxxxxxxxxx To subscribe,

unsubscribe,

or change list options,
visit:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fli
st
s.midrange.com%2Fmailman%2Flistinfo%2Fwdsci-l&amp;data=02%7C01%7C%7C
88
7e8d841c7f4888165d08d73abfcd82%7C4384ec27a8814f18be5ab93756fd6075%7C
0%
7C0%7C637042467782846683&amp;sdata=ZkQrGUK6BJNku7DUm2aJOurGojqwXrljc
Tr
QMid6e6w%3D&amp;reserved=0 or email:
mailto:WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at

https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Farch
ive.midrange.com%2Fwdsci-l&amp;data=02%7C01%7C%7Cacc7e703711642ec9f270
8d73acf753c%7C4384ec27a8814f18be5ab93756fd6075%7C0%7C0%7C6370425350281
60328&amp;sdata=%2B6L%2F9z0OwA5CcgA99DIlyGsHzB%2FP4uLh984phPlCNkQ%3D&a
mp;reserved=0
.

Help support midrange.com by shopping at amazon.com with our
affiliate
link:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fam
az
on.midrange.com&amp;data=02%7C01%7C%7C887e8d841c7f4888165d08d73abfcd
82
%7C4384ec27a8814f18be5ab93756fd6075%7C0%7C0%7C637042467782846683&amp
;s
data=2rruM1OJA5aRYhCapEdIpIO5C5ddY1GXDDwPF7%2BNVZQ%3D&amp;reserved=0

--
This is the Rational Developer for IBM i / Websphere Development
Studio Client for System i & iSeries (WDSCI-L) mailing list To post a
message
email: mailto:WDSCI-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist
s.midrange.com%2Fmailman%2Flistinfo%2Fwdsci-l&amp;data=02%7C01%7C%7Cac
c7e703711642ec9f2708d73acf753c%7C4384ec27a8814f18be5ab93756fd6075%7C0%
7C0%7C637042535028160328&amp;sdata=q6vfq5SkuvSN0wXcp1LhCFkUpSOTxdDBMU7
MX3vgd8k%3D&amp;reserved=0 or email:
mailto:WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Farch
ive.midrange.com%2Fwdsci-l&amp;data=02%7C01%7C%7Cacc7e703711642ec9f270
8d73acf753c%7C4384ec27a8814f18be5ab93756fd6075%7C0%7C0%7C6370425350281
60328&amp;sdata=%2B6L%2F9z0OwA5CcgA99DIlyGsHzB%2FP4uLh984phPlCNkQ%3D&a
mp;reserved=0
.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Famaz
on.midrange.com&amp;data=02%7C01%7C%7Cacc7e703711642ec9f2708d73acf753c
%7C4384ec27a8814f18be5ab93756fd6075%7C0%7C0%7C637042535028160328&amp;s
data=gYBtvEe3XBHImdAOz9S7r%2FQ0n8rwFqpD1oHHJ%2B2H2IY%3D&amp;reserved=0
This e-mail and any files transmitted with it are confidential and
solely for the use of the individual or entity to which they are
addressed and intended. If you have received this e-mail in error,
please notify the sender by return e-mail. If you are not the intended
recipient, you may not read, copy, retain, print, disclose, or
distribute this message or its contents to any other individual, for such actions may be unlawful.
WARNING: We take certain precautions to prevent viruses, but we are
not responsible for loss or damage arising from the use of this e-mail
or attachments.
--
This is the Rational Developer for IBM i / Websphere Development
Studio Client for System i & iSeries (WDSCI-L) mailing list To post a
message email: WDSCI-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist
s.midrange.com%2Fmailman%2Flistinfo%2Fwdsci-l&amp;data=02%7C01%7C%7Cac
c7e703711642ec9f2708d73acf753c%7C4384ec27a8814f18be5ab93756fd6075%7C0%
7C0%7C637042535028160328&amp;sdata=q6vfq5SkuvSN0wXcp1LhCFkUpSOTxdDBMU7
MX3vgd8k%3D&amp;reserved=0 or email:
WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fwdsci-l&amp;data=02%7C01%7C%7Cacc7e703711642ec9f2708d73acf753c%7C4384ec27a8814f18be5ab93756fd6075%7C0%7C0%7C637042535028160328&amp;sdata=%2B6L%2F9z0OwA5CcgA99DIlyGsHzB%2FP4uLh984phPlCNkQ%3D&amp;reserved=0.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Famaz
on.midrange.com&amp;data=02%7C01%7C%7Cacc7e703711642ec9f2708d73acf753c
%7C4384ec27a8814f18be5ab93756fd6075%7C0%7C0%7C637042535028160328&amp;s
data=gYBtvEe3XBHImdAOz9S7r%2FQ0n8rwFqpD1oHHJ%2B2H2IY%3D&amp;reserved=0

--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fwdsci-l&amp;data=02%7C01%7C%7Cacc7e703711642ec9f2708d73acf753c%7C4384ec27a8814f18be5ab93756fd6075%7C0%7C0%7C637042535028160328&amp;sdata=q6vfq5SkuvSN0wXcp1LhCFkUpSOTxdDBMU7MX3vgd8k%3D&amp;reserved=0
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fwdsci-l&amp;data=02%7C01%7C%7Cacc7e703711642ec9f2708d73acf753c%7C4384ec27a8814f18be5ab93756fd6075%7C0%7C0%7C637042535028160328&amp;sdata=%2B6L%2F9z0OwA5CcgA99DIlyGsHzB%2FP4uLh984phPlCNkQ%3D&amp;reserved=0.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Famazon.midrange.com&amp;data=02%7C01%7C%7Cacc7e703711642ec9f2708d73acf753c%7C4384ec27a8814f18be5ab93756fd6075%7C0%7C0%7C637042535028160328&amp;sdata=gYBtvEe3XBHImdAOz9S7r%2FQ0n8rwFqpD1oHHJ%2B2H2IY%3D&amp;reserved=0
This e-mail and any files transmitted with it are confidential and solely for the use of the individual or entity to which they are addressed and intended. If you have received this e-mail in error, please notify the sender by return e-mail. If you are not the intended recipient, you may not read, copy, retain, print, disclose, or distribute this message or its contents to any other individual, for such actions may be unlawful. WARNING: We take certain precautions to prevent viruses, but we are not responsible for loss or damage arising from the use of this e-mail or attachments.