90
Hi All,
I have installed IDMF 2.0 (Intelligent Data Management Framework) tool on AX 2012 R3. After completion of post-installation tasks, I have scheduled production database analysis (snapshot analysis) tasks and this task throws "Package "InsIndexCaptureStats" failed error". Because of this error, I am not able to proceed further.
Any thoughts on this highly appreciated.
*This post is locked for comments
I have the same question (0)
We are using SQL Server 2012 and IDMF log showing me following:
Message: Package Error: "InsIndexCaptureStats" : The requested OLE DB provider SQLNCLI.1 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
"InsIndexCaptureStats" : Consider changing the PROVIDER in the connection string to SQLNCLI11 or visit www.microsoft.com/downloads to find and install support for SQLNCLI.1.
"InsIndexCaptureStats" : SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "ManagementDB" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
COM error object information is available. Source: "InsIndexCaptureStats" error code: 0xC0209303 Description: "Consider changing the PROVIDER in the connection string to SQLNCLI11 or visit www.microsoft.com/downloads to find and install support for SQLNCLI.1.
".
"InsIndexCaptureStats" : The requested OLE DB provider SQLNCLI.1 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
"InsIndexCaptureStats" : Consider changing the PROVIDER in the connection string to SQLNCLI11 or visit www.microsoft.com/downloads to find and install support for SQLNCLI.1.
"GETTIME" : Failed to acquire connection "ManagementDB". Connection may not be configured correctly or you may not have the right permissions on this connection.
"InsIndexCaptureStats" : The requested OLE DB provider SQLNCLI.1 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
"InsIndexCaptureStats" : Consider changing the PROVIDER in the connection string to SQLNCLI11 or visit www.microsoft.com/downloads to find and install support for SQLNCLI.1.
"Execute SQL Task 1" : Failed to acquire connection "ManagementDB". Connection may not be configured correctly or you may not have the right permissions on this connection.
"InsIndexCaptureStats" : The requested OLE DB provider SQLNCLI.1 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
"InsIndexCaptureStats" : Consider changing the PROVIDER in the connection string to SQLNCLI11 or visit www.microsoft.com/downloads to find and install support for SQLNCLI.1.
"Execute SQL Task 1" : Failed to acquire connection "ManagementDB". Connection may not be configured correctly or you may not have the right permissions on this connection.
Share
Report
All responses (
Answers (
