PD 16.5 SP4 ODBC Error

[Former Member]

Hi,

Using PD 16.5 SP4 and getting the following error when we check in a PDM containing stored procedures.

ODBC error:

ODBC driver for Oracle

ORA-12899: value too large for column "PMTEXT"."TDAT" (actual: 2002, maximum: 2000)

SQLSTATE = NA000

Donna

[former_member192453 · Accepted solution]

Hi Donna,

On your Repository Definition, check the value of the 'Bytes Per Char' parameter. My guess is that the value is '1-byte'. Try changing it to '3-byte'.

For a direct connection:

disconnect from the repository

modify the repository definition

connect to the repository

check-in model

For a proxy connection, you would make this change on the connection instance on the proxy server.

Anthony

[Former Member]

Hi Anthony,

Thanks for the reply.  I changed the bytes from 1 to 3 on the direct connect however, I am not sure how to do it on the proxy server.  I do not see the same options as on the direct connection.

Thanks for you help.

Donna

[jong-kil_park]

Hi Donna,

You can run "pdproxyconf16.exe" on the machine where the proxy server will be running.

In the Repository Proxy Configuration window, you can make a connection instance for the repository and set it to "3-byte" as below.

Best Regards

Jerry