Internet Suite ODBC error

[vivek]

I am using Oracle 9i for contact server db. Our agents have Oracle 9i client. When they reply emails some times they get below error,

[DataDirect][ODBC Oracle Wire Protocol driver]Optional feature not implemented. (-2147467259)


Any idea why? and how I can resolve this.

Thanks, Vivek.

[Fra]

Vivek,

which version of contact server and oracle drivers are you running? I'd check the tnsnames.ora file. Anyway if the error occurs every once and a while it may be unavalaibility of the contact server db due to network connectivity issue.

[René]

Hi Vivek,

I would say you're using old driver for Oracle which doesn't support all features of 9i. Please check installed drivers in Control Panel / Administrative Tools / Data Sources (ODBC). All installed drivers are listed on tab Drivers, look for drivers "GCTI x.x Oracle Wire Protocol". I'm not 100 % sure but you need driver's version 4.2.

If the "right" driver (version 4.2) is installed then the issue could be caused by wrong configuration of Contact Server. Please check following option of Contact Server - section "DataSource Agent", key "Connection". The connection string should refer to driver version 4.2 (e.g. "driver={GCTI 4.2 Oracle Wire Protocol};SID=...")

R.

[vivek]

I got the solution.

Basically I had to install Internet Suite Thrid party components and common components.
Then server will get the Data Direct driver.

- this solved the problem.

[vivek]

hi,

I still have the problem.

when I setup contact svr db for 9i, i did the following steps,

- uninstalled oracle 8i contact svr db
- uninstalled oracle 8i
- installed oracle 9i
- installed contact svr db for oracle 9i
- finally installed common components and thirty party components.

I was wondering did I make any mistake in the above order. - if you know pls advice.

Thanks.

[catanirex]

Hi,
Have you changed the settings in CME? If I remember correct you have to change the driver settings for UAD (client) under Contact Server from the old wire version to the new. (4.2 Oracle Driver)

[Seb Reeve]

Are you using Oracle RAC? - I know ICS does not support this... (they use an older version of Wire Protocol Driver in UCS which does not support RAC)

...at least I remember this was the case with a client of mine about 12 months ago - if old info, please disregard!!

Seb

[vivek]

I am not using RAC.

Thanks.

[vivek]

This issue has been resolved.

The issue was not ODBC. It was ORacle 9i.
After I installed contact server db for 9i, the oracle pfile did not have few parameters.

I added those parameters, now it is working fine.
To resolve I added the following parameters,
java pool
large pool
also incereased shared pool size

Thx.