Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. FIX: The Microsoft Service for DRDA trace log listener repeatedly writes an error message in the trace log file

FIX: The Microsoft Service for DRDA trace log listener repeatedly writes an error message in the trace log file

View products that this article applies to.

Symptoms

The Microsoft Service for Distributed Relational Database Architecture (DRDA) trace log listener may repeatedly write an error message in the trace log file when certain errors occur. After the error message is written to the trace log file, the trace log listener does not log messages for any new transactions that are processed by the Microsoft Service for DRDA.

The following is an example excerpt of a trace log that shows an error message that is written repeatedly:

Information:3:3:[date time] Request: SYNCCTL, SyncType=SYNCTYPE_FORGET
Information:3:3:[ date time] Client 10 disconnected
Information:3:3:[ date time] Client 10 disconnected
Information:3:3:[ date time] Client 10 disconnected
Information:3:3:[ date time] Client 10 disconnected
Information:3:3:[ date time] Client 10 disconnected
Information:3:3:[ date time] Client 10 disconnected
Information:3:3:[ date time] Client 10 disconnected
Information:3:3:[ date time] Client 10 disconnected
Information:3:3:[ date time] Client 10 disconnected
Information:3:3:[ date time] Client 10 disconnected
Information:3:3:[ date time] Client 10 disconnected

↑ Back to the top

Resolution

Cumulative update information

The fix that resolves this problem is included in Cumulative Update 1  for Microsoft Host Integration Server 2013.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

More Information

This problem may occur when the following conditions are true:
  • An IBM DB2 database sends a fully qualified quoted identifier such as "SCHEMA1.TABLE1." 
  • An SQL synonym is not defined for the DB2 alias in the Microsoft Service for DRDA configuration. 
Under these conditions, the SQL transformer in the Microsoft Service for DRDA converts the fully qualified quoted identifier to a quoted SQL schema name only, such as "SCHEMA1," because of the missing SQL synonym. This results in an error because the SQL table name is missing and therefore the SQL table cannot be located. At this point, the trace log listener problem is encountered because one of the messages is repeatedly written to the trace log file.

↑ Back to the top

Keywords: kbqfe, kbhotfixserver, kbfix, kbexpertiseinter, kbbug, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2899694
Revision : 1
Created on : 1/7/2017
Published on : 4/1/2014
Exists online : False
Views : 312