2010 Apr 27 3:08 PM
Hello group,
we suddenly had a performance issue, and we found that suddenly table EBKN appeared as "patially active" in the database. After activating the performance problems were gone. But we have no clue as to how the table got the status "partially active" and what this means. We got no errors or warnings when activating.
Doe sanyone have a clue as to what the cause is for the status "partially active"?
Regards, Léon Hoeneveld
2010 Apr 27 5:09 PM
Somebody didn't check transports for non-zero return code for something that changed the definition of the table...Had the transports been checked, you'd see the explanation in the transport log.
Somebody didn't check transports for non-zero return code for something that changed the definition of the table...Had the transports been checked, you'd see the explanation in the transport log.
2010 Apr 27 3:16 PM
Hi,
talk with your basis and let them check the imported transports.
There might be includes that have been changed with transports.
I had a similar case (no performance problems but dumps).
Kind regards,
Hermann
2010 Apr 27 3:29 PM
Hello Hermann,
I've checked with SE01 Transport organizer if any transport contained table EBKN. But none recently. It's not a program or a fucntion module that is causing dumps, but a table that is partially inactive and causes performance problems in standard transactions. I need to know how the status of a table can change. Maybe it's the append-structures.
Regards, Léon Hoeneveld
2010 Apr 27 4:11 PM
Hi,
> I've checked with SE01 Transport organizer if any transport contained table EBKN.
it's not necessarily the table but could be one of the includes .... .
Partially active means that a part of the table (e.g. an include) was not active while the table (the part without the include) was active. You can try to find that part and search that in transports.
In the cases i had i was like this.
Regaring your performance problems: I wonder if they have to do with a partially activated table. Honestly i doubt it.
Programs working on partially activated tables should either work or dump but i never heard of performance problems
related to partially activated tables....
Kind regards,
Hermann
2010 Apr 27 5:09 PM
Somebody didn't check transports for non-zero return code for something that changed the definition of the table...Had the transports been checked, you'd see the explanation in the transport log.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |