cancel
Showing results for 
Search instead for 
Did you mean: 

TemSe->XRTAB(0)->1 for table TCPSEG (Everyday)

Former Member
0 Kudos

Hi there,

NW2004s under Windows 2003, oracle 10g, I am getting everyday this messages when I try to connect through SAP GUI

in Solution Manager

Error:

SAP system Messages:

No connect to datbase, session terminated

This error shows every munite in SAPMMC SYSLOG

"Spool / print: Database error: TemSe->XRTAB(0)->1 for table TCPSEG key "

When I restart instance problem has been solved...

Then I use SP12

SP12 TemSe database->Consistency Check

It just shows only one record. delete all.. thats it

I check background job for SAP_REG_ABAPDUMP thats running fine... everyday at 1:00am

please tell me how to fix that problem...

Angeline

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Angeline,

Check this SAP Note :Note 67055 - Explanation of syslog message xrtab(?)->? for ????

Hope the message that appears in your syslogs shows some SQL read error for the tableTCPSEG.

I Suggest you to drill down the details of the table.

Thanks,

Best Regards,

Shyam Dontamsetty

Former Member
0 Kudos

Hi,

Thank for reply,

Here is some screen-short for SM21

http://www.flickr.com/photos/38842895@N04/4308670419/sizes/o/

As per SAP note: 67055 explanation shows that return code comes from SQL error anyway! when I use SP12 from menu

TemSe - storageData - List all of objects does shows log of temp logs

I Deleted "Consistency Check"

I Deleted all objects using tbale TST01 Tr: SE16

I Deleted program to deleted temp entry in Table using RSPO041

Next day I got same message again every munites

spool / print: database error: TemSe-> XRTAB(0)-> for table TCPSEG

I check in service.sap.com nothing information I found out

Please verify

Thank

Edited by: AngelinePurnama on Jan 27, 2010 4:03 PM

Edited by: AngelinePurnama on Jan 27, 2010 4:36 PM

Former Member
0 Kudos

Thank problem has been resolved, due to database problem

Former Member
0 Kudos

Hi Angeline,

We have the same problem on windows 2003 oracle 10g.

Could you please give me any suggestions?

Thank you very much.

Sam Zhao.

Answers (0)