[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    General error;-9205 in select * from VIEW
From:       "Jens-Peter C. Hillers" <jph () remoteweb ! de>
Date:       2005-12-22 11:33:18
Message-ID: 05cb01c606eb$81621d90$3201a8c0 () office ! remoteweb ! de
[Download RAW message or body]


Hello,

I get :

[MySQL MaxDB][LIBSQLOD SO][MaxDB] General error;-9205 POS(1) System error:
AK Catalog information not found:000000000004F200006000

error by doing a

Select * from V_ArtDisp

---------- definition of V_ArtDisp ------------------------

create view V_ArtDisp as
SELECT
N.NEWSID, N.NBID, N.BILDID1, N.BILDID2, N.SPRID, N.NTID, N.MANID NMANID,
N.HEADLINE,
N.SUBHEADLINE, N.IDXTXT, N.VALIDFROM, N.VALIDUNTIL, N.HOMEPAGE, N.FREIGABE,
N.TEXT1, N.TEXT2, N.WANN NWANN,
A.ARTID, A.MANID AMANID, A.WAGRID, A.HERSTID, A.ZBGID,
A.PMID, A.EINHID, A.ARTNUM, A.PREIS, A.GEWICHT, A.WANN AWANN,
B.NAME BNAME,

W.NAME WNAME,W.WAGRNR, W.SORTKZ, W.MWSTID, M.NAME MNAME, M.PROZ,
E.NAME ENAME, E.KURZNAME,
P.NAME PNAME, P.INCL,
H.NAME HNAME,
U.NAME UNAME
FROM ARTIKEL A,NEWS N, NEWSBER B,WAGR W,MWST M , EINHEIT E, PREISMTD P,
HERSTELLER H, RUSER U
WHERE A.NEWSID = N.NEWSID
AND N.NTID = 2
AND A.WER = U.WHO(+)
AND N.NBID = B.NBID(+)
AND A.WAGRID = W.WAGRID(+)
AND A.EINHID = E.EINHID(+)
AND A.PMID = P.PMID(+)
AND A.HERSTID = H.HERSTID(+)
AND W.MWSTID = M.MWSTID(+)
-------------------------------------------------------

The funny thing is that just using the SELECT the Databas has no problems
AND

The Database can even explain the Query:

      EXPLAIN select * from V_ArtDisp
       OWNER    TABLENAME    COLUMN_OR_INDEX    STRATEGY    PAGECOUNT
           A       TABLE SCAN    1
           N   NEWSID   JOIN VIA KEY COLUMN    2
           B   NBID   JOIN VIA KEY COLUMN    1
                   TABLE HASHED
           W   WAGRID   JOIN VIA KEY COLUMN    1
                   TABLE HASHED
           M   MWSTID   JOIN VIA KEY COLUMN    1
                   TABLE HASHED
           E   EINHID   JOIN VIA KEY COLUMN    1
           P   PMID   JOIN VIA KEY COLUMN    1
                   TABLE HASHED
           H   HERSTID   JOIN VIA KEY COLUMN    1
           U   WHO   JOIN VIA KEY COLUMN    1
                   TABLE HASHED
                    NO TEMPORARY RESULTS CREATED
       INTERNAL   TEMPORARY RESULT       TABLE SCAN    500
                    RESULT IS COPIED , COSTVALUE IS    1038


Any Idea ?

regards
jph
___________________________
Dipl.-Ing. Jens-Peter C. Hillers
Remote Web Services GmbH
Tel: +49 40 25 49 06 22
Fax: +49 40 36 00 67 27
Email: jph@remoteweb.de
____________________________



[prev in list] [next in list] [prev in thread] [next in thread]