[OGo-Users-DE] fehlerhafte oid

[Stegbauer]

-------- Original-Nachricht --------
Datum: Sun, 3 Dec 2006 12:10:27 +0100
Von: Helge Hess <helge.hess@opengroupware.org>
An: users-de@opengroupware.org
Betreff: Re: [OGo-Users-DE] fehlerhafte oid

> On Nov 28, 2006, at 11:31, Stegbauer wrote:
> >> On Nov 21, 2006, at 11:38, Stegbauer wrote:
> >>>   name:    LSDBObjectCommandException
> >>>   reason:  appointment::query failed: could not get date ids
> >>>   info:
> >>>
> >>> und fliege raus.
> >>> was ist muss hier an den date id's angepasst werden, dass diese
> >>> abfrage wieder fkt?
> >> Was sagt denn das Logfile dazu?
> > sorry for my delay:
> >
> > Nov 28 11:27:53 ogo-webui-1.0 [31317]: |ogo-webui-1.0|  
> > <OpenGroupware[0x081269DC]: name=ogo-webui-1.0>: caught:
> >   (Exception name:LSDBObjectCommandException  
> > class:LSDBObjectCommandException reason:appointment::query failed:  
> > could not get date ids info:<nil>)
> > in context:
> 
> Kann man nicht viel mehr erkennen. Offensichtlich wird ein SQL Query  
> abgefahren der keine Resultate liefert. Wenn du schauen moechtest was  
> fuer ein Query das ist, musst du das PGDebugEnabled Default  
> anschalten. Dann werden alle SQL Statements geloggt.
> Eventuell ist selbiges ja fehlerhaft.

hallo helge,

habe das PGDebugEnabled gesetzt und bekomme jetzt in der webui.log folgende statements:

Dec 18 15:49:48 ogo-webui-1.0 [31251]: PG0x08E261FC SQL: BEGIN TRANSACTION
Dec 18 15:49:48 ogo-webui-1.0 [31251]: PG0x08E261FC SQL: SELECT DISTINCT t1.anniversary, t1.assistant_name, t1.associated_categories, t1.associated_company, t1.associated_contacts, t1.boss_name, t1.company_id, t1.contact_id, t1.db_status, t1.department, t1.description, t1.dir_server, t1.email, t1.email_alias, t1.fileas, t1.freebusy_url, t1.im_address, t1.is_location_team, t1.is_team, t1.login, t1.name_af
fix, t1.name_title, t1.number, t1.object_version, t1.occupation, t1.office, t1.owner_id, t1.partner_name, t1.sensitivity FROM  team t1, company_assignment t2 WHERE t2.sub_company_id = 47990 AND t1.company_id = t2.company_id
Dec 18 15:49:48 ogo-webui-1.0 [31251]: PG0x08E261FC SQL: COMMIT TRANSACTION
Dec 18 15:49:48 ogo-webui-1.0 [31251]: PG0x08E261FC SQL: BEGIN TRANSACTION
Dec 18 15:49:48 ogo-webui-1.0 [31251]: PG0x08E261FC SQL: SELECT DISTINCT t1.company_id FROM  person t1, company_assignment t2 WHERE (t2.company_id=10003) AND (t1.db_status <> 'archived') AND t1.company_id = t2.sub_company_id
Dec 18 15:49:48 ogo-webui-1.0 [31251]: PG0x08E261FC SQL: SELECT DISTINCT t1.sub_company_id, t1.company_id FROM  company_assignment t1 WHERE t1.sub_company_id IN (13330,300080,47990,15100,15720,14110,35750,154140,14300,14920,65390,16070,229320,14740,13810,16260,13160,14560,10160,16580,15280)
Dec 18 15:49:48 ogo-webui-1.0 [31251]: PG0x08E261FC SQL: SELECT DISTINCT t2.date_id FROM  date_company_assignment t1, date_x t2 WHERE ((t1.company_id IN (16260,10540,14560,114340,25930,65390,14110,14740,229320,14300,10470,14920,,108980,16580,15100,12540,35960,154140,10003,15720,13810,9991,47990,35750,15280,13160,96050,300080,13330,16070,10160)) AND (t2.end_date > '2006-12-18 00:00:00+0100')) AND (t2.star
t_date < '2006-12-24 23:59:59+0100') AND t2.date_id = t1.date_id
Dec 18 15:49:48 ogo-webui-1.0 [31251]: PG0x08E261FC SQL: ROLLBACK TRANSACTION
Dec 18 15:49:48 ogo-webui-1.0 [31251]: |ogo-webui-1.0| <OpenGroupware[0x08126A24]: name=ogo-webui-1.0>: caught:
  (Exception name:LSDBObjectCommandException class:LSDBObjectCommandException reason:appointment::query failed: could not get date ids info:<nil>)
in context:
  <0x08E0FEC4[WOContext]: 01f4586aa8c08e0fec4 app=ogo-webui-1.0 sn=7A137A13054586AA7E eid=01f4586aa8c08e0fec4.0.17.1.3.b.weekoverview.3.5.1.3 rqeid=01e4586aa8308dddf9c.0.17.1.1.1>.
Dec 18 15:49:48 ogo-webui-1.0 [31251]: |ogo-webui-1.0| terminating session due to exception: 7A137A13054586AA7E
Dec 18 15:49:48 ogo-webui-1.0 [31251]: |ogo-webui-1.0| WOServerSessionStore: session 7A137A13054586AA7E terminated.
Dec 18 15:49:48 ogo-webui-1.0 [31251]: LSWImapMails WARNING: could not determine context object!
Dec 18 15:49:48 ogo-webui-1.0 [31251]: LSWImapMails could not get session object from context 
Dec 18 15:49:48 ogo-webui-1.0 [31251]: LSWImapMails WARNING: missing session for component!
Dec 18 15:49:48 ogo-webui-1.0 [31251]: LSWImapMails WARNING: could not determine context object!
Dec 18 15:49:48 ogo-webui-1.0 [31251]: LSWImapMails could not get session object from context 
Dec 18 15:49:48 ogo-webui-1.0 [31251]: LSWImapMails WARNING: missing session for component!


der fehler befindet sich im dritten statement:
SELECT DISTINCT t2.date_id FROM  date_company_assignment t1, date_x t2 WHERE 
((t1.company_id IN (16260,10540,14560,114340,25930,65390,14110,14740,229320,14300,10470,14920,,108980,
16580,15100,12540,35960,154140,10003,15720,13810,9991,47990,35750,15280,13160,96050,300080,13330,16070,10160)) 
AND (t2.end_date > '2006-12-18 00:00:00+0100')) AND (t2.start_date < '2006-12-24 23:59:59+0100') AND t2.date_id = t1.date_id


hier sind zwischen 14920,,108980 2, 
das ist ein syntaxfehler im sql-statement.

muss ich jetzt einen eintrag in der tabelle loeschen? falls ja, welchen, bzw wie finde ich den raus?


zusaetzliche frage: warum werden select statements in eine transaction eingefasst?

viele gruesse
thomas

-- 
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! 
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer