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.
- 2 Answers
- 6943 Views
- I also Faced
- E-Mail Answers
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
How to update or delete the rows in a target, which do not have key fields?
what is song in infrmatica...?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Sequence generator, when you move from develoment to production how will you reset
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is the difference between informatica 7.0 and 8.0?
Explain pushdown optimization $pushdownconfig parameter - informatica
State the limitations where we cannot use joiner in the mapping pipeline?
What is a pre-defined event and user-defined event?
what is the size of your data warehousing?
How do we call shell scripts from informatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is informatica metadata and where is it stored?
Explain dynamic target flat file name generation in informatica
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
