Author |
Message
|
RaviKrG |
Posted: Thu Sep 11, 2008 10:48 pm Post subject: Database Error in WMB V6.0 |
|
|
 Master
Joined: 07 Sep 2008 Posts: 240
|
Can somebody help me out in this
I am using on simple flow as MQ InputN --> DatabaseN --> MQ OutputN
but when I put the message I get the following error as
( RAVIBK.Database ) Database error: SQL State ''IM002''; Native Error Code '0'; Error Text ''[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified''.
The error has the following diagnostic information: SQL State ''IM002'' SQL Native Error Code '0' SQL Error Text ''[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified''
This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error.
But I have kept thr Database source property
Can some body tell what I have forgotten to add.
Thanks |
|
Back to top |
|
 |
AkankshA |
Posted: Thu Sep 11, 2008 11:02 pm Post subject: |
|
|
 Grand Master
Joined: 12 Jan 2006 Posts: 1494 Location: Singapore
|
ODBC Driver Manager] Data source name not found and no default driver specified''
you have not created DSN ... _________________ Cheers |
|
Back to top |
|
 |
RaviKrG |
Posted: Thu Sep 11, 2008 11:20 pm Post subject: |
|
|
 Master
Joined: 07 Sep 2008 Posts: 240
|
Ya you are right , but after creating the DSN still I get an error but a different one
Database error: SQL State ''23502''; Native Error Code '-407'; Error Text ''[IBM][CLI Driver][DB2/NT] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=2, TABLEID=2, COLNO=0" is not allowed. SQLSTATE=23502 ''.
The error has the following diagnostic information: SQL State ''23502'' SQL Native Error Code '-407' SQL Error Text ''[IBM][CLI Driver][DB2/NT] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=2, TABLEID=2, COLNO=0" is not allowed. SQLSTATE=23502 '
As this says that I am assigning a NULL value to a NOT NULL column but which I am not able to undestand |
|
Back to top |
|
 |
AkankshA |
Posted: Thu Sep 11, 2008 11:35 pm Post subject: |
|
|
 Grand Master
Joined: 12 Jan 2006 Posts: 1494 Location: Singapore
|
RaviKrG wrote: |
Ya you are right , but after creating the DSN still I get an error but a different one
Database error: SQL State ''23502''; Native Error Code '-407'; Error Text ''[IBM][CLI Driver][DB2/NT] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=2, TABLEID=2, COLNO=0" is not allowed. SQLSTATE=23502 ''.
The error has the following diagnostic information: SQL State ''23502'' SQL Native Error Code '-407' SQL Error Text ''[IBM][CLI Driver][DB2/NT] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=2, TABLEID=2, COLNO=0" is not allowed. SQLSTATE=23502 '
As this says that I am assigning a NULL value to a NOT NULL column but which I am not able to undestand |
check you insert statement for that _________________ Cheers |
|
Back to top |
|
 |
RaviKrG |
Posted: Thu Sep 11, 2008 11:54 pm Post subject: |
|
|
 Master
Joined: 07 Sep 2008 Posts: 240
|
Well I think I did not find any error with this (I may be wrong)
INSERT INTO Database.EMP(EMPID, FIRSTNAME, LASTNAME, BU, DESIGNATION)
VALUES(Body.Staff.StaffNumber, Body.Staff.NameInfo.FirstName,
Body.Staff.NameInfo.LastName, Body.Staff.BUNumber,
Body.Staff.EmpDesig);
But when I changed the NULLABLE field of the table to YES the message passed to the MQOutput Node without updating the Database. |
|
Back to top |
|
 |
AkankshA |
Posted: Fri Sep 12, 2008 12:06 am Post subject: |
|
|
 Grand Master
Joined: 12 Jan 2006 Posts: 1494 Location: Singapore
|
on your compute node.. have you checked "throw error on databse warking button ??
Is EMp a temporary table ? _________________ Cheers |
|
Back to top |
|
 |
RaviKrG |
Posted: Fri Sep 12, 2008 12:35 am Post subject: |
|
|
 Master
Joined: 07 Sep 2008 Posts: 240
|
I have checked(corrected) the tab on Database Node as
Throw Exception on Database Error
Also, When I pass the message, the message goes to the output queue and the database tells the numbers of rows when I do select * from tablename but I find the field with no value in the database. |
|
Back to top |
|
 |
RaviKrG |
Posted: Fri Sep 12, 2008 12:39 am Post subject: |
|
|
 Master
Joined: 07 Sep 2008 Posts: 240
|
Also EMP is a not a temperory table |
|
Back to top |
|
 |
RaviKrG |
Posted: Fri Sep 12, 2008 1:41 am Post subject: |
|
|
 Master
Joined: 07 Sep 2008 Posts: 240
|
Heloo there, Thanks for your help. Now this problem is resolved. |
|
Back to top |
|
 |
Raj2000 |
Posted: Tue Sep 22, 2009 12:01 pm Post subject: |
|
|
 Apprentice
Joined: 03 Aug 2009 Posts: 47
|
Hello RaviKRG can i know how did you solve this issue???Becoz i am in the same situation.
Actually i am using the Datainsert Node and using the mapping to insert the values from the source i get the above error:
SQL State ''23502'' SQL Native Error Code '-407' SQL Error Text ''[IBM][CLI Driver][DB2/NT] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=2, TABLEID=2, COLNO=0" is not allowed. SQLSTATE=23502 '
where i am assigned the values by selecting the value from source. |
|
Back to top |
|
 |
RaviKrG |
Posted: Tue Sep 22, 2009 6:04 pm Post subject: |
|
|
 Master
Joined: 07 Sep 2008 Posts: 240
|
Raj,
I did not use the mapping node, instead used the compute node to insert the values in the table. Also I made sure that the fields of the database tables can have null values, also I made the database definition file. |
|
Back to top |
|
 |
|