Troubleshooting the Repository Installed on ASE

This section lists known issues encountered when installing the repository on an Sybase Adaptive Server Enterprise DBMS.

Commonly Required ASE Parameters

The following ASE parameters must frequently be configured higher than their default settings to optimize check in of models:

number of open objects
number of open indexes
number of locks
max memory
procedure cache size

Must declare variable '@dr_t_a0'. SQLSTATE = ZZZZZ

If you see the above error and are connecting to an ASE server via ODBC, open the ODBC Data Source Administrator, select your data source, and select the Enable Dynamic Prepare option on the Connection tab.

Truncated data on extraction

If you are seeing data truncated on extraction from the repository and are connecting to an ASE server via ODBC, open the ODBC Data Source Administrator, select your data source, and enter the value 10000000 in the Text size field on the Advanced tab.

If characters such as the ellipsis are being truncated, you should verify that the character set of your driver matches the setting for your database.