Creating a new OLEDB connection manager in BIDS SSIS project was giving below
error. Right click on Connection Manager and select "New OLE DB Connection" . In
the "Configure
OLE DB Connection Manager" window click on the "New.." button and you will see
below error:
========================================
TITLE: Microsoft Visual Studio
------------------------------
Creating an instance of the COM component with CLSID
{C8B522D0-5CF3-11CE-ADE5-00AA0044773D} from the IClassFactory failed due to the
following error: 8007007e.
------------------------------
BUTTONS:
OK
========================================
RESOLUTION
==============
Reinstalled MDAC components by running MDAC.inf file.
1. Go to the C:\Windows\Inf folder
2. Right-click the Mdac.inf file, and then click Install
3. Point to the Windows Installation CD when prompted
This reinstalled the MDAC components and then the to choose the OLE DB connector.
Thursday, August 6, 2009
Monday, August 3, 2009
Parser Error Message: Could not load file or assembly 'Microsoft.SharePoint, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or on
Parser Error Message: Could not load file or assembly 'Microsoft.SharePoint, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
Stack trace
getting error
'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!5/24/2007-15:57:03:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!5/24/2007-15:57:03:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!5/24/2007-15:57:03:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!5/24/2007-15:57:03:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!1!5/24/2007-15:57:03:: Unhandled exception: System.Configuration.ConfigurationErrorsException: Could not load file or assembly 'Microsoft.SharePoint, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. (c:\inetpub\wwwroot\web.config line 46) ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SharePoint, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.SharePoint, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'
at System.RuntimeTypeHandle._GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName)
at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)
at System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)
at System.Type.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase)
at System.Web.Compilation.BuildManager.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase)
at System.Web.Configuration.ConfigUtil.GetType(String typeName, String propertyName, ConfigurationElement configElement, XmlNode node, Boolean checkAptcaBit, Boolean ignoreCase)
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
--- End of inner exception stack trace ---
Cause:
=======================================================================
Still the References to the dll’s of SharePoint exists in the web.config file in c:\inetpub\wwwroot as well as the rssrvpolicy.config file and rsmgrpolicy.config file
So the error is getting thrown while browsing the reportserver and reports
Resolution:
=======================================================================
Manually Removed all the code references pointing to the sharepoint from web.config file of c:\inetpub\wwwroot, rssrvpolicy.config file and rsmgrpolicy.config file
And reset the iis.
Now browsed report server and reports its coming up fine without error.
or
rename the web.config file of c:\inetpub\wwwroot to something like web.config.bak
now restart the iis and try browsing the reportserver and reports
Stack trace
getting error
'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!5/24/2007-15:57:03:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!5/24/2007-15:57:03:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!5/24/2007-15:57:03:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!5/24/2007-15:57:03:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!1!5/24/2007-15:57:03:: Unhandled exception: System.Configuration.ConfigurationErrorsException: Could not load file or assembly 'Microsoft.SharePoint, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. (c:\inetpub\wwwroot\web.config line 46) ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SharePoint, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.SharePoint, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'
at System.RuntimeTypeHandle._GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName)
at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)
at System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)
at System.Type.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase)
at System.Web.Compilation.BuildManager.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase)
at System.Web.Configuration.ConfigUtil.GetType(String typeName, String propertyName, ConfigurationElement configElement, XmlNode node, Boolean checkAptcaBit, Boolean ignoreCase)
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
--- End of inner exception stack trace ---
Cause:
=======================================================================
Still the References to the dll’s of SharePoint exists in the web.config file in c:\inetpub\wwwroot as well as the rssrvpolicy.config file and rsmgrpolicy.config file
So the error is getting thrown while browsing the reportserver and reports
Resolution:
=======================================================================
Manually Removed all the code references pointing to the sharepoint from web.config file of c:\inetpub\wwwroot, rssrvpolicy.config file and rsmgrpolicy.config file
And reset the iis.
Now browsed report server and reports its coming up fine without error.
or
rename the web.config file of c:\inetpub\wwwroot to something like web.config.bak
now restart the iis and try browsing the reportserver and reports
ReportingServicesService!emailextension!4!04/19/2007-17:05:59:: Error sending email. System.Runtime.InteropServices.COMException (0x80040211): The mes
ReportingServicesService!dbpolling!21!04/19/2007-17:05:59:: NotificationPolling finished processing item 0ed42bc8-26ab-4454-819c-db894e68c973
ReportingServicesService!library!4!04/19/2007-17:05:59:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!4!04/19/2007-17:05:59:: Error sending email. System.Runtime.InteropServices.COMException (0x80040211): The message could not be sent to the SMTP server. The transport error code was 0x800ccc15. The server response was not available
A firewall was blocking traffic from the Report Server to the Exchange server. It blocks emails being sent from the server on port 25.
Add an exception for the ReportingServerService.exe Anti virus program
and now emails for data driven subscriptions of reports should fire
OR
CAUSE:
The configuration for the Email service was incorrect.
RESOLUTION:
change the SendEmail setting to 2 and removed the value for
SMTPServerPickupDirectory in the RSReportServer.config file.
ReportingServicesService!library!4!04/19/2007-17:05:59:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!4!04/19/2007-17:05:59:: Error sending email. System.Runtime.InteropServices.COMException (0x80040211): The message could not be sent to the SMTP server. The transport error code was 0x800ccc15. The server response was not available
A firewall was blocking traffic from the Report Server to the Exchange server. It blocks emails being sent from the server on port 25.
Add an exception for the ReportingServerService.exe Anti virus program
and now emails for data driven subscriptions of reports should fire
OR
CAUSE:
The configuration for the Email service was incorrect.
RESOLUTION:
change the SendEmail setting to 2 and removed the value for
SMTPServerPickupDirectory in the RSReportServer.config file.
Failed to map the path '/ReportServer/App_GlobalResources/' while Trrying to browse the Reporserver and reports.
problem lies in the permissions of the ASP.NET user account.
First step was to delete the ASPNET user account and then run the aspnet_regiis utility in the framework folder:
c:\WINNT\Microsoft.NET\framework\v2.0.50727\aspnet_regiis -i
This will re-register ASP.NET with IIS and re-create the ASPNET account.
Next you need to give permissions to the (nicely refreshed) ASPNET user account to access this folder with Modify permissions:
C:\Documents and Settings\All Users.WINNT\Application Data\Microsoft\Crypto\RSA\MachineKeys
A quick restart of IIS (quick-tip: simply type iisreset in a run dialog to restart your IIS)
OR
giving the ASP.NET user account permissions over the 'C:\Documents and Settings\All Users.WINNT\Application Data\Microsoft\Crypto\RSA\MachineKeys'
OR
click the Security Tab under the Properties of the C:\Documents and Settings\All Users\Application Data\Microsoft\Crypto\RSA and add the ASP.NET account with full control.
OR
In the folder --> C:\Documents and Settings\All Users\Application Data\Microsoft\Crypto\RSA\MachineKeys
... I found a key that was 0 KBytes,
simply deleted it (which is then recreated when accessing the website)
First step was to delete the ASPNET user account and then run the aspnet_regiis utility in the framework folder:
c:\WINNT\Microsoft.NET\framework\v2.0.50727\aspnet_regiis -i
This will re-register ASP.NET with IIS and re-create the ASPNET account.
Next you need to give permissions to the (nicely refreshed) ASPNET user account to access this folder with Modify permissions:
C:\Documents and Settings\All Users.WINNT\Application Data\Microsoft\Crypto\RSA\MachineKeys
A quick restart of IIS (quick-tip: simply type iisreset in a run dialog to restart your IIS)
OR
giving the ASP.NET user account permissions over the 'C:\Documents and Settings\All Users.WINNT\Application Data\Microsoft\Crypto\RSA\MachineKeys'
OR
click the Security Tab under the Properties of the C:\Documents and Settings\All Users\Application Data\Microsoft\Crypto\RSA and add the ASP.NET account with full control.
OR
In the folder --> C:\Documents and Settings\All Users\Application Data\Microsoft\Crypto\RSA\MachineKeys
... I found a key that was 0 KBytes,
simply deleted it (which is then recreated when accessing the website)
Wednesday, July 29, 2009
"Could not find file C:\Documents and Settings\username\Local Settings\Temp\xxxxxxx.dll"
Getting below error message when we try to create a Business Intelligence Project[SSIS]
"Could not find file C:\Documents and Settings\username\Local Settings\Temp\xxxxxxx.dll"
Issue seems to be an corruption with Dot Net framework dll.
SQL 2005 uses dotnet framework 2.0
SQL 2008 uses dotnet framework 3.5
Uninstalling and reinstalling the framework Should resolve the issue.
"Could not find file C:\Documents and Settings\username\Local Settings\Temp\xxxxxxx.dll"
Issue seems to be an corruption with Dot Net framework dll.
SQL 2005 uses dotnet framework 2.0
SQL 2008 uses dotnet framework 3.5
Uninstalling and reinstalling the framework Should resolve the issue.
Attempting to install is MS07-009, which corresponds to KB article 927779 and its failing with error.
Before making any changes to registry key do a backup of it.
1.Remove the MDAC Exception component keys from HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\ExceptionComponents.
2. Re-run the MDAC 2.81 installer (MDAC_TYP.EXE). When the installer runs you should see a few windows coming up showing it copying files.
http://www.microsoft.com/downloads/details.aspx?FamilyID=78CAC895-EFC2-4F8E-A9E0-3A1AFBD5922E&displaylang=en [mdac 2.8 sp1 download]
3. Apply the update again and if need be reboot the machine.
1.Remove the MDAC Exception component keys from HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\ExceptionComponents.
2. Re-run the MDAC 2.81 installer (MDAC_TYP.EXE). When the installer runs you should see a few windows coming up showing it copying files.
http://www.microsoft.com/downloads/details.aspx?FamilyID=78CAC895-EFC2-4F8E-A9E0-3A1AFBD5922E&displaylang=en [mdac 2.8 sp1 download]
3. Apply the update again and if need be reboot the machine.
Thursday, June 11, 2009
We can ping the IP address of the SQL Server but we can not connect to the SQL
Make sure File and Printer Sharing for Microsoft Networks is installed and is
checked.
Right-click on Network Places, select Properties. Right-click the network we
are using, select properties and make sure that “File and Printer Sharing for
Microsoft Networks” is installed and is checked.
checked.
Right-click on Network Places, select Properties. Right-click the network we
are using, select properties and make sure that “File and Printer Sharing for
Microsoft Networks” is installed and is checked.
Subscribe to:
Comments (Atom)