Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 09, 2007 at 09:50 PM

    Hello Reynaldo,

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

    Regards.

    Ruchit.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • avatar image
    Former Member
    Oct 10, 2007 at 09:01 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Oct 10, 2007 at 03:44 AM

    Hi,

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

    Thanks & Regards

    Vivek

    Add comment
    10|10000 characters needed characters exceeded