Ansicht
Dokumentation
13350 - Antwort: SQL error "-551" occurred when accessing table"AGR_USERS ".
PERFORM Short Reference rdisp/max_wprun_time - Maximum work process run timeThis documentation is copyright by SAP AG.
Antwort: SQL error "-551" occurred when accessing table"AGR_USERS ".
Jim
Yes That's right. Yesterday than I saw that SQL7008 (thanks Volker)
indicate that some files was not journaled, and that was truth, I guess
that it was lack of authority to QN2OFR then I run AS4FIXFILE first time.
Even if the jobloggs didn't indicate any problems, I put *alluser authority
on QN2OFR and run AS4FIXFILE once more. Now it start journaling to all
files and also fixed the owner problem and the system is up and running.
Thanks to all of you who has been involved.
Regards
**************************************************
Per-Lennart Andersson
Coca-Cola Drycker Sverige AB
Tel +46 8 5007 5057 Mobil +46 70 320 5743
"Jim Doll"
<JDOLLZperrigo To: <peranderssonZc...>
.com> cc:
Subject: Re: Antwort:
SQL error "-551" occurred when
2004-03-14 accessing table"AGR_USERS ".
04:45
Can you try running AS4FIXFILE as QSECOFR? QN2OFR doesn't have the
authority to change ownership, because they're owned by QDFTOWN, maybe?
Jim Doll, Perrigo
>>> peranderssonZc... 03/13/04 04:56AM >>>
Volker
I checked the joblogg once more and see -AS4FIXFILE DBLIB(R3QN2DATA)
CHGOWN
(*YES) run by QN2OFR in batch. NEWOWN(*SIDOWNER) should bee the default
value. First time I start the job it was ended because the system was
still
building index over BSIS, Its rather big 150 GB. R3 started NO no.
Regarding DBIF_RSQL_SQL_ERROR I see SQL error "-7008" occurred when
accessing table "KBEZ " and also other tables.
/ PL
**************************************************
Per-Lennart Andersson
Coca-Cola Drycker Sverige AB
Tel +46 8 5007 5057 Mobil +46 70 320 5743
"Volker Gueldenpfennig"
<volker.gueldenpfennigZeasymarke To:
DoNotReply@consolut.eu
tplace.de> cc:
Subject:
Re: Antwort: SQL error "-551" occurred when
2004-03-13 09:37 accessing
table "AGR_USERS ".
Please respond to SAP on System i
Hi Per-Lennart,
what ? Some tables still partly on QDFTOWN after the follwonig
command ?
AS4FIXFILE DBLIB(R3SIDDATA) CHGOWN(*YES) NEWOWN(*SIDOWNER)
Are you sure, that SAP was down and you had no other locks ?
Because this command does a DSPOBJD and changes all tables ...
DBIF_RSQL_SQL_ERROR..........??
What SQL errors behind that
You can have a look into the short dump. 901 ? 551 ? 501
Regards
Volker
--- In DoNotReply@consolut.eu, "Per-Lennart Andersson"
<peranderssonZc...> wrote:
>
> Udo
>
> Yes - no problem to start QN2 now, but I see a lot of ABAP
runtime errors
> DBIF_RSQL_SQL_ERROR..........??
>
> Regarding authority and owners I have some objects in the DB witch
still
> have QDFTOWN and was not changed by FIXR3OWNS or AS4FIXFILE
>
> **************************************************
> Per-Lennart Andersson
> Coca-Cola Drycker Sverige AB
>
> Tel +46 8 5007 5057 Mobil +46 70 320 5743
>
>
>
>
>
> "Udo
Wiedel"
> <uwiedelZlitte To:
<DoNotReply@consolut.eu>
> lfuse.com>
cc:
> Subject: RE: Antwort:
SQL error "-551" occurred when
> 2004-03-12 accessing
table "AGR_USERS ".
>
21:14
> Please
respond
>
to
>
SAP on System i
>
>
>
>
>
>
> Works also..
>
> -----Original Message-----
> From: Per-Lennart Andersson [mailto:peranderssonZc...]
> Sent: Friday, March 12, 2004 9:43 AM
> To: DoNotReply@consolut.eu
> Cc: DoNotReply@consolut.eu
> Subject: RE: Antwort: SQL error "-551" occurred when
> accessing table "AGR_USERS ".
>
>
>
> Udo
>
> Of corse - stupid me.... thanks, but I took sidOWNER as owner.
>
> Regards and nice weekend
>
> **************************************************
> Per-Lennart Andersson
> Coca-Cola Drycker Sverige AB
>
> Tel +46 8 5007 5057 Mobil +46 70 320 5743
>
>
>
>
> "Udo Wiedel"
> <uwiedelZlitte To:
> <DoNotReply@consolut.eu>
> lfuse.com> cc:
> Subject: RE: Antwort:
> SQL error "-551" occurred when
> 2004-03-12 accessing
table "AGR_USERS ".
> 16:30
> Please respond
> to
> SAP on System i
>
>
>
>
>
>
> 1. GRTOBJAUT OBJ(R3xxxDATA/*ALL) OBJTYPE(*ALL) USER(R3OWNER)
AUT(*ALL)
>
>
>
> Udo
>
> -----Original Message-----
> From: Per-Lennart Andersson [mailto:peranderssonZc...]
> Sent: Friday, March 12, 2004 9:15 AM
> To: DoNotReply@consolut.eu
> Cc: DoNotReply@consolut.eu
> Subject: Re: Antwort: SQL error "-551" occurred when
> accessing table "AGR_USERS ".
>
>
>
> Hi Thomas
>
> Yes it was "dftown" how was the owner and some more and it's not
fixed by
> FIXR3OWNS. As I understand FIXR3OWNS just fix owner problems in
the Kernel.
> I need something that change owners in R3sidDATA.
>
> / PL
>
> **************************************************
> Per-Lennart Andersson
> Coca-Cola Drycker Sverige AB
>
> Tel +46 8 5007 5057 Mobil +46 70 320 5743
>
>
>
>
> thomas.kremmin
> Zseeber.de To:
> DoNotReply@consolut.eu
> cc:
> 2004-03-12 Subject: Antwort:
> SQL error "-551" occurred when
> 14:30 accessing
table "AGR_USERS ".
> Please respond
> to
> SAP on System i
>
>
>
>
> Hi Per,
>
> looks like an authortiy problem.
> Look at the file at OS level DSOBJAUT.
> <SID> owner should be the owner.
> Authorities:
> *GROUP <SID>OWNER *ALL
> *PUBLIC *CHANGE (Don't know if this is OK?
Perhaps
> it have to be *EXCLUDE ?)
>
>
> Best regards / Mit freundlichen Grüßen
>
> Thomas
>
>
>
> "Per-Lennart Andersson" <peranderssonZc...>
> 12.03.2004 14:15
> Bitte antworten zu
> DoNotReply@consolut.eu
>
>
> An
> DoNotReply@consolut.eu
> Kopie
>
> Thema
> SQL error "-551" occurred when accessing
table "AGR_USERS
> ".
>
>
>
>
>
>
> Hi all of you!
>
> I got the following immediately then I start R3 after an refresh
of QN2. I
> have done it several times before but now something went wrong. I
use the
> concept from "files".
>
> After I have run AS4FIXFILE, DLTR3PKG and also FIXR3OWNS. We
are "very
> close" to the infoapar and on 46C with kernel 1768
>
> Do anyone know??
>
> ABAP runtime errors DBIF_RSQL_SQL_ERROR
> SQL error "-551" occurred when accessing table "AGR_USERS ".
>
> How to correct the error
>
> Database error text........: "Not authorized to object AGR_USERS in
> R3QN2DATA
> type *FILE. Job=117626/QN202/WP00"
> Internal call code.........: "[RSQL/OPEN/AGR_USERS ]"
>
>
>
> Regards
>
> **************************************************
> Per-Lennart Andersson
> Coca-Cola Drycker Sverige AB
>
> Tel +46 8 5007 5057 Mobil +46 70 320 5743
>
>
>
>
>
> Have a look to our homepage at: http://www.EasyMarketplace.de
> DoNotReply@consolut.eu
>
>
>
>
> consolut Links
>
> To visit your group on the web, go to:
> http://groups.consolut.net/group/SAP on System i/
>
> To unsubscribe from this group, send an email to:
> DoNotReply@consolut.eu
>
> Your use of consolut is subject to the consolut Terms of
Service.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Have a look to our homepage at: http://www.EasyMarketplace.de
> DoNotReply@consolut.eu
>
>
> consolut Sponsor
>
> [IMAGE]
> [IMAGE]
>
>
>
>
> consolut Links
>
> To visit your group on the web, go to:
> http://groups.consolut.net/group/SAP on System i/
>
> To unsubscribe from this group, send an email to:
> DoNotReply@consolut.eu
>
> Your use of consolut is subject to the consolut Terms of
Service.
>
>
>
>
>
>
>
>
> Have a look to our homepage at: http://www.EasyMarketplace.de
> DoNotReply@consolut.eu
>
>
>
> _____
>
> consolut Links
>
>
> * To visit your group on the web, go to:
> http://groups.consolut.net/group/SAP on System i/
>
>
> * To unsubscribe from this group, send an email to:
> DoNotReply@consolut.eu <
> mailto:DoNotReply@consolut.eu?
subject=Unsubscribe>
>
>
> * Your use of consolut is subject to the consolut Terms of
Service
> < http://www.consolut.net>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Have a look to our homepage at: http://www.EasyMarketplace.de
> DoNotReply@consolut.eu
>
>
> consolut Sponsor
>
> [IMAGE]
> [IMAGE]
>
>
>
>
> consolut Links
>
> To visit your group on the web, go to:
> http://groups.consolut.net/group/SAP on System i/
>
> To unsubscribe from this group, send an email to:
> DoNotReply@consolut.eu
>
> Your use of consolut is subject to the consolut Terms of
Service.
>
>
>
>
>
>
>
>
> Have a look to our homepage at: http://www.EasyMarketplace.de
> DoNotReply@consolut.eu
>
>
>
> consolut Sponsor
>
>
> <
>
http://rd.consolut.net/SIG=12cmo3tb8/M=266841.4700596.5858952.1261774/D=
egroupweb/S=1705123219:HM/EXP=1079192636/A=2026346/R=0/SIG=12473cbsu/
*http://www.lifescapeinc.com/picasa/landing.php?capid=314&caId=2343
> > click here
> <
> http://us.adserver.consolut.net/l?
M=266841.4700596.5858952.1261774/D=egroupweb/S
>
> :HM/A=2026346/rand=155322867>
>
>
> _____
>
> consolut Links
>
>
> * To visit your group on the web, go to:
> http://groups.consolut.net/group/SAP on System i/
>
>
> * To unsubscribe from this group, send an email to:
> DoNotReply@consolut.eu <
> mailto:DoNotReply@consolut.eu?
subject=Unsubscribe>
>
>
> * Your use of consolut is subject to the consolut Terms of
Service
> <http://www.consolut.net>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Have a look to our homepage at: http://www.EasyMarketplace.de
> DoNotReply@consolut.eu
>
>
>
>
> consolut Links
>
> To visit your group on the web, go to:
> http://groups.consolut.net/group/SAP on System i/
>
> To unsubscribe from this group, send an email to:
> DoNotReply@consolut.eu
>
> Your use of consolut is subject to the consolut Terms of
Service.
Have a look to our homepage at: http://www.EasyMarketplace.de
DoNotReply@consolut.eu
consolut Sponsor
click here
[IMAGE]
consolut Links
To visit your group on the web, go to:
http://groups.consolut.net/group/SAP on System i/
To unsubscribe from this group, send an email to:
DoNotReply@consolut.eu
Have a look to our homepage at: http://www.EasyMarketplace.de
DoNotReply@consolut.eu
consolut Links
Durban Tours - Südafrika Safari
ABAP Short Reference BAL Application Log Documentation
This documentation is copyright by SAP AG.
Length: 26355 Date: 20240424 Time: 191423 sap01-206 ( 5 ms )
