Skip to Content
author's profile photo Former Member
Former Member

Moving fields from repair to append structure

On the system I work with right now, a repair has been made on BSEG to add a few fields. This modification has been set into production some time ago. Naturally, SPDD complains about this during upgrade.

I think the right thing to do is to move the data into an append structure in the old system before upgrade, thus avoiding the SPDD error during the real upgrade, but I have one big worry about doing this:

Loss of data in the custom fields is unacceptable when the table is moved into production. So the question is, if it is possible to make this change without destroying productive data and if so, what is the right way to do it?

1. Should (and can, due to SE11 checks of name identity) the fields be added to an append structure before they are deleted from the repaired BSEG?

2. Should (and can) the fields be deleted from BSEG without activating the new structure, then creating the append structure and activating it?

I hope somebody here has tried something like this before.

Peter

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2008 at 10:01 AM

    You are so right. Fields SHOULD have been added in an append structure. But they WERE appended directly to BSEG using SE11, hence the repair.

    So the whole issue now is to correct the sins of the past.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      U can try to create a backup of the information stored in that field (perhaps downloading in a file).

      In this way it can regenerate the standard structure of BSEG and then insert the field again but in the correct way, and reloaded the information in that field..

      I don't know how many records are in BSEG table, but if that fields is filled only for certain items, perhaps a file with the key of BSEG and that field can be created. Probably the job takes a long time, but it should run only one time.

      Max

  • author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2008 at 09:58 AM

    Hi

    The problem is to understand how this new field was insert in BSEG table.

    The BSEG table is a cluster table so a new field shouldn't be inserted directly by SE11 and you should consider you can create an APPEND structure for a cluster table.

    In the new field was created in the right way, you shouldn't find the BSEG table in SPDD.

    Max

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2008 at 11:08 AM

    Yeah, I thought about that too. I just hope there is a way to avoid writing custom programs for data conversion. I know that the Dictionary (or rather the transport system) can do many conversions automatically, but I think this is a rather special case.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 09:40 AM

    It seems there is no automated solution for this problem. We ended up writing a program to export the data and another one to import the data again after moving the fields in BSEG into an append structure.

    It is a shame that no system support exists for this operation, but then again - the fields should never have been placed directly in BSEG in the first place. I just hope not to come across this kind of "repairs" again.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.