| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| database table retrieve problem |
« View previous topic :: View next topic » |
| Author |
Message
|
| sai kumar123 |
 Posted: Tue Jan 31, 2017 9:53 pm Post subject: database table retrieve problem |
 |
|
Novice
Joined: 16 Dec 2016
Posts: 15
|
Hello everyone...I have created a table in sql database.I have created connection between broker and database. But i was unable retrieve the table in database node flow.
ExceptionList
RecoverableException
File:CHARACTER:F:\build\slot1\S900_P\src\DataFlowEngine\MessageServices\ImbDataFlowNode.cpp
Line:INTEGER:1153
Function:CHARACTER:ImbDataFlowNode::createExceptionList
Type:CHARACTER:ComIbmMQInputNode
Name:CHARACTER:flow#FCMComposite_1_1
Label:CHARACTER:flow.MQ Input
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Node throwing exception
Insert
Type:INTEGER:14
Text:CHARACTER:flow.MQ Input
RecoverableException
File:CHARACTER:F:\build\slot1\S900_P\src\DataFlowEngine\SQLNodeLibrary\ImbDatabaseNode.cpp
Line:INTEGER:320
Function:CHARACTER:ImbDatabaseNode::evaluate
Type:CHARACTER:ComIbmDatabaseNode
Name:CHARACTER:flow#FCMComposite_1_2
Label:CHARACTER:flow.Database
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Caught exception and rethrowing
Insert
Type:INTEGER:14
Text:CHARACTER:flow.Database
DatabaseException
File:CHARACTER:F:\build\slot1\S900_P\src\DataFlowEngine\MessageServices\ImbOdbc.cpp
Line:INTEGER:2260
Function:CHARACTER:ImbOdbcConnection::checkRcInner
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2393
Text:CHARACTER:Root SQL exception
Insert
Type:INTEGER:2
Text:CHARACTER:-1
Insert
Type:INTEGER:5
Text:CHARACTER:ORDERDSN1
Insert
Type:INTEGER:14
Text:CHARACTER:odbc32.dll
DatabaseException
File:CHARACTER:F:\build\slot1\S900_P\src\DataFlowEngine\MessageServices\ImbOdbc.cpp
Line:INTEGER:2438
Function:CHARACTER:ImbOdbcConnection::checkRcInner
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2322
Text:CHARACTER:Child SQL exception
Insert
Type:INTEGER:5
Text:CHARACTER:28000
Insert
Type:INTEGER:2
Text:CHARACTER:18456
Insert
Type:INTEGER:5
Text:CHARACTER:[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'.
DatabaseException
File:CHARACTER:F:\build\slot1\S900_P\src\DataFlowEngine\MessageServices\ImbOdbc.cpp
Line:INTEGER:2438
Function:CHARACTER:ImbOdbcConnection::checkRcInner
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2322
Text:CHARACTER:Child SQL exception
Insert
Type:INTEGER:5
Text:CHARACTER:IM006
Insert
Type:INTEGER:2
Text:CHARACTER:0
Insert
Type:INTEGER:5
Text:CHARACTER:[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
DatabaseException
File:CHARACTER:F:\build\slot1\S900_P\src\DataFlowEngine\MessageServices\ImbOdbc.cpp
Line:INTEGER:2438
Function:CHARACTER:ImbOdbcConnection::checkRcInner
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2322
Text:CHARACTER:Child SQL exception
Insert
Type:INTEGER:5
Text:CHARACTER:42000
Insert
Type:INTEGER:2
Text:CHARACTER:4060
Insert
Type:INTEGER:5
Text:CHARACTER:[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database "sql" requested by the login
 |
|
| Back to top |
|
 |
| Vitor |
| Posted: Wed Feb 01, 2017 5:19 am Post subject: Re: database table retrieve problem |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| sai kumar123 wrote: |
| I have created connection between broker and database. |
Maybe, but not correctly.
This seems fairly clear:
| sai kumar123 wrote: |
| Text:CHARACTER:[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'. |
I would doubt that you intended the connection to be using the system id, and if you did, that's not a great idea.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Feb 01, 2017 5:49 am Post subject: Re: database table retrieve problem |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20768
Location: LI,NY
|
| Vitor wrote: |
| sai kumar123 wrote: |
| I have created connection between broker and database. |
Maybe, but not correctly.
This seems fairly clear:
| sai kumar123 wrote: |
| Text:CHARACTER:[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'. |
I would doubt that you intended the connection to be using the system id, and if you did, that's not a great idea. |
You probably will need to switch from windows authentication to SQL authentication for your DB. Or maybe live with a mix of both... 
_________________
MQ & Broker admin |
|
| 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
|
|
|
|
