CRTSQLRPGI errors out with DBGVIEW(*SOURCE) but passes with DBGVIEW(*NONE)

It looks like the source is pretty big and the debugger space is being
exceeded. Since you need to debug this program, how about trying it
without creating the SQL debug views. You can either compile
with a two step compile or just specify DBGVIEW(*NONE) and
COMPILEOPT('DBGVIEW(*LIST)') on the CRTSQLRPGI command.
You could use *STMT if you rather use that view.

Thanks,
Gina

date: Thu, 17 Sep 2009 09:32:17 -0400
from: rob@xxxxxxxxx
subject: CRTSQLRPGI errors out with DBGVIEW(*SOURCE) but passes with
DBGVIEW(*NONE)

quick summary for the list. He originally posted this on the bpcs-l list
and I recommended he bring it over here.
I'll even change his subject line to eye catch better...
His English is much better than my Polish.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From:
"Jszarlik" <jszarlik@xxxxxx>
To:
"rpg400-l@xxxxxxxxxxxx"@mail.midrange.com
Date:
09/16/2009 05:23 PM
Subject:
Rpg compilation error
Sent by:
rpg400-l-bounces@xxxxxxxxxxxx



hello,
maybe someone from RPG list help me
Jarek
--------- Orygina? wiadomo?ci --------
Od: rob@xxxxxxxxx
Do: BPCS ERP System <bpcs-l@xxxxxxxxxxxx>
Temat: Reply-To:List-Id:List-Unsubscribe:List-Archive:List-Post:; Re:
[BPCS-L]
Data: 16/09/09 20:38

You need to take this to the RPG list. The gal who wrote CRTSQLRPGI
monitors that list. 10-1 she asks you what level of OS you are running
and recommends a ptf.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From:
"Jszarlik" <jszarlik@xxxxxx>
To:
"bpcs-l@xxxxxxxxxxxx"@mail.midrange.com
Date:
09/16/2009 02:27 PM
Subject:
Re: [BPCS-L] Reply-To:List-Id:List-Unsubscribe:List-Archive:List-Post:;
Re: Rpg compilation error
Sent by:
bpcs-l-bounces+rob=dekko.com@xxxxxxxxxxxx



I checked the joblog. A part of it:


Buffer length longer than record for member PUR550D2.
Member PUR550D2 added to file QSQLTEMP1 in QTEMP.
Size of member PUR550D2 increased 55 increments.
Ownership of object QRNFER in QTEMP type *USRSPC changed.
Ownership of object QRNFEF in QTEMP type *USRSPC changed.
View data overflow. All debug data lost.
View data overflow. All debug data lost.
File QWXDUMP created in library QTEMP.
Member QWXDUMP added to file QWXDUMP in QTEMP.
File QWXDUMP in library QTEMP changed.
An error occurred during translation.
View data overflow. All debug data lost.
Member QWXDUMP already in use.
Compilation failed. Module PUR550D2 not created in library BPSTFSKC


I found calling command CRTSQLRPGI and changed DBGVIEW(*SOURCE) for
DBGVIEW(*NONE) and the all is OK.
But I have to debug this program to find error.

How to compile with DBGVIEW(*SOURCE)?

Jarek

--------- Orygina? wiadomo?ci --------
Od: rob@xxxxxxxxx
Do: BPCS ERP System <bpcs-l@xxxxxxxxxxxx>
Temat: Reply-To:List-Id:List-Unsubscribe:List-Archive:List-Post:; Re:
[BPCS-L] Rpg compilation error
Data: 16/09/09 18:47

I found msg RNS9331.
DSPMSGD RANGE(RNS9331) MSGF(QDEVTOOLS/QRPGLEMSG)
Did you check the joblog?
When you submitted the compile you didn't specify ALWMLTTHD(*YES) did

you?

If you had *JOBD does that jobd specify *YES?

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From:
"Jszarlik" <jszarlik@xxxxxx>
To:
"bpcs-l@xxxxxxxxxxxx"@mail.midrange.com
Date:
09/16/2009 01:14 PM
Subject:
[BPCS-L] Rpg compilation error
Sent by:
bpcs-l-bounces+rob=dekko.com@xxxxxxxxxxxx



Hello,
I try to compile PUR550D2 source. I use RPGLE command in batch. The

job

ends
normally but when I check spoolfile on the bottom I see the following:
* * * * * E N D O F F I N A L S U M M A R Y * * * * *
C o d e G e n e r a t i o n M e s s a g e s
An error occurred during translation.
An error occurred during translation.
* * * * * E N D O F C O D E G E N E R A T I O N M E S S A G

E

S

* * * * *
THE COMPILATION WAS UNEXPECTEDLY CANCELLED. THE REASON COULD BE ONE OF

THE

FOLLOWING:
-- COMPILING IN BATCH WITH ALWMLTTHD(*YES) SPECIFIED FOR THE JOB.
-- CANCELLATION OF SESSION WHILE COMPILE IS IN PROGRESS.
-- ENDING LAST REQUEST WHILE COMPILE IS IN PROGRESS.
Compilation failed. Module PUR550D2 not created in library BPSTFSKC.
* * * * * E N D O F C O M P I L A T I O N * * * * *

ERPLX 8.2.3
os V5R4M0

Any idea what I do wrong?

Regards
Jarek