[OGo-Users] incomplete transaction; scheduler disabled; obj_link table missing

[Dave Fisher]

Hi,

Strictly speaking this may be a postgres question, but my problem seems to be
rather ogo-specific and I'm not sure about whether to report it as a bug.

The scheduler on my ogo installation looks to be completely disabled.  This is
pretty significant, since scheduling is the most important feature of ogo for
me at the moment.

Whenever I try to access the scheduler via the web UI (as a an ordinary user or
as root) I get something like error message shown beneath my sig.  When the
problem first occurred I associated it with an apparently incomplete
transaction ... because I'd got no feedback from an attempt to save a new
schedule entry just before I saw the error message for the first time.

I don't know enough about how ogo uses postgres to be sure whether or not the
apparently incomplete transaction is just a red herring.

I notice that the error is identified as:

  "Relation obj_link; does not exist info:nil;"

According to psql there is no table in my ogo database with the name
"obj_link", but I also notice that the postgres schema which generated the
database does contain the SQL to create one, i.e.

CREATE TABLE obj_link (
  obj_link_id int          not null,
  source_id   int          not null,
  source_type varchar(50)  null,
  target      varchar(255) not null,
  target_id   int          null,
  target_type varchar(50)  null,
  link_type   varchar(50)  null,
  label       varchar(255) null);

Does this mean that I've stumbled over an ogo bug which deletes the table?  

I have only altered the database via the ogo web UI, i.e. never using tools
like psql.

If I did use psql to re-create the missing table, would that cause other
problems, e.g.  for objects that expect it to contain particular data?

Dave
--

<pre>
Application Server caught exception:

  session: 35413541093FC54E66
  element: 0863fc55473089714ac.1.17.1.1.3.b.weekoverview.3.5.1.4
  context: &lt;0x089714AC[WOContext]: 0863fc55473089714ac app=OpenGroupware sn=35413541093FC54E66 eid=0863fc55473089714ac.1.17.1.1.3.b.weekoverview.3.5.1.4 rqeid=&gt;
  request: &lt;WORequest[0x089246B4]: method=GET uri=/OpenGroupware/x/dock?woinst=13633&amp;page=SkySchedulerPage&amp;cid=0853fc5534b089714ac&amp;wosid=35413541093FC54E66 app=OpenGroupware rqKey=x rqPath=dock&gt;

  class:   NSException
  name:    WOKeyPathException
  reason:  couldn't get value for a keypath component
  info:
    {
    association = &lt;WOKeyPathAssociation[0x086DB63C]: keyPath=cacheDataSource.fetchObjects&gt;;
    exception = (Exception name:PostgreSQL72FatalError class:PostgreSQL72Exception reason:fatal pgsql error (channel=&lt;PostgreSQL72Channel[0x08924774] connection=0x089175A0&gt;): ERROR:  Relation &quot;obj_link&quot; does not exist
 info:&lt;nil&gt;);
    keyPath = &quot;cacheDataSource.fetchObjects&quot;;
}
</pre>