| Author |
Message
|
| grammer |
 Posted: Wed Feb 27, 2008 9:58 am Post subject: DatabaseRetrieve Node Help |
 |
|
Novice
Joined: 08 Feb 2008
Posts: 16
Location: Canada
|
It keeps thowing this error, altho i can't seem to find an option for a parser
| Code: |
==========================================
========= Output From DBRetrieve ===================
Time is: 12:54
========ROOT==============================
(
(0x01000000):Properties = (
(0x03000000):MessageSet = ''
(0x03000000):MessageType = ''
(0x03000000):MessageFormat = ''
(0x03000000):Encoding = 546
(0x03000000):CodedCharSetId = 0
(0x03000000):Transactional = TRUE
(0x03000000):Persistence = FALSE
(0x03000000):CreationTime = TIMESTAMP '2008-02-27 12:53:52.767'
(0x03000000):ExpirationTime = -1
(0x03000000):Priority = 0
(0x03000000):ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x03000000):ReplyProtocol = ''
(0x03000000):Topic = NULL
(0x03000000):ContentType = ''
(0x03000000):IdentitySourceType = ''
(0x03000000):IdentitySourceToken = ''
(0x03000000):IdentitySourcePassword = ''
(0x03000000):IdentitySourceIssuedBy = ''
(0x03000000):IdentityMappedType = ''
(0x03000000):IdentityMappedToken = ''
(0x03000000):IdentityMappedPassword = ''
(0x03000000):IdentityMappedIssuedBy = ''
)
)
======== EXCEPTIONS ===================
(
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S610_P\src\DataFlowEngine\ImbDataFlowNode.cpp'
(0x03000000):Line = 739
(0x03000000):Function = 'ImbDataFlowNode::createExceptionList'
(0x03000000):Type = 'ComIbmJniNode'
(0x03000000):Name = 'R_To_RR#FCMComposite_1_8'
(0x03000000):Label = 'R_To_RR.DatabaseRetrieve'
(0x03000000):Catalog = 'BIPv610'
(0x03000000):Severity = 3
(0x03000000):Number = 2230
(0x03000000):Text = 'Node throwing exception'
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S610_P\src\DataFlowEngine\ImbMessageGroup.cpp'
(0x03000000):Line = 173
(0x03000000):Function = 'ImbMessageGroup::createParser'
(0x03000000):Type = 'ComIbmJniNode'
(0x03000000):Name = 'R_To_RR#FCMComposite_1_8'
(0x03000000):Label = 'R_To_RR.DatabaseRetrieve'
(0x03000000):Catalog = 'BIPv610'
(0x03000000):Severity = 3
(0x03000000):Number = 2310
(0x03000000):Text = 'Could not create parser'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'RRUPDATE'
)
)
)
)
|
|
|
| Back to top |
|
 |
| grammer |
| Posted: Fri Feb 29, 2008 11:06 am Post subject: |
|
|
Novice
Joined: 08 Feb 2008
Posts: 16
Location: Canada
|
still neep  with it  |
|
| Back to top |
|
|
| mgk |
| Posted: Fri Feb 29, 2008 12:23 pm Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Can you post a description of your flow, along with any options on those node that youhave changed from the defaults and any relevant ESQL etc...
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| grammer |
| Posted: Fri Feb 29, 2008 1:19 pm Post subject: |
|
|
Novice
Joined: 08 Feb 2008
Posts: 16
Location: Canada
|
Flow:
TimeroutNotification Node -> Database Retrive Node -> (HttpRequestion*)
*not implimented yet.
Settings:
TimeroutNotification Node:
-Unique Identifier: T001
-Transaction Mode: Yes
-Operation Mode: Auto
-Timeout Interval: 300
Database Retive Node:
-Datasource Name: Microsoft_SQL_Server
-multiple rows: checked
-Query Elemnets: I chose the colums i want
on the Dataelement table tab:
- data element: columnDOB : $OutputRoot/RUpdate/dateOfBirth
and the same for the rest of the columns |
|
| Back to top |
|
|
| mgk |
| Posted: Tue Mar 04, 2008 4:41 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
On the Retrieve node you specify:
$OutputRoot/RUpdate/dateOfBirth
And this causes the underlying code to try to create a parser to own all immediate children of OutputRoot. Therefore, you need to specify a parser to own the data returned such as:
$OutputRoot/XMLNSC/RUpdate/dateOfBirth
Regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
|
|
