Hi!
Yesterday apple released a supplemental update in order to fix the password leak for encrypted APFS disks. Around the same time all the High Sierra macs in our environment started failing their recons. Here's what I've noticed:
Recon's resulting in an Unknown error
sudo jamf recon
Password:
Retrieving inventory preferences from ***...
Finding extension attributes...
Locating applications...
Locating accounts...
Locating package receipts...
Searching path: /Applications
Locating hard drive information...
Locating software updates...
Locating printers...
Locating hardware information (Mac OS X 10.13.0)...
Submitting data to ***...
There was an error.
Unknown Error - An unknown error has occurred.
JAMF server log full of SQL errors:
2017-10-06 09:44:18,991 [WARN ] [Tomcat-15 ] [SqlExceptionHelper ] - SQL Error: 1406, SQLState: 22001
2017-10-06 09:44:18,992 [error] [Tomcat-15 ] [SqlExceptionHelper ] - Data too long for column 'version' at row 1
Query is: insert into available_software_updates (computer_id, display_name, name, recommended, restart_required, version) values (?, ?, ?, ?, ?, ?)
Query is:
insert into available_software_updates (computer_id, display_name, name, recommended, restart_required, version) values (?, ?, ?, ?, ?, ?)
2017-10-06 09:44:18,993 [error] [Tomcat-15 ] [lientCommunicationServlet] - Error processing communication content - org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.DataException: could not execute statement
Software updates seem to be the culprit here.... Let's test that theory:
softwareupdate -l
Software Update Tool
Finding available software
Software Update found the following new or updated software:
* macOS High Sierra 10.13 Supplemental Update-
macOS High Sierra 10.13 Supplemental Update ( ), 893081K [recommended] [restart]
There is an update available! Lets run it
5 minutes and a reboot later, the machine is updated. Let's run a new recon:
sudo jamf recon
Password:
Retrieving inventory preferences from ***...
Finding extension attributes...
Locating package receipts...
Locating hard drive information...
Locating accounts...
Locating applications...
Searching path: /Applications
Locating software updates...
Locating printers...
Locating hardware information (Mac OS X 10.13.0)...
Submitting data to ***...
<computer_id>84</computer_id>
Presto!
Has anyone else run into this so far?