This forum is now just an archive. Use the new Q&A website
It is currently Thu Apr 24, 2014 8:43 pm

All times are UTC + 2 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 23 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: I can connect to the Oracle,but...
PostPosted: Tue Jun 09, 2009 5:26 am 
Offline

Joined: Sun Nov 09, 2008 2:58 am
Posts: 35
Location: Sichuan China
I edited the fact database Information to Oracle, and save the resoures,then Click the test connection button。but error:

An unknown error has been reported.

You do not have a valid Open ERP maintenance contract !If you are using Open ERP in production, it is highly suggested to subscribe
a maintenance program.

The Open ERP maintenance contract provides you a bugfix guarantee and an
automatic migration system so that we can fix your problems within a few
hours. If you had a maintenance contract, this error would have been sent
to the quality team of the Open ERP editor.

The maintenance program offers you:
* Automatic migrations on new versions,
* A bugfix guarantee,
* Monthly announces of potential bugs and their fixes,
* Security alerts by email and automatic migration,
* Access to the customer portal.

You can use the link bellow for more information. The detail of the error
is displayed on the second tab.

==========
Traceback (most recent call last):
File "netsvc.pyo", line 235, in dispatch
File "netsvc.pyo", line 74, in __call__
File "service\web_services.pyo", line 582, in execute
File "service\web_services.pyo", line 562, in _execute
File "wizard\__init__.pyo", line 178, in execute
File "wizard\__init__.pyo", line 135, in execute_cr
UnicodeDecodeError: 'ascii' codec can't decode byte 0xbc in position 87: ordinal not in range(128)

Hlp me! Pls! Thk!


Top
 Profile  
 
 Post subject:
PostPosted: Thu Jun 11, 2009 2:29 am 
Offline

Joined: Tue Aug 05, 2008 1:29 pm
Posts: 37
Hello,

Did you installed cx_oracle and configured it ?

Pls open your terminal start python. And do test for cx_oracle.

import cx_oracle
cx_Oracle.connect(user,password,sid)

Is this working for you. I guess no ...

If you are getting error like

>>import cx_oracle
Traceback (most recent call last):
File "", line 1, in ?
ImportError: ld.so.1: python: fatal: libclntsh.so.9.0: open failed: No such file or director

Add Oracle/Home to LD_LIBRARY_PATH and try importing and connecting to oracle from python. Hope it resolve the error.

_________________
Regards
----------------
asb


Top
 Profile  
 
 Post subject: hi asb:
PostPosted: Thu Jun 11, 2009 7:37 am 
Offline

Joined: Sun Nov 09, 2008 2:58 am
Posts: 35
Location: Sichuan China
asb wrote:
import cx_oracle
cx_Oracle.connect(user,password,sid)

It`s working!

and
asb wrote:

>>import cx_Oracle

no ImportError,It`s working!
error:
UnicodeDecodeError: 'ascii' codec can't decode byte 0xbc in position 87: ordinal not in range(128)
I want connection to (fact database)Oracle 10g for Simplified Chinese Edition,Which files need to edit ,I don`t know,Some files add ‘utf-8’already。Hlp me pls !Thk u!


Top
 Profile  
 
 Post subject:
PostPosted: Thu Jun 11, 2009 1:02 pm 
Offline

Joined: Tue Aug 05, 2008 1:29 pm
Posts: 37
You can find query.py in olap/cube folder. In that line 40 u will get encoding='utf-8'. You can remove that.

_________________
Regards
----------------
asb


Top
 Profile  
 
 Post subject:
PostPosted: Thu Jun 11, 2009 5:02 pm 
Offline

Joined: Sun Nov 09, 2008 2:58 am
Posts: 35
Location: Sichuan China
asb wrote:
You can find query.py in olap/cube folder. In that line 40 u will get encoding='utf-8'. You can remove that.


Hi asb,Thank you very much!


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jun 12, 2009 4:08 pm 
Offline

Joined: Sun Nov 09, 2008 2:58 am
Posts: 35
Location: Sichuan China
asb wrote:
You can find query.py in olap/cube folder. In that line 40 u will get encoding='utf-8'. You can remove that.


Hi,asb, I removed the " encoding='utf-8' "in query.py ,but error is same.
hlp me pls !Thk u !~


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jun 12, 2009 7:03 pm 
Offline

Joined: Tue Aug 05, 2008 1:29 pm
Posts: 37
Can i have more details abt the database u r using. Can u just show sample data, so that we can try here and get to the problem.

_________________
Regards
----------------
asb


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jun 12, 2009 7:41 pm 
Offline

Joined: Fri Apr 21, 2006 7:28 pm
Posts: 1349
Location: Cambridge, UK
[quote="toop"][size=18]
Why all the shouting? It's sure to mean that you're ignored by many of those who might have helped.

_________________
Regards, Geoff

Seath Solutions Ltd, Cambridge, UK


Top
 Profile  
 
 Post subject:
PostPosted: Sat Jun 13, 2009 3:14 am 
Offline

Joined: Sun Nov 09, 2008 2:58 am
Posts: 35
Location: Sichuan China
on the module named Business Intelligence,
Configuration--Fact Databases--Databases;
then Click the new button:

General information

Fact name: test
?Database name: orcl
Database type: Oracle (Oracle 10g for Simplified Chinese Edition
Connection parameters

Connection type: Port
?Database host: 192.168.0.1
?Database port: 1521
?Database login: testerp
?Database password: ****

then Click the test connection button。
error message:
Traceback (most recent call last):
File "netsvc.pyo", line 235, in dispatch
File "netsvc.pyo", line 74, in __call__
File "service\web_services.pyo", line 582, in execute
File "service\web_services.pyo", line 562, in _execute
File "wizard\__init__.pyo", line 178, in execute
File "wizard\__init__.pyo", line 135, in execute_cr
UnicodeDecodeError: 'ascii' codec can't decode byte 0xbc in position 87: ordinal not in range(128)


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jul 14, 2009 4:49 am 
Offline

Joined: Sun Nov 09, 2008 2:58 am
Posts: 35
Location: Sichuan China
Help me pls!Thanks


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jul 14, 2009 8:04 am 
Offline

Joined: Tue Aug 05, 2008 1:29 pm
Posts: 37
Can u please try this :

open python in terminal
>> import cx_Oracle
>> cx_Oracle.connect(user,password,host)

Where user,password and host is to be replaced by u r data.

Pls let us know is it success or failure.

_________________
Regards
----------------
asb


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jul 14, 2009 9:53 am 
Offline

Joined: Sun Nov 09, 2008 2:58 am
Posts: 35
Location: Sichuan China
asb wrote:
Can u please try this :

open python in terminal
>> import cx_Oracle
>> cx_Oracle.connect(user,password,host)

Where user,password and host is to be replaced by u r data.

Pls let us know is it success or failure.


It`s success .


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jul 20, 2009 6:28 am 
Offline

Joined: Tue Aug 05, 2008 1:29 pm
Posts: 37
Hello,

Pls. take update from launchpad on
olap (trunk-extra-addons)
bi specific web client (clinet-new-trunk)

We had made some minor changes. Hope it will solve your problem.

_________________
Regards
----------------
asb


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jul 21, 2009 6:20 am 
Offline

Joined: Sun Nov 09, 2008 2:58 am
Posts: 35
Location: Sichuan China
asb wrote:
Hello,

Pls. take update from launchpad on
olap (trunk-extra-addons)
bi specific web client (clinet-new-trunk)

We had made some minor changes. Hope it will solve your problem.


I updated it。But Application Error:

'utf8' codec can't decode byte 0xbc in position 87: unexpected code byte



Top
 Profile  
 
 Post subject:
PostPosted: Tue Jul 21, 2009 9:05 am 
Offline

Joined: Tue Aug 05, 2008 1:29 pm
Posts: 37
Hello

Can u give the details about
1. Which step are you performing when you get ths error.
2. Which error (traceback of server)

_________________
Regards
----------------
asb


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 23 posts ]  Go to page 1, 2  Next

All times are UTC + 2 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:

Protected by Anti-Spam ACP