Transport Problem in Qality system

[Former Member]

Hi Gurus,

In quality system we are facing a strange problem.Recently we refreshed our QAS with PRD database.

After importing the transport requests in QAS, the changes are not reflecting.If we check in the tables the changes are reflecting .But the views and the buffers are not getting updated.

If we run /$TAB or /$SYNC the changes are reflecting immediately.

I have updated R3trans and tp level to latest release. IT worked only 2 days and again this is creating problem.Until I give /$TAB the changes are not refrelcted...

The SAP version is SAP 4.7 EE

Oracle 9.2.0.6

When I check the buffers in ST02 the free directories in table definition buffers is showing as 0

Please help on this...

Thanks,

jagadish

[Former Member]

Thanks to all for the help provided during the issue.

The problem got solved after truncating the table by stopping sap and starting it again.

[Former Member]

Hi,

Just a hunch... did you empty (truncate) table DDLOG after the refresh and before bringing up the system? I don't know whether leaving old stuff in DDLOG can cause this problem but it's something I would certainly check.

What does transaction AL12 tell you?

Rgds,

Mark

[Former Member]

Hi Mark,

It seems i got some light on the issue.....I have gone thru AL12..the DDLOG records doesn't help me much but AL12 ->statistics->

Sync ->status info.. i m getting the below error...

Last synchronised number: -2.147.359.467

Buffer synchronisation doesn't work.

New sequence number: -2.147.360.701

I am not able to pick relevant note for the error..the parameter seem to be fine in the system..

So how to resolve this error????

Thanks much,

Jagadish

[markus_doehr2]

> Last synchronised number: -2.147.359.467

> Buffer synchronisation doesn't work.

> New sequence number: -2.147.360.701

the problem may be an overflow of the internal table:

Note 565057 - Memory overflow in buffer synchronization

The fix is delivered in kernel patch 288.

Markus

[Former Member]

Markus,

In syslog there are no entires with "Memory overflow for buffer sync"

We have some more systems with the same kernel level and there it is working fine...

Is there any way we can eliminate the error message "buffer sync doesnot work"

-Jag

[markus_doehr2]

don't know what the problem is updating the kernel to a recent version but I think the only people being able to help you is SAP.

I'd open an OSS call.

Markus

[markus_doehr2]

can you check if the affected table is buffered? (SE11 - technical settings)

Markus

[Former Member]

Not only for one table..whatever table changes coming with the transport..After importing the changes are updated in table...in table level the changes are reflecting.....not in the buffers.

One mor eexample.. If i have created a new role and i have transported into QAS..if i goto PFCG an display ..it will say like role does not exist..

If i run /$tab or /$sync and if i give the same in PFCG then i can see the new role..

-Jag

[markus_doehr2]

What kernel patchlevel are you running?

Markus

[Former Member]

release 640 patch level 247

[markus_doehr2]

I must admit I'm out of ideas. That kernel is not too old, should work (and also because it did before).

I suggest to open an OSS call (BC-CTS-TLS) according to

Note 1055826 - Composite note: Objects/data unavailable after transport

Markus

[Former Member]

Thanks for teh reply Mark..

Let me check with SAP then,,,,

[markus_doehr2]

What's the value of the parameter

rdisp/bufrefmode

?

Markus

[Former Member]

Mark,

The parameter value sendoff,exeauto I checked in some other systems also the value is same..We are not having any additional app servers too.We have only central instance...

-Jag

[Former Member]

The parameter value sendoff,exeauto I checked in some other systems also the value is same..

You can try sendon,exeauto. Check the following link for detailed information.

[http://help.sap.com/saphelp_nw04/helpdata/en/c4/3a6dd5505211d189550000e829fbbd/content.htm]