Ansicht
Dokumentation
05041 - How often do you have to delete SQL packages?
PERFORM Short Reference General Data in Customer MasterThis documentation is copyright by SAP AG.
How often do you have to delete SQL packages?
Hi Charlie,If those "database" errors are SQL errors (from the message file QSQLMSG in
lib QSYS):
SQL0303: "Host variable &2 not compatible."
SQL0443: "Trigger program or external routine detected an error"
SQL0615: "Object &1 in &2 type *&3 not dropped. It is in use"
Does BW do a lot of indexing rebuilding? (lots of dropping and re-creating
after data loads) Just a guess.
We usually only delete SQL packages after kernel upgrades or LCP / HotPack
upgrades. Not sure if that's even necessary, but we've been bit a few times
so we do it as a matter of procedure. (And of course, whenever the "bizarre
database problem that can't be solved by other means" issue arises too).
Rick
-----Original Message-----
From: Charlie Kil [mailto:chkil_2000Zy...]
Sent: Tuesday, February 12, 2002 10:54 AM
To: Gueldenpfennig, Volker
Cc: Sap400 (E-mail)
Subject: RE: How often do you have to delete SQL
packages?
Thanks Volker
FYI, we have R3 and SEM system on 46C with the same PTFs level, same OS
version as BW
However, the database errors only occur on BW.
This is strange to me.
Any comments?
--- "Gueldenpfennig, Volker" <volker.gueldenpfennigZs...> wrote:
> Hi Charly,
>
> as deleting the SQL-Packs is just a "workaround", you should open a PMR
with
> IBM on this. They should give you directoctions how to handle this, as it
> seems to reoccur on your site on a regular base. (e.g. backup of the
> sql-packs ...).
> As SAP doesn't change the SQL-Packs, just creates them via APIs and uses
> them and it reoccurs, the only address to solve your problem, can be IBM
in
> this case.
>
> Regards
>
> Volker
>
> > -----Original Message-----
> > From: Charlie Kil [mailto:chkil_2000Zy...]
> > Sent: Dienstag, 12. Februar 2002 16:29
> > To: DoNotReply@consolut.eu
> > Subject: How often do you have to delete SQL packages?
> >
> >
> > Hello,
> >
> > I have a question for you guys.
> > We are having Database error -443, -615 and -303 on our BW
> > development system(ASCII).
> > Deleting SQL packages resolved the problem but it occurred
> > after a couple of days again.
> >
> > I have couple of questions at this point.
> >
> > 1. How often should I delete SQL packages?
> >
> > 2. What are those errors, Database error 443, 615 and 303?
> > The system log did not give much information and I could
> > not find any related
> > documents.
> >
> > If any of you had this kind of experience, please drop me a note.
> > Thanks so much.
> >
> > Best regards
> > Charlie
> >
> > __________________________________________________
> > Do You consolut?
> > Send FREE Valentine eCards with consolut Greetings!
> > http://greetings.consolut.net
> >
> > ------------------------ consolut Sponsor
> > ---------------------~-->
> > Sponsored by VeriSign - The Value of Trust
> > Pinpoint the right security solution for your company - FREE
> > Guide from industry leader VeriSign gives you all the facts.
> > http://us.click.consolut.net/lWSNbC/WdiDAA/yigFAA/dkFolB/TM
> > --------------------------------------------------------------
> > -------~->
> >
> > Have a look to our homepage at: http://www.consolut.net
> > DoNotReply@consolut.eu
> >
> > Your use of consolut is subject to
> http://www.consolut.net
>
__________________________________________________
Do You consolut?
Send FREE Valentine eCards with consolut Greetings!
http://greetings.consolut.net
Durban Tours - Südafrika Safari
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up
This documentation is copyright by SAP AG.
Length: 5385 Date: 20240420 Time: 121432 sap01-206 ( 3 ms )
