Return
-
Title
The query 'select * from er_model_shape' against a large model does not succeed, giving error Cod -
Description
The query 'select * from er_model_shape' against a large model does not succeed, giving error Code HY000 Text [CA][ODBC ERwin Data Modeler driver][OpenAccess SDK SQL Engine]Error initializing the disk cache [10186] -
Resolution
Error Message:
Code HY000
Description:
When running an ODBC query, 'select * from er_model_shape' against large models, it fails giving the following error in the Query Tool.
Code HY000
Text [CA][ODBC ERwin Data Modeler driver][OpenAccess SDK SQL Engine] Error initializing the disk cache [10186]Solution:
1. Create a ‘cache’ folder under C:\Program Files\CA\ERwin Data Modeler r9\OpenAccess\oaserver60\ip\
2. Ensure ‘cache’ folder is writable and ensure there is enough disk space
3. Open oadm.ini (in Notepad) which should be under C:\Program Files\CA\ERwin Data Modeler r9\OpenAccess\oaserver60\cfg4. Add ‘ServiceSQLDiskCacheMaxSize=200’ to the last line.
5. Start ERwin.exe and open the large model.
6. Run select * from er_model_shape with query tool.
6. A temp file is created in the cache folder and the Results field should show the Metadata dataMore Information:
This is a workaround until this is fixed in ODBC driver (by Open Access).