SM58 Error

[Former Member]

Hello Guys,

I am new to BI systems.

When our BI system is running loads we are facing too many issues.

There are so my TRFcs in SM58 with SQL error in the database when accessing a table.Could the reason be while running the load some one at ECC side executed the same report for which the data was being loaded into ECC.

Sometimes it will transaction recored status.We have to manually execute the LUWs.

I have checked SMQS status., its showing waiting status.i have checked the resources also.. all are OK.

Please advice how to proceed.

Regards

Abhishek

Edited by: abhishek sharma on Feb 27, 2012 3:41 PM

[Former Member]

DId you registered systems in SMQR ? and also paste the error message.

[Former Member]

hello,

i executed smqr on BI system.

below is the information.

Scheduler Information

Scheduler Status : Inactv.

Last Update (Every 2 Minutes) : 27.02.2012 21:25:43

Name of AS Group (DEFAULT = All): DEFAULT

Number of Entries Displayed 1

Host ID : SPLBIOPRDN2_PBP_02

Number of Active Connections 0

Cl. Queue name Type Mode Max. Runtime Attempts Pause Destination with LOGON Data

330 MCEX02 R D 60 0000 300

i can just see error in sm58 where can i find the logs.

regards

Abhishek

[Former Member]

when you double click on the queue in SMQ2 or SMQ1 you can see the error.

[Former Member]

Hello,

On ECC side i executed SMQ1.

Queue Information

Number of Entries Displayed: 1,351,914

Number of Queues Displayed: 5

Cl. Queue Name Destination Entries

900 MCEX02 NONE 11,010

900 MCEX04 NONE 18,993

900 MCEX11 NONE 757,519

900 MCEX12 NONE 423,989

900 MCEX13 NONE 140,403

Cl. Queue Name Destination Entries Status Date 1 Time 1 NxtDate NxtTim Wait for queue

900 MCEX02 NONE 11,010 NOSEND 15.02.2012 10:10:33 27.02.2012 23:20:10

900 MCEX13 NONE 140,403 NOSEND 15.02.2012 10:20:06 27.02.2012 22:42:03

900 MCEX11 NONE 757,573 NOSEND 15.02.2012 10:20:10 27.02.2012 23:58:03

900 MCEX12 NONE 423,989 NOSEND 15.02.2012 10:21:01 27.02.2012 22:38:45

900 MCEX04 NONE 18,995 NOSEND 15.02.2012 13:30:27 27.02.2012 23:57:09

Regards

Abhishek