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.