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, Running UCM 8.5 cluster with UCCX 8.5. In CSD, silent monitoring is not working. Windows XP OS is running on supervisor desktop. when i select the agent then the silent monitoring icon will highlighted once i click on the icon, after 5-7 seconds [More]
Since pretty much the dawn of time, I've been able to, from the "Albums" view in iTunes, type in the first few letters of an artist's name and iTunes would go straight there, to that artist's first album. Ever since updating iTunes a couple of d [More]
The volume on my MacBook Pro no longer works after the Yosemite update. "Internal speakers" is selected for device output. I'm not sure how to fix this...Please read this whole message before doing anything. This procedure is a diagnostic test. [More]
I have recently changed from Windows 7 desktop to a new iMac running Mavericks.  I have chosen a wired keyboard as I like  the usual Delete key function. I cannot find out how to select several items which are not next to each other (e.g. words in Pa [More]
Bought a new apple TV today and during setup no lights blinking when i press the remote control buttons is that normal? Thamks. I have bought 3 apple TV's 3rd generation before and all of them have lights blinking while using the remote control this [More]
When you right click a selection of Word documents or photos in the finder, I see an option for Print. I thought that if I used this option, the selection would automatically print. Instead, it just opens the application and documents (for example, M [More]
HI, i want to display some names in a textfield like type forward that is if the user enter " a " in the textfield, the names starting with " a" has to display in drop-down list. how we can do this in flex?. please help me it is very c [More]
Hi! I always use folder view to go through my documents, but some of the folder names are too big so it only shows the beggining and the end of each tittle. So it looks like this... How can I change that to show more lines and wrap the texts? kind of [More]
Hi I´ve a Question about the BO XI 3.1 SP3 version. If I want to load a crystal report named "OutputBlock.rpt" over BO I get the following error. ->Error about the data OutputBlock: The chart could not found Does everyones know why? mfg Mr.Hy [More]
Hi experts, I want to use the Standard PO-migration program in the SPRO (RM06EEI0), for which I need to disable message determination for POs on the target system. What would be the easiest way to disable message determination? Thanks!If you do not w [More]