June 24, 2016 at 3:32 pm
Hi All,
I am trying to help one of my BI Developers out and seem to be hitting a brick wall. We are trying to use Oracle 11g as a data source for a tabular model in SSAS 2012. Test Connection succeeds, even data preview shows records, SQL validates with no problem, then it fails when conducting the import. Here is what the error says.
OLE DB or ODBC error: ORA-12154: TNS:could not resolve the connect identifier specified. A connection could not be made to the data source with the DataSourceID of 'blah blah blah', Name of Oracle XXXXXXXX. The current operation was cancelled because another operation in the transaction failed.
I have obviously seen this error before and have resolved it, but this time it isn't related to the connection per se, because the connection test was successful and the preview of the data is working. Like I said, it only errors on the actual import.
After some reading we found that it was potentially related to a 32 v 64 bit conflict with the driver, and the solution from MSDN simply says to create identical DSNs with the same name, but we aren't defining these on her machine for development, we eventually have to deploy it to a server so, we are reluctant to define a DSN outside of the connection we create within the package itself, otherwise we don't know if it will be carried over to the prod server when we deploy. Even if we encounter the same issue when we deploy to prod, we will definitely need to tell our server admin how to address the failure and what exactly needs to be installed to rectify the conflict.
June 24, 2016 at 4:14 pm
Not 100% sure what the question is, but sometimes you have no choice but to create System DSNs to help facilitate the connection.
The 32 vs. 64-bit driver issue could also play a role here, similar to what happens with SSIS. Designers as usually 32-bit applications and will use the 32-bit version of the driver. When scheduled, it could then be looking for a 64-bit driver unless specifically forced not to. I cannot confirm this however, as I have not tested this thoroughly with Oracle and SSAS Tabular recently.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply