Kontakt

Ansicht
Dokumentation

08580 - Strange errors' in joblog and users dump with SQL0901 since this morning

08580 - Strange errors' in joblog and users dump with SQL0901 since this morning

General Material Data   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.
SAP E-Book

Strange errors' in joblog and users dump with SQL0901 since this morning

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.lindegaardZrockwool.dk]
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.gueldenpfennigZsap.com]
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.lindegaardZrockwool.dk]
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.gueldenpfennigZsap.com]
Sendt: 10. december 2002 08:52
Til: 'DoNotReply@consolut.eu'
Cc: 'klaus.lindegaardZrockwool.dk'
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.lindegaardZrockwool.dk]
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

 Durban Tours - Südafrika Safari

CPI1466 during Backup   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Length: 8110 Date: 20240520 Time: 180808     sap01-206 ( 4 ms )