Ansicht
Dokumentation

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

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

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   General Data in Customer Master  
This documentation is copyright by SAP AG.
SAP E-Book

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


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









Durban Tours - Südafrika Safari

BAL Application Log Documentation   General Material Data  
This documentation is copyright by SAP AG.

Length: 22531 Date: 20240329 Time: 164458     sap01-206 ( 3 ms )