DB not loading

Community Support
1

I’ve been struggling with this error for a while. My database is C:/kdb/DB2 and I store segments in C:/kdb/DBp. 

$ find C:/kdb/DB2

DB2/

DB2/par.txt

DB2/sym

$ find C:/kdb/DBp

DBp

DBp/a_j

DBp/a_j/2006.10.03

DBp/a_j/2006.10.03/.d

DBp/a_j/2006.10.03/close

DBp/k_z

DBp/k_z/2006.10.03

DBp/k_z/2006.10.03/.d

DBp/k_z/2006.10.03/close

but when I try to load the DB2, I get this error. Can someone please explain to me what this means?

$ q DB2

KDB+ 3.0 2012.09.06 Copyright (C) 1993-2012 Kx Systems

w32/ 4()core 4095MB Home Home-pc 192.168.2.3 PLAY 2012.12.05

k){.[y;();:;+(x . y,`.d)!y]}

'C:/kdb/DBp/k_z/2006.10.04/.d/.d: The system cannot find the path specified.

.

`:C:/kdb/DBp/k_z/2006.10.04

.d.d

2

You seem to somehow have a .d file in a date partition. 

.d files should only be in the splayed table directories to determine the column order.

Did you move this manually?

3

Yes it was a big mess. I was able to sort this out. I still have some problem with segmented tables. I am still investigating it.