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.
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
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Define the various join types of joiner transformation?
scenario where i can use only concurrent execution of workflow.
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Why do we need informatica?
Clarify the aggregator change?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is fact table? Explain the different kinds of facts.
can any one give some examples for pre sql and post sql(Except dropping and creating index).
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
tell me 5 session failure in real time how can you solve that in your project?
Explain the aggregator transformation?
How can we use mapping variables in informatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?