Ansicht
Dokumentation
08588 - Strange errors' in joblog and users dump w ith SQL0901 since this morning
CL_GUI_FRONTEND_SERVICES - Frontend Services rdisp/max_wprun_time - Maximum work process run timeThis documentation is copyright by SAP AG.
Strange errors' in joblog and users dump w ith SQL0901 since this morning
Hi,I dpon't know.
Regards
Volker
-----Original Message-----
From: ngkmZtoyota.com.my [mailto:ngkmZtoyota.com.my]
Sent: Dienstag, 10. Dezember 2002 15:49
To: DoNotReply@consolut.eu
Subject: Fw: Re: Strange errors' in joblog and users dump
with SQL0901 since this morning
Importance: High
Dear Volker,
what is the actual cause of this problem?
KM Ng
----- Forwarded by Ng Kien Meng/ISD/UMWT/UMWToyota on 10/12/2002 10:22 PM
-----
"adeymard <adeymardZconsolut.fr>" <adeymard
10/12/2002 05:54 PM
Please respond to SAP on System i
To: DoNotReply@consolut.eu
cc:
Subject: Re: Strange errors' in joblog and
users dump with SQL0901 since this morning
Hello all
I remenber we had this problem once. It was impossible for us to run
a transaction, we always have an error message on SQL.
The only way to solve this problem was to stop SAP delete SQL
packages and then start SAP. Everything is fine since.
Regards
Alexandre Deymard
SAP Admin
--- In DoNotReply@consolut.eu, "Gueldenpfennig, Volker"
<volker.gueldenpfennigZs...> wrote:
> Hi Klaus,
>
> if the problem disappeared with cycling the WPs, we don't need the
SQL-packs, because they obviously didn't cause the problem.
> So, the next time, you should immediately cycle the WPs and it
should disappear.
> Analyzing the SQL packs makes only sense when they caused the
problem.
>
> Regards
>
> Volker
>
> -----Original Message-----
> From: Klaus Lindegaard (RWDK) [mailto:klaus.lindegaardZr...]
> Sent: Dienstag, 10. Dezember 2002 09:39
> To: Gueldenpfennig, Volker; 'DoNotReply@consolut.eu'
> Subject: SV: Strange errors' in joblog and users dump
> with SQL0901 since this morning
>
>
> Yes, seems in my opinion to be right. I have saved 8 sqlpacks
>
> System now seems to be functioning OK again.
>
> Should I do a binary get from OS400 of the SAVF's and mail them to
you and
> open an OSS ?
>
> Regards and Thanks !!!!
> Klaus
> -----Oprindelig meddelelse-----
> Fra: Gueldenpfennig, Volker [mailto:volker.gueldenpfennigZs...]
> Sendt: 10. december 2002 09:27
> Til: 'Klaus Lindegaard (RWDK)'; 'DoNotReply@consolut.eu'
> Emne: RE: Strange errors' in joblog and users dump
with
> SQL0901 since this morning
>
> Hi Klaus,
>
> but it didn't help to delete the SQL-Packs. It only helped to cycle
the WPs.
> Is this right ?
>
> Regards
>
> Volker
>
> -----Original Message-----
> From: Klaus Lindegaard (RWDK) [mailto:klaus.lindegaardZr...]
> Sent: Dienstag, 10. Dezember 2002 09:25
> To: Klaus Lindegaard (RWDK); Gueldenpfennig, Volker;
> 'DoNotReply@consolut.eu'
> Subject: SV: Strange errors' in joblog and users dump
> with SQL0901 since this morning
>
>
> Now seemed to stop after saving/deleting sqlpacks, and restart of
all WP's -
> letting few users on now.
>
> Regards
> KLaus
>
> -----Oprindelig meddelelse-----
> Fra: Klaus Lindegaard (RWDK)
> Sendt: 10. december 2002 08:55
> Til: 'Gueldenpfennig, Volker'; 'DoNotReply@consolut.eu'
> Cc: Klaus Lindegaard (RWDK)
> Emne: SV: Strange errors' in joblog and users dump
with
> SQL0901 since this morning
>
> I have until now 4 I think 42 different dumps
>
>
>
> -----Oprindelig meddelelse-----
> Fra: Gueldenpfennig, Volker [mailto:volker.gueldenpfennigZs...]
> Sendt: 10. december 2002 08:52
> Til: 'DoNotReply@consolut.eu'
> Cc: 'klaus.lindegaardZr...'
> Emne: RE: Strange errors' in joblog and users dump
with
> SQL0901 since this morning
>
> Hi Klaus,
>
> as we try to catch all occurences of damaged SQL Packs, I would
please ask
> you to save this SQL-Pack, that is described bleow to a SAVF.
Please gather
> the joblog as well.
>
> Then delete this one SQL-Pack while the system is active. Try your
request
> again. If you should run into MCH3402, you should cylcle all the
WPs while
> they are doing nothing. If the problem is solved then, please
backup the
> SQL-Pack again and open an OSS ticket and let me know. IBM has then
to
> analyze the problem in the SQL-Pack in order to find the real root
cause.
>
> Regards
>
> Volker
>
> -----Original Message-----
> From: Klaus Lindegaard (RWDK) [mailto:klaus.lindegaardZr...]
> Sent: Dienstag, 10. Dezember 2002 08:49
> To: 'DoNotReply@consolut.eu'
> Subject: Strange errors' in joblog and users dump
with
> SQL0901 since this morning
>
>
> Anyone seen this in the joblog
>
>
>
> 1 User Trace buffer(s)
deleted.
>
> Invalid value in floating-point
instruction.
>
> Internal failure occurred in query
processor.
>
> SQL-
systemfejl.
>
> Ejerskab til objekt QP0Z697074 i QUSRSYS type *USRSPC
revideret.
>
> File QAP0ZDMP in library QTEMP already
exists.
>
> User Trace data for job 697074/P0100/WP01 dumped to member
QP0Z697074 in
>
> file QAP0ZDMP in library
QTEMP.
>
> 27 records copied from member
QP0Z697074.
>
> 1 User Trace buffer(s)
deleted.
>
> -------------------------------------------------------------------
>
> Func=4 Lib= R3P0132020 Pkg=
Z_DEBI3KW
>
> Open MLib= R3P01OP46D MPgm=
DW
>
> Cursor
name= "C3Z_DEBI302440"
>
> Stmt name = "WKqYIAADAA"
7FE6D298E8C9C1C1C4C1C17F404040404040
>
> Openopts =
80
>
> ReuseDA = N Block = 0000000001 Reopen =
0
>
> Invalid value in floating-point
instruction.
>
> Internal failure occurred in query
processor.
>
> SQL-
systemfejl.
>
> Ejerskab til objekt QP0Z697074 i QUSRSYS type *USRSPC
revideret.
>
> File QAP0ZDMP in library QTEMP already
exists.
>
> User Trace data for job 697074/P0100/WP01 dumped to member
QP0Z697074 in
>
> file QAP0ZDMP in library
QTEMP.
>
> 27 records copied from member
QP0Z697074.
>
> 1 User Trace buffer(s)
deleted.
>
> SELECT * FROM R3P01DATA/"Z_DEBI3" WHERE "MANDT" = ? AND
STRIP("
>
> SORTL",T) LIKE ? WITH
UR
>
>
Mere .
>
> -------------------------------------------------------------------
>
> Func=4 Lib= R3P0132020 Pkg=
Z_DEBI3KW
>
> Open MLib= R3P01OP46D MPgm=
DW
>
> Cursor
name= "C3Z_DEBI302440"
>
> Stmt name = "WKqYIAADAA"
7FE6D298E8C9C1C1C4C1C17F404040404040
>
> Openopts =
80
>
> ReuseDA = N Block = 0000000001 Reopen =
0
>
> Invalid value in floating-point
instruction.
>
> Internal failure occurred in query
processor.
>
> SQL-
systemfejl.
>
> Ejerskab til objekt QP0Z697074 i QUSRSYS type *USRSPC
revideret.
>
> File QAP0ZDMP in library QTEMP already
exists.
>
> User Trace data for job 697074/P0100/WP01 dumped to member
QP0Z697074 in
>
> file QAP0ZDMP in library
QTEMP.
>
>
>
> And so onnnnn
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Have a look to our homepage at: http://www.consolut.net
> DoNotReply@consolut.eu
>
> Your use of consolut is subject to
http://www.consolut.net
Have a look to our homepage at: http://www.consolut.net
DoNotReply@consolut.eu
Your use of consolut is subject to http://www.consolut.net
[Non-text portions of this message have been removed]
Have a look to our homepage at: http://www.consolut.net
DoNotReply@consolut.eu
Your use of consolut is subject to http://www.consolut.net
Durban Tours - Südafrika Safari
CL_GUI_FRONTEND_SERVICES - Frontend Services BAL_S_LOG - Application Log: Log header data
This documentation is copyright by SAP AG.
Length: 11255 Date: 20240602 Time: 135401 sap01-206 ( 4 ms )
