Skip to Content
Former Member
Apr 07, 2014 at 10:30 AM

ODBC error checking in a data model


At my client we're using PD 16.5.0 build 3982, and we're trying to check in a LDM that was originally generated from a PDM. When we try and check the LDM in to the repository, we get an ODBC error:

ODBC driver for Oracle

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


I have an old (PD 16.1) PDM for the repository, which shows the column as having a length of 30,000, not 2,000. On my own laptop, the 16.5.3 (Sybase SQL Anywhere) repository also shows the column as varchar(30,000). However, the client's 16.5.0 Oracle database shows the column as varchar2(2000).

Has anyone else had this problem with an Oracle repository?