Home » Developer & Programmer » Warehouse Builder » Autosys-OWB -Issue (OWB,10.02 ,Windows)
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 ...................................

Previous Topic: OWB upgrade from 10gR2 to 11g R2 and Migration of OWB from Solaris to linux
Next Topic: Help! column incompatibility issue during data migration sqlserver-oracle
Goto Forum:
  


Current Time: Fri Apr 18 13:40:55 CDT 2014

Total time taken to generate the page: 0.14679 seconds