I am not sure what is causing this ERROR.... URGENT, PLEASE CHECK

[UWTechie]

I just set up an experimental Cognos server, so that we can do some web based tests. Yesterday I set up the ODBC connection with our Oracle server, which was troublesome because I was given Oracle 8.1.6 Client, whereas the office used to use SQL*net 2.3 and an Oracle 7.3 driver.


Eventually I got it to connect , then I used architect to build a package for transformer.


When I went to transformer I set up the dimensions and measures as I always do, but I keep on getting the same error whenever I try to generate categories or create a cube.


The error is as follows:


[TR0109] Transformer couldn't read the data source.


The details:
DMS-E-GENERAL, A general exception has occurred during operation 'asynchronous' open.


[Oracle][ODBC][Ora]ORA-01453: SET TRANSACTION must be first statement of transaction.



Not sure what this means, since I have never seen it before. I know that the two server's are now hooked up because I tested the Oracle database with an MS Acces query, and got the desired results, so I figure that I need to change the configuration of something, but not sure what I need to change. Or where it is...

 

[MikeJones]

Set Transaction is an ORacle command that is used to set things like the rollback segment that will be used for the following transaction. It must be the first command as the error message states so it looks like a syntax error.

Have you changed this code of late??

HTH,

Mike,