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

Questions by vishallakhotia

Showing Answers 1 - 2 of 2 Answers

Raghu

  • Mar 9th, 2012
 

Delete it

  Was this answer useful?  Yes

Vids

  • Aug 13th, 2013
 

The error seems to be DB error . First of all , check at the database level if the source and the target table are created correctly. Then using INSERT stmt , try to insert a record in Oracle database. I guess , u ll get some errors here . try to rectify them and then run the workflow. Lets know if it works or any other error

  Was this answer useful?  Yes

Gatla Dileep reddy

  • Feb 16th, 2015
 

it is a DB issue, If the Session failed in middle just try to recover the workflow.

  Was this answer useful?  Yes

Give your answer:

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

 

Related Answered Questions

 

Related Open Questions