Switching spool destination to file system

325 Views

Hi,

We are getting the spool errors below in the system log SM21. To avoid

writing to spool logs to database we changed the parameter

rspo/store_location = G. Spool is being written, but we still have the

problem. We are running the spool and TemSe consistency checks daily.

Please advise how we can completely avoid using databse for spool

logs. Thanks, Abdul

System Logs:

OPERATION MODES: Switch to operation mode normal_day triggered

SQL error 12571. Work processes in reconnect status

Database error: TemSe->XRTAB(0)->1 for table TST01 key

retry creation JOBLGX btctlgow216

Database error: TemSe->XRTAB(0)->1 for table TST01 key [100]

JOBLGX23572401X87963,1

retry creation JOBLGX btctlgow216

Database error: TemSe->XRTAB(0)->1 for table TST01 key [100]

JOBLGX23572401X87963,1

retry creation JOBLGX btctlgow216

Database error: TemSe->XRTAB(0)->1 for table TST01 key [100]

JOBLGX23572401X87963,1

Failed to create log for job SWFSLSDLEX #00024771000########ﵝŚ##03###ᒥ

Job SWFSLSDLEX

Failed to read status entry for job SWFSLSDLEX

Job SWFSLSDLEX

SQL error 12571. Work processes in reconnect status

Database error: TemSe->XRTAB(0)->1 for table TST01 key

retry creation JOBLGX btctlgow216

Database error: TemSe->XRTAB(0)->1 for table TST01 key [100]

JOBLGX02552402X01262,1

retry creation JOBLGX btctlgow216

Database error: TemSe->XRTAB(0)->1 for table TST01 key [100]

JOBLGX02552402X01262,1

retry creation JOBLGX btctlgow216

Database error: TemSe->XRTAB(0)->1 for table TST01 key [100]

JOBLGX02552402X01262,1

Failed to create log for job ZMR_RSWUWFMLEC

#30024737000########ﵝŚ##03###ᒥ

Job ZMR_RSWUWFMLEC

Failed to read status entry for job ZMR_RSWUWFMLEC

Job ZMR_RSWUWFMLEC

SQL error 12571. Work processes in reconnect status

Database error: TemSe->XRTAB(0)->1 for table TST01 key

retry creation JOBLGX btctlgow216

Database error: TemSe->XRTAB(0)->1 for table TST01 key [100]

JOBLGX11572500X07676,1

retry creation JOBLGX btctlgow216

Database error: TemSe->XRTAB(0)->1 for table TST01 key [100]

JOBLGX11572500X07676,1

retry creation JOBLGX btctlgow216

Edited by: Abdul Rahim Shaik on Jun 26, 2008 5:14 PM