Install and Configure a Sybase Mart › 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/CA/ERwin Mart Server/logs/application.log

Port out of range

Symptom:

Whenever I connect to the web server, I get the following error message:

java.lang.IllegalArgumentException: port out of range 80821.

Solution:

Type the correct port number in the Configure CA ERwin Mart Administrator’s Server dialog and then restart your web server.

Back to Top

Call failed on the server

Symptom:

When I try to connect to the Mart server, I get the following error:

500 The call failed on the server; see server log for details

Solution:

The probable reasons for this error could be one of the following reasons:

• The server name is not correct.
• The application name is not correct. By default, the application name is MartServer and it is case-sensitive.

Type the correct server name and application name in the CA ERwin Mart Administrator’s Server dialog and the Configure MartServer Details dialog. Restart the web server.

Back to Top

Application Internal Error

Symptom:

When I try to connect to the database, I get the following error:

Application Internal Error

Solution

You get this error when the MartServer application is unable to connect to the required database. The following reasons are probable for this error:

• The database details that are provided in the Configure MartServer Details dialog are incorrect.
• The username and the password for the database are incorrect.
• The database is not present.
• The port number for the database is incorrect.
• The network is down.

Ensure that you enter the correct details of your database in the Mart Server tab of the CA ERwin Mart Configuration dialog.

Back to Top

ORA-12514 TNS listener does not currently know of service requested in connect descriptor

Symptom:

When I try to open the CA ERwin Mart Administrator page, I get the Application Internal Error. The Tomcat windows shows the following error message:

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Solution:

Use a fully qualified instance name when starting the Mart Server.

Back to Top

Mart already exists. Specify another database name

Symptom:

When I try to connect to the Mart, I get the following error message:

An earlier mart is already present in the database you are trying to initialize. This process can not be continued. Please specify another database name to continue.

Solution:

You get this error when you connect to an old Mart that you have used for CA ERwin DM Release r7 series, r8 series, or Beta release of any r9 series release.

Create a database and provide its details in the Configure MartServer Details dialog.

Back to Top

Initialize page is not loading in Internet Explorer

Symptom:

When I type the URL to initialize my Mart in Internet Explorer, the Initialize Mart page is taking a long time to load.

Solution:

The Initialize Mart page does not load because the Active Scripting option in Internet Explorer is disabled.

To enable Active Scripting, follow these steps:

1. In Internet Explorer, click Tools, Internet Options.
2. In the Security tab, click the Custom Level button.

   The Security Settings – Local Intranet Zone window opens.

3. From the list of options, locate Scripting, Active Scripting, and select Enable. Click OK.
4. Restart Internet Explorer and enter the URL to initialize Mart.

   The Mart Initialize page opens.

Back to Top

The Tomcat server is not starting properly. The Configure button is disabled.

Symptom:

My administrator has given me the Administrator rights and when I start the Tomcat server, I get a series of errors. Also, I cannot click the Configure button in the configuration dialog because it is disabled.

Solution:

Right-click Start Server, and click Run as Administrator.

The Tomcat server starts without any error, and the configuration button is enabled.

Back to Top

A connection with the server could not be established

Symptom:

When I try to connect to the web server from CA ERwin Data Modeler, I get the following error message:

A connection with the server could not be established

Solution:

Verify that you have provided the correct port number and then reconnect to the web server.

Back to Top

The server name or address could not be resolved

Symptom:

When I try to connect to the web server from CA ERwin Data Modeler, I get the following error message:

The server name or address could not be resolved

Solution:

Verify that the server name where the web server is installed is correct and then reconnect to the server.

Note: If CA ERwin Data Modeler and the web server are installed on the same computer, you can give the server name as localhost. Suppose that CA ERwin Data Modeler and the web server are installed on different computers. The server name is the name of the computer where the web server is installed.

Back to Top

Invalid user ID or password

Symptom:

When I try to connect to the server, I get the following error message:

Invalid user ID or password. Please try again to login.

Solution:

Type the correct user name and password.

Note: The user must be an application level user and not a database user.

Back to Top

Error 12029

Symptom:

When I connect to the web server, I get the following error message:

Error 12029

Solution:

Restart the web server.

Back to Top

Unable to load the web page from my web browser

Symptom:

When I type the URL in Internet Explorer or Google Chrome to connect to the web server, I get the following error messages:

For Internet Explorer

Internet Explorer cannot display the webpage

For Google Chrome

Oops! Google Chrome could not connect to localhost:18170

Solution:

Restart the web server.

Back to Top

Internet Explorer Redirects to a Different Link

Symptom:

Suppose that I install CA ERwin Mart Server on a fresh machine. If I enable the SSL option and I invoke CA ERwin Mart Administrator, Internet Explorer redirects the page to res://ieframe.dll//.

Solution:

Internet Explorer versions 8 through 10 have a security enhancement that blocks the following types of sites:

• Sites that have self-signed certificates
• Sites that have self-signed certificates where the certificate does not match the URL

Follow any of these steps:

• Install the certificate in the Trusted Root Certification Authorities store.
• Add the site to trusted sites.
• Set the Internet Explorer Security level to Medium Low.

I have a very long Windows user name and I cannot log in to the Mart through CA ERwin Data Modeler

Symptom:

I have added a very long Windows user name similar to "Magdalena.Chalamalasetti" using the Mart Administrator. When the user tries to log in to the Mart through CA ERwin Data Modeler, the name is truncated to "US\Magdalena.Chalamas" and the user cannot log in.

Solution:

The name is truncated due to a limitation with Windows. The Windows API returns the legacy user name that is limited to 20 characters. If the length of a user name exceeds 20 characters, for example, "US\Magdalena.Chalamalasetti", the name is displayed as "US\Magdalena.Chalamas" in the Connect to Mart dialog.

You can resolve this in one of the following ways:

• Type the first 20 characters of the user name when you add the user as a Windows User, in the Mart Administrator. For example, instead of typing "US\Magdalena.Chalamalasetti", type "US\Magdalena.Chalamalas".
• Use a Windows Group instead of the user's domain name. Using your Windows domain controller software, add the user to a Windows Group, and then add the group as a User Group in the Mart Administrator. For more information about how to add a User Group, see CA ERwin Data Modeler r9 Workgroup Edition: Support for Directory Services video.

Sybase Mart Database Memory

Symptom:

You may experience one of the following issues when there is insufficient memory for the Sybase Mart database.

• You cannot save multiple Mart models in a Sybase Mart database.
• When you upgrade a Mart model from 8.x to r9.64 using the upgrade utility for a Sybase database the upgrade process fails.

Solution:

Increase the main memory and procedure cache of the database.

1. Enter the following command to increase the main memory of the database:

   sp_configure "max memory", <memory size>
   

   <memory size>

   Specifies the amount of memory that you need to increase.

2. Enter the following command to increase the procedure cache of the database:

   sp_configure "procedure cache size", <memory size>
   

   <memory size>

   Specifies the amount of memory that you need to increase.

SSL Certificate Error

Symptom:

When you open Mart Administrator from Mart Server that is configured with an SSL certification, an SSL certificate error appears.

Solution:

1. Replace localhost in the Mart Server URL with your computer name.

   https://localhost:12345/MartAdmin/

   https://<computer_name>:12345/MartAdmin/

2. Use the updated URL to access the Mart Server

Unable to save a model to Mart with an existing model name

Symptom:

When you save a model to Mart with an existing model name, a dialog with the following text appears.

Model '<model name>' already exists in library '<mart name>'. Rename the new model name

Solution:

Save the model with a different name.