Ansicht
Dokumentation

13348 - Antwort: SQL error "-551" occurred when accessing table "AGR_USERS ".

13348 - Antwort: SQL error "-551" occurred when accessing table "AGR_USERS ".

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

Antwort: SQL error "-551" occurred when accessing table "AGR_USERS ".

Hi,

but you can have a look into the joblog of 117748/QN202/WP01 !
There you'll find it.

btw: the easiest is, you give me a short call on my mobile ...

Regards

Volker
--- In DoNotReply@consolut.eu, "Per-Lennart Andersson"
<peranderssonZc...> wrote:
>
> 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
>
> Your use of consolut is subject to the consolut Terms of
Service.


Durban Tours - Südafrika Safari

RFUMSV00 - Advance Return for Tax on Sales/Purchases   General Material Data  
This documentation is copyright by SAP AG.

Length: 32493 Date: 20240328 Time: 191134     sap01-206 ( 5 ms )