| Autosys-OWB -Issue [message #560223] |
Wed, 11 July 2012 05:42 |
visuora@yahoo.com
Messages: 13
Registered: September 2008
|
Junior Member |
 
|
|
Hi,
Please find below error log.Could you please let me know how to resolve this and what cause this issue?
*************************************************************************
Beginning saas_annd1_stg_spike_TBLEX_TOUCH at : Wed Jul 11 04:16:22 EDT 2012
*************************************************************************
Accepting Input Parameters .......................................
Initializing AutoSys Variables for Processing ..................
=========================================================================
= Run Number is ....: 42655661
= Job Name is ......: saas_annd1_stg_spike_TBLEX_TOUCH
= Job is in Box Name: saas_annd1_stg_SPIKE
= Using Profile ....: /export/home/pabatchd/var/saas_annd1.profile
= Job Uses Calendar : n/a
= Run Days .........: n/a
= Waited For File ..: n/a
= Starting Condition: n/a
= Standard Out .....: $Std_Out/STG_TBLEX_TOUCH.log
= Standard Err .....: $Std_Out/STG_TBLEX_TOUCH.err
=========================================================================
End Of Auto Sys Variable Initialization .......................
Connecting To Database .........................................: stgsrd01
Connect As User ................................................: OWB_ACC
Rutime Owner ...................................................: OWB_RUN
Location Name ..................................................: LOC_PHASE1_STAGING_A
Task Type ......................................................: PLSQL
Task Name ......................................................: MAP_TBLEX_SP_TOUCH_TBL_TOUCH
Auto-Retry is set to ...........................................: 0
Current Run Number is set to ...................................: 11
Autosys Job Name is set to .....................................: saas_annd1_stg_spike_TBLEX_TOUCH
Autosys Run Number is set to ...................................: 42655661
Checking For System Parameter Overrides from Database ...........
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Jul 11 04:16:22 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Enter user-name:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
OWB_ACC@stgsrd01> 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57
PL/SQL procedure successfully completed.
OWB_ACC@stgsrd01>Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Checking for Existing of System Variable File ...................
Variable File Name is ..........................................: /export/home/pabatchd/VFILES/owb_MAP_TBLEX_SP_TOUCH_TBL_TOUCH_stgsrd01_params.var
!!! WARNING ...................................................
System Variable Definition File Found BUT Empty ............
No Sys Vars Will Be Passed in ..............................
Running With Command String Below ...............................
/export/home/pabatchd/scripts/run_owb_map.sql OWB_RUN LOC_PHASE1_STAGING_A PLSQL MAP_TBLEX_SP_TOUCH_TBL_TOUCH saas_annd1_stg_spike_TBLEX_TOUCH 42655661 "," ","
Submitting OWB Map .............................................: MAP_TBLEX_SP_TOUCH_TBL_TOUCH
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Jul 11 04:16:22 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Enter user-name:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
OWB_ACC@stgsrd01>
Session altered.
Role set.
Stage 1: Decoding Parameters
........ Task Type ..........: PLSQL
........ Task Name ..........: MAP_TBLEX_SP_TOUCH_TBL_TOUCH
........ Location Name ......: LOC_PHASE1_STAGING_A
........ Autosys Job Name ...: saas_annd1_stg_spike_TBLEX_TOUCH
........ Autosys Job ID .....: 42655661
.
Stage 2: Opening Task
........ LOC_PHASE1_STAGING_A-->PLSQL-->MAP_TBLEX_SP_TOUCH_TBL_TOUCH ....
........ Execution Id ......: 149839
.
Stage 3: Overriding Default Parameters
........ System Parameters ..: None
........ Custom Parameters ..: None
.
Stage 4: Executing Task .....: 149839
........ Return Status ......: 3 (FAILURE)
.
Stage 5: Closing Task
.
Stage 6: Processing Result
.
Stage 7: Updating Autosys Execution Table
........ Updating OWB_AUTOSYS_EXECUTIONS Table with Run Info
........ Exiting With Code ..: 3
PL/SQL procedure successfully completed.
DISPLAYING JOB/MAP PROCESSING SUMMARY ........................
no rows selected
DISPLAYING ERROR MESSAGES IF ENCOUNTERED DURING RUN ..........
no rows selected
RunTimeExecID : RT_EXE_ID
RunTimeErrorID : RT_ERR_ID
MapName :
DISPLAYING EXECUTION MESSAGES IF FOUND .......................
no rows selected
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Checking Return Code From SqlPlus ...............................
Completed OWB Map ..............................................: MAP_TBLEX_SP_TOUCH_TBL_TOUCH
Completion Status of OWB Map ...................................: 3
Completion Status of Job .......................................: UNSUCCESSFUL
Exit Status for AutoSys ........................................: 1
Sending Email on Job Status .....................................
Job Ended With Status of .......................................: UNSUCCESSFUL
Sending Log File ................................................
OWB Web Broswer Link ............................................
OWB Audit Browser Entry for Run .................................
*************************************************************************
saas_annd1_stg_spike_TBLEX_TOUCH Completed at : Wed Jul 11 04:16:23 EDT 2012
*************************************************************************
</PRE></BODY></HTML>
Cleaning Up Old Mail File .......................................
Cleaning Up Old Variable File ...................................
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
