SQL Server communications errors - Revision history

ELowell at 00:00, 12 October 2016

2016-10-12T00:00:20Z

← Older revision		Revision as of 00:00, 12 October 2016
Line 273:		Line 273:
	</tr>		</tr>
	</table>		</table>

			==See also==
			{{Template:SQL connectivity topic list}}

	[[Category: SQL connectivity]]		[[Category: SQL connectivity]]

ELowell: /* Interpreting communications errors */

2015-07-20T20:05:34Z

Interpreting communications errors

← Older revision		Revision as of 20:05, 20 July 2015
Line 7:		Line 7:
	Connect<span class="superstar">★</span> errors that involve the underlying communications layer are handled differently from application-level errors. </p>		Connect<span class="superstar">★</span> errors that involve the underlying communications layer are handled differently from application-level errors. </p>

	~~<H3 CLASS~~=~~"blocklabel">~~		===Communications error display format===
	Communications error display format~~</H3>~~
	<p>		<p>
	Each Model 204 error condition involving the underlying communications layer is displayed as one or two error messages. One of these messages contains the status codes. The other line, if any, contains a Model 204 message that helps to describe the condition that caused the error.</p>		Each Model 204 error condition involving the underlying communications layer is displayed as one or two error messages. One of these messages contains the status codes. The other line, if any, contains a Model 204 message that helps to describe the condition that caused the error.</p>
Line 14:		Line 13:
	An error message that includes the status codes has the following format:</p>		An error message that includes the status codes has the following format:</p>

	<p class="syntax">M204.<i>nnnn</i>: COMM ERROR STATUS=<i>nn</i>, STATUSD=<i>nn</i></p>		<p class="syntax">M204.<span class="term">nnnn</span>: COMM ERROR STATUS=<span class="term">nn</span>, STATUSD=<span class="term">nn</span></p>
	<p>		<p>
	The STATUS value refers to the status of the communications statement last executed. This value is a number value greater than or equal to zero. A value of 12 or greater indicates that a communications error occurred and identifies the error as belonging to a particular category. </p>		The STATUS value refers to the status of the communications statement last executed. This value is a number value greater than or equal to zero. A value of 12 or greater indicates that a communications error occurred and identifies the error as belonging to a particular category.</p>
	<p>		<p>
	STATUSD is set to the return code that details the specific error condition within a particular STATUS category. </p>		STATUSD is set to the return code that details the specific error condition within a particular STATUS category.</p>
	<p>		<p>
	STATUS and STATUSD refer to the Model 204 SOUL $STATUS and $STATUSD function values described in [[#$STATUS and $STATUSD codes\|$STATUS and $STATUSD codes]].</p>		STATUS and STATUSD refer to the Model 204 SOUL $STATUS and $STATUSD function values described in [[#$STATUS and $STATUSD codes\|$STATUS and $STATUSD codes]].</p>
Line 28:		Line 27:
	<p class="caption">$STATUS and $STATUSD codes</p>		<p class="caption">$STATUS and $STATUSD codes</p>
	<table>		<table>
	<tr>		<tr class="head">
	<th>S</th>		<th>S</th>
	<th>SD</th>		<th>SD</th>
Line 261:		Line 260:
	<td>53</td>		<td>53</td>
	<td>1</td>		<td>1</td>
	<td>Session or connection failure. Check sense code in <var>[[$Errmsg]]</var>.</td>		<td>Session or connection failure. Check the sense code in <var>[[$Errmsg]]</var>.</td>
	</tr>		</tr>
	<tr>		<tr>

JAL: add link

2015-06-12T15:56:12Z

add link

← Older revision		Revision as of 15:56, 12 June 2015
Line 261:		Line 261:
	<td>53</td>		<td>53</td>
	<td>1</td>		<td>1</td>
	<td>Session or connection failure. Check sense code in $~~ERRMSG~~.</td>		<td>Session or connection failure. Check sense code in <var>[[$Errmsg]]</var>.</td>
	</tr>		</tr>
	<tr>		<tr>

ELowell at 17:27, 23 February 2015

2015-02-23T17:27:57Z

← Older revision		Revision as of 17:27, 23 February 2015
Line 275:		Line 275:
	</table>		</table>

	[[Category: SQL ~~Connectivity~~]]		[[Category: SQL connectivity]]

ELowell at 23:30, 20 February 2015

2015-02-20T23:30:16Z

← Older revision		Revision as of 23:30, 20 February 2015
Line 275:		Line 275:
	</table>		</table>

	~~[[Category: Model 204 SQL processing]]~~
	[[Category: SQL Connectivity]]		[[Category: SQL Connectivity]]

ELowell at 23:29, 20 February 2015

2015-02-20T23:29:34Z

← Older revision		Revision as of 23:29, 20 February 2015
Line 276:		Line 276:

	[[Category: Model 204 SQL processing]]		[[Category: Model 204 SQL processing]]
			[[Category: SQL Connectivity]]

ELowell: Created page with "==Interpreting communications errors==
When you use or attempt to use Connect★, Model 204 generates messages that track the network ac..."

2015-02-19T22:22:44Z

Created page with "==Interpreting communications errors== When you use or attempt to use Connect★, Model 204 generates messages that track the network ac..."

New page

==Interpreting communications errors==

When you use or attempt to use Connect★, Model 204 generates messages that track the network activity. Model 204 writes these messages in the audit trail. 

If an error occurs involving Connect★, conversation processing is neither started nor stopped, and Model 204 automatically displays status codes and sometimes an error message on the operator's console. Model 204 also writes the error message in the audit trail. 

Connect★ errors that involve the underlying communications layer are handled differently from application-level errors. 

<H3 CLASS="blocklabel">
Communications error display format</H3>

Each Model 204 error condition involving the underlying communications layer is displayed as one or two error messages. One of these messages contains the status codes. The other line, if any, contains a Model 204 message that helps to describe the condition that caused the error.

An error message that includes the status codes has the following format:

M204.nnnn: COMM ERROR STATUS=nn, STATUSD=nn

The STATUS value refers to the status of the communications statement last executed. This value is a number value greater than or equal to zero. A value of 12 or greater indicates that a communications error occurred and identifies the error as belonging to a particular category. 

STATUSD is set to the return code that details the specific error condition within a particular STATUS category. 

STATUS and STATUSD refer to the Model 204 SOUL $STATUS and $STATUSD function values described in [[#$STATUS and $STATUSD codes|$STATUS and $STATUSD codes]].

===$STATUS and $STATUSD codes===
The following table lists the possible combinations of return values of the $STATUS and $STATUSD functions and a brief description of each combination.

The combinations are listed by ascending $STATUSD value (SD column) for each $STATUS value (S column).
$STATUS and $STATUSD codes
<table>
<tr>
<th>S</th>
<th>SD</th>
<th>Description</th>
</tr>
<tr>
<td>0</td>
<td>0</td>
<td>Normal completion; no unusual conditions.</td>
</tr>
<tr>
<td>1</td>
<td>0</td>
<td>Normal completion; check RESULT variable.</td>
</tr>
<tr>
<td>1</td>
<td>1</td>
<td>Specified event(s) not pending (WAIT or TEST).</td>
</tr>
<tr>
<td>1</td>
<td>2</td>
<td>Specified event(s) still pending (TEST).</td>
</tr>
<tr>
<td>1</td>
<td>3</td>
<td>WAIT completed due to timeout.</td>
</tr>
<tr>
<td>2</td>
<td>2</td>
<td>SEND ERROR statement issued by partner.</td>
</tr>
<tr>
<td>3</td>
<td>3</td>
<td>State check: verb issued in wrong conversation state.</td>
</tr>
<tr>
<td>4</td>
<td>0</td>
<td>Conversation ended normally by partner process. The partner process has finished executing, or it has ended the conversation by issuing a CLOSE PROCESS statement.</td>
</tr>
<tr>
<td>4</td>
<td>1</td>
<td>Partner closed conversation abnormally.</td>
</tr>
<tr>
<td>5</td>
<td>1</td>
<td>Password is required. If the USERID keyword parameter is provided in the OPEN PROCESS statement, then PASSWORD parameter must also be provided.</td>
</tr>
<tr>
<td>5</td>
<td>2</td>
<td>Process is already open. The OPEN PROCESS statement being executed specifies a process name or CID for a process that is already open.</td>
</tr>
<tr>
<td>5</td>
<td>3</td>
<td>Initial (PIP) data incorrectly specified.</td>
</tr>
<tr>
<td>5</td>
<td>4</td>
<td>Entity (process, processgroup, or link) not defined.</td>
</tr>
<tr>
<td>5</td>
<td>5</td>
<td>Process has not been opened.</td>
</tr>
<tr>
<td>5</td>
<td>6</td>
<td>Statement or option not supported.</td>
</tr>
<tr>
<td>5</td>
<td>11</td>
<td>Process can be opened only within an application subsystem.</td>
</tr>
<tr>
<td>5</td>
<td>12</td>
<td>Process definition requires "OPEN" for security parameters. The OPEN PROCESS statement being executed contains an ACCOUNT or USERID parameter. This is valid only when the process definition specifies ACCTSOURCE=OPEN or UIDSOURCE=OPEN (PROFILE and PROFSOURCE can be written instead of ACCOUNT and ACCTSOURCE).</td>
</tr>
<tr>
<td>5</td>
<td>13</td>
<td>Security violation.</td>
</tr>
<tr>
<td>5</td>
<td>14</td>
<td>SESPARMS was specified on the processgroup definition but is not valid for Horizon or Horizon links.</td>
</tr>
<tr>
<td>5</td>
<td>15</td>
<td>OPEN type conflicts with PROCESS type.</td>
</tr>
<tr>
<td>5</td>
<td>16</td>
<td>Reserved names cannot be used in OPEN PROCESS.</td>
</tr>
<tr>
<td>5</td>
<td>17</td>
<td>Process name or CID is too long.</td>
</tr>
<tr>
<td>5</td>
<td>18</td>
<td>Synchronization level not supported. CONFIRM verb requires the process definition to have the CONFIRM parameter.</td>
</tr>
<tr>
<td>5</td>
<td>19</td>
<td>Required parameter not specified.</td>
</tr>
<tr>
<td>5</td>
<td>20</td>
<td>Invalid duration value specified for WAIT statement.</td>
</tr>
<tr>
<td>10</td>
<td>1</td>
<td>Insufficient main storage available at local node.</td>
</tr>
<tr>
<td>10</td>
<td>2</td>
<td>Reserved.</td>
</tr>
<tr>
<td>10</td>
<td>3</td>
<td>Local link is not open or is being stopped or closed.</td>
</tr>
<tr>
<td>10</td>
<td>4</td>
<td>Local processgroup is being stopped.</td>
</tr>
<tr>
<td>11</td>
<td>1</td>
<td>Partner process temporarily cannot be started.</td>
</tr>
<tr>
<td>11</td>
<td>3</td>
<td>Remote allocation failure that you can retry.</td>
</tr>
<tr>
<td>12</td>
<td>1</td>
<td>Link failure.</td>
</tr>
<tr>
<td>13</td>
<td>1</td>
<td>Session or connection failure.</td>
</tr>
<tr>
<td>13</td>
<td>2</td>
<td>Reserved.</td>
</tr>
<tr>
<td>13</td>
<td>3</td>
<td>Connection failure for parallel session setup.</td>
</tr>
<tr>
<td>50</td>
<td>1</td>
<td>Local session or connection limit has been reached.</td>
</tr>
<tr>
<td>50</td>
<td>2</td>
<td>Local conversation limit has been reached.</td>
</tr>
<tr>
<td>50</td>
<td>3</td>
<td>Server process subsystem could not be started because APSY is not initialized.</td>
</tr>
<tr>
<td>50</td>
<td>4</td>
<td>Subsystem is not available. The requested server process subsystem is not defined in CCASYS.</td>
</tr>
<tr>
<td>50</td>
<td>5</td>
<td>Input buffer too small for SUBSYSPARM. The SUBSYSPARM value specified in the process definition was larger than the size in the IODEV 27 command line.</td>
</tr>
<tr>
<td>50</td>
<td>6</td>
<td>Synchronization level not supported by local process. Requesting process and local process must agree on CONFIRM or NOCONFIRM.</td>
</tr>
<tr>
<td>50</td>
<td>7</td>
<td>Server security violation.</td>
</tr>
<tr>
<td>51</td>
<td>1</td>
<td>Server process not available. Examine messages sent to operator's console or audit trail at server node to diagnose.</td>
</tr>
<tr>
<td>51</td>
<td>2</td>
<td>Synchronization level not supported by server. The server process definition does not specify the same synchronization level as that of the local process (CONFIRM/NOCONFIRM).</td>
</tr>
<tr>
<td>52</td>
<td>1</td>
<td>Link failure.</td>
</tr>
<tr>
<td>53</td>
<td>1</td>
<td>Session or connection failure. Check sense code in $ERRMSG.</td>
</tr>
<tr>
<td>53</td>
<td>2</td>
<td>Conversation timed out waiting for response from partner.</td>
</tr>
<tr>
<td>53</td>
<td>3</td>
<td>Session or connection not established due to incorrect session or connection parameters.</td>
</tr>
</table>

[[Category: Model 204 SQL processing]]