Problem with large database

Gigi

Hi All,
I have no results in Sql Search due to the following error when indexig a large (50 GB) database.

16 Sep 2020 10:35:27.381 [57] INFO  DatabaseObjectStorage - Inserting objects into index

16 Sep 2020 10:35:27.581 [57] INFO  DatabaseObjectStorage - Done objects

16 Sep 2020 10:35:27.582 [57] INFO  DatabaseObjectStorage - Inserting columns into index

16 Sep 2020 10:35:27.637 [57] ERROR DatabaseObjectIndexer - Exception while indexing database drMendrisio: 

System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error for data type smallint, value = 47927.

I have already tried to clear Log and indexing files in AppData\Local\Red Gate folder with no success.

Any help will be appreciated?

Luigi

Tianjiao_Li

Hi @Luigi

Could you let us know roughly the number of schema items the database has? Is it 50GB mainly data?

Thanks!

Gigi

Hi Tianjiao,

here is the database items list

Count type_desc

69 SYSTEM_TABLE

18 VIEW

25 SQL_TABLE_VALUED_FUNCTION

2740 DEFAULT_CONSTRAINT

3 SERVICE_QUEUE

242 USER_TABLE

256 PRIMARY_KEY_CONSTRAINT

10 INTERNAL_TABLE

5 TYPE_TABLE

483 SQL_TRIGGER

17 SQL_SCALAR_FUNCTION



Cheers
Luigi