GeekInterview.com
Series: Subject: Topic:
Question: 20 of 726

Informatica ERROR REP_12014 : Error occured while accessing the Registry

Hi
Iam learning informatica 8.1 ( which is what i could get my hands on)..

I am connecting to oracle 10g.
I created 2 connections to the DB using Connection --> Relational Connection Browser.
The Source and Target are the same db in this case, just diff table names. But created 2 separate connections .
I 1st created the TUTORIAL_SOURCE and then copied it to TUTORIAL_TARGET and gave it a new name.
then saved it
But when i try to retrieve now, for the TUTORIAL_TARGET I'm getting this.

DataBase error: ORA-01455: converting column overflows integer datatype ORA-01455: converting column overflows integer datatype Database driver error... Function Name : Fetch SQL Stmt : SELECT OBJECT_NAME, OBJECT_TYPE, OBJECT_SUBTYPE, USER_NAME, USER_PASSWORD2, CONNECT_STRING, CODE_PAGE, COMMENTS, OWNER_ID, GROUP_ID, LAST_SAVED, CREATE_INFO, OPB_OBJECT_ID, OBJVERSION, COMP_VERSION FROM OPB_CNX WHERE OBJECT_ID = ?

I can see some data in the table and I have an idea about the offending column
The structure of the table is

SQL> desc OPB_CNX ;
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
OBJECT_ID NUMBER
OBJECT_TYPE NUMBER
OBJECT_NAME VARCHAR2(240)
OBJECT_SUBTYPE NUMBER
USER_NAME VARCHAR2(240)
USER_PASSWORD VARCHAR2(240)
CONNECT_STRING VARCHAR2(240)
CODE_PAGE NUMBER
COMMENTS VARCHAR2(2000)
OWNER_ID NUMBER
GROUP_ID NUMBER
LAST_SAVED VARCHAR2(30)
CREATE_INFO NUMBER
OPB_OBJECT_ID NUMBER
OBJVERSION NUMBER
COMP_VERSION NUMBER
USER_PASSWORD2 VARCHAR2(2000)


SQL> select object_id, object_type,object_subtype, object_name, owner_id, create_info ,code_page,opb_object_id,owner_id, group_id , last_saved,
objversion, comp_version
from opb_cnx; 2 3

OBJECT_ID OBJECT_TYPE OBJECT_SUBTYPE OBJECT_NAME OWNER_ID CREATE_INFO CODE_PAGE OPB_OBJECT_ID OWNER_ID GROUP_ID LAST_SAVED OBJVERSION COMP_VERSION
---------- ----------- -------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ---------- ----------- ---------- ------------- ---------- ---------- ------------------------------ ---------- ------------
10 73 101 TUTORIAL_SOURCE 2252 -5.355E+27 -2.01E-100 64 2252 2 ? 0 1
11 73 101 TUTORIAL_TARGET 2252 -5.355E+27 -2.01E-100 64 2252 2 ? 0 1

Can i delete them from the db and recreate them ?

Thanks in Advance
Vishal

Asked by: vishallakhotia | Member Since Oct-2011 | Asked on: Oct 20th, 2011

View all questions by vishallakhotia

Showing Answers 1 - 2 of 2 Answers

Try these and see if it helps

- Delete statics and try to retrieve.
- Try to export with INDEXES=n STATISTICS=none
- Disable auditing with "noaudit session"
SQL> noaudit session;

  
Login to rate this answer.
Raghu

Answered On : Mar 9th, 2012

Delete it

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.