Working with Data Models › How to Reverse Engineer a Model from a Database or a Script › Troubleshooting

Troubleshooting

This section explains the errors that you can encounter while installing and configuring Mart, and how you can troubleshoot them.

Note: The Mart Server log files are available in the following location:

Windows 7: {user.home}/AppData/Local/erwin Mart Server/logs/application.log

How to Add Naming Standards

Symptom:

How to add naming standards to a reverse engineered model?

Solution:

Follow these steps:

1. Create a model and include the naming standards.
2. Save the model as a template.
3. Select this template in the Match template field of the New Model dialog.

   The naming standards are selected in the new model.

Unable to use a Reserved Word

Symptom:

When I try to reverse engineer from a script, I get the error message, "RES-1:Syntax Error - Line <number>, Offset11 <word>".

Solution:

This error message appears when you use a database-specific reserved word or a keyword. Add the quotation marks (" and ") around the word in the script and then reverse engineer.

Unable to Locate Client Connectivity Software Ora7nt

Symptom:

I am trying to connect to an Oracle 11g database and I am getting the message, "Unable to locate client connectivity software Ora7nt.dll."

Solution:

erwin® Data Modeler is a 32-bit application and requires 32-bit client libraries to connect to the database. The reason for this error is that the application could not find the required Oracle client to connect to the Oracle instance.

Try one of the following solutions:

• Install the Instant client software that is available from Oracle into a directory that does not contain any spaces in the PATH. For example, C:\app\Administrator\Oracle.
• If both 32-bit and 64-bit Oracle clients exist on the same computer, then ensure that the PATH environment variable refers to the 32-bit Oracle client. Include the path "C:\Oracle\product\11.2.0\client_32\" at the beginning of the variable value.