Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
Adding an Enumeration Items
October 7, 2022
12:48, EEST
Avatar
Sabari
Member
Members
Forum Posts: 62
Member Since:
June 21, 2021
sp_UserOfflineSmall Offline

Hello,
When I try to add an enumeration item via Collection Groups, it is not added, but if I manually add it to the collectionitem table in the database, the item is added for history. Is this correct?

Thank you

October 7, 2022
13:39, EEST
Avatar
Bjarne Boström
Moderator
Moderators
Forum Posts: 1032
Member Since:
April 3, 2012
sp_UserOfflineSmall Offline

Hi,

Things that cannot be added via the UI are not officially supported, but might technically like work.

If you would like to have this as a feature, contact sales@prosysopc.com.

Since this is related a bit to another question, linking https://forum.prosysopc.com/forum/opc-ua-historian/add-programmatically-items-and-group/#p6302, and since that answer applies here it is copied below:

Hi,

“Yes”, but doing it like that will not be officially supported. The application should be the only one writing to the database, however some consideration was made to enable reading the data directly from the database.

Also I would assume in practice the historian service component must be shut down before doing any changes, otherwise the results might be undefined. Plus note that nothing prevents setting values manually which might be otherwise limited by the UI, which might cause a scenario that the UI could stop working, show wrong data or cause some other undefined result. But if you just make it so that the database would look exactly same as-if written from the UI while both the Configurator UI + the service component are shut down everything like should work.

NOTE!
Do not edit the schema however, all tables and columns need to be as they are, they are versioned (via liquibase lib) and basically any changes not made by the application itself to the schema will most likely cause it to not start (and in practice the schema must be dropped or reverted to the state it was before so that it is the application itself making the changes). Also this would most likely happen much later than doing schema edits, i.e. if a newer version of the application needed to do changes, it must be itself the one doing them (it will do checksums etc.).

Forum Timezone: Europe/Helsinki

Most Users Ever Online: 1919

Currently Online:
46 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Heikki Tahvanainen: 402

hbrackel: 144

rocket science: 88

pramanj: 86

Francesco Zambon: 83

Ibrahim: 78

Sabari: 62

kapsl: 57

gjevremovic: 49

Xavier: 43

Member Stats:

Guest Posters: 0

Members: 726

Moderators: 7

Admins: 1

Forum Stats:

Groups: 3

Forums: 15

Topics: 1529

Posts: 6471

Newest Members:

gabriellabachus, Deakin, KTP25Zof, Wojciech Kubala, efrennowell431, wilfredostuart, caitlynfajardo, jeromechubb7, franciscagrimwad, adult_gallery

Moderators: Jouni Aro: 1026, Pyry: 1, Petri: 0, Bjarne Boström: 1032, Jimmy Ni: 26, Matti Siponen: 349, Lusetti: 0

Administrators: admin: 1