SSIS 2012 Attunity Oracle connector problem
-
I am trying to deploy my SSIS package from my Windows 7 64-bit development machine to a Windows Server 2008 R2 server. The package now includes a Attunity Oracle connection that works fine on the dev box. Both the dev box and the server have the same 32-bit and 64-bit Oracle clients installed. I have deployed and run the package on the server successfully before I added the Oracle connection.
Now when I try to deploy I get a fail with the message:
Failed to deploy project. For more information, query the operation_messages view for the operation identifier '10194'. (Microsoft SQL Server, Error: 27203)
When I query the view I get:
Failed to deploy the project. Fix the problems and try again later.:Unable to create the type with the name 'MSORA'.
Any idea what the problem might be?
Thank you!
-
Just to state the obvious, but have you deployed the Attunity connectors on the Win 2008 box?
We have these working in our environment but I do remember it being a bit fiddly. For example, BIDS is a 32-bit application, so when running in interactive mode, you're running the 32-bit version of Attunity, but if you've deployed to a live server and are running from an Agent job (and haven't clicked the 32-bit runtime checkbox) then it will be looking for the 64-bit version.
There is also a prerequisite as I remember:
Microsoft Visual C++ 2008 SP1 Redistributable Package (x64)
http://www.microsoft.com/en-us/download/details.aspx?id=2092
-
You got it Grasshopper! I guess I thought those bits would be wrapped up in the SSIS package. Once I installed them on the server I could deploy.
Now however, I see that the Attunity connector requires SQL Enterprise edition! I have developers on my dev box so it worked. The server is standard edition so does not work. Ugh!!!
Thanks for your help!
Jonathan
-
jonathan.matt (7/1/2014)
Now however, I see that the Attunity connector requires SQL Enterprise edition! I have developers on my dev box so it worked. The server is standard edition so does not work. Ugh!!!I ran into the same thing. Frustrating
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Yes and it is not made clear on the Attunity site. It may be buried somewhere but I don't see it.
-
Thats very strange, I have an Enterprise Edition on a 64 bit Windows 2012 Server Standard Edition, and I get the following error:
Failed to deploy project. For more information, query the operation_messages view for the operation identifier '80
-
Did you figure out how to get it to work?
-
I had a similar error:
Failed to deploy project. For more information, query the operation_messages view for the operation identifier '192473'So I ran the following SQL:
SELECT [message]FROM [SSISDB].[internal].[operation_messages]where [operation_id] = 192473Which returned:
Failed to deploy the project. Fix the problems and try again later.:Unable to create the type with the name 'MSORA'.Installing the Attunity drivers via the MSI corrected this.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply