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\cfg
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\cfg
4. 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 data
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 data
More Information:
This is a workaround until this is fixed in ODBC driver (by Open Access).
Comments
0 comments
Please sign in to leave a comment.