[asterisk-dev] ODBC error

[riscphree]

I'm having a problem getting asterisk to execute odbc commands.
Asterisk is successfully using odbc to store CDR just fine.

acallpbx*CLI> odbc show all

ODBC DSN Settings
-----------------

 Name:   acall-cdr-db
 DSN:    *edited*
   Last connection attempt: 1969-12-31 19:00:00
 Pooled: No
 Connected: Yes


acallpbx*CLI> odbc read
GET_CLIENTLIST    GET_PRECEDENCE    GET_SUB_STATUS    ODBC_CLIENTCOUNT

acallpbx*CLI> odbc read GET_PRECEDENCE testcorp
SELECT event_precedence from user_profile where company = 'testcorp' limit 1

acallpbx*CLI> odbc read GET_PRECEDENCE testcorp exec
Failed to execute query. [SELECT event_precedence from user_profile
where company = 'testcorp' limit 1]

Any hints on where to debug? CDR is writing to the same DB and DSN
(same connection) fine.

Thanks.