Thread: [cx-oracletools-users] Weird ExportObjects error..
Brought to you by:
atuining
Menu
▾
▴
cx-oracletools-users
|
From: Michael M. <mm...@gm...> - 2007-09-27 20:55:12
|
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
"Seriously" - HSR
|
|
From: Michael M. <mm...@gm...> - 2007-09-28 00:25:19
|
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
>
> "Seriously" - HSR
>
|
|
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
> >
>
|
|
From: Anthony T. <ant...@gm...> - 2007-10-01 21:15:14
|
Interesting. Do you have the create table statement you used for this?
I wouldn't mind solving this problem but I've never seen it before.
I'd like to also eliminate the string exceptions at the same time.
Thanks.
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
>
> "Seriously" - HSR
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> cx-oracletools-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracletools-users
>
|
Thanks for helping keep SourceForge clean.
X