Forgot to set status to resolved.
As noted in msg84, this is fixed with rev524 in svn.

Also, is this the same as Issue21?

So does this fix the problem for you?  Should this be swithched to 'resolved'?

I'm putting it in as 'testing' for now.

Fixed in rev524

removed support for pscyopg2.  I was picking up psycopg2.ProgrammingError
but otherwise was using pysycopg (ver 1.1.x).

ERROR reading file: msg83
Possibly a access right configuration problem.
[Errno 13] Permission denied: '/extra/trackers/sgdi/db/files/msg/0/msg83'

That's the function I was talking about.  The relevant code is:
        try:
            sqlInterface('SELECT * FROM %(grpTab)s LIMIT 1'%locals())
        except ProgrammingError:
            createQry = "CREATE TABLE %(grpTab)s (geneid varchar(80));"%locals()

Why would the ProgrammingError not get caught there?

ERROR reading file: msg81
Possibly a access right configuration problem.
[Errno 13] Permission denied: '/extra/trackers/sgdi/db/files/msg/0/msg81'

Wha'ts the traceback on this?  

Is the error coming from createWorkspaceDBTables() (in SGDIworkspace.py)?

That's the only place I see with the 'LIMIT 1' on the query and it is explicitly
catching the ProgrammingError and creating the table if it doesn't exist.

This is the same error (and description) as the previous one you put in.  Does
this imply that this time you have datasets in the DB?

So I thought I would get further than this.  But I can't create a workspace.
This is with my starting from scratch ova instance.

Site Error

An error was encountered while publishing this resource.

Error Type: ProgrammingError
Error Value: ERROR: relation "sgdi_seth_test1_globalreppool" does not exist
SELECT * FROM sgdi_seth_test1_globalreppool LIMIT 1

Troubleshooting Suggestions