Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

hi all when i am creating repository contents i am getting
this error and not able to create contents please let me
know wht may be the problem
ORA-01031: insufficient privileges

Database driver error...
Function Name : executeDirect
SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT
DISTINCT
DBDNAM DATABASE_NAME,
SRCNAM DEF_SOURCE,
SUBJ_NAME SUBJECT_AREA,
NULL VERSION_ID,
OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER
FROM OPB_DBD, OPB_SUBJECT, OPB_SRC
WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND
OPB_SRC.DBDID = OPB_DBD.DBDID AND
OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND
OPB_SRC.IS_VISIBLE = 1

Oracle Fatal Error
Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
Error occurred while creating the repository
An error has occurred while creating contents. Dropping
repository tables...
Create Contents operation on repository [reposerv] ended at
01/02/2009 13:02:48. Elapsed time is 0:00:09.

Question Posted / ganesh

Answer Posted / ganesh

This error message appears when the user prilliges is not
given. First start the repository service. Then, open the
Admin console, then check repository, integration and
reporting services are running. Then, click on the Domain
name and then give access to the user account by checking
all the above services. Then, restart the computer. Now,
check the repository is running with out error message.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1006

What does reusable transformation mean?

1130

Difference between Data and Index Caches?

1135

What are the designer tools for creating transformations?

1112

Slowly changing dimensions, types and where will you use them

1709

How identifying bottlenecks in various components of informatica and resolving them?

1125

What is resilience time?

1130

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1289

Can we create a node as a gateway node and the same node can be assigned to a grid?

1075

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1161

Explain why we use partitioning the session in informatica?

1086

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1998

what is the Default Source Option For Update Strategy Transformation?

1231

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7180

COM components can be used in Informatica

2382