[cisco-voip] Datasource name blank in UCCX Editor

[Teixeira, Mike]

All,

Well it seems that it both problems were from me not hitting refresh database schema on the db read step. Once I hit that and waited for a  long time, my oracle server has hundreds of tables and views, the datasource name drop down box populated. The driver not capable error has also stopped; however, since the problem was intermittent I'll give it a while to make sure.

Mike

From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Teixeira, Mike
Sent: Wednesday, September 23, 2009 2:53 PM
To: 'cisco-voip at puck.nether.net'
Subject: [cisco-voip] Datasource name blank in UCCX Editor

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/20090924/5f7ecb52/attachment.html>