[WP3] Re: Sourcelists

[Jan Snigula]

Hello Danny,

so here's the offending query:

(Pdb) print query
call
"AWOPER".AW_UTIL.MAKESUBTYPE('SourceList$sources$','SourceList$sources$00001',
"AWOPER".CHR_LIST('BackGr','Corr','ERRA_IMAGE','FIELD_POS','FLUXERR_ISO',
'FLUX_ISO','FLUX_RADIUS','Flag','Level','MAGERR_ISO','MAG_ISO','MaxVal',
'NPIX','SeqNr','XM2','Xpos','YM2','Ypos'),"AWOPER".CHR_LIST('DOUBLE PRECISION',
'DOUBLE PRECISION','DOUBLE PRECISION','SMALLINT','DOUBLE PRECISION',
'DOUBLE PRECISION','DOUBLE PRECISION','SMALLINT','DOUBLE PRECISION',
'DOUBLE PRECISION','DOUBLE PRECISION','DOUBLE PRECISION','SMALLINT',
'SMALLINT','DOUBLE PRECISION','DOUBLE PRECISION','DOUBLE PRECISION',
'DOUBLE PRECISION'))

Jan


On Thu, 29 Jan 2004, Danny R. Boxhoorn wrote:

>
> Hoi Jan,
>
> What I do in such cases is to start the debugger and look at the
> query.
> If this error is raised by a script you should run the script with
>
>    awe -i <python script>
>
> This will give you an awe prompt after the error.
> Otherwise, if you get this error in an interactive awe session, you are
> returned to the awe prompt automatically after the error.
>
> >From the awe prompt do
>
>    from pdb import pm; pm()
>
> This will start the "post mortem" debugger.
> In this case you want to do `up' in the debugger, followed by `list'
> and you should see line 127 of DBOracle.py. If not you may have to
> go `up' or `down' an appropriate number of times before you do.
> Next type `print query'. This will show the query that fails.
> Just send it so that we can have a look at it.
>
> Cheers,
>
>                                                    Danny
>
> > I'm trying to implement the photred code in python and was trying out the
> > SourceList interface. When trying to generate a sourcelist  I run across
> > the following error:
> >
> > 12:31:09 - Running : ldacconv -i sex.cat -o ldac.cat -b 1 -c OMEGACAM -f
> > 842
> > Traceback (most recent call last):
> >   File "<stdin>", line 1, in ?
> >   File
> > "/home/pegasus/snigula/work/AWPipeline/opipe/Experimental/SourceList.py",
> > line 402, in make
> >     self.make_sourcelist_from_catalog()
> >   File
> > "/home/pegasus/snigula/work/AWPipeline/opipe/Experimental/SourceList.py",
> > line 277, in make_sourcelist_from_catalog
> >     self.commit()
> >   File
> > "/home/pegasus/snigula/work/AWPipeline/opipe/astro/database/DBMain.py",
> > line 124, in commit
> >     DBObject.database.commit(self)
> >   File
> > "/home/pegasus/snigula/work/AWPipeline/opipe/astro/database/DBOracle.py",
> > line 269, in commit
> >     self.insert_or_update(other)
> >   File
> > "/home/pegasus/snigula/work/AWPipeline/opipe/astro/database/DBOracle.py",
> > line 297, in insert_or_update
> >     self.insert_into_database(other)
> >    File
> > "/home/pegasus/snigula/work/AWPipeline/opipe/astro/database/DBOracle.py",
> > line 396, in insert_into_database
> >     sub_type = register_objecttype(supertype, attributes)
> >   File
> > "/home/pegasus/snigula/work/AWPipeline/opipe/astro/database/DBOracle.py",
> > line 127, in register_objecttype
> >     cursor.execute(query)
> >   File
> > "/home/pegasus/snigula/work/AWPipeline/opipe/i686-pc-linux/lib/python2.2/site-packages/DCOracle2/DCOracle2.py",
> > line 973, in execute
> >     result = self._cursor.execute()
> > dco2.DatabaseError: (6576, 'ORA-06576: not a valid function or procedure
> > name')
> >
> >
> > To me this looks like an inconsitency between python and the database,
> > but as database I use a fresh test database.
> >
> > Any hints?
> >
> > Jan
> >
> >
> >
> > _______________________________________________
> > WP3 mailing list
> > WP3 at astro-wise.org
> > http://listman.astro-wise.org/mailman/listinfo/wp3
> _______________________________________________
> WP3 mailing list
> WP3 at astro-wise.org
> http://listman.astro-wise.org/mailman/listinfo/wp3
>