Trouble Shooting Tips

1. I get the following message when I try to start the server : "Port already in use. Change WebServer port in /conf/server.xml". Why ?
2. When I try to start the server, I get a message reading "Already Server seems to be running". Why ?
3. I have started the server using the batch files/program menu. How do I start the client ?
4. Whenever I start DBChangeManager server, the browser opens to launch the client? Is there a way to disable this default behavior ?
5. When I click on "Login" in the client start up screen, nothing happens and hence I am not able to see the product screens. Why ?
6. The client interface doesn't respond to New Comparison, Synchronization or audit actions. Why ?
7. Even after successful Synchronization, recomparison of the same resources shows the same set of differences in the difference viewer. Why ?
8. When I click on "Stop" as the comparison is in progress, the UI doesn't seem to respond. Why ?
9. Comparison throws a parse error when I load a script file for comparison. Why ?
10. I compared a script file in a comparison project during the previous run of the tool. When I reopen the project, the script is not loaded in the script file field by default. Why ?
11. When the comparison is in progress, the updates seems to freeze for a long time. No further updates seen. Why ?

1. I get the following message when I try to start the server : "Port already in use. Change WebServer port in /conf/server.xml". Why ?
   This message corresponds to a state when the DBChangeManager is unable to start the server at the user configured port number. The default port number used by the tool is 9090. The same can be configured during product install time. As the message indicates, the configured, conflicts with another application using the same port number.
   
   To rectify the above error, you may either have to free that port number and reconfigure the port number to be used to start the tool. As indicated in the message, the port number configuration has to be made in a file named "server.xml" present under "<product_home>/conf" directory. In the specified file, search for the port number and replace the same with another unused port number.
   
   If you change the port number, take care to use the new port in the URL to connect to the DBChangeManager client.
   
   
2. When I try to start the server, I get a message reading "Already Server seems to be running". Why ?
   This message appears if the server is already started and running in an alternate window. You may also cross check for the presence of Tray Icon in the System tray icon (in Windows) to verify the state of the server.
   
   
3. I have started the server using the batch files/program menu. How do I start the client ?
   Please refer to the "Starting the client" document in the help documentation.
   
   
4. Whenever I start DBChangeManager server, the browser opens to launch the client? Is there a way to disable this default behavior ?
   Follow the steps given below to disable default client start up when starting the server (applicable only in windows) :
   
   • Start the server
   • Locate the tray icon in the system tray and left click on the icon.
   • Click on "Auto Start Client Off" menu item to disable client start up when starting the server
   
   
5. When I click on "Login" in the client start up screen, nothing happens and hence I am not able to see the product screens. Why ?
   The Web client interface mandates that Javascript be enabled in your browser to work with the client. Hence ensure you have Javascript enabled in your browser that you are using to connect to the server. How to Enable Javascript in :
   
   • Firefox Browser: Invoke "Tools -> Options" option from the menu. Navigate to the "Content" tab in the popped up dialog and "Check" the option corresponding to Javascript to enable the same.
   • Internet Explorer Browser: Invoke "Tools -> Internet Options" option from the menu. Navigate to the "Security" tab and click on "Custom Level" button. Check the "Active Scripting" option to be Enabled to enable Javascript.
     
     
6. The client interface doesn't respond to New Comparison, Synchronization or audit actions. Why ?
   It is required that the client interface be "Refreshed" (or in other terms "Reloaded") in the browser when the server is shutdown and restarted in the back-end. Hence try refreshing the interface (preferably by pressing the "Shift" key along with the "Refresh" button in the browser window) to ensure that the client is connected to the server. If the server is restarted, you'll have to re-login to proceed with the required operation.
   
   
7. Even after successful Synchronization, recomparison of the same resources shows the same set of differences in the difference viewer. Why ?
   This may happen due to a page reload setting if you are using a Internet Explorer Browser. To resolve the problem, invoke the "Tools -> Internet Options" option menu and navigate to the "Temporary Internet Files -> Settings -> Check for newer versions of stored pages" option. This option should have "Every visit to the page" selected to overcome this error. If not set, choose the same and perform a fresh comparison. If the issue persists, please report to us with your comparison details to support@dbchangemanager.com
   
   
8. When I click on "Stop" as the comparison is in progress, the UI doesn't seem to respond. Why ?
   It is more likely that the comparison operation is already completed in the back-end in this scenario. There is a minimal time difference by the time the updates gets rendered in the client from the moment the response has dispatched by the server. Hence when you activate the button in this scenario, the stop operation becomes invalid.
   
   
9. Comparison throws a parse error when I load a script file for comparison. Why ?
   The tool currently expects that the individual DDL statements be separated by a "GO" statement for successful parsing of the ensure. Hence ensure that all DDL statements are separated by a "GO" statement in the SQL script that is fed for parsing. If the error still persists, please report the problem by attaching the SQL script to support@dbchangemanager.com
   
   
10. I compared a script file in a comparison project during the previous run of the tool. When I reopen the project, the script is not loaded in the script file field by default. Why ?
    Due to browser security limitations, the script files that are used for comparison can be automatically loaded from the system from with in the browser. The same has to be uploaded (by using the browse button) each time the comparison is to be performed using the tool. In some cases however (for instance in a Firefox browser), the last chosen file name is retained in the field which can be used as is.
    
    
11. When the comparison is in progress, the updates seems to freeze for a long time. No further updates seen. Why ?
    When comparing databases, it is possible that the compared database takes time to respond to queries issued by DBChangeManager to fetch the metadata information (due to excessive load on the database server). In such scenarios, you may either either wait for the comparison to complete or reload the client interface (web page) and perform a new comparison.

Note: To enable the same option, invoke the "Auto Start Client On" menu item after starting the server