Setting up ODI Lineage package

Asked By daniel murdoch 0 points N/A Posted on - 03/09/2012

Hi,

Whenever I try to set up ODI lineage package it ends up in the following error screen:

Error

 

ODI-50036: Error creating V_LINEAGE_HIERARCHY Table. Check the logs.

Is there a possible solution for this?

Thanks in advance.

• Status: Open
• Question Views: 1100
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Development Software

Answered By Tunacao_Caaron1 20 points N/A #108418

Setting up ODI Lineage package

Hey Daniel!

Your problem reminds me of last month when I was trying to set up my ODI Lineage Package I got the same error. I can not to forget I spend my whole night to resolve it. First I Google it and search it on the internet, there was not much information about this problem.

Then I made a call to one of my friend who had set up the ODI lineage Package. He guide me and I was succeeded to set up my ODI lineage Package.

So what you have to do is to run the following script from your DBA

grant create view to snpm1;
grant create view to snpw1;

Your problem will be solved.

Thanks.

About Tunacao_Caaron1

Questions
1

Answers
399

Best Answers
138

• Vote Up 0 Vote Down

• Posted on - 03/11/2012
• Question Category: Development Software