Home » RDBMS Server » Server Utilities » Ora errors while calling a funtion
Ora errors while calling a funtion [message #237574] Tue, 15 May 2007 00:01 Go to next message
amarnath.gorantla
Messages: 1
Registered: May 2007
Junior Member
Hi Guru's,

Help me out please

TRANSF_1_1_1_1> Sat May 12 01:28:07 2007
TRANSF_1_1_1_1> CMN_1022 Database driver error...
CMN_1022 [
ORA-20051: FN_EXEC_3000_LKP_FUNC : Unable to Create Lookup SQLORA-20051:
FNL_V_FI_POSTADDRS_RSK_ST : Unable to Create Lookup SQLORA-12801: error
signaled in parallel query server P022
ORA-00600: internal error code, arguments: [kghpih:ds], [0x41B265BE8], [],
[], [], [], [], []
ORA-06512: at "INFOPROD_CLM_OBJECT_BATCH_PROD.FN_EXEC_3000_LKP_FUNC", line
87
ORA-06512: at line 2

Database driver error...
Function Name : ExecuteSP

Oracle Fatal Error
Database driver error...
Function Name : ExecuteSP

Oracle Fatal Error]
TRANSF_1_1_1_1> Sat May 12 01:28:07 2007
TRANSF_1_1_1_1> TE_7007 Transformation Evaluation Error; current row
skipped...
TE_7007 [<<Expression Fatal Error>> [f::SP.fn_FN_EXEC_3000_LKP_FUNC]:
widget execution failed
...
f::SP.fn_FN_EXEC_3000_LKP_FUNC(u:'FNL_V_FI_POSTADDRS_RSK_ST',u:'LKP_V_FI_POSTADDRS_RSK_ST',u:'Y',u:'FNL_V_FI_POSTADDRS_RSK_ST')]
TRANSF_1_1_1_1> Sat May 12 01:28:07 2007
TRANSF_1_1_1_1> TM_6085 A transform encountered fatal error. Terminating
session.
TRANSF_1_1_1_1> DBG_21082 exp_CALL_3000A_LKP_FUNC: : Current Input data:
TRANSF_1_1_1_1> CMN_1053 Input row from exp_GET_FIELDS: Rowdata: (
RowType=0 Src Rowid=15 Targ Rowid=15
flg_STAT_FLG (flg_STAT_FLG:UniChar.1:): "Y"
flg_SANITY_CHECK (flg_SANITY_CHECK:UniChar.1:): "N"
flg_AUTO_FLG (flg_AUTO_FLG:UniChar.1:): "Y"
EXEC_SEQ (EXEC_SEQ:Double:): "98.00000000000000"
LKP_SP_FN_NAME (i_LKP_SP_FN_NAME:UniChar.100:):
"FNLR_AGG_EXP_MJR_RSN_CD_RST3"
LKP_TBL_NAME (i_LKP_TBL_NAME:UniChar.100:): "LKR_AGG_EXP_MJR_RSN_CD_RST3"
STATUS (i_STATUS:UniChar.1:): "N"
EXEC_LVL (EXEC_LVL:Double:): "1.000000000000000"
)

TRANSF_1_1_1_1> CMN_1053 Input row from lkp_V_CTL_3000A_LKP_EXEC_STAT:
Rowdata: ( RowType=0 Src Rowid=15 Targ Rowid=15
LKP_SP_FN_NAME (lkp_V_CTL_3000A_LKP_EXEC_STAT_FN:UniChar.100:):
"FNL_V_FI_POSTADDRS_RSK_ST"
LKP_TBL_NAME (lkp_V_CTL_3000A_LKP_EXEC_STAT_TBL:UniChar.100:):
"LKP_V_FI_POSTADDRS_RSK_ST"
)

TRANSF_1_1_1_1> Sat May 12 01:28:07 2007
TRANSF_1_1_1_1> CMN_1086 exp_CALL_3000A_LKP_FUNC: Number of errors exceeded
threshold [1].
TRANSF_1_1_1_1> Sat May 12 01:28:07 2007
TRANSF_1_1_1_1> TM_6085 A transform encountered fatal error. Terminating
session.
TRANSF_1_1_1_1> DBG_21082 lkp_V_CTL_3000A_LKP_EXEC_STAT: : Current Input
data:
TRANSF_1_1_1_1> CMN_1053 Input row from exp_GET_FIELDS: Rowdata: (
RowType=0 Src Rowid=15 Targ Rowid=15
EXEC_SEQ (iEXEC_SEQ:Double:): "98.00000000000000"
EXEC_LVL (iEXEC_LVL:Double:): "1.000000000000000"
)

TRANSF_1_1_1_1> Sat May 12 01:28:07 2007
TRANSF_1_1_1_1> TM_6085 A transform encountered fatal error. Terminating
session.
TRANSF_1_1_1_1> DBG_21082 exp_GET_FIELDS: : Current Input data:
TRANSF_1_1_1_1> CMN_1053 Input row from sq_CTL_3000A_LKP_EXEC_STAT:
Rowdata: ( RowType=0 Src Rowid=15 Targ Rowid=15
LKP_SP_FN_NAME (LKP_SP_FN_NAME:UniChar.100:):
"FNLR_AGG_EXP_MJR_RSN_CD_RST3"
LKP_TBL_NAME (LKP_TBL_NAME:UniChar.100:): "LKR_AGG_EXP_MJR_RSN_CD_RST3"
STATUS (STATUS:UniChar.1:): "N"
EXEC_LVL (EXEC_LVL:Double:): "1.000000000000000"
)
Re: Ora errors while calling a funtion [message #237578 is a reply to message #237574] Tue, 15 May 2007 00:14 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

Ora-00600 just search on metalink or call oracle support.

Regards
Taj
Previous Topic: migrate from 10g to 9i, with LOB objects ??
Next Topic: Grouping different records using SQL Loader
Goto Forum:
  


Current Time: Thu Dec 08 10:41:33 CST 2016

Total time taken to generate the page: 0.17513 seconds