Synchronization of phonebook OXE <---> OTUC

ebolar · Post by **ebolar** » 12 Jan 2007 02:41

Hello All,

does anyone knows, how I could synchronize the phonebook of the OXE with OTUC manually?
Problem is: When I add, for example, a speedDialing contact, it is not visible in the phonebook of the MyPhone Clients. The next day the contacts are synchronized. I tried to use the tsa_maintenance command, but I found no documentation of this menu, so I am carefull of use....

The OTUC Server based on RH Linux, the OXE version is 7.1
When I launch tsa_maintenance, an error occurs once a minute:

08h40:26.302 Error: 4 ??? 1 RSI point is not defined on main TSA

Has anyone an idea??

Thanks, Jan

cavagnaro · Post by **cavagnaro** » 12 Jan 2007 09:04

Just on tsa_maintennace run command 47 and then 57 to verify

regards

ebolar · Post by **ebolar** » 12 Jan 2007 10:06

Many thanks for your help.

Have you any idea regarding the mentioned error messages??

cavagnaro · Post by **cavagnaro** » 12 Jan 2007 12:25

yes,
have you configured an RSI on the OXE for OTUC?
go to: http://ip.otuc:3695 and see the status of the app.
If you are using only MyPhone no need of RSI, RSI is used only for MyAssistant.

Regards

ebolar · Post by **ebolar** » 15 Jan 2007 07:29

after entering 57, I got the error for each entry in the phonebook like this:

13h24:58.171 Error executing "INSERT INTO phonebook (sn, givenname, telephonenumber, itu_dtmf_sn, itu_dtmf_givenname, ccitt_dtmf_sn, ccitt_dtmf_givenname) VALUES ('Fax', '', '99', '329', '', '329', '');": [Sybase][ODBC Driver][Adaptive Server Anywhere]Index 'phonebook UNIQUE (telephonenumber,sn,givenname)' fÃ¼r Tabelle 'phonebook' wÃ¼rde nicht eindeutig sein

the last german words translated are: ... for table 'phonebook' would not be identical.

cavagnaro · Post by **cavagnaro** » 15 Jan 2007 07:59

:S Seems you have an error on you DB.
Is this a new installation? an upgrade?
Can you please explain a little bit more your scenario to try to see why this error raised?

ebolar · Post by **ebolar** » 15 Jan 2007 10:13

This is a fresh installation of OXE and OTUC Server. An external company installed the environment....
Between christmas and New Year we had an power outage, so it may be a DB corruption. But how can troubleshoot the dbs? Where are the relevant log files? I recongnized the error, after I created a speedDialing number and wanted to synchronize the phonebook with OTUC...

iourid · Post by **iourid** » 15 Jan 2007 12:42

14.2 OTS / Force loading Qmcdu from PBX
There are serveral errors in tsa_maintenance ... when using "57 - Force loading Qmcdu from Pbx"
tsa_maintenance shows...
19h37:30.675 Error executing "INSERT INTO phonebook (sn, givenname, telephonenumber,
itu_dtmf_sn, itu_dtmf_givenname, ccitt_dtmf_sn, ccitt_dtmf_givenname) VALUES ('RIEGLER', 'Christop',
'3248', '7434537', '24747867', '7434537', '24747807');": [Sybase][ODBC Driver][Adaptive Server
Anywhere]Index 'phonebook UNIQUE (telephonenumber,sn,givenname)' for table 'phonebook' would
not be unique ... for each user.
It is normal, as your request is to import all users from PBX, the system tries to create them in the
OmniTouch UC database, but if the users already exist => this warning in this context is normal.

cavagnaro · Post by **cavagnaro** » 15 Jan 2007 12:53

Hum, i never got that error.
If you do a Dump, do you see all your extensions?

ebolar · Post by **ebolar** » 16 Jan 2007 06:31

yes, when I dump ( 47 ) I get all extensions....