.NET Questions and Solutions

Symptoms
An INSERT, UPDATE, or DELETE query that operates on a table that is referenced by an indexed view may encounter a floating point exception during optimization. The batch and transaction is aborted, and you receive the following error message:

Server: Msg 3628, Level 16, State 1, Line 1
A floating point exception occurred in the user process. Current transaction is canceled.
Resolution
Service pack informationTo resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
290211?(http://support.microsoft.com/kb/290211/) How to obtain the latest SQL Server 2000 service pack
Hotfix informationThe English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

DateTimeVersionSizeFile name——————————————————————-31-May-200317:452000.80.818.078,400Console.exe25-Jun-200300:012000.80.818.033,340Dbmslpcn.dll25-Apr-200301:12786,432Distmdl.ldf25-Apr-200301:122,359,296Distmdl.mdf30-Jan-200300:55180Drop_repl_hotfix.sql12-Sep-200302:262000.80.859.01,905,216Dtspkg.dll26-Aug-200319:162000.80.854.0528,960Dtspump.dll23-Jun-200321:402000.80.837.01,557,052Dtsui.dll23-Jun-200321:402000.80.837.0639,552Dtswiz.dll24-Apr-200301:51747,927Instdist.sql03-May-200300:561,581Inst_repl_hotfix.sql08-Feb-200305:402000.80.765.090,692Msgprox.dll01-Apr-200301:071,873Odsole.sql05-Apr-200300:462000.80.800.062,024Odsole70.dll07-May-200319:412000.80.819.025,144Opends60.dll02-Apr-200320:482000.80.796.057,904Osql.exe02-Apr-200322:152000.80.797.0279,104Pfutil80.dll04-Aug-200317:17550,780Procsyst.sql11-Sep-200323:3712,305Qfe469315.sql22-May-200321:5719,195Qfe469571.sql06-Sep-200300:361,090,932Replmerg.sql06-Sep-200306:182000.80.858.0221,768Replprov.dll06-Sep-200306:182000.80.858.0307,784Replrec.dll05-Sep-200323:001,087,150Replsys.sql13-Aug-200315:28986,603Repltran.sql29-Jul-200319:132000.80.819.0492,096Semobj.dll31-May-200317:272000.80.818.0172,032Semobj.rll05-Aug-200320:06127,884Sp3_serv_uni.sql01-Jun-200300:012000.80.818.04,215,360Sqldmo.dll07-Apr-200316:4425,172Sqldumper.exe19-Mar-200317:202000.80.789.028,672Sqlevn70.rll01-Jul-200323:182000.80.834.0180,736Sqlmap70.dll03-Sep-200301:562000.80.857.0188,992Sqlmmc.dll02-Sep-200322:032000.80.857.0479,232Sqlmmc.rll08-Feb-200305:402000.80.765.057,920Sqlrepss.dll23-Sep-200300:032000.80.863.07,614,545Sqlservr.exe25-Jul-200320:442000.80.845.0590,396Sqlsort.dll08-Feb-200305:402000.80.765.045,644Sqlvdi.dll25-Jun-200300:012000.80.818.033,340Ssmslpcn.dll01-Jun-200300:012000.80.818.082,492Ssnetlib.dll01-Jun-200300:012000.80.818.025,148Ssnmpn70.dll01-Jun-200300:012000.80.818.0158,240Svrnetcn.dll31-May-200317:592000.80.818.076,416Svrnetcn.exe30-Apr-200322:522000.80.816.045,132Ums.dll01-Jul-200323:192000.80.834.098,816Xpweb70.dll Note Because of file dependencies, the most recent hotfix or feature that contains these files may also contain additional files.

Symptoms
When you try to add the System Monitor Control (Sysmon.ocx) to a Windows Form, you receive the following error message:

Object Reference Error
Resolution
A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next Microsoft .NET Framework service pack that contains this hotfix.
To resolve this problem immediately, contact Microsoft Product Support Services to obtain the hotfix. For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:
http://support.microsoft.com/contactus/?ws=support(http://support.microsoft.com/contactus/?ws=support)NoteIn special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question. The English version of this fix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.

DateTimeVersionSizeFile name————————————————————————-17-Aug-200206:401.0.3705.3081,175,552System.data.dll17-Aug-200206:381.0.3705.3081,986,560System.windows.forms.dll

Symptoms
This article describes a hotfix rollup package that is available for the Microsoft Systems Management Server (SMS) 2003 Service Pack 3 (SP3) client. This update is in the form of an MSP package and can only be used to update existing SMS 2003 SP3 clients. The same update is also available as a Client.msi package inhotfix 941214. This hotfix provides an updated Client.msi for Systems Management Server 2003.
This hotfix rollup packages resolves the following problems.
Problem 1The Wmiprvse.exe process on client computers in the organization may generate high CPU usage while SMS 2003 SP3 Asset Advisor is performing hardware-inventory operations. Sometimes, the CPU usage may reach 100 percent. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
937882?(http://support.microsoft.com/kb/937882/) After you install SMS 2003 Service Pack 3, the Wmiprvse.exe process may generate high CPU usage on client computers during hardware-inventory operations
Problem 2When you schedule advertisements in Microsoft Systems Management Server 2003, you experience the following symptoms:Advertisements that have a recurring daily schedule that you create in British Summer Time (BST) run one hour too early after the time changes to Coordinated Universal Time (UTC).Advertisements that have a recurring daily schedule that you create in Coordinated Universal Time run one hour too late after the time changes to BST.For more information, click the following article number to view the article in the Microsoft Knowledge Base:
933870?(http://support.microsoft.com/kb/933870/) Advertisements that have a recurring schedule are off by one hour in SMS 2003 when the time changes between British Summer Time (BST) and Coordinated Universal Time
Problem 3The hardware inventory process may fail for SMS clients that are running on Windows Vista-based computers. Additionally, Task Manager may display that a Wmiprvse.exe process has more than 500 megabytes (MB) of private working set. This behavior usually occurs on a computer that has more than 100,000 events in the Security log.
The symptoms of hardware failure may vary. Typically, no inventory data is sent to the management point when this problem occurs. Additionally, one of the following messages is logged in the InventoryAgent.log file.
Log message 1
Inventory: Starting reporting task.
Reporting: (80041013) Reading of reports failed
Raising event:
[SMS_CodePage(437), SMS_LocaleID(1033)]
instance of CLIMSG_HINV_ERROR_REPORTFAILURE
…
CReportTask::CreateReportHeader: GetSingleWMIObject() – Failed to read the client version & type.
CReportTask::CreateReport: CreateReportHeaderFile()failed.
CReportTask::CreateReport() failed.
Reporting: Cycle failed: 80041013
Inventory: Reporting Task completed in 0.062 seconds
Inventory: Reporting task failed to completed successfully. No report will be sent.Log message 2
Unknown error encountered processing an instance of class CCM_System: 80041013
Collection: Failed to process mandatory data item for class: CCM_System. Cycle abandoned !!
Failed to process instances of CCM_System: 80004005
Collection: Cycle failed: 80004005Log message 3
Unknown error encountered processing an instance of class SMS_MIFGroup: 80041013Note This information is logged when some noncritical classes are not listed in the inventory data. The class that is listed in the log information may vary between clients or between instances of hardware inventory that are executed. The 80041013 error code represents a WMI Provider Load Failure (WBEM_E_PROVIDER_LOAD_FAILURE) error.
Resolution
Problem 4 Some processes have an access violation problem because the AssetAdvisor.dll module allocates insufficient memory. For example, the Wmiprvse.exe process may have this access violation problem.
Problem 5 After you upgrade to Microsoft SMS 2003 Service Pack 3, you run a report that is based on the v_Add_Remove_Programs view. However, the report stops responding, and the process uses 100 percent of the CPU resources. For example, reports such as the “Computers with specific software registered in Add Remove Programs” report stop responding, and the process uses 100 percent of the CPU resources.For more information, click the following article number to view the article in the Microsoft Knowledge Base:
939872?(http://support.microsoft.com/kb/939872/) Reports that use the v_Add_Remove_Programs view stop responding and cause high CPU use in SMS 2003 Service Pack 3
Problem 6 SMS 2003 should use data that is combined with the ProductID registry entry and the DigitalProductID registry entry to determine sale channel code. Earlier products do not support the DigitalProductID registry entry.
Problem 7Inventory counts are inaccurate in the License 1A report and in the License 1B report. Multiple components that have the same Microsoft product code (MPC) appear as a single product instead of as individual products.
Problem 8When Microsoft SQL Enterprise Manager and Books online are installed on the computer, they are incorrectly reported as SQL Server installations in the License Ledger report.
Problem 9The SMS_InstalledSoftware class incorrectly generates a software code for Windows operating systems by inserting some extra characters.