Sitemap

Amicuk Programming Answers

Informatica Workflow Manager ODBC Relational Connection for ETL in DAC

-0001-11-30   Views:1

Advertisement

In Informatica Workflow Manager, I have created a Relational Connection of type ODBC and specified Connect String as "DSN=BIEEDW" where "BIEEDW" is the System ODBC DSN already set pointing to a SQL Server 2008 database. However, when t

In Informatica Workflow Manager, I have created a Relational Connection of type ODBC and specified Connect String as "DSN=BIEEDW" where "BIEEDW" is the System ODBC DSN already set pointing to a SQL Server 2008 database.
However, when the ETL run in DAC, the following error occurs in Session log files showing that the database and driver cannot be located:
MAPPING> CMN_1569 Server Mode: [UNICODE]
MAPPING> CMN_1570 Server Code page: [MS Windows Traditional Chinese, superset of Big 5]
MAPPING> TM_6151 The session sort order is [Binary].
MAPPING> TM_6156 Using low precision processing.
MAPPING> TM_6180 Deadlock retry logic will not be implemented.
MAPPING> TM_6187 Session target-based commit interval is [10000].
MAPPING> TM_6307 DTM error log disabled.
MAPPING> TE_7022 TShmWriter: Initialized
MAPPING> DBG_21075 Connecting to database [DSN=BIEEDW], user [bieedw02]
MAPPING> CMN_1761 Timestamp Event: [Wed May 22 01:29:17 2013]
MAPPING> CMN_1022 Database driver error...
CMN_1022 [
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Database driver error...
Function Name : Connect
Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [bieedw02] and connection string [DSN=BIEEDW].]
Any hint in setting the Connect String for ODBC Relational Connection?

The replay answer
Advertisement
Hi,
Let me tell you the real story:
Our server architecture consists of two servers:
Windows Server 2008 R2 (64-bit) platform with the following installed:
- SQL Server 2008
- DAC 10.1.3.4.1
- OBIEE 11g
- BI Apps (Financial Analytics) 7.9.6.3
- Informatica Server 9.1.0 HotFix 2
Windows Server 2003 Enterprise Edition SP2 (32-bit) platform with the following installed:
- Informatica Clients (i.e. Workflow Manager, Repository Manager, Designer and Workflow Monitor)
And thus the ODBC Relational Connection is configured in Informatica Client machine (Workflow Manager) which is a 32-bit platform.
Any idea?

Go to See the other 6 answers

Informatica Workflow Manager ODBC Relational Connection for ETL in DAC

Category:DefaultRelease time:-0001-11-30Views:130

In Informatica Workflow Manager, I have created a Relational Connection of type ODBC and specified Connect String as "DSN=BIEEDW" where "BIEEDW" is the System ODBC DSN already set pointing to a SQL Server 2008 database. However, when t[More]

Informatica Workflow not able to connect to source database.

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have completed the installation of OBI Apps.All the test connections are working fine and I have also configured the Relational Connection in Informatica Workflow.The passwords,username and connect string are correct.Still when I run a ETL all[More]

No Workflow Manager in Related Links section

Category:DefaultRelease time:-0001-11-30Views:130

As in the title... I log into EM as SYS or owf_mgr (my default user for OW), but don't get the link to Workflow Manager in the Related Links. Why is that? Help! Aliq.Hi shrikantnew, I'd like to know the meaning when you sya performed with intranet, a[More]

Informatica Start Workflow failed in Workflow Manager

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have just completed the installation of oracle BI Apps version 7.9.4 (Chapter 4 & 5 of installtion document). Now I am trying to run workflow using informatica workflow manager and i am getting below error in workflow log. It says "Cannot f[More]

Informatica Workflow hung/waits.

Category:DefaultRelease time:-0001-11-30Views:130

We have Informatica version 8.6.0 HF4 and OBIA 7.9.6. We are facing a weird issue with Informatica workflows hanging/waiting in recent months. Informatica session completes quick, but workflow takes long time to recognize last session finished. So it[More]

Oracle Workflow Manager, Agent Listener, and Java Mailer problem

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am not sure this topic to this forum, since this might be installation issue. But I am hitting a big wall. I had Windows 2000 SP4. I have already installed Oracle Database 10gR1, Oracle Developer 10gR2, and Oracle Workflow 2.6.3 Standalone prev[More]

Sharepoint 2013 Workflow manager setup SQL serverinstance "Failure in connecting to SQL Server"

Category:DefaultRelease time:-0001-11-30Views:130

Hi Guys im having issues with installing work flow manager. this installation has gone ok, but when I'm in the configuration stage, and type in the SQL server instance, it returns with failure in connecting to SQL server. this happens with SSL and wi[More]

SharePoint 2013 - Cannot connect or Register WorkFlow Manager with error "The data or messaging layer is unavailable. Please retry after 300 seconds"

Category:DefaultRelease time:-0001-11-30Views:130

Hi I have SharePoint 2013 farm and installed Workflow Manager 1.0 and configured it and have been runing fine for several months.  I upgraded this farm to SP 1 and then started having some issue with publish WF 2013 with task in SPD. I re-Registered[More]

Informatica 9.0.1 Repository Service Shutdown Error when Running ETL in DAC

Category:DefaultRelease time:2015-10-11Views:130

Hi All, When I executed the ETL in DAC client for full data load, I got this error from log "PLP_LoyMemberTierMovementQtrAggr.log". "Failed to connect to the repository on Host : hkhgc01dvapp01, Port : 6315. System Error (errno = 111): Conn[More]

Informatica 7.1.4:  IDLE Connections Killed

Category:DefaultRelease time:-0001-11-30Views:130

So I posted this question on Informatica's forum "Communities" but I wanted to post it here as well. We're on Informatica 7.1.4 (yeah, I know its old, but we're about to upgrade) and we have been running into issues where one long running ETL fa[More]

Can you install Workflow Manager 1.0 on Central Admin App Server Machine in 3-tier SharePoint Farm?

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have just realised when looking at doing a Workflow that 2013 Workflows not available (you need to install Workflow Manager Farm). I understand why from a tenant installation perspective, but we are on-premise. Can someone tell me if I can inst[More]

Hot
Hi, Service PO line items under item details are not appearing on print out... Where are they stored ..means in which table? RegardsHi SSingh,   Has this problem been solved? we have a similar problem here --- after upgrading from 4.6c to ECC6.0, we [More]
Can anyone please explain how do you remove irrelevant entries in the Profile Manager dialog? Since I have both 4.0 and 3.6 installed,each with two profiles,I use to launch secondary profiles with the Profile Manager via a command line instead of a s [More]
Machine specs:  HP Z820 - zeon e5-2690 48gb ram quadro k5000.  Since the recent updates & complete wipe of the system & fresh install, Premiere pro CC crashes regularly without any pattern.  Using MXF files while editing if that helps-i did read a [More]
5 days ago I did a clean installation of Mountain Lion on my ca 4 years old MaBook Pro and after that I can not see the dvd-player in Finder. That's not like it is hidden but the problem is that the dvd-player is powered off by the OS. This informati [More]
I need to downlad iTunes for my iPod Touch to work, but I can't dowload iTunes without apple application support. How can I get apple application support or is there any other way to download iTunes?Hi marian289, Thanks for using Apple Support Commun [More]
Hello, When i sorted my values of a column in a table it was showing all sorted upper case letters at top rows and all sorted lower case letters on bottom. So i would like to sort values without case sensitive order. Like. A, a, B, b, C, c.... I am u [More]
Hello, I installed Oracle 10g on Windows XP, SQLPlus is OK, but I can't start iSQL*Plus service. Please help me how to fix this problem. Thks a lot. Best regards, Kim HungWhat error message is returned when You try to start it? Additionaly You can re [More]
Hello, all. I’m using the EP Netweaver, version (EP - 6.0.10.0.0, J2EE - 6.40 PatchLevel 89291.313) and I don’t know where to find the Statistic for the Portal (example, number off user log on the Portal, number off times that one user log on the por [More]
I installed j2ee sdk 1.4 in my system. But the pointbase did not come with it. Can anyone help me out in this. Thanks in advanceI wouldn't bother with it. Use some other "free" db that doesn't have the size restriction (JavaDB, Derby, MySQL, Pos [More]
I keep getting the msg unable to connect you to Netflix. Try again later (ATV-ui31) when I try to connect to Netflix. Could you tell me what to do, to be aple to connect on Netflix using my Appletv? I have an Appletv 3rd generationMake sure DNS is se [More]