Hello Andreas,
This doesn't look like anything directly related to 'Upload of scanned server packages'.
More like a generic problem with SQL Server, JDBC driver or SQL Server database collation.
First check the collation:
select collation_name, name from sys.databases where name='temadb'
Do make sure that the temadb database collation is 'SQL_Latin1_General_CP1_CS_AS' collation.
If the collation is not an issue try to restart ILMT & SQL Server.
If it still doesn't resolve this problem please open up a support ticket to us...
------------------------------
Thank you,
Oktawian
Oktawian Powązka, L3 Support
IBM License Metric Tool
------------------------------
Original Message:
Sent: Tue August 29, 2023 06:29 AM
From: Andreas Schuster
Subject: Upload Problems - disconnected scan
Hello to all!
We try to get a new installation of ILMT 9.2.31 in disconnected scan mode up and running.
Problem: Upload of scanned server package file (.zip file) not possible. Following error message in tema.log file:
Deutsch:
<Sequel::DatabaseError: DBNAME: temadb - Java::ComMicrosoftSqlserverJdbc::SQLServerException: Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.>
English:
<Sequel::DatabaseError: DBNAME: temadb - Java::ComMicrosoftSqlserverJdbc::SQLServerException: When converting a varchar datatype to a datetime datatype, the value is out of range.>
Any hints are highly appreciated!
Where to look, what to check?
Best regards
Andreas
------------------------------
Andreas Schuster
------------------------------