Teradata SQL Error and Failure Codes from Error 10308to 10312

SQLServerF1

10308 Cannot discard an accessed segment.
Explanation: An attempt was made to discard a shared segment that is currently being accessed by other tasks.
Generated By: PDE segment subsystem.
For Whom: System Support Representative.
Notes: This event normally causes an automatic DBS restart.
The associated stack trace will help the Global Support Center determine the exact cause of the failure.
Remedy: Contact the Global Support Center.

10309 Segments exhausted or no virtual memory for segment.
Explanation: This event is caused when application runs out of segments. It can also occur if a segment could not be created
because the virtual address space of the task is full.
Generated By: PDE segment subsystem.
For Whom: System Support Representative.
Notes: This event normally causes an automatic DBS restart.
The associated stack trace will help the Global Support Center determine the exact cause of the failure.
Remedy: Contact the Global Support Center.

10310 ERRSEGRELOCATED: Segment is relocated.
Explanation: This event is returned by the segchange() service when a segment is moved to a different virtual address so
that it could be increased in size. The calling program should test for this result and react appropriately, not enter the event
in the log.
Generated By: PDE segment subsystem.
For Whom: System Support Representative.
Notes: The associated stack trace will help the Global Support Center determine the exact cause of the failure.
Remedy: This event should not appear in the log file. If it does, contact the Global Support Center.

10311 No swap space for segment.
Explanation: The system was not able to reserve anon space to back up a new segment in swap space because all available
space has already been reserved. This probably means that some program (not necessarily the one reporting the problem)
is not releasing segments when it should, or that the PDE segment subsystem is failing to properly account for freed
segments.
Generated By: PDE segment subsystem.
For Whom: System Support Representative.
Notes: This event normally causes an automatic DBS restart.
The associated stack trace will help the Global Support Center determine the exact cause of the failure.
Remedy: Verify that sufficient swap space is allocated on the system. If more space is needed, allocate one or more additional swap partitions, or increase the size of existing ones on secondary system disks. Otherwise, if the automatic DBS restart does not clear up the problem, an operating system shutdown and reboot should do so. However, this is possibly caused by a bug in DBS or PDE software, which should be reported to the Global Support
Center.

10312 Cannot allocate SDB structure for segment.
Explanation: A segment could not be created because no SDB kernel structure could be allocated for it. This indicates
PDE kernel memory saturation, either because kernel blocks are being lost, or too many system resources have been allocated.
Generated By: PDE segment subsystem.
For Whom: System Support Representative.
Notes: This event normally causes an automatic DBS restart.
The associated stack trace will help the Global Support Center determine the exact cause of the failure.
Remedy: If the automatic DBS restart does not clear up the problem, an operating system shutdown and reboot should
do so. However, this is possibly caused by a bug in DBS or PDE software, which should be reported to the Global Support
Center.

Above are list of Teradata Errors or Failure Codes from Error 10308to 10312 received while performing certain operation against Teradata Database or related products.

What are Teradata Database Errors?

In general, each Teradata error message contains the following information:
• The message number.
• The message text. This text is usually returned with the message number.
Some messages employ word substitution, where the word substituted
represents the system-replacement of a term more specific to the
occurrence.
• An explanation of how the error may have occurred.
• Generated-by text that indicates the software module which initiated the
message. This field serves a diagnostic purpose for support and
development personnel.
• A remedy which suggests how to resolve the condition.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Teradata SQL Error and Failure Codes and Error Messages on Windows, Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *