Transaction problem, Unable to start RSA1

[Former Member]

Hello every one:

I am not able to start RSA1 transaction in our BW system.

RSA1 transaction hangs. Can some one tell me how to trouble shoot please.

Regards,

KG

[Former Member]

For those who have the same problem:

Reorg TBTCO table delete the entries.

[Former Member]

Can you please let me know how you reorg TBTCO

[Former Member]

Balkrishna

BW 3.5, Sql Server 2003. We just upgraded support packs to SP18.

This is the only transaction that has been affected. When Executing RSA1,

If you look at sm66, it sits on TBTCO table for ever. There are no short dumps or errors in database or system logs. This is the only transaction that has issues.

Because of this behavior I applied note 924198, however the problem still there.

Regards,

KG

[Former Member]

Hi,

provide the system details

BW Ver ??

Operating System ???

Database ??

Thanks & Regards,

Balkrishna

[Former Member]

Hello,

You have to enter table RSADMINA and define the BW client before you can execute RSA1.

Hope,you have created the logical system also.

Thanks & Regards

Balkrishna

[Former Member]

Balkrishna,

This is not a new install, The entries do exist. However, this is the only transaction that takes over 3600 ms to start.

Any other idea?

Regards,

kg