About Me

Anjum Ara I am a technology enthusiast, an ardent reader. My latest interest is virtualization. In my free time, I love understanding child nutrition, child holistic development. I bake, read, paint, and do whatever it takes to improve myself every day.

Sunday, February 21, 2016

HPCM Stage Balancing does not connect with SmartView

Written by   on   in , , ,   with No comments
Issue: Unable to launch Smart View from HPCM Stage Balance page.  When you click on stage balance , it should launch a excel .

Reason: After a lot of research , SR with Oracle we were not able to reach anywhere. When I started comparing my internal server with the client server , I realised my internal server works perfectly fine.  Suspecting it to be a port issue I spent hours finding it. After multiple comparison here is my observation

Solution: HPCM 11.1.2.4 Stage balance tables work fine when accessing through IE 10.
This functionality does not support IE 11 and Firefox.
 I tried the same on my internal server and came to conclusion that it works on IE 10 currently.
We have raised a bug with Oracle . I hope we get a solution quickly.


Update 10/March/2016
I forgot to add that a few days later we tried to dig in more and found out that it was working IE 11 and the issue was with the proxy and not with the browser.
I remember a Hindi saying in situations like this "Khoda pahad nikla chuha". (Dug a mountain to find a tiny rat). 
I think situations like this are also important they remind us however big the problem is , solution is always simple.






Share:

FDMEE Data Rule Status Change

Written by   on   in , , , , , ,   with No comments
Issue: 
FDMEE Data Rule does not show Completed status . The data rule hangs in the running state forever.
Checking the ODI operator or process details reveals that the rule was successfully completed.

Tried updating many tables in the Oracle DB: AIF_PROCESSES and AIF_PROCESS_DETAILS but this does not contain data for Data Rule Summary Page.
Finally found that AIF_BALANCE_RULES table impacts the Data Rule Summary page.

To fix this:
  • Connect to the Database . 
  • Connect to the FDMEE Schema
  • Update the  particular field using below query 
SELECT PROCESS_ID FROM  AIF_BALANCE_RULES WHERE STATUS='RUNNING';
  • Note the process_id and update the status
UPDATE "HYP_FDMEE"."AIF_BALANCE_RULES" SET STATUS = 'SUCCESS' WHERE PROCESS_ID = '<PROCESS_ID>'



 


The link that really helped me solve this - https://community.oracle.com/thread/3891226 

This provides alternative solutions to this issue. 
Share:

Saturday, February 20, 2016