Unable to connect to SQLServer 2005 on repository

Change the authentication of the SQL Server to "SQL Server and Windows" (also known as "mixed mode").

OR

Use a different network library.

Go to SQL Server Configuration Manager > Protocols for MSSQLSERVER > enable TCP/IP

and restart SQL server services

Bad File in informatica

Informatica badfiles will have the row indicator columns which can take values between 0 to 9 and Please find the details as below:

RowIndicator Meaning Rejected By
0 Insert Writer or target
1 Update Writer or target
2 Delete Writer or target
3 Reject Writer
4 Rolled-back insert Writer
5 Rolled-back update Writer
6 Rolled-back delete Writer
7 Committed insert Writer
8 Committed update Writer
9 Committed delete Writer

Also you can focus on column indicators, and the details are as below:
Indicator Type of data Writer Treats As

D Valid data. Good data. Writer passes it to the target database. The target accepts it unless a database error occurs, such as finding a duplicate key.

O Overflow Numeric data exceeded the specified precision or scale for the column. Bad data, if you configured the mapping target to reject overflow or truncated data.

N Null The column contains a null value. Good data. Writer passes it to the target, which rejects it if the target database does not accept null values.

T Truncated String data exceeded a specified precision for the column, so the PowerCenter Server truncated it. Bad data, if you configured the mapping target to reject overflow or truncated data.

Administration Console hangs when logging in using host name

Administration Console hangs when logging in using host name

Problem Description

The Administration Console is displayed however after entering the user name and password, the page appears to hang. Domain will be running and accessible by command line tools such as infatest . Domain may be accessed using localhost and not the machine host name is entered into Administration Console URL.

Cause

The fact that the Administration Console can be accessed via the localhost string indicates there is a fault with DNS. PowerCenter will use DNS to check back on host names and IP addresses.

Solution

To resolve this issue identify which machines on the network are acting as DNS servers and check their configuration ensuring that entries for machines used by PowerCenter (database server, client machines, PowerCenter nodes) are correct.

Applies To

PowerCenter 8.1.x PowerCenter 8.5

HOW TO: Set the PowerCenter service Custom Properties
Solution
To add an undocumented PowerCenter parameter (Integration Service or Repository Service Custom Property ) do the following in the Informatica PowerCenter (8.1.x or 8.5.x) Administration Console:
Stop the Integration Service (or Repository Service).
Select the Integration Service (or Repository Service).
Under the Properties tab, click Edit in the Custom Properties section.
Under Name enter the name of the undocumented parameter.
Example:
XMLinUTF8
Enter the value for the parameter under Value .
Example:
AggSupprtWithNoPartLic = Yes
Click OK .
Start the Integration Service (or Repository Service

Partitioning option license required to run sessions with user-defined partition points.

Quote: TM_6281: Partitioning option license required to run sessions with user-defined partition points.

When I de-select the "Sorted Input" property, it runs fine but it spends needless time caching my entire table to file. Does anyone know why this might be happening and/or a possible resolution? " " To run a PowerCenter session with a sorted Aggregator transformation set the server parameter AggSupprtWithNoPartLic to "Yes" as follows:

Unix Using a text editor open the PowerCenter server configuration (pmserver.cfg) file.
Add the following entry to the end of the file:
AggSupprtWithNoPartLic = Yes
Re-start the PowerCenter server (pmserver).

Windows To set this parameter on Windows refer to article 11486
(article 11486) To add a PowerCenter Server parameter (that is not in the server configuration dialog) on Windows enter it in the registry as follows:

Click Start, click Run, type regedit, click OK. Go to the following registry key: HKEY_LOCAL_MACHINE\ SYSTEM\CurrentControlSet\Services\PowerMart\Paramet ers\Configuration
On the Edit menu, point to New, and then click String Value. Enter the String Value "SERVER_PARAMETER". Go to Edit > Modify. Enter "VALUE" and then click OK Re-start the PowerCenter server (Informatica Service). Where SERVER_PARAMETER is the name of the parameter and VALUE is the setting of the parameter."

recv_all:WSAECONNRESET)Connection reset by peer

Problem Description

When debugging a mapping with Sorter transformation, the debugger shuts down with the following message. Failed to receive a notification from the Integration Service: recv_all: (WSAECONNRESET)Connection reset by peer Shutting down notification handler due to previous errors. Shutting down the debugger due to previous errors. Debugger shutdown complete

Solution

This is a known issue (CR 127472) in PowerCenter 8.1 and PowerCenter 8.1.1, which had been fixed in PowerCenter 8.1.1 SP1. To resolve this issue, you will have to install PowerCenter 8.1.1 SP1 maintenance release.

"TE_7020 Unbound field in Source Qualifier" when running session

Problem Description

When running a session the session fails with the following error: TE_7020 Unbound field in Source Qualifier "

Solution

This error will occur when there is an inconsistency between the Source Qualifier and the source table. Either there is a field in the Source Qualifier that is not in the physical table or there is a column of the source object that has no link to the corresponding port in the Source Qualifier. To resolve this, re-import the source definition into the Source Analyzer in Designer. Bring the new Source definition into the mapping. This will also re-create the Source Qualifier. Connect the new Source Qualifier to the rest of the mapping as before.

"Cannot generate query no valid fields projected from the Source Qualifier" generating a SQL Override in a Source Qualifier

Problem Description

After clicking on the Generate SQL button in a SQL override the following error is encountered: Cannot generate query because there are no valid fields projected from the source qualifier

Solution

The output ports of the Source Qualifier must be connected to another transformation in the mapping. Only the ports that are connected to another transformation will be included in the SELECT clause of the SQL that is generated. To resolve do the following: Close the SQL Override window. Connect the ports from the Source Qualifier to the next transformation in the mapping. Create the SQL Override.

FATAL ERROR : Unexpected Condition in file [\ZeusbuilderProduction\view\powrmart\server\dmapper\widget\wjoiner.cpp]

"Unexpected Condition at at wjoiner.cpp: line 8772" when running a PowerCenter session with Joiner transformation

Problem Description

When running a PowerCenter session with the mapping that has a Joiner Transformation with sorted input using a Sorter transformation, the session fails with the following errors in the session log in different versions of PowerCenter: FATAL ERROR : Unexpected Condition in file [\ZeusbuilderProduction\view\powrmart\server\dmapper\widget\wjoiner.cpp] line [8772].Contact Informatica Technical Support for assistance.Aborting this DTM process due to an unexpected condition. PowerCenter 7.1.x: FATAL ERROR : Unexpected Condition in file [/home1/build71/pm711n/server/dmapper/widget/wjoiner.cpp] line [8449].Contact Informatica Technical Support for assistance.Aborting this DTM process due to an unexpected condition.

Cause

This is due to insufficient buffer memory being allocated to run the session.

Solution

To resolve this set the DTM buffer block size to AUTO. However, if you do not want to run the session with AUTO, then set the DTM buffer size and Buffer Block size to the value that is specified in the session when run in the AUTO mode. PowerCenter 7.1.x To resolve this in versions prior to 8.x increase the DTM buffer size.

Applies To

PowerCenter

More Information

Alternatively you can clear the Sorted Input option in the Joiner transformation to avoid this error.

Reference

"Allocating Buffer Memory" under "Optimizing Sessions" in the PowerCenter Performance Tuning Guide

"TM_6795 ERROR: Session or its instance is invalidated and the Integration Service is configured not to run impacted sessions."

"TM_6795 ERROR: Session or its instance is invalidated and the Integration Service is configured not to run impacted sessions."

Problem Description

A PowerCenter session fails to run and the following error is in the workflow log: INFO : LM_36488 : (655482|7711) Session task instance [s_session] : [TM_6721 Started [Fetch Session from Repository].] ERROR : LM_36488 : (655482|7711) Session task instance [s_session] : [TM_6795 ERROR: Session or its instance is invalidated and the Integration Service is configured not to run impacted sessions.] ERROR : LM_36320 : (655482|7197) Session task instance [s_m_DP_All_Functions_sybs]: Execution failed. INFO : LM_36318 : (655482|7197) Workflow [all_function_sybs]: Execution succeeded.

Cause

This error will occur when the session has been invalidated due to a dependent object being updated and the Run sessions impacted by dependency updates Integration Service property is set to 'No' (the default setting).

Solution

To run the session successfully do the following: Validate session in the Workflow Manager. Save the workflow. Run the workflow.

More Information

To run the session after updates without validating (not recommended) do the following: Login to the Informatica PowerCenter Administration Console. Select the Integration Service. Select the Properties tab. Expand the Advanced Properties Select Edit. Select Run sessions impacted by dependency updates. Click OK.

XML Reader error:Downcasting from UNICODE to ASCII'.

problem
sources are XML Files.When I run the
workflow some sessions are failing and the error mesg in log is
'XML Reader error:Downcasting from UNICODE to ASCII'.This happens
only with some XML files.

solved

Goto Informatica PowerCenter Administration Console (8.1) >> change ascii to unicode

You can configure general properties for the Integration Service. You can override some of these properties at the session level or workflow level. To override these properties, configure the properties for the session or workflow.

To edit the general properties, select the Integration Service in the Navigator, and then click the Properties tab > General Properties > Edit.

Solved

others fix the xml file :

Please find the below link to get the XML parser tool.

www.architag.com/xray/

you can use this tool to parse your xml.

you have to update your source xml code page to UNICODE.

error importing xml with xsd: xsd too big (more than 500MB)

Problem :
When creating an xml source using an xsd, I am getting an error
saying that the xsd used is too big. It lets me complete the
import but the source is not valid. When trying to validate, I
get the following error message: "ThisXML definition is too
large. The total length of all columns must not exceed 500
MB""The XML definition is not valid"

Solve
In source analyzr open the source in edit xml mode (in xml editor) then
goto TOOLS.....>OPTIONS....>Override all infinite lengths with value(tik
this option and set the value to 200 or less)

Invalid lookup override

Problem :
LOOKUP transformation : SQL Override
SELECT DISTINCT TIM_DT_ID FROM L_TIM_DT
WHERE TIM_DT_ID >= '2006-01-01'

Error :
Severity Timestamp Node Thread Message Code Message
WARNING 3/6/2008 18:12:23 node01_quadjt MAPPING DBG_21263 Invalid lookup override

Solved :
while overriding the lookup you must have to give the
alias name as exisiting port name,

SELECT DISTINCT L_TIM_DT.TIM_DT_ID as TIM_DT_ID FROM L_TIM_DT
WHERE L_TIM_DT.TIM_DT_ID >= '2006-01-01'

"PCSF_46007 No gateway connectivity is provided for domain. ERROR: Cannot connect to Integration Service" when running the PowerCenter 8.1

"PCSF_46007 No gateway connectivity is provided for domain. ERROR: Cannot connect to Integration Service" when running the PowerCenter 8.1 pmcmd connect command

Problem Description

When running pmcmd connect command to connect to a domain, the following error is displayed: PCSF_46007 No gateway connectivity is provided for domain[xxx]. ERROR: Cannot connect to Integration Service [xxx] The issue is not resolve even when the following command is used to update the Gateway node in the domains.infa file: Infacmd(.sh) updateGatewayInfo <-domainname|-dn> name_of_domain <-gatewayaddress|-dg> domain_gateway_host:port

Cause

This issue is caused when the domains.infa already contains the entry for the domain and its details but the pmcmd command is not able to find the domains.infa file to read the information.

Solution

To resolve the issue, add the environment variable INFA_DOMAINS_FILE. To add the environment variable, do the following: Windows: Right click My Computer. Click Properties. Select the Advanced Tab Click Environmental Variables... Click New... under System variables. Enter the following: Variable Name: INFA_DOMAINS_FILE Value Name: C:\Informatica\PowerCenter8.1.0\domains.infa. Note The domain.infa filename must be included in the path as show above. Click OK three times. UNIX: In a UNIX C shell environment, type the following: setenv INFA_DOMAINS_FILE /domains.infa In a UNIX Bourne shell environment, type the following: INFA_DOMAINS_FILE=/domains.infa export INFA_DOMAINS_FILE

Applies To

PowerCenter 8.1