I can connect to the Oracle,but...

toop · **Posted:** Tue Jun 09, 2009 5:26 am

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!

asb · **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.

toop · **Posted:** Thu Jun 11, 2009 7:37 am

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！

asb · **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.

toop · **Posted:** Thu Jun 11, 2009 5:02 pm

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!

toop · **Posted:** Fri Jun 12, 2009 4:08 pm

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 !~

asb · **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.

gegard · **Posted:** Fri Jun 12, 2009 7:41 pm

[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.

toop · **Posted:** Sat Jun 13, 2009 3:14 am

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)

toop · **Posted:** Tue Jul 14, 2009 4:49 am

Help me pls！Thanks

asb · **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.

toop · **Posted:** Tue Jul 14, 2009 9:53 am

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 .

asb · **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.

toop · **Posted:** Tue Jul 21, 2009 6:20 am

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

asb · **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)