Thursday, 16 March 2017

PowerCenter session fails with the following error messages when running a session with SQL transformation:

Problem Description

PowerCenter session fails with the following error messages when running a session with SQL transformation:

ERROR : (1124 | TRANSF_1_1_1) : (IS | is_test) : pmsql_50018 : [ERROR] Failed to get the connections. 
ERROR : (1124 | TRANSF_1_1_1) : (IS | is_test) : pmsql_50009 : [ERROR] Static Connection information is inappropriate to create a valid Database Handle. 
ERROR : (1124 | TRANSF_1_1_1) : (IS | is_test) : CTSDK_43013 : Partition Driver level [SQL]: CT failed in init(). 
ERROR : (1124 | TRANSF_1_1_1) : (IS | is_test) : TM_6085 : The transformation [SQL] encountered fatal error. Terminating session.
Cause
This error occurs when SQL transformation is not set as Relational under Edit > Mapping tab.
Solution

To resolve this error do the following:

  1. Edit the Session Task Properties in the Workflow Manager.

  2. Click the Mapping tab.

  3. Select the SQL transformation under the Transformations folder.

  4. Edit the connection for SQL transformation.

  5. Switch None to Relational.

  6. Choose a valid Relational Connection from the list.

  7. Click Apply.

  8. Save the changes.

  9. Run the session.

No comments:

Post a Comment