Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (herse.apache.org: local policy)
From: Daniel Noll <daniel@nuix.com>
To: "Derby Discussion" <derby-user@db.apache.org>
Subject: Re: ERROR XSAI2: The conglomerate requested does not exist.
Date: Mon, 14 May 2007 10:44:12 +1000
User-Agent: KMail/1.9.6
References: <200705111509.54028.daniel@nuix.com> <46449012.8010701@gmail.com>
 <200705141004.33602.daniel@nuix.com>
In-Reply-To: <200705141004.33602.daniel@nuix.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200705141044.12977.daniel@nuix.com>

On Monday 14 May 2007 10:04:33 Daniel Noll wrote:
> I'll see if I can get access to the derby.log file.

Okay, now I have derby.log and the same error occurs twice.  Once on 
checkpoint, but it also happens earlier when trying to do a real query 
(figures.)

Here's the lines which precede the error:

2007-05-11 04:34:05.612 GMT Thread[sG,5,main] (XID = 114873), (SESSIONID = 0), 
(DATABASE = directory:D:\Path\To\Stores\EvidenceDatabase), (DRDAID = null), 
Cleanup action starting
2007-05-11 04:34:05.612 GMT Thread[sG,5,main] (XID = 114873), (SESSIONID = 0), 
(DATABASE = directory:D:\Path\To\Stores\EvidenceDatabase), (DRDAID = null), 
Failed Statement is: SELECT CAST ('' AS VARCHAR(128)) AS TABLE_CAT, 
SCHEMANAME AS TABLE_SCHEM,  TABLENAME AS TABLE_NAME, (CAST (RTRIM(TABLE_TYPE) 
AS VARCHAR(12))) AS TABLE_TYPE, CAST ('' AS VARCHAR(128)) AS REMARKS FROM 
SYS.SYSTABLES, SYS.SYSSCHEMAS, (VALUES ('T','TABLE'), ('S','SYSTEM TABLE'), 
('V', 'VIEW')) T(TTABBREV,TABLE_TYPE) WHERE (TTABBREV=TABLETYPE 	AND 
(SYS.SYSTABLES.SCHEMAID = SYS.SYSSCHEMAS.SCHEMAID) AND ((1=1) OR ? IS NOT 
NULL) AND (SYS.SYSSCHEMAS.SCHEMANAME LIKE ?) AND (TABLENAME LIKE ?)) AND 
TABLETYPE IN ('T') ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME

Daniel


-- 
Daniel Noll
Nuix Pty Ltd
Suite 79, 89 Jones St, Ultimo NSW 2007, Australia    Ph: +61 2 9280 0699
Web: http://nuix.com/                               Fax: +61 2 9212 6902