Hello
This statement
alter table artikel add a char(1)
as well as other 'usual' alter table statements produce the following
error message (not with all tables but with several):
-5015 Pos(241) Missing keyword:FROM
It seems that something within the catalog is wrong and causes this
error. The checks all passed correctly.
Has anyone an idea what exactly could cause that.
(We use SAPDB 7.3.0, Build 030-000-088-166)
Vtrace:
... ...
b02get root 4; e_ok
>b02repl key(12): 00000000 00005EBB 00220001
b02repl root 4; e_ok
>b02get key(12): 00000000 00005EBB 00210001
b02get root 4; e_ok
>b02repl key(12): 00000000 00005EBB 00210001
b02repl root 4; e_ok
>b02repl key(12): 00000000 00005EBB 000A0001
b02repl root 4; e_ok
>b02get key(12): 00000000 00005EAB 00010001
b02get root 4; e_ok
>b02repl key(12): 00000000 00005EAB 00010001
b02repl root 4; e_ok
>b02get key(20): 00000000 00005EAB 00060001 FFFF0000 0000000D
b02get root 4; e_ok
>b02repl key(20): 00000000 00005EAB 00060001 FFFF0000 0000000D
b02repl root 4; e_ok
>b02repl key(28):
00000000 00005EAB 00070001 FFFF0000 0000000D FFFF0000 0000000D
b02repl root 4; e_ok
>b02get key(12): 00000000 00005EAB 000A0001
b02get root 4; e_ok
>b02repl key(12): 00000000 00005EAB 000A0001
b02repl root 4; e_ok
>b02repl key(12): 00000000 00004609 00010001
b02repl root 4; e_ok
>b02del key(12): 00000000 00004609 00170020
b02del root 4; e_ok
KB05 id11713168/1 e_ok
>b07cnext zerokey
b07cnext root 15004; *** key_not_found ***
>b07cdel key(12): FF00003E 01460020 00870000
b07cdel root 2890; *** key_not_found ***
>b07cdel key(12): FF00003E 02460020 00870000
b07cdel root 2890; *** key_not_found ***
>b07cdel key(12): FF00003E 03460020 00870000
b07cdel root 2890; *** key_not_found ***
>KB05 id11713168 rollback
===== log_writer.id0 ==================================26.2222 page 27
*b15write log log --------> 163754; pno log 1: 17211
===== T36 ===== id11713176 ============================26.2260 page 27
KB05 id11713176 e_ok
>KB05 id11713176 select_row direct TABID 0-97 key(9):
003C4985 0020454E 47 '.<I.. ENG'
>b02direct_ql key(9): 003C4985 0020454E 47 '.<I.. ENG'
b02direct_ql root 13; e_ok
KB05 id11713176 return_result
RECEIVE: ascii, full_swap, 70300-ODB (1 segment, len: 96)
(26.2483 page 27)
*** -5015 / RETURN SEGMENT 1 (1 part, len: 96)
alter_table_fc, errpos: 241, sqlstate: '42000'
errortext PART (1 argument, size: 36520)
buf(34): 'Missing keyword:FROM '
===== timeout.id0 =====================================26.2659 page 27
>KB51 inspect locklist
KB51 inspect locklist e_ok
===== T37 ===== nil.id0 ===============================26.2715 page 27
REQUEST: ascii, full_swap, 70300-DBM (1 segment, len: 152)
(26.2715 page 27)
dbs SEGMENT 1 (2 parts, len: 152)
session_sqlmode, internal_cmd
command PART (1 argument, size: 32552)
buf(31): 'CONNECT "DBM" IDENTIFIED by :PW'
data PART (1 argument, size: 32504)
buf(44):
00C791FA C53AF78E 420D499F 9BD8FE2D 4DC692E3 40369BDC 30002E63
6F6D2020 20202020 20202020 20202020
'.....:[EMAIL PROTECTED] '
[T37 ===== id11713177 new TransNo] 26.2971 page
27
>b01t_create tfnTemp; fileTfnNo = 0; ttfnPars
session: 27810; fid = 0
fn: 1A00 000000006CA20600 000000000000
b01t_create root 28698; e_ok
>b01t_create tfnTemp; fileTfnNo = 0; ttfnInto
session: 27810; fid = 1
fn: 1A00 000000006CA20800 000001000000
b01t_create root 28772; e_ok
>KB05 id11713177 select_row direct TABID 0-97 key(9):
00C31000 0020454E 47 '..... ENG'
>b02direct_ql key(9): 00C31000 0020454E 47 '..... ENG'
b02direct_ql root 13; e_ok
KB05 id11713177 return_result
>KB05 id11713177 connect
KB05 id11713177 e_ok
RECEIVE: ascii, full_swap, 70300-DBM (1 segment, len: 3344)
(26.3370 page 27)
ok / RETURN SEGMENT 1 (3 parts, len: 3344)
connect_fc, sqlstate: '00000'
user_info_returned PART (1 argument, size: 36464)
buf(18):
03444241 03444241 08535441 4E444152 4400 '.DBA.DBA.STANDARD.'
conv_tables_return PART (4 arguments, size: 36424)
buf(1024):
00010203 04050607 08090A0B 0C0D0E0F 10111213 14151617 18191A1B
1C1D1E1F 20212223 24252627 28292A2B 2C2D2E2F 30313233 34353637
38393A3B 3C3D3E3F 40616263 64656667 68696A6B 6C6D6E6F 70717273
74757677 78797A5B 5C5D5E5F 60616263 64656667 68696A6B 6C6D6E6F
70717273
'................................ !"#$%&'()*+,-./0123456789:;<'
'=>?@abcdefghijklmnopqrstuvwxyz[\]^_`abcdefghijklmnopqrs'
sessioninfo_return PART (1 argument, size: 35384)
buf(2208):
0000006C A2094444 2D4D4F4E 2D595920 20202020 20202020 20202020
20202020 20202020 20202020 20202020 20202020 20202020 20202020
20202020 20202020 20202020 20202020 20202020 20202020 20202020
20202020 20202020 20202020 20202020 20202020 20200C10 0E05042D
1505042D
'...l..DD-MON-YY '
' .....-...-'
REQUEST: ascii, full_swap, 70300-DBM (1 segment, len: 64)
(26.3842 page 27)
dbs SEGMENT 1 (1 part, len: 64)
session_sqlmode, user_cmd
with_info
command PART (1 argument, size: 32552)
buf(7): 'vtrace '
Thanks for any comment on that.
G. Matter
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
