Skip to content

Arithmetic overflows in view_IndexInformation_CurrentDB; No data output #306

Open
@Hedrik

Description

@Hedrik

Freshly downloaded from GitHub. No usage instructions found, so I just added a 'USE {Db}' at the top and ran it. Here is the relevant part of the message output - I suspect that the script may need to be updated to use the bigint type instead of int - I will report back if I attempt again after changing to bigint, though given that it took 6 and 1/2 hours to run, I may just wait on that...: (then again, I don't see anything even possible in the region of the line reported as having the
error, so...)

.
.
.
Msg 8115, Level 16, State 2, Line 416
Arithmetic overflow error converting expression to data type int.
The statement has been terminated.
Msg 8115, Level 16, State 2, Line 416
Arithmetic overflow error converting expression to data type int.
The statement has been terminated.
Msg 8115, Level 16, State 2, Line 416
Arithmetic overflow error converting expression to data type int.
The statement has been terminated.
Msg 8115, Level 16, State 2, Line 416
Arithmetic overflow error converting expression to data type int.
The statement has been terminated.
.
.
.
Msg 8152, Level 16, State 10, Line 3
String or binary data would be truncated.

And the result had no data:

image

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions