[Issues] Exception: ORA-12899: value too large for column "AWOPER"."COADDEDREGRIDDEDFRAME"."OBJECT#" (actual: 405, maximum: 297)

[Philippe Heraudeau]

Hi All,

I get this error message on an coadd of 32 frames of chip50 for WFI
It looks like the OBJECT name of the final coadd is too long to be 
handle by Oracle,
since aw stacks the names of all 32 chips as the final name it is beyond 
the limit of 297 and the file cannot be commited...
Could you please have a look and cut the OBJECT name at the right place 
for Oracle?

Thanks
Philippe


[foucault] 16:09:25 - [node199] 15:58:36 - Computing statistics for 
Sci-PHERAUDEAU-WFI-------#844---Coadd---Sci-54362.5804703-cce623ed722d87f35bad7717a1eaa88be4c500ad.fits
[foucault] 16:09:25 - [node199] 15:58:39 -   mean   :   5.06e-12
[foucault] 16:09:25 - [node199] 15:58:39 -   median :          0
[foucault] 16:09:25 - [node199] 15:58:39 -   stddev :   2.76e-10
[foucault] 16:09:25 - [node199] 15:58:39 - Making catalog to determine 
psf_radius
[foucault] 16:09:25 - [node199] 15:58:39 - Running: sex 
Sci-PHERAUDEAU-WFI-------#844---Coadd---Sci-54362.5804703-cce623ed722d87f35bad7717a1eaa88be4c500ad.fits 
-c tmp1190210152.619672.45wQI_.psfsex.conf
[foucault] 16:09:25 - [node199] 15:59:01 - RUNNING: ldacconv -i 
tmp1190210152.619672.45wQI_.psfsex.cat -o 
Sci-PHERAUDEAU-WFI-------#844---Coadd---Sci-54362.5804703-cce623ed722d87f35bad7717a1eaa88be4c500ad.psf.cat 
-b 1 -c OMEGACAM -f CousinsR
[foucault] 16:09:25 - [node199] 15:59:01 - RUNNING: ldacfilter -i 
Sci-PHERAUDEAU-WFI-------#844---Coadd---Sci-54362.5804703-cce623ed722d87f35bad7717a1eaa88be4c500ad.psf.cat 
-o 
Sci-PHERAUDEAU-WFI-------#844---Coadd---Sci-54362.5804703-cce623ed722d87f35bad7717a1eaa88be4c500ad.psf.cat.filt.cat 
-t OBJECTS -c "(Flag = 0) AND (FLUX_RADIUS > 1.25);"
[foucault] 16:09:25 - [node199] 15:59:01 - Median stellar FWHM of 
sources for 
Sci-PHERAUDEAU-WFI-------#844---Coadd---Sci-54362.5804703-cce623ed722d87f35bad7717a1eaa88be4c500ad.fits 
(arcsec): 0.860885
[foucault] 16:09:25 - [node199] 15:59:01 - WARNING: can not derive 
psf_radii per ccd for CoaddedRegriddedFrame 
Sci-PHERAUDEAU-WFI-------#844---Coadd---Sci-54362.5804703-cce623ed722d87f35bad7717a1eaa88be4c500ad.fits, 
the dither pattern is too wide to compare the PSF on a per CCD basis
[foucault] 16:09:25 - [node199] 15:59:01 - 
[CoaddedRegriddedFrame.make_psf_end_to_end_dict] WARNING: 
psf_radii_per_ccd of CoaddedRegriddedFrame 
Sci-PHERAUDEAU-WFI-------#844---Coadd---Sci-54362.5804703-cce623ed722d87f35bad7717a1eaa88be4c500ad.fits 
has default value ([]), can not verify frame
[foucault] 16:09:25 - [node199] 15:59:01 - CoaddedRegriddedFrame.verify: 
Quality OK
[foucault] 16:09:25 - [node199] 15:59:01 - Storing 
Sci-PHERAUDEAU-WFI-------#844---Coadd---Sci-54362.5804703-cce623ed722d87f35bad7717a1eaa88be4c500ad.fits
[foucault] 16:09:25 - [node199] 15:59:03 - Compressing 
Cal-PHERAUDEAU-WFI-------#844---Coadd---Wei-54362.5804727-94b3e17efd6b3dc3d36647fd5ba344d6a04b8f43.fits 
. . .
[foucault] 16:09:25 - [node199] 15:59:12 - 
Cal-PHERAUDEAU-WFI-------#844---Coadd---Wei-54362.5804727-94b3e17efd6b3dc3d36647fd5ba344d6a04b8f43.fits[93540kb] 
-> 
Cal-PHERAUDEAU-WFI-------#844---Coadd---Wei-54362.5804727-94b3e17efd6b3dc3d36647fd5ba344d6a04b8f43.fits.gz[58950kb] 
(8.63sec)
[foucault] 16:09:25 - [node199] 15:59:12 - Storing 
Cal-PHERAUDEAU-WFI-------#844---Coadd---Wei-54362.5804727-94b3e17efd6b3dc3d36647fd5ba344d6a04b8f43.fits.gz
[foucault] 16:09:25 - Error executing 'execute'
[foucault] 16:09:25 - Exception:  ORA-12899: value too large for column 
"AWOPER"."COADDEDREGRIDDEDFRAME"."OBJECT#" (actual: 405, maximum: 297)
[foucault] 16:09:25 -
[foucault] 16:09:25 -   File 
"/home/rugwn201/omegacen/awehome/opipe/current/astro/net/dpu_runner.py", 
line 174, in main
[foucault] 16:09:25 -     job.execute()
[foucault] 16:09:25 -   File 
"/net/hercules01/data/users/heraud/ASTROWISE/opipe/DBRecipes/Coadd.py", 
line 112, in execute
[foucault] 16:09:25 -   File 
"/net/hercules01/data/users/heraud/ASTROWISE/opipe/DBRecipes/Coadd.py", 
line 151, in coadd_regridded_frames
[foucault] 16:09:25 -   File 
"/net/hercules01/data/users/heraud/ASTROWISE/opipe/astro/main/DataObject.py", 
line 131, in commit
[foucault] 16:09:25 -   File 
"/net/hercules01/data/users/heraud/ASTROWISE/opipe/astro/database/DBMain.py", 
line 128, in commit
[foucault] 16:09:25 -   File 
"/net/hercules01/data/users/heraud/ASTROWISE/opipe/astro/database/DBOracle.py", 
line 284, in commit
[foucault] 16:09:25 -   File 
"/net/hercules01/data/users/heraud/ASTROWISE/opipe/astro/database/DBOracle.py", 
line 318, in insert_or_update
[foucault] 16:09:25 -   File 
"/net/hercules01/data/users/heraud/ASTROWISE/opipe/astro/database/DBOracle.py", 
line 163, in insert_into_flattable
[foucault] 16:09:25 -
Current profile:
- username : awpheraudeau
- database : db.astro.rug.astro-wise.org
- project  : ALL

awe> a = CoaddedRegriddedFrame.filename == 
'Sci-PHERAUDEAU-WFI-------#844---Coadd---Sci-54362.5804703-cce623ed722d87f35bad7717a1eaa88be4c500ad.fits'
awe> len(a)
0

-- 
==========================================================================
Dr. Philippe Heraudeau
Argelander-Institut für Astronomie Email: heraudeau at astro.uni-bonn.de
Auf dem Hügel 71                   Tel.: +49 (0)228 733673
D-53121 Bonn                       Fax.: +49 (0)228 731775
Germany
=========================================================================