UCCX 10 integrate with Orcale DB

[helawamry]

Hi,

We have UCCX 10 integrating with Oracle DB and the customer wants to run certain SQL statement at DB read step and add the result it directly in string variable on UCCX without using DB get step because the result of this SQL statement is not searching in table, it acts as equation and returns digits into string.

Can this be done or I need other way for doing this.

Thanks
Haitham,

[helawamry]

Hi Gergely,

Thank you for cooperation, I faced error in the code as below.
I have uploaded the odbc jar file to use it in the scripts.

sorry for interruption and thanks for your help.

[Gergely Szabo]

Hi,

I guess you have forgotten about posting the error message. Can you please what error message we are talking about?

G.

[helawamry]

Kindly find attached.

[Gergely Szabo]

This means the JDBC Driver jar was not registered.

Can you give me a screenshot from the appadmin web admin interface from System > Custom File Configuration?

G.

[helawamry]

Here we go.

[Gergely Szabo]

Did you restart the CCX Engine process (or the whole server) after adding that jar file to the Selected Classpath Entries list?

G.

[helawamry]

Yes, I have restarted the whole server yesterday after selecting the jar file.

Thanks
Haitham,

[Gergely Szabo]

Okay, this is interesting.

Is this a live system?

Anyway, can you ssh into UCCX and say

file tail activelog uccx/log/MIVR/stdout.log

And then try calling into the script again? Is there an error message?

G.

[helawamry]

yes it running system.

kindly find below screen shot of the results.

[Gergely Szabo]

Hi,

this is getting weird.

Anyway, I will try to install UCCX 10.5 in my lab to try to replicate the problem.

G.