Page 1 of 1

OmniPCX Enterprise R9.1 - SQLCODE_-2 error

Posted: 25 Jul 2011 05:01
by ranjithvkumar
Hello everyone,

I am currently using OmniPCX Enterprise R9.1 with 2 Appliance server (let us consider A & B) in same domain. The system was working well and good but suddenly now i am getting "SQLCODE_-2" error when i am trying to create user. In telnet with logical IP address, When the server A is in MAIN role this error use to occur and when i try create user directly in server A the same error occurs. But in telnet with logical IP address if the server B is in MAIN role there is no problem at all. I can even able to create user if i directly telnet to server B.

Waiting for experts help / solution.

Note : error snapshot attached.

Thanks in advance.

With regards,
Kumar

Re: OmniPCX Enterprise R9.1 - SQLCODE_-2 error

Posted: 25 Jul 2011 07:08
by murraya
sounds like a database error on "A". quickest fix might be to stop the tel on "A" then do a mastercopy of the database from "B".

Re: OmniPCX Enterprise R9.1 - SQLCODE_-2 error

Posted: 25 Jul 2011 08:15
by vad
Check database - "checkdb" command on both AS.

Re: OmniPCX Enterprise R9.1 - SQLCODE_-2 error

Posted: 27 Jul 2011 03:32
by ranjithvkumar
Thanks a lot Mr.Murraya and Mr.Vad.. i have made master copy from serve B to Server A and the error was solved. But now i am getting 2 error one is related to Table Entity and another is Table NetNode when i do check the database. So can u help me on this ?

Note : Error snapshot attached.

With regards,
Kumar

Re: OmniPCX Enterprise R9.1 - SQLCODE_-2 error

Posted: 27 Jul 2011 04:00
by alexeik
The entity error is pretty common, you have no overflow routing no. in both entitys. This should normaly be no problem.
The tunparam error has something to do with the x25 tunnel parameters. Is this a networked system with multiple nodes?

Re: OmniPCX Enterprise R9.1 - SQLCODE_-2 error

Posted: 15 Aug 2011 07:04
by Eliott
alexeik wrote:The tunparam error has something to do with the x25 tunnel parameters. Is this a networked system with multiple nodes?
I guess the Netadmin X25 config (Network / Site) doesn't match mgr - System - Node and Network number