Solved - Command Task to invoke Procedure with multiple arguments/Parameters

Refer the following link in case Command Task completes without any error but doesn't invoke the procedure.

http://dbsqlserverdb.blogspot.com.au/2018/01/solved-incorrect-syntax-near-cmd-c.html

Solved -execution of command did not complete successfully with exit code [255] - Informatica

A command task invokes a batch script which could be doing anything and has ECHO or REM statements. The workflow fails with the following error in workflow log:

LM_36623 : Command task instance [cmd_SFTP_command]: execution of command [Command1] did not complete successfully with exit code [99840]

Or

LM_36623 : Command task instance [cmd_SFTP_command]: execution of command [Command1] did not complete successfully with exit code [255]

Cause

This occurs when the batch script containing the SFTP connection contains REM and ECHO statements which causes the command task to fail. This is a known issue and CR 203903 exists.

Solution

To run the task remove the REM and ECHO statements from the batch script and start the batch script from the command task.

refer the below link

https://kb.informatica.com/solution/12/Pages/105547.aspx

Solved - Repository SQL to Find all Checked out Objects - Informatica

Use below SQL to find All Informatica Checked Out Objects.

SELECT s.SUBJ_NAME,
       P.OBJECT_NAME,
       oot.OBJECT_TYPE_NAME,
       P.LAST_SAVED,
       CAST (P.COMMENTS AS nvarchar(MAX)) COMMENTS,
            U.NAME USER_NAME,
            P.SAVED_FROM HOST_NAME
FROM OPB_TASK O,
     OPB_VERSION_PROPS P,
     OPB_SUBJECT S,
     OPB_USER_GROUP U,
     OPB_OBJECT_TYPE oot
WHERE O.IS_VISIBLE = 2
  AND P.SUBJECT_ID = S.SUBJ_ID
  AND P.USER_ID = U.ID
  AND U.TYPE = 1
  AND P.SUBJECT_ID = O.SUBJECT_ID
  AND P.OBJECT_ID = O.TASK_ID
  AND P.VERSION_NUMBER = O.VERSION_NUMBER
  AND P.OBJECT_TYPE = O.TASK_TYPE
  AND O.IS_REUSABLE=1
  AND oot.OBJECT_TYPE_ID = P.OBJECT_TYPE
UNION
SELECT s.SUBJ_NAME,
       P.OBJECT_NAME,
       oot.OBJECT_TYPE_NAME,
       P.LAST_SAVED,
       CAST (P.COMMENTS AS nvarchar(MAX)) COMMENTS,
            U.NAME USER_NAME,
            P.SAVED_FROM
FROM OPB_SESSION_CONFIG O,
     OPB_VERSION_PROPS P,
     OPB_SUBJECT S,
     OPB_USER_GROUP U,
     OPB_OBJECT_TYPE oot
WHERE O.IS_VISIBLE = 2
  AND P.SUBJECT_ID = S.SUBJ_ID
  AND P.USER_ID = U.ID
  AND U.TYPE = 1
  AND P.SUBJECT_ID = O.SUBJECT_ID
  AND P.OBJECT_ID = O.CONFIG_ID
  AND P.VERSION_NUMBER = O.VERSION_NUMBER
  AND P.OBJECT_TYPE = 72
  AND oot.OBJECT_TYPE_ID = P.OBJECT_TYPE
UNION
SELECT s.SUBJ_NAME,
       P.OBJECT_NAME,
       oot.OBJECT_TYPE_NAME,
       P.LAST_SAVED,
       CAST (P.COMMENTS AS nvarchar(MAX)) COMMENTS,
            U.NAME USER_NAME,
            P.SAVED_FROM
FROM OPB_SCHEDULER O,
     OPB_VERSION_PROPS P,
     OPB_SUBJECT S,
     OPB_USER_GROUP U,
     OPB_OBJECT_TYPE oot
WHERE O.IS_VISIBLE = 2
  AND P.SUBJECT_ID = S.SUBJ_ID
  AND P.USER_ID = U.ID
  AND U.TYPE = 1
  AND P.SUBJECT_ID = O.SUBJECT_ID
  AND P.OBJECT_ID = O.SCHEDULER_ID
  AND P.VERSION_NUMBER = O.VERSION_NUMBER
  AND P.OBJECT_TYPE = 69
  AND O.IS_REUSABLE=1
  AND oot.OBJECT_TYPE_ID = P.OBJECT_TYPE
UNION
SELECT s.SUBJ_NAME,
       P.OBJECT_NAME,
       oot.OBJECT_TYPE_NAME,
       P.LAST_SAVED,
       CAST (P.COMMENTS AS nvarchar(MAX)) COMMENTS,
            U.NAME USER_NAME,
            P.SAVED_FROM
FROM OPB_MACRO O,
     OPB_VERSION_PROPS P,
     OPB_SUBJECT S,
     OPB_USER_GROUP U,
     OPB_OBJECT_TYPE oot
WHERE O.IS_VISIBLE = 2
  AND P.SUBJECT_ID = S.SUBJ_ID
  AND P.USER_ID = U.ID
  AND U.TYPE = 1
  AND P.SUBJECT_ID = O.SUBJECT_ID
  AND P.OBJECT_ID = O.MACRO_ID
  AND P.VERSION_NUMBER = O.VERSION_NUMBER
  AND P.OBJECT_TYPE = 106
  AND oot.OBJECT_TYPE_ID = P.OBJECT_TYPE
UNION
SELECT s.SUBJ_NAME,
       P.OBJECT_NAME,
       oot.OBJECT_TYPE_NAME,
       P.LAST_SAVED,
       CAST (P.COMMENTS AS nvarchar(MAX)) COMMENTS,
            U.NAME USER_NAME,
            P.SAVED_FROM
FROM OPB_SHORTCUT O,
     OPB_VERSION_PROPS P,
     OPB_SUBJECT S,
     OPB_USER_GROUP U,
     OPB_OBJECT_TYPE oot
WHERE O.IS_VISIBLE = 2
  AND P.SUBJECT_ID = S.SUBJ_ID
  AND P.USER_ID = U.ID
  AND U.TYPE = 1
  AND P.SUBJECT_ID = O.SUBJECT_ID
  AND P.OBJECT_ID = O.OBJECT_ID
  AND P.VERSION_NUMBER = O.VERSION_NUMBER
  AND P.OBJECT_TYPE = O.OBJECT_TYPE
  AND P.OBJECT_TYPE IN (25,
                        1,
                        24,
                        23,
                        44,
                        30,
                        31,
                        21,
                        20,
                        106,
                        69,
                        72,
                        82)
  AND oot.OBJECT_TYPE_ID = P.OBJECT_TYPE
UNION
SELECT s.SUBJ_NAME,
       P.OBJECT_NAME,
       oot.OBJECT_TYPE_NAME,
       P.LAST_SAVED,
       CAST (P.COMMENTS AS nvarchar(MAX)) COMMENTS,
            U.NAME USER_NAME,
            P.SAVED_FROM
FROM OPB_MAPPING O,
     OPB_VERSION_PROPS P,
     OPB_SUBJECT S,
     OPB_USER_GROUP U,
     OPB_OBJECT_TYPE oot
WHERE O.IS_VISIBLE = 2
  AND P.SUBJECT_ID = S.SUBJ_ID
  AND P.USER_ID = U.ID
  AND U.TYPE = 1
  AND P.SUBJECT_ID = O.SUBJECT_ID
  AND P.OBJECT_ID = O.MAPPING_ID
  AND P.VERSION_NUMBER = O.VERSION_NUMBER
  AND P.OBJECT_TYPE = 21
  AND O.REF_WIDGET_ID=0
  AND oot.OBJECT_TYPE_ID = P.OBJECT_TYPE
UNION
SELECT s.SUBJ_NAME,
       P.OBJECT_NAME,
       oot.OBJECT_TYPE_NAME,
       P.LAST_SAVED,
       CAST (P.COMMENTS AS nvarchar(MAX)) COMMENTS,
            U.NAME USER_NAME,
            P.SAVED_FROM
FROM OPB_MD_DIMENSION O,
     OPB_VERSION_PROPS P,
     OPB_SUBJECT S,
     OPB_USER_GROUP U,
     OPB_OBJECT_TYPE oot
WHERE O.IS_VISIBLE = 2
  AND P.SUBJECT_ID = S.SUBJ_ID
  AND P.USER_ID = U.ID
  AND U.TYPE = 1
  AND P.SUBJECT_ID = O.SUBJECT_ID
  AND P.OBJECT_ID = O.DIMENSION_ID
  AND P.VERSION_NUMBER = O.VERSION_NUMBER
  AND P.OBJECT_TYPE = 31
  AND oot.OBJECT_TYPE_ID = P.OBJECT_TYPE
UNION
SELECT s.SUBJ_NAME,
       P.OBJECT_NAME,
       oot.OBJECT_TYPE_NAME,
       P.LAST_SAVED,
       CAST (P.COMMENTS AS nvarchar(MAX)) COMMENTS,
            U.NAME USER_NAME,
            P.SAVED_FROM
FROM OPB_MD_CUBE O,
     OPB_VERSION_PROPS P,
     OPB_SUBJECT S,
     OPB_USER_GROUP U,
     OPB_OBJECT_TYPE oot
WHERE O.IS_VISIBLE = 2
  AND P.SUBJECT_ID = S.SUBJ_ID
  AND P.USER_ID = U.ID
  AND U.TYPE = 1
  AND P.SUBJECT_ID = O.SUBJECT_ID
  AND P.OBJECT_ID = O.CUBE_ID
  AND P.VERSION_NUMBER = O.VERSION_NUMBER
  AND P.OBJECT_TYPE = 30
  AND oot.OBJECT_TYPE_ID = P.OBJECT_TYPE
UNION
SELECT s.SUBJ_NAME,
       P.OBJECT_NAME,
       oot.OBJECT_TYPE_NAME,
       P.LAST_SAVED,
       CAST (P.COMMENTS AS nvarchar(MAX)) COMMENTS,
            U.NAME USER_NAME,
            P.SAVED_FROM
FROM OPB_WIDGET O,
     OPB_VERSION_PROPS P,
     OPB_SUBJECT S,
     OPB_USER_GROUP U,
     OPB_OBJECT_TYPE oot
WHERE O.IS_VISIBLE = 2
  AND P.SUBJECT_ID = S.SUBJ_ID
  AND P.USER_ID = U.ID
  AND U.TYPE = 1
  AND P.SUBJECT_ID = O.SUBJECT_ID
  AND P.OBJECT_ID = O.WIDGET_ID
  AND P.VERSION_NUMBER = O.VERSION_NUMBER
  AND P.OBJECT_TYPE = O.WIDGET_TYPE
  AND O.IS_REUSABLE=1
  AND oot.OBJECT_TYPE_ID = P.OBJECT_TYPE
UNION
SELECT s.SUBJ_NAME,
       P.OBJECT_NAME,
       oot.OBJECT_TYPE_NAME,
       P.LAST_SAVED,
       CAST (P.COMMENTS AS nvarchar(MAX)) COMMENTS,
            U.NAME USER_NAME,
            P.SAVED_FROM
FROM OPB_TARG O,
     OPB_VERSION_PROPS P,
     OPB_SUBJECT S,
     OPB_USER_GROUP U,
     OPB_OBJECT_TYPE oot
WHERE O.IS_VISIBLE = 2
  AND P.SUBJECT_ID = S.SUBJ_ID
  AND P.USER_ID = U.ID
  AND U.TYPE = 1
  AND P.SUBJECT_ID = O.SUBJ_ID
  AND P.OBJECT_ID = O.TARGET_ID
  AND P.VERSION_NUMBER = O.VERSION_NUMBER
  AND P.OBJECT_TYPE = 2
  AND TBL_TYPE = 0
  AND oot.OBJECT_TYPE_ID = P.OBJECT_TYPE
UNION
SELECT s.SUBJ_NAME,
       P.OBJECT_NAME,
       oot.OBJECT_TYPE_NAME,
       P.LAST_SAVED,
       CAST (P.COMMENTS AS nvarchar(MAX)) COMMENTS,
            U.NAME USER_NAME,
            P.SAVED_FROM
FROM OPB_SRC O,
     OPB_VERSION_PROPS P,
     OPB_SUBJECT S,
     OPB_USER_GROUP U,
     OPB_OBJECT_TYPE oot
WHERE O.IS_VISIBLE = 2
  AND P.SUBJECT_ID = S.SUBJ_ID
  AND P.USER_ID = U.ID
  AND U.TYPE = 1
  AND P.SUBJECT_ID = O.SUBJ_ID
  AND P.OBJECT_ID = O.SRC_ID
  AND P.VERSION_NUMBER = O.VERSION_NUMBER
  AND P.OBJECT_TYPE = 1
  AND oot.OBJECT_TYPE_ID = P.OBJECT_TYPE

Solved - unable to fetch log error in Informatica

unable to fetch log.

[CORE_003][CORE-003] An internal exception occurred with message: [LGS_10052] The Log Service has no record of the requested session or workflow run.\n

Quick Solution - Check Workflow logs instead - This mostly happens when the session was never started, workflow logs will have a reason as to why the session was not triggered.

Check your Parm files, probably something could be missing there which caused session not to start properly

This message is due to the fact that the session didn't start and thus Informatica is not able to locate the associated log files.

If you review your Workflow log file then you should be able to see why the session didn't start as expected. --- Always related to Parameters/Variables values.

I could be due to various reasons namely.

1) Missing Initial value for session Parameter.

    Implies Parameter defined in Mapping doesn't have an initial value.

2) or

    Implies Parameter/Variable is missing from Mapping or parm file.
3) or

4) or