How can we help you today? How can we help you today?

Problem with large database

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
luigi menegolo
0

Comments

2 comments

Sort by
  • Tianjiao_Li
    Hi @Luigi

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

    Thanks!
    Tianjiao_Li
    0
  • 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
    Gigi
    0

Add comment

Please sign in to leave a comment.