|
Problem IT01992
|
Status: Closed |
XML WRAPPER SQL0901N "MEMORY ALLOCATION ERROR" DUE TO EMPTY STRING NAMESPACE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When using xml wrapper, and creating nickname with NAMESPACE
option assigned with empty string, querying the nickname could
result in -901 error:
CREATE NICKNAME "RU291375"."INVOKEDECISIONCOORDINATOR_NN2" (
"DOCUMENT" VARCHAR(48) OPTIONS (DOCUMENT 'FILE'),
"PARTYNAME_FULLNAME" VARCHAR(48) OPTIONS (XPATH
'./servicePreferences/schemaReleaseId')) FOR SERVER
"XML_SERVER1" OPTIONS( NAMESPACES 'ns=""', STREAMING 'YES',
XPATH '//ns:invokeDecisionCoordinator' )
SELECT * FROM RU291375.INVOKEDECISIONCOORDINATOR_NN WHERE
document ='/home/iidev16/xml/GRDRequest.xml'
DOCUMENT
PARTYNAME_FULLNAME
------------------------------------------------
------------------------------------------------
SQL0901N The SQL statement failed because of a non-severe
system error.
Subsequent SQL statements can be processed. (Reason "Memory
allocation error".) SQLSTATE=58004Symptoms: |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to v97fp10 *
**************************************************************** |
| Local Fix: |
|
| Solution |
v97fp10 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.05.2014
10.11.2014
10.11.2014 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
