IBM License Metric Tool (ILMT)

IBM License Metric Tool (ILMT)

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Upload Problems - disconnected scan

    Posted 08/29/23 09:30 AM
      |   view attached

    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
    ------------------------------

    Attachment(s)

    log
    tema.log   877 KB 1 version


  • 2.  RE: Upload Problems - disconnected scan

    Posted 08/29/23 11:47 AM
    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
    ------------------------------



Related Content