Home

	Expand Search

Adaptive Server Enterprise Monitor Client-Library Programmer's Guide

Appendix D: Troubleshooting Information and Error Messages

Appendix D

This appendix contains two sections.

• "Troubleshooting" lists problems that you may encounter using Monitor Client Library, but that do not have specific error messages.
• "Error Messages" describes error messages that you may receive.

Troubleshooting

Confusing Messages from Adaptive Server

If you create a view that requires information from a database that needs to be recovered, you get error messages from Adaptive Server rather than a concise error message from Monitor Client Library.

View Refreshes Fail

• If you try to refresh a view at the same time as someone creates a database, the refresh may fail.
• A refresh for a view may fail if one or more databases on Adaptive Server are in single user mode.

Negative Numbers as Object Ids

If you create a view using the SMC_NAME_OBJ_ID data item, you might see negative numbers as object IDs. Negative object IDs are an accurate reporting of IDs as assigned by Adaptive Server.

Monitor Server reports on all activity, including activity on temporary tables that Adaptive Server creates to perform a complex query. The object IDs that Adaptive Server assigns to temporary tables can be positive or negative. The object ID that was assigned by Adaptive Server is reported.

In views that show SMC_NAME_OBJ_NAME, the string **TempObject** is reported for temporary tables.

Error Messages

Monitor Client Library is an Open Server application that uses the Open Client Library to communicate with Adaptive Server and Monitor Server. Any of these components can detect and report errors conditions. Monitor Client Library also detects and reports error conditions, which it logs or reports or both to clients.

The following building, linking, and compiling error messages may be reported. They are listed here in alphabetical order.

Communication failure: Check if server is running.

While running testmon.exe, one of the following conditions caused the error to be reported:

• Server names are incorrect in EXAMPLE.H.
• SQL.INI file is missing.
• SQL.INI file has incorrect network connection information.
• Adaptive Server is not running.
• Historical Server is not running.
• User name is incorrectly set in EXAMPLE.H.
• Password for the user name is incorrectly set in EXAMPLE.H.

Configuration failure: Possibly missing interfaces file or bad login parameters.

While running testmon.exe, one of the following conditions caused the error to be reported:

• Server names are incorrect in EXAMPLE.H.
• SQL.INI file is missing.
• SQL.INI file has incorrect network connection information.
• Adaptive Server is not running.
• Historical Server is not running.
• User name is incorrectly set in EXAMPLE.H.
• Password for the user name is incorrectly set in EXAMPLE.H.

Don't know how to build example.h.

While building testmon.exe, one of the following conditions caused the compile error to be reported:

• Project needs to rebuild all dependencies.
• Project's include file path needs the location of the file names.
• Default location would be C:\SYBASE\INCLUDE and C:\SYBASE\MONCLT\SAMPLE.

error L2029: 'SMC_CONNECT' : unresolved external

While building testmon.exe, the following condition caused the link error to be reported:

• smcapi32.lib needs to be included as one of the libraries in which to link. It is located by default in C:\SYBASE\MONCLT\LIB.

error L2029: 'SMC_CREATE_VIEW' : unresolved external

While building testmon.exe, the following condition caused the link error to be reported:

• You need to include smcapi32.lib as one of the libraries in which to link. It is located by default in C:\SYBASE\MONCLT\LIB.

fatal error C1083: Cannot open include file: 'cstypes.h': No such file or directory

While building testmon.exe, one of the following conditions caused the compile error to be reported:

• Project needs to rebuild all dependencies.
• Project's include file path needs the location of the file names.
• Default location would be C:\SYBASE\INCLUDE and C:\SYBASE\MONCLT\SAMPLE.

fatal error C1083: Cannot open include file: 'mcpublic.h': No such file or directory

While building testmon.exe, the following condition caused the compile error to be reported:

• Project's include path for the preprocessor needs to be edited to the correct setting. It is currently set to C:\SYBASE\MONCLT\INCLUDE; C:\SYBASE\INCLUDE;.

LINK: fatal error L4051: smcapi32.lib : cannot find library

While building testmon.exe, the following condition caused the link error to be reported:

• The project's Library File's path needs to include the location of SMCAPI32.LIB, which is assumed to be in C:\SYBASE\MONCLT\LIB.