Re: [cx-oracletools-users] Weird ExportObjects error..
Brought to you by:
atuining
Menu
▾
▴
Re: [cx-oracletools-users] Weird ExportObjects error..
|
From: Michael M. <mm...@gm...> - 2007-09-28 00:25:38
|
546,549c546,547
< row = cursor.fetchone()
< # total hack
< if not row:
< row = ['',0,0,0,0,0]
---
> if not row:
> raise "Unable to locate LOB segment %s" % self.name
On 9/27/07, Michael March <mm...@gm...> wrote:
> Just for kicks I created this VERY hacky hack.. It seems to silence
> the issue.. but I'm not sure at what cost.
>
> On 9/27/07, Michael March <mm...@gm...> wrote:
> > python ExportObjects.py -t --log-level=debug
> > --log-file=/tmp/rebuildTableCHCO.log --schema=USER/PA...@TE...
> > --name=SCHEMA_NAME
> >
> > === snip ===
> > from user_segments
> > where segment_type = 'LOBSEGMENT' and segment_name = :p_SegmentName
> > 14:14:28.704 BIND VARIABLES
> > p_SegmentName => 'SYS_LOB0000084624C00005$$'
> > /usr/lib/python2.5/site-packages/cx_OracleObject/Object.py:548:
> > DeprecationWarning: raising a string exception is deprecated
> > raise "Unable to locate LOB segment %s" % self.name
> > 14:14:28.780 Configured Python exception encountered:
> > 14:14:28.781 Message: Unable to locate LOB segment CLNT_DRUG_GRP_RULE
> > 14:14:28.781 Template Id: 0
> > 14:14:28.781 Arguments:
> > 14:14:28.781 Traceback:
> > 14:14:28.781 file
> > /usr/lib/python2.5/site-packages/cx_OracleObject/Object.py, line 548,
> > in __RetrieveSegment
> > 14:14:28.781 file
> > /usr/lib/python2.5/site-packages/cx_OracleObject/Object.py, line 516,
> > in __init__
> > 14:14:28.781 file
> > /usr/lib/python2.5/site-packages/cx_OracleObject/Object.py, line 993,
> > in ObjectIterator
> > 14:14:28.781 Details:
> > 14:14:28.781 Exception type: Unable to locate LOB segment
> > CLNT_DRUG_GRP_RULE
> > 14:14:28.781 Local Variables:
> > 14:14:28.781 file
> > /usr/lib/python2.5/site-packages/cx_OracleObject/Object.py, line 548,
> > in __RetrieveSegment
> > 14:14:28.781 cursor -> <cx_OracleEx.Cursor on
> > <cx_OracleEx.Connection to ODS...@WK...>>
> > 14:14:28.781 isPrepared -> None
> > 14:14:28.781 row -> None
> > 14:14:28.781 self -> <cx_OracleObject.Object.Lob object at 0x829aa2c>
> > 14:14:28.781 statement -> "\n select\n
> > tablespace_name,\n
> > initial_extent,\n next_extent,\n
> > min_extents,\n max_extents,\n
> > pct_increase\nfrom user_segments\nwhere segment_type =
> > 'LOBSEGMENT' and segment_name = :p_SegmentName"
> > 14:14:28.781 file
> > /usr/lib/python2.5/site-packages/cx_OracleObject/Object.py, line 516,
> > in __init__
> > 14:14:28.781 environment ->
> > <cx_OracleObject.Environment.Environment object at 0x829244c>
> > 14:14:28.781 name -> 'CLNT_DRUG_GRP_RULE'
> > 14:14:28.781 owner -> 'ODS_CHCO'
> > 14:14:28.781 row -> ('ODS_CHCO', 'CLNT_DRUG_GRP_RULE',
> > 'CLIENT_DRUG_CLS_GRP', 'SYS_LOB0000084624C00005$$', 'YES')
> > 14:14:28.781 self -> <cx_OracleObject.Object.Lob object at 0x829aa2c>
> > 14:14:28.781 file
> > /usr/lib/python2.5/site-packages/cx_OracleObject/Object.py, line 993,
> > in ObjectIterator
> > 14:14:28.781 args -> ()
> > 14:14:28.781 classFactory -> <class 'cx_OracleObject.Object.Lob'>
> > 14:14:28.781 cursor -> <cx_OracleEx.Cursor on
> > <cx_OracleEx.Connection to ODS...@WK...>>
> > 14:14:28.781 environment ->
> > <cx_OracleObject.Environment.Environment object at 0x829244c>
> > 14:14:28.781 keywordArgs -> {'p_Owner': 'ODS_CHCO',
> > 'p_Name': 'CLIENT_DRUG_CLS_GRP'}
> > 14:14:28.781 row -> ('ODS_CHCO', 'CLNT_DRUG_GRP_RULE',
> > 'CLIENT_DRUG_CLS_GRP', 'SYS_LOB0000084624C00005$$', 'YES')
> > 14:14:28.781 statement -> '\n select\n
> > o.owner,\n o.column_name,\n o.table_name,\n
> > o.segment_name,\n o.in_row\n from
> > %(p_ViewPrefix)s_lobs o\n %(p_WhereClause)s\n order by
> > o.column_name'
> > 14:14:28.781 tag -> 'Lobs'
> > 14:14:28.781 whereClause -> 'where o.owner = :p_Owner and
> > o.table_name = :p_Name'
> > 14:14:28.782 ending logging
> >
> > --
> > <admiral>
> >
> > Michael F. March ----- mmarch at gmail dot com
> >did
> > "Seriously" - HSR
> >
>
|