Ansicht
Dokumentation
13347 - Antwort: SQL error "-551" occurred when accessing table "AGR_USERS ".
TXBHW - Original Tax Base Amount in Local Currency Vendor Master (General Section)This documentation is copyright by SAP AG.
Antwort: SQL error "-551" occurred when accessing table "AGR_USERS ".
Volker
Sorry to saw that can't see any reason cods in ST22 or SM21. Here you have
som information from ST22
ABAP runtime errors DBIF_RSQL_SQL_ERROR
Occurred on 13.03.2004 at 12:24:08
SQL error "-7008" occurred when accessing table "ALTIDTOOL ".
How to correct the error
Database error text........: "ALTIDTOOL in R3QN2DATA not valid for
operation.
Job=117748/QN202/WP01"
Internal call code.........: "[RSQL/INSR/ALTIDTOOL ]"
Please check the entries in the system log (Transaction SM21).
If the error occurred in a non-modified SAP program, you may be
able to find a solution in the SAP note system.
If you have access to the note system yourself, use the following
search criteria:
"DBIF_RSQL_SQL_ERROR"
"SAPLSALU " or "LSALUU26 "
"SALU_TOOL_SET_FROM_DB"
If you cannot solve the problem yourself, please send the
/ 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 12:11 accessing table
"AGR_USERS ".
Please respond to SAP on System i
Hi,
SQL7008 ? Then the reason code is interesting in order to go
further. There are OSS notes out for 3 and 6 or 9 ...
Regards
Volker
--- In DoNotReply@consolut.eu, "Per-Lennart Andersson"
<peranderssonZc...> wrote:
>
> 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
>
> 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
Durban Tours - Südafrika Safari
BAL_S_LOG - Application Log: Log header data General Data in Customer Master
This documentation is copyright by SAP AG.
Length: 29046 Date: 20240425 Time: 064500 sap01-206 ( 5 ms )