on 05-21-2013 8:33 PM
Hi,
I'm getting the following error when trying to create a webi report:
"ODBC Driver Manager
The specified DSN contains an architecture mismatch between the Driver and Application
IES 10901"
The steps followed are:
1. I've converted the eFashion universe from unv to unx
2. created a unx connection to MS Access 2010 ==> ODBC
3. created a Data Foundation table, select two tables, connect them with the ID, select primary key, and check integrity
4. create a semantic layer
5. check integrity
6. published the connection
7. change the connection of the Data Foundation to the published one
8. check integrity
9. publish the semantic layer
10. enter Platform BI
11. create a webi with the universe created in the previous steps
12. create a query and refresh it.
The Error arose. (see picture)
We have Bo 4.0
ODBC 64 bit (deleted it and created it again)
Any idea what i'm missing?
Thanks!
You do not have a 64bit driver or DSN on BI4 server with the samename as in client machine.
install the drivers, create a dsn, it will work.
Thanks,
Avinash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks all for your responses.
I read the links, but I can't use the 32 bits ODBC because the machine runs on 64 bit.
I'm using 64 bit both in the server and in the client, and same driver, same ODBC, same name.
I have other eFashion universes pointed to the database taht are working ok.
Maybe it's a universe problem? what could it be happening?
please read the links again . there are 2 places where you can maintain DSN, even on a 64 bit platform.
I'd recommending checking this article :
Note 1803970 - Errors: IES 10901, WIS 10901 and "The specified DSN contains an architecture mismatch between the Driver and Application" if generating Web Intelligence report in SAP BusinessObjects BI Platform 4.0
Regards,
H
Hi Florencia
the link is http://service.sap.com/sap/support/notes/1803970 you need a S user account
Resolution
Note 1: In a Microsoft Windows Server 2008
environment the following rules are applicable:
Note 2 from MSDN: To manage a data source that connects to a
32-bit driver under 64-bit platform, use c:\windows\sysWOW64\odbcad32.exe. To
manage a data source that connects to a 64-bit driver, use
c:\windows\system32\odbcad32.exe. If you use the 64-bit odbcad32.exe to
configure or remove a DSN that connects to a 32-bit driver you will receive this
message.
On the server it uses 64 bit ODBC DSN format so you should create 64 bit ODBC with the same name as your local 32 bit ODBC.
If client and server running on same machine make sure same ODBC exists in 32 bit and 64 bit drivers.
-- Gopal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
We're using a relational connection with OLAP structure (star): (eFashion universe)
The steps followed were:
1. Database relational oracle.
2. Did a relational connection
3. Used an STAR scheme as a un.
Can i visualize this in explorer?
Does it work this way? or do we have to use an relational scheme?
Try creating another ODBC System DSN with 64 bit driver on the BI Server with the same name used for 32bit driver
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I think that is the issue then . You are using 64 bit trying to connect 32 bit.
Below link might help you.
http://msdn.microsoft.com/en-us/library/ms712362(v=vs.85).aspx
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.