Ranga wrote: >Subject: [sipX-dev] ODBC ERR from sipXproxy > >Hello, > >I am running 4.1.6-017649 > >After I built, installed and configured the system, I noticed >that phones could not call each other. I see the following in >my sipXproxy.log file: > >"2010-01-11T03:25:41.255068Z":59:ODBC:ERR:sipxtest.sipxtest.net >:SipXProxyCseObserver-10:B77FAB90:SipXProxy:"odbcExecute: >statement INSERT INTO call_state_events VALUES >(DEFAULT,'192.168.5.75:-1',1,timestamp '2010-01-11 >03:25:41.254','R',1,'[email protected]',' EFD9BEBD-AA18E08C','','\"user1\" ><sip:[email protected]>;tag=EFD9BEBD-AA18E08C','<sip: >[email protected];user=phone>','<sip:[email protected] 2>','','',0,'','','','f',''); >failed, error code -1" >"2010-01-11T03:25:41.255135Z":60:ODBC:ERR:sipxtest.sipxtest.net >:SipXProxyCseObserver-10:B77FAB90:SipXProxy:" > SQLGetDiagRec(SQLExecDirect):[unixODBC]Error while executing >the query (non-fatal);\nERROR: INSERT has more expressions >than target columns" > > >Any clues about where this is coming from? > How old is your CDR database? I added a number of new fields in the CSE and CDR tables in 4.2 (awhile back though) and informed the development public to drop and re-create the CDR database. If you hadn't done this and just started using CDR in the development environment then this could be your issue.
I would go into the database and check both the "call_state_events" and "cdrs" tables to ensure all of the fields exist. This can be done as follows: >psql -d SIPXCDR -U postgres SIPXCDR=# \d call_state_events <== will show the fields in the call_state_events table. SIPXCDR=# \d cdrs <== will show the fields in the cdrs table. Call_state_events table should contain the following fields: id observer event_seq event_time event_type cseq call_id from_tag to_tag from_url to_url contact refer_to referred_by failure_status failure_reason request_uri reference caller_internal callee_route Cdrs table should contain the following fields: id call_id from_tag to_tag caller_aor callee_aor start_time connect_time end_time termination failure_status failure_reason call_direction reference caller_contact callee_contact caller_internal callee_route If all of these fields are not present then you'll need to drop and create the SIPXCDR database as follows: Stop your sipXecs system. (i.e. sudo etc/init.d/sipxecs stop) >bin/sipxcallresolver.sh --database drop >bin/sipxcallresolver.sh --database create Start your sipXecs system. (i.e. sudo etc/init.d/sipxecs start) _______________________________________________ sipx-dev mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-dev Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-dev sipXecs IP PBX -- http://www.sipfoundry.org/
