connect to the Oracle error

toop · **Posted:** Mon Nov 02, 2009 1:34 pm

Hello everyone, I 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 button "test connection"。
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)

encoding of the database:Oracle 10g for Simplified Chinese Edition(SIMPLIFIED CHINESE_CHINA.ZHS16GBK)

Help me pls! Thanks!

Jiten · **Joined:** Mon Sep 14, 2009 12:42 pm **Posts:** 8

Hi toop,

Try and check this. May be it will help you.

Go in your server folder like:
server/bin/wizard/__init__.pyo , in def execute_cr(), line nubmer 135.

if its
arch = etree.tostring(doc)

Than change it with
arch = etree.tostirng(doc, encoding='utf-8')

Try and check that it will work or not...!!!

Thanks

Jiten · **Joined:** Mon Sep 14, 2009 12:42 pm **Posts:** 8

Hi toop,

I think this error is solved in stable server-5.0,
Are you using trunk version of server...??
If yes than,
Please try with the stable server-5.0..
i think u dont get this type of error in that.

Thanks.