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 All, I have identified a bug in the copy cluster roles wizard in 2012 R2, which is preventing me from migrating my clusters from 2008 R2 & 2012 to 2012 R2. The bug surfaces when you attempt to copy a VM role from a 2008 R2 or 2012 cluster that has [More]
Hi, I am trying to print from an HP LaserJet Pro MFP M-125a which is connected to a MacBook Air via a USB cable. The software has been downloaded and the print job window is always showing as if it is in the process of printing the print job given bu [More]
In Feb this year, I purchased an HP Envy 700-216 computer which came with Windows 8.1 installed. As everyone is now finally realizing, even Microsoft, Windows 8 and 8.1 sucks and is shortly going to be replaced and made obsolete!! I knew this when I [More]
When I tyr to import an Image onto Adobe Flash CS5, the image is balnk with grey outlines. Same thing happens when I try and copy and paste a image onto flash.I have created a dad on 9.0.3, and the import works. The dad in both are identical to what [More]
I prefer viewing thumbnails against a "dark" background. When the background is darkened the black type info below the "thumb" begins to blend with the darkened background, and becomes difficult to see. The file/title isn't too bad, bu [More]
Dear All, We have one problem in material given for some process work. Actually we are procuring one assembly (e.g. Motor ) through external procurement. After some time if there is any problem in sub assembly(shaft) of MOTOR thn we are creating that [More]
Hi, My work unit consist of a main program (Z_MAIN) and an include program (Z_INCLUDE). It looks like this... in the main program:     report z_main.     select-options: s_budat for mkpf-budat,     perform write_date. in the include program (Z_INCLUD [More]
How can I install my Adobe Photoshop on my computer with Windows XP Service Pack 3?  Seriously frustrated.  I put the disc in the drive and nothing happens.  I open up add/remove programs and I get an error message stating it can't find a disc.  I ch [More]
Hi, I have a question about EM DB Console. I'm not sure if it's also related with Grid Control, but maybe. I can't find any information for setting the EM administrators (link Setup and then Administrators). I thought that to do this I first have to [More]
i us this sql UPDATE DETINVENTRY A SET A.PRIXACHAT=NVL((SELECT B.PRIXACHAT FROM DETONAIRE B WHERE (B.PACKID=A.PACKID)),A.PRIXACHAT), A.PRIXVENTE=NVL((SELECT B.PRIXVENTE FROM DETONAIRE B WHERE (B.PACKID=A.PACKID)),A.PRIXVENTE), A.ACTIVEDATE=NVL((SELEC [More]