ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexWebSphere Message Broker SupportBIP2348E: Error detected while attempting to obtain a conn

Post new topicReply to topic
BIP2348E: Error detected while attempting to obtain a conn View previous topic :: View next topic
Author Message
petervh1
PostPosted: Thu Oct 01, 2020 4:40 am Post subject: BIP2348E: Error detected while attempting to obtain a conn Reply with quote

Acolyte

Joined: 19 Apr 2010
Posts: 58

Hi

I'm trying to connect to and write to a remote Oracle DB from an ACE flow. The ACE flow runs in an OpenShift container.

I ran the following successfully:

Code:
sh-4.4$ mqsisetdbparms -w  /home/aceuser/ace-server -n ESBDB -u uafresb -p xxx


Code:
sh-4.4$ mqsicvp -n ESBDB -u uafresb -p xxx
BIP8290I: Verification passed for the ODBC environment.

BIP8270I: Connected to Datasource 'ESBDB' as user 'UAFRESB'. The datasource platform is 'Oracle', version '12.02.0000 Oracle 12.2.0.1.0'.
===========================


I then ran a trace on my flow, with the following result:
Code:
2020-10-01 12:14:34.711296      164  UserTrace   BIP2348E: Error detected while attempting to obtain a connection to dat
a source 'ESBDB' of type 'ODBC' using userid 'mqsiUser'.
The integration node detected an error while attempting to obtain a connection to data source 'ESBDB' of type 'ODBC' wit
h userid 'mqsiUser'. If your integration node is running on z/OS, it is possible for the userid to be blank, which resul
ts in a connection attempt using the userid of the started task.
See the following messages for details of the error, or use the mqsicvp command to verify the database configuration.
2020-10-01 12:14:34.711328      164  UserTrace   BIP2393E: Database error: ODBC return code '-1' from data source 'ESBDB
' using ODBC driver manager '/opt/ibm/ace-11/ie02/lib/libodbcinterface.so'.
The integration node received an error when processing a database operation. The ODBC return code was '-1'. See the foll
owing messages for information obtained from the database about this error.
Use the following messages to determine the cause of the error. Typical problems are an incorrect data source, or table
names. Correct either the database or the integration node configuration. Use the mqsicvp command to test connectivity t
o this database.
2020-10-01 12:14:34.711376      164  UserTrace   BIP2322E: Database error: SQL State '46'; Native Error Code '1017'; Err
or Text '[unixODBC][IBM][ODBC 20101 driver][20101]ORA-01017: invalid username/password; logon denied'.


Why does the trace report a userid of 'mqsiUser' for the connection attempt?

Can anyone assist?

Thanks in advance
Back to top
View user's profile Send private message
abhi_thri
PostPosted: Thu Oct 01, 2020 11:25 am Post subject: Re: BIP2348E: Error detected while attempting to obtain a co Reply with quote

Partisan

Joined: 17 Jul 2017
Posts: 381
Location: UK

petervh1 wrote:

Why does the trace report a userid of 'mqsiUser' for the connection attempt?


hi...restarted the node/integration server after running mqsisetdbparms?
Back to top
View user's profile Send private message
petervh1
PostPosted: Fri Oct 02, 2020 2:39 am Post subject: Reply with quote

Acolyte

Joined: 19 Apr 2010
Posts: 58

I tried running the mqsisetdbparms as in my initial post, and then scaling the pod to 0 and then back to 1. If I then run mqsireportdbparms I get:
Code:

sh-4.4$ mqsireportdbparms -w  /home/aceuser/ace-server -n ESBDB -u uafresb -p xxx
BIP8208W: No resources found with resource name 'ESBDB'.


So, working on the basis that I need to rerun the mqsisetdbparms every time I scale the pod to 1, I reran mqsisetdbparms and then immediately ran mqsireportdbparms. This time I get:
Code:

sh-4.4$ mqsisetdbparms -w  /home/aceuser/ace-server -n ESBDB -u uafresb -p xxx
BIP8071I: Successful command completion.
sh-4.4$ mqsireportdbparms -w  /home/aceuser/ace-server -n ESBDB -u uafresb -p xxx
BIP8180I: The resource name 'ESBDB' has userID 'uafresb'.
BIP8201I: The password you entered, 'xxx' for resource 'ESBDB' and userId 'uafresb' is correct.
BIP8206I: The Integration node is not running and may not have been restarted since the last change made by the mqsisetdbparms command.


As before, the trace shows:
Code:

The integration node detected an error whilst processing a message in node 'Datalogger_Common.Compute'. An exception h
as been thrown to cut short the processing of the message.
See the following messages for details of the error.
2020-10-02 10:30:26.332770      193  UserTrace   BIP2348E: Error detected while attempting to obtain a connection to d
ata source 'ESBDB' of type 'ODBC' using userid 'mqsiUser'.
The integration node detected an error while attempting to obtain a connection to data source 'ESBDB' of type 'ODBC' w
ith userid 'mqsiUser'. If your integration node is running on z/OS, it is possible for the userid to be blank, which r
esults in a connection attempt using the userid of the started task.
See the following messages for details of the error, or use the mqsicvp command to verify the database configuration.
2020-10-02 10:30:26.332814      193  UserTrace   BIP2393E: Database error: ODBC return code '-1' from data source 'ESB
DB' using ODBC driver manager '/opt/ibm/ace-11/ie02/lib/libodbcinterface.so'.
The integration node received an error when processing a database operation. The ODBC return code was '-1'. See the fo
llowing messages for information obtained from the database about this error.
Use the following messages to determine the cause of the error. Typical problems are an incorrect data source, or tabl
e names. Correct either the database or the integration node configuration. Use the mqsicvp command to test connectivi
ty to this database.
2020-10-02 10:30:26.332872      193  UserTrace   BIP2322E: Database error: SQL State '46'; Native Error Code '1017'; E
rror Text '[unixODBC][IBM][ODBC 20101 driver][20101]ORA-01017: invalid username/password; logon denied'.
The error has the following diagnostic information:     SQL State             '46'     SQL Native Error Code '1017'
  SQL Error Text        '[unixODBC][IBM][ODBC 20101 driver][20101]ORA-01017: invalid username/password; logon denied'
This message may be accompanied by other messages describing the effect on the integration node itself. Use the reason
 identified in this message with the accompanying messages to determine the cause of the error. Use the mqsicvp comman
d to test connectivity to this database.


As before, the mqsicvp shows:
Code:

sh-4.4$ mqsicvp -n ESBDB -u uafresb -p uafresb
BIP8290I: Verification passed for the ODBC environment.

BIP8270I: Connected to Datasource 'ESBDB' as user 'UAFRESB'. The datasource platform is 'Oracle', version '12.02.0000Oracle 12.2.0.1.0'.
===========================


Can anyone assist?
Back to top
View user's profile Send private message
Vitor
PostPosted: Fri Oct 02, 2020 4:28 am Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26062
Location: Texas, USA

How is the storage arranged in OpenShift?

Remember that the credentials are stored in the depths of /var/mqsi so if there's anything odd about how that's being set up, initialized or shared as you scale up and down you could well see this sort of effect.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker SupportBIP2348E: Error detected while attempting to obtain a conn
Jump to:



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
Protected by Anti-Spam ACP


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.