Error on Auto execute of a job.

Johnsone,

This job does not even show on my cronjobs as a number...therefore I cannot even tell what its doing. I am not sure if its just a sequence number given by the system all something...I can only see the error on the alert.log file but thats it. How can I go about it...any ideas? Thx!

Cheers,
V.

Johnsone,

When you say it's a user defined error...does that mean its an application issue...not database and I should consult the Developers? Thx!

Cheers,
V.

In PL/SQL the code can raise it's own error.  Oracle has reserved a series of error numbers for this purpose.  The range starts at 20000 and goes from there (I forget the upper number).  This allows developers to create custom error messages when something goes wrong.

Yes, I think you need to contact the developers.  It still may be a problem with the database but you need to know what that error means.  If it will take a while to get hold of the developers, you can pull out the source yourself by querying the DBA_SOURCE table ( unless the developers 'wrapped' the code ).

select text from dba_source where name = '<name of procedure>' order by line;

The job can be found in DBA_JOBS.  

select * from dba_jobs
where job = 50160;

That should give you the information on the job.

I believe the errors will not be in the alert.log.  If I remember correctly, they are in the same directory as the alert.log and the naming convention varies by OS but they should contain snp in the file name.

Like slightwv says, it could be application or database related, without the code to what it is doing we have no idea what the error actually means.  It is not an Oracle error it is an error created and raised by the procedure and the text of the error message can be anything you want.

How do I know the name of the procedure? This is the whole error message...I missed out on a few things...sorry! Thx.

ORA-12012: error on auto execute of job 50160
ORA-20000: ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1338
ORA-06512: at "SYS.DBMS_SPACE", line 1554

Cheers,
V.

Johnsone,

I got this result...not good. Maybe I need to check with Developers?

SQL> select * from dba_jobs
  2  where job = 50160;

no rows selected

Cheers,
V.

Give this a try:
select job,what,failures from dba_jobs;

See what is in DBA_JOBS.  Something had to run from there to generate this error.

select job, what from dba_jobs;

Yes...there were 8 rows selected...but its still hard to tell the one connected to the "50160" number. My OS is AIX and the file you had mentioned earlier on is .trc file (for example vic_j000_1184198.trc). That is the one that has the whole error like I sent to you. Thx.

Cheers,
V.

Johnsone,

Waiting on Developers to respond...I sent them the job error # since we don't have the code. I'll keep you posted. Thx!

Cheers,
V.

I spoke with Developers and they knew about the job...there was an interface problem. A table needed a clean up in order for the job to resume prcessing again. Thank you for your help.

Cheers,
V.