Environment
Novell ZENworks 7.5 Asset Management - ZAM7.5
Novell ZENworks 7 Asset Management - ZAM7
Oracle Database version 9 or 10
Situation
During the Software Compliance portion of updating the PRU, it fails with an error "PRU Error"
Resolution
Increase the size of the UNDO Tablespace .
Additional Information
Updating the Software compliance table during the PRU process is usually the lengthiest portion of the process, happens as one of the last processes during the PRU and can substantially increase the growth of the Undo table.
The error message seen is a very general message. You will need to first look within the TSCMgrEvent<date>.log file. If you see an error referencing the LC_Post_PRU procedure, then you will need to turn on Persistor diagnostic logging for the ZAM Manager.
You do so by creating a key named Database under HKEY_LOCAL_MACHINE\SOFTWARE\Tally Systems Corp.\TSCensus. Highlight the key and create a new DWORD value named DiagnosticLogging. Set the value to 1. Restart the Manager.
You will then need to retry the PRU. When it fails you can view the Manager Persistor log which will be within the Manager's \Logs directory with the file name of ServerName-DatabaseName-Date.Log.
If space is the issue you will see an error within the log similar to this:
" Error2: 1Message2: [Oracle][ODBC][Ora]ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1' "
If you see this error then you will need to run the below query run in the system user context:
select file_name, bytes, autoextensible, maxbytes
from dba_data_files
where tablespace_name='UNDOTBS1'
from dba_data_files
where tablespace_name='UNDOTBS1'
This query will tell you the status of the table and indicate whether the table needs to be set to autoExtend and grow or the Database administrator will need to set a new size to the Undo table.