The error occures only when creating a query based on VIEW:
(CREATE VIEW K_P_VYVOJ AS SELECT ID, KLIENT_ID, PRODUKT, SMLOUV_TYP, ZMENA = 1,
VALUE(DATUM_OD,'1994-01-01') AS DATUM FROM KLIENT_PRODUKT UNION SELECT ID,
KLIENT_ID, PRODUKT, SMLOUV_TYP, ZMENA = -1, DATUM_VRAC AS DATUM FROM
KLIENT_PRODUKT WHERE DATUM_VRAC IS NOT NULL).
SYSKEY not exist probably - I can't create index for this view. What am I doing
wrong?
R. V.
Zabach, Elke wrote:
R. Vajsar wrote
Hello,
We are using the MaxDB version 7.5.00.19. My application works well,
but
when I'm using Microsoft Query to import data from view, the error
occures: Column not found,-4005 POS(32) Unknown column name:SYSKEY.
Has anyone an idea, what can I do?
As I do not know the statements sent to the kernel in this context, as I
do not know the table being part of the statement resulting in that
error and as I do not know if this table does have a user-defined
primary key or not:
You can do a vtrace according to
http://sapdb.2scale.net/moin.cgi/VTrace, but change default in 1.
and 6. to default order .
The search in the resulting file for -4005, look upwards a little bit
(to the corresponding part starting with REQUEST:), inspect the SQL, you
will find there and then check if the table mentioned has a user-defined
primary key (then SYSKEY will NOT exist) or not.
If that will not give the idea what happens, send the table definition
and the statement resulting in the error to the list.
2181 183 185 187 189 191 193 195 197 199
dec: 32 32 32 32 32 32 32 32 2 0 0 0 0196129146248 0 0 0
hex: 20 20 20 20 20 20 20 20 02 00 00 00 00 C4 81 92 F8 00 00 00
chr:
ebc: D a k 8
2201 203 205 207
dec: 55 48 53 48 48 0 0 0
hex: 37 30 35 30 30 00 00 00
chr: 7 0 5 0 0
(129.2899 page 129)
PACKET: ascii, full_swap, 70500-DBM (1 segment, len: 88)
utility SEGMENT 1 (1 part, len: 88)
session_sqlmode, internal_cmd
with_info
command PART (1 argument, size: 36328)
partbuf BUFFER FROM 1 TO 26
pos: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
dec:100105 97103110111115101 32118116114 97 99101 32100101102 97
hex: 64 69 61 67 6E 6F 73 65 20 76 74 72 61 63 65 20 64 65 66 61
chr: d i a g n o s e v t r a c e d e f a
pos: 21 22 23 24 25 26
dec:117108116 32111110
hex: 75 6C 74 20 6F 6E
chr: u l t o n
ebc: % ? >
(129.3046 page 129)
PACKET: ascii, full_swap, 70500-DBM (1 segment, len: 40)
ok / RETURN SEGMENT 1 (0 parts, len: 40)
diagnose_fc, sqlstate: '00000'
(129.3181 page 129)
PACKET: ascii, full_swap, 70500-DBM (1 segment, len: 80)
dbs SEGMENT 1 (1 part, len: 80)
session_sqlmode, user_cmd
command PART (1 argument, size: 36328)
partbuf
pos: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
dec: 67 79 77 77 73 84 32 87 79 82 75 32 82 69 76 69 65 83 69
hex: 43 4F 4D 4D 49 54 20 57 4F 52 4B 20 52 45 4C 45 41 53 45
chr: C O M M I T W O R K R E L E A S E
>KB05 id4182 commit destroy_temp
>b01p_destroy Temp; fileTfnNo = 0; ttfnPars
session: nil; fid = 0
fn: 1A00 0000FFFFFFFF0600 000000000000
b01p_destroy root 89545; ok
>b01p_destroy Temp; fileTfnNo = 0; ttfnInto
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0800 000001000000
b01p_destroy root 104433; ok
[T4 ===== id4183 new TransNo] 129.3500 page 129
KB05 id4183 ok 0.000 sec
KB05 id4183 ok 0.000 sec
>KB05 id4183 release
KB05 id4183 ok 0.000 sec
KB05 id4183 ok 0.000 sec
(129.3604 page 129)
PACKET: ascii, full_swap, 70500-DBM (1 segment, len: 40)
ok / RETURN SEGMENT 1 (0 parts, len: 40)
commit_release, sqlstate: '00000'
===== T16 ===== id4181 ==============================129.3739 page 129
(129.3739 page 129)
PACKET: ascii, full_swap, 70500-ODB (1 segment, len: 128)
parse SEGMENT 1 (1 part, len: 128)
internal, user_cmd
commit_immediately
command PART (1 argument, size: 32232)
partbuf BUFFER FROM 1 TO 67
pos: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
dec: 83 69 76 69 67 84 32 75 95 80 95 86 89 86 79 74 46 73 68 44
hex: 53 45 4C 45 43 54 20 4B 5F 50 5F 56 59 56 4F 4A 2E 49 44 2C
chr: S E L E C T K _ P _ V Y V O J . I D ,
pos: 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
dec: 32 75 95 80 95 86 89 86 79 74 46 83 89 83 75 69 89 13 10 70
hex: 20 4B 5F 50 5F 56 59 56 4F 4A 2E 53 59 53 4B 45 59 0D 0A 46
chr: K _ P _ V Y V O J . S Y S K E Y F
pos: 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
dec: 82 79 77 32 65 80 84 46 75 95 80 95 86 89 86 79 74 32 75 95
hex: 52 4F 4D 20 41 50 54 2E 4B 5F 50 5F 56 59 56 4F 4A 20 4B 5F
chr: R O M A P T . K _ P _ V Y V O J K _
ebc: ( . ¬ ¬ . ¬
pos: 61 62 63 64 65 66 67
dec: 80 95 86 89 86 79 74
hex: 50 5F 56 59 56 4F 4A
chr: P _ V Y V O J
>b07cget key(138):
00000000 00000000 00B54B5F 505F5659 564F4A20 20202020 20202020
20202020 20202020 20202020 20202020 20202020 20202020 20202020
20202020
'..........K_P_VYVOJ '
b07cget root 215; *** key_not_found ***
>KB05 id4181/13568 get direct SYS1CAT key(12):
00000000 000008D3 00080001
>b02get key(12): 00000000 000008D3 00080001
b02get root 44664; ok
KB05 id4181/13568 return_result 0.000 sec
KB05 id4181/13568 return_result 0.000 sec
>b01t_create Temp; fileTfnNo = 0; ttfnComplexView
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0200 000001000000
b01t_create root 217; ok
>b07cadd key(8): 00000000 000008D3
b07cadd root 217; ok
>b07cadd key(4): 01000000
b07cadd root 217; ok
>b07cdel key(12): FF00002D 013C0020 00B20000
b07cdel root 215; *** key_not_found ***
>b07cdel key(12): FF00002D 013C0020 00C10000
b07cdel root 215; *** key_not_found ***
>KB05 id4181 destroy_temp prefix
>b01p_destroy Temp; fileTfnNo = 0; ttfnComplexView
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0200 000001000000
b01p_destroy root 217; ok
KB05 id4181 return_result 0.000 sec
KB05 id4181 return_result 0.000 sec
>b07cnext key(4): FF00002D
b07cnext root 215; *** no_next_record ***
>b07cget key(138):
00000000 00000000 00B54B5F 505F5659 564F4A20 20202020 20202020
20202020 20202020 20202020 20202020 20202020 20202020 20202020
20202020
'..........K_P_VYVOJ '
b07cget root 215; *** key_not_found ***
>KB05 id4181/13824 get direct SYS2CAT key(21):
FFFF0000 0000000E 00410001 4B5F505F 5659564F 4A
'.........A..K_P_VYVOJ'
>b02get key(21): FFFF0000 0000000E 00410001 4B5F505F 5659564F 4A
'.........A..K_P_VYVOJ'
b02get root 59552; ok
KB05 id4181/13824 return_result 0.000 sec
KB05 id4181/13824 return_result 0.000 sec
>KB05 id4181/13824 get direct SYS1CAT key(12):
00000000 000008D3 00010001
>b02get key(12): 00000000 000008D3 00010001
b02get root 44664; ok
KB05 id4181/13824 return_result 0.000 sec
KB05 id4181/13824 return_result 0.000 sec
>KB05 id4181/13824 get direct SYS1CAT key(20):
00000000 000008D3 00060001 FFFF0000 0000000E
>b02get key(20): 00000000 000008D3 00060001 FFFF0000 0000000E
b02get root 44664; ok
KB05 id4181/13824 return_result 0.000 sec
KB05 id4181/13824 return_result 0.000 sec
>KB05 id4181/13824 get direct SYS1CAT key(12):
00000000 000008D3 00080001
>b02get key(12): 00000000 000008D3 00080001
b02get root 44664; ok
KB05 id4181/13824 return_result 0.000 sec
KB05 id4181/13824 return_result 0.000 sec
>b01t_create Temp; fileTfnNo = 0; ttfnComplexView
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0200 000001000000
b01t_create root 15106; ok
>b07cadd key(8): 00000000 000008D3
b07cadd root 15106; ok
>b07cadd key(4): 01000000
b07cadd root 15106; ok
>b07cdel key(12): FF00002E 013C0020 00B20000
b07cdel root 215; *** key_not_found ***
>b07cdel key(12): FF00002E 013C0020 00C10000
b07cdel root 215; *** key_not_found ***
>KB05 id4181 destroy_temp prefix
>b01p_destroy Temp; fileTfnNo = 0; ttfnComplexView
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0200 000001000000
b01p_destroy root 15106; ok
KB05 id4181 return_result 0.000 sec
KB05 id4181 return_result 0.000 sec
>b07cnext key(4): FF00002E
b07cnext root 215; *** no_next_record ***
>b07cadd key(12): FF000029 013C0020 00810000
b07cadd root 215; ok
>b07cadd key(12): FF000029 013C0020 00C10000
b07cadd root 215; ok
>b07cadd key(13): FF000029 013C0020 00C10000 01
b07cadd root 215; ok
>b07cadd key(12): FF000029 013C0020 00B20000
b07cadd root 215; ok
>b07cadd key(12): FF000029 013C0020 00B10001
b07cadd root 215; ok
>b07cadd key(12): FF00002B 012A0020 00810000
b07cadd root 215; ok
>b07cadd key(12): FF00002C 01060020 00810000
b07cadd root 215; ok
>KB05 id4181 rollback
[T16 ===== id4184 new TransNo] 130.3943 page 130
KB05 id4184 ok 0.000 sec
KB05 id4184 ok 0.000 sec
(130.3979 page 130)
PACKET: ascii, full_swap, 70500-ODB (1 segment, len: 88)
*** -4005 / RETURN SEGMENT 1 (1 part, len: 88)
select_fc, errpos: 32, sqlstate: '42000'
errortext PART (1 argument, size: 36168)
partbuf BUFFER FROM 1 TO 26
pos: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
dec: 85110107110111119110 32 99111108117109110 32110 97109101 58
hex: 55 6E 6B 6E 6F 77 6E 20 63 6F 6C 75 6D 6E 20 6E 61 6D 65 3A
chr: U n k n o w n c o l u m n n a m e :
ebc: > , > ? > ? % _ > > _
pos: 21 22 23 24 25 26
dec: 83 89 83 75 69 89
hex: 53 59 53 4B 45 59
chr: S Y S K E Y
(130.4162 page 130)
PACKET: ascii, full_swap, 70500-ODB (1 segment, len: 128)
parse SEGMENT 1 (1 part, len: 128)
internal, user_cmd
commit_immediately
command PART (1 argument, size: 32232)
partbuf BUFFER FROM 1 TO 67
pos: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
dec: 83 69 76 69 67 84 32 75 95 80 95 86 89 86 79 74 46 73 68 44
hex: 53 45 4C 45 43 54 20 4B 5F 50 5F 56 59 56 4F 4A 2E 49 44 2C
chr: S E L E C T K _ P _ V Y V O J . I D ,
pos: 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
dec: 32 75 95 80 95 86 89 86 79 74 46 83 89 83 75 69 89 13 10 70
hex: 20 4B 5F 50 5F 56 59 56 4F 4A 2E 53 59 53 4B 45 59 0D 0A 46
chr: K _ P _ V Y V O J . S Y S K E Y F
pos: 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
dec: 82 79 77 32 65 80 84 46 75 95 80 95 86 89 86 79 74 32 75 95
hex: 52 4F 4D 20 41 50 54 2E 4B 5F 50 5F 56 59 56 4F 4A 20 4B 5F
chr: R O M A P T . K _ P _ V Y V O J K _
ebc: ( . ¬ ¬ . ¬
pos: 61 62 63 64 65 66 67
dec: 80 95 86 89 86 79 74
hex: 50 5F 56 59 56 4F 4A
chr: P _ V Y V O J
>b07cget key(138):
00000000 00000000 00B54B5F 505F5659 564F4A20 20202020 20202020
20202020 20202020 20202020 20202020 20202020 20202020 20202020
20202020
'..........K_P_VYVOJ '
b07cget root 215; *** key_not_found ***
>KB05 id4184/14080 get direct SYS2CAT key(21):
FFFF0000 0000000E 00410001 4B5F505F 5659564F 4A
'.........A..K_P_VYVOJ'
>b02get key(21): FFFF0000 0000000E 00410001 4B5F505F 5659564F 4A
'.........A..K_P_VYVOJ'
b02get root 59552; ok
KB05 id4184/14080 return_result 0.000 sec
KB05 id4184/14080 return_result 0.000 sec
>KB05 id4184/14080 get direct SYS1CAT key(12):
00000000 000008D3 00010001
>b02get key(12): 00000000 000008D3 00010001
b02get root 44664; ok
KB05 id4184/14080 return_result 0.000 sec
KB05 id4184/14080 return_result 0.000 sec
>KB05 id4184/14080 get direct SYS1CAT key(20):
00000000 000008D3 00060001 FFFF0000 0000000E
>b02get key(20): 00000000 000008D3 00060001 FFFF0000 0000000E
b02get root 44664; ok
KB05 id4184/14080 return_result 0.000 sec
KB05 id4184/14080 return_result 0.000 sec
>KB05 id4184/14080 get direct SYS1CAT key(12):
00000000 000008D3 00080001
>b02get key(12): 00000000 000008D3 00080001
b02get root 44664; ok
KB05 id4184/14080 return_result 0.000 sec
KB05 id4184/14080 return_result 0.000 sec
>b01t_create Temp; fileTfnNo = 0; ttfnComplexView
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0200 000001000000
b01t_create root 29994; ok
>b07cadd key(8): 00000000 000008D3
b07cadd root 29994; ok
>b07cadd key(4): 01000000
b07cadd root 29994; ok
>b07cdel key(12): FF00002F 013C0020 00B20000
b07cdel root 215; *** key_not_found ***
>b07cdel key(12): FF00002F 013C0020 00C10000
b07cdel root 215; *** key_not_found ***
>KB05 id4184 destroy_temp prefix
>b01p_destroy Temp; fileTfnNo = 0; ttfnComplexView
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0200 000001000000
b01p_destroy root 29994; ok
KB05 id4184 return_result 0.000 sec
KB05 id4184 return_result 0.000 sec
>b07cnext key(4): FF00002F
b07cnext root 215; *** no_next_record ***
>b07cget key(138):
00000000 00000000 00B54B5F 505F5659 564F4A20 20202020 20202020
20202020 20202020 20202020 20202020 20202020 20202020 20202020
20202020
'..........K_P_VYVOJ '
b07cget root 215; *** key_not_found ***
>KB05 id4184/14336 get direct SYS2CAT key(21):
FFFF0000 0000000E 00410001 4B5F505F 5659564F 4A
'.........A..K_P_VYVOJ'
>b02get key(21): FFFF0000 0000000E 00410001 4B5F505F 5659564F 4A
'.........A..K_P_VYVOJ'
b02get root 59552; ok
KB05 id4184/14336 return_result 0.000 sec
KB05 id4184/14336 return_result 0.000 sec
>KB05 id4184/14336 get direct SYS1CAT key(12):
00000000 000008D3 00010001
>b02get key(12): 00000000 000008D3 00010001
b02get root 44664; ok
KB05 id4184/14336 return_result 0.000 sec
KB05 id4184/14336 return_result 0.000 sec
>KB05 id4184/14336 get direct SYS1CAT key(20):
00000000 000008D3 00060001 FFFF0000 0000000E
>b02get key(20): 00000000 000008D3 00060001 FFFF0000 0000000E
b02get root 44664; ok
KB05 id4184/14336 return_result 0.000 sec
KB05 id4184/14336 return_result 0.000 sec
>KB05 id4184/14336 get direct SYS1CAT key(12):
00000000 000008D3 00080001
>b02get key(12): 00000000 000008D3 00080001
b02get root 44664; ok
KB05 id4184/14336 return_result 0.000 sec
KB05 id4184/14336 return_result 0.000 sec
>b01t_create Temp; fileTfnNo = 0; ttfnComplexView
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0200 000001000000
b01t_create root 44882; ok
>b07cadd key(8): 00000000 000008D3
b07cadd root 44882; ok
>b07cadd key(4): 01000000
b07cadd root 44882; ok
>b07cdel key(12): FF000030 013C0020 00B20000
b07cdel root 215; *** key_not_found ***
>b07cdel key(12): FF000030 013C0020 00C10000
b07cdel root 215; *** key_not_found ***
>KB05 id4184 destroy_temp prefix
>b01p_destroy Temp; fileTfnNo = 0; ttfnComplexView
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0200 000001000000
b01p_destroy root 44882; ok
KB05 id4184 return_result 0.000 sec
KB05 id4184 return_result 0.000 sec
>b07cnext key(4): FF000030
b07cnext root 215; *** no_next_record ***
>KB05 id4184 rollback
[T16 ===== id4185 new TransNo] 131.6522 page 131
KB05 id4185 ok 0.000 sec
KB05 id4185 ok 0.000 sec
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
