Произошла следующая ошибка недопустимый или не поддерживаемый синтаксис запроса sql

Hi, I sucessfully have installed SP3 using group policy, on Windows 2003 SP1 to Windows XP SP1.

When I created the group policy this error was recored in the Application log on the server :

(CSV File)

1/7/2008,5:08:16 PM,Software Installation,Error,None,107,N/A,SERVER01,»Software Installation was unable to read the MSI file server01.contoso.comServicePacki386updateupdate.msi.  The following error was encountered: SQL query syntax invalid or unsupported.

However the deploy was recored as sucessfull (information system event: 5:35:46 PM Windows XP Service Pack 3 was installed (Service Pack 1 was previously installed).) 

The XP computer was restarted 5:35:47 PM (the ‘reason’ could be clearer in the event log) infomation:

The process msiexec.exe has initiated the restart of DESKTOPSP3 for the following reason: No title for this reason could be found
 Minor Reason: 0x2
 Shutdown Type: reboot
 Comment: The Windows Installer initiated a system restart to complete or continue the configuration of ‘Windows XP Service Pack 3 (1033)’.

The only system errors recorded on the XP computer are:

1/7/2008,5:36:50 PM,DCOM,Error,None,10016,NT AUTHORITYSYSTEM,DESKTOPSP3,The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID
{DCBCA92E-7DBE-4EDA-8B7B-3AAEA4DD412B}

1/7/2008,5:37:46 PM,Service Control Manager,Error,None,7023,N/A,DESKTOPSP3,The Portable Media Serial Number service terminated with the following error:
The specified module could not be found.

1/7/2008,5:38:35 PM,DCOM,Error,None,10016,NT AUTHORITYSYSTEM,DESKTOPSP3,The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID
{DCBCA92E-7DBE-4EDA-8B7B-3AAEA4DD412B}

The DCOM errors repeat every hour, 2 errors, less then 1 minute between them.

Three following warning events are in the application log:

1/7/2008,5:34:11 PM,WinMgmt,Warning,None,63,NT AUTHORITYSYSTEM,DESKTOPSP3,»A provider, HiPerfCooker_v1, has been registered in the WMI namespace, RootWMI, to use the LocalSystem account.  This account is privileged and the provider may cause a security violation if it does not correctly impersonate user requests.»

1/7/2008,5:37:46 PM,WinMgmt,Warning,None,5603,NT AUTHORITYSYSTEM,DESKTOPSP3,»A provider, Rsop Planning Mode Provider, has been registered in the WMI namespace, rootRSOP, but did not specify the HostingModel property.  This provider will be run using the LocalSystem account.  This account is privileged and the provider may cause a security violation if it does not correctly impersonate user requests.  Ensure that provider has been reviewed for security behavior and update the HostingModel property of the provider registration to an account with the least privileges possible for the required functionality.»

1/7/2008,5:37:46 PM,WinMgmt,Warning,None,5603,NT AUTHORITYSYSTEM,DESKTOPSP3,»A provider, Rsop Planning Mode Provider, has been registered in the WMI namespace, rootRSOP, but did not specify the HostingModel property.  This provider will be run using the LocalSystem account.  This account is privileged and the provider may cause a security violation if it does not correctly impersonate user requests.  Ensure that provider has been reviewed for security behavior and update the HostingModel property of the provider registration to an account with the least privileges possible for the required functionality.»

If you need any further information let me know.

Hi, I sucessfully have installed SP3 using group policy, on Windows 2003 SP1 to Windows XP SP1.

When I created the group policy this error was recored in the Application log on the server :

(CSV File)

1/7/2008,5:08:16 PM,Software Installation,Error,None,107,N/A,SERVER01,»Software Installation was unable to read the MSI file server01.contoso.comServicePacki386updateupdate.msi.  The following error was encountered: SQL query syntax invalid or unsupported.

However the deploy was recored as sucessfull (information system event: 5:35:46 PM Windows XP Service Pack 3 was installed (Service Pack 1 was previously installed).) 

The XP computer was restarted 5:35:47 PM (the ‘reason’ could be clearer in the event log) infomation:

The process msiexec.exe has initiated the restart of DESKTOPSP3 for the following reason: No title for this reason could be found
 Minor Reason: 0x2
 Shutdown Type: reboot
 Comment: The Windows Installer initiated a system restart to complete or continue the configuration of ‘Windows XP Service Pack 3 (1033)’.

The only system errors recorded on the XP computer are:

1/7/2008,5:36:50 PM,DCOM,Error,None,10016,NT AUTHORITYSYSTEM,DESKTOPSP3,The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID
{DCBCA92E-7DBE-4EDA-8B7B-3AAEA4DD412B}

1/7/2008,5:37:46 PM,Service Control Manager,Error,None,7023,N/A,DESKTOPSP3,The Portable Media Serial Number service terminated with the following error:
The specified module could not be found.

1/7/2008,5:38:35 PM,DCOM,Error,None,10016,NT AUTHORITYSYSTEM,DESKTOPSP3,The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID
{DCBCA92E-7DBE-4EDA-8B7B-3AAEA4DD412B}

The DCOM errors repeat every hour, 2 errors, less then 1 minute between them.

Three following warning events are in the application log:

1/7/2008,5:34:11 PM,WinMgmt,Warning,None,63,NT AUTHORITYSYSTEM,DESKTOPSP3,»A provider, HiPerfCooker_v1, has been registered in the WMI namespace, RootWMI, to use the LocalSystem account.  This account is privileged and the provider may cause a security violation if it does not correctly impersonate user requests.»

1/7/2008,5:37:46 PM,WinMgmt,Warning,None,5603,NT AUTHORITYSYSTEM,DESKTOPSP3,»A provider, Rsop Planning Mode Provider, has been registered in the WMI namespace, rootRSOP, but did not specify the HostingModel property.  This provider will be run using the LocalSystem account.  This account is privileged and the provider may cause a security violation if it does not correctly impersonate user requests.  Ensure that provider has been reviewed for security behavior and update the HostingModel property of the provider registration to an account with the least privileges possible for the required functionality.»

1/7/2008,5:37:46 PM,WinMgmt,Warning,None,5603,NT AUTHORITYSYSTEM,DESKTOPSP3,»A provider, Rsop Planning Mode Provider, has been registered in the WMI namespace, rootRSOP, but did not specify the HostingModel property.  This provider will be run using the LocalSystem account.  This account is privileged and the provider may cause a security violation if it does not correctly impersonate user requests.  Ensure that provider has been reviewed for security behavior and update the HostingModel property of the provider registration to an account with the least privileges possible for the required functionality.»

If you need any further information let me know.

count = (int)database.ExecuteScalar("SELECT COUNT(*) FROM Shortcut");
....
database.Execute("DELETE FROM Shortcut WHERE `Shortcut`.`Target` LIKE '%.chm'");
Console.WriteLine("chm deleted");

2 ответа