EP2846264A1 - Method and apparatus for implementing changes within a data system - Google Patents
Method and apparatus for implementing changes within a data system Download PDFInfo
- Publication number
- EP2846264A1 EP2846264A1 EP14180810.5A EP14180810A EP2846264A1 EP 2846264 A1 EP2846264 A1 EP 2846264A1 EP 14180810 A EP14180810 A EP 14180810A EP 2846264 A1 EP2846264 A1 EP 2846264A1
- Authority
- EP
- European Patent Office
- Prior art keywords
- request
- objects
- data
- transport request
- backup
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 30
- 230000008859 change Effects 0.000 claims description 45
- 230000002441 reversible effect Effects 0.000 claims description 16
- 230000004044 response Effects 0.000 claims description 5
- 230000008676 import Effects 0.000 claims description 4
- 238000004590 computer program Methods 0.000 claims description 3
- 238000012360 testing method Methods 0.000 description 7
- 238000012217 deletion Methods 0.000 description 4
- 230000037430 deletion Effects 0.000 description 4
- 230000008569 process Effects 0.000 description 3
- 230000000007 visual effect Effects 0.000 description 2
- 238000010586 diagram Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000003203 everyday effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1415—Saving, restoring, recovering or retrying at system level
- G06F11/1435—Saving, restoring, recovering or retrying at system level using file system or storage system metadata
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1415—Saving, restoring, recovering or retrying at system level
- G06F11/1433—Saving, restoring, recovering or retrying at system level during software upgrading
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1448—Management of the data involved in backup or backup restore
- G06F11/1451—Management of the data involved in backup or backup restore by selection of backup contents
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/70—Software maintenance or management
- G06F8/71—Version control; Configuration management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1471—Saving, restoring, recovering or retrying involving logging of persistent data for recovery
Definitions
- the method is particularly applicable to a method of implementing changes within an SAP (TM) system.
- the current method of implementing change within a data system involves the use of three different systems, a development system, a test system and a production system as illustrated in Figure 1 .
- the development system changes to objects in the system are developed by programmers. Once a change has been sufficiently developed it is moved into the test system which mirrors the system that is used by the employees of the enterprise as far as possible. In the test system any effects of the change can be identified. If any further development is required occur to overcome issues which are identified in the test system then the transport request is rejected and returned to the development system for further development. Once, sufficient testing has occurred the changes can be imported into the "production system" which is the system used by employees of the enterprise to perform their day to day tasks.
- a transport request is used to move new features from one system to the next.
- the developer adds objects to the transport request.
- any related development objects and categories are also added to the transport request an example of such a Transport Request is illustrated in Figure 2 .
- data files which contain the data to be transported
- cofiles which contain the different steps of the request
- profile files which contain profile parameters
- transport log which contains logs, trace files and statistics
- support packs which contain update and enhancement related files.
- a system including a data store and a processor configured to, upon receiving a request including one or more objects to be imported into the system, perform the steps of: creating a back up request comprising a copy of the objects included within the request as they are present in the system at the time the back up request is created; and storing the back up request.
- the processor is configured to identify a backup request implementing a change to an object in the system, the reversal of which may involve a loss of information and, upon identifying the backup request, generate an alert to a user.
- the alert may be a visual alert displayed on a display.
- the processor may be configured to generate the alert when it is determined that reversal of the backup request will result in a loss of information.
- the present invention enables a database including a large number of objects to be quickly and efficiently backed up. Additionally, it allows the system to be reverted to its previous state quickly and efficiently as only the objects which were modified by the request are altered.
- the request may be imported into the system causing the system to be amended by importing the one or more objects.
- the objects that were copied in the back up request may be reimported into the system.
- the request may include an identifier for the back up request.
- the back up request includes an identifier of the request. This enables the corresponding back up request to be quickly identified enabling reversal of any change that has unwanted consequences.
- the back up request may be deleted after a predetermined length of time.
- a request implementing a change to an object no version history is stored, in the data system and, upon identifying a request implementing a non-reversible change, generating an alert and, optionally, causing the alert to be displayed on a display.
- the change may be non-reversible.
- An example of such a non-reversible change in an SAP system is the creation, update or deletion of data in a table.
- the processor is configured to identify a backup request implementing a non-reversible change to an object in the data system and, upon identifying a backup request implementing a non-reversible change, generating an alert and, optionally, causing the alert to be displayed on a display.
- This allows a user to be informed that the restoration may not include all of the data required for a complete restoration and enable them to ensure that all of the relevant data is entered. For example, if the non-reversible change is a deletion of a column although the restoration will allow a user to be aware that the column is not going to be populated with data and, if necessary, repopulate the restored column.
- a method in a system including a data store and a processor.
- the method includes receiving a request including one or more objects to be imported into the system, creating a back up request comprising a copy of the objects included within the request as they are present in the system at the time the back up request is created and storing the backup request.
- the method also includes identifying a backup request implementing a change to an object in the system, the reversal of which may involve a loss of information and, upon identifying the backup request, generating an alert to a user, which may be displayed on a display.
- the request can be imported into the system causing the system to be amended by importing the one or more objects.
- the objects comprising the back up request may be imported into the system.
- a computer program embodied on a computer readable medium which, when executed on a processor in a data system causes the processor to: upon receiving a request including one or more objects to be imported into the system; create a backup request comprising a copy of the objects included within the request as they are present in the system at the time the back up request is created; store the backup request; and identify a backup request implementing a change to an object in the system, the reversal of which may involve a loss of information and, upon identifying the backup request, generate an alert to a user, which may be displayed on a display.
- the imported changes may change the structure of objects within the system and add new objects to the system.
- methods and apparatus disclosed herein may relate to identifying a backup request implementing a change to an object in the system, the reversal of which may involve the loss of information.
- a back up request implementing a change to an object in the system, the reversal of which may involve the loss of information encompasses a SAP instruction implementing a change that can only be undone with loss of data. That is, the change may be reversed, but the system is degraded as a result, for example by data being lost.
- the backup request will only result in a loss of information in a number of specific scenarios.
- the term "information" as referred to herein encompasses data stored in any objects within a SAP system.
- the data may relate to the structure of one or more objects in a SAP system.
- the data may comprise entries made within objects stored within a SAP system.
- information as referred to herein relates to information associated with a SAP system or any of the contents of a SAP system.
- a loss of information as referred to herein relates to any information that is lost from an SAP system that cannot be retrieved.
- a loss of information may specifically refer to information that is lost from a SAP system and that cannot be retrieved by either a transport request or a backup transport request.
- An example of a loss of information would be manual entries of data that have been added to an object in a SAP system and then deleted, wherein the entries of data have not been stored elsewhere in the SAP system.
- SAP has 3 different types of database tables - (1) Configuration, (2) Master data and (3) Transactional data.
- Configuration data is "customising" that each specific client has when they implement SAP. It might define things like payment methods, customer segments, company codes etc.
- Exemplary configuration tables have single digits of rows, dozens of rows up to hundreds of rows at an upper end. Configuration tables rarely change since they control how the system functions. In fact, configuration database tables typically only change via transport requests.
- the second type of database table, master data comprises tables like customer records, vendor records, etc. that change occasionally bit but not excessively. Master data tables typically change more frequently than configuration database tables. Small numbers of customers/vendors might be created each day depending on industry and implementation of the system. Typically, master data database tables might have thousands to tens of thousands of records in them.
- transactional data comprises data such as sales orders, meter readings, billing documents etc.
- data such as sales orders, meter readings, billing documents etc.
- master data and transactional data tables are updated (rows created, changed, deleted) not by transport requests but by users and automated business processes running in the system through-out the day.
- Transport requests might be used to change the structure of master data and transactional data database tables, but generally not their contents.
- Exemplary methods and apparatus disclosed herein are for use on database tables when no back-up of data is undertaken. This may be because it is not possible or infeasible to back-up the data, for example, due to high data volumes. Exemplary methods and apparatus disclosed herein may be used with master data and transactional data database tables.
- a production system may include a table C001 as illustrated in Figure 5 , which may be a master data or transactional data database table.
- C001 has three columns, namely Country Code, Description and Currency.
- a transport request as illustrated in Figure 6 includes an entry requesting, that for C001, the currency column is deleted.
- a back up request is generated and implemented in the production system. After its implementation in the production system the transport request appears as illustrated in Figure 7 . Thus, it can be seen in the back up transport request the structure of C001 is stored.
- a backup transport request can be created.
- the backup transport request may comprise a copy of the state of objects in the production system prior to implementation of the transport request.
- the backup transport request would include a copy of the structure of the table as it appeared in the production system prior to the transport request being imported (i.e. the table including the Currency column).
- the back up transport request may be created in the production system. After it is created, the backup request would appear as illustrated in Figure 7 .
- the structure of C001 is stored.
- the previous structure of C001 is stored in the back up request
- the data that is removed from the table during the implementation of the transport request may not be.
- the structure of C001 and the format of the currency column may be stored in the back up request, but the individual entries within the currency column may not be stored.
- the backup request in the production system after the transport request has been imported to the system, the original structure of C0001 may be restored. It may not be possible to reinstate the data that once populated the currency column using the back up request.
- the backup transport request may store data included in objects as well as the structure of the objects themselves.
- a similar problem may arise in the opposite direction. That is, a backup request may result in a loss of information. The information that is lost may not be able to be obtained from an original transport request.
- a transport request which alters the structure of a table by the addition of a column may be imported into a production system.
- the transport request may also include provisions for data to be added to the new column.
- data may be manually entered into the column of the table in question by an employee.
- a variety of other manual or automatic processes may populate the column. If the backup request is then subsequently imported into the production system, this will reverse the changes made to the table accordingly.
- the column that was added to the table according to the earlier transport request will be deleted in the production system.
- the data in the added column will also be deleted in the production system.
- the system may be configured to detect when a transport request or back up transport request involves the implementation of a change where the structure of one or more objects in the production system is altered. Further, the system may be configured to detect where a change in structure to an object potentially involves the loss of information contained within the object or in connection with the object. In exemplary methods and apparatus, the system may determine when a transport request is to be executed on a master data or transactional data database and/or when it is not possible or infeasible to back up data in a table before a transport request is executed, for example because the volume of data is too great to be stored.
- the system may generate an alert to a user before implementing the transport request. Further, the system may generate an alert to the user before importing a backup transport request if it involves the change to the structure of one or more objects.
- the system may generate alerts to the user where any transport or back up transport request is to be imported into the production system and the request involves a change to the structure of one or more objects which may lead to a loss of information.
- alerts may allow the user to choose not to import a transport request of a back up transport request into the production system.
- the alerts may be visual on a display, but may take any other suitable form.
- the alert may be auditory or physical, such as through vibration.
- the system may be configured to detect when a transport request includes a configuration change where the structure of an object is altered. Examples of a configuration change include a deletion of a column in a table.
- the system may generate an alert to the user before implementing the transport request.
- the system may additionally, or alternatively, generate an alert to the user before importing a backup transport request to reverse a transport request where a configuration change has occurred. This will alert the user to the fact that data may have to be input into the object.
- the alert may indicate to the user that the column currency is being restored to Table 001. Additionally, such an alert allows a user to choose not to import the backup transport request into the data system.
- the data of the configuration table may be stored within the backup transport request so that after reversing out the structural column change, the data within that table can also be restored.
- Examples of other objects that might be included within a transport request are: programs, data elements, structures, tables, functions.
- the back up transport request has been described as being linked to the transport request by including an identifier for the transport request in the back up transport request it is clear that any suitable method may be used to link the transport request and back up transport request.
- the system may be provided with a table which stores transport request identifiers in association with the identifier for their related back up transport request or the identifier of the back up transport request may be added to the transport request.
- the identifier of the back up transport request or transport request may be stored for example, as an attribute of the transport request.
Abstract
Description
- A method of implementing changes within a data system to enable restoration of a system to the state it was in prior to implementation of the change. The method is particularly applicable to a method of implementing changes within an SAP (TM) system.
- Within an enterprise data system such as that designed by SAP (TM) development of that system continuously occurs, for example to solve problems within the system or to enable additional functionality. However, as enterprises are responsible for interacting with large numbers of people the implementation of changes are tightly controlled in order to mitigate the risk of any undesirable changes being introduced into the system.
- The current method of implementing change within a data system involves the use of three different systems, a development system, a test system and a production system as illustrated in
Figure 1 . In the development system changes to objects in the system are developed by programmers. Once a change has been sufficiently developed it is moved into the test system which mirrors the system that is used by the employees of the enterprise as far as possible. In the test system any effects of the change can be identified. If any further development is required occur to overcome issues which are identified in the test system then the transport request is rejected and returned to the development system for further development. Once, sufficient testing has occurred the changes can be imported into the "production system" which is the system used by employees of the enterprise to perform their day to day tasks. - In order to ensure that all of the data and objects related to a particular development are transported together an element called a transport request is used to move new features from one system to the next. When a transport request is created the developer adds objects to the transport request. When an object is added to the transport request any related development objects and categories are also added to the transport request an example of such a Transport Request is illustrated in
Figure 2 . In a transport request five different types of files can be found, these are: data files which contain the data to be transported; cofiles which contain the different steps of the request; profile files which contain profile parameters, a transport log which contains logs, trace files and statistics; and support packs which contain update and enhancement related files. - It is important that this process is tightly controlled as, once a change is imported into the production system, the production system cannot automatically be returned to its previous state but rather a further transport request must be produced and developed to reverse the changes. This takes time and therefore is undesirable if a critical issue such as a function required for a commonly used business transaction no longer being operational, has been introduced into the production system.
- Therefore what is required is an improved method for controlling the production system when a change is imported into it.
- According to an aspect of the present invention there is provided a system including a data store and a processor configured to, upon receiving a request including one or more objects to be imported into the system, perform the steps of: creating a back up request comprising a copy of the objects included within the request as they are present in the system at the time the back up request is created; and storing the back up request. The processor is configured to identify a backup request implementing a change to an object in the system, the reversal of which may involve a loss of information and, upon identifying the backup request, generate an alert to a user. The alert may be a visual alert displayed on a display.
- The processor may be configured to generate the alert when it is determined that reversal of the backup request will result in a loss of information.
- By creating a copy only of the objects that are to be changed by a request the present invention enables a database including a large number of objects to be quickly and efficiently backed up. Additionally, it allows the system to be reverted to its previous state quickly and efficiently as only the objects which were modified by the request are altered.
- After creating a back up request, the request may be imported into the system causing the system to be amended by importing the one or more objects.
- In response to an input to reverse the request, the objects that were copied in the back up request may be reimported into the system.
- The request may include an identifier for the back up request. Alternatively, the back up request includes an identifier of the request. This enables the corresponding back up request to be quickly identified enabling reversal of any change that has unwanted consequences.
- The back up request may be deleted after a predetermined length of time.
- Optionally, a request implementing a change to an object no version history is stored, in the data system and, upon identifying a request implementing a non-reversible change, generating an alert and, optionally, causing the alert to be displayed on a display. The change may be non-reversible. A change that is non-reversible, for example, where no version history is stored of the contents of the object, cannot be reversed by the system as no previous versions are stored and there is no record of the previous state of the object data. An example of such a non-reversible change in an SAP system is the creation, update or deletion of data in a table.
- The processor is configured to identify a backup request implementing a non-reversible change to an object in the data system and, upon identifying a backup request implementing a non-reversible change, generating an alert and, optionally, causing the alert to be displayed on a display. This allows a user to be informed that the restoration may not include all of the data required for a complete restoration and enable them to ensure that all of the relevant data is entered. For example, if the non-reversible change is a deletion of a column although the restoration will allow a user to be aware that the column is not going to be populated with data and, if necessary, repopulate the restored column.
- According to another aspect of the present invention there is provided a method, in a system including a data store and a processor. The method includes receiving a request including one or more objects to be imported into the system, creating a back up request comprising a copy of the objects included within the request as they are present in the system at the time the back up request is created and storing the backup request. The method also includes identifying a backup request implementing a change to an object in the system, the reversal of which may involve a loss of information and, upon identifying the backup request, generating an alert to a user, which may be displayed on a display.
- After creating the back up request, the request can be imported into the system causing the system to be amended by importing the one or more objects.
- In response to an input to reverse the request, the objects comprising the back up request may be imported into the system.
- According to a further aspect of the present invention there is provided a computer program embodied on a computer readable medium which, when executed on a processor in a data system causes the processor to: upon receiving a request including one or more objects to be imported into the system; create a backup request comprising a copy of the objects included within the request as they are present in the system at the time the back up request is created; store the backup request; and identify a backup request implementing a change to an object in the system, the reversal of which may involve a loss of information and, upon identifying the backup request, generate an alert to a user, which may be displayed on a display.
-
-
Figure 1 illustrates a data system in which the present invention may be implemented; -
Figure 2 illustrates a transport request; -
Figure 3 is a flow diagram of a method according to the present invention; -
Figure 4 illustrates a back up transport request; -
Figure 5 illustrates a table in the data system; -
Figure 6 illustrates a transport request which implements a change to the table of -
Figure 5 ; and -
Figure 7 illustrates a back up transport request for the transport request ofFigure 6 . - A method of the present invention will now be described with reference to
Figure 3 . This method is suitable for implementation in any suitable data system and, in particular, may be implemented in a SAP (TM) system such as the system described inUK patent application no 1309320.8 - S1: A development request for the system is received.
- S2: A transport request is created within the development system.
- S3: As work is done in response to the development request it is assigned to the transport request so that the transport request includes all of the data, parameters, and all of the steps required by the request. An example of a transport request is illustrated in
Figure 2 . InFigure 2 the data files include program Z which is a program to be imported into the system and the objects included in the co-files folder of the transport request include a new function of reporting program Z. - S4: Once the work has been completed the transport request is moved into the test system and implemented.
- S5: In the test system the need for further changes to the code included in the transport request can be identified. If further changes are required then the transport request is passed back to the development system for further work. If no further changes are required the transport request can be imported into the production system.
- S6: Before the transport request is imported into the production system a back up of objects within the production system that will be altered by the transport request is created. This may be created, for example using a back up transport request as illustrated in
Figure 4 . A back up transport request is a copy of the objects as listed in the data section of the transport request as they appear in the production system immediately prior to the importation of the transport request. The back up transport request is released from the production system. This results in a copy of all of the objects being stored in the data file of the backup transport request. This execution is recorded in the logs contained within the transport request. The executed back up transport request is stored with a link to the original transport request. This link may be any suitable link, for example, the back up transport request may be amended to include an identifier of the transport request. - S7: The transport request is imported into the production system.
- S8: The system is monitored for errors.
- S9: If no errors occur in the system as the result of the implementation of the transport request then the back up transport request can be deleted after a predetermined period of time.
- S10: If errors occur within the system then the back up transport request is imported back into the system. When the backup transport request is imported into the system the objects are restored to their previous state and all newly created objects are deleted.
- In this way the changes imported into the system in the transport request are reversed. The imported changes may change the structure of objects within the system and add new objects to the system.
- Broadly, methods and apparatus disclosed herein may relate to identifying a backup request implementing a change to an object in the system, the reversal of which may involve the loss of information. A back up request implementing a change to an object in the system, the reversal of which may involve the loss of information encompasses a SAP instruction implementing a change that can only be undone with loss of data. That is, the change may be reversed, but the system is degraded as a result, for example by data being lost. In particular exemplary methods and apparatus, the backup request will only result in a loss of information in a number of specific scenarios.
- The term "information" as referred to herein encompasses data stored in any objects within a SAP system. The data may relate to the structure of one or more objects in a SAP system. The data may comprise entries made within objects stored within a SAP system. For example, information as referred to herein relates to information associated with a SAP system or any of the contents of a SAP system.
- A loss of information as referred to herein relates to any information that is lost from an SAP system that cannot be retrieved. A loss of information may specifically refer to information that is lost from a SAP system and that cannot be retrieved by either a transport request or a backup transport request. An example of a loss of information would be manual entries of data that have been added to an object in a SAP system and then deleted, wherein the entries of data have not been stored elsewhere in the SAP system.
- An example of a change which might be imported in a transport request and the reversal of which may result in a loss of information is the deletion of a column within a table. SAP has 3 different types of database tables - (1) Configuration, (2) Master data and (3) Transactional data. Configuration data is "customising" that each specific client has when they implement SAP. It might define things like payment methods, customer segments, company codes etc. Exemplary configuration tables have single digits of rows, dozens of rows up to hundreds of rows at an upper end. Configuration tables rarely change since they control how the system functions. In fact, configuration database tables typically only change via transport requests.
- The second type of database table, master data, comprises tables like customer records, vendor records, etc. that change occasionally bit but not excessively. Master data tables typically change more frequently than configuration database tables. Small numbers of customers/vendors might be created each day depending on industry and implementation of the system. Typically, master data database tables might have thousands to tens of thousands of records in them.
- The last type of database table, transactional data, comprises data such as sales orders, meter readings, billing documents etc. Typically, there are thousands, tens of thousands to hundreds of thousands of records being created/updated every day in these tables. Typically, both master data and transactional data tables are updated (rows created, changed, deleted) not by transport requests but by users and automated business processes running in the system through-out the day. Transport requests might be used to change the structure of master data and transactional data database tables, but generally not their contents.
- When a transport request changes a configuration table, a back-up of all of the entries in that table prior to importing the new transport request is typically undertaken. Not only will the structure (fields) of the table be backed up, but also the contents. In this way, if the change is reversed then the previous entries will be added back into the table such that there is no data loss.
- However, it is often not possible or infeasible do to backup all of the data each time for master or transactional tables because the amount of data is very high. Typically, if a transport request is applied that removes a column on one of those tables the data would not be backed up for restoring the data in the column that is reinstated after deployment of a back-up request.
- Exemplary methods and apparatus disclosed herein are for use on database tables when no back-up of data is undertaken. This may be because it is not possible or infeasible to back-up the data, for example, due to high data volumes. Exemplary methods and apparatus disclosed herein may be used with master data and transactional data database tables.
- For example, a production system may include a table C001 as illustrated in
Figure 5 , which may be a master data or transactional data database table. C001 has three columns, namely Country Code, Description and Currency. A transport request as illustrated inFigure 6 includes an entry requesting, that for C001, the currency column is deleted. A back up request is generated and implemented in the production system. After its implementation in the production system the transport request appears as illustrated inFigure 7 . Thus, it can be seen in the back up transport request the structure of C001 is stored. - Before the transport request is imported into the production system, a backup transport request can be created. The backup transport request may comprise a copy of the state of objects in the production system prior to implementation of the transport request. In the example of C001, the backup transport request would include a copy of the structure of the table as it appeared in the production system prior to the transport request being imported (i.e. the table including the Currency column). The back up transport request may be created in the production system. After it is created, the backup request would appear as illustrated in
Figure 7 . Thus, as can be seen inFigure 7 , the structure of C001 is stored. - Although the previous structure of C001 is stored in the back up request, the data that is removed from the table during the implementation of the transport request may not be. In other words, the structure of C001 and the format of the currency column may be stored in the back up request, but the individual entries within the currency column may not be stored. By implementing the backup request in the production system after the transport request has been imported to the system, the original structure of C0001 may be restored. It may not be possible to reinstate the data that once populated the currency column using the back up request.
- In other embodiments, the backup transport request may store data included in objects as well as the structure of the objects themselves.
- A similar problem may arise in the opposite direction. That is, a backup request may result in a loss of information. The information that is lost may not be able to be obtained from an original transport request.
- To elaborate on this point by way of example, a transport request which alters the structure of a table by the addition of a column may be imported into a production system. The transport request may also include provisions for data to be added to the new column. In addition or alternatively, data may be manually entered into the column of the table in question by an employee. A variety of other manual or automatic processes may populate the column. If the backup request is then subsequently imported into the production system, this will reverse the changes made to the table accordingly. The column that was added to the table according to the earlier transport request will be deleted in the production system. The data in the added column will also be deleted in the production system.
- It may be possible to reverse changes to the table resulting from the implementation of the backup request. By once again importing the transport request into the production system, it may be possible to reinstate the additional column into the table. However, it may not be possible to reinstate any data that has been added to the additional column of the table in-between the first implementation of the transport request and the implementation of the backup request. In this scenario, although a change resulting from the implementation of a transport request or a backup transport request may be reversible to an extent, there may be certain repercussions from implementing certain transport requests. These repercussions primarily involve the loss of information from the production system.
- The system may be configured to detect when a transport request or back up transport request involves the implementation of a change where the structure of one or more objects in the production system is altered. Further, the system may be configured to detect where a change in structure to an object potentially involves the loss of information contained within the object or in connection with the object. In exemplary methods and apparatus, the system may determine when a transport request is to be executed on a master data or transactional data database and/or when it is not possible or infeasible to back up data in a table before a transport request is executed, for example because the volume of data is too great to be stored.
- In the event that such a change is detected in a transport request, the system may generate an alert to a user before implementing the transport request. Further, the system may generate an alert to the user before importing a backup transport request if it involves the change to the structure of one or more objects.
- In addition or alternatively, the system may generate alerts to the user where any transport or back up transport request is to be imported into the production system and the request involves a change to the structure of one or more objects which may lead to a loss of information.
- Additionally, such alerts may allow the user to choose not to import a transport request of a back up transport request into the production system. The alerts may be visual on a display, but may take any other suitable form. For example, the alert may be auditory or physical, such as through vibration.
- Although the previous structure of the table is stored the data that is removed from that table by deleting the currency column is not stored. Optionally, the system may be configured to detect when a transport request includes a configuration change where the structure of an object is altered. Examples of a configuration change include a deletion of a column in a table. In the event that a configuration change is detected the system may generate an alert to the user before implementing the transport request. Further the system may additionally, or alternatively, generate an alert to the user before importing a backup transport request to reverse a transport request where a configuration change has occurred. This will alert the user to the fact that data may have to be input into the object. For example, the alert may indicate to the user that the column currency is being restored to Table 001. Additionally, such an alert allows a user to choose not to import the backup transport request into the data system. Further, the data of the configuration table may be stored within the backup transport request so that after reversing out the structural column change, the data within that table can also be restored.
- Examples of other objects that might be included within a transport request are: programs, data elements, structures, tables, functions.
- Although the back up transport request has been described as being linked to the transport request by including an identifier for the transport request in the back up transport request it is clear that any suitable method may be used to link the transport request and back up transport request. For example, the system may be provided with a table which stores transport request identifiers in association with the identifier for their related back up transport request or the identifier of the back up transport request may be added to the transport request. The identifier of the back up transport request or transport request may be stored for example, as an attribute of the transport request.
Claims (13)
- A system including a data store and a processor configured to, upon receiving a request including one or more objects to be imported into the system, perform the steps of:creating a back up request comprising a copy of the objects included within the request as they are present in the system at the time the back up request is created;storing the backup request,
whereinthe processor is configured to identify a back up request implementing a change to an object in the system, the reversal of which may involve a loss of information and, upon identifying the backup request, generate an alert to a user. - A system as claimed in claim 1 wherein the processor is further configured to, after creating a back up request, import the request into the system causing the system to be amended by importing the one or more objects.
- A system as claimed in claim 2 wherein, in response to an input to reverse the request, the processor imports the objects comprising the back up request into the system.
- A system as claimed in any one of the preceding claims wherein the request includes the identifier of the back up request and/or the back up request includes an identifier of the request.
- A system as claimed in any one of the preceding claims wherein the back up request is deleted after a predetermined length of time.
- A system as claimed in any one of the preceding claims wherein the processor is configured to identify a request implementing a change to an object where no version history is stored in the data system and, upon identifying the request, generate an alert to a user.
- A method, in a system including a data store and a processor comprising:receiving a request including one or more objects to be imported into the system;creating a back up request comprising a copy of the objects included within the request as they are present in the system at the time the back up request is created;storing the backup request; andidentifying a backup request implementing a change to an object in the system, the reversal of which may involve a loss of information and, upon identifying the backup request, generating an alert to a user.
- A method as claimed in claim 7 wherein, after creating the back up request, the method comprises importing the request into the system causing the system to be amended by importing the one or more objects.
- A method as claimed in claim 7 or claim 8 further comprising, in response to an input to reverse the request, importing the objects comprising the back up request into the system.
- A computer program embodied on a computer readable medium which, when executed on a processor in a data system causes the processor to perform the method of any one of claims 7 to 9.
- A method substantially as described with reference to and shown in Figures 3 to 7.
- A device substantially as described with reference to and shown in Figures 3 to 7.
- A computer program substantially as described with reference to and shown in Figures 3 to 7.
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
GB1314506.5A GB2512958A (en) | 2013-08-13 | 2013-08-13 | Method and apparatus for implementing changes within a data system |
Publications (2)
Publication Number | Publication Date |
---|---|
EP2846264A1 true EP2846264A1 (en) | 2015-03-11 |
EP2846264B1 EP2846264B1 (en) | 2016-06-08 |
Family
ID=49262129
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
EP14180810.5A Active EP2846264B1 (en) | 2013-08-13 | 2014-08-13 | Method and apparatus for implementing changes within a data system |
Country Status (3)
Country | Link |
---|---|
US (1) | US9575838B2 (en) |
EP (1) | EP2846264B1 (en) |
GB (1) | GB2512958A (en) |
Families Citing this family (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108319466A (en) * | 2017-12-15 | 2018-07-24 | 北京先进数通信息技术股份公司 | A kind of restoration methods and device of configuration information |
CN115756968B (en) * | 2022-12-02 | 2023-07-21 | 西安货达网络科技有限公司 | Data backup method and system based on network and cloud platform |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20030126159A1 (en) * | 2001-12-28 | 2003-07-03 | Nwafor John I. | Method and system for rollback of software system upgrade |
US7272600B1 (en) * | 2004-03-24 | 2007-09-18 | Sun Microsystems, Inc. | Migrating large data sets for products upgrades |
US20080114771A1 (en) * | 2006-11-15 | 2008-05-15 | Bharat Welingkar | Device-side data de-duping |
US20080155526A1 (en) * | 2006-12-22 | 2008-06-26 | Parag Gokhale | Point in time rollback and un-installation of software |
Family Cites Families (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6438749B1 (en) * | 1999-03-03 | 2002-08-20 | Microsoft Corporation | Method and system for restoring a computer to its original state after an unsuccessful patch installation attempt |
US7085957B2 (en) * | 2002-11-21 | 2006-08-01 | Texas Instruments Incorporated | Upgrading of firmware with tolerance to failures |
US7908600B2 (en) * | 2005-06-30 | 2011-03-15 | Oracle International Corporation | Fault-tolerant patching system |
US9158633B2 (en) * | 2013-12-24 | 2015-10-13 | International Business Machines Corporation | File corruption recovery in concurrent data protection |
-
2013
- 2013-08-13 GB GB1314506.5A patent/GB2512958A/en not_active Withdrawn
-
2014
- 2014-08-13 US US14/458,827 patent/US9575838B2/en active Active
- 2014-08-13 EP EP14180810.5A patent/EP2846264B1/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20030126159A1 (en) * | 2001-12-28 | 2003-07-03 | Nwafor John I. | Method and system for rollback of software system upgrade |
US7272600B1 (en) * | 2004-03-24 | 2007-09-18 | Sun Microsystems, Inc. | Migrating large data sets for products upgrades |
US20080114771A1 (en) * | 2006-11-15 | 2008-05-15 | Bharat Welingkar | Device-side data de-duping |
US20080155526A1 (en) * | 2006-12-22 | 2008-06-26 | Parag Gokhale | Point in time rollback and un-installation of software |
Also Published As
Publication number | Publication date |
---|---|
US9575838B2 (en) | 2017-02-21 |
GB2512958A (en) | 2014-10-15 |
EP2846264B1 (en) | 2016-06-08 |
GB201314506D0 (en) | 2013-09-25 |
US20150082086A1 (en) | 2015-03-19 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
EP3308297B1 (en) | Data quality analysis | |
US8793230B2 (en) | Single-database multiple-tenant software system upgrade | |
US8200614B2 (en) | Apparatus and method to transform an extract transform and load (ETL) task into a delta load task | |
US10956911B2 (en) | System and method of managing data injection into an executing data processing system | |
US10353878B1 (en) | Method and system for cloning enterprise content management systems | |
US20090307277A1 (en) | Generation of database deltas and restoration | |
AU2014233672A1 (en) | System for metadata management | |
US9092576B2 (en) | Non-intrusive measurement of content quality using dry runs with roll-back | |
US8935207B2 (en) | Inspecting replicated data | |
US9058367B2 (en) | Methods and systems for staging and propagating data | |
US20190196930A1 (en) | System and method for recording the beginning and ending of job level activity in a mainframe computing environment | |
US9575838B2 (en) | Method and apparatus for implementing changes within a data system | |
Saranya et al. | Data migration using etl workflow | |
US9665438B2 (en) | System and method for the production of job level pre-processed backup of critical data and/or datasets in a mainframe computing environment | |
US9317526B1 (en) | Data protection compliant version control | |
CN102682038A (en) | Database change method and device | |
CN111435306A (en) | Code management method and device | |
EP3905058A1 (en) | Systems and methods for monitoring user-defined metrics | |
US20230168939A1 (en) | Definition and implementation of process sequences | |
US20190095058A1 (en) | Determining a user interface | |
Morton | Data Movement | |
US20190019123A1 (en) | Self-sustainable objects within deployable processes | |
Wayne et al. | Small Non-Linear Solver | |
US20200065238A1 (en) | Non-Intrusive Measurement of Content Quality Using Dry Runs with Roll-back | |
Price | Moving Beyond Masking and Subsetting: Realizing the Value of Test Data Management |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
17P | Request for examination filed |
Effective date: 20140813 |
|
AK | Designated contracting states |
Kind code of ref document: A1 Designated state(s): AL AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HR HU IE IS IT LI LT LU LV MC MK MT NL NO PL PT RO RS SE SI SK SM TR |
|
AX | Request for extension of the european patent |
Extension state: BA ME |
|
PUAI | Public reference made under article 153(3) epc to a published international application that has entered the european phase |
Free format text: ORIGINAL CODE: 0009012 |
|
GRAP | Despatch of communication of intention to grant a patent |
Free format text: ORIGINAL CODE: EPIDOSNIGR1 |
|
RIC1 | Information provided on ipc code assigned before grant |
Ipc: G06F 9/44 20060101ALI20151210BHEP Ipc: G06F 11/14 20060101AFI20151210BHEP |
|
INTG | Intention to grant announced |
Effective date: 20160114 |
|
GRAS | Grant fee paid |
Free format text: ORIGINAL CODE: EPIDOSNIGR3 |
|
GRAA | (expected) grant |
Free format text: ORIGINAL CODE: 0009210 |
|
AK | Designated contracting states |
Kind code of ref document: B1 Designated state(s): AL AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HR HU IE IS IT LI LT LU LV MC MK MT NL NO PL PT RO RS SE SI SK SM TR |
|
REG | Reference to a national code |
Ref country code: GB Ref legal event code: FG4D |
|
REG | Reference to a national code |
Ref country code: CH Ref legal event code: EP |
|
REG | Reference to a national code |
Ref country code: IE Ref legal event code: FG4D |
|
REG | Reference to a national code |
Ref country code: DE Ref legal event code: R096 Ref document number: 602014002242 Country of ref document: DE |
|
REG | Reference to a national code |
Ref country code: AT Ref legal event code: REF Ref document number: 805682 Country of ref document: AT Kind code of ref document: T Effective date: 20160715 |
|
REG | Reference to a national code |
Ref country code: FR Ref legal event code: PLFP Year of fee payment: 3 |
|
REG | Reference to a national code |
Ref country code: LT Ref legal event code: MG4D |
|
REG | Reference to a national code |
Ref country code: NL Ref legal event code: MP Effective date: 20160608 |
|
PG25 | Lapsed in a contracting state [announced via postgrant information from national office to epo] |
Ref country code: LT Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 Ref country code: FI Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 Ref country code: NO Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160908 |
|
REG | Reference to a national code |
Ref country code: AT Ref legal event code: MK05 Ref document number: 805682 Country of ref document: AT Kind code of ref document: T Effective date: 20160608 |
|
PG25 | Lapsed in a contracting state [announced via postgrant information from national office to epo] |
Ref country code: SE Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 Ref country code: NL Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 Ref country code: RS Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 Ref country code: HR Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 Ref country code: ES Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 Ref country code: GR Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160909 Ref country code: LV Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 |
|
PG25 | Lapsed in a contracting state [announced via postgrant information from national office to epo] |
Ref country code: BE Free format text: LAPSE BECAUSE OF NON-PAYMENT OF DUE FEES Effective date: 20160831 |
|
PG25 | Lapsed in a contracting state [announced via postgrant information from national office to epo] |
Ref country code: SK Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 Ref country code: IT Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 Ref country code: EE Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 Ref country code: IS Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20161008 Ref country code: CZ Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 Ref country code: RO Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 |
|
PG25 | Lapsed in a contracting state [announced via postgrant information from national office to epo] |
Ref country code: BE Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 Ref country code: AT Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 Ref country code: PL Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 Ref country code: PT Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20161010 Ref country code: SM Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 |
|
REG | Reference to a national code |
Ref country code: DE Ref legal event code: R097 Ref document number: 602014002242 Country of ref document: DE |
|
PG25 | Lapsed in a contracting state [announced via postgrant information from national office to epo] |
Ref country code: MC Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 |
|
PLBE | No opposition filed within time limit |
Free format text: ORIGINAL CODE: 0009261 |
|
STAA | Information on the status of an ep patent application or granted ep patent |
Free format text: STATUS: NO OPPOSITION FILED WITHIN TIME LIMIT |
|
26N | No opposition filed |
Effective date: 20170309 |
|
PG25 | Lapsed in a contracting state [announced via postgrant information from national office to epo] |
Ref country code: DK Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 Ref country code: SI Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 |
|
REG | Reference to a national code |
Ref country code: IE Ref legal event code: MM4A |
|
PG25 | Lapsed in a contracting state [announced via postgrant information from national office to epo] |
Ref country code: IE Free format text: LAPSE BECAUSE OF NON-PAYMENT OF DUE FEES Effective date: 20160813 |
|
PG25 | Lapsed in a contracting state [announced via postgrant information from national office to epo] |
Ref country code: LU Free format text: LAPSE BECAUSE OF NON-PAYMENT OF DUE FEES Effective date: 20160813 |
|
REG | Reference to a national code |
Ref country code: FR Ref legal event code: PLFP Year of fee payment: 4 |
|
REG | Reference to a national code |
Ref country code: CH Ref legal event code: PL |
|
PG25 | Lapsed in a contracting state [announced via postgrant information from national office to epo] |
Ref country code: CH Free format text: LAPSE BECAUSE OF NON-PAYMENT OF DUE FEES Effective date: 20170831 Ref country code: LI Free format text: LAPSE BECAUSE OF NON-PAYMENT OF DUE FEES Effective date: 20170831 |
|
PG25 | Lapsed in a contracting state [announced via postgrant information from national office to epo] |
Ref country code: HU Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT; INVALID AB INITIO Effective date: 20140813 |
|
PG25 | Lapsed in a contracting state [announced via postgrant information from national office to epo] |
Ref country code: MT Free format text: LAPSE BECAUSE OF NON-PAYMENT OF DUE FEES Effective date: 20160831 Ref country code: CY Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 Ref country code: MK Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 |
|
REG | Reference to a national code |
Ref country code: FR Ref legal event code: PLFP Year of fee payment: 5 |
|
PG25 | Lapsed in a contracting state [announced via postgrant information from national office to epo] |
Ref country code: BG Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 |
|
PG25 | Lapsed in a contracting state [announced via postgrant information from national office to epo] |
Ref country code: TR Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 Ref country code: AL Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20160608 |
|
PGFP | Annual fee paid to national office [announced via postgrant information from national office to epo] |
Ref country code: FR Payment date: 20230620 Year of fee payment: 10 |
|
PGFP | Annual fee paid to national office [announced via postgrant information from national office to epo] |
Ref country code: GB Payment date: 20230622 Year of fee payment: 10 |
|
PGFP | Annual fee paid to national office [announced via postgrant information from national office to epo] |
Ref country code: DE Payment date: 20230620 Year of fee payment: 10 |