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
I have a Seagate Central 3tb NAS (latest firmware) attached to my wireless router (Netgear wndr3400v3).  I have a late 2011 macbook pro with Yosemite on it.  When I go through finder to use my NAS I keep getting "The operation can't be completed beca [More]
I left a family share with my brother and started one with my wife and son.  I now have multiple family calendars on both my Mac and phone.  The normal method for deleting old calendars does not work on the family calendars.  How do I remove the old [More]
Hi I have question about SD process  , First step is  PGI  ( Dr. Cost   Cr. FG )  >> 1 FI DOC Next  Post Billing   ( Dr AR  Cr. Revenue)  >> 1 FI Doc Current process has problem with different posting date between PGI and Billing doc .At my co [More]
I know someone with a Dial-Up modem connection that wants to get the latest version of iTunes installed on their computer. Rather than having them sit for hours to download over dial-up is there a way for me to get the iTunes software (PC or Mac) fro [More]
Hi, How can I print Warranty (No. of Months) on Delivery Note using PLD. Warranty is already defined in a service template which is assigned to Item Master record. when i try to print "duration" from OCTT is shows all the duration values set in [More]
I use Toplink 2.0-b41-beta2 (03/30/2007) and have a problem with the following JPQL query: “SELECT DISTINCT OBJECT(e) FROM Entry e WHERE e.location IN (SELECT loc From View v JOIN v.viewLocs vl JOIN vl.location loc where v.code = :code)” “Entry” is a [More]
I usually open multiple files for editing.  I usually cut and past portions of these pictures into new images.  Once I am done with these original images, I usually close them.  Sometimes many other open picture files close as well as the file that I [More]
I have a login section that has a username and password input field. I am not sure if I am doing this right, but since there is only one username and one password, this is how I did this. function checkPassword(userN:String, passW:String):Void { if(u [More]
I developed a site for a Studio/Gallery using Muse, with the intention of hosting it with one of my five  Business Catalyst sites. After I launched the site, I discovered that there a several issues  that makes Adobe BC a bad choice for hosting throu [More]
HI GURU'S   I'M UNABLE TO SEND THE SCREENSHOT OF THIS PARTICULAR ERROR MESSAGE.   THIS IS THE STATUS I AM GETTING Request still running Diagnosis No errors could be found. The current process has probably not finished yet. System response The ALE inb [More]