| Author |
Message
|
| tonythomasantony |
 Posted: Tue Jul 01, 2008 8:34 am Post subject: DataInsert Node-Error Number is 2465 |
 |
|
Apprentice
Joined: 12 Aug 2006
Posts: 47
|
Hi ,
i wanted to insert a record into a DB2 Table using DatabaseInsert Node.
I successfully configured and created messagemap.
But after pushing the message i am getting the below error
( ['MQROOT' : 0x7931c20]
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S610_P\src\DataFlowEngine\ImbDataFlowNode.cpp' (CHARACTER)
(0x03000000):Line = 739 (INTEGER)
(0x03000000):Function = 'ImbDataFlowNode::createExceptionList' (CHARACTER)
(0x03000000):Type = 'ComIbmDatabaseNode' (CHARACTER)
(0x03000000):Name = 'gg#FCMComposite_1_42.ComIbmDataInsert#FCMComposite_1_1' (CHARACTER)
(0x03000000):Label = 'gg.INSERT NEW RECORD INTO XREF TABLE.ComIbmDatabase' (CHARACTER)
(0x03000000):Catalog = 'BIPv610' (CHARACTER)
(0x03000000):Severity = 3 (INTEGER)
(0x03000000):Number = 2230 (INTEGER)
(0x03000000):Text = 'Node throwing exception' (CHARACTER)
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S610_P\src\DataFlowEngine\ImbRdl\ImbRdlValueOperations.cpp' (CHARACTER)
(0x03000000):Line = 3775 (INTEGER)
(0x03000000):Function = 'SqlExpressionUtility::cast' (CHARACTER)
(0x03000000):Type = 'ComIbmDatabaseNode' (CHARACTER)
(0x03000000):Name = 'gg#FCMComposite_1_42.ComIbmDataInsert#FCMComposite_1_1' (CHARACTER)
(0x03000000):Label = 'gg.INSERT NEW RECORD INTO XREF TABLE.ComIbmDatabase' (CHARACTER)
(0x03000000):Catalog = 'BIPv610' (CHARACTER)
(0x03000000):Severity = 3 (INTEGER)
(0x03000000):Number = 2465 (INTEGER)
(0x03000000):Text = 'Cannot cast the value '%1' to type type '%2'. The types are incompatible' (CHARACTER)
(0x01000000):Insert = (
(0x03000000):Type = 5 (INTEGER)
(0x03000000):Text = '1960' (CHARACTER)
)
(0x01000000):Insert = (
(0x03000000):Type = 5 (INTEGER)
(0x03000000):Text = 'DATE' (CHARACTER)
)
)
)
)
In the table,some fields are notnullable and some are nullable.I have mapped all notnullable columns of the table.
And also i have tried with Adding and removing Properties and MQMD folders.
My mapping lookslike
Message DataBaseTable
---------- ---------------
Cross
item1-------------------it1
item2-------------------it2
item3
item4(complexItem)
item4i----------------it3
item4o
regards,
Tony Thomas |
|
| Back to top |
|
 |
| Bill.Matthews |
| Posted: Tue Jul 01, 2008 5:19 pm Post subject: |
|
|
Master
Joined: 23 Sep 2003
Posts: 232
Location: IBM (Retired)
|
Go back and look at the data types of the columns in the database. I suspect that you will find one that is defined as a DATE and the data that you are mapping to that field is not a date.
The error information that you have posted - would be much clearer if it had been taken from the syslog (or event viewer) - where it would show if you didn't wire the Failure or Catch terminals. It would have looked something like this:
| Code: |
| 'BIPv610 Cannot cast the value '1960' to type 'DATE'. The types are incompatible' |
_________________
Bill Matthews |
|
| Back to top |
|
|
| tonythomasantony |
| Posted: Tue Jul 01, 2008 8:27 pm Post subject: |
|
|
Apprentice
Joined: 12 Aug 2006
Posts: 47
|
Bill,
i checked and confirmed that my mapping doesnt contain any mapping to a column in table whose datatype is DATE or DATETIME.
Moreover i cant identify how this value 1960 is coming as an error.In my entire message flow there is no value with 1960.My flow looks like this
MqInput>Trace>MqOutput>DataInsert>Trace
In MQInput i am validating the message with messageset then outputting the message to a queue.After that i need to insert the Values.
regards,
Tony |
|
| Back to top |
|
|
| AkankshA |
| Posted: Tue Jul 01, 2008 8:39 pm Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
did u match each column type and the data supplied type...
u r validating it against a msg set.... there are chances of having a type mismatch with database fields...
in ur error msg i can see mismatch message with INTEGER and CHARACTER data types... etc etc
if u still face the error then probably u can try doing it in compute node... i can do all this very well 
_________________
Cheers |
|
| Back to top |
|
|
| tonythomasantony |
| Posted: Tue Jul 01, 2008 8:47 pm Post subject: |
|
|
Apprentice
Joined: 12 Aug 2006
Posts: 47
|
i wanted to use onlyDatainsert node bcz of some design issue.v6.1 traces having this structure contains the datatypes of every field generated for the trace.
I am 100% sure that my message not conatins any filed having datatype DATETIME and also i am not mapping to the tables columns...
regards,
Tony |
|
| Back to top |
|
|
|
|
