swaudit: Incorrect datetime value

Antworten
faspie
Beiträge: 1
Registriert: 06 Sep 2021, 22:20

swaudit: Incorrect datetime value

Beitrag von faspie »

Liebes Forum,
als neuer OPSI-Nutzer stehe ich vor einer Herausforderung: Schon auf meinem Testrechner lässt sich swaudit nicht installieren, es kommt zu einer Fehlermeldung:

Code: Alles auswählen

(206)     [5] [2021-09-06 21:57:48.738] [swaudit] message Running software audit...
(207)     [5] [2021-09-06 21:57:48.805] [swaudit] comment: detect if we run in opsi service mode
(208)     [5] [2021-09-06 21:57:48.812] [swaudit]       message collecting 64 Bit products ...
(209)     [5] [2021-09-06 21:57:48.823] [swaudit]       message collecting 64 Bit product details ...
(210)     [5] [2021-09-06 21:57:50.581] [swaudit]     message collecting 32 Bit product details ...
(211)     [5] [2021-09-06 21:57:52.689] [swaudit]     message collecting os details ...
(212)     [5] [2021-09-06 21:57:52.754] [swaudit]         message collecting hotfixes ...
(213)     [5] [2021-09-06 21:57:55.409] [swaudit]   comment: convert object list to json array ..
(214)     [5] [2021-09-06 21:57:55.432] [swaudit]   message writing results back to service ...
(215)     [5] [2021-09-06 21:57:55.444] [swaudit]   comment: mask single quotes by double single quotes before sending ....
(216)     [5] [2021-09-06 21:57:55.458] [swaudit]     Execution of: opsiservicecall_auditSoftwareOnClient_setObsolete
(217)     [5] [2021-09-06 21:57:55.458] [swaudit]     
(218)     [5] [2021-09-06 21:57:55.489] [swaudit]     Execution of: opsiservicecall_auditSoftware_createObjects
(219)     [5] [2021-09-06 21:57:55.489] [swaudit]     
(220)     [5] [2021-09-06 21:57:55.807] [swaudit]     Execution of: opsiservicecall_auditSoftwareOnClient_createObjects
(221)     [5] [2021-09-06 21:57:55.807] [swaudit]     
(222)     [3] [2021-09-06 21:57:55.958] [swaudit]       Error: retrieveJSONObject --- opsi service problem ----> {"message":"(1292, \"Incorrect datetime value: '0000-00-00 00:00:00' for column 'lastUsed' at row 1\")","class":"OperationalError"}
(223)     [3] [2021-09-06 21:57:55.959] [swaudit]       Received (first 512): {"id": 1, "result": null, "error": {"message": "(1292, \"Incorrect datetime value: '0000-00-00 00:00:00' for column 'lastUsed' at row 1\")", "class": "OperationalError"}}
(224)     [3] [2021-09-06 21:57:55.959] [swaudit]       Error: -> {"message":"(1292, \"Incorrect datetime value: '0000-00-00 00:00:00' for column 'lastUsed' at row 1\")","class":"OperationalError"}
(225)     [2] [2021-09-06 21:57:55.993] [swaudit]       Error level set to fatal
(226)     [1] [2021-09-06 21:57:55.993] [swaudit] ___________________
(227)     [1] [2021-09-06 21:57:55.993] [swaudit] script finished: failed
(228)     [1] [2021-09-06 21:57:55.993] [swaudit] 3 errors
(229)     [1] [2021-09-06 21:57:55.994] [swaudit] 0 warnings
(230)     [1] [2021-09-06 21:57:55.994] [swaudit] 
(231)     [1] [2021-09-06 21:57:55.994] [swaudit] installed product: swaudit Version: 4.1.0.5-1
(232)     [1] [2021-09-06 21:57:55.994] [swaudit] 
OPSI Server 4.1.1.101 auf Ubuntu 18.04 LTS
Betroffener Rechner führt aus: Win 10 Enterprise 20H2 64-bit

Für Hilfe wäre ich sehr dankbar!

VG

faspie
Antworten