Thursday, 29 December 2016

Mapping Failure Due to The data channel used by this callback handler has.


many of the mappings are failing with error "[ICMD_10033] Command [RunMapping] 

failed with error [[ICMD_10000] [JSF_0010] 

The data channel used by this callback handler has been closed.  

No new events will be received on this handler.]."



The error occurs due to a broken connection between infacmd process and DIS process.

Connection may break due to DIS process termination, network errors, or heartbeat timeout on the connection. Heartbeat timeout, default of 40 seconds, can happen due to resource crunch.


To resolve this issue, identify if there are network errors or DIS termination and resolve those issues.

 If the failure is due to heartbeat timeout, check for system resource utilization to identify resource crunch and ensure no resource starvation for infacmd and DIS process. Alternatively, set domain-level custom property "HeartbeatTimeout" to higher value than 40 to increase tolerance of network delays [requires service restart].

Wednesday, 28 December 2016

HOW TO: Delete older object versions in a PowerCenter versioned repository

Problem Description 
There are older checked-in versions of PowerCenter objects in the recent PowerCenter folder or repository.
For the largest and most actively maintained folders, the responsive time while using Designer is slow.
Is there a way to clean them all?

This can be done using one of the following:
  • Advanced Purge
    Using the Repository Manager.
  • PurgeVersion
    Using the pmrep command line tool.
  • Purge Object Version
    Using the Repository Manager.

Advanced Purge (Repository Manager)

You can delete the older checked-in version in the Repository Manager using the Advanced Purge option as follows:
  1. Open Repository Manager.
  2. Connect to the versioned repository.
  3. Select one of the following:
    • Repository (to purge all objects in the repository)
    • Folder (to purge all objects in a folder)
    • Object (to purge one object)
  4. Choose Versioning > Advanced Purge Option.
  5. Select Active objects.
  6. Select either Older than x versions or Older than particular date or number of days

pmrep PurgeVersion (Command Line)

You can use the pmrep PurgeVersion command to purge older versions from a command prompt.


To use the PurgeVersion command, you must have the Administrator Repository privilege.


The PurgeVersion command uses the following syntax:
{-d <all | time_date | num_day> |
{-n <last_n_versions_to_keep> |
-t <time_date | num_day>}}
[-f <folder_name>]
[-q <query_name>]
[-o <output_file_name>]
[-p (preview purged objects only)]
[-b (verbose)]
[-c (check deployment group reference)]


The following example purges all versions of all deleted objects in the repository:
pmrep purgeversion -d all
The following example purges all but the latest checked-in version of objects in the folder1 folder:
pmrep purgeversion -n 1 -f folder1
The following example previews a purge of all object versions that were checked in 
before noon on January 5, 2005, and outputs the results to 
the file named purge_output.txt:
pmrep purgeversion -t '01/05/2005 12:00:00' -o purge_output.txt -p

Purge Object Version (Repository Manager)

To purge one object version do the following:
  1. Connect to the repository in Repository Manager
  2. Select the object to be purged
  3. Choose Versioning > View History option
    A pop up window will display all the versions of the selected object.
  4. Select all the versions of the object to be purged.
  5. Select Tools > Purge Object Version.
This can also be used in conjunction with the object query feature in the Repository Manager.
Please refer to the related articles below.

Tuesday, 27 December 2016

HOW TO: Recover a deleted object from a PowerCenter versioned repository

Solution :

If the PowerCenter repository is a versioned repository, it is possible to rollback changes to previous (checked-in) versions.
User gets an object (such as Mapping, Workflow or Transformation) deleted then it is no longer available through the GUI 
but all versions are still in the repository.

To recover the last version if you deleted an object you can first check if the object is still checked out:
  1. Select in the PowerCenter Client menu Versioning > Find Checkouts...
  2. Locate the deleted object, verify if it is the deleted object and restore the object through right-click > Undo Checkout
If the deleted object was already checked-in, you can recover the object by using the Repository Managers Query tool:
  1. Open in the Repository Manager's menu Tools > Queries...
  2. Create a new query at least with the filter parameter 'Version Status' 'Is Equal To' 'Deleted'
  3. You can define the query more specific if needed or use an existing one.
  4. Run the query.
  5. Locate the deleted object, example, by sorting for Time Stamp.
  6. Right-click on the object and select View History
  7. In the resulting list you should see all versions of the object. The latest one is the deleted version.
  8. Select the latest deleted version.
  9. In the menu select Tools > Purge Object Version
  10. When you then select Ok from the following dialog the version gets removed from the repository
    and the version before is active again.

Thursday, 8 December 2016

N is used to specify a unicode string

N is used to specify a unicode string.

In your example N prefix is not required because ASCII characters (with value less than 128) map directly to unicode.
However, if you wanted to insert a name that was not ASCII then the N prefix would be required.


Select N'Wahi','Wahi'