Error: Invalid object name 'SYS.IDENTITY_COLUMNS'

Hi,

I get the following error when I make a database connection.
Infer Schema Error: Invalid object name ‘SYS.IDENTITY_COLUMNS’.
Data Source: Ms Sql Server Express 2017 (I’ve also tried with Microsoft SQL Server Developer (64-bit) Ver.11.)
.net Core: 2.1.402
os: Windows 10 Pro x64

Hi @Ozgur,

Radzen is making this query in order to infer your DB schema. This error is rather strange though. According to a quick google search this could mean that your DB is running in compatibility. Could that be the case? What is the output of running select @@version ?

select @@version output:

Microsoft SQL Server 2017 (RTM-GDR) (KB4293803) - 14.0.2002.14 (X64) Jul 21 2018 07:47:45 Copyright (C) 2017 Microsoft Corporation Express Edition (64-bit) on Windows 10 Pro 10.0 (Build 17134: )

db_properties

Same problem here. Do you have a solution?

Hi,

Can you verify if you have such view (sys.identity_columns) in msdb system database?

More info can be found here:
https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-identity-columns-transact-sql?view=sql-server-2017

Best Regards,
Vladimir

There is a collation problem. It gives this error with Turkish collation. But with Latin1_General it works.

Hi @Ozgur,

Can you execute the following query with Turkish collation to see what will be the result

select * from sys.identity_columns

Best Regards,
Vladimir

object_id name column_id system_type_id user_type_id max_length precision scale collation_name is_nullable is_ansi_padded is_rowguidcol is_identity is_filestream is_replicated is_non_sql_subscribed is_merge_published is_dts_replicated is_xml_document xml_collection_id default_object_id rule_object_id seed_value increment_value last_value is_not_for_replication is_computed is_sparse is_column_set generated_always_type generated_always_type_desc encryption_type encryption_type_desc encryption_algorithm_name column_encryption_key_id column_encryption_key_database_name is_hidden is_masked graph_type graph_type_desc
133575514 instance_id 1 56 56 4 10 0 NULL 0 0 0 1 0 0 0 0 0 0 0 0 0 1 1 NULL 0 0 0 0 0 NOT_APPLICABLE NULL NULL NULL NULL NULL 0 0 NULL NULL
149575571 log_id 1 56 56 4 10 0 NULL 0 0 0 1 0 0 0 0 0 0 0 0 0 1 1 NULL 0 0 0 0 0 NOT_APPLICABLE NULL NULL NULL NULL NULL 0 0 NULL NULL
901578250 Id 1 56 56 4 10 0 NULL 0 0 0 1 0 0 0 0 0 0 0 0 0 1 1 11 0 0 0 0 0 NOT_APPLICABLE NULL NULL NULL NULL NULL 0 0 NULL NULL
933578364 Id 1 56 56 4 10 0 NULL 0 0 0 1 0 0 0 0 0 0 0 0 0 1 1 50 0 0 0 0 0 NOT_APPLICABLE NULL NULL NULL NULL NULL 0 0 NULL NULL
965578478 Id 1 56 56 4 10 0 NULL 0 0 0 1 0 0 0 0 0 0 0 0 0 1 1 250 0 0 0 0 0 NOT_APPLICABLE NULL NULL NULL NULL NULL 0 0 NULL NULL
1993058136 queuing_order 3 127 127 8 19 0 NULL 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 NULL 0 0 0 0 0 NOT_APPLICABLE NULL NULL NULL NULL NULL 0 0 NULL NULL
2025058250 queuing_order 3 127 127 8 19 0 NULL 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 NULL 0 0 0 0 0 NOT_APPLICABLE NULL NULL NULL NULL NULL 0 0 NULL NULL
2057058364 queuing_order 3 127 127 8 19 0 NULL 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 NULL 0 0 0 0 0 NOT_APPLICABLE NULL NULL NULL NULL NULL 0 0 NULL NULL

Thanks! We will do our best to provide support for Turkish collation as well.

Hi @Ozgur,

I have additional question. Can you query INFORMATION_SCHEMA.TABLES like this?

select * from INFORMATION_SCHEMA.TABLES

Best Regards,
Vladimir

TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
test_db dbo Products BASE TABLE
test_db dbo Orders BASE TABLE
test_db dbo OrderDetails BASE TABLE

Thanks! Shoot us an email at info@radzen.com and we will send you private build.

Hello @enchev when will this build be public?

Hi @gurol,

If it works as expected in your case we can release it today!

Best Regards,
Vladimir

I just tried and works like a charm. Thanks.

1 Like