| Ora errors while calling a funtion [message #237574] |
Tue, 15 May 2007 00:01  |
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"
)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
