2209 - custom tag

[Uwe]

Hello,

there is a custom tag "Link" defined in the shared catalog. This catalog is open. The custom tag doesn't exist in the local catalog. Additionally I open the local catalog. I get this error message. You can get a recorded video. 

The client log:

2020-08-15 00:20:01,426 [STP SmartThreadPool Thread #1] DEBUG PicaJet.Daminion.Service.Utils.GetIndexedTagValuesCommand [(null)] Start: (641) - 39 - 0 - 0 - 500
2020-08-15 00:20:01,430 [STP SmartThreadPool Thread #1] DEBUG SQL [(null)] select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon, IsApproved, exists (select 1 from (select outTagId, outTagValueId, inTagId, inTagValueId from tagLinks) t where (t.outTagId = indexedtagid and t.outTagValueId = id) or (t.inTagid = indexedtagid and t.inTagValueId = id)) as HasTagLinks from SystemFlag_Table it where (not Hidded or Hidded is null) and ParentValueId = @ParentId order by isdefaultvalue desc, Upper(Value), Id LIMIT @Offset, @Limit (@ParentId=0, @Offset=0, @Limit=500)
2020-08-15 00:20:01,432 [STP SmartThreadPool Thread #1] ERROR PicaJet.Daminion.Service.Utils.GetIndexedTagValuesCommand [(null)] Error: (641) - 39 - 0 - 0 - 500
code = Error (1), message = System.Data.SQLite.SQLiteException (0x800007BF): SQL logic error
no such table: tagLinks
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at PicaJet.Daminion.Service.DbCommandWrapper.ExecuteReader() in C:\DaminionAutoGit\code\Service.DB\DbCommandWrapper.cs:line 48
   at PicaJet.Daminion.Service.DbCommandHelper.GetList[T](IDbCommand command, SelectDelegate selectDelegate) in C:\DaminionAutoGit\code\Service.DB\DbCommandHelper.cs:line 29
   at PicaJet.Daminion.Service.DbCommandHelper.GetList[T](IDbCommand command, SelectDelegate selectDelegate, Int32 pageIndex, Int32 pageSize) in C:\DaminionAutoGit\code\Service.DB\DbCommandHelper.cs:line 140
   at PicaJet.Daminion.Service.Utils.GetIndexedTagValuesCommand.GetTagValuesFromDb(DbConnection connection) in C:\DaminionAutoGit\code\Service.Utils.Uni\Command\GetIndexedTagValuesCommand.cs:line 178
   at PicaJet.Daminion.Service.Utils.GetIndexedTagValuesCommand.Start(DbConnection connection) in C:\DaminionAutoGit\code\Service.Utils.Uni\Command\GetIndexedTagValuesCommand.cs:line 102
   at PicaJet.Daminion.Service.Utils.DatabaseCommand.Start() in C:\DaminionAutoGit\code\Service.Utils.Uni\DatabaseCommand.cs:line 102
   at PicaJet.Daminion.Service.Utils.DatabaseCommand.Process() in C:\DaminionAutoGit\code\Service.Utils.Uni\DatabaseCommand.cs:line 50

Regards, Uwe

[Daria Kotilainen]

Thank you Uwe, Kate will test it out

 

Kind regards

Daria

[Daria Kotilainen]

Hi Uwe, regarding the custom tag Link - it was created only for the server version, specifically for the Daminion web client. But is is also available in the desktop client in the shared catalog. 

Regarding the local catalog, this issue will be resolved soon. Apologies for the inconvenience! 

 

Kind regards

Daria