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.