[cisco-voip] Datasource name blank in UCCX Editor

[Teixeira, Mike]

Hello,

I am having intermittent issues with one of my database read steps of my UCCX scripts. Oracle states the driver is doing a conversion that the ODBC is in capable of. The view hasn't changed in months and the only thing that has changed is the UCCX version, I went from 4.05 to 7.01 SR3.

When I try to edit the db read step of my script it doesn't list any datasource names. I can see they are defined in the database subsystem of UCCX and the database subsystem is in full service.

Any ideas as to why I am getting the datasource name be blank and more importantly the ODBC driver not capable error?

Thanks,
Mike

MIVR-LIB_JDBC-7-UNK:*Statement.getQueryTimeout
MIVR-LIB_JDBC-7-UNK:Get statement option (SQLGetStmtOption), hStmt=9721560, fOption=0
MIVR-LIB_JDBC-7-UNK:RETCODE = -1
MIVR-LIB_JDBC-7-UNK:ERROR - Generating SQLException...
MIVR-LIB_JDBC-7-UNK:SQLException: SQLState(S1C00) vendor code(0)
MIVR-LIB_JDBC-7-UNK:java.sql.SQLException: [Oracle][ODBC]Driver not capable.
MIVR-DB_STEPS-3-EXECUTE_SQL_EXCEPTION:Error during executing SQL Update: Task ID=15000058612,Step Name=DB Read,SQL State=S1C00,SQL Error Code=0
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090923/1eafcfca/attachment.html>