iT Synergy Blogs

Growing Innovation - Soluciones a problemas reales

Copyright © 2024 · iT Synergy·

The AcquireConnection method call to the connection manager “ExcelConnection” failed with error code 0xC00F9304
The AcquireConnection method call to the connection manager “ExcelConnection” failed with error code 0xC00F9304 avatar

By Leave a Comment

 

Problema

Dentro de un paquete de SQL Server Integration Server, tengo una conexión a un archivo excel, el problema esta que al tratar de ejecutar el paquete me genera el siguiente error:

Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "ExcelConnection" failed with error code 0xC00F9304.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.

Solución

Cambiar la propiedad del proyecto ETL,

Run 64BitRuntime = false

Vida Familiar
Vida Familiar avatar

By Leave a Comment

Quiero compartir un articulo muy interesante que lei en la revista compensar acerca de la familia, su importancia y una frase bastante interesante …

“Las empresas que promueven los valores familiares tienen mejor productividad porque reciben a cambio un mayor compromiso laboral de sus colaboradores y sus familias”.

El articulo se puede leer en la siguiente dirección: http://www.compensar.com/revistacompensar/revista62/index.aspx

Es un poco demorado en abrir, pero finalmente se logra 🙂

BAM Errors Could not load file or assembly ‘Microsoft.BizTalk.Bam.Portal’
BAM Errors Could not load file or assembly ‘Microsoft.BizTalk.Bam.Portal’ avatar

By Leave a Comment

BAM Installation Notes.

I want to public some errors that I get when I made the configuration of the feature BAM with BizTalk 2010.

  • BAM ERROR – Could not load file or assembly ‘Microsoft.BizTalk.Bam.Portal’ or one of its dependencies. Strong name signature could not be verified.  The assembly may have been tampered with, or it was delay signed but not fully signed with the correct private key. (Exception from HRESULT: 0x80131045)

In the event viewer show this

Event code: 3008

Event message: A configuration error has occurred.

Event time: 12/07/2011 01:19:55 p.m.

Event time (UTC): 12/07/2011 06:19:55 p.m.

Event ID: 7e81636267fe4bb58d4dc308137f315e

Event sequence: 1

Event occurrence: 1

Event detail code: 0

Exception message: Could not load file or assembly ‘Microsoft.BizTalk.Bam.Portal, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35’ or one of its dependencies. Strong name signature could not be verified.  The assembly may have been tampered with, or it was delay signed but not fully signed with the correct private key. (Exception from HRESULT: 0x80131045)

 

Solution: After hours of try to solve this,we figured it out, the copy of our BizTalk 2010 was corrupted so we opted to copy this ‘Microsoft.BizTalk.Bam.Portal.dll from other installation with the BAM portal working with the same version, we copy and it work fine.  You can also get a fresh copy of BizTalk Server 2010 and reinstall or repair BizTalk BAM.

 

  • BAM ERROR USER RIGHTS Then the problem was the permissions for the user’s, apparently  BAM  didn’t assign the right permissions to the user BAM management, so I had to gave to the user the right permission, in a command console I ran this commands.

With bm.exe I granted the permissions, replace domain name of the view and server name.

  • bm.exe add-account -Accountname:domain\user – view:ExcALL -Server:Srvtest
  • bm.exe add-account -Accountname:domain\user – view:ExcByApplication -Server: Srvtest
  • bm.exe add-account -Accountname:domain\user – view:ItineraryView -Server: Srvtest