| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Data source name not found - impossible (SOLVED FINALLY) |
« View previous topic :: View next topic » |
| Author |
Message
|
| giorginus80 |
 Posted: Thu Feb 05, 2009 2:17 am Post subject: Data source name not found - impossible (SOLVED FINALLY) |
 |
|
Centurion
Joined: 08 Jul 2008
Posts: 124
Location: Rome, Italy
|
Hi,
I have a strange beahviour on broker. I have broker 6.1.0.3 under linux and Oracle 9.2 using datadirect 5.3.
I have other flows deployed on the same execution group, using DB in esql node and mapping nodes, but on one other new flow I got this error on mapping node:
| Code: |
ExceptionList
RecoverableException
File:CHARACTER:/build/S610_P/src/DataFlowEngine/ImbDataFlowNode.cpp
Line:INTEGER:739
Function:CHARACTER:ImbDataFlowNode::createExceptionList
Type:CHARACTER:ComIbmDatabaseNode
Name:CHARACTER:dispatchFile#FCMComposite_1_17.posteFtpImport#FCMComposite_1_6.ComIbmDataInsert#FCMComposite_1_1
Label:CHARACTER:dispatchFile.posteFtpImport.InserIntoSwap.ComIbmDatabase
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Node throwing exception
RecoverableException
File:CHARACTER:/build/S610_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp
Line:INTEGER:602
Function:CHARACTER:SqlStatementGroup::execute
Type:CHARACTER:ComIbmDatabaseNode
Name:CHARACTER:dispatchFile#FCMComposite_1_17.posteFtpImport#FCMComposite_1_6.ComIbmDataInsert#FCMComposite_1_1
Label:CHARACTER:dispatchFile.posteFtpImport.InserIntoSwap.ComIbmDatabase
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2488
Text:CHARACTER:Error detected, rethrowing
Insert
Type:INTEGER:5
Text:CHARACTER:.IBM_WBIMB_posteFtpImport_InserIntoSwap.MAIN
Insert
Type:INTEGER:5
Text:CHARACTER:3.1
Insert
Type:INTEGER:5
Text:CHARACTER:posteFtpImport_InserIntoSwap(Root, LocalEnvironment);
RecoverableException
File:CHARACTER:/build/S610_P/src/DataFlowEngine/ImbRdl/ImbRdlRoutine.cpp
Line:INTEGER:548
Function:CHARACTER:SqlRoutine::invoke
Type:CHARACTER:ComIbmDatabaseNode
Name:CHARACTER:dispatchFile#FCMComposite_1_17.posteFtpImport#FCMComposite_1_6.ComIbmDataInsert#FCMComposite_1_1
Label:CHARACTER:dispatchFile.posteFtpImport.InserIntoSwap.ComIbmDatabase
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2934
Text:CHARACTER:Error occured in procedure
Insert
Type:INTEGER:5
Text:CHARACTER:posteFtpImport_InserIntoSwap
RecoverableException
File:CHARACTER:/build/S610_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp
Line:INTEGER:586
Function:CHARACTER:SqlStatementGroup::execute
Type:CHARACTER:ComIbmDatabaseNode
Name:CHARACTER:dispatchFile#FCMComposite_1_17.posteFtpImport#FCMComposite_1_6.ComIbmDataInsert#FCMComposite_1_1
Label:CHARACTER:dispatchFile.posteFtpImport.InserIntoSwap.ComIbmDatabase
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2488
Text:CHARACTER:Error detected, rethrowing
Insert
Type:INTEGER:5
Text:CHARACTER:.posteFtpImport_InserIntoSwap
Insert
Type:INTEGER:5
Text:CHARACTER:62.2
Insert
Type:INTEGER:5
Text:CHARACTER:INSERT INTO Database.orcl.SIR_SVIL.SWAP_ID_REC_POSTE_FTP ( SRF_ID_INIZIO_FLUSSO, SRF_NUMERO_VERSAMENTI, SRF_DATA_RIF_DATI, SRF_CODICE ) VALUES ('AA', source_body.numeroVersamenti, source_body.dataRiferimento, swapVersamentoRecPosteNextID() )
DatabaseException
File:CHARACTER:/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp
Line:INTEGER:327
Function:CHARACTER:ImbOdbcHandle::checkRcInner
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2321
Text:CHARACTER:Root SQL exception
Insert
Type:INTEGER:2
Text:CHARACTER:-1
DatabaseException
File:CHARACTER:/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp
Line:INTEGER:456
Function:CHARACTER:ImbOdbcHandle::checkRcInner
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2322
Text:CHARACTER:Child SQL exception
Insert
Type:INTEGER:5
Text:CHARACTER:IM002
Insert
Type:INTEGER:2
Text:CHARACTER:0
Insert
Type:INTEGER:5
Text:CHARACTER:[DataDirect][ODBC lib] Data source name not found and no default driver specified
|
This is not possible because the datasource specified on the node is THE SAME of other flow specified. But I'm getting crazy why I have this error? The flow is very simple, I have an MQInput node, and esql node (no db operation inside this one) and one mapping DB Insert node and then the output.
Last edited by giorginus80 on Fri Feb 06, 2009 3:47 am; edited 1 time in total |
|
| Back to top |
|
 |
| dilse |
| Posted: Thu Feb 05, 2009 10:05 am Post subject: |
|
|
Master
Joined: 24 Jun 2004
Posts: 270
|
| This is generally the error you see when you don't mention the database on the 'compute node' data source name property or sometimes you PASSTHRU statement but dont mention the database name. Let us know what your message flow looks like so that we can analyze the possibility to some extent. |
|
| Back to top |
|
|
| giorginus80 |
| Posted: Fri Feb 06, 2009 1:21 am Post subject: |
|
|
Centurion
Joined: 08 Jul 2008
Posts: 124
Location: Rome, Italy
|
| dilse wrote: |
| This is generally the error you see when you don't mention the database on the 'compute node' data source name property or sometimes you PASSTHRU statement but dont mention the database name. Let us know what your message flow looks like so that we can analyze the possibility to some extent. |
The property is right configured and on other flow with same db is working. It try to do the query, but I don't know why may be it put the instance name (in this case 'orcl') in the query....and in the other flows I think this isn't. why?
| Code: |
INSERT INTO Database.orcl.SIR_SVIL.SWAP_ID_REC_POSTE_FTP ( SRF_ID_INIZIO_FLUSSO, SRF_NUMERO_VERSAMENTI, SRF_DATA_RIF_DATI, SRF_CODICE ) VALUES ('AA', source_body.numeroVersamenti, source_body.dataRiferimento, swapVersamentoRecPosteNextID() )
|
it seems to get orcl before schema, but why? If I write this in a esql node I got the same error, I have to write this query without ".orcl" but why the mapping node is putting this statement? is there any bug ? |
|
| Back to top |
|
|
| giorginus80 |
| Posted: Fri Feb 06, 2009 3:33 am Post subject: |
|
|
Centurion
Joined: 08 Jul 2008
Posts: 124
Location: Rome, Italy
|
I found the problem.
This is very useful for who think to use db mapping to insert or other operation on db. May be there is a bug in the latest broker develpment fix. I have the last one 6.0.3 with latest patched.
In the other flow all it worked because was with old patches:
when I created message map if you open the corresponding msgmap file there is a parameter VERY IMPORTANT:
| Code: |
<dbOverride dsnName="orcl" useDsnInProperty="true"/>
|
where orcl is the name of istance db in my case.
Ok in my new flows, developed in the same project but after doing the latest fix pack with installation manager, this parameter isn't put. So If I put this parameter in the msgmap file manually all it's working. In the previous released patches this was working. Very hard to find this, because the error 'Data source name not found' is incorrect! |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Feb 06, 2009 4:28 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| giorginus80 wrote: |
Ok in my new flows, developed in the same project but after doing the latest fix pack with installation manager, this parameter isn't put. So If I put this parameter in the msgmap file manually all it's working. In the previous released patches this was working. Very hard to find this, because the error 'Data source name not found' is incorrect! |
Time for a PMR.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| 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
|
|
|
|
