Database error: TemSe->XRTAB(2)->1 for table TST01 key [400]JOBLGX13132201X

[Former Member]

Hi

We are getting the next erros with the jobs:

13:13:51 PRDAUNE2_PRD_02 BTC 22 000 SAPSYS F6H Database error: TemSe->XRTAB(2)->1 for table TST01 key

13:13:51 PRDAUNE2_PRD_02 BTC 22 000 SAPSYS GZZ > retry creation JOBLGX btctlgow216#

13:13:51 PRDAUNE2_PRD_02 BTC 22 000 SAPSYS F6H Database error: TemSe->XRTAB(2)->1 for table TST01 key [400]JOBLGX13132201X28173,1

13:13:51 PRDAUNE2_PRD_02 BTC 22 000 SAPSYS GZZ > retry creation JOBLGX btctlgow216#

13:13:51 PRDAUNE2_PRD_02 BTC 22 000 SAPSYS F6H Database error: TemSe->XRTAB(2)->1 for table TST01 key [400]JOBLGX13132201X28173,1

13:13:51 PRDAUNE2_PRD_02 BTC 22 000 SAPSYS GZZ > retry creation JOBLGX btctlgow216#

13:13:51 PRDAUNE2_PRD_02 BTC 22 000 SAPSYS F6H Database error: TemSe->XRTAB(2)->1 for table TST01 key [400]JOBLGX13132201X28173,1

13:13:51 PRDAUNE2_PRD_02 BTC 22 000 SAPSYS ECF Failed to create log for job POLCASHWIN

13:13:51 PRDAUNE2_PRD_02 BTC 22 000 SAPSYS EBC > Job POLCASHWIN

13:13:51 PRDAUNE2_PRD_02 BTC 22 000 SAPSYS EAY Failed to read status entry for job POLCASHWIN

13:13:51 PRDAUNE2_PRD_02 BTC 22 000 SAPSYS EBC > Job POLCASHWIN

13:24:21 PRDAUNE2_PRD_02 BTC 22 000 SAPSYS BYM SQL error 0 . Work processes in reconnect status

We make a consistency check of spool and temse but nothing is wrong, but if we apply Check Status in the SM37 some jobs change to Active and run but other are in same status Ready

We olny found the note 67055 but recommended the consistency check.

Best Regards

Reynaldo Rebolledo

[Former Member · Accepted solution]

Hello Reynaldo,

Just delete the existing job and reschedule it from the beginning.

Regards.

Ruchit.

[Former Member · Accepted solution]

Hi Ruchit

The job is generated by the user, always is a new one but continued with the same error. It hapend with some jobs, the others are running ok.

Some idea.

Best Regards

Reynaldo Rebolledo.

[Former Member]

Hi Reynaldo,

Check for Tablespace PSAPTEMP size for Oracle database when job is running.

If tablespace is full try adding datafile and run the job.

• Award Points if Helpful

[Former Member]

Hello to all

Thank you very much about your help, we have some issues related to the network and DNS, we must to restarted all the servers and everything looks fine.

Best Regards

Reynaldo Rebolledo

[Former Member]

Hi,

Kindly have a look at this note 806588. I hope this will help you in resolving your issue.

Thanks & Regards

Vivek