| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Database Node Error: [IBM][CLI Driver] CLI0112E |
« View previous topic :: View next topic » |
| Author |
Message
|
| ovasquez |
 Posted: Thu Sep 04, 2008 3:36 pm Post subject: Database Node Error: [IBM][CLI Driver] CLI0112E |
 |
|
Centurion
Joined: 09 Dec 2005
Posts: 141
Location: Lima, Peru
|
What is the problem its flow:
MQInput->Database->Trace
MQInput
*********
Queue:Q.REQUEST
MessageDomain:XML
Database
*********
Data Source: DB1
Stament: FlujoTest_Database
ESQL
*************
CREATE DATABASE MODULE FlujoTest_Database
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
--Only for TESTING.....
INSERT INTO Database.TBL(COD,NAME,VALUE) VALUES ('C000001','zzzzzz','1111');
RETURN TRUE;
END;
END MODULE;
TABLE
*****************
CREATE TABLE TBL
(COD VARCHAR(7),NAME VARCHAR(30),VALUE VARCHAR(15));
S.O: Windows XP SP2
WMB 6.0
DB:
******************
Derby, part of WMB, install default
ERROR:
***********
[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005
ERROR Full:
*******************************
ExceptionList = [(
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S600_P\src\DataFlowEngine\ImbDataFlowNode.cpp'
(0x03000000):Line = 616
(0x03000000):Function = 'ImbDataFlowNode::createExceptionList'
(0x03000000):Type = 'ComIbmDatabaseNode'
(0x03000000):Name = 'FlujoTest#FCMComposite_1_5'
(0x03000000):Label = 'FlujoTest.Database'
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2230
(0x03000000):Text = 'Node throwing exception'
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S600_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp'
(0x03000000):Line = 573
(0x03000000):Function = 'SqlStatementGroup::execute'
(0x03000000):Type = 'ComIbmDatabaseNode'
(0x03000000):Name = 'FlujoTest#FCMComposite_1_5'
(0x03000000):Label = 'FlujoTest.Database'
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2488
(0x03000000):Text = 'Error detected, rethrowing'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '.FlujoTest_Database.Main'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '3.3'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'INSERT INTO Database.TBL(COD,NAME,VALUE) VALUES ('C000001','zzzzzz','1111') '
)
(0x01000000):DatabaseException = (
(0x03000000):File = 'F:\build\S600_P\src\DataFlowEngine\ImbOdbc.cpp'
(0x03000000):Line = 227
(0x03000000):Function = 'ImbOdbcHandle::checkRcInner'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2321
(0x03000000):Text = 'Root SQL exception'
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '-1'
)
(0x01000000):DatabaseException = (
(0x03000000):File = 'F:\build\S600_P\src\DataFlowEngine\ImbOdbc.cpp'
(0x03000000):Line = 355
(0x03000000):Function = 'ImbOdbcHandle::checkRcInner'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2322
(0x03000000):Text = 'Child SQL exception'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '22005'
)
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '-99999'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005'
)
)
)
)
)
)]
########################################
_________________
Oscar Vásquez Flores |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Thu Sep 04, 2008 9:16 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
sounds like binding problem between the variable and datatype..
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| sandeep9678 |
| Posted: Thu Sep 04, 2008 9:45 pm Post subject: |
|
|
Apprentice
Joined: 04 Aug 2008
Posts: 41
Location: India
|
Do you have multiple Schemas in your database?
_________________
Cheers,
Sandeep |
|
| Back to top |
|
|
| AkankshA |
| Posted: Thu Sep 04, 2008 10:14 pm Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
|
| Back to top |
|
|
| ovasquez |
| Posted: Fri Sep 05, 2008 6:13 am Post subject: |
|
|
Centurion
Joined: 09 Dec 2005
Posts: 141
Location: Lima, Peru
|
But When i use Command Console is good....
db2 => connect to XXX user USER01 using USER01
Database Connection Information
Database server = Apache Derby CSS10000
SQL authorization ID = USER01
Local database alias = XXX
db2 => INSERT INTO TBL(COD,NAME,VALUE) VALUES ('C000001','zzzzzz','1111');
DB20000I The SQL command completed successfully.
¿?
_________________
Oscar Vásquez Flores |
|
| Back to top |
|
|
| ovasquez |
| Posted: Fri Sep 05, 2008 7:26 am Post subject: |
|
|
Centurion
Joined: 09 Dec 2005
Posts: 141
Location: Lima, Peru
|
i changed my DSN to other DataBase: MS SQL Server..and flow running ok....
same table, same flow.....
What happen in Derby?, i need use this DataBase.
_________________
Oscar Vásquez Flores |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
