NumberFormatException with Oracle data source in multisource universe

[Former Member]

Hello,

using an oracle data connection in a multisource universe gives the following error as soon as the query result includes decimal numbers. Using the same data connection with the same query result including decimal numbers works without problems in a single source universe. Here is the error message when using the multisource universe:

<com.businessobjects.dsl.commons.exception.NestedException: (Data Federator Driver) (Server) (Connector 'ORACLE11_CLIENT') ConnectionServer has reported an Exception: Localization information not found : java.lang.NumberFormatException>

The data federation service has a problem with the decimal numbers. In the data federation administration tool the query also shows up as failed.

Maybe it has to do something with the decimal format (1,5 or 1.5).

Anyone has an idea how to fix this? Is there any option in the data federation administration tool that will fix this issue?

Any help would be greatly appreciated!

Thanks in advance.

Matthias

[Former Member]

Hi Matthias.

We're experiencing the same problem but nobody has posted a solution yet. Did you manage to work it out?

Best regards,

Hinrik

[Former Member]

Hi Hinrik,

unfortunately I dont't have a real solution for this. I use a simple workaround: Round the decimal numbers to integer numbers in the oracle database view. Of course, this isn't the best solution but rounded integer numbers are ok for me in this report. For sure there are other cases where you don't want to deal with rounded numbers.

Regards,

Matthias