Can not load JVM library.Check if Java runtime environment is installed properly after applying Informatica 10.2.0 Hotfix2

we are working with Informatica Power center 10.2.0 version in Windows platform.We got a requirement to upgrade 10.2.0 to 10.2.0 hotfix2.We have applied 10.2.0 hotfix2 server to the existing Informatica 10.2.0 server.After applying the Informatica 10.2.0 hotfix2,we faced issue with Informatica services.We are not able to up  informatica services.we got the below error while trying to start Informatica services.

"The Informatica 10.2.0 services on local computer are started and then stopped.Some services stopped automatically if they are not in use by other services or programs".


Cause: Informatica used java from Oracle up-to 10.2.0 version.From 10.2.0 Hotfix version onwards,Informatica start using JDK Opensource.After applying 10.2.0 Hotfix2 to existing Informatica 10.2.0 version,it did not update the registry entries of Java home as it is already existed.


Java Home Path in Informatica 10.2.0 version:

Command prompt->regedit

HKEY_LOCAL_MACHINE->System->CurrentControlset->Services->Informatica 10.2.0 ->Parameters->JavaHome ->C:\Informatica 10.2.0\Java\Jre

The above path needs to change After applying the Informatica 10.2.0 Hotfix2

Java Home Path in Informatica 10.2.0 Hotfix2 version:

HKEY_LOCAL_MACHINE->System->CurrentControlset->Services->Informatica 10.2.0 ->Parameters->JavaHome ->C:\Informatica 10.2.0\Java

Issue will resolve after updating the path.

How to check the status of node manger and to kill the node manager.

Below commands are used to check the running applications.

check using ps -ef | grep weblogic to see if any weblogic services left running.

check using ps -ef | grep node to see if any nodemanager services left running.

Below commands are used to kill the node manager and weblogic.

 kill -9 PID to kill them (PID is first number in ps -ef)

 

ORA-01840: input value not long enough for date format

Issue: when we create a virtual column with DATE datatype,we should have the proper value for the physical column.
Ex:We created a virtual column X_CAL_WEEK_END_DT based on the physical column CAL_WEEK_END_DT_WID.

CAL_WEEK_END_DT_WID having the date values in the following formate YYYYMMDD.But one value has 0.Without knowing the value of zero(0),we created Virtual column with below script

ALTER TABLE w_day_d ADD x_CAL_WEEK_END_DT GENERATED ALWAYS AS (TO_DATE(TO_CHAR("CAL_WEEK_END_DT_WID"),'yyyymmdd'))  VIRTUAL;

The above alter script can not covert the value ZERO(0) to DATE.

FIX:Changed the alter script like below.
ALTER TABLE w_day_d ADD x_CAL_WEEK_END_DT GENERATED ALWAYS AS (CASE  WHEN "CAL_WEEK_END_DT_WID"<>0 THEN TO_DATE(TO_CHAR("CAL_WEEK_END_DT_WID"),'yyyymmdd') END)  VIRTUAL;

ORA-00938: not enough arguments for function

Issue:Coalesce function is uesd in the map without placing sufficient arguments.
Ex:COALESCE(
(CASE
WHEN
 SQ_W_MCAL_PERIOD_D.ADJUSTMENT_PERIOD_FLG = 'Y' THEN
 SQ_W_MCAL_PERIOD_D.MCAL_PRIOR_PERIOD_WID
ELSE
 LKP_PERIOD_PRIOR.ROW_WID

END )
)  AS MCAL_PRIOR_PERIOD_WID

Fix:For example if we miss the replacing value in the COALESCE function then will get this error.So we need to place arguments properly.
 Ex:
 COALESCE(
(CASE
WHEN
 SQ_W_MCAL_PERIOD_D.ADJUSTMENT_PERIOD_FLG = 'Y' THEN
 SQ_W_MCAL_PERIOD_D.MCAL_PRIOR_PERIOD_WID
ELSE
 LKP_PERIOD_PRIOR.ROW_WID

END )
,0)  AS MCAL_PRIOR_PERIOD_WID

TO_DATE_WID function in ODI

TO_DATE_WID function is used to convert the DATE(07/24/2015) to DATE_WID(20150724)(YYYYMMDD) in ODI.

How to write sql query in ODI

There are two possible ways to use sql query as a source.
1)Using knowledge module as SQL AS SOURCE
2)Using the property as OBI_SOURCE_SQL_OVERRIDE in the knowledge module IKM BIAPPS Oracle Control Append(this KM will be available in Biaaps11.1.1.8.1,etc...).

                                      Steps to Implement this scenario using BIApps Knowledge Module
                                  --------------------------------------------------------------------------
Step 1:Create temp interface
Step2:Create a temp table with the required columns in the interface like below.

Step3:Click on flow tab-->select knowledge module as IKM BIAPPS Oracle Control Append or IKM BIAPPS Oracle Incremental Update.
Step4:Select the property as OBI_SOURCE_SQL_OVERRIDE in the knowledge module IKM BIAPPS Oracle Control Append or IKM BIAPPS Oracle Incremental Update and then write the query like below.

 Note:The number of ports in the temp table and the number of columns in the select list should be match.
Note: No need to drag any source table.Here sql query as source.
Step5:Click on save
Step6:Create a new interface and drag the temp interface in the workspace of new interface.
Step7:Drag the target datastore from the models.Click yes to auto mapping.

Step8:Click on source table then enable the property as use temporary interface as Derived table(Sub-select).

Step9:Click on flow tab then select knowledge module as IKM BIAPPS Oracle Control Append or IKM BIAPPS Oracle Incremental Update.
Step10:Click on save.
Step11:Execute the interface.

ODI-1228:Task IS_INCREMENTAL(Variable) fails on the target connection (BIAPPS 11.1.1.8.1)

Cause:Step name of IS_INCREMENTAL in package is IS_INCREMENTAL.Step name of IS_INCREMENTAL in package should be with the name Refresh IS_INCREMENTAL.

Solution:Step name of IS_INCREMENTAL in package changed from IS_INCREMENTAL to Refresh IS_INCREMENTAL.