Mstr Tutorial project in 3-tier

[teccum]

Hello,

I configured the mstr I-Server and then tested it by moving the Mstr Tutorial project into 3 tier by moving it to I-Server. I was able to access the project from another desktop but when I tried to execute the report I get a ODBC error. I am wondering where I am going wrong.

could anyone guide me on this.

The SQL error which I am getting is given below.

***************************
Status: Execution failed

Error: SQL Generation Complete
QueryEngine encountered error: Connect failed. Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. [IM002:0: on HDBC] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error in Process method of Component: QueryEngineServer, Project 0, Job 226, Error Code= -2147212544.

Starting Time: 19:53:45

*************************

I am in MSTR 7.5.3 and configured the metadata to SQL server. So my I-server is point to SQL server MD. I have defined the SQL Server DSN in my computer and in the I-server computer and i have the Mstr tutorial DSN for the MS Access database specified in my computer but not the I-Server.

Should I copy the MS Access Metadata of Mstr Tutorial project to a SQL server database and use that as the metadata database? Is it because of this?

Is there any particular that I should take care of in the database instance connection. My project is pointing to the MS Access Mstr Tutorial Data

Any ideas?

Advance thanks for all help.



teccum.

 

[mstrNate]

Try creating and specifying the Tutorial Warehouse DSN on the I-Server machine. I'm pretty sure you need to have the DSNs for all your projects that the I-Server will access on the I-server itself.

Nate

 

[teccum]

MstrNate,

Thanks for your reply.

I tried creating the DSN which is Microstrategy_Tutorial_Data (MS Access database DSN for Mstr tutorial project) in the Server

But since the Server machine has only the I-Server and Web-Server installed and there is no other microstrategy products, there is no path like

C:\Program files\Microstrategy\Tutorial Reporting\Tutorial_Data_7200.mdb

defined for the Microstrategy Tutorial Project at the I - Server. Then I tried mapping to my Desktop computer where Mstr Desktop is installed and configured the DSN with the same name and paramaters with the path as

Mycomputer\Z:\Program files\Microstrategy\Tutorial Reporting\Tutorial_Data_7200.mdb.

but I am getting the following SQL error when I run the report.

*********************

Report: Employee Headcount by Region

Job: 71

Status: Execution failed

Error: SQL Generation Complete
QueryEngine encountered error: Connect failed. Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. [S1009:-1023: on HDBC] [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. [IM006:0: on HDBC] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
Error in Process method of Component: QueryEngineServer, Project 0, Job 71, Error Code= -2147212544.

Starting Time: 12:45:49

*********************************

So, now, since it is a access database datawarehouse, I created the folders with the same path in the I-Server and then copied the Tutorial_Data_7200.mdb MS Access file into the location and the report ran successfully.

So you are right, I-Server requires all DSN to be defined at the I-Server, but in this case, since the database is a file rather than an RDBMS, I think it also requires the file to be present in the server and at the specified path.

Kindly correct me if I am wrong.

Onceagain thanks for your reply.

Teccum

 

[mstrNate]

Hi Teccum,

Glad you got it working. I'm not sure if you meant to have this part in the front of your DSN, the "Mycomputer\" in front of the mapped drive letter, Z:, but if you did, that might have been the problem.

If you're still curious, I would try it like so:

Z:\Program files\Microstrategy\TutorialReporting\Tutorial_Data_7200.mdb

The database doesn't need to be on the I-Server, although the I-server needs to be able to see the machine the database is on. For instance, we run Oracle in our shop, and the database is on a Unix box while we run the I-server on a NT 4.old box.

Have a good day!

Nate

 

[teccum]

Hi Nate,

Thanks for the reply onceagain.

I am sorry on mentioning as "Mycomputer". Actually it is my workstation where Mstr Desktop is installed and where the Mstr Tutorial project metadata and the tutorial warehouse is available. I created the DSN in the I-Server (which is a different machine) by mapping to my workstation and definining the DSN for the MS Access database in the I-Server machine as

Z:\Program Files\Microstrategy\Tutorial Reporting\Tutorial_Data_7200.mdb

But still I am getting this SQL error. I also checking whether any access privileges are not given for all the folders in my workstation which the server DSN is accessing.

Thanks onceagain

teccum