[sap-basis] We can not run batch jobs (sm37)
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by acicuno on Mar 9 at 1:12 PM |
SAP 4.6c
Windows 2003 SP2 64 bits
MS SQL 2005 Sp2 64 bits
Hello gurus
We have a problem, after system copy (attach-detach) Productive to Test, we can not run batch jobs (sm37)
because the following message is showed:
Error reading job log
Message no. BT 167
Diagnosis
The background processing system was unable to read the job log named in the message.
This message suggests that there is a problem with the TEMSE storage system of the SAP System. The TEMSE storage system is a repository for temporary R/3 objects, such as job logs and spool requests. Job logs are always stored in the TEMSE as operating system files.
This error occurs if the TEMSE system is not able to find or access the file that contains the text of the job log that you requested. Possible causes for the loss or unavailability of the job log include the following:
So we want to fix and run tx sp12 but another error appear:
ABAP runtime errors DBIF_RSQL_SQL_ERROR
SQL error 9105 occurred when accessing table "TST01 ".
At file dev_w0 we have:
C Tue Mar 09 13:20:02 2010
C HandleOledbError [RpcExec,line 22204]: Error/Message: (err 9105, sev 0), The provided statistics stream is corrupt.
C RpcExec failed. HR 80040e14 DBSL retcode 99. proc: [Y8R40000001K3993149TST01ut01]
C DbSlRead - Error 99 (dbcode 9105) on open
C DbSlRead - <Y8R40000001K3993149TST01ut01>
C DbSlRead - Error 99 (dbcode 9105) on fetch
C DbSlRead - <Y8R40000001K3993149TST01ut01>
B ***LOG BY4=> sql error 9105 performing SEL on table TST01 [dbtrtab 6295 ]
B ***LOG BY0=> The provided statistics stream is corrupt. [dbtrtab 6295 ]
C HandleOledbError [RpcExec,line 22204]: Error/Message: (err 9105, sev 0), The provided statistics stream is corrupt.
Thank you for your time
__.____._ Windows 2003 SP2 64 bits
MS SQL 2005 Sp2 64 bits
Hello gurus
We have a problem, after system copy (attach-detach) Productive to Test, we can not run batch jobs (sm37)
because the following message is showed:
Error reading job log
Message no. BT 167
Diagnosis
The background processing system was unable to read the job log named in the message.
This message suggests that there is a problem with the TEMSE storage system of the SAP System. The TEMSE storage system is a repository for temporary R/3 objects, such as job logs and spool requests. Job logs are always stored in the TEMSE as operating system files.
This error occurs if the TEMSE system is not able to find or access the file that contains the text of the job log that you requested. Possible causes for the loss or unavailability of the job log include the following:
So we want to fix and run tx sp12 but another error appear:
ABAP runtime errors DBIF_RSQL_SQL_ERROR
SQL error 9105 occurred when accessing table "TST01 ".
At file dev_w0 we have:
C Tue Mar 09 13:20:02 2010
C HandleOledbError [RpcExec,line 22204]: Error/Message: (err 9105, sev 0), The provided statistics stream is corrupt.
C RpcExec failed. HR 80040e14 DBSL retcode 99. proc: [Y8R40000001K3993149TST01ut01]
C DbSlRead - Error 99 (dbcode 9105) on open
C DbSlRead - <Y8R40000001K3993149TST01ut01>
C DbSlRead - Error 99 (dbcode 9105) on fetch
C DbSlRead - <Y8R40000001K3993149TST01ut01>
B ***LOG BY4=> sql error 9105 performing SEL on table TST01 [dbtrtab 6295 ]
B ***LOG BY0=> The provided statistics stream is corrupt. [dbtrtab 6295 ]
C HandleOledbError [RpcExec,line 22204]: Error/Message: (err 9105, sev 0), The provided statistics stream is corrupt.
Thank you for your time
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
