Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Problem With SQL update #53

Open
jcknf opened this issue Sep 16, 2020 · 0 comments
Open

Problem With SQL update #53

jcknf opened this issue Sep 16, 2020 · 0 comments

Comments

@jcknf
Copy link

jcknf commented Sep 16, 2020

Hi, just installed, it seems to run fine but when trying to commit to sql server it fail with this :

Update-SQL : Error updating SQL with the following query: begin tran if exists (SELECT * FROM dbo.Clients WITH (updlock,serializable) WHERE Hostname='M200900256T') begin UPDATE dbo.Clients SET Operatingsystem='Microsoft Windows 10 Professionnel', Architecture='64-Bit', Build='18362.1.amd64fre.19h1_release.190318-1202', Manufacturer='VMware, Inc.', Model='VMware7,1', InstallDate='2019-12-13 10:02:43', OSUpdates='2020-09-16 12:02:09', LastLoggedOnUser='j.crottaz@xxx', ClientVersion='5.00.9012.1020', PSVersion='5.1', PSBuild='18362', Sitecode='xxx', Domain='xxx', MaxLogSize='4096', MaxLogHistory='1', CacheSize='10040', ClientCertificate='OK', ProvisioningMode='OK', DNS='OK', Drivers='OK', Updates='Unknown', PendingReboot='OK', LastBootTime='2020-09-16 14:41:18', OSDiskFreeSpace='21.97', Services='OK', AdminShare='OK', StateMessages='OK', WUAHandler='OK', WMI='OK', RefreshComplianceState='2020-09-16 14:43:26', HWInventory='2020-09-16 14:36:51', Version='0.8.2', ClientInstalled='2020-09-16 14:52:04', Timestamp='2020-09-16 14:52:04', SWMetering='OK', BITS='OK', PatchLevel='1082', ClientInstalledReason='Below minimum verison. Upgrade failed.' WHERE Hostname = 'M200900256T' end else begin INSERT INTO dbo.Clients (Hostname, Operatingsystem, Architecture, Build, Manufacturer, Model, InstallDate, OSUpdates, LastLoggedOnUser, ClientVersion, PSVersion, PSBuild, Sitecode, Domain, MaxLogSize, MaxLogHistory, CacheSize, ClientCertificate, ProvisioningMode, DNS, Drivers, Updates, PendingReboot, LastBootTime, OSDiskFreeSpace, Services, AdminShare, StateMessages, WUAHandler, WMI, RefreshComplianceState, HWInventory, Version, ClientInstalled, Timestamp, SWMetering, BITS, PatchLevel, ClientInstalledReason) VALUES ('M200900256T', 'Microsoft Windows 10 Professionnel', '64-Bit', '18362.1.amd64fre.19h1_release.190318-1202', 'VMware, Inc.', 'VMware7,1', '2019-12-13 10:02:43', '2020-09-16 12:02:09', 'j.crottaz@xxxx', '5.00.9012.1020', '5.1', '18362', 'MAS', 'mairie-massy.fr', '4096', '1', '10040', 'OK', 'OK', 'OK', 'OK', 'Unknown', 'OK', '2020-09-16 14:41:18', '21.97', 'OK', 'OK', 'OK', 'OK', 'OK', '2020-09-16 14:43:26', '2020-09-16 14:36:51', '0.8.2', '2020-09-16 14:52:04', '2020-09-16 14:52:04', 'OK', 'OK', '1082', 'Below minimum verison. Upgrade failed.') end commit tran. Error: Exception lors de l'appel de «Fill» avec «1» argument(s): «La conversion d'un type de données varchar en type de données smalldatetime a créé une valeur hors limites. L'instruction a été arrêtée. » Au caractère \\xxx\netlogon\Ccm\ConfigMgrClientHealth\ConfigMgrClientHealth.ps1:3502 : 9 Update-SQL -Log $log ~~~~~~~~~~~~~~~~~~~~ CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Update-SQL

also their is a typo on the word version -> verison

Regards

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant