Oracle error in ZAM - Unable to increase temp segment by 128 in tablespace TSCTEMP

  • 3598540
  • 28-Mar-2007
  • 16-Mar-2012

Environment

Novell ZENworks Asset Management 7 - ZAM7

Situation

Software compliance report on all license records and filtering by Microsoft. The report runs but when they try to drill down into Unused installations they get the above error message.

Oracle error in ZAM:
Unable to increase temp segment by 128 in tablespace TSCTEMP
Details: [ORACLE][ODBC][ORA]ORA-06512:Unable to increase temp segment by 128 in tablespace TSCTEMP

Resolution

Fixed in Interim Release 5 for ZAM 7.0
Modified SQL statements used by the Web Console to make population of the TEMP table and subsequent Select queries more efficient and faster, especially for Suite Products.
If downloading the Interim Release manually from https://download.novell.com, the filename is ZAM700SP1IR5.EXE. The Interim releases can also be set up within the ZAM Manager for the Task server to check the site on a scheduled basis, and download and apply them automatically. Please refer to the Help Section for details of how to set up automatic downloads if desired.

Each interim release is cumulative. If Interim Release 5 is not available due to a newer interim release being placed on the website, be assured that the code needed is in the later release.



Additional Information


Formerly known as TID# 10100098