What are the challenges you face when working across database platforms? Take the survey
Options

Problem with large database

GigiGigi Posts: 2 New member
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
Tagged:

Answers

  • Options
    Tianjiao_LiTianjiao_Li Posts: 684 Rose Gold 5
    edited September 18, 2020 3:10PM
    Hi @Luigi

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

    Thanks!
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
  • Options
    GigiGigi Posts: 2 New member
    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
Sign In or Register to comment.