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

How to update or delete the rows in a target, which do not have key fields?

651

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1734

have u done any performance tuning? how u ll do?

1857

r u done any partitions in ur project?

1407

What is rank transform?

601




What are the informatica performance improvement tips

615

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

537

Separate from an archive server and a powerhouse?

493

What is standalone command task?

711

To import the flat file definition into the designer where should the flat file be placed?

677

What is the benefit of session partitioning?

595

Please let me know how to make Data masking in informatica..

1269

How many input parameters can exist in an unconnected lookup?

992

Enlist the tasks for which source qualifier transformation is used.

588

What is an active transformation?

648