Common Error Part1

These are errors which i encountered working today..I have put solution for them with detailsError :  Scheduling Error for workflow, workflow [id = X] could not be retrieved from the repositoryReason : Your workflow and related object are not checked inSolution : Checkin workflow and related objectsError :  Schedule Workflow: ERROR: Workflow [wf_name]: Workflow not scheduledReason :   Your are using resuable scheduler and it is not checked inSolution :  Checkin resuable schedulerError :  Input sources to SQ SQ_TRADE have...

Read More

How to change the mapping associated in the session:

Often during development cycle we come across scenario when you have to change session’s existing mapping with a new one.Informatica should have provided a direct option to choose new mapping unfortunately it is not straight forward you can follow below method to achieve this 1. Invalidate the current mapping temporarily and refresh the session. This would allow you to choose a different mapping for your session. Pick the new one.2. XML export. Export the session object and then edit the xml file where you need to change the mapping name. Now when...

Read More

How to pass a mapping value of mapping variable to workflow and worklet

Normally we come across various scenarios where have to use value from inside of mapping as session or workflow/worlklet variable.Two scenarios I can think of 1.       You have to use sessstarttime in sending attached files by email in email task. You can’t do it normally as sessstart time is not available in email task.2.       You have a mapping to capture errors in mapping and you...

Read More