Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Zope: DB

OracleStorage problem

 

 

Zope db RSS feed   Index | Next | Previous | View Threaded


jagarrido at emergya

Jun 28, 2006, 5:33 AM

Post #1 of 2 (1464 views)
Permalink
OracleStorage problem

Hello all.

After installing a Oracle8i client in my Zope machine(2.8.3) and compiling
DCOracle2 product satisfactory, I added the DCOracle2 and DCOracleStorage
Directories at $ZOPE_INSTANCE/lib/python. Later, I created a
zodb_custom.py file at $ZOPE_INSTANCE and fixed $ORACLE_HOME variable at
my oracle_home client Directory.

My Oracle8i Database resides in other machine Zope resides. I fixed
tnsnames.ora of my Oracle client correctly to the Oracle machine(Solaris
9).

I executed the sqlplus -s user/pw [at] si @Full.sql sentence and tables were
created correctly in Oracle machine.

The problem resides at startup Zope, showing this error:

Traceback (most recent call last):
File "/home/jagarrido/Zope/DMR/lib/python/Zope2/Startup/run.py", line
56, in ?
run()
File "/home/jagarrido/Zope/DMR/lib/python/Zope2/Startup/run.py", line
21, in run
starter.prepare()
File "/home/jagarrido/Zope/DMR/lib/python/Zope2/Startup/__init__.py",
line 98, in prepare
self.startZope()
File "/home/jagarrido/Zope/DMR/lib/python/Zope2/Startup/__init__.py",
line 257, in startZope
Zope2.startup()
File "/home/jagarrido/Zope/DMR/lib/python/Zope2/__init__.py", line 47,
in startup
_startup()
File "/home/jagarrido/Zope/DMR/lib/python/Zope2/App/startup.py", line
64, in startup
DB = ZODB.DB(storage)
File "/home/jagarrido/Zope/DMR/lib/python/ZODB/DB.py", line 239, in
__init__
storage.load(z64,'')
File "/home/jagarrido/Zope/DMR/lib/python/DCOracleStorage/Full.py", line
250, in load
s, c = self._call('load', (z_oid, version), 'pickle')
File "/home/jagarrido/Zope/DMR/lib/python/DCOracleStorage/Full.py", line
201, in _call
return apply(getattr(self, name), args+(c,))
File "/home/jagarrido/Zope/DMR/lib/python/DCOracle2/DCOracle2.py", line
1492, in __call__
cursor.execute(sql,__plist=args)
File "/home/jagarrido/Zope/DMR/lib/python/DCOracle2/DCOracle2.py", line
973, in execute
result = self._cursor.execute()
dco2.DatabaseError: (24370, 'ORA-24370: illegal piecewise operation
attempted')


I see the Oracle error and says me:
ORA-24370: illegal piecewise operation attempted
Cause: Data of a certain datatype that does not support piecewise
operation is being sent or fetched in pieces.
Action: Always set the piece value to OCI_ONE_PIECE for datatypes that
does not support piecewise operation.

I see in a comment from Mathew:
This one looks like the stored procedure is trying to
return two LONG columns (which is not supported right now). Without
tracing it I can't say for sure what the illegal piecewise operation it
was trying to do, but it is LONG related, for sure.
The unique LONG is Z_PICKLE in ZODB_PICKLE table.

suggestions to resolve?

Thanks for all




_______________________________________________
Zope-DB mailing list
Zope-DB [at] zope
http://mail.zope.org/mailman/listinfo/zope-db


lists at zopyx

Jun 28, 2006, 5:39 AM

Post #2 of 2 (1362 views)
Permalink
Re: OracleStorage problem [In reply to]

Is there a *real* need your you using OracleStorage?
It is old, it is unmaintained, it is about 10 times slower than
FileSystemStorage.

-aj

--On 28. Juni 2006 14:33:46 +0200 jagarrido [at] emergya wrote:

> Hello all.
>
> After installing a Oracle8i client in my Zope machine(2.8.3) and compiling
> DCOracle2 product satisfactory, I added the DCOracle2 and DCOracleStorage
> Directories at $ZOPE_INSTANCE/lib/python. Later, I created a
> zodb_custom.py file at $ZOPE_INSTANCE and fixed $ORACLE_HOME variable at
> my oracle_home client Directory.
>
> My Oracle8i Database resides in other machine Zope resides. I fixed
> tnsnames.ora of my Oracle client correctly to the Oracle machine(Solaris
> 9).
>
> I executed the sqlplus -s user/pw [at] si @Full.sql sentence and tables were
> created correctly in Oracle machine.
>
> The problem resides at startup Zope, showing this error:
>
> Traceback (most recent call last):
> File "/home/jagarrido/Zope/DMR/lib/python/Zope2/Startup/run.py", line
> 56, in ?
> run()
> File "/home/jagarrido/Zope/DMR/lib/python/Zope2/Startup/run.py", line
> 21, in run
> starter.prepare()
> File "/home/jagarrido/Zope/DMR/lib/python/Zope2/Startup/__init__.py",
> line 98, in prepare
> self.startZope()
> File "/home/jagarrido/Zope/DMR/lib/python/Zope2/Startup/__init__.py",
> line 257, in startZope
> Zope2.startup()
> File "/home/jagarrido/Zope/DMR/lib/python/Zope2/__init__.py", line 47,
> in startup
> _startup()
> File "/home/jagarrido/Zope/DMR/lib/python/Zope2/App/startup.py", line
> 64, in startup
> DB = ZODB.DB(storage)
> File "/home/jagarrido/Zope/DMR/lib/python/ZODB/DB.py", line 239, in
> __init__
> storage.load(z64,'')
> File "/home/jagarrido/Zope/DMR/lib/python/DCOracleStorage/Full.py", line
> 250, in load
> s, c = self._call('load', (z_oid, version), 'pickle')
> File "/home/jagarrido/Zope/DMR/lib/python/DCOracleStorage/Full.py", line
> 201, in _call
> return apply(getattr(self, name), args+(c,))
> File "/home/jagarrido/Zope/DMR/lib/python/DCOracle2/DCOracle2.py", line
> 1492, in __call__
> cursor.execute(sql,__plist=args)
> File "/home/jagarrido/Zope/DMR/lib/python/DCOracle2/DCOracle2.py", line
> 973, in execute
> result = self._cursor.execute()
> dco2.DatabaseError: (24370, 'ORA-24370: illegal piecewise operation
> attempted')
>
>
> I see the Oracle error and says me:
> ORA-24370: illegal piecewise operation attempted
> Cause: Data of a certain datatype that does not support piecewise
> operation is being sent or fetched in pieces.
> Action: Always set the piece value to OCI_ONE_PIECE for datatypes that
> does not support piecewise operation.
>
> I see in a comment from Mathew:
> This one looks like the stored procedure is trying to
> return two LONG columns (which is not supported right now). Without
> tracing it I can't say for sure what the illegal piecewise operation it
> was trying to do, but it is LONG related, for sure.
> The unique LONG is Z_PICKLE in ZODB_PICKLE table.
>
> suggestions to resolve?
>
> Thanks for all
>
>
>
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB [at] zope
> http://mail.zope.org/mailman/listinfo/zope-db



--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: info [at] zopyx - Phone +49 - 7071 - 793376
E-Publishing, Python, Zope & Plone development, Consulting

Zope db RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.