Data Model editor: Key field not found

Siren Platform/Investigate Tech Support Community
#1

Dear all,

I am writing as I have some trouble in the Data Model phase. Specifically, I am using Siren to explore a SQL database connected through a JDBC connection. Unluckily, it looks like the Primary Key of my Virtual Index is not recognised, as I keep receiving the following error:

“Data Model editor: Key field my_field not found”

I was wondering whether you have any hint about how to solve this problem?

Many thanks in advance.

All the best,
Michele

#2

Hi Michele

In order to help we would need a bit more information like:

  • Database you are using
  • The schema of the table which causing this problem.
  • Version of Investigate.

Cheers
Simon

#3

Dear Simon,

Many thanks for your help!

As for your questions:

  1. I am using a MariaDB database
  2. Siren Investigate version: 10.2.1
  3. Table schema:

CREATE TABLE test_table (
UserID bigint(20) NOT NULL AUTO_INCREMENT,
Type int(11) DEFAULT 0,
PRIMARY KEY (UserID),
KEY Type (Type) USING BTREE
)

Please, let me know in case you need further information.

All the best,
Michele