cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Error Datetime field overflow

Dawn_Fischer
Champ in-the-making
Champ in-the-making

I am new to these boards and am hoping someone can help me. When batches are running through auto-indexing the client will create the following error:

 Database Error encountered: Native Error: 0(0x00000000) SQL State: [22008] SQL Error: [[Microsoft][ODBC SQL Server Driver]Datetime field overflow]

SQL: [Update hsi.itemdata set itemname = ?, itemtypenum = ?, itemdate = ? where item num = ?]

Source File: []  Line Number: 9465  Function Call: [::SQLExecute(m_hStatement)]  Softeware Build: [9.2.1.618 SP1]

 

If we delete the batch and re-scan it we do not get the error.

Thanks!

5 REPLIES 5

Dawn_Fischer
Champ in-the-making
Champ in-the-making

We made the suggested changes so the drivers all matched but we received the error again this morning. Any other suggestions are appreciated!

Getting started

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.