Home

SequeLink Troubleshooting Guide and Reference

Contents

1. 383 The configuration file was changed by someone else Cause The configuration file has been modified by another administrator Action Reload the configuration file and make the changes again 390 Received a request to stop listening ignoring other events on the queue Cause An internal error occurred Action Contact DataDirect Technologies technical support 391 The semaphore operation could not be completed within the timeout period specified Cause An internal error occurred Action Contact DataDirect Technologies technical support 392 Request to send an event failed because there is no listener active on the event queue Cause An internal error occurred Action Contact DataDirect Technologies technical support 393 Request to send an event failed because the event queue is full Cause The service could not send the events to the Event Processor because the event queue was full Action Increase the value for both or either of the ServiceEvQShmQSize and ServiceEvVQShmMaxResend service attributes 394 Request to send an event failed because the event size exceeds the maximum event size Cause The service could not send the event to the Event Processor because the event queue was too small to hold all the attributes of the event Action Increase the value for the ServiceEvVQShmQSize service attribute 395 Request to create an IPC object failed Cause An internal error occurred Action Contact DataDirect Technologies techni
2. 1017 The object is closed Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 1018 0 Cause An unexpected error occurred At runtime an error message from the JDK will be displayed Action Contact DataDirect Technologies technical support 1019 Error attempting to backup position in data stream Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 1020 Error establishing socket 0 Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 1021 Error establishing socket Unknown host 0 Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 2200 Network problem local timeout during session setup connection closed Cause The session connection handshake could not be completed within the time limit set Action Make sure that you are connecting to a SequeLink 5 x Server If the problem persists increase the connection timeout value 2201 Network problem remote timeout during session setup connection closed Cause An unexpected error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 84 Chapter 6 Error Messages 2202 Network resource problem session aborted due to local buffer allocation failure connection closed Cause The SequeLink Client could not allocate internal buffers to r
3. SequeLink Troubleshooting Guide and Reference 86 Chapter 6 Error Messages 2221 Network problem invalid IIOP operation target connection closed Cause The SequeLink service the SequeLink Client is connected to did not accept the IIOP operation target sent Action Contact DataDirect Technologies technical support 2223 Internal network error session aborted due to remote procedure call failure connection closed Cause An internal error occurred Action Contact DataDirect Technologies technical support 2249 Internal network error Cause An internal error occurred Action Contact DataDirect Technologies technical support 2251 Connection closed due to session kill Cause The session was killed on the SequeLink Server The connection was closed Action None 2252 Connection closed due to service shutdown Cause The session was killed on the SequeLink Server because the SequeLink service was shutting down Action None 2253 Connection closed non SequeLink IIOP user exception received Cause An IIOP user exception reply was received from a server that was not a SequeLink Server The session was aborted and the connection was closed Action Contact DataDirect Technologies technical support 2254 Connection closed non SequeLink IIOP system exception received Cause An IIOP system exception reply was received from a server that was not a SequeLink Server The session was aborted and the connection was closed Act
4. 00000 eee eee 22 Starting DataDirect Test 22020000 0 aee 23 Making a DataDirect Test Connection 24 Troubleshooting the NET Data Provider 28 Troubleshooting TCP IP Connection Problems 31 Establishing a TCP IP Connection 00000 ee eee 31 Connection Handshaking 00e eee eee eee 33 SequeLink Troubleshooting Guide and Reference 4 Table of Contents 3 Troubleshooting Your Database Connection Changing the Service Connection Model Connecting with SequeLink Server for ODBC Socket Using the ODBC Socket Service with Connect for ODBC Drivers 2 2 2 00 e eee Using the ODBC Socket Service with IBM DB2 Driver Analyzing ODBC Socket Service Problems Releasing Locks Held by Disassociated DB2 Threads 4 Using Debug Log Files nunnana SequeLink Debug Log Files 0c cece eee SequeLink Server Session Debug Log File SequeLink Service Debug Log File Configuring Logging 00 cece eee eee Configuring Logging Using the SequeLink Manager Snap in adi ikenasca ee tet area Configuring Logging Using the SequeLink Manager Command Line Tool 00 cee eee ee eee Configuring Logging Using the SequeLink Manager for OS 390 00 00 c eee Changing the Debug Log Level for Active Services and Sessions 7 05 04 Se erg etal scien eed awa eae ee
5. CommandPrefix pppppppp used for SubSystem ssss Severity Information Explanation Messages showing information about Subsystem Interface setup where ssss Is the Subsystem Name Pppppppp Is the CommandPrefix System action Not applicable User response None SSI ssss is in use by another SequeLink for OS 390 Severity Error Explanation SequeLink for OS 390 SSI initialization detected an active SSI SSid for the SSID specified in the SYSINI SequeLink Server starts up normally but the command recognition character cannot be used to issue SequeLink commands Change the SYSINI and use an available SSID System action None User response None SSI ssss not associated with SequeLink MVS Severity Error Explanation SubsystemName ssss already in use by another Subsystem SequeLink Troubleshooting Guide and Reference 220 Chapter 8 OS 390 Messages and Descriptions System action None User response Choose another SubsystemName for use by SequeLink VAIC126E Invalid CommandPrefix pppp for Subsystem ssss rc xx reason yy Severity Error Explanation SubsystemName ssss already in use by another Subsystem System action None User response Probably pppp is a subset of an existing CommandPrefix Use MVS DISPLAY OPDATA command to check this Also see the OS 390 CPF macro for rc and reason codes SequeLink Troubleshooting Guide and Reference SMF Interface Messages 221 SMF Interface Messages
6. If the shutdown is Immediate no new connections are allowed to start Existing connections will be terminated in a consistent manner Once you start a Normal shutdown you can overwrite it with an Immediate shutdown Invalid TYPE parameter on CLOSE command Severity Explanation System action User response Error The value of the type parameter in the CNTL CLOSE command is invalid The CNTL CLOSE command is ignored Correct the parameter and issue the command again Taskname xxxxxxxxxx Notified of shutdown Severity Explanation System action User response Trace This is a debugging or trace message Not applicable None SequeLink Troubleshooting Guide and Reference 248 Chapter 8 OS 390 Messages and Descriptions VAISO89I taskname tacbaddr flags coutime service username Severity Information Explanation This message results from a CNTL STATUS command and is always preceded by a VAISO85I message Each line of information includes the fields as titled by the VAISO85 header message Each column provides information about a server task server runtime component or application thread and includes taskname The name of the main line load module server component task or the thread ID of an OS 390 application service task tacbaddr The address of the task s TACB The TACB is the anchoring control block for all server tasks flags A 4 byte set of flags representing th
7. None nnn DB2Thread s released Severity Explanation System action User response Information This is the response from the RRS RELEASE operator command nnn number of DB2 thread s were released None Ttttttttt Logon request from aaa aaa aaa aaa for userid uuuuuuuu Severity Explanation System action User response Information a aa aaa aaa aaa is the client IP address and uuuuuuuu is the userid validated by the SAF OS 390 security system uuuuuuu will be used as Primary Authid for DB2 None SequeLink Troubleshooting Guide and Reference 234 Chapter 8 OS 390 Messages and Descriptions VAIDO651 VAIDO66I VAID0671 VAIDO68W VAIDO69W Ttttttttt Logon request from aaa aaa aaa aaa for userid uuuuuuuu mapped to mapped _user Severity Information Explanation aaa aaa aaa aaa client IP address uuuuuuuu is the userid validated by the SAF OS 390 security system System action mapped_user will be used as Primary Authid for DB2 User response None Ttttttttt Anonymous logon request from aaa aaa aaa aaa mapped to mapped_user Severity Information Explanation aaa aaa aaa aaa is a client IP address System action mapped_user will be used as the Primary Authid for DB2 User response None Ttttttttt Logged off Severity Information Explanation The connection is logged off from DB2 System action DB2 resources are committed User response None Ttttt
8. Processing continues the command is ignored This is an internal error Report this message to DataDirect Technologies technical support Command in command Severity Explanation System action User response Trace The operator interface component of the server system received the specified command from either the operator s console Not applicable None Parse failure on operator command format expected is ROUTID VERB F1 fld F2 fld etc Severity Explanation System action User response Information The operator interface component of the server system received an incorrect command from the operator s console The command received did not follow the expected format The entered command is ignored Check the syntax of the command and reenter the correct command Command indicated an unsupported ROUTE ID Severity Explanation System action User response Information The operator interface component of the server system received an incorrect command from the operator s console The command received contained an invalid route or component ID The entered command is ignored Check the syntax of the command and reenter the correct command Command indicated an unsupported verb verbname Severity Explanation Information The operator interface component of the server system received an incorrect command from the operator s console The command c
9. Cause The SequeLink Client is not compatible with the version of the SequeLink Server to which it is connecting Action Verify that the versions of your SequeLink Client and SequeLink Server are compatible Contact DataDirect Technologies technical support if necessary 5152 You are trying to connect to a server that is not running the correct version of SequeLink Server Cause An attempt was detected to connect to a SequeLink Server running an incompatible version of SequeLink Action Verify that the versions of your SequeLink Client and SequeLink Server are compatible Contact DataDirect Technologies technical support if necessary 5153 The SequeLink Client failed to retrieve the connection parameters from the LDAP server Cause The SequeLink Client failed to retrieve connection information from the LDAP server Action Typically this error is followed by other errors containing more detailed information Use these details to troubleshoot the problem 5154 The TCP IP host was not specified Cause The TCP IP host of the SequeLink Server was not specified in the connection information Action Make sure that the connection information configured at the SequeLink Client specifies the TCP IP host of the SequeLink Server 5155 The TCP IP port was not specified Cause The TCP IP port of the SequeLink Server was not specified in the connection information Action Make sure that the connection information configured at the SequeLink Cli
10. Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5044 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5045 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5046 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5047 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 131 132 Chapter 6 Error Messages 5052 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5058 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5059 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5060 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5061 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5065 An internal error occurred Cause An unexpected error occurred Action Contact DataD
11. Cause The log level name in a SequeLink Manager command that was entered was invalid Action Check the SequeLink Manager command help to verify log level names 5520 Invalid log value lt name gt Cause The value specified with the log level name in a SequeLink Manager command that was entered was invalid Action Check the SequeLink Manager command help to verify log level values 5522 Invalid numeric value lt value gt Cause A value was specified in a SequeLink Manager command that could not be converted to a numeric value Action Specify a valid numeric value for the SequeLink Manager command 5523 AutoSave option is already activated Cause The SequeLink Manager command SaveConfig was issued when the AutoSave setting was activated Action None This message is informational only 5524 Quote mismatch Cause Syntax error No closing quote was typed Action Correct the syntax 5525 System execution returned a non zero return code return code lt value gt Cause An application or operating system command failed The operating system command specified with the command returned a non zero return code Action Refer to the command s documentation typically the operating system command documentation for more information SequeLink Troubleshooting Guide and Reference 144 Chapter 6 Error Messages 5526 Failed to open a pipe to lt application gt Cause A pipe to the specified application could not be opened Action M
12. DB2SQL ssssssssssssssssssssss to be executed Severity Explanation System action User response Trace This messages shows which DB2 StatementType is about to be passed to DB2 None None Tttttttt Abend in DB2 while an ssssssssssssssssssss StatementType is executing Severity Explanation Error Sequelink Server trapped an abend in DB2 This error shows the DB2 StatementType active in DB2 when this event happened onThrdid Tttttttt SequeLink Troubleshooting Guide and Reference 226 Chapter 8 OS 390 Messages and Descriptions System action None User response See the Reason and AbendCode in the VAIDO46E message for more information VAIDO24I UserID Thread Service Plan Net Stat SQLcalls VAIDO25I Severity Information Explanation The following information is displayed when a DB2 STATUS command is issued User D client userid Thread thread number Service service requested by client Plan DB2 plan being used Net network platform TCP or APPC Stat thread status OPEN thread is open DISC thread is disconnected CLOS thread is closed RLSE thread is eligible for release reuse WAIT thread is waiting for an available thread S QLcalls number of SQL calls is issued by the session NOTE This field will always be OPEN if thread management is inactive VAIDO271 Connection to DB2 ssss is ccccc DB2 STOPOPT is 00000 Severity Information Explanation T
13. User response None VAIS235l Free storage below K above K Severity Information Explanation Display free storage available above and below 16 MB This message results from command CNTL LIST TYPE FREE System action None User response None New connections will be refused if free storage drops below SosLimit values See message VAISO18I VAIS246I Time altered from 24 00 00 to xx xx xx date julian date Severity Information Explanation Message to indicate the start of a new day System action None User response None VAIS300I Mgr SQLNK DataDirect xxxx registered Severity Information Explanation SequeLink server is registered to RRS as a ResourceMgr with the name SQLNK DataDirect xxxx where xxxx is the GlobalSubSystemld the server is started with System action Registering to RRS during initialization User response None SequeLink Troubleshooting Guide and Reference VAIS301I VAIS302I VAIS3031 VAIS304I VAIS3051 Server Controller Task Messages 269 Mgr SQLNK DataDirect xxxx unregistered Severity Explanation System action User response Information SequeLink server unregistered from RRS Unregisters from RRS during shutdown None Begin restart Mgr SQLNK DataDirect xxxx Severity Explanation System action User response Information SequeLink server is restarting as a ResourceMgr to RRS Restarting as ResourceMgr during initialization None Incomplete In
14. 7800 SSL Administration request only allowed from localhost Cause An attempt was made to stop a proxy server running on another host Action You cannot stop a proxy server running on another host Stop the proxy server from the host on which it is running 7801 SSL Error while accepting incoming connection on administration port Cause An internal error occurred when trying to stop a running proxy server Action Check the console of the proxy server machine for more detailed error messages If necessary contact DataDirect Technologies technical support 7802 SSL No administration listener started could not stop proxy server Cause An attempt was made to stop a proxy server that has no administration listener started Action Check the AdminPort parameter in the proxy server configuration file 7803 SSL Proxy server with the name lt proxy server name gt already running Cause A remote administration internal error occurred Action Contact DataDirect Technologies technical support 7804 SSL Proxy server with name lt proxy server name gt is not running Cause A remote administration internal error occurred Action Contact DataDirect Technologies technical support 7805 SSL Error while starting proxy server lt proxy server name gt Cause A remote administration internal error occurred Action Contact DataDirect Technologies technical support 7806 SSL Error while stopping proxy server lt proxy server name gt Cause A remot
15. Action Contact DataDirect Technologies technical support 3132 The requested attribute was not found in the server configuration file Cause An internal error occurred Action Contact DataDirect Technologies technical support 3133 The specified attribute ID is not valid Cause An internal error occurred Action Contact DataDirect Technologies technical support 3134 An unexpected duplicate entity was detected Cause An internal error occurred Action Contact DataDirect Technologies technical support 3137 swadm Failed to open the Service Control Manager Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 106 Chapter 6 Error Messages 3138 Failed to open the specified OS service Cause An internal error occurred Action Contact DataDirect Technologies technical support 3139 Failed to create the specified OS service Cause An internal error occurred Action Contact DataDirect Technologies technical support 3140 Failed to delete the specified OS service Cause An internal error occurred Action Contact DataDirect Technologies technical support 3141 Failed to unregister the OS service because it is not stopped Cause An attempt to delete or unregister a service that is still active was detected Action If the SequeLink Manager lists the SequeLink service as inactive the SequeLink service may be in the process of stoppin
16. None VAIDO38W ATTACHMENT RRSAF incompatible with DB2 xxxx CAF substituted Severity Warning SequeLink Troubleshooting Guide and Reference VAIDO391 VAIDO40T VAID041T VAIDO42E VAID043T Explanation System action User response DB2 Application Support Package Messages 229 RRSAF attachment requested see GlobalDB2attachment attribute in DataModel but RRSAF is incompatible with the current DB2 version Use CAF attachment to DB2 Change GlobalDB2attachment to CAF xxxx Waiting for RRS MVS to become active Severity Explanation System action User response Information RRSAF attachment requires RRS to be active Server continues initialization but DB2 services will not be available Either use CAF attachment or activate RRS Tracing Information not documented Severity Explanation System action User response Trace Internal use None None Tracing Information not documented Severity Explanation System action User response Trace Internal use None None ccccccc Command ignored tttttttttttttttttttttttttttttttttt Severity Explanation System action User response Error RRS RELEASE or LIST command has been ignored for reason tttttttttttttttttttttttttttttttttt The command is ignored Correct the command Ttttttttt Corrld cccccc Prim Auth authid User uuuuuuu ACEE aaaaaaaa ActTk tttttt Severity Trace
17. SequeLink Troubleshooting Guide and Reference 179 7440 XA Close failed with return code 0 Cause XA Close failed with the specified return code Action Refer to the X Open XA Specification for more information about the return code 7441 An error occurred while processing the cache of the insensitive scrollable resultset Cause An error occurred while processing the cache of the insensitive scrollable result set Action Contact DataDirect Technologies technical support 7442 FetchSize must be less than maxRowSize Cause FetchSize must be less than maxRowSize Action Check your JDBC application 7443 Method 0 cannot be called when the statement is executed Cause The JDBC driver cannot change the setmaxFieldSize when the statement is already executed Action Check your JDBC application 7444 Value of setMaxFieldSize exceeds maximum limit Cause The value of setMaxFieldSize exceeded the maximum limit To avoid excessive memory use the JDBC driver limits the maximum value of setMaxFieldSize Action If you require higher values contact DataDirect Technologies technical support 7445 Internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 7446 Error occurred while processing transliteration table 0 Cause An error occurred while processing a transliteration table Action Contact DataDirect Technologies technical support SequeLink Tro
18. Severity Fatal Explanation A critical task abended with CompletionCode cc and its restart Count if any is exhausted System action The server abends with abend U146 User response Contact DataDirect Technologies technical support EOT routine for Service service failed Severity Error Explanation The ServiceEotExit that was called during end of task failed System action None User response Check why this routine failed and contact DataDirect Technologies technical support Application nnnnnnnn Status xx Debug y Severity Information Explanation This message is output following a CNTL STATUS SHOWs servicename command The message shows the loadmodule nnnnnnnn information for the specified service System action None User response None CNTL REFRESH command obsolete Severity Error Explanation CNTL REFRESH command no longer supported System action Command is ignored User response None Free storage below ____K above__ K Severity Trace Explanation Display free storage available above and below 16 MB SequeLink Troubleshooting Guide and Reference 268 Chapter 8 OS 390 Messages and Descriptions System action None User response None New connections will be refused if free storage drops below SosLimit values See message VAISO18I VAIS233I1 CNTL LIST command obsolete Severity Information Explanation CNTL LIST command no longer supported System action Command is ignored
19. VAIC300E VAIC301E This section contains OS 390 log messages generated by SMFINTF which handles SMF interface tasks Unable to obtain storage for SMF write Severity Error Explanation GETMAIN failed for SMF record buffer System action SMF record is not written to the SMF dataset User response Report this message to DataDirect Technologies technical support SMF write failed with RC x return code Severity Error Explanation SMFWTM macro failed with the displayed return code System action SMF record is not written to the SMF dataset User response Report this message to DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 222 Chapter 8 OS 390 Messages and Descriptions DB2 Application Support Package Messages VAIDOOOI VAIDO01I VAID003I VAIDO04I This section contains OS 390 log messages generated by DB2ASP modules DB2ASP handles the server DB2 access Successful connection to DB2 ssss Severity Explanation System action User response Information SequeLink or OS 390 is connected to DB2 address space ssss DB2 subsystem ID and ready to accept DB2 session requests None None DB2 ssid initialization completed yyyyy attachment Severity Explanation System action User response Information Initialization to DB2 subsystem completed using either CAF or RRSAF attachment None None DB2 ifid is now active
20. Warning Explanation Thread exceeds its ServiceMaxCPU System action None User response Check why thread exceeds limit specified Thread tttttttt for service sssssss at termid aborted due to CPU time excession Severity Error Explanation Thread exceeded either ServiceThrottle limit or ServiceMaxCPU limit and ServiceRatAction is specified as DIE Either message VAIS211W or VAIS212W proceeds this message System action Thread is aborted User response Check why thread exceeds limit specified Task tttttttt has unexpectedly terminated CC xxxyyy attempting restart reload Severity Error Explanation The parameter defined for DB2INTERFACE in the SYSINI file does not match the value set in the SequeLink startup JCL file RUNSRVR or the DD statement with the value for DB2INTERFACE is missing from the RUNSRVR file System action Task is terminated User response Change the DB2INTERFACE parameter value in the SequeLink startup JCL file RUNSRVR to the value set in the SYSINI file For example if the SYSINI file sets DB2INTERFACE DB2A the RUNSRVR JCL file should have a DD statement similar to the following DB2A DD DSN DSN410 SDSNEXIT DISP SHR DD DSN DSN410 SDSNLOAD DISP SHR SequeLink Troubleshooting Guide and Reference VAIS216F VAIS219E VAIS2201 VAIS229E VAIS230T Server Controller Task Messages 267 Task xxxxxxxx has unexpectedly terminated CC cc restart reload count Exhausted
21. purposes VAILO2Z2W Tnnnnnnn ServiceName Hostname gt ErrorCode lt xxxx gt ErrorMessage lt tttttttttt gt Severity Warning Explanation The explanation depends on the exact nature of the failure System action The system action depends on the exact nature of the failure User response The user response depends on the exact nature of the failure VAILO231 Tnnnnnnn ServiceName Hostname gt ErrorCode lt xxxx gt ErrorMessage lt tttttttttt gt Severity Information Explanation The explanation depends on the exact nature of the failure System action The system action depends on the exact nature of the failure User response The user response depends on the exact nature of the failure SequeLink Troubleshooting Guide and Reference 240 Chapter 8 OS 390 Messages and Descriptions VAILO24T Tnnnnnnn ServiceName Hostname gt ErrorCode lt xxxx gt ErrorMessage lt tttttttttt gt Severity Explanation System action User response Trace The explanation depends on the exact nature of the failure The system action depends on the exact nature of the failure The user response depends on the exact nature of the failure VAIL109T Thrdid tttttttt SAPI passing control to Application Severity Explanation System action User response Trace After the worker thread was initialized control was passed to the application None None VAIL112E Thrdid SAPI control ret
22. 3046 Internal error unable to access the monitor tree Cause An internal error occurred Action Contact DataDirect Technologies technical support 3047 Invalid table type filter is configured Cause The value set for the DataSourceTableTypeFilterList service attribute is not valid Action Specify a valid value for the DataSourceTableTypeFilterList service attribute For information about valid values for SequeLink service attributes refer to the SequeLink Administrator s Guide 3048 Internal error failed to initialize the event trace component Cause The service failed to start because the event trace component did not initialize correctly Action Make sure that m The event trace file is not being used by another application m The directory specified by the ServiceEventTraceLocation service attribute exists and is accessible m There is enough disk space If the problem persists contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 98 Chapter 6 Error Messages 3049 Only select statements are allowed in this read only connection Cause The value for the DataSourceReadOnlly service attribute was set to select and the application tried to execute a statement that was not a Select statement Action Change your application or change the DataSourceReadOnly service attribute to accept statements other than Select statements 3050 Internal error an inval
23. 85 2208 Internal network error session aborted connection closed Cause An internal error occurred Action Contact DataDirect Technologies technical support 2209 Network problem no pending request to cancel Cause An internal error occurred Action Contact DataDirect Technologies technical support 2211 Network problem cancel not possible because session is killed Cause The cancel operation failed because the session was killed on the SequeLink Server The connection was closed Action Contact DataDirect Technologies technical support 2213 Internal network error connection closed because session key not found in remote session list Cause An internal error occurred Action Contact DataDirect Technologies technical support 2215 Network problem cancel failed because all transport channels in use on remote session Cause The cancel operation failed because the previous cancel request did not release all its resources on the SequeLink Server Action Contact DataDirect Technologies technical support 2217 Network problem session aborted due to internal error in remote procedure call connection closed Cause An internal error occurred Action Contact DataDirect Technologies technical support 2219 Network problem invalid IIOP object key connection closed Cause The SequeLink service the SequeLink Client is connected to did not accept the IIOP object key sent Action Contact DataDirect Technologies technical support
24. Cause A stored procedure was executed but the number of parameters did not correspond with the stored procedure definition Action Change the stored procedure statement that executes the stored procedure in your application 3305 SequeLink does not support CLOB BLOB parameters as stored procedure parameters Cause A stored procedure was executed but a CLOB BLOB parameter was detected Action Change the stored procedure in your application 3306 Internal error An invalid OCI handle was passed to the database Cause An internal error occurred Action Contact DataDirect Technologies technical support 3307 Unexpected XA error Cause An Oracle specific XA distributed transaction call failed Action Contact DataDirect Technologies technical support 3308 The specified object does not exist Cause A stored procedure was executed for which no definition was found Action Make sure that the stored procedure you execute exists in the database and that you have the privileges to execute the stored procedure SequeLink Troubleshooting Guide and Reference 113 3309 A filter value is too long Cause The DataSourceSchemafFilterList or DataSourceTableTypeFilterList service attribute contains a value that is too long Action Correct the DataSourceSchemaFilterList or DataSourceTableTypeFilterList service attribute value 3310 An Oracle procedure was created with compilation errors Cause An error was detected in the syntax of the st
25. Cause The specified profile filter is not valid Action Correct the syntax of the profile filter 421 Failed to load profile with ID xxxx Cause An internal error occurred Action Contact DataDirect Technologies technical support 430 Failed to open event trace file because the file version was not recognized Cause An internal error occurred Action Contact DataDirect Technologies technical support 431 Failed to resize the event trace file Cause An attempt to resize the event trace file failed probably because SequeLink Server was restarted with a new value for the ServiceEventTraceSize service attribute that may be too large Action Make sure that there is enough disk space available for the event trace file which can be found at the location specified by the ServiceEventTraceLocation service attribute 432 The request could not be completed because the event trace is in an error state Cause An internal error occurred Action Contact DataDirect Technologies technical support 433 Failed to open the event trace file Cause The event trace file could not be opened during service startup because the SequeLink service was not stopped properly for example because the server machine failed or the SequeLink service was terminated with an operating system command while it was processing events Action Delete the event trace file Then re start the service SequeLink Troubleshooting Guide and Reference 80 Chapter 6 Error
26. Client installation 5302 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 139 5303 Failed to load the transliteration file xxxx Cause The transliteration file xxxx failed to load Action Check your SequeLink Client installation 5304 The transliteration file xxxx is corrupt Cause The transliteration file xxxx is corrupt Action Check your SequeLink Client installation 5305 An internal error occurred Failed to load XlatTransliterator for transliteration table Cause The creation of a transliteration table failed Action Reduce the memory load of the application 5306 An internal error occurred Failed to load IcuTransliterator for codepage Cause The creation of a transliteration code page handled by the ICU failed Action Check the validity of the indicated code pages or encodings 5320 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5321 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5330 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5331 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technol
27. Contact DataDirect Technologies technical support 7365 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 7366 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 7367 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 7368 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 171 7369 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 7370 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 7391 Driver cannot perform requested operation 0 Cause The method 0 is not supported by this version of the JDBC driver Action Verify the method 0 in your JDBC application 7392 Object is closed The JDBC application used an illegal method on a closed object Cause Object is closed The JDBC application used an illegal method on a closed object Action Correct your JDBC application 7393 The value specified for parameter 0 is invalid Cause The value specified for parameter 0 is invalid Action Verify the value of the parameter 0 in your
28. DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 6502 A required output parameter could not be written Cause An internal error occurred Action Contact DataDirect Technologies technical support 6503 A parameter was malformed Cause An internal error occurred Action Contact DataDirect Technologies technical support 6504 An unsupported mechanism was requested Cause An internal error occurred Action Contact DataDirect Technologies technical support 6505 An invalid name was supplied Cause An internal error occurred Action Contact DataDirect Technologies technical support 6506 A supplied name was of an unsupported type Cause An internal error occurred Action Contact DataDirect Technologies technical support 6507 Incorrect channel bindings were supplied Cause An internal error occurred Action Contact DataDirect Technologies technical support 6508 An invalid status code was supplied Cause An internal error occurred Action Contact DataDirect Technologies technical support 6509 A token had an invalid signature Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 157 158 Chapter 6 Error Messages 6510 No credentials were supplied Cause An error occurred during OSLogon processing because the client application did not provide a user name or a user
29. JCAConnection object 4307 Error fetching local transaction object Cause Never generated Action None 4308 Error fetching meta data from resource Cause An error was generated while fetching information needed for the ManagedConnectionMetaData from the JDBC connection used by the resource adapter Action The exception generated by the JDBC connection is chained to this exception Use the method ResourceException getLinkedException to retrieve the exception chained to this exception The message of the chained exception will indicate the cause of the problem 4309 The object is closed Cause An attempt was made to use a JCAConnection object that has already been closed Action Do not use a JCAConnection object after it has been closed 4310 The Connection Factory is invalid Cause An attempt was made to use a Connection Factory object that was not initialized correctly Action Contact DataDirect Technologies technical support A JCAManageConnectionFactory should never create a Connection Factory object that is invalid It is an internal resource adapter error if it does 4311 Can not fetch XAResource Resource adaptor does not support XA Transactions Cause The resource adapter does not support XA Transactions Action Do not use XA Transactions with the resource adapter SequeLink Troubleshooting Guide and Reference 4312 The Managed Connection Factory is invalid Cause A ManagedConnectionFactory was not specified wh
30. NOTE The SequeLink for ODBC Socket Server incurs a performance penalty when setting this workaround so use this workaround only for those applications that need it The workaround can be activated using either of the following methods m By changing the data source definition m By changing the value of the SequeLink DataSourceSOCODBCConnsStr service attribute Changing the Data Source Definition When you enable the workaround in the data source definition all connections that use the data source have the workaround activated even if the connection request does not come from SequeLink Server for ODBC Socket For more information about using ODBC connection strings in the data source definition refer to the SequeLink Developer s Reference On UNIX Edit your ODBC INI or ODBC64 INI file to add the following key and value to the ODBC Data source section WorkArounds 536870912 On Windows NT Windows 200x and Windows XP Edit the ODBC INI section of your registry to add the following key and value to the ODBC Data source section WorkArounds 536870912 SequeLink Troubleshooting Guide and Reference Connecting with SequeLink Server for ODBC Socket 39 Changing the SequeLink Connection String SequeLink Server for ODBC Socket uses a connection string to initiate a connection to an ODBC driver You can change this connection string in the DataSourceSOCODBCConnsStr service attribute using the appropriate SequeLink administration
31. ODBC driver ODBCTest is included in the Microsoft Platform SDK available for download at http www microsoft com msdownload platformsdk setuplauncher htm x o Example is an ODBC C application provided with the ODBC unix Client on UNIX platforms The program is located in the installdir 5_04_00 example directory where installdir is the installation directory of the ODBC Client When you run the executable you are prompted for the ODBC data source name user ID and password Once connected a prompt will appear You can then execute any non parameterized SQL statements SequeLink Troubleshooting Guide and Reference 20 Chapter 1 Troubleshooting Tools Troubleshooting the ADO Data Provider Rowset Viewer is a tool provided by Microsoft that allows you to view and manipulate ADO OLE DB rowsets In addition you can use Rowset Viewer to test ADO and OLE DB methods from the objects supported by the ADO data provider The Rowset Viewer also displays any error information from the data provider For information on using the Rowset Viewer see Rowset Viewer Sample at http msdn microsoft com library default asp url library en us oledb htm samples asp Rowset Viewer is included in the Microsoft Platform SDK available for download at http Awww microsoft com msdownload platformsdk setuplauncher htm SequeLink Troubleshooting Guide and Reference Troubleshooting the JDBC Driver 21 Troubleshooting the JDBC Driver Data
32. Reference 17 Part 1 Troubleshooting This part contains the following chapters m Chapter 1 Troubleshooting Tools on page 19 describes tools that you can use to identify problems for the SequeLink for ODBC driver SequeLink for ADO provider SequeLink for JDBC driver and SequeLink for NET provider m Chapter 2 Troubleshooting TCP IP Connection Problems on page 31 provides information on the types of problems that can occur with TCP IP connections m Chapter 3 Troubleshooting Your Database Connection on page 35 provides information to help you identify the source of connection problem m Chapter 4 Using Debug Log Files on page 43 describes the SequeLink debug log files how to obtain the files and how to set the debug log file options SequeLink Troubleshooting Guide and Reference 18 Part 1 Troubleshooting SequeLink Troubleshooting Guide and Reference 19 1 Troubleshooting Tools This chapter provides information about troubleshooting tools for the SequeLink for ODBC driver the ODBC driver SequeLink for ADO provider the ADO data provider SequeLink for JDBC driver the JDBC driver and SequeLink for NET Client the NET data provider Troubleshooting the ODBC Driver A ODBCTest is a tool provided by Microsoft that allows you to connect to ODBC data sources and execute or manipulate SQL statements using the ODBC API functions ODBCTest also displays any error messages reported by the
33. SequeLink Troubleshooting Guide and Reference 165 6875 Function not available for platform configuration Cause The specified administrative function was not supported for the server operating system Action None 6877 Monitor not available for service lt service name gt Cause Monitoring has not been enabled for this SequeLink service Action Enable a monitoring profile for the service and make sure that the service is active For more information about enabling profiles for a SequeLink service refer to the SequeLink Administrator s Guide 6878 Invalid data source name lt service name gt Cause An invalid server data source name was specified Action Specify a correct server data source name Server data source names are case sensitive For more information about creating server data sources refer to the SequeLink Administrator s Guide 6879 Cannot create a data source for an agent service Cause Server data sources cannot be created for SequeLink Agent services Action Make sure that you are trying to create a server data source for a SequeLink data access service 6880 Only one lt object gt may exist Cause Only one instance of the object may exist Action Contact DataDirect Technologies technical support 6881 Invalid lt object gt Cause An invalid SequeLink service name or server data source name was specified Action Specify a correct SequeLink service name or server data source name 6882 No
34. SequeLink Troubleshooting Guide and Reference 230 Chapter 8 OS 390 Messages and Descriptions Explanation Auth_Signon RRSAF call parameters for connection Ttttttttt System action None User response None VAIDO44T Tracing Information not documented Severity Trace Explanation Internal use System action None User response None VAIDO45T Tracing Information not documented Severity Trace Explanation Internal use System action None User response None VAIDO46T Ttttttttt DB2 abend ReasonCode rrrrrrrr trapped in DB2SQL transformed as SQLCODE 999 to application Severity Trace Explanation DB2 abended with SO4E SO4F abend with reasoncode rrrrrrrr The Unit of Work UOW for connection tttttttt will be rolled back System action The UOW will be rolled back The connection will end User response Refer to the reason code in your DB2 documentation for the recommended user response VAIDO47T Tracing Information not documented Severity Trace Explanation Internal use System action None User response None VAIDO48T Tracing Information not documented Severity Trace SequeLink Troubleshooting Guide and Reference VAIDO50E VAIDO51E VAIDO52E VAID053T Explanation System action User response DB2 Application Support Package Messages 231 Internal use None None Ttttttttt RRS callname ReturnCode rrrrrrrr Severity Explanation System act
35. Settings node SequeLink Troubleshooting Guide and Reference 52 Chapter 4 Using Debug Log Files 4 Select the Logging attribute category it Console D g eee iti Console Root SequeLink 5 4 Manager speed _DataDirect T echnologies com 19997 Ea a Console Root 128 ServiceD ebugLogLevel Integer 3 SequeLink 5 4 Manager speedy na DataDire 423 ServiceE ventT raceSize Integer 1000000 E 9 Connected to SLAgent abe ServiceEventTraceLocation String ust sqlnk54_alph ci ir SequeLink Services H Ry SLAgent active Yj SLDB2 inactive ce By SLinformixS1 4 inactive i Ry SLOracle816 active Eb Q Configuration pi Service Settings l General Advanced 4 Environment Installation paramete Ga Logging H User Security tf 5 Change the properties for the ServiceDebugLogLevel service attribute Selecting all check boxes on the ServiceDebugLogLevel Properties window will log all possible debug information 6 Save the configuration file The change will take effect for all subsequent connections SequeLink Troubleshooting Guide and Reference Configuring Logging 53 xa Configuring Logging Using the SequeLink Manager Command Line Tool Use the SequeLink Manager Command Line Tool command ServiceDebugLogLevel which has the format ServiceDebugLogLevel sdll service name dis disable enall enableall en enable ferr fatalerror off on err
36. Severity Explanation System action User response Information DB2ASP has detected that the previously inactive DB2 system ifid DB2 interface ID has now become active The SequeLink or OS 390 DB2 environment is initialized DB2 session requests will now be permitted DB2 ifid is terminating Severity Explanation System action User response Information DB2ASP has detected that DB2 ifid is about to terminate All current DB2 sessions will be aborted and DB2ASP will proceed according to the SYSINI DB2STOPOPT specification None SequeLink Troubleshooting Guide and Reference VAIDOO5E VAIDOO6I VAIDO07E VAIDOO8E DB2 Application Support Package Messages 223 Connection to DB2 ssss failed R15 X rc RO X reason Severity Explanation System action User response Error Connection to DB2 address space ssss failed rc and reason are the return reason codes for the failure If the error is DB2 inactive DB2ASP will enter a dormant state and wait for DB2 to come back up Any other error causes DB2ASP to terminate with RC 08 Note that this message will a ways be issued when DB2ASP has detected that DB2 has gone inactive and the user wants to maintain the connection to the DB2 address space DB2STOPOPT is LEAVE Situation dependent Waiting for DB2 ssss to become active Severity Explanation System action User response Information DB2ASP is
37. System out println e SequeLink Troubleshooting Guide and Reference Troubleshooting the JDBC Driver 25 The main DataDirect Test window shows the following information m Inthe Connection List box a list of available connections m Inthe JDBC Database scroll box a report indicating whether the last action succeeded or failed m Inthe Java Code scroll box the actual Java code used to implement the last action TIP The DataDirect Test windows contain two Concatenate check boxes Select a Concatenate check box to see a cumulative record of previous actions otherwise only the last action is shown Be aware that selecting Concatenate can degrade performance particularly when displaying large resultSets SequeLink Troubleshooting Guide and Reference 26 Chapter 1 Troubleshooting Tools 3 Select Connection Connect to DB via Data Source DataDirect Test displays the Select A Datasource window gh Select Datasource sqlsrvz000 on bowhead oracle9i on bowhead db2v7mvs on csimvs db2v7 nt on baleen inf92 on pilot sybasel2 on pilot com sun jndi fscontext RefFsCont file c jdbc org sqlsrv2000 on bowhead SequeLink Troubleshooting Guide and Reference Troubleshooting the JDBC Driver 27 4 Select a data source from the Defined Datasources pane In the User Name and Password fields type the required user name and password connection properties then click Connect For information about JDBC connection proper
38. detailed error messages If necessary contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 190 Chapter 6 Error Messages 7771 SSL State error Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7772 SSL Internal error no data to process Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7773 SSL Could not allocate memory for send receive buffer Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7774 SSL Could not start new thread Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7775 SSLIMaximum number of simultaneous connections reached Cannot add connection to connection list Cause The maximum number of connections specified by the MaxConnections parameter in the proxy server configuration file has been reached Action Check the MaxConnections parameter in the proxy server configuration file Increase the value of this parameter if necessary 7776 SSL Can
39. error the network is not reachable from this host Cause Action TCP IP cannot establish a connection with the SequeLink Server host because no route can be found to the network on which the host resides Make sure that m The network configuration is correct m A network route to the SequeLink Server is available m The SequeLink Server is active Try another TCP IP network application to verify whether the server is reachable SequeLink Troubleshooting Guide and Reference 88 Chapter 6 Error Messages 2304 TCP IP error network subsystem down Cause An internal error occurred Action Contact DataDirect Technologies technical support 2305 TCP IP resource problem Cause A network operation failed because TCP IP had insufficient resources Action Check for heavy traffic conditions on the server 2306 TCP IP error connection refused Cause There was no process waiting for connections on the SequeLink Server host at the specified port or the SequeLink Server was experiencing too many simultaneous connection attempts Action Contact DataDirect Technologies technical support 2307 TCP IP error the specified address is already in use Cause TCP IP resource problem A connection failed because all ports were being used Action Re attempt the connection when more network resources are available 2308 TCP IP error connection timed out Cause The connection has been closed because no response was received
40. following errors can occur e Error 2200 The client did not receive a reply from the server within the specified time frame This error occurs only if a connection timeout is specified e Error 2312 A connection was established with the server but no data was received on the server within the keep alive period Increase the keep alive setting on the server SequeLink Troubleshooting Guide and Reference 35 3 Troubleshooting Your Database Connection Some problems occur when the client application attempts to connect to the database This chapter provides information to help you identify the source of this type of connection problem m Changing the Service Connection Model on page 36 describes how to avoid internal errors generated after the connection model of a service has changed m Connecting with SequeLink Server for ODBC Socket on page 37 explains how to identify and troubleshoot connection problems for SequeLink Server for ODBC Socket m Releasing Locks Held by Disassociated DB2 Threads on page 41 helps you to troubleshoot problems that occur when a transaction branch becomes disassociated from the thread of control on a DB2 database SequeLink Troubleshooting Guide and Reference 36 Chapter 3 Troubleshooting Your Database Connection Changing the Service Connection Model When you use the ServiceConnectionModel attribute to change the connection model for a service the SequeLink service someti
41. following section Establishing a TCP IP Connection for more information 2 When this low level TCP IP connection has been established the SequeLink Client exchanges operational parameters or a handshake with the SequeLink service See Connection Handshaking on page 33 for more information This chapter describes situations that may cause TCP IP connections between a SequeLink Client and a SequeLink service to fail See Chapter 6 Error Messages on page 73 for information about the error codes referenced Establishing a TCP IP Connection If you are experiencing problems when a TCP IP connection is made to a SequeLink Server follow these recommendations m If the server host is specified by a symbolic host name instead of an IP formatted address make sure that the host name can be mapped to an IP address Error 2469 indicates that the specified server could not map the server host name to an IP address SequeLink Troubleshooting Guide and Reference 32 Chapter 2 Troubleshooting TCP IP Connection Problems Other TCP IP applications such as ping telnet ftp or traceroute should return similar errors m Confirm that it is possible to make a TCP IP connection with the specified server host using other TCP IP applications such as ping telnet ftp or traceroute if the requested service is available on that host If other TCP IP applications can connect to the server host look for the following problems in Seq
42. i 11 ac eeu soda sade ea ie Gaia dee Message Severity Gos aata dls oh he a a eee Sane ede eae Message Descriptions 0000 cee ee eee SequeLink Troubleshooting Guide and Reference 5 6 Table of Contents 8 9 OS 390 Messages and Descriptions 213 Operator Interface Messages 200ee eee eee 213 SMF Interface Messages 2000 cece eee eee 221 DB2 Application Support Package Messages 222 Multiplatform Log Messages 00ee cece cece 239 Server Controller Task Messages n on nnana anaana 241 Resource Manager MessageS rnaar 276 ThreadPool Task Messages nnna nnana nanan 278 SAS C Runtime Library Messages 281 SequeLink Troubleshooting Guide and Reference Preface This book provides information about error codes and messages that may be generated when you use DataDirect SequeLink from DataDirect Technologies Read on to find out more about SequeLink and how to use this book What Is DataDirect SequeLink DataDirect SequeLink is a middleware product that provides point to point connections from client to server for the latest data access standards including Open Database Connectivity ODBC JDBC ActiveX Data Objects ADO and ADO NET Using This Book This book assumes that you are familiar with your operating system and its commands the definition of directories the management of user accounts and security access a
43. in the proxy server configuration file m Check the DSSPrivateKey parameter in the proxy server configuration file m Check the PassPhrase parameter in the proxy server configuration file 7940 SSL A ciphersuite that requires an RSA certificate and a ciphersuite that requires a DSS certificate cannot be supplied at the same time Cause An attempt was made to start the proxy server with a cipher suite list that contains both cipher suites which require an RSA certificate and cipher suites which require a DSS certificate It is not possible to mix both families of cipher suites Action Check the CipherSuites parameter in the proxy server configuration file SequeLink Troubleshooting Guide and Reference 7942 203 SSL A ciphersuite requires a DSS certificate that was not supplied Cause An attempt was made to start the proxy server with a cipher suite list that contains a cipher suite which requires a DSS certificate but no such certificate file has been specified Action m Check the CipherSuites parameter in the proxy server configuration file m Check the DSSCertificate parameter in the proxy server configuration file 7943 SSL JA ciphersuite requires a DSS privatekey that was not supplied Cause An attempt was made to start the proxy server with a cipher suite list that contains a cipher suite which requires a DSS private key but no such private key file has been specified Action m Check the CipherSuites
44. log level for active services and sessions when a monitoring profile is enabled UNIX m If you change the debug log level for an active service the change becomes effective immediately but reverts to its original setting when the service is next restarted m If you change the debug log level for an active session the change becomes effective immediately but expires when the session ends Changing the Debug Log Level for an Active Service When a monitoring profile is enabled you can change the debug log level for an active service The change is effective immediately but reverts to its original setting when the service is next restarted Ka Changing the Debug Log Level for an Active one S Service Using the SequeLink Manager Snap in 1 Using the SequeLink Manager Snap in right click the service for which you want to change the debug log level and select Properties 2 Click the Debug Log Level tab and change the debug log level by selecting one or multiple check boxes For more information about using the SequeLink Manager Snap in refer to the SequeLink Administrator s Guide SequeLink Troubleshooting Guide and Reference Changing the Debug Log Level for Active Services and Sessions 57 Changing the Debug Log Level for An Active Service Using the SequeLink Manager Command Line Tool Use the SequeLink Manager command ServiceActiveDebugLogLevel which has the format ServiceActiveDebugLogLevel sadll service
45. message For example DDTek SequeLink SequeLinkException Oracle ORA 00942 table or view does not exist Use the native error code to look up details about the possible cause of the error For these details refer to your database documentation SequeLink Troubleshooting Guide and Reference 72 Chapter5 Overview of SequeLink Error Codes and Messages SequeLink Troubleshooting Guide and Reference 73 6 Error Messages This chapter lists in numerical order error messages you may receive while using SequeLink Each error message is followed by a description of the error and recommended actions if applicable 351 Error detected while processing an administration request Cause An administration request could not be processed by the server Action Preceding or subsequent messages contain more detailed information 352 Error detected while processing an administration request Cause An administration request could not be processed by the server Action Preceding or subsequent messages contain more detailed information 353 Memory allocation failed while processing an administration request Cause A request to the operating system to allocate memory for the SequeLink Server failed Action Free memory resources If the problem persists contact DataDirect Technologies technical support 354 An invalid argument is passed to an administration function Cause An internal error occurred Action Contact DataDirect Technologies
46. name dis disable enall enableall en enable ferr fatalerror off on err errors off on war warnings off on info informationals off on debug debugging off on sspp ssppackets off on sspr ssprequests off on we u where service _ name is the active service for which you want to display or change debug log levels Service names can be obtained using the ServiceList s command The following example turns on debug messages and turns off error messages in the debug log for the SLOracle8 data access service sadll SLOracle8 debug on err off For more information about using the SequeLink Manager Command Line Tool refer to the SequeLink Administrator s Guide SequeLink Troubleshooting Guide and Reference 58 Chapter 4 Using Debug Log Files Changing the Debug Log Level for an Active Session When a monitoring profile is enabled you can change the debug log level for an active session The change is effective immediately but expires when the session ends xA Changing the Debug Log Level for an Active UNIX 1 sr Session Using the SequeLink Manager Snap in Using the SequeLink Manager Snap in select the service that owns the session for which you want to change the debug log level Select the Monitor node Select the Active Sessions node Right click the session for which you want to change the debug log
47. name for your SequeLink service 6902 Service lt service name gt is already started Cause An attempt was made to start a SequeLink service that was already started Action None 6903 Service lt service name gt is not active Cause The specified SequeLink service is not active Action None 6904 No monitor profile available for service lt service name gt Cause The specified SequeLink service does not have monitoring enabled Action Enable a monitoring profile for the SequeLink service For more information about enabling monitoring profiles refer to the SequeLink Administrator s Guide SequeLink Troubleshooting Guide and Reference 169 6905 A monitor profile already exists for service lt service name gt Cause The specified SequeLink service already has monitoring enabled Action None 6906 No event log profile available for service lt service name gt Cause The specified SequeLink service does not have event tracing enabled Action Enable an event tracing profile for the SequeLink service For more information about enabling profiles for SequeLink services refer to the SequeLink Administrator s Guide 6911 The default data source for service lt service name gt may not be destroyed Cause An attempt to delete the default server data source was detected The default server data source for the specified SequeLink service cannot be deleted Action None 6912 Unable to find a default data source for s
48. not start Action Make sure that the value of the ServiceMinThreads service attribute is at least 6 3017 Error writing to trace file Cause No data can be written to the session debug log file probably because the file system is full Action Remove old files on the full file system 3021 Internal error unable to load the server configuration file Cause An internal error occurred Action Contact DataDirect Technologies technical support 3025 Internal error unable to locate settings for service xxxx in the server configuration file xxxx Cause An internal error occurred Action Contact DataDirect Technologies technical support 3043 Internal error event trace information is not available from a service with a process based connection model Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 97 3044 The configured debug log path for the service is not valid Cause The directory specified by the ServiceDebugLogPath service attribute is not accessible Action Make sure the specified directory exists and is accessible 3045 The server listener component ran out of network resources Cause The SequeLink Server was unable to accept a new connection request because of insufficient network resources The SequeLink Server will wait 1 second before accepting new SequeLink Client connections Action Re attempt the connection
49. operator s specifications stated in the CNTL ALTER command None Service is currently Unavailable Severity Explanation System action User response Information This message follows messages VAIS1811 1821 1831 if the status of the service is stopped None None XXXXXXXX Thread for User uuuuuuuu with Thrdid tttttttt at termid purged due to timeout Severity Explanation System action User response Error Thread exceeded Idletime None None Start thread request for service name from user ID at terminal ID rejected Severity Explanation System action User response Error A request to establish a connection to the OS 390 server from the stated user at the stated terminal was rejected This message is always followed by another VAIS20xE message that supplies the reason for the rejection The connection request is rejected Check the subsequent VAIS20xE messages relating to the given user and terminal and respond accordingly SequeLink Troubleshooting Guide and Reference 264 Chapter 8 OS 390 Messages and Descriptions VAIS201E VAIS202E VAIS206S VAIS207T Unknown service name Severity Explanation System action User response Error A request to establish a connection to the server from a specific user at a specific terminal was rejected because the service that was specified in the connection request was not known to the OS 39
50. parameter in the proxy server configuration file m Check the DSSPrivateKey parameter in the proxy server configuration file 7944 SSL JA ciphersuite requires an RSAA certificate that was not supplied Cause An attempt was made to start the proxy server with a cipher suite list that contains a cipher suite which requires an RSA certificate but no such certificate file has been specified Action m Check the CipherSuites parameter in the proxy server configuration file m Check the RSACertificate parameter in the proxy server configuration file 7945 SSL JA ciphersuite requires an RSA privatekey that was not supplied Cause An attempt was made to start the proxy server with a cipher suite list that contains a cipher suite which requires an RSA private key but no such private key file has been specified Action m Check the CipherSuites parameter in the proxy server configuration file m Check the RSAPrivateKey parameter in the proxy server configuration file SequeLink Troubleshooting Guide and Reference 204 Chapter 6 Error Messages 7946 SSL An unnecessary RSA certificate was supplied Cause An attempt was made to start the proxy server with an RSA certificate but SSL is not enabled or no cipher suite from the specified cipher suite list requires an RSA certificate Action m Check the Network parameter in the proxy server configuration file m Check the CipherSuites parameter in the proxy server configura
51. password and the application disabled prompting for this information Action Make sure the connection information provided by the application contains all required attributes 6511 No context has been established Cause An internal error occurred Action Contact DataDirect Technologies technical support 6512 A token was invalid Cause An internal error occurred Action Contact DataDirect Technologies technical support 6513 A credential was invalid Cause An internal error occurred Action Contact DataDirect Technologies technical support 6514 The provided credentials have expired Cause An error occurred during authentication processing because the password for the specified user has expired Action Update the password on the server host 6515 The context has expired Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 159 6516 A generic error occurred Minor MGGS state is xxxx Cause An error occurred during authentication processing The accompanying error message which is different from the text above indicates the exact nature of the problem for example User not found or Invalid password provided Action Make sure that the logon information provided by your client application is correct 6517 The quality of protection requested could not be provided Cause An internal error occurred Action Co
52. profile Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 110 Chapter 6 Error Messages 3186 Failed to open the Service Control Manager The SequeLink Administrator has not enough privileges to create delete a service Cause The operating system requires processes that must have administrator privileges for starting and deleting services Action Ask your security administrator to grant sufficient privileges 3201 Unable to retrieve error message from backend ODBC driver Cause An internal error occurred Action Contact DataDirect Technologies technical support 3202 3202 Unable to retrieve warning message from backend ODBC driver Cause An internal error occurred Action Contact DataDirect Technologies technical support 3203 Required user name is missing Cause The SequeLink service has been configured to require a database user name but the SequeLink Client did not provide a database user name Action Make sure that all required connection attributes are specified 3204 Select statement not allowed in batch processing Cause A Select statement was detected in a batch of statements Action Change your application so that Select statements are not included in the batch 3208 Unable to retrieve the code page from IBM DB2 UDB Cause The SequeLink server could not retrieve the code page from IBM DB2 UDB during the connection setup Ac
53. server configuration file m Check the DSSPrivateKey parameter in the proxy server configuration file 7950 SSL An unnecessary value for the UsePassPhraseDialog was supplied Cause The proxy server is started without SSL enabled or only anonymous cipher suites therefore a pass phrase does not need to be supplied Action m Check the UsePassPhraseDialog parameter in the proxy server configuration file m Check the Network parameter in the proxy server configuration file m Check the CipherSuites parameter in the proxy server configuration file 7951 SSL An unnecessary pass phrase was supplied Cause The proxy server is started without SSL enabled or only anonymous cipher suites therefore a pass phrase does not need to be supplied Action Check the PassPhrase parameter in the proxy server configuration file m Check the Network parameter in the proxy server configuration file m Check the CipherSuites parameter in the proxy server configuration file 7952 SSL You cannot use PassPhrase and UsePassPhraseDialog together Cause The pass phrase required to decrypt the private key from the proxy server is specified in the proxy server configuration It is unnecessary to prompt the user using a dialog box or the console for the pass phrase Action m Check the UsePassPhraseDialog parameter in the proxy server configuration file m Check the PassPhrase parameter in the proxy server configuration file SequeL
54. service is shutting down connection closed Cause The requested session was not accepted because the service was shutting down Action None 2403 Network resource problem session refused connection closed Cause The SequeLink Server failed to allocate a network resource Action Check for heavy traffic conditions on the server 2404 Session refused by service connection closed Cause The server process was unable to accept the connection request Action Check the service debug log file or event trace file for details 2405 Network resource problem session refused connection closed Cause The SequeLink Server failed to allocate a network resource Action Check for heavy traffic conditions on the server SequeLink Troubleshooting Guide and Reference 91 2406 Session refused service process could not be spawned connection closed Cause The service process launch failed Action Check the service debug log file or the system log facility for the specific problem 2450 Invalid host no leading blanks allowed Cause The specified host name starts with a blank character Blank characters including leading or trailing blanks are not allowed in the host name Action Specify the correct host name making sure not to include a blank character at the beginning of the name 2451 Invalid port no trailing blanks allowed Cause The specified port ends with a blank character Blank characters including leading or traili
55. the following format DataDirect ODBC SequeLink driver message For example DataDirect ODBC SequeLink driver Invalid precision specified The native error code is always zero 0 If you receive this type of error check the last ODBC call your application made Contact your ODBC application vendor or refer to the ODBC documentation available from Microsoft The ODBC 3 0 Software Development Kit and Programmer s Reference is available from Microsoft Press For information on later versions of ODBC refer to the documentation included in the ODBC SDK SequeLink Client Errors An error generated by the ODBC Client has the following format DataDirect ODBC SequeLink driver SequeLink Client message SequeLink Troubleshooting Guide and Reference ODBC Driver 65 For example DataDirect ODBC SequeLink driver SequeLink Client The specified transliteration module is not found Use the native error code to look up details about the possible cause of the error See Chapter 6 Error Messages on page 73 for a list of all error codes and messages SequeLink Server Errors An error generated by SequeLink Server has the following format DataDirect ODBC SequeLink driver SequeLink Server message For example DataDirect ODBC SequeLink driver SequeLink Server Only Select statements are allowed in this read only connection Use the native error code to look up details about the possible cause
56. these recommendations m You may have specified a TCP IP port that is not used by a SequeLink service If the specified port is serviced by a SequeLink Server of an earlier incompatible version SequeLink 4 x the following errors can occur Error 2200 The client did not receive a reply from the server within the specified time frame This error occurs only if a connection timeout is specified Error 2300 The server closed the transport connection If the specified port is serviced by a server that is not a SequeLink server the following errors can occur Error 2200 The client did not receive a reply from the server within the specified time frame This error occurs only if a connection timeout is specified Error 2300 The server closed the transport connection Error 2310 The server went down while trying to process the handshake request The connection was closed Error 2315 The server received the handshake request and returned a non llOP reply that the client could not understand SequeLink Troubleshooting Guide and Reference 33 34 Chapter 2 Troubleshooting TCP IP Connection Problems m You may be connecting with a previous incompatible version of the SequeLink Client SequeLink 4 x to a SequeLink 5 4 Server e The client receives an error message that informs you that the server has closed the connection during the initial handshake e If the specified port is serviced by a SequeLink 5 4 Server the
57. time library SequeLink Troubleshooting Guide and Reference 210 Part 3 OS 390 Log Messages and Reference SequeLink Troubleshooting Guide and Reference 211 7 Overview of OS 390 Log Messages This chapter describes how OS 390 log messages are organized and formatted including m Message categories m Severity ratings m Message descriptions Message Categories The messages written to the primary and secondary log files can be generated by SequeLink Server or by the SequeLink Server DB2 service Some messages provide information about events in various parts of the system others report where errors have occurred OS 390 log messages are divided into sections and organized into the following message categories Operator Interface messages SMF Interface messages DB2 Application Interface messages Multiplatform messages Server controller messages ThreadPool Interface messages Resource Manager messages SequeLink errors are not logged in the log files See Chapter 5 Overview of SequeLink Error Codes and Messages on page 63 SequeLink Troubleshooting Guide and Reference 212 Chapter 7 Overview of OS 390 Log Messages for more information about SequeLink Error Codes and Messages Message Severity OS 390 log messages have six severity levels These severity levels listed in order of least severe to most severe are Information Trace Warning Error Severe Fatal Message Descriptions Each OS 390 log
58. to SequeLink services on UNIX or OS 390 SequeLink Troubleshooting Guide and Reference 60 Chapter 4 Using Debug Log Files For more information about using the SequeLink Manager Command Line Tool refer to the SequeLink Administrator s Guide Multi Platform Log Messages Some log messages are not platform specific This type of message is generated by a Service Task and begins with a service name and in some cases a thread ID The message continues with a specific error code and message See Chapter 6 Error Messages on page 73 for the details about the error code The following examples show the general format of this type of log message Tnnnnnnn ServiceName Hostname gt ErrorCode lt xxxx gt ErrorMessage lt tttttttttt gt Severity The severity depends on the situation Explanation The explanation of the failure depends on the exact nature of the failure System action The system action depends on the exact nature of the failure User response The user response depends on the exact nature of the failure lt service name gt lt hostname gt ErrorCode lt xxxx gt ErrorMessage lt text gt Severity The severity depends on the situation Explanation This is a general error message System action The operation fails User response The user response depends on the exact nature of the failure SequeLink Troubleshooting Guide and Reference 61 Part 2 Error Codes and Messages This part contai
59. unexpected error occurred while accessing the transliteration table Action Contact DataDirect Technologies technical support 1011 Character set 0 not found in com ddtek util transliteration properties Cause The SequeLink Server uses a Code page that is currently not supported by the SequeLink Client Action Contact DataDirect Technologies technical support 1012 IO Error creating temp file 0 Cause An unexpected error occurred while creating a temporary file Action Check the 1O exception 0 for more information If necessary contact DataDirect Technologies technical support 1013 IO Error writing temp file 0 Cause An unexpected error occurred while writing a temporary file Action Check the 1O exception 0 for more information If necessary contact DataDirect Technologies technical support 1014 IO Error reading temp file 0 Cause An unexpected error occurred while reading a temporary file Action Check the 1O exception 0 for more information If necessary contact DataDirect Technologies technical support 1015 IO Error reading temp file 0 Cause An unexpected error occurred while reading a temporary file Action Check the 1O exception 0 for more information If necessary contact DataDirect Technologies technical support 1016 Error fetching data from temp buffer Cause An unexpected error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 83
60. unsupported version of the SequeLink Client Action Upgrade the SequeLink Client to Version 5 4 or higher If the problem persists contact DataDirect Technologies technical support 3101 Error detected while processing an administration request Cause The administration request could not be processed by the SequeLink Server Action Preceding or subsequent messages contain more detailed information 3102 An invalid argument was detected while processing an administration request Cause An internal error occurred Action Contact DataDirect Technologies technical support 3103 Unexpected error detected while processing an administration request Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 103 3104 The requested administration function is not implemented on this platform Cause An internal error occurred Action Contact DataDirect Technologies technical support 3105 Memory allocation failed while processing an administration request Cause A request to the operating system to allocate memory for the SequeLink Server failed Action Free memory resources If the problem persists contact DataDirect Technologies technical support 3106 A collection library function failed while processing an administration request Cause An internal error occurred Action Contact DataDirect Technologies technical support 3107 An operation on th
61. waiting for DB2 ssss to become active Issued after message VAIDOOS5E when the error was DB2 inactive DB2ASP enters a dormant state and waits for DB2 ssss to become active Start up DB2 address space ssss Disconnection to DB2 ssss failed R15 X rc RO X reason Severity Explanation System action User response Error Disconnection from DB2 address space ssss failed rc and reason are the return reason codes for the failure DB2ASP continues but this may be a serious error Contact DataDirect Technologies technical support Datamodel aaaaaaaaaaaaaaaa syntax error Severity Explanation Error Required Datamodel attribute for this DB2 root task is missing or has a syntax error aaaaaaaaaa describes the attribute SequeLink Troubleshooting Guide and Reference 224 Chapter 8 OS 390 Messages and Descriptions VAIDO10E VAIDO11E VAIDO12E System action No attachment is set up to the corresponding DB2 subsystem User response Correct or supply missing attribute in the DataModel and restart the server Abnormal termination detected in DB2 ifid thread manager DB2ASP terminating Severity Error Explanation The DB2ASP thread manager VAICDB2T of DB2 interface ifid abnormally terminated System action DB2ASP terminates with RC 08 User response Contact DataDirect Technologies technical support Setup ContextCleanup Problem ttttttttttttttt Severity Err
62. you specified was too long Action Change the column value in your application 3427 No row for parameter in SYSIBM SYSPARMS Cause SYSIBM SYSPARMS contains a row for each parameter of a stored procedure SequeLink could not find a row for at least one of the parameters Action Check your procedure definition Re issue the call procedure If the problem persists contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 121 3428 Procedurename specified too long Cause The length of the unqualified name of a stored procedure cannot exceed 18 characters Action Correct the name of the stored procedure and re issue the catalog statement 3429 Procedure parameter name specified too long Cause The length of the name of a stored procedure parameter cannot exceed 18 characters Action Correct the name of the stored procedure parameter and re issue the catalog statement 3430 A valid database context could not be found Cause A valid database context could not be found Action Contact DataDirect Technologies technical support 3431 A database context could not be created Cause A database context could not be created Action AVAIDO50E message is generated and written to the service debug log Contact your system administrator 3432 The database context could not be added to the context pool Cause The database context could not be added to the context pool because no virtual storage
63. your application SequeLink Troubleshooting Guide and Reference 133 134 Chapter 6 Error Messages 5107 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5108 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5109 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5110 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5111 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5112 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5113 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5150 You cannot connect to a server that is not a SequeLink Server Cause An attempt was detected to connect to a server that is not a SequeLink Server Action Make sure that the connection information configured at the SequeLink Client is specified correctly to connect to the SequeLink Server SequeLink Troubleshooting Guide and Reference 135 5151 A protocol error occurred during the connection setup
64. 0 server This message is always preceded by a VAIS200E message which denotes the user and terminal who made the request The connection request is rejected Check the connection string that is being used at the specified terminal Correct it and retry your connection request Refer to SequeLink Administrator s Guide for details about the link parameters required when connecting to an OS 390 server using each of the different network protocols supported Security Enabled in STRTTHRD no longer supported Severity Explanation System action User response Error Internal error The connection is rejected Contact DataDirect Technologies technical support VAIGM failure insufficient storage Severity Explanation System action User response Severe A request to establish a connection to the server from a specific user at a specific terminal was not satisfied due to an internal error in the server s start thread process The connection request is rejected Contact DataDirect Technologies technical support Have a listing of the current server SIL ready to review This error could be caused by an incorrect update to a DSASIZE parameter ESTAEX recovery for nnnnnnnn setup Severity Explanation Trace ESTAEX recovery is activated on Workerthread nnnnnnnn SequeLink Troubleshooting Guide and Reference VAIS2081 VAIS209T VAIS211W System action User response Server Contro
65. 005 Invalid column name 0 Cause The specified column 0 was not found An invalid column name was specified Action Check your JDBC application 6006 Column index 0 is out of range Cause Your JDBC application specified a column index 0 that is out of bounds Action Check your JDBC application 6007 ResultSet can not re read row data for column 0 Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 6008 Unsupported data conversion Cause The requested data conversion is not supported by this version of the JDBC driver Action Verify the requested conversion in your JDBC application 6009 Object has been closed Cause Object is closed The JDBC application used an illegal method on a closed object Action Correct your JDBC application 6010 Invalid parameter binding s Cause The parameter must be registered prior to getXXX Action Correct your JDBC application SequeLink Troubleshooting Guide and Reference 147 6011 Invalid call Statement method 0 Cause The methods on Statement that have a SQL statement as parameter like execute sql and addBatch sql are not supported on PreparedStatements Action Check your JDBC application 6012 No ResultSet set was produced Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 6013 No rows affected Cause The statement did not generate a row count executeUpdate cannot be use
66. 16 Chapter 6 Error Messages 3329 Invalid configuration SequeLink service ServiceCodePage Database is not supported for Oracle 8 0 Cause Unsupported configuration Action Check your current configuration SequeLink Server for Oracle 8 0 only supports the value Default or OS for the setting seviceCodePage 3330 The Oracle datatype XMLTYPE is not supported Please convert the XMLTYPE to a string or clob Cause SequeLink does not support the Oracle data type XMLTYPE Action Use the Oracle DBMS packages to convert the XMLTYPE to a string or CLOB 3331 The resultset contains an unsupported Oracle datatype Cause The resultset contains an unsupported data type resulting in unsupported behavior Action Check the Oracle data types in your resultset Refer to the SequeLink Developer s Reference for the Oracle data types that SequeLink supports 3332 Invalid configuration SequeLink service ServiceCodePage Database is not supported for Oracle 8 0 Cause Unsupported configuration Action Check your current configuration SequeLink Server for Oracle8 0 supports only the values Default or OS for the attribute ServiceCodePage 3333 Unsupported behavior for this SequeLink Server version Cause Searching a CLOB with a CLOB locator as search argument is not supported Action None 3401 The database does not support catalogs Cause An attempt was made to use a catalog but the database does not support catalogs A
67. ADO provider SequeLink Client message For example DataDirect SequeLink ADO provider SequeLink Client Memory allocation error occurred Use the native error code to look up details about the possible cause of the error See Chapter 6 Error Messages on page 73 for a list of all error codes and messages SequeLink Server Errors An error generated by SequeLink Server has the following format DataDirect SequeLink ADO provider SequeLink Server message For example DataDirect SequeLink ADO provider SequeLink Server Only Select statements are allowed in this read only connection Use the native error code to look up details about the possible cause of the error See Chapter 6 Error Messages on page 73 for a list of all error codes and messages SequeLink Troubleshooting Guide and Reference 68 Chapter5 Overview of SequeLink Error Codes and Messages Database Errors An error generated by the database has the following format DataDirect SequeLink ADO provider message For example DataDirect SequeLink ADO provider Oracle ORA 00942 table or view does not exist Use the native error code to look up details about the possible cause of the error For these details refer to your database documentation JDBC Driver The SequeLink for JDBC driver reports errors to the calling application by returning SQLExceptions Errors can be generated by the following components m JDBC
68. Check the SequeLink Manager command help to verify the command parameter SequeLink Troubleshooting Guide and Reference 141 5506 Failed to open file lt file name gt Cause The specified file could not be opened Action Make sure that the specified file exists If it does make sure that you have sufficient privileges to open and read the file 5507 Argument out of range Cause A parameter for a SequeLink Manager command was too long Action Check the SequeLink Manager command help to verify the command parameter 5508 Required parameter lt name gt for command not specified Cause A required parameter for the SequeLink Manager command was not specified Action Check the SequeLink Manager command help to verify the required parameters for the command 5509 Command not available for current configuration Cause The SequeLink Manager command entered is not supported for the current configuration Action Check the SequeLink Manager command help to verify the command 5510 Failed to display help item Cause SequeLink Manager help could not be displayed for the specified command This is an internal error Action Contact DataDirect Technologies technical support 5511 No configuration opened Cause A SequeLink Manager command was entered that required an open configuration Action Check the SequeLink Manager command help to verify the command SequeLink Troubleshooting Guide and Reference 142 Chapter 6 Error Messag
69. DataDirect SequeLink Troubleshooting Guide and Reference June 2003 De 2003 DataDirect Technologies All rights reserved Printed in the U S A DataDirect DataDirect Connect and SequeLink are registered trademarks and Client Server MiddleWare DataDirect Connect Integrator DataDirect jXTransformer DataDirect Reflector DataDirect SequeLink Integrator DataDirect Spy DataDirect Test and SupportLink are trademarks of DataDirect Technologies Java Java Naming and Directory Interface and JDBC are registered trademarks of Sun Microsystems Inc in the United States and other countries DataDirect Technologies is independent of Sun Microsystems Inc All other trademarks are the property of their respective owners DataDirect products for UNIX platforms include ICU Copyright c 1995 2001 International Business Machines Corporation and others All rights reserved Permission is hereby granted free of charge to any person obtaining a copy of this software and associated documentation files the Software to deal in the Software without restriction including without limitation the rights to use copy modify merge publish distribute and or sell copies of the Software and to permit persons to whom the Software is furnished to do so provided that the above copyright notice s and this permission notice appear in all copies of the Software and that both the above copyright notice s and this permission notice appe
70. Direct Test is a tool that is included in the SequeLink package It allows you to test and learn the JDBC API and contains a tutorial that takes you through a working example of its use DataDirect Test contains menu selections that correspond to specific JDBC functions for example connecting to a database or passing a SQL statement It allows you to m Execute a single JDBC method or execute multiple JDBC methods simultaneously so that you can easily perform some common tasks such as returning result sets m Display the results of all JDBC function calls in one window while displaying fully commented Java JDBC code in an alternate window This section introduces DataDirect Test and describes how to use it to test JDBC connections Refer to the SequeLink Developer s Reference for information on additional features of DataDirect Test and a tutorial that takes you through a working example of its use SequeLink Troubleshooting Guide and Reference 22 Chapter 1 Troubleshooting Tools Configuring DataDirect Test The default DataDirect Test configuration file is installdir jdbctest Config txt where installdir is the installation directory of the JDBC Client You can customize this file for your environment using any text editor All parameters in the DataDirect Test configuration file can be customized but the most commonly configured parameters are Drivers A list of colon separated JDBC driver classes DefaultDriver The d
71. INFORMIXSERVER environment variables in the DataSourceINFInformixDir and DataSourcelNFInformixServer service attributes 3515 Database name not specified Cause A connection was attempted without specifying a valid database name Action Check the connection settings and make sure a valid database name is passed to the server 3516 Stat ClsDb Commit Rollback functions not allowed for execution Cause An attempt was made to execute the native Informix transaction functions Action Use only the SequeLink Client s transaction functions for transaction handling 3517 Prepared statement is not described by Informix Cause An internal error occurred Action Contact DataDirect Technologies technical support 3518 Informix function failed while reading smart LOB data Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 127 3519 Select statements cannot be executed via Nimmediate Cause An attempt was made to execute statements that generate result sets in a batch of JDBC statements Action Make sure that every statement in a statement batch is a DDL or a statement that generates RowCounts 4301 Operation Failed Cause Never generated Action None 4302 Error configuring the JDBC DataSource Cause The logWriter writer could not be set because the DataDirect Spy jar file was not on the class path Action Verify that the spy jar file is o
72. JDBC application 7394 The method call 0 is not supported on a forward only result set The JDBC application used an illegal method on a forward only result set Cause The method 0 is not supported on a forward only result set The JDBC application used an illegal method on a forward only result set Action Correct your JDBC application 7395 Timeout expired Cause A timeout expired Action Verify that the SequeLink Server is running and that you have specified the correct network address of the host If your configuration is correct increase the connection timeout value SequeLink Troubleshooting Guide and Reference 172 Chapter 6 Error Messages 7396 The specified URL is not accepted 0 Cause The specified URL is not accepted 0 Action Verify the specified connection URL 7397 Insufficient information to connect Missing parameters are 0 Cause Insufficient information to connect was supplied Missing parameters are 0 Action Make sure that you specify the connection URL completely For information about the syntax of the connection URL refer to the SequeLink Administrator s Guide 7398 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 7399 Method 0 cannot be called when a result set is open The JDBC application used an illegal method on a Statement which has an open result set Cause Method 0 cannot be calle
73. L command must be numeric System action The command was ignored User response None ThreadPool is waiting for an available WorkerThread Severity Trace Explanation All worker threads are currently in use System action An RPC for this connection cannot be scheduled yet User response None SequeLink Troubleshooting Guide and Reference 280 Chapter 8 OS 390 Messages and Descriptions VAITO18I ThreadPool has waited ssss secs for an available WorkerThread Severity Information Explanation The threadpool waited longer then 0 5 seconds for an available WorkerThread System action Processing continues normally User response If this message occurs too frequently change one or more of the following configuration parameters m Increase the value ServiceMaxThread m Lower the value of DataSourceThreadMaxRpc and or DataSourceThreadRpcTimeOut SequeLink Troubleshooting Guide and Reference 281 9 SAS C Runtime Library Messages The SequeLink Server and SequeLink Manager on OS 390 use the SAS C run time library The SAS C run time library generates messages for unusual conditions detected during program execution These messages are written to the SYSTERM output of the SequeLink Server Job With SequeLink Manager these messages are normally written to the terminal SAS C run time library diagnostic messages have the form LSCX num severity ERRNO errno value Generated in function called
74. Link Administrator s Guide 3070 License verification failed Cause The SequeLink Server could not locate the required license to execute the client request The request is refused Action Make sure a valid SequeLink license is registered If the problem persists contact DataDirect Technologies technical support 3071 Maximum number of sessions reached Cause The number of active session is exceeding the value of the configuration parameter Incoming client connection requests are denied Action None SequeLink Troubleshooting Guide and Reference 102 Chapter 6 Error Messages 3078 Internal error invalid search argument type specified Cause An internal error occurred Action Contact DataDirect Technologies technical support 3079 Cannot initialize the ICU translator Cause The ICU translator could not be initialized because one of the codepages is not supported by the ICU Action Use an ICU supported codepage If the problem persists contact DataDirect Technologies technical support 3080 Service configuration error the ServiceCodepage configuration setting has an incorrect value Cause The current ServiceCodePage setting is not allowed Action Change the ServiceCodePage setting If the problem persists contact DataDirect Technologies technical support 3081 Accessing a SequeLink service configured with ServiceCodepage Database requires SequeLink client version 5 4 or higher Cause The connection is using an
75. Link Server for ODBC Socket It is important to realize that the problem or unexpected behavior could be caused by either SequeLink Server for ODBC Socket or a third party ODBC driver Identifying which component is generating the problem is key to solving it Identifying Connection Problems It is important to know the connection string used on a SQLDriverConnect call by Sequelink to initiate the connection to the ODBC driver When experiencing problems with establishing a connection examine the connection string configured in DatasourceSOCODBCConnsStr service attribute and check whether it is a valid connection string You can test this connection string using ODBCTest Once you have validated the connection string SequeLink Server for ODBC Socket should be able to use it to connect successfully to the database Identifying the Source of the Problem To check which component is the source of the problem m Use the ODBC driver directly Use the connection string configured in the DatasourceSOCODBCConnStr service attribute to initiate a direct connection to the ODBC driver You can use ODBCTest to run the same operations that gave you the problem m Use a different ODBC driver to see if the same error occurs Try using another ODBC driver with SequeLink Server for ODBC Socket and see whether the problem still occurs SequeLink Troubleshooting Guide and Reference Releasing Locks Held by Disassociated DB2 Threads 41 m Use ODBC Trac
76. Messages 434 Failed to open the event trace file because event tracing was not stopped cleanly Cause The event trace file has been left in an inconsistent state and can no longer be used Action Delete the event trace file Before deleting make sure SequeLink services are stopped using the SequeLink Manager 435 The event trace file is corrupt Cause An inconsistency was detected within the event trace file Action Delete the event trace file If the problem persists contact DataDirect Technologies technical support 436 Failed to open file to export Cause The specified export file cannot be opened Action Verify the reason reported by the operating system 437 Failed to close file to export Cause An error was encountered when closing the specified export file Action The contents of the specified export file may be corrupted use another export file 1000 System Exception 0 Cause An unexpected error occurred Action Check the system exception 0 for more information If necessary contact DataDirect Technologies technical support 1001 No more data available to read Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 1002 End of stream was detected on a read Cause An unexpected error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 81 1003 Error opening loading com ddtek util tra
77. NER JESMSGLG JES2 2 GN00002 JESJCL JES2 3 GN00002 JESYSMSG JES2 4 GN00002 s VAILOGP SQLNK 104 GN00002 SYS00001 SQLNK 106 GN00002 You will now see all SequeLink messages SequeLink Troubleshooting Guide and Reference SequeLink Debug Log Files 49 3 In some special cases SAS C runtime library routines write error information into SYSTERM See Chapter 9 SAS C Runtime Library Messages on page 281 for information on those messages Select the SYSTERM log file and press ENTER For example NP DDNAME STEPNAME PROCSTEP DSID OWNER JESMSGLG JES2 2 GN00002 JESJCL JES2 3 GN00002 JESYSMSG JES2 4 GN00002 VAILOGP SQLNK 104 GN00002 S SYSTERM SQLNK 106 GN00002 Use the SDSF option LOG to view the system log when you want to view messages for example DB2 messages related to SequeLink SequeLink Troubleshooting Guide and Reference 50 Chapter 4 Using Debug Log Files Configuring Logging You configure logging by using the SequeLink Manager to change the ServiceDebugLogLevel service attribute Depending on the level of logging you set the log file can contain any of the following types of messages Fatal Errors Errors Warnings Information Debug SSP Packet log SequeLink Server Protocol packets in binary format SSP requests decoded SSP packets By default the logging is enabled for Fatal Error messages All Error and Fatal Error messages for example an invalid license key encountered message are logged in a syst
78. OException occurred while trying to read from the proxy server configuration file Check the console of the proxy server machine for more detailed error messages If necessary contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 184 Chapter 6 Error Messages 7732 SSL Cannot read key value pairs from stream into properties object Cause Internal error An IOException occurred when trying to interpret the proxy server configuration file as a properties object Action Check the console of the proxy server machine for more detailed error messages If necessary contact DataDirect Technologies technical support 7733 SSL Non numerical value for port specified Cause A non numeric value is specified for the Port parameter in the proxy server configuration file Action Check the Port parameter in the proxy server configuration file 7734 SSL Non numerical value for server port specified Cause The proxy server configuration file specified an invalid value for the ServerPort parameter Action Check the ServerPort parameter in the proxy server configuration file 7735 SSL Non numerical value for maximum number of connections specified Cause The proxy server configuration file specified an invalid value for the MaxConnections parameter Action Check the MaxConnections parameter in the proxy server configuration file 7736 SSL Non numerical value for maximum packet size s
79. PUs are displayed None None SequeLink Troubleshooting Guide and Reference VAISO23E VAISO31I VAISO411 VAISO51F VAISO77E Server Controller Task Messages 245 GETMAIN for TACB storage failed Severity Error Explanation Insufficient storage left to allocate a TACB System action STRTTHRD request fails User response Increase Region size Normal end of JOB Severity Information Explanation Server main task has terminated normally System action Not applicable User response None Control CNTL Q message received Severity Information Explanation A control queue message was received by VAISMAIN System action Not applicable User response None SIL configuration error Severity Fatal Explanation Internal error System action The server abends User response Contact DataDirect Technologies technical support Unrecognized service request Severity Error Explanation Invalid service request from a server subtask System action Server terminates abnormally with an abend code of U143 User response Report this error to DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 246 Chapter 8 OS 390 Messages and Descriptions VAISO79E VAISO84E VAISO85I Attach failed at Initialization time Severity Explanation System action User response Error VAISMAIN was unable to attach one of its subtasks Server initialization co
80. ResultSet Absolute method Cause 0 is not a valid value for the row parameter of the method ResultSet Absolute Action Correct your application 6042 Invalid call to ResultSet Relative because there is no current row Cause This method invocation is only valid when the result set has a current row Action Check your JDBC application 6043 An I O error while manipulating the sort index Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 6044 The evaluation period for this driver has expired Contact DataDirect Technologies SupportLink to purchase a valid license Cause An unexpected error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 151 6045 A table name must be supplied Cause The application did not specify a table name for the DatabaseMetaData getIndexInfo method Action Correct your application 6046 Scrolling request was downgraded Cause The result set type was downgraded Action Refer to the SequeLink Developer s Reference for information about restrictions on scrollable cursors 6047 Updateable concurrency not supported downgraded to readonly concurrency Cause The result set concurrency was downgraded Action Refer to the SequeLink Developer s Reference for information about restrictions on updatable cursors 6048 Pooled connection reclaimation not supported Cause The JDBC driver does not s
81. SequeLink Troubleshooting Guide and Reference 70 Chapter 5 Overview of SequeLink Error Codes and Messages NET Data Provider The following types of errors can occur when you are using the SequeLink for NET Client m SequeLink Client errors m SequeLink Server errors m Database errors SequeLink Client Errors Errors generated by the NET Client have different formats depending on the cause and source of the problem Formats include SequeLink nnnn Memory allocation error occurred Invalid parameter type If a native error code is displayed you can look up details about the possible cause of the error See Chapter 6 Error Messages on page 73 for a list of all SequeLink error codes and messages For a list of all error codes and messages refer to the SequeLink Troubleshooting Guide and Reference SequeLink Server Errors An error generated by SequeLink Server has the following format DDTek SequeLink SequeLinkException SequeLink Server message For example DDTek SequeLink SequeLinkException SequeLink Server Required user name is missing SequeLink Troubleshooting Guide and Reference NET Data Provider 71 Use the native error code to look up details about the possible cause of the error See Chapter 6 Error Messages on page 73 for a list of all error codes and messages Database Errors An error generated by the database has the following format DDTek SequeLink SequeLinkException
82. SequeLink Troubleshooting Guide and Reference 75 376 The specified entity type is read only Cause An internal error occurred Action Contact DataDirect Technologies technical support 377 The specified configuration file could not be opened Cause An internal error occurred Action Contact DataDirect Technologies technical support 378 The syntax of the configuration file is incorrect Cause An internal error occurred Action Contact DataDirect Technologies technical support 379 An unexpected duplicate entity was detected Cause An internal error occurred Action Contact DataDirect Technologies technical support 380 The required primary key attributes were not provided Cause An internal error occurred Action Contact DataDirect Technologies technical support 381 The provided attribute is a primary key attribute Cause An internal error occurred Action Contact DataDirect Technologies technical support 382 The provided attribute already exists Cause An attempt was made to add an attribute that already exists Action This error only occurs when multiple SequeLink administrators attempt to add the same attribute to the configuration at the same time Using the SequeLink Manager reconnect to the SequeLink Agent service to refresh the SequeLink Manager view of the configuration file Then execute the administration task again SequeLink Troubleshooting Guide and Reference 76 Chapter 6 Error Messages
83. Session Debug Log File on OS 390 and z OS Log File Name The log file name is Servername_Servicename_Tnnnnnnn log where Servername is the name of the SequeLink Server started task Job Servicename is the name of the SequeLink service running within the server nnnnnnn is a unique numeric identifier of the session Log File Location The Session Debug Log Files are located in UNIX System Services hierarchical file system HFS The ServiceDebugLogPath service attribute specifies the HFS directory where the Session Debug log files will be created For more information about specifying SequeLink Troubleshooting Guide and Reference 46 Chapter 4 Using Debug Log Files XP 200x NT SequeLink service attributes refer to the SequeLink Administrator s Guide SequeLink Service Debug Log File The service debug log file contains information about processing that occurs outside the context of a client session Each debug log file includes a fixed header that contains installation specific information When you consult DataDirect Technologies technical support you may be asked for the contents of this log file The name and location of the SequeLink Service debug log file depend on your SequeLink Server platform The information that is logged depends on the value set for the ServiceDebugLogLevel service attribute By default logging is enabled for Fatal Error messages Enabling additional logging levels uses considerable
84. System action The command is ignored SequeLink Troubleshooting Guide and Reference VAIS185E VAIS186E User response Server Controller Task Messages 259 Use any of the following m SHOW ALL m SHOWS SERVICES to control what data is displayed as a result of the CNTL STATUS command Reenter the command with one of these keywords Refer to the SequeLink Administrator s Guide for additional information regarding the CNTL STATUS command Error thread was not found Severity Explanation System action User response Error This message is output in response to an incorrect CNTL ABORT command It indicates that the thread ID THRDID specified in the command named an unknown thread The command is ignored Application service threads are tagged with a unique thread ID with the form T nnnnnn where nnnnnn is a decimal number Use the CNTL STATUS command to display the active application threads and reenter the command specifying a valid thread ID Refer to the SequeLink Administrator s Guide for additional information regarding the CNTL STATUS and CNTL ABORT commands Error USERID or THRDID must be specified Severity Explanation System action User response Error This message is output in response to an incorrect CNTL ABORT command The USERID or THRDID parameter was missing from the command string At least one of these parameters is required in this command The
85. Technologies technical support if necessary 7429 Handshake failure A protocol error occurred during the connection setup Cause An attempt was detected to connect to a SequeLink Server running an incompatible version of SequeLink Action Verify that the versions of your SequeLink Client and SequeLink Server are compatible Contact DataDirect Technologies technical support if necessary 7430 Driver does not support different parameter target types The JDBC driver does not allow you to change the type of parameters once they are registered Cause The JDBC driver does not allow you to change the type of parameters once they are registered Action Check your JDBC application Possibly add a call to clearParameters 7431 Column index out of bounds The column index your JDBC application specified is out of bounds Cause Your JDBC application specified a column index that is out of bounds Action Check your JDBC application 7432 Internal error Invalid state of statement context 0 Cause The state of statement context 0 was invalid Action Contact DataDirect Technologies technical support 7433 Conversion not supported setObject with object type 0 used for SQL data type 1 at parameter index 2 Cause This type of conversion not supported Action Check your JDBC application SequeLink Troubleshooting Guide and Reference 178 Chapter 6 Error Messages 7434 An authentication mechanism c
86. The network may have gone down without notice the client server host was unreachable or the SequeLink Server was experiencing too many simultaneous connection attempts Action Check for heavy traffic conditions on the server 2309 Network problem could not load transport manager Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 89 2310 TCP IP error connection reset by peer Cause The connection was closed by the peer When the specified port is serviced by a non SequeLink Server this error can occur if the server goes down while trying to process a handshake request Action Check the server logs If the failure was caused by the SequeLink Server stopping unexpectedly contact DataDirect Technologies technical support 2311 TCP IP network error connection closed Cause An unexpected TCP IP error occurred The connection was closed Action Contact DataDirect Technologies technical support 2312 Network problem connection closed due to idle event on transport endpoint not linked to session Cause A connection was established with the SequeLink Server but no data was received by the SequeLink Server within the keep alive time frame The connection was closed Action Increase the keep alive setting on the server 2313 Network resource problem connection closed due to buffer allocation problem Cause A request to the op
87. Troubleshooting Guide and Reference 109 3160 Failed to process remote monitoring request Cause The monitoring request could not be processed by the server Action Preceding or subsequent messages contain more detailed information 3161 Failed to process the monitor request because a required counter could not be found in the monitor Cause An internal error occurred Action Contact DataDirect Technologies technical support 3170 Failed to process the remote query event trace request Cause The event trace request could not be processed by the server Action Preceding or subsequent messages contain more detailed information 3171 Failed to process the query event trace request because the specified handle has not been opened Cause An internal error occurred Action Contact DataDirect Technologies technical support 3172 Failed to open the event trace Cause The SequeLink Server was unable to open the event trace file Action Make sure that the ServiceEventTraceLocation service attribute contains a valid event trace file location and that it is accessible If the problem persists contact DataDirect Technologies technical support 3180 Failed to process the profile generator request because the required object could not be found in the profile Cause An internal error occurred Action Contact DataDirect Technologies technical support 3181 Failed to process the profile generator request because a duplicate object was found in the
88. W _ VAIBEAT Error in DataModel using default value for Timelnterval Severity Warning Explanation TIMERINTERVAL incorrectly specified in SequeLink configuration file System action A default TIMEINTERVAL of 15 seconds is set User response Correctly specify TIMERINTERVAL in the SequeLink configuration file VAIS160F No valid Service definitions in DataModel at least 1 must be found Severity Fatal Explanation No valid service definition was found in the SequeLink configuration file The Server requires at least one valid service definition System action The server abends with abend U160 User response Correctly define a service in the SequeLink configuration file call DataDirect Technologies technical support for assistance SequeLink Troubleshooting Guide and Reference VAIS161E VAIS162E VAIS163W VAIS164E Server Controller Task Messages 253 Datamodel error for service xxxxxxxx Service has been ignored Severity Explanation System action User response Error ServiceApplid was incorrectly specified in the SequeLink configuration file for service xxxxxx The affected service will not be available until the error is corrected and the server is restarted The incorrect service definition is ignored and bypassed Correctly define ServiceApplid for service xxxxxxx in the SequeLink configuration file DataModel ServiceldleTime error Service xxxxxxxx has been ignored Severity Ex
89. a type conversion for the specified column failed Action Correct your JDBC application 6025 Object has been closed Cause Object is closed The JDBC application used an illegal method on a closed object Action Correct your JDBC application 6026 Can t start manual transaction mode because there are cloned connections Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 6027 Not in local manual transaction mode Cause The application called a method that can only be used in manual transaction mode Action Correct your JDBC application SequeLink Troubleshooting Guide and Reference 149 6029 Unable to connect DataSource property 0 must be specified Cause Insufficient information to connect was supplied Missing parameters are 0 Action Make sure that you specify all required connection properties For more information about all possible connection properties refer to the SequeLink Administrator s Guide 6030 Unable to connect Invalid URL Cause Insufficient information to connect was supplied Missing parameters are 0 Action Make sure that you specify the connection URL completely For information about the syntax of the connection URL refer to the SequeLink Administrator s Guide 6031 The input stream contained a different number of bytes than specified Cause The application requested more bytes than available in the input stream Action Check your JDBC app
90. able 6057 Row update failed Cause An exception occurred while updating the ResultSet Action Obtain the next exception for more information If necessary contact DataDirect Technologies technical support 6058 Invalid operation while positioned on the insert row Cause The application called a method 0 that can not be called while positioned on the insert row Action Correct your JDBC application 6059 Row delete actually caused 0 rows to be deleted Cause ResultSet deleteRow updated more ore than one row Action Make sure that your application selects the primary key of the table SequeLink Troubleshooting Guide and Reference 153 6060 Row delete failed Cause An exception occurred while deleting a row from the ResultSet Action Obtain the next exception for more information If necessary contact DataDirect Technologies technical support 6061 Must be on the insert row to insert Cause This method invocation is only valid when the cursor is positioned on the insert row Action Check your JDBC application 6062 Row insert failed Cause An exception occurred while inserting a row into the ResultSet Action Obtain the next exception for more information If necessary contact DataDirect Technologies technical support 6063 Error closing Blob or Clob object Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 6064 The search pattern specified is too large Cause The search pat
91. ake sure that the MoreExecPath is configured correctly The following example is for HP UX Your path to the more command may be different depending on the version of UNIX you are using 1 Stop your SequeLink services 2 Add the following lines to your swcla ini file CLA Settings MoreExePath usr bin more 3 Restart your SequeLink services 5527 When handling commands interactive no output or error file can be specified Cause An output or error file was specified on the command line but no input file was specified Action Correct the command line by adding the input file option or by removing the output or error file option 5528 Invalid flag lt name gt Cause An invalid command line flag was specified Action Specify a valid command line flag 5529 Invalid profile level lt name gt Cause An invalid profile level in a SequeLink Manager command was specified Action Check the SequeLink Manager command help to verify profile levels 5530 Invalid name or ID lt va ue gt for profile level lt name gt Cause An invalid profile name or ID for the specified profile level in a SequeLink Manager command was supplied Action Check the SequeLink Manager command help to verify profile levels and their names or IDs SequeLink Troubleshooting Guide and Reference 145 5531 Too many parameters specified Cause Too many arguments were provided with a SequeLink Manager command Action Make sure that the SequeLink Mana
92. ale ans Changing the Debug Log Level for an Active Service Changing the Debug Log Level for an Active Session Multi Platform Log Messages 20 00eee eens SequeLink Troubleshooting Guide and Reference Table of Contents Part 2 Error Codes and Messages 5 Overview of SequeLink Error Codes and Messages 4 Soeur ust One heen asiedeue toys ore ODBC Driven ordaina cc dad ae asian Shee paia ae tle Wak wad a ed a ODBC Driver Errors 0000 00 eee eee eens SequeLink Client Errors 0002 cee eee eee SequeLink Server Errors 02 000 eee eee ees Database Errors ta Secs eee eae eo ADO Data Provider 00 eee ee ee eee ADO Data Provider Errors 0000 eee eee eeee SequeLink Client Errors 0 0c eee eee eens SequeLink Server Errors 00000 e cece eee eens Database Errors tea bee wee we ds ee OL Se eee JDBC DFINGi 25 ft beh ett ee een Pe ode ee ge Bae ee JDBC Driver Errors 0 0 ee ee ee eee SequeLink Server Errors 00 0c cece eee eee eens Database Errors enoei eke tata ei eat hi ek eee ee NET Data Provider 3 00 cess oe gee ka we aes SequeLink Client Errors 1 2 0 0000 e eee eee eee SequeLink Server Errors 000 cece cece eee enes Database Errors 424422200 dip seeoe dais awe en 6 Error Messages 0 cece eee eee eens Part 3 OS 390 Log Messages and Reference 7 Overview of OS 390 Log Messages Message Categones
93. ar in supporting documentation DataDirect Connect for SQUXML includes Xerces developed by the Apache Software Foundation http Awww apache org Copyright C 1999 2003 The Apache Software Foundation All rights reserved Xalan developed by the Apache Software Foundation http www apache org Copyright C 1999 2003 The Apache Software Foundation All rights reserved JDOM developed by the JDOM Project http Awww jdom org Copyright C 2001 Brett McLaughlin amp Jason Hunter All rights reserved DataDirect SequeLink includes Portions created by Eric Young are Copyright C 1995 1997 Eric Young eay cryptsoft com All Rights Reserved No part of this publication with the exception of the software product user documentation contained in electronic format may be copied photocopied reproduced transmitted transcribed or reduced to any electronic medium or machine readable form without prior written consent of DataDirect Technologies Licensees may duplicate the software product user documentation contained on a CD ROM but only to the extent necessary to support the users authorized access to the software under the license agreement Any reproduction of the documentation regardless of whether the documentation is reproduced in whole or in part must be accompanied by this copyright statement in its entirety without modification U S GOVERNMENT RESTRICTED RIGHTS It is acknowledged that the Software and the Documentation we
94. at Reader 5 x with Search for Windows and Acrobat Reader 4 x with Search for UNIX SequeLink product documentation is also available on the DataDirect Technologies Web site http Awww datadirect technologies com techres proddoc_product asp On Windows and UNIX you can choose to install the online books on your system When installed they are located in the books directory that is created beneath the SequeLink installation directory SequeLink Troubleshooting Guide and Reference 10 Preface When you install the JDBC NET or ODBC Client HTML based online help for developing applications is placed by default in the help directory that is created beneath the SequeLink installation directory To access help you must have Internet Explorer 5 x or higher or Netscape 4 x or higher installed Netscape 6 0 does not support the help system however 6 1 or higher does After you have opened the main screen of the help system in your browser as described below you can bookmark it in the browser for quick access later On Windows platforms help is available from the setup dialog for the ODBC driver and ADO data provider When you click Help your browser will open to the correct topic There are three navigation buttons at the left end of the grey menu bar at the top of the help screen Clicking the left hand button displays the table of contents and the index for the entire help system in the left pane After the left pane is disp
95. atal The server has found an invalid STKSIZE value in one of the server s internal SIL entries VAISMAIN terminates with a condition code of 4 Report this error to DataDirect Technologies technical support Fatal Invalid DSASIZE value in one of the server s internal SIL entries VAISMAIN terminates with a condition code of 4 Report this error to DataDirect Technologies technical support Fatal There is an invalid AFLGS value in one of the server s internal SIL entries VAISMAIN terminates with a condition code of 4 Report this error to DataDirect Technologies technical support Fatal There is an invalid DPMOD value in one of the server s internal SIL entries SequeLink Troubleshooting Guide and Reference 252 Chapter 8 OS 390 Messages and Descriptions System action VAISMAIN terminates with a condition code of 4 User response Report this error to DataDirect Technologies technical support VAIS157F VAIT build error Severity Fatal Explanation Logic error while building the server VAIT list System action VAISMAIN terminates with a condition code of 4 User response Report this error to DataDirect Technologies technical support VAIS158F VAIT OPRI error Severity Fatal Explanation Logic error while processing an OPERID entry in the SIL System action VAISMAIN terminates with a condition code of 4 User response Report this error to DataDirect Technologies technical support VAIS159
96. atement that created the stored procedure Action Correct the syntax of the statement that created the stored procedure 3311 A data dictionary statement was called with an invalid parameter value Cause A data dictionary statement for example SQLSpecialColumns was called but at least one of the parameters had a value that was not valid Action Contact DataDirect Technologies technical support 3312 SequeLink does not support this data type for stored procedure parameters Cause A stored procedure was executed and a data type that SequeLink does not support for stored procedures was detected Action Change the statement that executes the stored procedure in your application 3313 Internal error The specified data source is not found in the SequeLink configuration file Cause The specified server data source could not be found in the SequeLink configuration file Action Contact DataDirect Technologies technical support 3314 Select statement not allowed in batch processing Cause You cannot execute a Select statement in a batch of statements Action Change your application so that Select statements are not included in the batch SequeLink Troubleshooting Guide and Reference 114 Chapter 6 Error Messages 3315 A required Oracle user name is missing Cause The SequeLink service is configured to require a database user name but a database user name was not provided by the SequeLink Client Action Specify
97. ath the SequeLink for JDBC Client installation directory b Right click testforjdbc bat and select Properties After the properties display select the Memory tab c On the Memory tab locate the Initial environment setting From this drop down list select 1024 Then select the Protected check box Click OK A DataDirect Test shortcut is created in the same directory with testforjdbc bat d Double click testforjdbc bat or the DataDirect Test shortcut DataDirect Test will open normally without producing the error NOTE Do not delete the DataDirect Test shortcut the 1024 environment setting will be lost if the shortcut is deleted K m Asa Java application on UNIX Run the testforjdbc sh shell eee script located in the testforjdbc directory SequeLink Troubleshooting Guide and Reference 24 Chapter 1 Troubleshooting Tools Making a DataDirect Test Connection 1 Select Driver Register Driver DataDirect Test prompts you for the JDBC driver to load 2 Inthe Please Supply a Driver URL field make sure that a driver is specified as in the following example then click OK com ddtek jdbc sequelink SequeLinkDriver If the JDBC Driver was registered successfully the main DataDirect Test window appears with a confirmation in the JDBC Database Output scroll box Btestfor DBC To PAN registerDriver Succeeded REGISTER DRIVER try Driver d Driver Class forName com ddtek jdbc catch Exception e
98. cal support SequeLink Troubleshooting Guide and Reference 77 396 The parameters needed to create an IPC key could not be found in the configuration file Cause An internal error occurred Action Contact DataDirect Technologies technical support 397 A call to ftok failed Check if the file xxx exists and is readable Cause An internal error occurred Action Contact DataDirect Technologies technical support 398 Request to create or attach to shared memory key xxxx failed Cause An internal error occurred Action Contact DataDirect Technologies technical support 399 Request to create a semaphore key xxxx failed Cause An internal error occurred Action Contact DataDirect Technologies technical support 400 Request to create a message queue key xxxx failed Cause An internal error occurred Action Contact DataDirect Technologies technical support 401 Failed to terminate the event queue cache because it is not empty Cause An internal error occurred Action Contact DataDirect Technologies technical support 410 The specified parameter xxxx is invalid Cause An internal error occurred Action Contact DataDirect Technologies technical support 411 The attribute xxx is not found in the attribute list of the event that is being processed Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 78 Chapter 6 Error Messag
99. ce processid is the numeric process identifier assigned by the operating system for the SequeLink service process Messages are sent to the syslogd infrastructure By default the messages are sent as USER type messages however you can change the message type by setting the ServiceUnixSyslogFacility service attribute For more information about specifying SequeLink service attributes refer to the SequeLink Administrator s Guide SequeLink Troubleshooting Guide and Reference 48 Chapter 4 Using Debug Log Files z OS Service Debug Log File on OS 390 and z OS The Service Debug log file on OS 390 records all log messages See Chapter 8 OS 390 Messages and Descriptions on page 213 for an explanation of these messages By default the log file is allocated to DD statement VAILOGP or VAILOGS We recommend that you allocate the log file to a SYSOUT dataset This allows you to view all messages online using the OS 390 System Display and Search Facility SDSF 1 Use the SDSF option DA to display a list of the active jobs Select the SequeLink job using a question mark command and press ENTER For example NP JOBNAME STEPNAME PROCSTEP JOBID OWNER GN00002H DUMP JOB08358 GN00002 GN000020 SQLNK JOB08359 GNO00002 GNO0002 LOGISPF4 FBBSO80I TSU08354 GN00002 2 Select the VAILOGP primary or VAILOGS secondary log file and press ENTER The following example shows choosing the VAILOGP log file NP DDNAME STEPNAME PROCSTEP DSID OW
100. ce XXXXXXX in the SequeLink configuration file Service list entry for service name application name built successfully values Severity Explanation System action User response Information The SequeLink configuration file application service definitions for the named service representing the named application were successfully processed The server s service list is updated with the named service for example the named application is available for use None LOAD failed for module xxxxxxxx with rc zz yyyyyyyy Severity Explanation System action User response Error An OS 390 LOAD for loadmodule xxxxxxxx specified as ServiceApplid for yyyyyyyy failed with rc zz The affected service will not be available until error is corrected and the Server restarted The incorrect service definition is ignored and bypassed Check why the loadmodule could not be accessed Either ServiceApplid is a nonexistent loadmodule or OS 390 Contents Supervisor detects errors If problems persist contact DataDirect Technologies technical support STRTTHRD request for Service service_id from user_id at terminal_id was not successful Severity Explanation System action User response Error An attempt to start an application thread failed The affected application is identified by its name the user by their user ID and the terminal by its terminal ID This message is always preceded by a VAIS174E o
101. ce attribute value specified requires a numeric value Action Specify a numeric value for the service attribute value For more information about specifying SequeLink service attributes refer to the SequeLink Administrator s Guide 6858 Specified value lt attribute value gt for attribute lt name or ID gt is not valid Values between lt ower imit gt and lt upper limit gt are valid Cause The specified service attribute value was invalid Action Specify the service attribute value using a numeric value between lt lower limit gt and lt upper limit gt 6859 Specified value lt attribute value gt for attribute lt D or name gt is not valid Cause The specified service attribute value was invalid Action Specify a valid value for the service attribute 6861 Invalid values for boolean attribute lt D or name gt Cause The specified service attribute value is not a valid boolean value Action Specify a valid value for the service attribute 6862 Length of string attribute lt D or name gt cannot be larger then lt ength gt characters Cause The specified service attribute value cannot exceed the maximum string length allowed Action Specify a valid value for the service attribute 6863 Attribute type not supported Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 163 6864 Unable to determine local host name Cause SequeLi
102. characters z OS Contacting Technical Support DataDirect Technologies provides technical support for registered users of this product including limited installation support for the first 30 days Register online for your SupportLink user ID and password for access to the password protected areas of the SupportLink web site at http Awww datadirect technologies com support support_index asp Your user ID and password are issued to you by email upon registration For post installation support contact us using one of the methods listed below or purchase further support by enrolling in the SupportLink program For more information about SupportLink contact your sales representative The DataDirect Technologies web site provides the latest support information through SupportLink Online our global service network providing access to support contact details tools and valuable information Our SupportLink users access information using the web and automatic email notification SupportLink SequeLink Troubleshooting Guide and Reference 14 Preface Online includes a knowledge base so you can search on keywords for technical bulletins and other information World Wide Web http www datadirect technologies com support support_index asp E Mail USA Canada and Mexico supportlink datadirect technologies com Europe Middle East and Africa int supportlink datadirect technologies com Japan jpn answerline datadirect co jp All other cou
103. chnologies technical support SequeLink Troubleshooting Guide and Reference VAIS1791 VAIS1801 VAIS18 11 Server Controller Task Messages 257 XXXXXXXX Normal end Thrdid yyyyyyyy Severity Explanation System action User response Information A server task an application thread or a server component has ended with the stated condition code If the task was an application thread the thread identifier is also given in the message The task is flushed from the system and all storage used by the task is freed None This message simply notes that a task has ended This is a normal situation XXXXXXXX abnormal end cc zzzz Thrdid yyyyyyyy Severity Explanation System action User response Information Task ended abnormally Either the task was deliberately aborted for Timeout or maxCPU reasons or by Operator commands or otherwise suffered an abend zzzz OS 390 CompletionCode Abendcode None None if task was deliberately aborted Otherwise contact DataDirect Technologies technical support Service service name Severity Explanation System action User response Information This message is output following a CNTL STATUS command It is always followed by a set of VAIS182I and VAIS1831 messages The service application for which the status was requested is identified by name The status is detailed in the subsequent VAIS182I and VAIS1831 messages Not app
104. cified statement to an Informix specific format Cause The SequeLink Server SQL Parser could not parse the SQL statement Action Correct the syntax error in the SQL statement that you are trying to prepare or execute 3503 An Informix DECIMAL value can only be converted to a SequeLink decimal value Cause An internal error occurred Action Contact DataDirect Technologies technical support 3504 A SequeLink decimal value can only be converted to an Informix NUMBER value Cause An internal error occurred Action Contact DataDirect Technologies technical support 3505 Internal error An unsupported action is encountered in a fetch callback routine Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 125 3506 Numeric value truncated Cause The precision or scale of a numeric value is larger than Informix expects Action Make sure the numeric value that you send to Informix corresponds to the columns definition 3507 An Informix timestamp value can only be converted to a SequeLink timestamp value Cause An internal error occurred Action Contact DataDirect Technologies technical support 3508 A SequeLink timestamp value can only be converted to an equivalent Informix timestamp value Cause An internal error occurred Action Contact DataDirect Technologies technical support 3509 Output and Input Output variables not supported Cause An atte
105. command is ignored Correct the command and reenter it Refer to the SequeLink Administrator s Guide for additional information regarding the CNTL ABORT command SequeLink Troubleshooting Guide and Reference 260 Chapter 8 OS 390 Messages and Descriptions VAIS187E VAIS188I VAIS189T Error thread has already been aborted Severity Error Explanation This message is output in response to an incorrect CNTL ABORT command It indicates that the operator is attempting to terminate abnormally an application service thread that has already been terminated abnormally System action The command is ignored User response Under certain circumstances an ABORT of an application service thread instance can take about 3 10 seconds Wait until this time has elapsed before attempting the command again Thrdid tttttttt for User uuuuuuuu has been aborted Severity Information Explanation This message is output in response to a successful CNTL ABORT command It indicates that the application service thread identified by its thread ID started by the stated user has been terminated abnormally System action The affected thread is removed from the system and the associated application logic is terminated User response None ssssssss Service for User uuuuuuuu with Thrdid tttttttt exceeds Timeout value xxxx yyyy Severity Trace Explanation An application service thread identified by its thread ID started by th
106. configuration file was refused because another SequeLink Manager application has locked the SequeLink configuration file Action Wait for the other SequeLink Manager application to release the lock on the SequeLink configuration file Then re attempt the SequeLink Manager operation SequeLink Troubleshooting Guide and Reference 101 3067 The user password was changed successfully Cause An informational message was generated when the server password of the user was successfully changed Action None 3068 The application specified an invalid application identifier Cause The application ID specified by the application is not recognized by the SequeLink service Action Make sure that the application is specifying the correct application ID or change the DataSourceAutoApplld service attribute of the SequeLink service to accept the application ID For information about application IDs or changing SequeLink service attributes refer to the SequeLink Administrator s Guide 3069 The application failed to specify a valid application identifier Cause Because the application did not provide a valid application ID client requests will be refused Action Make sure that the application is specifying the correct application ID or change the DataSourceAutoApplld service attribute of the SequeLink service to accept the application ID For information about application IDs or changing SequeLink service attributes refer to the Seque
107. could be obtained Action None 3433 The database context could not be switched Cause The database context could not be switched Action AVAIDO50E message is generated and written to the service debug log Contact your system administrator 3434 Invalid literal Cause A literal in the stored procedure is invalid Action Make sure that the character literals are enclosed in quotes and that numeric literals have a valid value SequeLink Troubleshooting Guide and Reference 122 Chapter 6 Error Messages 3435 Literal cannot be an output parameter Cause A literal cannot be used as an output parameter Action Use a bind variable for the output parameter and re issue the call procedure 3436 Datatype not supported for literals Cause An unsupported data type was used for a literal The stored procedure could not be executed Action Use a bind variable for the literal and re issue the call procedure 3437 Literals and bind variables cannot be mixed Cause A combination of literals and bind variables cannot be used when calling a stored procedure Action Make sure that you use only literals or only bind variables when calling a stored procedure 3438 The maximum size of a large object output parameter is exceeded Cause A stored procedure was called that returns a LOB output parameter that exceeds the value set by the DataSourceDB2MaxLobSize service attribute for this data source The data is not returned Action I
108. could not be opened Cause The SystemRoot system32 drivers etc services file Windows NT Windows 200x Windows XP or the etc services file UNIX could not be opened Action Contact your system administrator If the problem persists contact DataDirect Technologies technical support 3147 The TCP port for the service could not be registered unregistered because the services file could not be accessed Cause A file input output error was detected while accessing the services file SystemRoot system32 drivers etc services on Windows NT Windows 200x Windows XP or etc services on UNIX Action Contact your system administrator If the problem persists contact DataDirect Technologies technical support 3148 Failed to unregister the OS service because it is not a SequeLink Service Cause An attempt to unregister a SequeLink service failed because the SequeLink service name was being used by another operating system service Action Make sure that the name you choose for your SequeLink service is not being used by another operating system service 3149 The configuration file was changed by someone else Cause The configuration file has been modified by another administrator Action Reload the configuration file and make the changes again SequeLink Troubleshooting Guide and Reference 108 Chapter 6 Error Messages 3150 Failed to process the remote management request Cause The management request could not be
109. ction Do not try to use a catalog SequeLink Troubleshooting Guide and Reference 117 3402 The database does not support the change of isolation level Cause An attempt was detected to change the transaction isolation level but the database does not support changing the isolation level Action Do not try to change the transaction isolation level 3403 Schema Owner is not supported in stored procedure calls SQLProcedures or SQLProcedureColumns Cause Because DB2 stored procedures do not have schemas you cannot specify a schema name in procedure related data dictionary statements Action Change the stored procedures in your application 3404 Invalid stored procedure name or not authorized to invoke this procedure Cause Either an invalid stored procedure name was specified or you do not have sufficient privileges to invoke the stored procedure Action Make sure that you execute a stored procedure that exists in the database and that you have sufficient privileges to execute it 3405 No default parameters are allowed in a stored procedure call Cause Default parameters were used when invoking a stored procedure Action Do not use the default parameters when invoking a stored procedure 3406 Number of parameters mismatch for stored procedure Cause A stored procedure was executed and the number of parameters did not correspond with the stored procedure definition Action Change the number of parameters specified in your applicati
110. ction to prompt for a user ID and password failed Action Contact DataDirect Technologies technical support 6896 Invalid attribute name lt name gt Cause An invalid attribute name was specified Action Specify a valid attribute For more information about specifying SequeLink service attributes refer to the SequeLink Administrator s Guide 6897 No agent service found in lt file name gt Cause A SequeLink Agent service was not found defined in the specified SequeLink configuration file Action Create a SequeLink Agent service For information about creating SequeLink services refer to the SequeLink Administrator s Guide SequeLink Troubleshooting Guide and Reference 168 Chapter 6 Error Messages 6898 Unable to locate local SequeLink server configuration file Cause A local SequeLink configuration file could not be located Action Make sure that you have specified the local configuration file correctly 6899 SequeLink Administration library has not been initialized Cause A call to the SequeLink Manager library was made before calling SLMAM_Init Action Contact DataDirect Technologies technical support 6900 Service lt service name gt already exists Cause A SequeLink service with the same service name already exists Action Specify a unique service name for the SequeLink service 6901 Invalid token in service name Cause The specified service name contains a token that is not allowed Action Choose another
111. d on a statement that returns a result set Action Correct your JDBC application 6014 Invalid operation Statement not in an executed state Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 6017 Unexpected internal error Cause An unexpected internal error occurred Action Contact DataDirect Technologies technical support 6018 Invalid SQL specified Cause The specified SQL statement is not valid Action Correct your JDBC application 6019 Method not valid for read only ResultSet 0 Cause The method 0 can only be called on an updatable result set Action Correct your JDBC application SequeLink Troubleshooting Guide and Reference 148 Chapter 6 Error Messages 6020 Method not valid for TYPE_FORWARD_ONLY ResultSet 0 Cause The method 0 can only be called on an scrollable result set Action Correct your JDBC application 6021 Can t start a cloned connection while in manual transaction mode Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 6022 The specified SQL type is not supported by this driver Cause Your application uses a SQL type that is not supported by this driver Action Check your JDBC application 6023 Cannot obtain a connection to perform the operation Cause The maximum number of statements are in use Action Check your JDBC application 6024 Value can not be converted to requested type Cause The dat
112. d when a result set is open The JDBC application used an illegal method on a Statement which has an open result set Action Correct your JDBC application 7400 Error occurred while reading properties file Cause An error occurred while reading the properties file Action Contact DataDirect Technologies technical support 7401 Insufficient information to log on to the database Missing parameters are 0 Cause Insufficient information was provided to log on to the database Missing parameters are indicated by 0 Action Re attempt the connection making sure that you specify the connection URL completely SequeLink Troubleshooting Guide and Reference 7402 173 Unexpected error occurred during timed connection startup Cause An unexpected error occurred during timed connection startup Action Obtain the next exception for more information If necessary contact DataDirect Technologies technical support 7403 Statement did not generate a row count executeUpdate cannot be used on a statement that returns a result set Cause The statement did not generate a row count executeUpdate cannot be used on a statement that returns a result set Action Correct your JDBC application 7404 Statement did not generate a result set executeQuery cannot be used ona statement that does not return a result set Cause The statement did not generate a result set executeQuery cannot be used on a statement that does
113. de or reasoncode where IWMExxxx can be IWMECREA IWMELEAV IWMEJOIN IWCLSFY or IWMEDEL System action Continue without enclave support for this thread User response Check why this macro call failed Contact DataDirect Technologies technical support Tttttttt IWMExxxx WLMEnclaveToken nnnnnnnn Severity Trace Explanation Trace WLM macro IWMExxxx calls show EnclaveToken where IWMExxxx can be IWMECREA IWMELEAV IWMEJOIN IWCLSFY or IWMEDEL System action None User response None SIL Start table missing Severity Fatal Explanation VAISMAIN could not locate the started tasks STRTTABL System action VAISMAIN terminates with a condition code of 4 User response Report this error to DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference VAIS152F VAIS153F VAIS154F VAIS155F VAIS156F Server Controller Task Messages 251 SIL NAME field error Severity Explanation System action User response SIL STKSIZE error Severity Explanation System action User response SIL DSASIZE error Severity Explanation System action User response SIL AFLGS error Severity Explanation System action User response SIL DPMOD error Severity Explanation Fatal VAISMAIN could not locate a required START entry VAISMAIN terminates with a condition code of 4 Report this error to DataDirect Technologies technical support F
114. disk space and slows processing We recommend that you enable these additional levels only while you are troubleshooting How you turn on and off the logging option depends on your SequeLink Server platform See Configuring Logging on page 50 for information about setting debug levels Service Debug Log File on Windows NT Windows 200x and Windows XP On Windows NT Windows 200x and Windows XP the operator logging facility is the event log You can access the event log by clicking the Event Viewer icon in the Administrative Tools program group SequeLink Server logging belongs to the application class with the service name as the source name SequeLink Troubleshooting Guide and Reference SequeLink Debug Log Files 47 The service debug log file is an operating system file called servicename_processid log where servicename is the name of the SequeLink service processid is the numeric process identifier assigned by the operating system for the SequeLink service process You can choose the messages that you want to view in the event log by using the Filter menu option NOTE You may need to refresh the Event window to receive the latest logging information Service Debug Log File on UNIX The ServiceDebugLogPath service attribute specifies the location of the service debug log file The service debug log file is an operating system file called servicename_processid log where servicename is the name of the SequeLink servi
115. driver m SequeLink Server m Database JDBC Driver Errors An error generated by the JDBC driver has the following format DataDirect SequeLink JDBC Driver message For example DataDirect SequeLink JDBC Driver Timeout expired SequeLink Troubleshooting Guide and Reference JDBC Driver 69 Use the native error code to look up details about the possible cause of the error See Chapter 6 Error Messages on page 73 for a list of all error codes and messages Sometimes you may need to check the last JDBC call your application made and refer to the JDBC specification for recommended action SequeLink Server Errors An error generated by SequeLink Server has the following format DataDirect SequeLink JDBC Driver SequeLink Server message For example DataDirect SequeLink JDBC Driver SequeLink Server Only Select statements are allowed in this read only connection Use the native error code to look up details about the possible cause of the error See Chapter 6 Error Messages on page 73 for a list of all error codes and messages Database Errors An error generated by the database has the following format DataDirect SequeLink JDBC Driver message For example DataDirect SequeLink JDBC Driver Oracle ORA 00942 table or view does not exist Use the native error code to look up details about the possible cause of the error For these details refer to your database documentation
116. e The value must be between 128 and 256 Error opening SYSCMDS file Severity Explanation Error An error occurred while opening SYSCMDS file SequeLink Troubleshooting Guide and Reference 244 Chapter 8 OS 390 Messages and Descriptions System action User response The Server continues initialization Make sure the Server Userid is authorized to open SYSCMDS file If problems persist contact DataDirect Technologies technical support VAISO171 Processing commands from SYSCMDS file Severity Explanation System action User response Information The SYSCMDS file has been opened The Server continues initialization All commands in SYSCMDS will be processed VAISO18I SosLimit above xxxxx K below yyy K Severity Explanation Information The MVSGlobalSosLimit attribute has reserved xxxxx KB of free storage above the 16 MB line New connections will be refused when free storage drops below this limit In addition yyy KB of free storage has been reserved below the 16 MB line but this limit is fixed System action None User response None VAISO21I Running on Severity Information Explanation The Operating System and Release on which the System action User response application is running are displayed None None VAISO221 CPUid __ CPUSerialNr Severity Explanation System action User response Information The CPU id and CPU Serial number for all C
117. e administration internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 196 Chapter 6 Error Messages 7830 SSL Failed to load authentication provider class Cause Internal error A fatal error occurred when loading a specified provider class Providers must be specified in the com ddtek sequelink slje properties properties file At startup all authentication providers are loaded in the order they are specified If the provider class is not found this provider is not installed When a provider class is found but an error occurred when loading it this error message is returned Action Check the detailed error message If necessary contact DataDirect Technologies technical support 7831 SSL Authentication provider lt provider class name gt has wrong type Cause Internal error A provider specified in the com ddtek sequelink slje properties properties file is not a sub class of com ddtek sequelink auth MGSSProvider Action Check the com ddtek sequelink slje properties properties file If necessary contact DataDirect Technologies technical support 7832 SSL No authentication provider specified or found Cause No provider specified in the com ddtek sequelink slje properties properties file can be found Action Check the com ddtek sequelink slje properties properties file Make sure that the provider classes specified in this
118. e current status of the task Flags can include p1 D dispatched initializing L has a queue locked W wait state X exiting dispatcher S task is the SCT component K aborted by the SCT p2 Not used p3 T task is an application thread X invalidated by the SCT p4 not used cputime CPU time consumed by the SequeLink engine task service Usually the name of the application in the SYSINI for an instance of the application thread Alternatively it is set to the literal CORE for all server component tasks username Usually the user ID that initiated this instance of the application thread Alternatively it is set to the literal Not applicable for all server component tasks SequeLink Troubleshooting Guide and Reference VAISO91F VAISO95E VAIS100W VAIS101E Server Controller Task Messages 249 System action Not applicable User response None XXXXXX task has ended unexpectedly Abend server Severity Fatal Explanation An essential server component subtask has terminated System action VAISMAIN terminates abnormally with an abend code of U146 User response Report this error to DataDirect Technologies technical support Alter request is invalid invalid or missing keyword Severity Error Explanation This message is in response to a CNTL ALTER command There are two possible causes m a keyword was not supplied m the keyword supplied was inc
119. e detailed error messages If necessary contact DataDirect Technologies technical support 7790 SSL Write to data output stream failed Cause An internal error occurred when trying to stop a running proxy server Action Check the console of the proxy server machine for more detailed error messages If necessary contact DataDirect Technologies technical support 7791 SSL Unable to close end point Cause An internal error occurred when trying to stop a running proxy server Action Check the console of the proxy server machine for more detailed error messages If necessary contact DataDirect Technologies technical support 7792 SSLINon numerical value for port specified Cause A non numeric value was specified for the AdminPort parameter in the proxy server configuration file The AdminPort parameter must have a numeric value Action Check the AdminPort parameter in the proxy server configuration file 7793 SSL Unknown local host Cause An internal error occurred when trying to stop a running proxy server Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 194 Chapter 6 Error Messages 7794 SSL Supply name of proxyserver Cause Internal error No name is specified when starting a proxy server Action Contact DataDirect Technologies technical support 7795 SSL Cannot create data input stream over socket Cause An internal error occurred when t
120. e detailed error messages If necessary contact DataDirect Technologies technical support 7753 SSL Invalid client connection Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7754 SSL Closing client connection failed Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7755 SSL Internal error in client read message operation Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7756 SSL Network write error in client write SSL TLS Alert message Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 188 Chapter 6 Error Messages 7757 SSL Network read error in server read message length operation Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7758 SSL Network read error in server read message operation Cause A non fatal internal er
121. e server configuration file failed Cause An internal error occurred Action Contact DataDirect Technologies technical support 3108 An operation on the NT registry failed Cause An internal error occurred Action Contact DataDirect Technologies technical support 3110 Failed to open the server configuration file for reading Cause An internal error occurred Action Contact DataDirect Technologies technical support 3111 Failed to open the server configuration file for writing Cause An internal error occurred Action Contact DataDirect Technologies technical support 3112 Failed to open the server configuration file because its syntax is incorrect Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 104 Chapter 6 Error Messages 3113 Failed to open the server configuration file because the file does not exist Cause An internal error occurred Action Contact DataDirect Technologies technical support 3114 Failed to save the server configuration file Cause An internal error occurred Action Contact DataDirect Technologies technical support 3115 Failed to save the server configuration file because the file backup failed Cause An internal error occurred Action Contact DataDirect Technologies technical support 3116 Failed to attach to the event queue Cause An internal error occurred Action Contact DataDirect Technologies t
122. e stated user has exceeded the timeout value that was coded for the stated application in the SYSINI The timeout value from the SYSINI is given together with the number of timer intervals that the thread has currently been inactive System action Not applicable User response None SequeLink Troubleshooting Guide and Reference VAIS190W VAIS191E Server Controller Task Messages 261 WARNING Server thread for User uuuuuuu with Thrdid tttttttt at terminal termid exceeded Timeout value Severity Explanation System action User response Warning An application service thread identified by its thread ID started by the stated user from the stated terminal has exceeded the timeout value that was coded for the application service being used The value of the IDLEACTION idle action parameter in the SYSINI was set to MESSAGE which causes an alert message to be displayed Each time that the timeout value set for the application service elapses while the application service thread has been inactive that is no messages have been passed to the attached workstation the server will produce an alert message Investigate the cause of the application s inactivity If desired the thread might be terminated using the CNTL ABORT command application name THREAD for USER user ID at THRDID T xxxxxx at terminal ID aborted due to timeout Severity Explanation System action User response Error An a
123. ead the reply sent from the SequeLink Server The session was aborted and the connection was closed Action Free memory resources If the problem persists contact DataDirect Technologies technical support 2203 Network resource problem session aborted due to remote buffer allocation failure connection closed Cause The SequeLink Server could not allocate internal buffers to read the request coming from the SequeLink Client The session was aborted and the connection was closed Action Free memory resources If the problem persists contact DataDirect Technologies technical support 2204 Internal network error session aborted due to local session protocol error connection closed Cause An internal error occurred Action Contact DataDirect Technologies technical support 2205 Internal network error session aborted due to remote session protocol error connection closed Cause An internal error occurred Action Contact DataDirect Technologies technical support 2206 Network problem cancel not allowed Cause The cancel feature was disabled by the SequeLink service Action If needed the cancel feature can be enabled by setting the service attribute ServiceCancelEnabled TRUE 2207 Internal network error session aborted due to session protocol data unit format error connection closed Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference
124. echnical support 3117 Failed to send event to event queue Cause An internal error occurred Action Contact DataDirect Technologies technical support 3118 Failed to access the event queue Cause An internal error occurred Action Contact DataDirect Technologies technical support 3119 Failed to send an event because a wait operation timed out Cause An internal error occurred Action Contact DataDirect Technologies technical support 3120 Failed to process the administration request because the specified handle has not been opened Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 105 3122 Failed to process the administration request because the version of the configuration file is not supported by this version of SequeLink Cause An attempt was detected to open a SequeLink configuration file with a SequeLink version that is incompatible with the current version of the installed SequeLink software Action Use a compatible version of the installed SequeLink software to open the SequeLink configuration file 3130 Failed to process to remote administration request Cause The administration request could not be processed by the server Action Preceding or subsequent messages contain more detailed information 3131 The requested entity was not found in the server configuration file Cause An internal error occurred
125. echnical support 9523 Graphic data is not supported by this version of the SequeLink for NET provider Cause This version of the NET data provider does not support graphic data Action Check your NET application 9532 Encryption algorithm not supported in this version Cause The encryption algorithm specified in the server configuration is not supported by this version of the NET data provider Action Check the ServiceEncryptionAlgorithm attribute in your SequeLink server configuration SequeLink Troubleshooting Guide and Reference 208 Chapter 6 Error Messages 9535 Connection timed out Cause Establishing a connection to SequeLink server timed out Action Specify a larger value for the Connection Timeout attribute in your connection string 9536 Command canceled Cause The command was successfully canceled by the user Action None SequeLink Troubleshooting Guide and Reference 209 Part 3 OS 390 Log Messages and Reference This part contains the following chapters m Chapter 7 Overview of OS 390 Log Messages on page 211 describes how OS 390 log messages are organized and formatted m Chapter 8 OS 390 Messages and Descriptions on page 213 lists OS 390 log messages that may be generated and provides a description for each message m Chapter 9 SAS C Runtime Library Messages on page 281 describes how SequeLink Server and SequeLink Manager report messages generated by the SAS C run
126. eck the AdminPort parameter in the proxy server configuration file m Make sure that a proxy server is not already running at the host 7785 SSL Unknown operation requested by system administrator Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7786 SSL Could not connect to proxy server check if the proxy server was started Cause An attempt was made to stop a proxy server but a proxy server was not found The proxy server may already be stopped Action Make sure the proxy server is started before stopping it 7787 SSL Cannot create data output stream over socket Cause An internal error occurred when trying to stop a running proxy server Action Check the console of the proxy server machine for more detailed error messages If necessary contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 193 7788 SSL Write to data output stream failed Cause An internal error occurred when trying to stop a running proxy server Action Check the console of the proxy server machine for more detailed error messages If necessary contact DataDirect Technologies technical support 7789 SSL Write to data output stream failed Cause An internal error occurred when trying to stop a running proxy server Action Check the console of the proxy server machine for mor
127. ed Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7765 SSL Closing server connection failed Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7766 SSL Internal error in server read message operation Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7767 SSL Network write error in server write SSL TLS Alert message Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7768 SSL Cannot add connection object to connection list Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7769 SSL Graceful disconnection failed Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7770 SSL Data transfer between client and server already active Cause A non fatal internal error occurred Action Check the proxy server log file for more
128. ed to use WLM enclaves User response None Error connecting to WLM IWMCONN reasoncode xxxxx Severity Error Explanation MVSGlobalWLMEnclaves is specified but SequeLink failed to register as a workmanager to WLM The reasoncode for the IWMCONN macro is displayed System action Sequelink Server is not enabled to use WLM enclaves User response Check the reasoncode for IWMCONN If necessary contact DataDirect Technologies technical support Disconnected from WLM as WorkManager Severity Information Explanation During shutdown of SequeLink Server SequeLink deregistered from WLM as a workmanager System action None User response None SequeLink Troubleshooting Guide and Reference 274 Chapter 8 OS 390 Messages and Descriptions VAIS356E VAIS357E VAIS360I VAIS361E Error disconnecting from WLM IWMDISC reasoncode xxxxx Severity Explanation System action User response Error SequeLink failed to disconnect from WLM as workmanager The reasoncode for the IWMDISC macro is displayed Sequelink Server continues with shutdown Check the reasoncode for IWMDISC macro If necessary contact DataDirect Technologies technical support No ConnectionToken found unable to disconnect from WLM Severity Explanation System action User response Error WLM ConnectionToken is invalid or not found Sequelink Server could not disconnect from WLM Internal Sequelink error If necessary c
129. efault JDBC driver that appears in the Get Driver URL window Databases A list of comma separated JDBC URLs The first item in the list appears as the default in the database selection window You can use one of these URLs as a template when you make a JDBC connection The default Config txt file contains example URLs for most databases InitialContextFactory Should be set to com sun jndi fscontext RefFSContextFactory if you are using file system data sources or com sun jndi ldap LdapCtxFactory if you are using LDAP ContextProviderURL_ The location of the bindings file if you are using file system data sources or your LDAP Provider URL if you are using LDAP Datasources A list of comma separated JDBC data sources The first item in the list appears as the default in the data source selection window SequeLink Troubleshooting Guide and Reference Troubleshooting the JDBC Driver 23 Starting DataDirect Test How you start DataDirect Test depends on whether you want to start it as an application or applet and your Java Virtual Machine ZH amp Asa Java application on Windows Run the testforjdbc bat E file located in the testforjdbc directory On Windows 98 and Me double clicking testforjdbc bat opens a DOS window and displays the error Out of environment space To prevent this use the following procedure a After installing SequeLink for JDBC Client locate the testforjdbc bat file in the testforjdbc directory bene
130. em wide platform specific log facility XP 200x NT gt X UNIX On Windows NT Windows 200x and Windows XP use the Event Viewer and look for messages in the Application Log where the Source is either SequeLink or the name of the service On UNIX messages are sent to the UNIX syslog service The messages will be sent by default as USER type messages the ServiceUnixSyslogFacility service attribute can be used to change the default message type The SequeLink administrator can edit the syslog conf file to configure the actual destination of these messages Refer to your UNIX documentation for more information SequeLink Troubleshooting Guide and Reference Configuring Logging 51 z OS mm OnOS 390 the SequeLink Server log files VAILOGP and VAILOGS are used to log all messages In addition to the service messages the SequeLink Server log contains all messages from other components such as the TCP IP listener and the DB2 interface Messages are sent first to VAILOGP the primary log When the primary log is almost full SequeLink Server sends a message to the operator s console to alert you to switch to the secondary log file VAILOGS A Configuring Logging Using the SequeLink Manager Snap in For information about using the SequeLink Manager Snap in refer to the SequeLink Administrator s Guide 1 Select the service for which you want to obtain a log file 2 Select the Configuration node 3 Select the Service
131. en creating a new ManagedConnection while using default connection manager included with the resource adapters Action Contact DataDirect Technologies technical support A JCAConnectionFactory should always specify a valid ManagedConnectionFactory when creating anew ManagedConnection It is an internal resource adapter error if it does not 4313 Unsupported Method Cause An attempt to call unlock on a connection handle that does not contain a valid physical connection A connection handle will not contain a valid physical connection if the connection handle was closed Action Do not call unlock on a connection handle that has been closed 5001 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5002 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5003 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5004 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5011 An internal error occurred Cause Action An unexpected error occurred Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 129 130 Chapter 6 Error Messages 5012 An internal error occurred Cause An unexpected
132. ends on the exact nature of the problem The system action depends on the exact nature of the problem The user response depends on the exact nature of the problem Threadid UR identifier UR state Severity Explanation System action User response Information The explanation depends on the exact nature of the problem The system action depends on the exact nature of the problem The user response depends on the exact nature of the problem SequeLink Troubleshooting Guide and Reference 238 Chapter 8 OS 390 Messages and Descriptions VAID105T Threadid UR identifier UR state Severity Trace Explanation The explanation depends on the exact nature of the problem System action The system action depends on the exact nature of the problem User response The user response depends on the exact nature of the problem SequeLink Troubleshooting Guide and Reference Multiplatform Log Messages 239 Multiplatform Log Messages Some log messages are generated by a Service Task and are not platform specific These messages begin a service name and in some cases a threadid followed by the name of the service anda specific error message See Chapter 6 Error Messages on page 73 for the specific details on the error code VAILO21E Tnnnnnnn ServiceName Hostname gt ErrorCode lt xxxx gt ErrorMessage lt tttttttttt gt Severity Error Explanation This is a generic message that is used for different
133. ent specifies the TCP IP port of the SequeLink Server 5156 LDAP Distinguished Name is missing Cause The LDAP Distinguished Name that identifies a unique LDAP entry was not specified in the connection information to the LDAP server SequeLink Troubleshooting Guide and Reference 136 Chapter 6 Error Messages Action Make sure that the connection information configured at the SequeLink Client specifies the Distinguished Name of the LDAP entry 5157 The specified LDAP entry didn t specify all required attributes to connect to the SequeLink Server Cause The specified LDAP entry identified by the Distinguished Name did not specify all the required attributes to connect to the SequeLink Server Action Check the LDAP entry in the LDAP directory to make sure that the LDAP entry specifies the complete connection information for SequeLink connections For information about configuring LDAP for SequeLink refer to the SequeLink Administrator s Guide 5158 LDAP return code xxxx XXXX Cause An LDAP return code was generated by the underlying LDAP implementation The return code contains parameters that provide more detailed information Action Refer to your LDAP product documentation to reference the return code generated by LDAP 5159 The initialization of the LDAP client failed Possible cause memory allocation failure Cause The initialization of the LDAP client failed A memory allocation failure may have occur
134. equeLink Troubleshooting Guide and Reference VAIX011E VAIX0121 VAIX0131 System action User response Resource Manager Messages 277 None This is an internal error Contact DataDirect Technologies technical support Invalid PARM passed Severity Explanation System action User response Error The R1 value that was passed was 0 or the address that R1 pointed to was 0 None This is an internal error Contact DataDirect Technologies technical support SSI has been deactivated Severity Explanation System action User response Information The resource manager had to reset the SSI None Contact DataDirect Technologies technical support Entering resource manager VAICOPRM Severity Explanation System action User response Information The resource manager is being entered Not applicable None SequeLink Troubleshooting Guide and Reference 278 Chapter 8 OS 390 Messages and Descriptions ThreadPool Task Messages This section contains messages generated by VAISTHRD This task is responsible for the Threadpool interface logic VAITO101 Sessionid ClientAddress A Userid Correlationld Severity Information Explanation This is a Header message resulting from THPL LIST operator command System action None User response None VAITO11I Sessionld ClientAddress A Userid Correlationld Severity Information Explanation This is the detail message resultin
135. erating system to allocate memory failed Action Free memory resources If the problem persists contact DataDirect Technologies technical support 2314 Internal network problem connection closed Cause An internal error occurred Action Contact DataDirect Technologies technical support 2315 Network problem unknown session conversation protocol Cause An attempt was made to connect to a SequeLink Server with an incompatible version of SequeLink Action Check the version of the SequeLink Server to make sure it is compatible with the current version of the installed SequeLink software If the problem persists contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 90 Chapter 6 Error Messages 2318 Network problem connection time out Cause The TCP IP connection could not be established within the set time limit Action Increase the time interval and try again to connect 2320 Network problem connection time out Cause The TCP IP connection to the server host could not be established within the set time limit Action Increase the time interval and try again to connect 2321 Network problem listener could not be started because port is already in use Cause The port specified for the SequeLink service was being used by another application Action Stop the application that is using the port or reconfigure the SequeLink service to use another port 2402 Session refused
136. error occurred Action Contact DataDirect Technologies technical support 5013 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5014 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5015 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5021 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5022 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5023 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5024 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 5031 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5033 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5034 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5043 An internal error occurred
137. errors off on war warnings off on info informationals off on debug debugging off on sspp ssppackets off on sspr ssprequests off on nu where service_name is the service to which the session belongs Service names can be obtained using the ServiceList sl command The following example turns on debug messages and turns off error messages in the debug log file for the SLOracle8 data access service sdll SLOracle8 debug on err off The change will take effect for all subsequent connections For information about using the SequeLink Manager Command Line Tool refer to the SequeLink Administrator s Guide SequeLink Troubleshooting Guide and Reference 54 Chapter 4 Using Debug Log Files zos Configuring Logging Using the SequeLink Manager for OS 390 For information about using the SequeLink Manager for OS 390 refer to the SequeLink Administrator s Guide 1 From the server management tree type beside the Service Settings node of the SequeLink service for which you want to obtain a log file The server management tree shows the attribute categories for the service 2 Type s beside the Logging attribute category to select it then press ENTER The AttributeList panel appears DataDirect SequeLink Manager for 0S 390 AttributeList Row 1 to 3 of 3 Dialog canceled MORE gt gt gt Service MVSDB2 Enter the ADD command to add an attr
138. ervice lt service name gt Cause The default server data source for the specified SequeLink service could not be found Action Contact DataDirect Technologies technical support 6913 Session monitoring has not been enabled for service lt service name gt Cause The monitoring profile enabled for the specified SequeLink service does not provide session or statement counters Action Enable a monitoring profile for the SequeLink service that uses session or statement counters For more information about enabling profiles for SequeLink services refer to the SequeLink Administrator s Guide 6914 Failed to start service lt service name gt Cause The specified SequeLink service could not be started Action Details about the failure are logged in the service debug log file the event trace file or the system logging facility Examine these details to troubleshoot the problem SequeLink Troubleshooting Guide and Reference 170 Chapter 6 Error Messages 7361 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 7362 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 7363 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 7364 An internal error occurred Cause An unexpected error occurred Action
139. es 412 The specified attribute ID xxxx has an incorrect type Cause An internal error occurred Action Contact DataDirect Technologies technical support 413 Failed to evaluate the profile filter expression for event with ID xxxx Cause The specified profile filter is not valid Action Correct the syntax of the profile filter 414 Profile filter evaluation failed because the expressions have incompatible types Cause The specified profile filter is not valid Action Correct the syntax of the profile filter 415 Failed to parse the expression because of a syntax error at position xxxx Cause The specified profile filter is not valid Action Correct the syntax of the profile filter 416 Failed to parse the profile filter expression Cause The specified profile filter is not valid Action Correct the syntax of the profile filter 417 The provided monitor path xxxx is invalid Cause The specified profile filter is not valid Action Correct the syntax of the profile filter 418 The specified action xxxx is not a valid event profile action Cause The specified profile filter is not valid Action Correct the syntax of the profile filter 419 An invalid parameter value xxxx was specified Cause The specified profile filter is not valid Action Correct the syntax of the profile filter SequeLink Troubleshooting Guide and Reference 79 420 The specified event profile action xxxx failed to parse
140. es 5513 Numeric value for parameter required Cause A parameter for the specified SequeLink Manager command required a numeric value Action Check the SequeLink Manager command help to verify the parameters for the command 5514 An invalid service template ID was specified Cause An invalid SequeLink service template ID was specified Action Make sure that you specify the correct SequeLink service template ID For more information about template IDs refer to the SequeLink Administrator s Guide 5515 Invalid option lt name gt Cause An invalid option for the specified SequeLink Manager command was supplied Action Check the SequeLink Manager command help to verify the specified command 5516 Invalid value for option lt name gt Cause An invalid value for the specified SequeLink Manager command option was supplied Action Check the SequeLink Manager command help to verify the command 5517 Help topic not found Cause The topic specified with the SequeLink Manager help command could not be found Action Specify help without arguments to see the topics for which help is available 5518 Invalid attribute index syntax Cause The attribute array index specified with the attribute name has an incorrect syntax The correct syntax for an attribute array index is for example AttributeName 25 Action Correct the syntax SequeLink Troubleshooting Guide and Reference 143 5519 Invalid log level lt name gt
141. ese additional levels only while you are troubleshooting How you turn on and off the logging option depends on your SequeLink Server platform See Configuring Logging on page 50 for information about setting debug levels Session Debug Log File on Windows NT Windows 200x and Windows XP Log File Name The log file name is servicename_sessionid_processid log where servicename is the name of the SequeLink service sessionid is a unique numeric identifier of the session processid is the numeric process identifier assigned by the operating system for the SequeLink service process Log File Location The ServiceDebugLogPath service attribute specifies the location of the file For more information about specifying SequeLink service attributes refer to the SequeLink Administrator s Guide SequeLink Troubleshooting Guide and Reference X UNIX z OS SequeLink Debug Log Files 45 Session Debug Log File on UNIX Log File Name The log file name is servicename_sessionid_processid log where servicename is the name of the SequeLink service sessionid is a unique numeric identifier of the session processid is the numeric process identifier assigned by the operating system for the SequeLink service process Log File Location The ServiceDebugLogPath service attribute specifies the location of the file For more information about specifying SequeLink service attributes refer to the SequeLink Administrator s Guide
142. everity Explanation Severe The operator interface component of the server system received a command from the operator s console The operator interface VAICOPRI was unable to assign a storage buffer to the command SequeLink Troubleshooting Guide and Reference VAIC113F VAIC114S VAIC1151 System action User response Operator Interface Messages 217 The entered command is ignored This is an internal error Report this message to DataDirect Technologies technical support VAICOPRI Error loading VAICOPRI VAICCMDS Terminating Severity Explanation System action User response Fatal The operator interface component of the server system failed in its attempt to load one of its external routines The server system abends with an abend code of U146 Verify the integrity of the server s executable library Recover the library from a backup tape if necessary Contact DataDirect Technologies technical support for assistance if you are unable to correct the library failure VAICOPRI TACB search for COMPONENT component ID failed command ignored Severity Explanation System action User response Severe The operator interface component of the server system received a command from the operator s console The command contained the stated route or component ID but the system could not locate a corresponding component The entered command is ignored Ensure that the componen
143. fid is currently busy Severity Explanation System action User response Information DB2 interface ifid is temporarily unable to process the requested DB2ASP command The DB2ASP command is ignored Reissue the command Syntax error invalid value in DB2ASP command SequeLink Troubleshooting Guide and Reference 228 Chapter 8 OS 390 Messages and Descriptions Severity Error Explanation DB2ASP command contains invalid data System action Command is ignored User response User correct syntax for DB2ASP command VAIDO34I There are no configured DB2 interfaces Severity Information Explanation A DB2 SHOW command detected no DB2 interfaces System action None User response None VAIDO35I DB2 interface ifid associated with ssid Severity Information Explanation Normal output of a DB2 SHOW command System action None User response None VAID036F Db2 module mmmmmm not loaded for Interface dddd Severity Fatal Explanation DB2ASP command contains invalid data System action Abend Server abend code User 801 User response Check that the correct DB2 Load Libraries are Concatenated to DD statement DB2ifid and are for the correct DB2 version VAIDO371 Server ASID asid asidx DB2 version xxxx Attachment aaaaa Severity Information Explanation This message is issued when DB2 STATUS command is entered and is preceded by VAID0271 message System action None User response
144. fied the correct UID Map in the MvVSServiceUIDMap service attribute For more information about valid values for SequeLink service attributes refer to the SequeLink Administrator s Guide 3420 Select statement not allowed in batch processing Cause You cannot execute a Select statement in a batch of statements Action Change your application so that Select statements are not included in the batch SequeLink Troubleshooting Guide and Reference 120 Chapter 6 Error Messages 3421 The maximum number of concurrent SQL statements is reached Cause Too many statements are open at the same time Action Close some statements before attempting to open a new statement 3422 Invalid value specified for scope Cause The value for the scope input parameter of SQLSpecialColumns or GetBestRowldentifier is not valid Action Contact DataDirect Technologies technical support 3423 Schema name specified too long Cause The schema name parameter of a data dictionary statement was too long Action Change the schema name in your application 3424 Table name specified too long Cause The table name parameter of a data dictionary statement was too long Action Change the table name parameter in your application 3425 Filter value specified too long Cause The filter value parameter of a data dictionary statement was too long Action Change the filter value in your application 3426 Column value specified too long Cause The value of a column
145. from line num of function offset hex C Extended name fullname message text Interrupted while context where severity is one of the following NOTE describes a condition that permits program execution to continue but which is not communicated to the caller of the routine errno is usually not set WARNING describes a condition that permits program execution to continue however the routine that detected the condition returns an error indication to its caller When a library WARNING is issued the errno variable is set Usually an error code is returned from the function that detected the condition Most library messages are WARNINGs ERROR describes a condition that forces program termination usually with an ABEND SequeLink Troubleshooting Guide and Reference 282 Chapter 9 SAS C Runtime Library Messages For an explanation of LSCX messages refer to your SAS C documentation available at http www sas com service library onlinedoc sasc doc diag sascdmv1 htm SequeLink Troubleshooting Guide and Reference
146. g Wait for the SequeLink service to stop completely and retry 3142 Failed to register the specified OS service because the service already exists Cause An attempt was made to register a SequeLink service with a name that was already used by another operating system service Action Make sure the name you choose for your SequeLink service is not being used by another operating system service 3143 The required primary key attributes were not provided Cause An internal error occurred Action Contact DataDirect Technologies technical support 3144 Requested operation on the specified OS service failed because a wait operation timed out Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 107 3145 The TCP port for the service could not be registered because it is registered for another network service Cause The SequeLink service is configured to use a TCP IP port that is registered for another network service on the machine If the other service is active it will not be possible to start the SequeLink service Action If you are confident that the network service for which the port was registered will never be active at the same time as the SequeLink service you created you can continue If unsure change the TCP IP port for the SequeLink service 3146 The TCP port for the service could not be registered unregistered because the services file
147. g from the THPL LIST operator command where SessionID is the sessionid of the connection ClientAddress is the IP address of the connected client A is the Activity indicator The value is when the connection is executing an RPC otherwise this value is left blank Userid is the PrimaryAuthid used for DB2 connection or the Userid for an Administrator connection Correlationld is the Correlationid within the DB2 subsystem otherwise this value is set to the string Adminstrator System action None User response None VAITO12I Kill request for Sessionld ssss scheduled Severity Information Explanation This is a response from the THPL KILL operator command SequeLink Troubleshooting Guide and Reference VAITO14E VAITO15E VAITO16E VAITO17T ThreadPool Task Messages 279 System action The Server will try to kill the session User response None Operator command cccccccc unknown Severity Error Explanation The THPL command was not recognized System action The command was ignored User response Enter a valid THPL command No connection found for Sessionld ssss Severity Error Explanation The Session with Sessionld ssss was not found System action The command was ignored User response Provide a correct Sessionld as the argument of THPL LIST command Invalid Sessionld format should be numeric Severity Error Explanation The Sessionid argument of the THPL KIL
148. g the value set for the ServiceDB2MaxThread service attribute Action Increase the value of the ServiceDB2MaxThread service attribute 3445 Virtual storage limits exceeded Cause Insufficient storage was available at the server No more DB2 connections could be accepted Action Try the connection again 3446 DataSourceTransactionlsolation attribute has a unsupported value Cause DataSourceTransactionlsolation attribute missing Action Ask the administrator to add DataSourceTransactionlsolation attribute 3447 Abend occurred due to an internal error in IBM DATABASE 2 DB2 processing Cause DB2 had been abended and trapped within the session Action Ask the system operator to look for message VAI046 in VAILOG SequeLink Troubleshooting Guide and Reference 124 Chapter 6 Error Messages 3448 This functionality is not supported for this database version Cause An internal error occurred Action Contact DataDirect Technologies technical support 3449 Maximum cputime limit has been exceeded DB2 thread aborted Cause The session has exceed its maximum CPU time as set by the DataSourceMaxCpuTime attribute Action None 3501 Unsupported transaction isolation level Cause An attempt was detected to change the transaction isolation level to an isolation level that is unsupported by Informix Action Use a transaction isolation level that is supported by the Informix database 3502 Internal error Failed to translate the user spe
149. ger command provides the correct number of parameters 5532 A attribute index must be specified for this attribute Cause When deleting or replacing an array attribute with a SequeLink Manager command an index must always be specified Action Make sure that an index is specified and the syntax is correct 5533 Specified attribute is no array attribute Cause An index was provided in a SequeLink Manager command with an attribute that is not an array attribute Action Make sure that no index is specified and the syntax is correct 6000 Error loading error messages Cause An unexpected error occurred while loading the error messages Action Contact DataDirect Technologies technical support 6001 0 Cause Generic error occurred At runtime an error message from the JDK will be displayed Action Check the error message 0 for the appropriate action 6002 Specified parameter values not supported for method 0 Cause The parameters specified for method 0 contain invalid values Action Check your JDBC application 6003 Unsupported method 0 Cause The method 0 is not supported by this version of the JDBC driver Action Verify the method 0 in your JDBC application SequeLink Troubleshooting Guide and Reference 146 Chapter 6 Error Messages 6004 Invalid operation for the current cursor position Cause This method invocation is only valid when the result set has a current row Action Check your JDBC application 6
150. haracters or less Then restart the SequeLink Server 6851 Memory allocation failure Cause No memory could be allocated Action Free memory resources If the problem persists contact DataDirect Technologies technical support 6852 Internal SequeLink Administration error detected l lt number gt Cause An internal error occurred in the SequeLink Manager Action Contact DataDirect Technologies technical support 6853 Failed to access configuration at lt string gt Cause SequeLink failed to open the SequeLink configuration file because an invalid connection string to a SequeLink Agent was specified or an invalid path to a SequeLink configuration file was specified Action Re attempt to open the SequeLink configuration with a correct connection string or a correct path 6854 Failed to cache configuration information Cause An error occurred while caching configuration information from a SequeLink Agent or from a SequeLink configuration file Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 162 Chapter 6 Error Messages 6855 Invalid attribute ID lt id gt Cause An invalid service attribute ID was specified Action Specify a valid ID for the service attribute For more information about specifying SequeLink service attributes refer to the SequeLink Administrator s Guide 6856 Value for attribute lt D or name gt is no numeric value Cause The servi
151. he cipher suite lt cipher suite gt is not supported Cause The client or the proxy server specified an unsupported cipher suite NOTE exportable cipher suites are not supported by this release of SequeLink Use the corresponding cryptographic strong cipher suite Action m Check the CipherSuites connection parameter at the client m Check the CipherSuites parameter in the proxy server configuration file 7930 SSL The cipher suite lt cipher suite gt is unknown Cause The client or the proxy server specified an unknown cipher suite Action m Check the CipherSuites connection parameter at the client m Check the CipherSuites parameter in the proxy server configuration file 7931 SSL No cipher suite has been specified Cause No cipher suite has been specified by the client or the proxy server Action wm Check the CipherSuites connection parameter m Check the CipherSuites parameter in the proxy server configuration file 7932 SSL Problem reading files required for certificates Cause An error occurred while reading the specified certificate by the proxy server Action wm Check the detailed error messages m Check the RSACertificate parameter in the proxy server configuration file m Check the DSSCertificate parameter in the proxy server configuration file 7934 SSL Certificate Checker class not found Cause The user supplied class implementing the Certificate Checker interface was not found in the classpath by the SequeLink Clien
152. he result sets Otherwise modify your application so that it uses execute instead of executeUpdate SequeLink Troubleshooting Guide and Reference 156 Chapter 6 Error Messages 6084 Discarded rows affected count during executeQuery Cause The application used executeQuery for a SQLStatement that also returns update counts Action Check your JDBC application if you really want to discard the update counts Otherwise modify your application so that it uses execute instead of executeUpdate 6085 Execution timeout expired Cause A timeout expired Action Check the SQL statement used by your application If it is correct increase the query timeout value 6086 Can t set a savepoint during global transaction Cause You cannot set a savepoint during global transactions Action Check your JDBC application 6087 Can t release a savepoint during global transaction Cause You cannot release a savepoint during global transactions Action Check your JDBC application 6088 The requested parameter metadata is not available for the current statement Cause The requested parameter metadata is not available Action Check your JDBC application 6089 On a deleted row Can not perform operation Cause The method invocation is only valid if not positioned on a deleted row Action Check your JDBC application 6501 A required input parameter could not be read Cause An internal error occurred Action Contact
153. hine for more detailed error messages m Verify that the required file privileges are set m Make sure that no other process is using the log file 7781 SSL Seek in log file failed Cause An internal error occurred when processing an existing log file Action om Verify that the required file privileges are set m Make sure that no other process is using the log file m If the previous actions do not resolve the problem contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 192 Chapter 6 Error Messages 7782 SSL Get file descriptor failed Cause An internal error occurred when processing an existing log file Action mm Verify that the required file permission are set m Make sure that no other process is using the file m If the previous actions do not resolve the problem contact DataDirect Technologies technical support 7783 SSL Cannot create file outputstream Cause An error occurred when trying to write to the proxy server log file Action m Check the proxy server console for more detailed error messages m Verify that the required file permissions are set 7784 SSL Cannot create endpoint for proxy server administration Cause The Proxy server was unable to create the TCP IP socket to listen for incoming administration requests The proxy server may already be running or an invalid TCP IP port may have been specified Action m Check the detailed exceptions m Ch
154. his message is displayed when a DB2 STATUS command is issued ssss is the subsystem ID of the DB2 address space ccccc is either ACTIV or INACT 00000 is the DB2 stop option specified in the SYSINI System action None User response None VAIDO28I Already connected to DB2 request ignored Severity Information SequeLink Troubleshooting Guide and Reference VAIDO291 VAIDO301 VAIDO3 11 VAIDO321 VAID033E Explanation System action User response DB2 Application Support Package Messages 227 An operator issued a DB2 CONNECT command but SequeLink or OS 390 was already connected to the DB2 address space Command ignored None Already disconnected from DB2 request ignored Severity Explanation System action User response Information An operator issued a DB2 DISCONNECT command but SequeLink or OS 390 was already disconnected from the DB2 address space Command ignored None Issuing DB2 cccccccc per operator request Severity Explanation System action User response Information DB2ASP is executing DB2 request cccccccc CONNECT or DISCONN in response to an operator request DB2 request cccccccc is issued None ID ifid is an unknown DB2 interface Severity Explanation System action User response Information DB2 interface ID ifid is not known The DB2 command is ignored Correct ifid and reissue the command Db2 interface i
155. hnical support 6527 MGSS module returned an unknown major status code Cause An internal error occurred Action Contact DataDirect Technologies technical support 6801 Name given to entity instance is longer than 8 characters Cause An error occurred during the startup of the SequeLink Server because the service name assigned to a SequeLink service or DB2 Interface was longer than 8 characters Action Make sure that the service name of the SequeLink service or DB2 interface does not exceed 8 characters Change the configuration of the SequeLink service or DB2 interface if necessary Then restart the SequeLink Server SequeLink Troubleshooting Guide and Reference 161 6802 No unique agent service found Cause An error occurred during the startup of the SequeLink Server because a SequeLink Agent service was not created for the SequeLink Server or more than one SequeLink Agent service had been created for the SequeLink Server The SequeLink Server will not start Action Create the missing SequeLink Agent service or delete any duplicate SequeLink Agent services in the SequeLink Server configuration 6803 Name given to the agent service is longer than 8 characters Cause An error occurred during the startup of the SequeLink Server because the name of an OS 390 SequeLink Agent service was longer than 8 characters The SequeLink Server will not start Action Change the name of the OS 390 SequeLink Agent service to be 8 c
156. hnologies technical support may ask you to provide a debug log file SequeLink Server uses the following types of debug log files m Session debug log file contains information related to all server processing in the context of a client session See the following section SequeLink Server Session Debug Log File for more information m Service debug log file contains information related to service related processing any kind of processing that occurs outside the context of a client session See SequeLink Service Debug Log File on page 46 for more information SequeLink Server Session Debug Log File The SequeLink Server Session debug log file contains information related to all processing that occurs in the context of a client session Each debug log file includes a fixed header that contains installation specific information When you consult DataDirect Technologies technical support you may be asked for the contents of this log file The name and SequeLink Troubleshooting Guide and Reference 44 Chapter 4 Using Debug Log Files XP 200x NT location of the SequeLink Server Session debug log file depend on your SequeLink Server platform The information that is logged depends on the value set for the ServiceDebugLogLevel service attribute By default logging is enabled for Fatal Error messages Enabling additional logging levels uses considerable disk space and slows processing We recommend that you enable th
157. ibute or perform one of the actions below on a specific attribute o S elect o C hange o D elete o Help Name Value ServiceDebugLogLevel 1 ServiceDebugLogPath tmp ServiceEventTraceSize 1000000 kkkkkkkkkkkkkkkkkkkkkkkkkkkkk Bottom of data kkkkkkkkkkkkkkkkkkkkkkkkkkkkk COMMAND gt SCROLL gt PAGE NOTES m Your screen may not be able to display all attributes at once Press F7 and F8 to scroll up and down the attribute list m To display help about an attribute type beside the attribute then press ENTER SequeLink Troubleshooting Guide and Reference Configuring Logging 55 3 Type C beside the ServiceDebugLogLevel attribute then press ENTER The Attribute Display window appears DataDirect SequeLink Manager for 08 390 Row 1 to 7 of 7 ServiceDebugLogLevel Bitmask currently in effect Use S or to select bits to set Bit description Errors Warnings Informational Debug SSP Packet Log SSP Requests COMMAND gt SCROLL gt PAGE 4 Type beside one or multiple log options then press ENTER You are returned to the AttributeList panel and the attribute value if valid is changed 5 Press F3 to return to the server management tree The change will take effect for all subsequent connections SequeLink Troubleshooting Guide and Reference 56 Chapter 4 Using Debug Log Files Changing the Debug Log Level for Active Services and Sessions You can change the debug
158. id action parameter was detected while processing a monitor request Cause An internal error occurred Action Contact DataDirect Technologies technical support 3051 Due to a fatal error condition with the DBMS session no new request can be processed Cause A serious error has previously occurred within the DBMS session Action The client application must disconnect 3052 Maximum cputime limit has been exceeded Cause The session has exceeded his maximum CPU time no more request are allowed Action The client application must disconnect 3053 Only select and batch statements are allowed in this read only connection Cause The DataSourceReadOnly service attribute was set to select and batches and the application tried to execute a statement that was not a Select statement or a Batch statement Action Change your application or change the DataSourceReadOnly service attribute For information about valid values for SequeLink service attributes refer to the SequeLink Administrator s Guide 3054 Found syntax error s within the DataSourceSessionToken attribute Cause Syntax error in DataSourceSessionToken attribute Action Verify that the DataSourceSessionToken attribute contains valid placeholders SequeLink Troubleshooting Guide and Reference 99 3055 Found syntax error s within the DataSourceAutoApplld attribute Cause Syntax error in one of the DataSourceAutoApplld attribute entries Action Verify
159. ies technical support 3006 Internal error a fatal error was detected during event processing Cause An internal error occurred Action Contact DataDirect Technologies technical support 3007 Internal error an invalid argument was specified Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 95 3008 OSLogon authentication mechanism requires root privilege Cause An attempt was made to authenticate a connection to a UNIX SequeLink Server using the OSLogon mechanism but the UNIX SequeLink Server is not running as root Action Make sure that the UNIX SequeLink Server is running as root 3009 Authentication failed Cause The service attribute is set to ServiceDetailedOSLogonErrors FALSE and the OSLogon authentication process detected an error Action Correct the authentication information typically the user or password If the problem persists contact your system administrator to find out why the specified user is not allowed access to the server 3010 Could not create a log file in ServiceDebugLogPath Cause A session Debug Log File could not be created Action Verify that the UNIX System Services HFS directory specified in the ServiceDebugLogPath service attribute exists and the Userid of the Server has authorization to create a file in this directory In addition check whether the file system is full 3011 Unable to find the spec
160. ified session in the list of active sessions while processing the kill session request Cause The service received a session ID of a non existing session Action None 3012 Configuration file was changed by someone else Cause The configuration file has been modified by another administrator Action Reload the configuration file and make the changes again 3013 The value for maximum number of threads maxv exceeds the OS defined limit maxosv maximum threads downgrading to OS limit Cause The value of the ServiceMaxThreads service attribute is higher than the operating system allows The service will only use the number of thread allowed by the operating system Action Correct the value of the ServiceMaxThreads service attribute SequeLink Troubleshooting Guide and Reference 96 Chapter 6 Error Messages 3014 The value for minimum number of threads maxv exceeds the value for maximum number of threads minv downgrading min to max value Cause The value of the ServiceMinThreads service attribute is higher than the value of the ServiceMaxThreads service attribute The service will use the value of the ServiceMaxThreads service attribute as the value for the minimum number of threads Action Correct the value of the ServiceMinThreads service attribute 3016 Unable to configure enough threads 6 for the thread pool Cause The value of the ServiceMinThreads service attribute is not a valid value The service will
161. ing to investigate problems SequeLink Server for ODBC Socket complies with the ODBC specification This means that you can use standard tools such as ODBC Tracing to analyze and investigate problems or unexpected behavior ODBC tracing for the SequeLink backend ODBC driver can be enabled with the DataSourceMSSODBCLogPath attribute For more information refer to the SequeLink Administrator s Guide Releasing Locks Held by Disassociated DB2 Threads Errors can occur when a transaction branch becomes disassociated from the thread of control This can cause problems with locks that are held by disassociated DB2 threads An XA transaction branch starts with xa_start to register a new transaction branch with the resource manager and ends with xa_end when the application completes a portion of its work either partially or in its entirety When xa_end is successfully returned the calling thread of control is no longer actively associated with the branch but the branch still exists The transaction manager then calls xa_prepare to request a resource manager to prepare the work performed in that transaction branch for commitment During the time between the xa_end and the xa_prepare the transaction branch represented by an RRS context is no longer associated with the thread of control This disassociated RRS context can hold resources in the resource manager on behalf of the transaction branch The unit of recovery state for thi
162. ink Troubleshooting Guide and Reference 206 Chapter 6 Error Messages 7954 SSL Unexpected InterruptedExecption occurred while reading the pass phrase Cause An internal error occurred when requesting the user for the proxy server pass phrase using a dialog box Action Contact DataDirect Technologies technical support 7955 SSL SSL TLS handshake failure Cause The client attempted to make an SSL connection to the proxy server but an error occurred during the initial SSL connection setup Action m Check the CipherSuites client connection attribute and the corresponding parameter in the proxy server configuration file m Check the CertificateChecker client connection attribute m Check the proxy server log file for more detailed error information 7956 SSL Input of pass phrase interrupted by user Cause Because the proxy server is configured to use SSL with cipher suites that require access to the private key the proxy server prompts at startup for the pass phrase to use to decrypt the private key This operation has been cancelled from the dialog by the user Action m Check the Network parameter in the Proxy Server configuration file m Check the CipherSuites parameter in the Proxy Server configuration file 9501 Handshake failure You are trying to connect to a server that is not a SequeLink Server Cause An attempt was made to connect to a server that is not a SequeLink Server Action Make sure that the connection i
163. invalid Cause An internal error standard MGSS error occurred Not used by the standard SequeLink authentication modules Action Contact DataDirect Technologies technical support 7843 SSL The referenced credentials have expired Cause An internal error standard MGSS error occurred Not used by the standard SequeLink authentication modules Action Contact DataDirect Technologies technical support 7844 SSL The context has expired Cause An internal error standard MGSS error occurred Not used by the standard SequeLink authentication modules Action Contact DataDirect Technologies technical support 7845 SSL Miscellaneous failure unspecified at the MGSS level Cause An internal error standard MGSS error occurred Not used by the standard SequeLink authentication modules Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 199 7846 SSL The quality of protection requested could not be provided Cause An internal error standard MGSS error occurred Not used by the standard SequeLink authentication modules Action Contact DataDirect Technologies technical support 7847 SSL The operation is forbidden by local security policy Cause An internal error standard MGSS error occurred Not used by the standard SequeLink authentication modules Action Contact DataDirect Technologies technical support 7848 SSL The operation or option is unavailable Cause An i
164. ion User response Error The given RRS call failed for reason rrrrrrrr User logon or thread association will fail Refer to the Resource Recovery information in your MVS programming documentation for the explanation and action Ttttttttt RRSAF callname ReturnCode rrrrrrrr ReasonCode rrrrrrrr Severity Explanation System action User response Error The given RRSAF call failed User logon or Thread association failed Refer to the reason code in your DB2 documentation for the recommended user response Ttttttttt CAF callname ReturnCode rrrrrrrr ReasonCode rrrrrrrr Severity Explanation System action User response Error The given CAF call failed User logon will fail Refer to the reason code in your DB2 documentation for the recommended user response Ttttttttt CTXBEGC Contxt context RmToken rmtoken Severity Explanation System action User response Trace Arguments passed to the RRS Begin_Context service None None SequeLink Troubleshooting Guide and Reference 232 Chapter 8 OS 390 Messages and Descriptions VAIDO54T Ttttttttt CTXSWCH Contxt context DisAssocContxt context Severity Trace Explanation Arguments passed to the Switch_Context RRS service System action None User response None VAIDOS5T Ttttttttt CTXEND Contxt context ComplType type Severity Trace Explanation Arguments passed to the End_Context RRS service System action None Use
165. ion Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 2255 87 Connection closed non SequeLink IIOP message format error received Cause Action An IIOP message format error was received from a server that was not a SequeLink Server The session was aborted and the connection was closed Make sure the client application is connecting to a SequeLink Server If the problem persists contact DataDirect Technologies technical support 2300 Network problem connection unexpectedly closed by peer Cause Action The server closed the transport connection If logging was enabled the message give up waiting for incomplete record will be recorded in the service debug log file This error can occur when the server does not recognize the handshake request Make sure the client application is connecting to a SequeLink Server If the problem persists contact DataDirect Technologies technical support 2302 TCP IP error the remote host cannot be reached from this host at this time Cause Action TCP IP cannot establish a connection with the SequeLink Server host because no route to the SequeLink Server was found Make sure that m The network configuration is correct m A network route to the SequeLink Server is available m The SequeLink Server is active Try another TCP IP network application to verify whether the server is reachable 2303 TCP IP
166. iptions User response Respond to the reason given for the failure accordingly Not Active the application service is not active check for previous VAILOG messages relating to the application service and correct the error that prevented the successful validation and activation of the application service Stopped an Il or console operator stopped the application service with a CNTL ALTER command restart the application service AtMaxsess the maximum number of application threads for this application service was reached increase this value by using the CNTL ALTER command or by changing the SYSINI MAXIMUMSESSIONS value in the application service definition Refer to the SequeLink Administrator s Guide for details regarding CNTL ALTER Contact DataDirect Technologies technical support for details of the SIL definitions required for an application service VAIS176E SIL section LOADTBL2 omitted Severity Error Explanation Internal error System action Server initialization continues User response Contact DataDirect Technologies technical support VAIS177E NAME key omitted in LOADTBL2 Severity Error Explanation Internal error System action Server initialization continues User response Contact DataDirect Technologies technical support VAIS178E Syntax error in LOADTBL2 NAME Severity Error Explanation Internal error System action Server initialization continues User response Contact DataDirect Te
167. irect Technologies technical support 5067 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5069 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 5070 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5071 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5101 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5102 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5103 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5104 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5105 A memory allocation error occurred Cause SequeLink was unable to allocate the necessary amount of memory Action Increase the available memory for your application 5106 A memory allocation error occurred Cause SequeLink was unable to allocate the necessary amount of memory Action Increase the available memory for
168. is error 3413 More result sets have to be returned than defined Cause An internal error occurred Action Contact DataDirect Technologies technical support 3414 Parameter list contains invalid data type Cause The parameter list of a stored procedure contains an invalid or unsupported data type Action Change the stored procedure in your application SequeLink Troubleshooting Guide and Reference 119 3415 Conversion of a floating point number to a SequeLink decimal has failed Cause An internal error occurred Action Contact DataDirect Technologies technical support 3416 Some bind variables have not been defined Cause Some required parameter markers have not been defined by the application Action Correct your application 3417 Invalid data type conversion requested Cause An internal error occurred Action Contact DataDirect Technologies technical support 3418 UIDMap associated with the service not found Cause The specified UID Map could not be located Action Make sure that the name of the UID Map you specify in the MvVSServiceUIDMap service attribute is correct For more information about valid values for SequeLink service attributes refer to the SequeLink Administrator s Guide 3419 Access denied user cannot be found in UIDMap Cause The specified user was not found in the UID Map Action Make sure that you have correctly defined the specified user in the UID Map Also make sure that you have speci
169. is not found An invalid column name has been specified Cause The specified column was not found An invalid column name was specified Action Check your JDBC application 7424 The method 0 does not apply to columns of type 1 Cause The specified method does not apply to this type of column Action Check your JDBC application 7425 A batch cannot contain SQL statements that return a result set Cause A batch cannot contain SQL statements that return a result set Action Check your JDBC application Make sure that only row count generating statements are used in a batch 7426 Driver does not support batches containing stream variables Cause The JDBC driver does not support large objects in batches Action Check your JDBC application 7427 Handshake failure You are trying to connect to a server that is not a SequeLink Server Cause An attempt was made to connect to a server that is not a SequeLink Server Action Make sure that the connection information configured at the SequeLink Client is specified correctly to connect to the SequeLink Server SequeLink Troubleshooting Guide and Reference 177 7428 Handshake failure You are trying to connect to a server that is not a SequeLink Server Cause The SequeLink Client is incompatible with the version of the SequeLink Server to which it tried to connect Action Verify that the versions of your SequeLink Client and SequeLink Server are compatible Contact DataDirect
170. k service or server data source Action Specify a valid attribute for the SequeLink service or server data source For more information about specifying SequeLink service attributes refer to the SequeLink Administrator s Guide 6871 Attribute lt D or name gt may be added only once Cause An attempt to add an attribute that already existed in the SequeLink service or server data source configuration was detected Action None 6872 Attribute lt D or name gt is a primary key Cause The specified attribute is required by the SequeLink service or server data source and cannot be deleted Action None 6873 Attribute lt D or name gt not found in lt object gt Cause The specified attribute cannot be found in the SequeLink service or server data source Action Check your SequeLink service or server data source configuration to verify that the specified attribute exists in the configuration For more information about specifying SequeLink service attributes refer to the SequeLink Administrator s Guide 6874 Attribute lt D or name gt must at least exist once in lt object gt Cause The specified attribute could not be found in the SequeLink service or server data source Action Check your SequeLink service or server data source configuration to verify that the specified attribute exists in the configuration For more information about specifying SequeLink service attributes refer to the SequeLink Administrator s Guide
171. layed clicking the left hand button synchronizes the contents of the right hand pane with its location in the table of contents The next two buttons navigate to the previous and following pages The two buttons at the right end of the menu bar allow you print or bookmark the page The program group for SequeLink also contains an icon for launching the help system There are three navigation buttons at the left end of the grey menu bar at the top of the help screen Clicking the left hand button synchronizes the contents of the right hand pane with its location in the table of contents The next two buttons navigate to the previous and following pages The two buttons at the right end of the menu bar allow you print or bookmark the page SequeLink Troubleshooting Guide and Reference Conventions Used in This Book 11 Conventions Used in This Book The following sections describe the typography terminology and other conventions used in this book Typographical Conventions This book uses the following typographical conventions Convention italics bold UPPERCASE monospace monospaced italics forward slash vertical rule Explanation Introduces new terms with which you may not be familiar and is used occasionally for emphasis Emphasizes important information Also indicates button menu and icon names on which you can act For example click Next Indicates the name of a file For operating environments tha
172. level and select Properties Click the Debug Log Level tab and change the debug trace level by selecting one or multiple check boxes For more information about using the SequeLink Manager Snap in refer to the SequeLink Administrator s Guide SequeLink Troubleshooting Guide and Reference Changing the Debug Log Level for Active Services and Sessions 59 gq Changing the Debug Log Level for an Active se Session Using the SequeLink Manager Command Line Tool Use the SequeLink Manager command ServiceDebugLogLevel which has the format SessionDebugLogLevel sesdll service name dis disable enall enableall en enable ferr fatalerror off on err errors off on war warnings off on info informationals off on debug debugging off on sspp ssppackets off on sspr ssprequests off on a where service_name is the service to which the session belongs Service names can be obtained using the ServiceList sl command Example A The following example displays the current settings of the debug log for session 5 of the SLOracle8 data access service sesdll SLOracles8 5 Example B The following example turns on debug messages and turns off error messages in the debug log for session 5 of the SLOracle8 data access service sesdll SLOracle8 5 debug on err off NOTE The SessionDebugLogLevel command is not applicable
173. licable None SequeLink Troubleshooting Guide and Reference 258 Chapter 8 OS 390 Messages and Descriptions VAIS1821 VAIS1831 VAIS184E Application name application name STATUS xx DEBUG flag Severity Information Explanation This message follows a VAIS181I message It is output in response to a CNTL STATUS command It reflects the current status xx of the named application service This message also shows the setting of the DEBUG flag for the application service this is Y DEBUG is on or N DEBUG is off System action Not applicable User response The fields in the message include xx is a 1 byte hexadecimal flag that shows the status for this application at startup time 01 service is active and available 02 abort at time out 04 message only at time out 08 ignore time outs 80 service has been stopped by user MAXSESS number CURRSESS number TIMEOUT value Severity Information Explanation This message follows a VAIS181I message It is output in response to a CNTL STATUS command It reflects the current values for the maximum number of sessions the current number of sessions and the time out value for the application service System action Not applicable User response None Show keyword is in error Severity Error Explanation This message is output in response to an incorrect CNTL STATUS command It indicates that the SHOW keyword in the command was not valid
174. lication 6032 The hexadecimal string is invalid Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 6033 Unable to determine the type of the specified object Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 6036 Syntax error at token 0 line 1 offset 2 Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 6037 Unexpected end of escape Cause An unexpected error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 150 Chapter 6 Error Messages 6038 Error setting up static cursor cache Cause An unexpected error occurred while setting up the static cursor cache Action Obtain the next exception for more information If necessary contact DataDirect Technologies technical support 6039 Error writing data to static cursor cache Cause An unexpected error occurred while writing to the static cursor cache set up Action Obtain the next exception for more information If necessary contact DataDirect Technologies technical support 6040 Error reading data from static cursor cache Cause An unexpected error occurred while writing to the static cursor cache set up Action Obtain the next exception for more information If necessary contact DataDirect Technologies technical support 6041 0 is not a valid row parameter value for the
175. ller Task Messages 265 None None Tttttttt Maxcpu has been exceeded for this connection CPU usage ssss secs Severity Explanation System action User response Information When DataSourceMaxCpuTime has been exceeded this message shows the offending Threadid and the number of CPU seconds consumed until now If DataSourceMaxCpuAction is ABORT the connection will be abended also Check why this connection consumed so much CPU usage Start Thread for Service ssssssss at terminal termid for user uuuuuuu queued Severity Explanation System action User response Trace A request to establish a connection to the server from the stated user at the stated terminal was successfully validated by the server s start thread process The service request identified by its service name has been queued to the server s SCT for further validation The connection request is queued to the SCT None Thread tttttttt for service sssssss at termid exceeded its timer cycle CPU time limit Severity Explanation System action User response Warning Thread exceeds its ServiceThrottle limit within a Timelnterval None Check why thread exceeds its limits SequeLink Troubleshooting Guide and Reference 266 Chapter 8 OS 390 Messages and Descriptions VAIS212W VAIS213E VAIS215E Thread tttttttt for service sssssss at termid exceeded its max allowed CPU time limit Severity
176. llowing symbols are used to identify that information A Windows Information specific to the Microsoft Windows 98 Windows Me Windows NT Windows 2000 Windows Server 2003 32 bit and Windows XP environment is identified by Windows symbol Windows NT Information specific to the Microsoft Windows NT environment is identified by the Windows symbol and the letters NT Windows 200x Information specific to the Microsoft Windows 2000 and Windows Server 2003 32 bit environment is identified by the Windows symbol and the characters 200x Windows Servers Information specific to the Microsoft Windows platforms on which SequeLink Server runs is identified by the Windows symbol and the word Server SequeLink Troubleshooting Guide and Reference Contacting Technical Support 13 ee Windows Clients Information specific to the Microsoft Client Windows platforms on which SequeLink Client runs is identified by the Windows symbol and the word Client a Windows XP Information specific to the Microsoft SD Windows XP environment is identified by the Windows symbol and the letters XP X UNIX Information specific to UNIX environments is UNIX identified by this symbol which applies to all UNIX environments supported UNIX is a registered trademark in the United States and other countries licensed exclusively through X Open Company Ltd z OS Information specific to z OS and OS 390 2 05 environments is identified by the
177. lt object gt exists Cause No instance of object exists Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 166 Chapter 6 Error Messages 6883 lt object gt already exists Cause The SequeLink service name or the server data source name already exists Action Contact DataDirect Technologies technical support 6884 lt object gt still used by service lt service name gt Cause The object is still used by the specified SequeLink service Action Contact DataDirect Technologies technical support 6885 Cannot delete required attribute lt D or name gt Cause The attribute cannot be deleted because it is required Action Contact DataDirect Technologies technical support 6886 Unable to determine event trace location for service lt service name gt Cause An event trace file for the SequeLink service could not be located Either SequeLink service information could not be retrieved or the ServiceEventTraceLocation service attribute could not be found in the service information Action Make sure that the SequeLink service is active If it is check the ServiceEventTraceLocation service attribute to make sure that it is specified correctly For more information about specifying SequeLink service attributes refer to the SequeLink Administrator s Guide 6887 Event trace not available for service lt service name gt Check if the service is running and an event t
178. mes reports multiple internal errors When you examine the SequeLink packet log you see the following messages Wed Jan 10 10 39 45 2001 Internal error error detected in the event processor Wed Jan 10 10 39 45 2001 SequeLink Common Library SWANDM Entity FindFirstKeyValue 3820 21 The specified attribute does not exist Wed Jan 10 10 39 45 2001 SequeLink Common Library SWANDM Entity FindFirstKeyValue 3820 21 The specified attribute does not exist Wed Jan 10 10 39 45 2001 Internal error error detected in the event processor Wed Jan 10 10 39 45 2001 Internal error error detected in the event processor To avoid internal errors when changing the connection model perform the following steps 1 Make sure the services have the ServiceConnectionModel attribute set to the value you want 2 Delete both the Monitoring profile and Event trace profile of the services that have changed Create new Monitoring and Event trace profiles Stop all SequeLink services Stop the Agent Restart the Agent n oO uu A W Restart all SequeLink services SequeLink Troubleshooting Guide and Reference Connecting with SequeLink Server for ODBC Socket 37 Connecting with SequeLink Server for ODBC Socket The SequeLink Server for ODBC Socket is a service that provides data access to any database that is accessible through an ODBC 2 0 or 3 0 compliant driver Because SequeLink accesses the database by using the driver manager and the ODBC d
179. message contains the following information Severity This is the security level of the message Explanation This indicates the most probable reason for the message System action This summarizes how the system reacts to the message User response This indicates the action you should take SequeLink Troubleshooting Guide and Reference 213 8 OS 390 Messages and Descriptions This chapter lists OS 390 log messages that you may see in the primary VAILOGP or secondary VAILOGS Service debug log files NOTE The first message of the service debug log file contains the version of the Sequelink Server you are running Operator Interface Messages This section contains OS 390 log messages generated by VAICOPRI which handles operator interface processing VAICO33I Occurs when trying to execute LOGR PRINT Severity Information Explanation If the VAILOGP is sent to SYSOUT it cannot be printed with SequeLink commands System action The VAILOGP is not printed User response Use the JES commands to print VAILOGP VAIC100I Unknown operator command type not modify or stop Probable internal error Severity Information Explanation The operator interface component of the server system received an unknown command type from an operator s console SequeLink Troubleshooting Guide and Reference 214 Chapter 8 OS 390 Messages and Descriptions VAIC101T VAIC1021 VAIC1031 VAIC104I System action User response
180. mpt was detected to bind Output or Input Output variables which are not supported by Informix Action SequeLink returns Informix return parameters as result sets Fetch the result sets 3510 Data source not found Cause An invalid server data source was specified at connection time Action Make sure the server data source you want to connect to exists or use the default server data source 3511 Get diagnostics failed Cause SequeLink could not obtain the error message text from Informix Action Contact DataDirect Technologies technical support 3512 Insertion of Smart BLOB failed Cause SequeLink could not insert a smart BLOB data type BLOB or CLOB Action Make sure that a default sbspace has been created in Informix Refer to the Informix documentation for information about onconfig SequeLink Troubleshooting Guide and Reference 126 Chapter 6 Error Messages 3513 Set catalog name not supported Cause The application tried to switch the current database during the connection This is not supported by Informix Action Specify your database at connection time Do not change databases after connection 3514 Invalid environment variables during establishing connection to database Cause Either or both the environment variables INFORMIXDIR or INFORMIXSERVER are not specified correctly in the DataSourcelNFInformixDir and DataSourcelNFInformixServer service attributes Action Specify either or both the INFORMIXDIR or
181. n the class path 4303 JDBC DataSource not defined Cause The SequeLink for JDBC DataSource object used by the resource adapter was not initialized correctly Action Contact DataDirect Technologies technical support The subclasses of JCAManagedConnectionFactory should ensure that a SequeLink for JDBC DataSource object is passed to the JCAManagedConnectionFactory constructor It is an internal resource adapter error if it does not 4304 The physical connection is invalid Cause An operation was attempted on a ManagedConnection that has been closed Action Try the connection using an open ManagedConnection Do not use a ManagedConnection that has been closed 4305 Reauthorization of JDBC Connections is not allowed Cause An attempt was made to reuse a ManagedConnection with a user ID and password that is different from the user ID and password used to create the ManagedConnection was created Action Verify that the user ID and password supplied to the getConnection String userld String password method of a particular ConnectionFactory instance is the same for each invocation SequeLink Troubleshooting Guide and Reference 128 Chapter 6 Error Messages 4306 The supplied connection handle is invalid Cause An attempt was made to associate a ManagedConnection with a connection handle that is not an instance of JCAConnection Action The Connection object passed to ManagedConnection associateConnection must be an instance of a
182. ncrease the value of the DataSourceDB2MaxLobSize service attribute or return a smaller LOB output parameter in the stored procedure 3439 The requested DB2 subsystem is not active Cause The requested DB2 subsystem is not active Action Contact your system administrator to start the DB2 subsystem 3440 A required service data source attribute is not found contact your system administrator Cause A required service or data source attribute could not be found in the configuration file Action A message that identifies the missing attribute is generated and sent to the service debug log Contact your system administrator SequeLink Troubleshooting Guide and Reference 123 3441 No Uidmap associated with service anonymous logon denied Cause The service is not configured correctly A UIDMap is required to allow anonymous logon but no UIDMap is associated with the service Action Create a UIDMap and add the MVSServiceUIDMap service attribute to the service 3442 Uidmap does not contain wildchar entry anonymous logon denied Cause The UIDMap associated with the service does not contain a wild character entry Action Add a wild character entry to the UIDMap associated with the service 3443 Cannot logon to the database Cause The logon to DB2 failed Action See accompanying messages and the Server VAILOG for the DB2 reason code 3444 The maximum number of database Threads is reached Cause The Service is exceedin
183. ncy is changed from 0 to 1 This is a SQL Warning Cause Result set concurrency is changed from 0 to 1 This is a SQL Warning Action Refer to the SequeLink Developer s Reference for information about restrictions on scrollable cursors 7483 Finalization thread could not be started This is a SQL Warning The JDBC driver is unable to finalize Connection and Statement objects during garbage collection Cause Finalization thread could not be started The JDBC driver is unable to finalize Connection and Statement objects during garbage collection Action Make sure that your application explicitly closes the Connection and Statement objects 7491 Object is closed Cause The object is closed Action Check your JDBC application 7492 Cannot set autocommit to on for global transaction Cause You cannot set Autocommit to on for global transactions Action Check your JDBC application 7493 Cannot commit for global transaction Cause Global transaction could not be committed Action Check your JDBC application 7494 Cannot rollback for global transaction Cause Global transaction could not be rolled back Action Check your JDBC application 7495 Reclaim of open connection is not supported Cause The JDBC driver does not support the reclaim of open connections Action Check your JDBC application SequeLink Troubleshooting Guide and Reference 182 Chapter 6 Error Messages 7720 SSL IIlegal port number
184. nd your network protocol and its configuration This book contains the following information Part 1 Troubleshooting m Chapter 1 Troubleshooting Tools on page 19 provides information about troubleshooting tools for the SequeLink for ODBC driver SequeLink for ADO provider SequeLink for JDBC driver and SequeLink for NET data provider SequeLink Troubleshooting Guide and Reference 8 Preface m Chapter 2 Troubleshooting TCP IP Connection Problems on page 31 describes problems that can occur during TCP IP connections m Chapter 3 Troubleshooting Your Database Connection on page 35 provides information to help you identify the source of connection problems m Chapter 4 Using Debug Log Files on page 43 describes how to use log files to troubleshoot problems Part 2 Error Codes and Messages m Chapter 5 Overview of SequeLink Error Codes and Messages on page 63 provides general information about SequeLink s error handling strategy and describes the types of errors that can occur when using SequeLink m Chapter 6 Error Messages on page 73 lists error codes and messages that may be generated by SequeLink Part 2 OS 390 Messages and Reference m Chapter 7 Overview of OS 390 Log Messages on page 211 describes how OS 390 log messages are organized and formatted m Chapter 8 OS 390 Messages and Descriptions on page 213 lists OS 390 log messages that may be generated and provide
185. nection is unable to use DB2 sqicode 981 Sequelink when requested by a KILL command or during shutdown terminates the connection and cancels the DB2Thread only if the connections is still active in DB2 VAICDB2R Cancel THRDID invalid format specified Severity Explanation System action User response Error Internal error when trying to Cancel a DB2Thread None Contact DataDirect Technologies technical support VAICRRSM abend aaaa Severity Explanation Error Program VAICRRSM is returned with abend aaaa SequeLink Troubleshooting Guide and Reference VAID101I VAID102E VAID103W VAID 1041 System action User response DB2 Application Support Package Messages 237 Either the RRS command or the automatic ContextCleanup failed Contact DataDirect Technologies technical support Threadid UR identifier UR state Severity Explanation System action User response Information This message is always generated as the title for the RRS LIST command report output Processing continues normally None Threadid UR identifier UR state Severity Explanation System action User response Error A stored procedure abended The stored procedure is not executed and the service returns the SQL code Correct the stored procedure Threadid UR identifier UR state Severity Explanation System action User response Warning The explanation dep
186. nformation configured at the SequeLink Client is specified correctly to connect to the SequeLink Server 9502 Handshake failure A protocol error occurred during the connection setup Cause An attempt was detected to connect to a SequeLink Server running an incompatible version of SequeLink Action Verify that the versions of your SequeLink Client and SequeLink Server are compatible Contact DataDirect Technologies technical support if necessary SequeLink Troubleshooting Guide and Reference 207 9503 Handshake failure You are trying to connect to a server running an incompatible version of SequeLink Server Cause The SequeLink Client is incompatible with the version of the SequeLink Server to which it tried to connect Action Verify that the versions of your SequeLink Client and SequeLink Server are compatible Contact DataDirect Technologies technical support if necessary 9509 Server asked for unknown encryption Cause An internal error occurred Action Contact DataDirect Technologies technical support 9521 Unsupported authentication mechanism Cause The authentication mechanism specified in the server configuration is not supported by this version of the NET data provider or no authentication mechanism is specified Action Check the ServiceAuthMethods attribute in your SequeLink Server configuration 9522 Invalid OEM id Cause The OEM id specified was not valid Action Contact DataDirect Technologies t
187. ng a DB2Thread IFI command ccccccccccccc issued with corresponding returncodes is displayed None None VAICDB2R Thrdld tttttttt found in output DISPLAY THREAD command token nnnn extracted Severity Explanation System action User response Information The DB2 token nnnn which is extracted with the DISPLAY THREAD command for the Connection tttttttt active on DB2Thread that will be canceled is displayed None None SequeLink Troubleshooting Guide and Reference 236 Chapter 8 OS 390 Messages and Descriptions VAIDO74E VAIDO75E VAIDO76l VAIDO77E VAID100E VAICDB2R Thrdld tttttttt not found in output DISPLAY THREAD command Severity Explanation System action User response Error Thrdld tttttttt was not found in the output DISPLAY THREAD command None None VAICDB2R Thrdld tttttttt found in output DISPLAY THREAD command But Thrdld is not active Severity Explanation System action User response Error Thrdld tttttttt found in output DISPLAY THREAD command but is not active in DB2 None None VAICDB2R Canceling DB2Thread with Token nnnn for Threadid tttttttt Severity Explanation System action User response Information The DB2Thread with token nnnn on which Threadld tttttttt is active in DB2 is canceled when requested by a KILL command or during Shutdown with Type immed Either the Logon fails or the client con
188. ng blanks are not allowed in the port Action Specify the correct port making sure not to include any trailing blank characters 2452 Invalid host or port no blanks allowed Cause The specified host or port contained a blank character Blank characters including leading or trailing blanks are not allowed in the host name or port Action Specify the correct host name or port making sure it does not contain any blank characters 2453 Invalid port number out of range Cause The specified port number exceeds the maximum value of 32768 Action Specify the correct port using a valid port value 2454 Internal network error during parsing host and port Cause An internal error occurred Action Contact DataDirect Technologies technical support 2455 Internal network error missing separator Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 92 Chapter 6 Error Messages 2456 Invalid host or number character not allowed Cause The host name or number included a colon Action Specify the correct host name or number without a colon 2457 Invalid host character not allowed Cause The host name included a colon Action Specify the correct host name without a colon 2458 Invalid port character not allowed Cause The port included a colon Action Specify the correct port without a col
189. nk was unable to determine the name of the local host Action Contact DataDirect Technologies technical support 6865 Invalid service name lt service name gt Cause An invalid SequeLink service name was specified Action Specify a valid SequeLink service name Remember that service names are case sensitive 6866 Invalid service template ID Cause An invalid SequeLink service template ID was specified Action Specify a valid SequeLink service template ID For more information about template IDs refer to the SequeLink Administrator s Guide 6867 Only one agent service may be created Cause An attempt was made to create a duplicate SequeLink Agent service Action None 6868 Service lt service name gt is still active Cause An attempt was made to delete a SequeLink service that was still running Action Stop the SequeLink service before you delete it 6869 Failed to check if service lt service name gt is still active Cause SequeLink could not check if the SequeLink service was active The SequeLink service may have been experiencing heavy traffic or may have been in an incorrect state Action Re check the status of the SequeLink service If the problem persists contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 164 Chapter 6 Error Messages 6870 Attribute lt D or name gt is not valid lt object gt attribute Cause The specified attribute is not valid for the SequeLin
190. not create a connection list with a negative or zero number of maximum connections Cause An illegal value is specified for the MaxConnections parameter in the proxy server configuration file Action Check the MaxConnections parameter in the proxy server configuration file SequeLink Troubleshooting Guide and Reference 191 7777 SSL Internal error connection list state error Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7778 SSL Could not start new thread Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7779 SSL Cannot create a dictionary for log file Cause The directory specified by the LogDir parameter in the proxy server configuration file does not exist An error occurred in an attempt to create the missing directory Action m Check the LogDir parameter in the proxy server configuration file m Verify that the required file privileges are set m If the previous actions do not resolve the problem try to create the logging directory explicitly 7780 SSL Cannot access log file Cause The proxy server log file already exists and an error occurred when trying to read from or write to this file Action m Check the console of the proxy server mac
191. not create server listener on given port Cause The proxy server was unable to create a TCP IP socket to listen for incoming connections The proxy server may already be running or an incorrect port number was specified Action m Check the detailed exceptions m Check the Port parameter in the proxy server configuration file m Check the AdminPort parameter in the proxy server configuration file m Make sure that the proxy server is not already running at the host 7728 SSL IIlegal server port number specified Cause An invalid port number was specified for the ServerPort parameter in the proxy server configuration file Action Check the ServerPort parameter in the proxy server configuration file 7729 SSL Configuration file not found Cause The specified proxy server configuration file was not found in the current directory The proxy server configuration file is formed by adding the extensions cfg to the proxy server name The name of the proxy server can be specified using the last command line parameter of the SequeLink Manager command used to start the proxy server Action Verify that the proxy server configuration file has the extension cfg in its name and exists in the current directory 7730 SSL Cannot read configuration file Cause The specified configuration file is not readable Action Check the privileges of the specified configuration file 7731 SSL Cannot create file inputstream Cause Action Internal error An I
192. not return a result set Action Correct your JDBC application 7405 Conversion not supported 0 for SQL data type 1 The specified method is illegal for a column of the specified SQL data type Cause The specified method is invalid for a column of the specified SQL data type Action Correct your JDBC application 7406 Conversion of value 0 at column 1 failed The data type conversion for the specified column failed Cause The data type conversion for the specified column failed Action Correct your JDBC application 7407 An unsupported SQL data type has been specified 0 The specified SQL data type is invalid Cause The specified SQL data type is invalid Action Correct your JDBC application SequeLink Troubleshooting Guide and Reference 174 Chapter 6 Error Messages 7408 Invalid use of null string Cause A null string is incorrectly used as a parameter or a method of DatabaseMetaData Action Correct your JDBC application 7409 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 7410 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 7411 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 7412 Use register OutParameter int int int for SQL data
193. ns the following chapters m Chapter 5 Overview of SequeLink Error Codes and Messages on page 63 provides general information about SequeLink s error handling strategy and describes the types of errors that can occur when using SequeLink m Chapter 6 Error Messages on page 73 lists error codes that may be generated SequeLink Troubleshooting Guide and Reference 62 Part 2 Error Codes and Messages SequeLink Troubleshooting Guide and Reference 63 5 Overview of SequeLink Error Codes and Messages This chapter provides general information about SequeLink s error handling strategy and describes the types of errors that can occur when using SequeLink Each generated error message includes a description of the most probable cause of the error prefixed by the name of the component that returned the error For information about the error formats and the types of errors that can occur when using SequeLink m See ODBC Driver on page 64 m See ADO Data Provider on page 66 m See JDBC Driver on page 68 m See NET Data Provider on page 70 SequeLink Troubleshooting Guide and Reference 64 Chapter5 Overview of SequeLink Error Codes and Messages ODBC Driver The following types of errors can occur when you are using the SequeLink for ODBC Client ODBC driver errors SequeLink Client errors SequeLink Server errors Database errors ODBC Driver Errors An error generated by the ODBC driver has
194. nsliteration properties Cause An unexpected error occurred while accessing the transliteration properties file Action Contact DataDirect Technologies technical support 1004 Resource com ddtek util transliteration properties is corrupt Cause An unexpected error occurred while accessing the transliteration properties file Action Contact DataDirect Technologies technical support 1005 Transliteration table 0 not found Cause The SequeLink Server uses a Code page that is currently not supported by the SequeLink Client Action Contact DataDirect Technologies technical support 1006 Transliteration class 0 not found Cause The SequeLink Server uses a Code page that is currently not supported by the SequeLink Client Action Contact DataDirect Technologies technical support 1007 Unsupported VM encoding 0 Cause The SequeLink Server uses a Code page that is currently not supported by the SequeLink Client Action Contact DataDirect Technologies technical support 1008 Transliteration table 0 is corrupt Cause An unexpected error occurred while accessing the transliteration table Action Contact DataDirect Technologies technical support 1009 Transliteration failed Cause An unexpected error occurred while transliterating the String Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 82 Chapter 6 Error Messages 1010 Invalid transliteration class 0 Cause An
195. ntact DataDirect Technologies technical support 6518 The operation is forbidden by local security policy Cause An internal error occurred Action Contact DataDirect Technologies technical support 6519 The operation or option is unavailable Cause An internal error occurred Action Contact DataDirect Technologies technical support 6520 The requested credential element already exists Cause An internal error occurred Action Contact DataDirect Technologies technical support 6521 The provided name was not a mechanism name Cause An internal error occurred Action Contact DataDirect Technologies technical support 6522 Failed to load MGSS mechanism Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 160 Chapter 6 Error Messages 6523 Memory allocation failed Cause An internal error occurred Action Contact DataDirect Technologies technical support 6524 Context call failed Cause An internal error occurred Action Contact DataDirect Technologies technical support 6525 Prompt for authentication information aborted by user Cause An error occurred during authentication processing because the user cancelled from the dialog box prompting for authentication information user name and user password Action None 6526 MGSS module version mismatch Cause An internal error occurred Action Contact DataDirect Technologies tec
196. nternal error standard MGSS error occurred Not used by the standard SequeLink authentication modules Action Contact DataDirect Technologies technical support 7849 SSL The requested credential element already exists Cause An internal error standard MGSS error occurred Not used by the standard SequeLink authentication modules Action Contact DataDirect Technologies technical support 7850 SSL The provided name was not a mechanism name Cause An internal error standard MGSS error occurred Not used by the standard SequeLink authentication modules Action Contact DataDirect Technologies technical support 7851 SSI Failed to create authentication provider instance Cause Action A fatal error occurred when loading a specified provider class Providers must be specified in the com ddtek sequelink slje properties properties file At startup all authentication providers are loaded in the order they are specified If the provider class is not found this provider is not installed When a provider class is found but an error occurred when instantiating this provider class this message is returned Check the detailed error messages and the com ddtek sequelink slje properties properties file If necessary contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 200 Chapter 6 Error Messages 7852 SSL Server side authentication is not supported by the authentication libra
197. ntinues However results are unpredictable The OS 390 server job log should contain a message with the prefix CSV indicating the reason for the attach failure Report this error to DataDirect Technologies technical support SERVER MAIN error returned from VAIOPR macro RC return code VC verb code Severity Explanation System action User response Error Logic error processing VAIOPR request resulting in the displayed return code and verb code Request is ignored Report this error to DataDirect Technologies technical support TASKNAME TACBADDR FLAGS CPU SERVICE USERID Severity Explanation System action User response Information The server is responding to a STATUS command This is the header information about the tasks it is controlling This message is the result of a CNTL STATUS command and is always followed by a VAISO891 message Not applicable None SequeLink Troubleshooting Guide and Reference VAISO86I VAISO87E VAISO88T Server Controller Task Messages 247 Shutdown type ttttttttt initiated Severity Explanation System action User response Information The server acknowledges shutdown where the type is either Immediate or Normal System shutdown is initiated If the shutdown is Normal no new connections are allowed to start The server will wait until all existing connections ended normally before continuing Shutdown
198. ntries http www datadirect technologies com contactus distributor asp provides a list of the correct e mail contacts Local Telephone Support Local phone numbers can be found at http www datadirect technologies com support support_contact_aline asp SupportLink support is available 24 hours a day seven days a week Fax Information Fax US Mexico and Canada 1919 461 4527 Fax EMEA 32 0 15 32 09 19 When you contact us please provide the following information m The product serial number or a case number If you do not have a SupportLink contract we will ask you to speak with a sales representative m Your name and organization For a first time call you may be asked for full customer information including location and contact details m The version number of your DataDirect product m The type and version of your operating system SequeLink Troubleshooting Guide and Reference Contacting Technical Support 15 mg Any third party software or other environment information required to understand the problem m A brief description of the problem including any error messages you have received and the steps preceding the occurrence of the problem Depending on the complexity of the problem you may be asked to submit an example so that we can recreate the problem m An assessment of the severity level of the problem SequeLink Troubleshooting Guide and Reference 16 Preface SequeLink Troubleshooting Guide and
199. of the error See Chapter 6 Error Messages on page 73 for a list of all error codes and messages Database Errors An error generated by the database has the following format DataDirect ODBC SequeLink driver message For example DataDirect ODBC SequeLink driver Oracle ORA 00942 table or view does not exist SequeLink Troubleshooting Guide and Reference 66 Chapter5 Overview of SequeLink Error Codes and Messages ADO Data Use the native error code to look up details about the possible cause of the error For these details refer to your database documentation Provider The following types of errors can occur when you are using the SequeLink for ADO Client m ADO data provider errors m SequeLink Client errors m SequeLink Server errors m Database errors ADO Data Provider Errors An error generated by the ADO data provider has the following format DataDirect SequeLink ADO provider message For example DataDirect SequeLink ADO provider Invalid precision specified The native error code is always zero 0 If you receive this type of error check the last ADO call your application made Contact your ADO or OLE DB application vendor or refer to the ADO and OLE DB documentation available from Microsoft SequeLink Troubleshooting Guide and Reference ADO Data Provider 67 SequeLink Client Errors An error generated by the ADO Client has the following format DataDirect SequeLink
200. ogies technical support SequeLink Troubleshooting Guide and Reference 140 Chapter 6 Error Messages 5340 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5350 An authentication mechanism could not be successfully negotiated Cause The SequeLink Server did not specify an authentication mechanism supported by the SequeLink Client Action Make sure that the SequeLink Server specifies an authentication mechanism supported by the SequeLink Client Refer to the SequeLink Administrator s Guide for information on configuring authentication 5501 Memory allocation failure Cause Insufficient memory could be allocated Action Free memory resources If the problem persists contact DataDirect Technologies technical support 5502 Failed to initialize SequeLink Manager Cause The SequeLink Manager could not be initialized Action Contact DataDirect Technologies technical support 5503 Internal SequeLink Manager error detected l xxxxd Cause An internal error occurred in the SequeLink Manager Action Contact DataDirect Technologies technical support 5504 Unknown command lt name gt entered Cause An incorrect SequeLink Manager command was entered Action Check the SequeLink Manager command help to verify the command 5505 Specified argument not valid for the given command Cause An incorrect parameter for a SequeLink Manager command was entered Action
201. on 2459 Internal network error during parsing host and port Cause An internal error occurred Action Contact DataDirect Technologies technical support 2460 Internal network error during parsing host and port Cause An internal error occurred Action Contact DataDirect Technologies technical support 2461 Invalid port numerical value lt 0 is not allowed Cause An invalid port number was specified Action Specify the correct port using a valid value 2462 Invalid port numerical equal to 0 is not allowed Cause An invalid port number was specified Action Specify the correct port using a valid value 2463 Host name or service name too long Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 93 2464 Internal network error during parsing host and port Cause An internal error occurred Action Contact DataDirect Technologies technical support 2465 Internal network error during parsing host and port Cause An internal error occurred Action Contact DataDirect Technologies technical support 2466 Network resource problem memory allocation failure during parsing host and port Cause A system resource was not allocated while parsing the value provided for the host or port Action Free memory resources If the problem persists contact DataDirect Technologies technical support 2467 Internal network error during parsing host and p
202. on 3407 Literals are not supported as stored procedure parameters Cause Literals are used for stored procedure parameters Action Change the stored procedure in your application so that it does not use literals SequeLink Troubleshooting Guide and Reference 118 Chapter 6 Error Messages 3408 Stored procedures can no longer be executed because a SET CURRENT SQLID occurred Cause After issuing a a SET CURRENT SQLID it is no longer possible to execute stored procedures Action Change your application 3409 The kind in out or in out of a stored procedure parameter as specified by the SequeLink Client does not match with the stored procedure definition Cause An invalid type of a stored procedure parameter was specified Action Change the type of the stored procedure parameter specified in your application 3410 The stored procedure cannot handle NULL values Cause A NULL value was specified for a stored procedure parameter Action Change the value for the stored procedure parameter specified in your application 3411 Thread to DB2 could not be opened Either a resource is unavailable or the requested resource plan is not known to DB2 Cause An internal error occurred Action Contact DataDirect Technologies technical support 3412 Info about DB2 connection could not be retrieved Cause The SequeLink Server attempted to retrieve DB2 specific information Action Check your service debug log file for details about th
203. ontact DataDirect Technologies technical support Server registered in Sysplex ClusterName cccccccccccccccccc Severity Explanation System action User response Information If MVSGlobalClusterName is specified this message is displayed when Sequelink Server succesfully registers into the Sysplex with ClusterName cccccccccccccccccc None None Register Server in Sysplex IWMSRSRG failed reasoncode xxxx Severity Explanation System action User response Error SequeLink failed to register into the Sysplex The reasoncode for the IWMSRSRG macro is displayed Sequelink Server continues initialization without registration into Sysplex Check reasoncode for IWMSRSRG If necessary contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference VAIS362E VAIS363E Server Controller Task Messages 275 Deregister Server from Sysplex IWMSRDRS failed reasoncode xxxx Severity Error Explanation SequeLink failed to deregister from the Sysplex The reasoncode for the IWMSRDRS macro is displayed System action SequeLink Server continues shutdown User response Check the reasoncode for IWMSRDRS If necessary contact DataDirect Technologies technical support Server deregistered from Sysplex ClusterName cccccccccccccccccc Severity Information Explanation If MVSGlobalClusterName is specified Sequelink Server succesfully deregistered from the Sysple
204. ontained an invalid verb SequeLink Troubleshooting Guide and Reference VAIC1051 VAIC106I VAIC1071 System action User response Operator Interface Messages 215 The entered command is ignored Check the syntax of the command and reenter the correct command Required parameter field missing from command Severity Explanation System action User response Information The operator interface component of the server system received an incorrect command from the operator s console The command that was entered had a required field missing The entered command is ignored Check the syntax of the command and reenter the correct command Unknown parameter field in command Severity Explanation System action User response Information The operator interface component of the server system received an incorrect command from the operator s console The command that was entered included an unknown field The entered command is ignored Check the syntax of the command and reenter the correct command Extraneous parameter name in command Severity Explanation System action User response Information The operator interface component of the server system received an incorrect command from the operator s console The command that was entered included an unknown parameter parameter name The entered command is ignored Check the syntax of the command and reenter the cor
205. or Explanation Setup for automatic cleanup of RRS context s failed for reason ttttttttttttttt where ttttttttttttttt is either invalid EntryPoint VAICRRSM or SET_TIM routine failed System action Initialization continues no ContextCleanup will be done User response Contact DataDirect Technologies technical support Syntax error invalid value in DB2ASP command Severity Error Explanation DB2ASP operator request contained a syntax error or the parameter value was rejected System action Self explanatory User response Correct the command and re enter SequeLink Troubleshooting Guide and Reference VAIDO14E VAIDO15E VAIDO20T VAIDO21E DB2 Application Support Package Messages 225 Ttttttttt Error detected in VAICDB2I lt error description gt Severity Explanation System action User response Error This message is an internal error lt error description gt shows one of the errors No valid TACBUID2 No DB2Plan passed No DBWA for Service Wrong DB2attachment DB2 not active None If DB2 not active start DB2 For all other cases this is an internal error Contact DataDirect Technologies technical support Loadmodule VAICRRSM could not be loaded Severity Explanation System action User response Error The Loadmodule fetch failed Initialization continues no ContextCleanup will be done Check that loadmodule VAICRRSM is installed in steplib Tttttttt
206. orrect System action The command is ignored User response Check the syntax of the CNTL ALTER command Verify that a correct keyword was included in the command Refer to the SequeLink Administrator s Guide for details on the CNTL ALTER command CellPool with CellSize could not be expanded for Secondary Pages Severity Warning Explanation CellPool could not be expanded probably due to a shortage of Virtual storage System action None User response Start up the Server with greater RegionSize or contact DataDirect Technologies technical support Function failed Rc x __ in Thread tttttttt abend U079 will result Severity Error Explanation An internal error occurred due to a failure of the CellPool MemoryMgr function SequeLink Troubleshooting Guide and Reference 250 Chapter 8 OS 390 Messages and Descriptions VAIS1031 VAIS110E VAIS111T VAIS151F System action Abend Thread tttttttt with U079 User response Contact DataDirect Technologies technical support Tttttttt classified to WLMServiceClass cccccccc Severity Information Explanation Threadid has been classified to WLMServiceClass cccccccc System action WLM will use workload appropriate to this ServiceClass when scheduling enclaves for this Thread User response None Tttttttt IWMExxxx WLM Returncode returncode Reasoncode reasoncode Severity Error Explanation The WLM macro IWMExxxx returned a non zero returnco
207. ort 5203 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5204 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5205 An internal error occurred Cause An unexpected error occurred SequeLink Troubleshooting Guide and Reference 137 138 Chapter 6 Error Messages Action Contact DataDirect Technologies technical support 5206 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5223 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5241 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5270 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5290 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5300 Failed to load the transliteration file xxxx Cause The transliteration file xxxx failed to load Action Check your SequeLink Client installation 5301 The transliteration file xxxx is corrupt Cause The transliteration file xxxx is damaged Action Check your SequeLink
208. ort Cause An internal error occurred Action Contact DataDirect Technologies technical support 2468 Internal network error no host and port specified Cause An internal error occurred Action Contact DataDirect Technologies technical support 2469 Network problem host resolution failure Cause The specified server host name could not be resolved to a valid IP address Action Map the server host name to a valid IP address 2470 Network problem port resolution failure Cause The service name could not be resolved to a port number Action Check the TCP IP services configuration file SequeLink Troubleshooting Guide and Reference 94 Chapter 6 Error Messages 3001 Internal error memory allocation failed Cause Memory allocation error Action Free memory resources If the problem persists contact DataDirect Technologies technical support 3002 Internal error corrupt context Cause An internal error occurred Action Contact DataDirect Technologies technical support 3003 Internal error invalid request received from the client application Cause An internal error occurred Action Contact DataDirect Technologies technical support 3004 Internal error an unexpected exception was detected Cause An internal error occurred Action Contact DataDirect Technologies technical support 3005 Internal error a fatal server error was detected Cause An internal error occurred Action Contact DataDirect Technolog
209. ould not be successfully negotiated Cause The SequeLink Server did not specify an authentication mechanism supported by the SequeLink Client Action Make sure that the SequeLink Server specifies an authentication mechanism supported by the SequeLink Client Refer to the SequeLink Administrator s Guide for information about setting authentication 7435 Unable to resolve transliteration 0 The JDBC driver does not support the transliteration used by your server Cause The JDBC driver does not support the transliteration used by your server Action Contact DataDirect Technologies technical support 7436 Error occurred while processing transliteration table 0 Cause An error occurred while processing a transliteration table Action Contact DataDirect Technologies technical support 7437 Transliteration table corrupt 0 Cause A transliteration table was corrupted Action Contact DataDirect Technologies technical support 7438 NumberFormatException during setObject with object type 0 used for SQL data type 1 at parameter index 2 Cause A NumberFormatException occurred during setObject with object type 0 used for SQL data type 1 at parameter index 2 Action The subsequent exception will give you more information Check your JDBC application 7439 XA Open failed with return code 0 Cause XA Open failed with the specified return code Action Refer to the X Open XA Specification for more information about the return code
210. owing reasons m Itis currently being terminated abnormally by an II or console operator command m It was never successfully started generally an application link edit error m It has already ended Use the CNTL STATUS command to check the current state of the thread Verify that the application was built and linked correctly Check the VAILOG for previous error messages relating to this thread identified by its thread ID If necessary contact DataDirect Technologies technical support Error with ALTER command service application was not found Severity Explanation System action User response Error The operator at an OS 390 operator s console or at an Il terminal entered a CNTL ALTER command with an unknown service name The command is ignored Reenter the command CNTL ALTER SERVICE and specify a valid service name The CNTL STATUS SHOW SERVICE command might be used to check the name of the target service SequeLink Troubleshooting Guide and Reference VAIS1941 VAIS196I VAIS197E VAIS200E Server Controller Task Messages 263 Alter services request was successful Severity Explanation System action User response Information The operator at an OS 390 operator s console or at an Il terminal entered a CNTL ALTER command to update an existing application service definition The command was successful The application service definition is updated according to the
211. pecified Cause The proxy server configuration file specified an invalid value for the InitialPacketSize parameter Action Check the InitialPacketSize parameter in the proxy server configuration file 7737 SSL Illegal value for LogLevel specified Cause The proxy server configuration file specified an invalid value for the LogLevel parameter Action Check the LogLevel parameter in the proxy server configuration file SequeLink Troubleshooting Guide and Reference 185 7738 SSL Illegal value for TransferMode specified Cause The proxy server configuration file specified an invalid value for the TransferMode parameter Action Check the TransferMode parameter in the proxy server configuration file 7739 SSL Illegal administration port number specified Cause The proxy server configuration file specified an illegal port number for the AdminPort parameter Action Check the AdminPort parameter in the proxy server configuration file 7740 SSL Non numerical value for administration port specified Cause The proxy server configuration file specified a non numeric value for the AdminPort parameter Action Check the AdminPort parameter in the proxy server configuration file 7741 SSL Non numerical value for backlog specified Cause The proxy server configuration file specified a non numeric value for the BackLog parameter Action Check the BackLog parameter in the proxy server configuration file 7742 SSL Illegal backlog val
212. planation System action User response Error ServiceldleTime was incorrectly specified in the SequeLink configuration file for service xxxxxx The affected service will not be available until the error is corrected and the server is restarted The incorrect service definition is ignored and bypassed Correctly define ServiceldleTime for service xxxxxxx in the SequeLink configuration file DataModel ServiceldleAction error default set to MESSAGE for Service XXXXXXXX Severity Explanation System action User response Warning ServiceldleAction was incorrectly specified in the SequeLink configuration file for service xxxxxx Default setting of MESSAGE will be used The default value for the ServiceldleAction parameter MESSAGE will be used Correctly define ServiceldleAction for service xxxxxxx in the SequeLink configuration file DataModel ServiceMaxSession error Service xxxxxxxx has been ignored Severity Explanation Error ServiceMaxSession was incorrectly specified in the SequeLink configuration file for service xxxxxx The affected service will not be available until the error is corrected and the server is restarted SequeLink Troubleshooting Guide and Reference 254 Chapter 8 OS 390 Messages and Descriptions VAIS1651 VAIS171E VAIS172E System action User response The incorrect service definition is ignored and bypassed Correctly define ServiceMaxSession Time for servi
213. ponse Contact DataDirect Technologies technical support Define Exit_routines to Context_mgr failed reason xxxx Severity Error Explanation SequeLink registration to Context Mgr failed reasoncode xxxx during RSS registration System action The server abends with U130 User response Contact DataDirect Technologies technical support Define Exit_routines to RRS_mgr failed reason xxxx Severity Error Explanation SequeLink registration to RRS_services failed reasoncode xxxx during RRS registration System action The server abends with U130 User response Contact DataDirect Technologies technical support Begin Restart Mgr failed reason xxxx Severity Error Explanation SequeLink Begin Restart Mgr failed reasoncode xxxx during RRS registration SequeLink Troubleshooting Guide and Reference VAIS311E VAIS312E VAIS313E VAIS314E VAIS315E Server Controller Task Messages 271 System action The server abends with U130 User response Contact DataDirect Technologies technical support Retrieve Incomplete Interest failed reason xxxx Severity Error Explanation SequeLink Retrieve Incomplete Interest failed reasoncode xxxx during RRS registration System action The server abends with U130 User response Contact DataDirect Technologies technical support End Restart Mgr failed reason xxxx Severity Error Explanation SequeLink End Restart Mgr failed reasoncode xxxx during RRS regi
214. ported Cause You cannot use output parameters with batch updates Action Check your JDBC application 7418 An object of the unsupported class 0 has been specified The JDBC application specified an object of the unsupported class as parameter for PreparedStatement setObject Cause The JDBC application specified an object of the unsupported class as parameter for PreparedStatement setObject Action Check your JDBC application 7419 The number of bytes in a unicode stream cannot be an odd value Cause The number of bytes in a Unicode stream cannot be an odd value Action Check your JDBC application 7420 Some parameters are not defined The application did not call a setXXX method for each parameter in the SQL statement Cause Some parameters are not defined The application did not call a setXXX method for each parameter in the SQL statement Action Check your JDBC application for undefined parameters SequeLink Troubleshooting Guide and Reference 176 Chapter 6 Error Messages 7421 Illegal method call There is no current row This method invocation is only valid when the result set has a current row Cause This method invocation is only valid when the result set has a current row Action Check your JDBC application 7422 Positioned updates are not supported Cause Positional updates are not supported by this version of the JDBC driver Action Check your JDBC application 7423 The column 0
215. pplication service thread identified by its thread ID started by the stated user from the stated terminal has exceeded the value that was coded for the application service being used by this thread The value of the IDLEACTION idle action parameter in the SYSINI was set to ABORT The server system has therefore abnormally terminated this thread The named thread is terminated abnormally and removed from the server system Investigate the cause of the application s inactivity If need be increase the IDLETIME value for the application service using the TIDLETIME SYSINI parameter or the CNTL ALTER command Contact DataDirect Technologies technical support for additional information regarding the CNTL ALTER command and the IDLETIME SYSINI parameter SequeLink Troubleshooting Guide and Reference 262 Chapter 8 OS 390 Messages and Descriptions VAIS192E VAIS193E application name THREAD for USER user ID at terminal ID not able to timeout abort Severity Explanation System action User response Error An application service thread identified by its thread ID started by the stated user from the stated terminal has exceeded the value that was coded for the application service being used by this thread The value of the IDLEACTION idle action parameter in the SIL was set to ABORT but the server was not able to abnormally terminate the thread The thread cannot be terminated abnormally because of one of the foll
216. processed by the server Action Preceding or subsequent messages contain more detailed information 3151 Failed to start the specified SequeLink service Cause The SequeLink service did not start Action Examine the service debug log file or service event trace file for more information 3152 Failed to stop the specified SequeLink service Cause An internal error occurred Action Contact DataDirect Technologies technical support 3153 Failed to obtain the status of the specified OS Service Cause An internal error occurred Action Contact DataDirect Technologies technical support 3154 Failed to start the specified service because it is already running Cause An attempt to start a SequeLink service that is already running was detected Action If the SequeLink Manager displays the SequeLink service as inactive the SequeLink service may be in the process of stopping Wait for the SequeLink service to stop completely and then retry 3155 Failed to process the administration request because the required service executable is not found Cause An internal error occurred Action Contact DataDirect Technologies technical support 3156 Failed to open the Service The SequeLink Administrator has not enough privileges to start stop a service Cause The operating system requires processes that must have administrator privileges for opening the service controller Action Ask your security administrator to grant sufficient privileges SequeLink
217. properties file are defined in the classpath If necessary contact DataDirect Technologies technical support 7833 SSL An unsupported mechanism was requested Cause Internal error standard MDSS error No installed provider could support the requested authentication mechanism Action Check the com ddtek sequelink slje properties properties file Make sure that the provider classes specified in this properties file are defined in the classpath If necessary contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 197 7834 SSL An invalid name was supplied Cause An internal error standard MGSS error occurred Not used by the standard SequeLink authentication modules Action Contact DataDirect Technologies technical support 7835 SSLJA supplied name was of an unsupported type Cause Internal error standard MGSS error occurred Not used by the standard SequeLink authentication modules Action Contact DataDirect Technologies technical support 7836 SSL Incorrect channel bindings were supplied Cause An internal error standard MGSS error occurred Not used by the standard SequeLink authentication modules Action Contact DataDirect Technologies technical support 7837 SSL An invalid status code was supplied Cause An internal error standard MGSS error occurred Not used by the standard SequeLink authentication modules Action Contact DataDirect Technologies technical s
218. r a VAIS175E message that details the reason for the failure The application thread is not started Check the preceding VAIS174E or VAIS175E message for the exact reason for failure Respond accordingly SequeLink Troubleshooting Guide and Reference VAIS173E VAIS174E VAIS175E Server Controller Task Messages 255 STRTTHRD request for Service service_id from user_id at terminal_id failed SIL definition error Severity Explanation System action User response Error Internal error The application thread is not started Contact DataDirect Technologies technical support Verification of STRTTHRD request for Service service_id from user_id at terminal_id failed service definition was not found Severity Explanation System action User response Error Internal error The application thread is not started Contact DataDirect Technologies technical support Verification of STRTTHRD request for Service service_id from user_id at terminal_id failed xxxxxxxx Severity Explanation System action Error An attempt to start an application thread failed The affected application is identified by its name the user by their user ID and the terminal by its terminal ID The reason for the failure is also given This message is always followed by a VAIS172E message The application thread is not started SequeLink Troubleshooting Guide and Reference 256 Chapter 8 OS 390 Messages and Descr
219. r response None VAIDO56T Ttttttttt Dispatched on WorkerThread TWORKnnn Severity Trace Explanation Connection Ttttttttt was dispatched on worker thread nnn of the threadpool System action None User response None VAIDO57T Ttttttttt Leaving WorkerThread TWORKnnn Severity Trace Explanation Connection Ttttttttt is leaving worker thread nnn of the threadpool System action None User response None VAIDO60I Threadid RRSAF State Age Severity Information Explanation This is the Header message resulting from the RRS LIST operator command System action None User response None SequeLink Troubleshooting Guide and Reference VAIDO61I VAID0621 VAID0631 VAIDO64I DB2 Application Support Package Messages 233 Threadid RRSAF State Age Severity Explanation System action User response Information This is the Detail message resulting from the RRS LIST operator command where Threadid Identifies the thread RRSAF State The RRSAF State of the DB2 thread is one of the following m REUSABLE DB2 thread can be reused or released m FLAGFORREUSE DB2 thread is flagged for reuse m INUSE DB2 thread is in use Age Indicates how many seconds this DB2 thread is in REUSABLE state None None Total nnn DB2Thread s peak mmm DB2Threads used Severity Explanation System action User response Information This is the response to the RRS LIST command None
220. race profile is created Cause Event tracing was not enabled for the specified SequeLink service Action Enable an event tracing profile for the SequeLink service and make sure that the SequeLink service is running For more information about enabling profiles for a SequeLink service refer to the SequeLink Administrator s Guide 6888 Failed to open event trace file lt file name gt Cause The specified event trace file could not be opened Action Make sure that you have sufficient privileges to open and read the file and make sure that the file is not being used by another SequeLink service SequeLink Troubleshooting Guide and Reference 167 6890 Invalid array index lt number gt for attribute lt D or name gt Cause An invalid attribute array index was specified Action Specify a valid array index 6892 Invalid session ID lt number gt Cause An invalid session ID was specified Action Specify a correct session ID 6893 No configuration opened Cause A SequeLink Manager request was made that required a connection to a SequeLink Agent or a SequeLink configuration file Action Connect to a SequeLink Agent or open a SequeLink configuration file before making SequeLink Manager requests 6894 Invalid numeric value lt value gt Cause A value was specified that could not be converted to a numeric value Action Specify a valid numeric value 6895 Failed to prompt for user ID and password Cause The callback fun
221. re developed at private expense that no part is in the public domain and that the Software and Documentation are Commercial Computer Software provided with RESTRICTED RIGHTS under Federal Acquisition Regulations and agency supplements to them Use duplication or disclosure by the Government of the United States is subject to the restrictions as set forth in FAR52 227 14 and DFAR252 227 7013 et seq or the successor as appropriate Manufacturer is DataDirect Technologies 3202 Tower Oaks Blvd Suite 300 Rockville Maryland 20852 Rights are reserved under copyright laws of the United States with respect to unpublished portions of the Software DataDirect Technologies 3202 Tower Oaks Blvd Suite 300 Rockville Maryland 20852 Table of Contents Preface is diecast Lo OA at hat 7 What Is DataDirect SequeLink 00 0 0 ce eee 7 USING TisiBOOK 2s nal te es et ee ue Oe ted 8 7 SequeLink Documentation 0000 cece eee eee 9 Conventions Used in This Book 200000 eee ee 11 Typographical Conventions 200e eee eee 11 Environment Specific Information 12 Contacting Technical Support 000 eee 13 Part 1 Troubleshooting 1 Troubleshooting Tools 00c eee 19 Troubleshooting the ODBC Driver 00005 19 Troubleshooting the ADO Data Provider 20 Troubleshooting the JDBC Driver 00000 21 Configuring DataDirect Test
222. rect command SequeLink Troubleshooting Guide and Reference 216 Chapter 8 OS 390 Messages and Descriptions VAIC108I VAIC109T VAIC1101 VAIC111S Command parameter field exceeds maximum length Severity Explanation System action User response Information The operator interface component of the server system received an incorrect command from the operator s console The command that was entered included a parameter field with a length which exceeded the maximum allowed The entered command is ignored Check the syntax of the command and reenter the correct command Command accepted for routing CONSOLE ID ID Severity Explanation System action User response Trace The operator interface component of the server system received a command from the operator s console The command passed all validity checking by the operator interface component The command originated from the console identified by the stated console ID Not applicable None Unrecognized parameter field s in command Severity Explanation System action User response Information The operator interface component of the server system received a command from the operator s console The command that was entered included an unknown parameter The entered command is ignored Check the syntax of the command and reenter the correct command Not able to assign command buffer internal error S
223. red Action Increase the available memory for your application 5160 The specified LDAP entry could not be found Part of the Distinguished Name identifying the entry as xxxx was returned Cause The specified LDAP entry identified by the Distinguished Name could not be found Action Make sure that you specified a correct LDAP entry Distinguished Name 5161 Failed to load the LDAP library xxxx Cause SequeLink Client could not load the specified LDAP shared library Action Check your SequeLink Client installation 5162 An internal error occurred Cause An unexpected error occurred SequeLink Troubleshooting Guide and Reference Action Contact DataDirect Technologies technical support 5163 LDAP is not supported on this platform Cause The attempted operation is supported only on platforms that support LDAP Action Try the operation on a SequeLink Client running on a platform that supports LDAP 5164 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5200 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5201 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 5202 An internal error occurred Cause An unexpected error occurred Action Contact DataDirect Technologies technical supp
224. response Contact DataDirect Technologies technical support VAISO11F Active Agent failed could not locate VAISMNDM on TACB chain Severity Fatal Explanation Internal error System action The server abends with code 102 User response Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference VAISO12F VAISO13E VAISO14I VAISO15I VAISO16E Server Controller Task Messages 243 Specification error in SILLOADTABL entry Severity Explanation System action User response Fatal Internal error The server abends with code 109 Contact DataDirect Technologies technical support DB2ifid xxxx matches a reserved OPRID Severity Explanation System action User response Error Matches some predefined Operator Identifiers DB2 root task not started Change DB2ifid for this service SMFrecording active SMFrecordtype nnn Severity Explanation System action User response Information SMFrecording is activated SMFrecordtype nnn will be written to SMF None SMFrecording active tttttttttttttttttttttt Severity Explanation System action User response Information SMFrecording is not activated Either you requested tttttttttttt No SMFrecordType specified or you specified an invalid number tttttttttt SMFrecordType invalid range No SMF records will be written None To activate SMFrecording correct the SMFrecordTyp
225. river this makes SequeLink Server for ODBC Socket highly dependant on the quality and behavior of the ODBC driver through which it connects Because most drivers have their own specific behaviors and the ODBC specification leaves room for individual interpretation using a specific driver with SequeLink can show unexpected behavior This section summarizes the results that DataDirect Technologies found when testing connections with SequeLink Server for ODBC Socket to ODBC drivers This section also describes how to determine which component is causing the problems that can occur when you are using SequeLink Server for ODBC Socket Using the ODBC Socket Service with Connect for ODBC Drivers If you are using the SequeLink Server for ODBC Socket service with a DataDirect Connect for ODBC driver your application can experience problems when it re binds parameters with a different scale precision or sqltype The following is an example of an error message that is generated when this situation occurs DataDirect ODBC Oracle driver Data type for parameter 2 has changed since first SQLExecute call SequeLink Troubleshooting Guide and Reference 38 Chapter 3 Troubleshooting Your Database Connection X UNIX XP 200x NIT To avoid this problem you can activate a workaround in the Connect for ODBC driver For more information about workarounds for the Connect for ODBC driver refer to the Connect for ODBC Reference and README file
226. ror occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7759 SSL Network read error in server read message length operation Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7760 SSL End of input in server read message operation Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7761 SSL Network write error in server write operation Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7762 SSL Server message decoding failed Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7763 SSL Invalid server connection Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 189 7764 SSL Connection to server failed Cause A non fatal internal error occurr
227. ry Cause Internal error An attempt was made to use the Java authentication library in server mode Action Contact DataDirect Technologies technical support 7853 sSL Authentication failed lt reason gt Cause An attempt to authenticate the client to a server has failed Action Check the detailed exceptions 7921 SSL Internal error Cause Internal error in the SSL modules Action Contact DataDirect Technologies technical support 7922 SSL The symbolic host name could not be resolved to an IP address Cause The supplied server host name is unknown Action m Check the server name m Check the detailed error message 7925 SSL Error creating SSL socket Cause Internal error while setting up an SSL TLS socket at the client or proxy server Action Check the detailed error messages If necessary contact DataDirect Technologies technical support 7926 SSL Error closing SSL socket Cause Internal error while closing up an SSL TLS socket at the client or proxy server Action Check the detailed error messages If necessary contact DataDirect Technologies technical support 7927 SSL Error receiving accept Cause An internal error occurred while closing an SSL TLS socket at the SequeLink Client or proxy server Action Check the detailed error messages to troubleshoot the problem If the error still occurs contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 201 7929 SSL T
228. rying to stop a running proxy server Action Check the console of the proxy server machine for more detailed error messages If necessary contact DataDirect Technologies technical support 7796 SSL Network read error in read message length Cause An internal error occurred when trying to stop a running proxy server Action Check the console of the proxy server machine for more detailed error messages If necessary contact DataDirect Technologies technical support 7797 SSL Network read error in read message length Cause An internal error occurred when trying to stop a running proxy server Action Check the console of the proxy server machine for more detailed error messages If necessary contact DataDirect Technologies technical support 7798 SSL Internal error IOException in read token operation Cause An internal error occurred when trying to stop a running proxy server Action Check the console of the proxy server machine for more detailed error messages If necessary contact DataDirect Technologies technical support 7799 SSL Not an administration message Cause The running proxy server received an administration request but the message was not recognized You may be trying to connect to the administration port Action m Check the connection information configured at the SequeLink Client m Check the AdminPort parameter in the proxy server configuration file SequeLink Troubleshooting Guide and Reference 195
229. s a description of each message m Chapter 9 SAS C Runtime Library Messages on page 281 describes how SequeLink Server and SequeLink Manager report messages generated by the SAS C run time library NOTE This book refers the reader to Web URLs for more information about specific topics including Web URLs not maintained by DataDirect Technologies Because it is the nature of Web content to change frequently DataDirect Technologies can guarantee only that the URLs referenced in this book were correct at the time of publishing SequeLink Troubleshooting Guide and Reference SequeLink Documentation 9 SequeLink Documentation The following table provides a guide for finding information in your SequeLink documentation For information about Go to SequeLink concepts and Getting Started with SequeLink planning your SequeLink environment Installing the SequeLink SequeLink Installation Guide middleware components Administering your SequeLink Administrator s Guide SequeLink environment Developing ODBC ADO SequeLink Developer s Reference JDBC and NET applications for the SequeLink environment Troubleshooting and SequeLink Troubleshooting Guide referencing error and Reference messages SequeLink documentation is provided on your DataDirect CD in PDF format which allows you to view it online or print it You can view the SequeLink online documentation using Adobe Acrobat Reader The DataDirect CD includes Acrob
230. s transaction branch is called InFlight After xa_prepare is successfully returned the transaction branch represented by an RRS context is disassociated from the thread SequeLink Troubleshooting Guide and Reference 42 Chapter 3 Troubleshooting Your Database Connection of control This disassociated RRS context can hold resources in the resource manager on behalf of the transaction branch The unit of recovery state for this transaction branch is called InDoubt The application calls mH xa_commit to direct the resource manager to commit the transaction branch The resource manager applies any changes commits it has made to shared resources and releases any resources held on behalf of the branch m xa_rollback to direct the resource manager to roll back a branch The resource manager cancels any changes rolls back that it applied to shared resources and releases any resources it held Disassociated RRS contexts can be rolled back or committed using the XA RELEASE operator command For information on using SequeLink Operator Commands refer to the SequeLink Administrator s Guide Disassociated RRS contexts can also be rolled back or committed by using RRS panels SequeLink Troubleshooting Guide and Reference 43 4 Using Debug Log Files This chapter describes the SequeLink debug log files how to obtain the files and how to set the debug log file options SequeLink Debug Log Files DataDirect Tec
231. specified Cause An invalid port number was specified for the Port parameter in the proxy server configuration file Action Check the Port parameter in the proxy server configuration file 7721 SSL IIlegal value for maximum number of connections Cause An invalid value for the MaxConnections parameter in the proxy server configuration file was specified Action Check the MaxConnections parameter in the proxy server configuration file 7722 SSL Illegal value for Packet size Cause An invalid value for the InitialPacketSize parameter in the proxy server configuration file was specified Action Check the InitialPacketSize parameter in the proxy server configuration file 7723 SSL Illegal transfer mode specified Cause An internal error occurred Action Contact DataDirect Technologies technical support 7724 SSL Illegal log level specified Cause An internal error occurred Action Contact DataDirect Technologies technical support 7725 SSL lllegal sta16timeout value specified Cause An illegal value for the CloseWaitTime parameter in the proxy server configuration file was specified Action Check the CloseWaitTime parameter in the proxy server configuration file 7726 SSL Internal error proxy server state error Cause An unexpected error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 183 7727 SSL Can
232. stration System action The server abends with U130 User response Contact DataDirect Technologies technical support Respond to Retrieved Interest failed reason xxxx URid urid Severity Error Explanation SequeLink Respond to Retrieved Interest failed reasoncode xxxx during RRS registration System action The server abends with U130 User response Contact DataDirect Technologies technical support Mgr is already registered by another server use a different SubSystemID Severity Error Explanation The ResourceMgrName SQLNK DataDirect xxxx is already in use Change the GlobalSubSysid for this server System action The server abends with U130 User response Contact DataDirect Technologies technical support Unregistration for SQLNK DataDirect xxxx failed reason yyyy Severity Error Explanation The ResourceMgrName SQLNK DataDirect xxxx failed to unregister SequeLink Troubleshooting Guide and Reference 272 Chapter 8 OS 390 Messages and Descriptions VAIS3301 VAIS331E VAIS332E VAIS333E VAIS348I System action User response Server continues shutdown Contact DataDirect Technologies technical support Notification Exit XXXXXXXXXXXXX Severity Explanation System action User response Information Notification Exit called xxxxxxxxxxxxx explains why None None Notification Exit No Global data Severity Explanation System action User response Error In
233. t Action m Check the CertificateChecker connection parameter m Check if the specified certificate checker is in the client s classpath SequeLink Troubleshooting Guide and Reference 202 Chapter 6 Error Messages 7937 SSL Unexpected IOException occurred while reading the pass phrase Cause An internal error occurred while reading the pass phrase from the console when starting the proxy server Action mm Supply the pass phrase using the pass phrase dialog m Contact DataDirect Technologies technical support 7938 7939 SSL Unexpected Exception occurred while decrypting the private key probable cause invalid pass phrase Cause An error occurred while reading an unencrypted pass phrase When the pass phrase parameter in the proxy server configuration file is empty the private key is interpreted as unencrypted Action wm Check the RSAPrivateKey parameter in the proxy server configuration file m Check the DSSPrivateKey parameter in the proxy server configuration file m Check the PassPhrase parameter in the proxy server configuration file SSL Unexpected IOException occurred while reading the private key probable cause invalid pass phrase Cause An error occurred when reading and decrypting the encrypted private key A possible reason is that the supplied pass phrase with the proxy server startup is different from the pass phrase used to encrypt the private key Action wm Check the RASPrivateKey parameter
234. t CP is blank meaning the SSI will not be activated if the CP is not explicitly specified in the DataModel If the SSI is to be activated specify a non blank DataModel CP value and restart SequeLink or OS 390 SSID missing blank or has an invalid Length Severity Explanation System action User response Information The SequeLink or OS 390 subsystem ID SSID was either omitted from SYSINI or specified as blank The SequeLink or OS 390 SSI is not activated If the SSI is to be activated correct the SYSINI SSID value and restart SequeLink or OS 390 SSI SSCT construction failure Severity Explanation Error During initialization of the SequeLink or OS 390 SSI an error occurred attempting to construct the SSCT structure The most probable reason is CSA space could not be obtained SequeLink Troubleshooting Guide and Reference VAIC121E VAIC1221 VAIC123E VAIC124E Operator Interface Messages 219 System action The SequeLink or OS 390 SSI is not activated User response Report this error to DataDirect Technologies technical support SSI activation failure Severity Error Explanation Activation of the SequeLink or OS 390 SSI was unsuccessful System action The SequeLink or OS 390 SSI is not activated User response This message is usually preceded by either VAIC124E or VAIC126E check that message for the appropriate action Otherwise contact DataDirect Technologies technical support
235. t ID specified in the command is currently enabled within your Server system If the specified component is enabled and you still receive this message contact DataDirect Technologies technical support Operator interface initialization completed OK Severity Explanation System action User response Information The operator interface component of the server system successfully completed initialization The operator interface component will accept control commands None SequeLink Troubleshooting Guide and Reference 218 Chapter 8 OS 390 Messages and Descriptions VAIC117E VAIC1181 VAIC1191 VAIC120E You are not authorized to issue command Severity Explanation System action User response Error You have attempted to issue an operator command for which you have inadequate authorization The command is ignored If necessary ask your system administrator to update your security access Refer to the SequeLink Administrator s Guide for information about different types of security access CommandPrefix character s missing or blank Severity Explanation System action User response Information Specifying a non blank CRC causes the SSI to be activated This message informs you that the SSI will be inactive because the CommandPrefix character CP was either omitted from the DataModel or specified as blank The SequeLink or OS 390 SSI is not activated The defaul
236. t use case sensitive filenames the correct capitalization is used in information specific to those environments Also indicates keys or key combinations that you can use For example press the ENTER key Indicates syntax examples values that you specify or results that you receive Indicates names that are placeholders for values that you specify For example filename Separates menus and their associated commands For example Select File Copy means that you should select Copy from the File menu The slash also separates directory levels when specifying locations under UNIX Indicates an OR separator used to delineate items SequeLink Troubleshooting Guide and Reference 12 Preface Convention brackets braces ellipsis Explanation Indicates optional items For example in the following statement SELECT DISTINCT DISTINCT is an optional keyword Also indicates sections of the Windows Registry Indicates that you must select one item For example yes no means that you must specify either yes or no Indicates that the immediately preceding item can be repeated any number of times in succession An ellipsis following a closing bracket indicates that all information in that unit can be repeated Environment Specific Information This reference supports users of various operating environments Where it provides information that does not apply to all supported environments the fo
237. technical support 360 The requested node cannot be found in the monitor tree Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 74 Chapter 6 Error Messages 361 Duplicate object identifier in the monitor tree Cause An internal error occurred Action Contact DataDirect Technologies technical support 362 Could not delete the given node because it owns items that have not been deleted Cause An internal error occurred Action Contact DataDirect Technologies technical support 370 The specified entity type does not exist Cause An internal error occurred Action Contact DataDirect Technologies technical support 371 The specified attribute does not exist Cause An internal error occurred Action Contact DataDirect Technologies technical support 372 The specified entity instance could not be found Cause An internal error occurred Action Contact DataDirect Technologies technical support 373 The specified attributes do not match Cause An internal error occurred Action Contact DataDirect Technologies technical support 374 The specified attribute ID is not valid Cause An internal error occurred Action Contact DataDirect Technologies technical support 375 The specified entity type is not valid Cause An internal error occurred Action Contact DataDirect Technologies technical support
238. ter 6 Error Messages 3062 Internal error unknown provide ID Cause An internal error occurred Action Contact DataDirect Technologies technical support 3063 Maximum number of shared counter instances reached Cause SequeLink was unable to export monitoring data for a new session to the Windows NT performance monitor because the shared counter memory was full The size of the shared counter memory is configured by the ServiceEvQShmMonitorSize service attribute Action Increase the shared counter memory by changing the ServiceEvVQShmMonitorSize service attribute For information about valid values for SequeLink service attributes refer to the SequeLink Administrator s Guide 3064 Internal error an invalid monitor object was specified while processing an event Cause An internal error occurred Action Contact DataDirect Technologies technical support 3065 Save operation not allowed file allocation status or file organization incorrect Cause A remote SequeLink Agent tried to save changes and the SequeLink Server was started with a SWANDD Data Definition that specified an incorrect file allocation status or file organization Action Correct the SWANDM Data Definition in the server JCL use DISP OLD Verify that the SequeLink configuration file has a sequential file organization Then restart the SequeLink Server 3066 Configuration file is in use by another connection please retry Cause An attempt to update the SequeLink
239. ter in the proxy server configuration file 7747 SSL Network read error in client read message length operation Cause A non fatal internal error occurred Action Check the proxy server log file name for more detailed error messages If necessary contact DataDirect Technologies technical support 7748 SSL Network read error in client read message operation Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7749 SSL End of input in client read message length operation Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 187 7750 SSL End of input in client read message operation Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7751 SSL Network write error in client write operation Cause A non fatal internal error occurred Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7752 SSL Client message decoding failed Cause A non fatal internal error occurred Action Check the proxy server log file for mor
240. terest for URid urid Urstate In Urstate Role xxxx Severity Explanation System action User response Information During a restart as a ResourceMgr Incomplete Interest s which were unresolved when SequeLink was last unregistered can be retrieved from RRS Remember Urstate for this urid None Mgr has nnn Incomplete Interest s outstanding Severity Explanation System action User response Information During a restart nnn Incomplete Interest s were retrieved None None Mgr SQLNK DataDirect xxxx restarted Severity Explanation System action User response Information SequeLink Server is restarted successfully as ResourceMgr to RSS None None SequeLink Troubleshooting Guide and Reference 270 Chapter 8 OS 390 Messages and Descriptions VAIS306E VAIS307E VAIS308E VAIS309E VAIS310E Unable to construct a valid Mgr_name Subsystemid is missing Severity Error Explanation SequeLink Server must construct a unique ResourceMgr name to register to RRS The GlobalSubSysid is required to qualify the string SQLNK DataDirect System action The server abends with U130 User response Supply a unique GlobalSubSysid or use CAF DB2 attachment Mgr SQLNK DataDirect xxx registration failed reason xxxx Severity Error Explanation SequeLink registration to RSS failed see reasoncode xxxx System action The server abends with U130 User res
241. tern used is too large Action Try to reduce the size of the search pattern if possible 6065 The buffer supplied is too small Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 6066 The size of the Blob is too big to be cached Cause The size of the Blob is too large to be cached Action If possible try to reduce the size of the Blob SequeLink Troubleshooting Guide and Reference 154 Chapter 6 Error Messages 6068 Can t search Blobs larger than 2 GB Cause The size of the Blob is too large to be searched Action If possible try to reduce the size of the Blob 6069 One or more arguments supplied to method 0 are invalid Cause The parameters specified for method 0 contain invalid values Action Check your JDBC application 6070 Invalid character encoding for Clob Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 6071 Invalid position The Clob data uses UCS2 character encoding and current position is odd Cause This Clob data uses UCS 2 character encoding so the position cannot be an odd value Action Check your JDBC application 6072 Can t set autocommit to true during global transaction Cause You cannot set Autocommit to on for global transactions Action Check your JDBC application 6073 Can t commit using XAConnection during global transaction Cause You cannot call commit during a global transaction Action Check yo
242. ternal error None Contact DataDirect Technologies technical support Notification Exit could not locate RRSM Severity Explanation System action User response Error Internal error None Contact DataDirect Technologies technical support Notification Exit TACB not found Severity Explanation System action User response Error Internal error None Contact DataDirect Technologies technical support WLM in Goal mode Policy xxxxxxxx ServiceDefinition yyyyyyyy Severity Explanation Information Shows the active Policy and ServiceDefinition when WLM is in Goal mode SequeLink Troubleshooting Guide and Reference VAIS3491 VAIS350I VAIS351E VAIS355I Server Controller Task Messages 273 System action Registers as a WorkManager to WLM when MVSGlobalWLMEnclaves is specified User response User response None WLM in Compatibility mode IPS xxxxxxxx ICS yyyyyyyy Severity Information Explanation Shows the active IPS and ICS member when WLM is in compatibility mode System action Registers as a WorkManager to WLM when MVSGlobalWLMEnclaves is specified User response None WLM Enclave support enabled Type VAI Name yyyy Severity Information Explanation When MVSGlobalWLMEnclaves is specified this message means that SequeLink succesfully registered as a workmanager to WLM with Type VAI and Name MvVSGlobalSubSysld System action Sequelink Server is enabl
243. the database user name when you attempt to connect 3316 An invalid Oracle SID is specified in the SequeLink configuration file Cause The SequeLink configuration file specified an invalid Oracle SID Action Specify an existing valid Oracle SID 3317 Internal error An unsupported action is encountered in a fetch callback routine Cause An internal error occurred Action Contact DataDirect Technologies technical support 3318 An Oracle DATE value can only be converted to a SequeLink timestamp value Cause An internal error occurred Action Contact DataDirect Technologies technical support 3319 A SequeLink timestamp value can only be converted to an Oracle DATE value Cause An internal error occurred Action Contact DataDirect Technologies technical support 3320 An Oracle NUMBER value can only be converted to a SequeLink decimal value Cause An internal error occurred Action Contact DataDirect Technologies technical support 3321 A SequeLink decimal value can only be converted to an Oracle NUMBER value Cause An internal error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 115 3322 A backslash is not a valid value for a searchable input parameter of a data dictionary statement Cause A searchable input parameter of a data dictionary statement for example SQLTables has a backslash character value that is not followed by another character Ac
244. the syntax of the DataSourceAutoApplld attribute is correct It must contain exactly 40 hexadecimal digits 3056 A batch cannot contain SQL statements that return a result set Cause A batch cannot contain SQL statements that return a result set Action Check your JDBC application Make sure that only row count generating statements are used in a batch 3057 Internal error the monitor request could not be processed because a required action parameter was not provided Cause An internal error occurred Action Contact DataDirect Technologies technical support 3058 Internal error error detected in the event processor Cause An internal error occurred Action Contact DataDirect Technologies technical support 3059 The specified data source is not defined Cause The specified server data source is not a valid data source for the specified SequeLink service Action Specify a valid server data source for the SequeLink service 3060 Internal error the specified authentication mechanism is not accepted Cause An internal error occurred Action Contact DataDirect Technologies technical support 3061 Authorization failure Cause The ServiceAuthMethods or ServiceAdminAuthMethods service attributes in combination with the ServiceUser or ServiceAdministrator attributes respectively do not allow the user to perform the requested action Action Contact your SequeLink administrator for details SequeLink Troubleshooting Guide and Reference 100 Chap
245. ties refer to the SequeLink Developer s Reference Click Connect If the connection was successful the Connection window appears and a message is displayed in the JOBC Database Output scroll box amp Connection 1 jdbc sequelink bowhead 1 9 Ed Connection Established karst Erev Next Last EEN Vv SequeLink Troubleshooting Guide and Reference 28 Chapter 1 Troubleshooting Tools The connection window shows the following information m Inthe JDBC Database Output scroll box a report indicating whether the last action succeeded or failed m Inthe Java Code scroll box the actual Java code used to implement the last action TIP Select the Concatenate check box to see the Java code of all previous actions otherwise only the Java code of the last action will be shown Troubleshooting the NET Data Provider The NET data provider can trace all its method calls and the returns from those method calls to a user specified trace file Set the following environment variables to enable and control tracing DDTek_Enable_Trace When set to 1 or higher enables tracing The initial default value is 0 tracing is disabled DDTek_Trace_File Specifies the path and name of the trace file The initial default value is SequeLinkTrace txt If the file does not exist the data provider creates it RecreateTrace When set to 1 recreates the trace file each time the application restarts The initial default val
246. tion file m Check the RSACertificate parameter in the proxy server configuration file 7947 SSL An unnecessary RSA privatekey was supplied Cause An attempt was made to start the proxy server with an RSA private key but SSL is not enabled or no cipher suite from the specified cipher suite list requires an RSA private key Action m Check the Network parameter in the proxy server configuration file m Check the CipherSuites parameter in the proxy server configuration file m Check the RSAPrivateKey parameter in the proxy server configuration file 7948 SSL An unnecessary DSS certificate was supplied Cause An attempt was made to start the proxy server with a DSS certificate but SSL is not enabled or no cipher suite from the specified cipher suite list requires a DSS certificate Action m Check the Network parameter in the proxy server configuration file m Check the CipherSuites parameter in the proxy server configuration file m Check the DSSCertificate parameter in the proxy server configuration file SequeLink Troubleshooting Guide and Reference 7949 205 SSL An unnecessary DSS privatekey was supplied Cause An attempt was made to start the proxy server with a DSS private key but SSL is not enabled or no cipher suite from the specified cipher suite list requires a DSS private key Action m Check the Network parameter in the proxy server configuration file m Check the CipherSuites parameter in the proxy
247. tion Change the data dictionary statement in your application to use a valid value for a searchable input parameter 3323 The precision of a decimal input parameter is out of range Cause The SequeLink Client sent a decimal input value with a precision that is larger than the maximum allowed Oracle precision Action Change your application 3324 The impersonation of the SequeLink Server for Oracle failed Cause The SequeLink Server is configured in OS integrated mode DataSourceLogonMethod OSIntegrated but the impersonation of the SequeLink Server failed Action Contact DataDirect Technologies technical support 3326 Invalid querytimeout value Cause Only positive values are allowed as querytimeout Action Specify a valid querytimeout value 3327 Internal error An invalid SequeLink decimal parameter value encountered Cause The SequeLink Client sent a decimal value that is not recognized by the SequeLink Server Action Contact DataDirect Technologies technical support 3328 Oracle TIMESTAMP WITH TIME ZONE is not supported by this SequeLink configuration Cause By default SequeLink does not support the Oracle type Timestamp with time zone because there is no corresponding ODBC JDBC ADO type to represent this data Action SequeLink implements a workaround to support Timestamp With Time Zone See the description of DataSourceORAMapTSWTZ in the SequeLink Administrator s Guide SequeLink Troubleshooting Guide and Reference 1
248. tion Set the ServiceDebugLogLevel to debug Make a new connection and look for the message in the session log file SWANDB SPEC GetDBCodePageSettings cannot retrieve the DB2 codepage settings sqlcode xxx Contact DataDirect Technologies technical support and provide the codepage setting information SequeLink Troubleshooting Guide and Reference 111 3209 A connection to a SequeLink service with enhanced code page support can only be established when ServiceCodepage is set to Database Cause A connection to a SequeLink service with enhanced code page support was executed when the ServiceCodePage was set to Default or OS Action Check the SequeLink configuration and verify that the ServiceCodePage attribute is set to Database for the service to which you want to connect If the problem persists contact DataDirect Technologies technical support 3210 A connection to a SequeLink service without enhanced code page support can only be established when ServiceCodepage is set to Default or OS Cause A connection to a SequeLink service with enhanced code page support was executed and the ServiceCodePage is set to Database Action Check the SequeLink configuration and verify that the ServiceCodePage for the service to which you want to connect is set to Default or OS If the problem persists contact DataDirect Technologies technical support 3211 A connection to a SequeLink service set up with ServiceCodepage Database req
249. tool for your platform For information about service attributes and SequeLink administration tools refer to the SequeLink Administrator s Guide The following is an example of a connection string that enables the workaround for a specific data source DSN Employees WorkArounds 536870912 In this example only the SequeLink connections that specify the data source Employees have the workaround activated By using multiple SequeLink data sources you can control which SequeLink connections use the workaround Using the ODBC Socket Service with IBM DB2 Driver When you use SequeLink Server for ODBC Socket with the IBM DB2 UDB driver you must specify the name of the database that will be accessed through the connection The name of the database is passed using the DBALIAS keyword To connect successfully to a DB2 database using SequeLink Server for ODBC Socket you must specify a data source name and a database in the DataSourceSOCODBCConnsStr service attribute as shown in the following example DSN Employees DBALIAS HumanResources Only one database can be specified for each SequeLink data source To access multiple databases you must create one SequeLink data source for each database SequeLink Troubleshooting Guide and Reference 40 Chapter 3 Troubleshooting Your Database Connection Analyzing ODBC Socket Service Problems This section explains how to investigate problems or unexpected behavior when using Seque
250. tttt Logged off abnormally Severity Warning Explanation The connection is logged off abnormally from DB2 System action DB2 resources are Rolled back User response None ServiceDB2MaxThreads nnn lower then ServiceMaxThreads mmm Severity Warning Explanation Configuration conflict SequeLink Troubleshooting Guide and Reference VAIDO70W VAIDO72T VAIDO731 System action User response DB2 Application Support Package Messages 235 The value of ServiceMaxThreads will be used to limit the maximum number of DB2 threads allowed Increase the value of the dynamic ServiceDB2MaxThreads parameter Verify that the new value is lower than the MAX BATCH CONNECT parameter in the Thread management panel DSNTIPE of the DB2 installation and greater than ServiceMaxThreads in Sequelink Configuration file Ttttttttt Maximum of allowed DB2Threads nnnn reached Severity Explanation System action User response Warning The connection will not obtain a DB2 thread Either the Logon fails or the client connection is unable to use DB2 sqicode 981 Increase the value of the dynamic ServiceDB2MaxThreads parameter and verify that this value is lower than the MAX BATCH CONNECT parameter in the Thread management panel DSNTIPE of the DB2 installation VAICDB2R IFI command cccccccccccccccccc IFCARC1 rc1 IFCARC2 rc2 Severity Explanation System action User response Trace When canceli
251. type 0 The method registerOutParameter int int is not supported for DECIMAL data Cause The method registerOutParameter int int is not supported for DECIMAL data Action Correct your JDBC application 7413 No output parameter is registered at parameter index 0 registerOutParameter must be called prior to getXXX on a CallableStatement Cause registerOutParameter must be called prior to getXXX ona CallableStatement Action Correct your JDBC application 7414 Conversion not supported 0 used for SQL data type 1 at parameter index 2 The specified method is illegal for a column of the specified SQL data type Cause The specified method is invalid for a column of the specified SQL data type Action Correct your JDBC application SequeLink Troubleshooting Guide and Reference 175 7415 Illegal method call on a PreparedStatement The methods on Statement that have a SQL statement as parameter like execute sql and addBatch sql are not supported on PreparedStatements Cause The methods on Statement that have a SQL statement as parameter like execute sql and addBatch sql are not supported on PreparedStatements Action Check your JDBC application 7416 The number of input parameters is different from the previous parameter set Cause The number of input parameters is different from the previous parameter set Action Check your JDBC application 7417 Output parameters with batch updates are not sup
252. ubleshooting Guide and Reference 180 Chapter 6 Error Messages 7447 An unsupported transliteration type has been specified 0 Cause An unsupported transliteration type has been specified Action Contact DataDirect Technologies technical support 7448 You are attempting to use this DataDirect Technologies software from an application that is not licensed to use it Cause An internal error occurred Action Contact DataDirect Technologies technical support 7449 Server asked for unknown encryption Cause An internal error occurred Action Contact DataDirect Technologies technical support 7450 No initialization vector was sent when one was expected Cause An internal error occurred Action Contact DataDirect Technologies technical support 7451 Initialization vector has wrong size 0 bytes Expected 1 bytes Cause An internal error occurred Action Contact DataDirect Technologies technical support 7452 Error occurred during transliteration Cause An internal error occurred Action Contact DataDirect Technologies technical support 7481 Result set type is changed from 0 to 1 This is a SQL Warning Cause The result set type is changed from 0 to 1 This is a SQL Warning Action Refer to the SequeLink Developer s Reference for information about restrictions on scrollable cursors SequeLink Troubleshooting Guide and Reference 181 7482 Result set concurre
253. ue is 0 the trace file is appended The NET data provider traces the input arguments to all of its public method calls as well as the outputs and returns from those SequeLink Troubleshooting Guide and Reference Troubleshooting the NET Data Provider 29 methods anything that a user could potentially call Each call contains trace entries for entering and exiting the method The trace output has the following format lt Correlation gt lt Timestamp gt lt CurrentThreadName gt lt Object Address gt lt ObjectName MethodName gt ENTER or EXIT Argument 1 lt Argument 1 Value gt Argument 2 lt Argument 2 Value gt RETURN lt Method ReturnValue gt This line only exists for EXIT where Correlation is a unique number that can be used to match up ENTER and EXIT entries for the same method call in an application and Value is the hash code of an object appropriate to the individual function calls NOTE For installation instructions refer to the SequeLink Installation Guide SequeLink Troubleshooting Guide and Reference 30 Chapter 1 Troubleshooting Tools SequeLink Troubleshooting Guide and Reference 31 2 Troubleshooting TCP IP Connection Problems Establishing a TCP IP connection between a SequeLink Client and a SequeLink service consists of the following steps 1 A low level TCP IP connection is made from a SequeLink Client to a SequeLink Server that is listening on the specified TCP IP port See the
254. ue specified Cause An illegal value for the BackLog parameter is specified in the proxy server configuration file Action Check the BackLog parameter in the proxy server configuration file 7743 SSL Use different port number for administration port Cause An attempt was made to use the same port number for the proxy server port Port parameter used for listening to incoming requests and the proxy server administration port AdminPort parameter Action m Check the Port parameter in the proxy server configuration file m Check the AdminPort parameter in the proxy server configuration file SequeLink Troubleshooting Guide and Reference 186 Chapter 6 Error Messages 7744 SSL Fatal error occurred while receiving accept Cause Internal error An error occurred when accepting an incoming connection request Action Check the proxy server log file for more detailed error messages If necessary contact DataDirect Technologies technical support 7745 SSL Host name not found or empty in configuration file Cause A server that is not a SequeLink Server has been specified using the proxy server Host parameter Action Check the Host parameter in the proxy server configuration file Make sure that it specifies a SequeLink Server 7746 SSL Non numerical value for close wait time specified Cause The proxy server configuration file specified a non numeric value for the CloseWaitTime parameter Action Check the CloseWaitTime parame
255. ueLink e An invalid IP address has been specified e An invalid host name has been specified even if the host name is mapped to a valid IP address e The server host may not be operational e The server host could not be reached from the client machine because of a routing problem mg If atime limit is set on the connection check whether a timeout occurred Error 2320 is returned when TCP IP cannot connect to the server host within the specified time Increase the time interval and try again to connect m If the port is specified by a name instead of a number check whether the name can be mapped to a port number Error 2470 is returned if the specified name cannot be mapped to a port number Check the TCP IP services configuration file m Verify that a SequeLink service is listening on the server host at the specified port Use the netstat a command on the host to obtain a list of TCP ports that are in the listening state m Check for congestion problems on the server Error 2306 or Error 2308 is returned if TCP IP can reach the server and a service is listening on the server host at the specified port but too many TCP IP connection attempts are being made simultaneously for the server to handle SequeLink Troubleshooting Guide and Reference Connection Handshaking Connection Handshaking If you are experiencing problems during handshaking after the low level TCP IP connection has been made to a SequeLink Server follow
256. uires at least SequeLink 5 4 client or higher for ODBC JDBC or ADO NET Cause A connection to a SequeLink service with enhanced code page support was executed using an unsupported version of the SequeLink Client The ServiceCodePage Database setting is supported on SequeLink Clients version 5 4 or higher Action Check the version of the SequeLink ODBC JDBC or NET Client 3213 CLOB data type in UTF8 is not supported in SequeLink for DB2 UDB Cause DB2 UDB Unicode databases store character based Large Objects CLOB data in UTF 8 SequeLink for DB2 UDB does not support this multi byte character data type Action Check your application Remove the references to UTF 8 based CLOB columns or change the references to UCS 2 based DBCLOB columns 3301 Optional feature not implemented Cause A request to change to another catalog was refused You cannot change to another catalog Action Do not try to change to another catalog SequeLink Troubleshooting Guide and Reference 112 Chapter 6 Error Messages 3302 Unsupported transaction level Cause A request to change to an unsupported transaction level was refused Action Use a supported transaction level 3303 An invalid Oracle parameter kind is encountered Cause Oracle returned a stored procedure parameter type that is not documented Action Contact DataDirect Technologies technical support 3304 A incorrect number of parameter markers is encountered in the statement
257. upport 7838 SSLJA token had an invalid MIC Cause An internal error standard MGSS error occurred Not used by the standard SequeLink authentication modules Action Contact DataDirect Technologies technical support 7839 SSL No credentials were supplied or the credentials were unavailable or inaccessible Cause Authentication failed because the supplied credentials for example user name or password were incorrect or missing The required credentials depend on the selected authentication mechanism Action m Check the supplied authentication information for example user name or password m Check which credentials the selected authentication mechanism expects SequeLink Troubleshooting Guide and Reference 198 Chapter 6 Error Messages 7840 SSL Invalid context has been supplied Cause Internal error standard MGSS error This is an internal error or an authentication state error Action Contact DataDirect Technologies technical support 7841 SSLJA supplied token was invalid Cause An internal error standard MGSS error occurred A token used during authentication between client and server was invalid This is an internal error in the selected authentication mechanism or a mismatch between client and server authentication providers Action Check the com ddtek sequelink slje properties properties file If necessary contact DataDirect Technologies technical support 7842 SSLJA supplied credential was
258. upport reclaiming open connections Action Check your JDBC application 6049 Login has timed out Cause A timeout expired Action Verify that the SequeLink Server is running and that you have specified the correct network address of the host If your configuration is correct increase the connection timeout value 6050 This driver is locked for use with embedded applications Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 6052 There was an error s in processing the batch command Use getNextException for details Cause An unexpected error occurred Action Contact DataDirect Technologies technical support SequeLink Troubleshooting Guide and Reference 152 Chapter 6 Error Messages 6053 Statements that produce result sets are not allowed in batch commands Cause An unexpected error occurred Action Contact DataDirect Technologies technical support 6054 ResultSet is not updateable Cause The application issued a method on a read only result set that can only be called on an updatable result set Action Check your JDBC application 6055 Can not update the specified column is not writable Cause The application tried to update a read only column Action Check your JDBC application 6056 Row update actually caused 0 rows to be updated Cause ResultSet updateRow updated more ore than one row Action Make sure that your application selects the primary key of the t
259. ur JDBC application 6074 Can t rollback using XAConnection during global transaction Cause You cannot call rollback during a global transaction Action Check your JDBC application 6076 Cannot insert an empty row into this ResultSet Cause Your database does not support inserting an empty row into a result set Action Check your JDBC application SequeLink Troubleshooting Guide and Reference 155 6077 The position specified is past the end of the BLOB or CLOB Cause One of the specified parameters contains an invalid value Action Check your JDBC application 6078 The operation was cancelled at the user s request Cause The user cancelled the execute on another thread Action None 6079 All of the data supplied could not be written Cause One of the specified parameters contains an invalid value Action Check your JDBC application 6080 The specified Savepoint does not have a numeric ID Cause This savepoint does not have a numeric ID Action Check your JDBC application 6081 The specified Savepoint is un named Cause This savepoint does not have a name Action Check your JDBC application 6082 The specified Savepoint is invalid Cause The application specified an invalid savepoint Action Check your JDBC application 6083 Discarded ResultSet during executeUpdate Cause The application used executeUpdate for a SQLStatement that also returns Result Sets Action Check your JDBC application if you really want to discard t
260. urned from Application with rc _ Severity Explanation System action User response VAIL113E Thrdid __ Severity Explanation System action User response Error The ServiceApplication returned from MAIN with a nonzero return code If rc 8 the Thread Control Block TCB will be abended to force DB2 to roll back the Unit of Work UOW This message is followed by VAIL113E If any other return code is reported the return code is ignored None Application requested an Abend Error The ServiceApplication returned from MAIN with rc 8 This message follows a VAIL112E message The Thread Control Block will be abended to force DB2 to roll back the Unit of Work None SequeLink Troubleshooting Guide and Reference Server Controller Task Messages 241 Server Controller Task Messages This section contains OS 390 log messages generated by VAISMAIN VAISMAIN handles the server controller tasks VAISOO1F Initialization failed insufficient storage 01 Severity Fatal Explanation Unable to obtain storage for communication area System action VAISMAIN terminates with condition code 64 User response Report this error to DataDirect Technologies technical support VAISOO2F Build Data_Model failed xxxxxxxx Severity Fatal Explanation Problem encountered during build of SequeLink configuration file where xxxxxxxxxx describes the problem in more detail System action The server abends
261. with abend code 101 User response XXXXXXXX VAISMNDM did not complete within time frame For all other reasons contact DataDirect Technologies technical support VAISOOS5I DB2 task started DB2ifid dddd Severity Information Explanation DB2 root task started to support DB2 service for DB2ifid dddd System action None User response None VAISOO6E DB2Interfaceld has an invalid length Severity Error Explanation The maximum length of DB2InterfacelD is 4 characters SequeLink Troubleshooting Guide and Reference 242 Chapter 8 OS 390 Messages and Descriptions System action DB2 root task not started User response Correct DB2InterfacelD VAISOO7E Problem building TACB for DB2ifid xxxx Severity Error Explanation DB2 TACB could not be created System action DB2 root task not started User response Contact DataDirect Technologies technical support VAISOO8I XTCP task started Severity Information Explanation Extended TCP IP listener task started System action None User response None VAISOO9F Problem building XTCP TACB Severity Fatal Explanation XTCP TACB could not be created System action The server abends with code 101 User response Contact DataDirect Technologies technical support VAISO10F No EntityList found Severity Fatal Explanation No EntityList was passed after SequeLink configuration file build VAISMNDM System action The server abends with code 101 User
262. x with ClusterName cccccccccccccccccc System action None User response None SequeLink Troubleshooting Guide and Reference 276 Chapter 8 OS 390 Messages and Descriptions Resource Manager Messages VAIC125E VAIX010E This section contains OS 390 log messages generated by the operator interface resource manager facility VAICOPRM which allows any SequeLink or OS 390 task to initialize a resource manager routine to provide independent task cleanup and to supplement end of task routines provided by SequeLink or 0S 390 RESMGR failed w RC rc SSI ssid withdrawn Severity Error Explanation VACOPRI was unable to initialize its resource manager VAICOPRM The initialization request failed with the return code rc The SSI for ssid is not enabled meaning that command character prefixes cannot be used to enter SequeLink or OS 390 operator commands System action The operator interface proceeds without the SSI User response This is an internal error Contact DataDirect Technologies technical support The following messages are not written in the SequeLink or OS 390 log because they are issued by VAICOPRM when SequeLink or OS 390 is shutting down and message logging may be disabled These messages are generated using standard WTO macros Invalid SSCT passed Severity Error Explanation The VAICOPRM caller VAICOPRI passed an invalid SSCT VAICOPRM ends normally but the SSCT reset was not performed S

Download Pdf Manuals

Related Search

Related Contents

Compressori a Vite Screw Compressors R134a  Franke ADG 611-L  Notices d`Utilisation RV  取扱説明書 100mm 防じんマルノコ 125mm 防じんマルノコ  8 Motor User Manual  VR 18-24 - Navigloo  Design++ Release Notes  1 - Kenwood  Radio Shack TD-1500 User's Manual  サーバーレスオンデマンドプリント 取扱説明書  

Copyright © All rights reserved. Failed to retrieve file