[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Error while running DBLINK query in Informatica

Posted on 2009-04-29
2
Medium Priority
?
1,398 Views
Last Modified: 2012-05-06
Hi,

Can anyone please advise on why I am getting error while running session in informatica for sql query with dblink such as
select name from t1@EXPT. when I run this query in Toad, it works fine on database in which dblink has been created but throgh informatica it gives me below mentioned error-

READER_1_1_1> RR_4035 SQL Error [

ORA-01017: invalid username/password; logon denied

ORA-02063: preceding line from EXPT

Database driver error...
0
Comment
Question by:sunilbains
2 Comments
 
LVL 2

Accepted Solution

by:
kanema earned 1500 total points
ID: 24265096
This happens when the connection information stored in the informatica repository is not up to date with the current user/password information for that database.  Go to the Workflow manager, select connections from the menu bar at the top and select the type of connection (usually relational for a database). Then find the connection string for EXPT and click edit.  It will show you the username you are using to connect to the database.  The password is also there but it is hidden.  This is where you can update the password for the userid you are connect with.  click ok after updating the password and try again.
0
 

Author Closing Comment

by:sunilbains
ID: 31576178
Thanks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question