Troubleshooting the Repository Installed on ASE

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

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.

Connection Profile: "Error converting characters into server's character set"

If you receive such a conversion error when working with a connection profile, click the ellipsis button to the right of the Connection parameters field on the Connection Profile Definition dialog, add the CharSet parameter, and enter the appropriate charset value to match your repository database.