Information discordance when using ASE repository
I think many of you already know this problem well.
This is to share the prerequites when using ASE database as a repository with all of you again.
PowerDesigner 188.8.131.5282(32bit) on Windows 7
32bit Proxy server
Repository – ASE 15.0.3 EBF 16549 on Linux
The problem my customer encountered was as below.
1) Create 20 classes and assorciations between classes in a OOM and check it in. (V1)
2) Add 5 classes and assorciations and check it in, too. (V2)
3) Run “Compare with repository” menu, which shows many different objects.
4) When Checking V2 out of the repository, some objects are not shown normally.
So, I conducted some tests by alternating a few conditions and guided them to check “Enable Dynamic Prepare” and specify “Text Size” on ODBC DSN.
All the check-ins & outs were correctly worked from all the tests I’ve done,
The manual below describes a few things to avoid some known issues when installing and running a repository on ASE dataserver.
Specifically, we should confirm the value set in the Text Size parameter for the ODBC DSN.
When PD consolidates (Check In) a document (model), its diagrams, comments, etc. are stored as linked rows in the repository PMTEXT table.
When you extract (Check Out) a document, the linked rows from the PMTEXT table are reconstructed in the ‘Text Size’ parameter.
If the parameter size is too small then information could be truncated. The primary symptom when this occurs is diagrams missing symbols.
This is an ASE ODBC driver issue and no error log information is generated.
When creating a new ASE ODBC DSN, the default value for this parameter is small (32678 bytes). It is recommended to increase this value to 10,000,000. The maximum value for this parameter is 2G.