Error occurred during introspection, query RetrieveColumns:
I'm trying to setup another sqlserver database and I'm unable to view any table columns or use the introspect. After reviewing other post with similar issues, I was able to find the following error in the logs.
2021-01-08 13:58:51,894 [ 46495] ERROR - ql.introspector.MsIntrospector - Error occurred during introspection, query RetrieveColumns:
Arithmetic overflow error converting expression to data type bigint.
SQL statement:
with T as ( select object_id, create_date
from TEST_uninsured_care.sys.all_objects
where schema_id = ?
and type in ('U','S','IT','V','TT','IF','FT','TF')
and modify_date >= ? )
select T.create_date,
C.object_id, C.column_id as column_position, C.name,
Y.name as type_name,
C.max_length, C.precision, C.scale, C.collation_name,
C.is_nullable, C.is_computed,
cast(I.seed_value as bigint) as identity_seed_value,
cast(I.increment_value as bigint) as identity_increment_value,
cast(I.last_value as bigint) as identity_last_value,
D.name as default_constraint_name,
D.is_system_named as default_constraint_name_is_surrogate,
D.object_id as default_constraint_object_id,
D.modify_date default_constraint_modify_date,
coalesce(D.definition, X.definition) as default_expression,
C.is_hidden /* 0 */ as is_hidden,
C.is_sparse /* 0 */ as is_sparse,
C.is_column_set /* 0 */ as is_column_set
from T join TEST_uninsured_care.sys.all_columns C on T.object_id = C.object_id
left outer join TEST_uninsured_care.sys.types Y on C.system_type_id = Y.system_type_id and C.user_type_id = Y.user_type_id
left outer join TEST_uninsured_care.sys.identity_columns I on C.object_id = I.object_id and C.column_id = I.column_id
left outer join TEST_uninsured_care.sys.default_constraints D on C.object_id = D.parent_object_id and C.column_id = D.parent_column_id
left outer join TEST_uninsured_care.sys.computed_columns X on C.object_id = X.object_id and C.column_id = X.column_id
order by T.create_date, C.object_id, C.column_id
java.lang.Throwable: Error occurred during introspection, query RetrieveColumns:
Please sign in to leave a comment.
Please file a bug at https://youtrack.jetbrains.com/newIssue?project=DBE with the logs attached (Help | Collect Logs and Diagnostic Data).
https://youtrack.jetbrains.com/issue/DBE-12369