Load involving XML column might fail because of invalid QName
with following error:
SQL3306N An SQL error "-16275" occurred while inserting a row
into the table.
SQL16275N A name starting with "<name:>" is not a valid QName.
It was
intended as a QName for "element". SQLSTATE=2200M
Following errors would be logged in db2diag:
Information
2013-01-01-01.00.01.022010-240 I54850A672 LEVEL: Error
PID : 43647000 TID : 8572 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-47 APPID:
*LOCAL.db2inst1.130326092010
AUTHID : db2inst1
EDUID : 8572 EDUNAME: db2lfrm0
FUNCTION: DB2 UDB, database utilities, sqluCFormatter::iCleanUp,
probe:1775
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
"SQLCA has already been built"
DATA #1 : LOADID, PD_TYPE_LOADID, 47 bytes
LOADID: 1801.2013-03-26-05.20.31.727874.0 (3;5)
DATA #2 : File name, 10 bytes
sqluldat.C
DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes
0x8015006D
2013-01-01-01.00.01.023464-240 I55523A624 LEVEL: Error
PID : 43647000 TID : 8829 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-47 APPID:
*LOCAL.db2inst1.130326092010
AUTHID : db2inst1
EDUID : 8829 EDUNAME: db2lfrm1
FUNCTION: DB2 UDB, database utilities, sqluLoadEDUDriver,
probe:2698
MESSAGE : ZRC=0x82150056=-2112552874=SQLU_TERM_DIE_NOW
"Load EDU termination requested"
DATA #1 : LOADID, PD_TYPE_LOADID, 47 bytes
LOADID: 1801.2013-03-26-05.20.31.727874.0 (3;5)
DATA #2 : File name, 10 bytes
sqluedus.C
[...]
2013-01-01-01.00.01.130603-240 I60846A551 LEVEL: Error
PID : 43647000 TID : 1801 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-47 APPID:
*LOCAL.db2inst1.130326092010
AUTHID : db2inst1
EDUID : 1801 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 129 bytes
LOADID: 1801.2013-03-26-05.20.31.727874.0 (3;5)
Error loading partition. , -2146107283, 0, Detected in
file:sqluvtld.C, Line:4106
2013-01-01-01.00.01.131100-240 I61398A451 LEVEL: Severe
PID : 43647000 TID : 1801 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-47 APPID:
*LOCAL.db2inst1.130326092010
AUTHID : db2inst1
EDUID : 1801 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, database utilities, sqluLoadPartition,
probe:4101
MESSAGE : Load Error: Error loading partition.
2013-01-01-01.00.01.131630-240 I61850A551 LEVEL: Error
PID : 43647000 TID : 1801 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-47 APPID:
*LOCAL.db2inst1.130326092010
AUTHID : db2inst1
EDUID : 1801 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 129 bytes
LOADID: 1801.2013-03-26-05.20.31.727874.0 (3;5)
Error loading partition. , -2146107283, 0, Detected in
file:sqluvtld.C, Line:1146 |
