Thanks, I think I upgraded - just some seconds before - the end of april.
Will give this a try tomorrow, have to get home now.
Paul
"DANS, RAYMOND (RAYMOND)" <rgd...@avaya.com> wrote on 24-06-2010 17:18:45:
> Snip.......
> >> Raymond Dans wrote:
> >> In an HA environment, there should be a connection established
> >> between the Call Resolver on the primary and the Call Resolver Agent
> >> on the distributed.
> >> Have you turned on DEBUG logging for CDR on the primary? I'd be
> >> curious to see if its even able to establish a connection to the
> >> distributed server via stunnel.
>
> >Hi, the problem is that the secondary can't write the CSE's to the
> >database, see the end of the mail and the sipXproxy zip file,
> >here's the rest of the answers:
>
> >I have atached a zip containing a piece of the sipxcallresolverlog
> >First part is of a call via the primary server (visible in the GUI)
> >Second part is of a call via the secondary server (not visible in the
GUI)
> >There is not that much info in there, what is id:6 for example?
>
> >> Other things to look at are:
> >> a) ensure the Call Resolver Agent on the secondary server is running.
>
> >On the primary "CDR" is running,
> >[r...@gssipx02 sipxpbx]# sipxproc -l
> >{"FreeSWITCH"=>"Running",
> > "sipXmrtg"=>"Running",
> > "SipXrest"=>"Running",
> > "SipXopenfire"=>"Disabled",
> > "sipXrecording"=>"Running",
> > "SIPRegistrar"=>"Running",
> > "sipXprovision"=>"Running",
> > "ParkServer"=>"Running",
> > "ConfigAgent"=>"Running",
> > "CallResolver"=>"Running",
> > "ACDServer"=>"Running",
> > "SIPStatus"=>"Running",
> > "ConfigServer"=>"Running",
> > "CallResolver-Agent"=>"Disabled",
> > "SipXbridge"=>"Disabled",
> > "sipXivr"=>"Running",
> > "PageServer"=>"Running",
> > "PresenceServer"=>"Running",
> > "ResourceListServer"=>"Running",
> > "SipXrelay"=>"Running",
> > "SIPXProxy"=>"Running",
> > "SharedAppearanceAgent"=>"Running"}
>
> >on the secondary "CDR HA tunnel" is running,
> >[r...@gmsipx02 ~]# sipxproc -l
> >{"FreeSWITCH"=>"Disabled",
> > "sipXmrtg"=>"Disabled",
> > "SipXrest"=>"Disabled",
> > "SipXopenfire"=>"Disabled",
> > "sipXrecording"=>"Disabled",
> > "SIPRegistrar"=>"Running",
> > "sipXprovision"=>"Disabled",
> > "ParkServer"=>"Disabled",
> > "ConfigAgent"=>"Disabled",
> > "CallResolver"=>"Disabled",
> > "ACDServer"=>"Disabled",
> > "SIPStatus"=>"Disabled",
> > "ConfigServer"=>"Disabled",
> > "CallResolver-Agent"=>"Running",
> > "SipXbridge"=>"Disabled",
> > "sipXivr"=>"Disabled",
> > "PageServer"=>"Disabled",
> > "PresenceServer"=>"Disabled",
> > "ResourceListServer"=>"Disabled",
> >"SipXrelay"=>"Running",
> >"SIPXProxy"=>"Running",
> >"SharedAppearanceAgent"=>"Running"}
> >This part looks OK according to me.
>
> > b) with DEBUG on for the Proxy, check the sipXproxy log file on the
> > secondary server to see if its able to write Call State Events to
> > the database on the secondary server.
>
> >This is a hit, I get a:
> >"Error while executing the query;\nERROR: INSERT has more
> expressions than target columns"
>
> >See attached proxy.zip with 2 ERR messages.
> >Do you know what can be done to solve this?
>
> Yes I know exactly what the problem is. There was a bug in the
> upgrade process that in an HA system, didn't upgrade the database on the
> secondary server so new fields that were added in the release did
> not get added to the database. As a result, the Proxy on the secondary
> fails to write Call State Events to the database. Call State
> Events are used by the Call Resolver (i.e. CDR) to create Call Detail
Records.
>
> To fix the issue,
> 1. Open up a putty terminal to the secondary server(userid root).
> 2. Shutdown sipXecs on the secondary by issuing the command /etc/
> init.d/sipxecs stop
> 3. Edit the file sipxcallresolver-setup found under /usr/libexec/
> sipXecs/setup.d and add the line
> /usr/bin/sipxcallresolver.sh --patch
> at the end of the file.
> 4. Start up sipXecs on the secondary by issuing the command /etc/
> init.d/sipxecs start
>
> BTW. This issue was fixed at the end of April so you must have
> upgraded prior to this.
>
>
> Raymond
>
_______________________________________________
sipx-users mailing list sipx-users@list.sipfoundry.org
List Archive: http://list.sipfoundry.org/archive/sipx-users
Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-users
sipXecs IP PBX -- http://www.sipfoundry.org/
