Ansicht
Dokumentation

05041 - How often do you have to delete SQL packages?

05041 - How often do you have to delete SQL packages?

Fill RESBD Structure from EBP Component Structure   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by SAP AG.
SAP E-Book

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

Fill RESBD Structure from EBP Component Structure   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.

Length: 5385 Date: 20240302 Time: 134310     sap01-206 ( 3 ms )