spam problem

[Former Member]

hello experts,

I am appyling patch for BI-CONT, i had put in queue

3 patchs , and importing, its been 24 hours it is still

running, it import_proper it was fine. but from phase

import_proper it has not moved furthure. it has been

almost 16 hours it is still running. it was scheduled in

background. when i go and check in sm37 that

background job is not visible.

any suggestions.

thnx and regards

[Former Member]

Hello kavitha l,

I ran into the same problem and it is only valid for MS-SQLServer.

The Job "RDDDIS0L" canceled with a "SAPSQL_SUBQUERY_ILL_TABLE_TYPE"-error.

See TC SM37 or the TP-LOG in /usr/sap/trans/tmp.

SAP-Note 1042435 will solve that problem.

Also see SAP-Note 822379 and search for "SAPSQL_SUBQUERY_ILL_TABLE_TYPE".

Regards, HF.

[yuezhi_zhao]

I would suggest you dtart from SLOG in /usr/sap/trans/log directory. This could a locking file problem. But SLOG usually gives a hint. Attach the last part of SLOG here would be helpful.

Regards,

Joseph Zhao

[Former Member]

Hi If you are using ORC DB plz check weather u have free space for ORAARCH

[Former Member]

check the log for that particular support pack in /usr/sap/trans/log and the post if there is any error...

Sudha

[markus_doehr2]

Which database are you using?

Markus

[Former Member]

Please check transaction SM50 if there is some activity

[Former Member]

hi,

thank you for the response.

i had checked in sm50 , there is one background work process

which is on hold from a very long time. reason "RFC".

report "SAPLSTPA".

so what can be done.

thanks and regards.

[Former Member]

Hi Kavitha,

Go to /usr/sap/trans/log to find the latest log.

Send the latest Log.

regards,

Rohit

Edited by: Rohit Goswami on Feb 8, 2008 12:03 AM