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, i ran into a problem with the NC Logging / Disposition functionality while trying to log NCs for SFCs with a Quantity>1 Scenario: Released SFC with Quantity = 10 NC_DATA_ENTRY Activity Rule ALLOW_PARTIAL set to YES NC_DATA_ENTRY Activity Rule AUT [More]
Hi All, I have a PR number lets say 10231322 and somebody has release it. Could any one please tell me how to find out who has release it? Waiting for your kind replies...... Thanks in advance. Regards, FaisalHi, When you are in tr ME23N, use the men [More]
Hi, We are usign AQ JMS Adapter and we are publishing payload in AQ JMS Topic thorugh BPEL process. Issue is, i'm not able to publish large payload ( xml file of size 4KB) to AQ JMS Topic through asynchronous BPEL process. When i post the xml in the [More]
Hi there! I'm using OO ALV ( CL_GUI_ALV_GRID ) and experiencing a strange problem. I'm interested in the cells merging functionality of ALV, when i sort data for a specific field. It works fine but only if i do not set any field as editable ( lvc_s_f [More]
I am receiving an error from DVD studio pro 3 and Toast 6 when burning DVD DL. The error only appears when burning Memorex and Verbatim discs (so far) using these applications. HP branded DVD DLs burnt fine from the same applications. Aside from the [More]
This has happened a couple of times. I'll share an iMovie to iDVD and start burning the disc. iDVD goes through the whole process, ejects the DVD and asks me if I'm done or not. I put the DVD in a player, it starts up and shortly into the film just s [More]
I need to set time interval range with custom date fields in sharepoint view SPViewCollection.SPViewType.Calendar. How to do that? My code is this: System.Collections.Specialized.StringCollection viewFields = new System.Collections.Specialized.String [More]
Hi all, We were developing a system based on Oracle8i. Then we upgraded to Oracle9i, which provided nice performance enhancements. On the other hand, we keep facing a problem. The schema which contains the application we're developing keeps locking s [More]
I just bought a new iMac on here and I was hearing that there's no internal CD/DVD Drive in the new models, is this true?  If so where can I find an external CD/DVD Drive so that I'll be able to play games and watch my magic videos on the iMac?ok tha [More]
I had to redo my os on my computer which is a Dell Dimension 4600. After getting my information back on the system and installing itunes I try to import my music and it reboots my system after a few seconds of importing. There isn't any blue screen o [More]