Jive-Tango Db problem - TANGO Controls

# 7 years ago
TCS_GMRT	Hello All I am registering a device server from jive. Lets say Server/Instance—> Test/test Class–>Test Device—->a/b/c Now I am entering device properties of the above device through jive which is: PropertyName=test Value=Success Now when I check the tango.property_device table in mysql The domain/family/member is not getting updated in the table i.e. it is blank. Ideally domain should contain 'a', family should contain 'b' and member should contain 'c'. I am using the below versions: Tango-9.2.2 jive-6.9 Any suggestion would be helpful. Thanks and Regards TCS-GMRT TEAM Regards, TCS_GMRT

# 7 years ago

Hello All

I am registering a device server from jive. Lets say
Server/Instance—> Test/test
Class–>Test
Device—->a/b/c

Now I am entering device properties of the above device through jive which is:

PropertyName=test
Value=Success

Now when I check the tango.property_device table in mysql

The domain/family/member is not getting updated in the table i.e. it is blank.
Ideally domain should contain 'a', family should contain 'b' and member should contain 'c'.

I am using the below versions:
Tango-9.2.2
jive-6.9

Any suggestion would be helpful.

Thanks and Regards
TCS-GMRT TEAM

Regards,
TCS_GMRT

# 7 years ago
Pascal	Hi There is no domain/family/member fields in tango.property_device table. Fields are: device name count value updated accessed comment To see your property use the command: select name,value from property_device where device="a/b/c"; Regards

# 7 years ago
TCS_GMRT	Hello I am using tango-9.2.2 version of tango. I downloaded it from sourceforge. I installed the setup as per the mentioned steps. The property_device table of tango db has the 'domain', family' and 'member' columns. It would be nice if you could share the tango-db schema sql file here. Please find the attached screenshot. Thanks and Regards TCS-GMRT TEAM Regards, TCS_GMRT Attachments:

# 7 years ago
Pascal	Hello After an historical search, it seems that the script create these fields since years (at least Tango-7). Nobody knows why it has been added to the scripts, but it is not used by the Database server. And nobody tried to see what is the property_device table content for these fields. The misunderstood of my previous message was due to our database schema. Our database has not been updated or created by the script. And these fields do not exist. Sorry for the inconvenient. We will fix it in a future release. Pascal

# 7 years ago

Pascal

Hello
After an historical search, it seems that the script create these fields since years (at least Tango-7).
Nobody knows why it has been added to the scripts, but it is not used by the Database server.
And nobody tried to see what is the property_device table content for these fields.

The misunderstood of my previous message was due to our database schema.
Our database has not been updated or created by the script. And these fields do not exist. smile

Sorry for the inconvenient.
We will fix it in a future release.
Pascal

# 7 years ago
TCS_GMRT	Hello No issues. I will alter the property_device table and remove the 'domain', 'family' and 'member' column. Is there change in any other table of tango database from previous versions ? TCS-GMRT TEAM Regards, TCS_GMRT