Jive-Tango Db problem

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

Hi

There is no domain/family/member fields in tango.property_device table.
Fields are:
[*] device
[*] name
[*] count
[*] value
[*] updated
[*] accessed
[*] comment
[/list]
To see your property use the command:
select name,value from property_device where device=“a/b/c”;

Regards

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

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

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