Consultor Eletrônico

Status: Verified

SYMPTOM(s):

=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20211
[JDBC Progress Driver]:Server not reachable or possible RPC error

Server log has the following entries:
SQLSRV2 1: PROSQL_LOCKWAIT_TIMEOUT value is: 5 seconds
SQLSRV2 1: Login usernum 47, remote SQL client. (8873)
SQLSRV2 1: Usr 47 set name to actuate. (7129)
BROKER 0: Disconnecting client 47 of dead server 1. (2526)
BROKER 0: Begin transaction backout. (2252)
08:57:48 BROKER 0: Transaction backout completed. (2253)
08:57:48 BROKER 0: Disconnecting dead server 1. (2525)

Executing an SQL-92 query similar to:
SELECT
( UPPER("PUB"."Customer"."Cust-no") ) As ShipToCustNo,
( "PUB"."Order"."Order-no" ) As OrderNo
FROM
"PUB"."Customer"
inner join "PUB"."Customer-D"
on "PUB"."Customer"."Cust-no" = "PUB"."Customer-D"."Cust-no"
inner join "PUB"."Order"
on 'SZZ' = "PUB"."Order"."Ar-entity"
and UPPER("PUB"."Customer"."Cust-no") = UPPER("PUB"."Order"."Cust-no")
and 'BOOK' = UPPER("PUB"."Order"."Order-class")
inner join "PUB"."Order-Line"
on "PUB"."Order"."Ar-entity" = "PUB"."Order-Line"."Ar-entity"
and "PUB"."Order"."Order-no" = "PUB"."Order-Line"."Order-no"
WHERE
"PUB"."Customer-D"."Last-inv-dat" > '10/1/2002'
and "PUB"."Customer"."Slsmn-code" = 'DJH';

The query executes fine without the last join:
SELECT
( UPPER("PUB"."Customer"."Cust-no") ) As ShipToCustNo,
( "PUB"."Order"."Order-no" ) As OrderNo
FROM
"PUB"."Customer"
inner join "PUB"."Customer-D"
on "PUB"."Customer"."Cust-no" = "PUB"."Customer-D"."Cust-no"
inner join "PUB"."Order"
on 'SZZ' = "PUB"."Order"."Ar-entity"
and UPPER("PUB"."Customer"."Cust-no") = UPPER("PUB"."Order"."Cust-no")
and 'BOOK' = UPPER("PUB"."Order"."Order-class")
WHERE
"PUB"."Customer-D"."Last-inv-dat" > '10/1/2002'
and "PUB"."Customer"."Slsmn-code" = 'DJH'

FACT(s) (Environment):

All Supported Operating Systems
Progress 9.1D

CAUSE:

The query involves one or more inactive indexes.

FIX:

Make all the indexes involved in the query active.