Information Design Tool - Errors with Multiple Datasources

[Former Member]

Hello everybody,

I am looking for a solution that is caused by Information Design Tool (IDT). After creating relational database connection within a project, and publishing them in the repository an error occurs. If I create a new data foundation for multiple data sources and select the published connections an exception is thrown. If I use the data foundation as a single source both connections working. They dont work on a multisource enabled connection

The message is: Error returned by host

If I select the connection with the error and try manually test than the following error description will be displayed

Data Federator Driver Server Connector 'MSSQLSERVER' The database has reported an Exception: MicrosoftODBC Driver Manager Data source name not found and no default driver specified (SQLState: IM002, Vendor code: 0)

What is the reason for the problem? I use the IDT client version 14.0.0.v20110205-0760.

I have created System DSN and they work. If I look up the connection details (*.cnx) I can see table content. I am just not able to use them for a data foundation.

Best regards,

Thom

[Henry_Banks · Accepted solution]

Hi,

In BI 4.0, Multi Source universes are processed by the Data Federator Query Server engine, which is kind of Connection Server contained in the APS service. (it is called Data Federator Service)

This is "server-side processing" on the 64-bit BIPlatform. (which isn't used during a single-source workflow)

So you will need to do 2 things :

1) Create DataSource create a 64-bit version of the DSN on the BO server, by using this tool : C:\Windows\System32\odbcad32.exe

2) Add the Driver (assuming it's JDBC driver you are using) Copy/Paste the .jar file to these 2 locations:

..\dataAccess\connectionServer\jdbc\drivers\jdbc

..\dataAccess\connectionServer\jdbc\drivers\datafederator

You should also verify that the CLASSPATH is correct in the datafederator.sbo file

Further troubleshooting of MultiSource should be done using the Data Federator Admin Guide .

Regards,

H

p.s.

This kind of information is held in this Data Access guide

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_data_acs_en.pdf

Also, Information Designer Tool guide: http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_info_design_tool_en.pdf

Data Federator Admin Tool guide: http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_dfat_guide_en.pdf

[former_member203645 · Accepted solution]

Can please provide me the steps for Sybase IQ ODBC.

My universe is also Multi-source universe. I face the same issue.

Error:

[Data Federator Driver] [Server] [Connector 'ID002_1'] The database has reported an Exception: [Sybase][ODBC Driver][SQL Anywhere]Connection error: Insufficient system resources - failed to allocate a SYSV semaphore (SQLState: 08001, Vendor code: -832)

[Henry_Banks · Accepted solution]

Steps for what?    that error messge is widely searcheable 'Insufficient system resources - failed to allocate a SYSV semaphore'  - try google

Please open a new thread.   You might also want to ask the db vendor over here: http://www.sybase.com/developer/library/sql-anywhere-techcorner

[Former Member]

Hi Thom,

It looks that this error is coming due to ODBC connections settings or due to Data base issue. Could you please once check the below link which describe the reason of the error:

Error Data source not found and no default driver specified

Description :

(DM) The data source name specified in the argument ServerName was not found in the system information, nor was there a default driver specification.

http://msdn.microsoft.com/en-us/library/windows/desktop/ms711810%28v=vs.85%29.aspx

Could you please cross verify your ODBC connection parameters and comparability of it to the BO 4.0