JP2009271839A - Information processing system, information processing method, program and recording medium - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To prevent data inconsistency from being expanded when it occurs due to failure in a loosely coupled system, and to allow a manager to quickly take recovery action. <P>SOLUTION: After updating an application DB, an application server instructs a workflow server to update a workflow DB. When the workflow DB is normally updated, the application server commits the application DB, and when the commitment is normally completed, the application server instructs the workflow server to release the temporary stop state of the workflow DB. Meanwhile, when the commitment fails, the application server does not instruct releasing the temporary stop state. The workflow server updates the workflow state of the workflow DB according to the update instruction from the application server, temporarily stops the workflow DB, commits the workflow DB, then notifies the application server of the update result, and releases the temporary stop state according to the instruction for releasing the temporary stop state from the application server. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to an information processing system in which a web application server on which a web application (business application) runs and a workflow server are loosely coupled via a network, and more particularly to control when a failure occurs.

  In a loosely coupled system (for example, a system composed of a web application and a workflow application), it is very difficult to maintain data consistency at the time of failure.

  In general, between tightly coupled applications, all applications support 2-phase commit, etc., and the data atomicity (all processing is completed (committed) when the transaction ends). It is possible to maintain a high probability of being in a state of being in a state of being rolled back or not being performed at all).

  However, even in this case, data consistency cannot be completely guaranteed due to a phenomenon such as a communication failure.

Patent Document 1 shows that it is possible to maintain consistency between the workflow state and the application state. However, as described above, there is a possibility that data inconsistency may occur due to a communication failure. The recovery procedure from the inconsistent state is not shown.
JP 2000-29956 A

  However, loosely coupled applications that are strongly independent from each other have no system that plays the role of monitoring the entire transaction, making it more difficult to maintain data consistency in the event of a failure.

  If a failure occurs, if cancellation processing is performed, consistency can be restored, but it is difficult to specify the range of data to be canceled, and the work becomes complicated.

  The present invention has been made to solve the above-described problems. The object of the present invention is to prevent data failure at the time of failure in a loosely coupled system when complete data integrity cannot be realized due to failure. It is based on the premise of consistency, and further prevents the data inconsistency from being expanded, and provides a mechanism that can easily and quickly restore the data inconsistency by the operation of the administrator.

  The present invention is an information processing system in which a web application server on which a web application operates and a workflow server are configured to be loosely coupled via a network, the web application server being managed by the web application server Web application database updating means for updating the database, and a workflow database for instructing the workflow server to update the workflow state of the workflow database managed by the workflow server after updating by the web application database updating means When receiving an update instruction means and an update result indicating that the workflow state has been normally updated from the workflow server, the update means A commit processing unit that performs a commit process on the updated web application database, and when the commit process by the commit processing unit is normally completed, the workflow server is instructed to release the suspended state of the workflow database, On the other hand, if the commit processing by the commit processing unit results in an error, the suspension cancellation instruction control unit that does not instruct the workflow server to cancel the suspension state of the workflow database, and the workflow server includes the web application server In response to an update instruction from the workflow database, a workflow database update unit that updates a workflow state of the workflow database, and workflow data updated by the workflow database update unit A suspension means for temporarily suspending the service, and an update result notifying means for notifying the web application server of the update result after commit processing is performed on the workflow database that has been suspended by the suspension means, In accordance with a pause cancellation instruction from the web application server, the system has a pause cancellation means for canceling the pause state of the workflow database.

  According to the present invention, when a data inconsistency occurs due to a failure in a loosely coupled system, the data inconsistency is not further expanded, and the data inconsistency can be quickly recovered by the operation of the administrator. There is an effect such as being able to.

  FIG. 1 is a system configuration diagram showing an example of an information processing system showing an embodiment of the present invention. In this example, the configuration of the workflow application in the core business is shown.

  In FIG. 1, 001, 002 is an application server (web application server). The application server 1 (001) and the application server 2 (002) execute a business application (web application) for business processing (for example, an order receiving system, a shipping system, etc.). The application server 1 (001) and the application server 2 (002) store the business data (order information, inventory information, shipping information) in the application DB 005 (web application database).

  The workflow server 003 performs workflow operation (approval, denial, return, etc.) processing according to the workflow path information, and stores the information in the workflow DB 004 (workflow database).

  The client browser 006 indicates a web browser that operates as a web client on the client terminal. The client browser 006 communicates with the application server 1 (001), the application server 2 (002), and the workflow server 003 via the network 007 in accordance with a user instruction, and performs application processing.

  This information processing system is a loosely coupled system composed of highly independent business applications and workflow applications. In general, loose coupling refers to a state in which the individual components that are subdivided are relatively loosely connected and strongly independent.

  In the figure, 001 to 006 may be mounted on different information processing apparatuses, or any or all of them may be mounted on the same information processing apparatus.

  FIG. 2 is a block diagram illustrating an example of a hardware configuration of an information processing apparatus applicable to each apparatus configuring the information processing system illustrated in FIG.

  In FIG. 2, reference numeral 101 denotes a CPU, which comprehensively accesses various devices connected to the system bus based on a control program stored in a ROM 103 or an external storage device (hard disk (HD) or the like) 104. Control.

  Reference numeral 102 denotes a RAM that functions as a main memory, work area, and the like for the CPU 101. The ROM 103 or HD 104 stores a BIOS (Basic Input / Output System) or an operating system (OS) program, which is a control program for the CPU 101, and various programs necessary for causing the CPU to execute the processes shown in the flowcharts to be described later. Yes. The CPU 101 implements various functions by loading necessary programs and the like into the RAM 102 and executing them.

  Reference numeral 105 denotes an input device such as a keyboard or a mouse. Reference numeral 106 denotes a display device such as an LCD or CRT. A network interface card (NIC) 107 is configured to be able to communicate with other apparatuses via a network 007 such as a LAN or WAN.

  Hereinafter, with reference to the sequence chart of FIG. 3, a processing procedure in the case where the business processing is performed by the business application and the workflow processing is performed by the workflow server will be described. This process is started according to a request input from the client. Here, an example is given of the case where order acceptance processing and inventory allocation processing are performed by the order acceptance system.

  3 and 4 are sequence charts showing an example of a processing procedure when business processing is performed by a business application and workflow processing is performed by the workflow server. FIG. 3 corresponds to the case where no mismatch occurs between the DBs even if an error occurs. On the other hand, FIG. 4 corresponds to the case where inconsistency occurs between the DBs due to the occurrence of an error. In FIG. 3 and FIG. 4, the same number is assigned to the same process.

  Furthermore, in the sequence charts of FIGS. 3 and 4, the processing of the application server is performed by a program stored in the external storage device 104 by the CPU 101 of the information processing device that implements the application server (for example, application server 1 (001)). It is realized by being loaded into the RAM 102 and executed, and hereinafter, described as being executed by the application server. Further, the processing of the workflow server 003 is realized by the CPU 101 of the information processing apparatus that implements the workflow server being loaded into the RAM 102 and executing the program stored in the external storage device 104. It is described that the server 003 executes.

  First, it demonstrates using FIG.

  First, in FIG. 3, in S2001, the application server (for example, application server 1 (001)) instructs the application DB 005 to start a transaction.

  In S2002, the application server writes data to the application DB 005. For example, data is updated such as storage of order information and reduction in the number of merchandise inventory due to inventory allocation.

  Next, in S2003, the application server requests the approval process together with the case number from the workflow server 003. Here, it is assumed that the slip number has been transferred to the application server from the process waiting list screen of the workflow server 003 in advance.

  In step S2004, the workflow server 003 receives an approval processing request (S2003) from the application server, and instructs the workflow DB 004 storing the workflow information to start a transaction.

  In step S2005, the workflow server 003 updates data (case) related to the case number passed from the application server of the workflow DB 004 for approval processing.

  In step S2006, the workflow server 003 changes the state of the matter managed by the workflow DB 004 to the suspend state.

  In step S2007, the workflow server 003 instructs the workflow DB 004 to commit. Commit means to finalize the result when transaction processing is successful. Here, an instruction to confirm the result of the updated workflow DB 004 is issued.

  In S2005 to S2007, when an error occurs in the workflow server 003 or the workflow DB 004, the workflow server 003 performs a rollback process on the workflow DB 004 and notifies the application server of the occurrence of the error. Upon receiving this notification, the application server can roll back the application DB 005. Note that the above error occurs, for example, when a failure occurs in the workflow DB 004.

  When the processes in S2005 to S2007 are normally completed, in S2008, the workflow server 003 notifies the application server that the approval process is completed.

  In step S2009, the application server that has confirmed the normal termination by receiving this notification instructs the application DB 005 to commit.

  When the commit of the application DB 005 instructed in S2009 is completed, in S2010, the application server requests the workflow server 003 to change the case state from the suspend state to the resume state together with the case number.

  In step S2011, the workflow server 003 changes the state of the matter managed by the workflow DB 004 from the suspend state to the resume state.

  Here, the resume state and the suspend state indicating the state of the case will be described.

  The status of the matter managed by the workflow server 003 is held in the workflow DB 004 so that the matter is always in either the resume state or the suspend state. When the workflow server 003 operates on a matter (approval, rejection, send back, withdrawal, etc.), if the matter is not in the resume state, it cannot be operated and an error occurs. That is, the resume state indicates a state in which the matter can be operated (completed). On the other hand, the suspend state indicates a state where the matter cannot be operated (temporary suspension).

  Note that in the sequence shown in FIG. 3, when an error due to a network or device failure occurs, inconsistency may occur in the data of the application DB 005 and the workflow DB 004.

  If an error occurs in S2001 to S2007, both the application DB 005 and the workflow DB 004 are rolled back as described above, so that there is no inconsistency between the DB contents.

  That is, not only the application DB 005 is rolled back, but also the workflow DB 004 is not approved and the workflow processing does not proceed, so that no inconsistency occurs. Therefore, in such a case, the problem to be solved by the present invention does not occur.

  Next, a case where inconsistency occurs in the contents of the application DB 005 and the workflow DB 004 due to the occurrence of an error will be described with reference to FIG.

  As shown in S2110 of FIG. 4, when an error occurs in the commit process executed by the application server in S2009, the application DB 005 is rolled back as shown in S2111. On the other hand, the workflow DB 004 has been approved in S2005, and an inconsistency occurs between the application DB 005 and the workflow DB 004.

  However, since the state of the matter remains in the suspend state (S2006), the workflow server 003 cannot perform other operations on the matter, so that the approval process can be continued further. It becomes impossible.

  Hereinafter, with reference to the flowchart of FIG. 5, processing of the application server when no inconsistency occurs between the DBs even when the error illustrated in FIG. 3 occurs will be described.

  FIG. 5 is a flowchart showing an example of the operation of the application server (for example, application server 1 (001)). In each step (S2201 to S2217) in this flowchart, the CPU 101 of the information processing apparatus that implements the application server (for example, application server 1 (001)) loads the program stored in the external storage device 104 into the RAM 102. In the following description, the application server executes.

  In S2201, the application server checks whether the recovery mode in the session is true. In the case of normal processing as shown in FIGS. 3 and 4, the determination in S2201 is false (N). In S2201, the application server determines that it is not in the recovery mode, and advances the process to S2202.

  In step S2202, the application server initializes a workflow state (including a case number and processing information) that is held and managed in the memory on the application server side. The application server initializes the matter number with the matter number of the matter to be processed currently received from the workflow server 003 in advance. In addition, the application server initializes the processing state indicating the processing state of the currently processed case with “unprocessed” (in this case, “unprocessed” because it is before processing).

  Next, in S2203, the application server separately saves a copy of the workflow state initialized in S2202 in the memory on the application server side.

  In step S2204, the application server instructs the application DB 005 to start a transaction, as in step S2001 in FIG.

  Next, in S2205, the application server performs update processing of the application DB 005 as in S2002 of FIG. Also, the DB update data log is output to the log on the application server (FIG. 6).

  FIG. 6 is a diagram showing an output example (DB update data log) of the log output in S2205 of FIG.

  Next, in S2206, the application server determines whether an error has occurred in the processing of S2205. If it is determined that an error has occurred, the application server rolls back the application DB 005 in S2207 and ends the processing.

  On the other hand, if it is determined in S2206 that no error has occurred in the process of S2205, the application server advances the process to S2208.

  In S2208, the application server checks whether the recovery mode in the session is true. In the case of FIGS. 3 and 4, since the recovery mode is not true (because of the normal mode), the next S2209 is performed to perform the workflow processing. Proceed with the process.

  In S2209, the application server instructs the workflow server 003 to perform the workflow process (approval process) (S2003 in FIG. 3), and the process proceeds to S2210.

  In step S2210, the application server changes the workflow processing state to “processed” because the workflow processing has been completed. The workflow processing state is for use in determining the state (valid or invalid) of a button displayed on the client, which will be described later. Using this workflow processing state, for example, the approval button can be invalidated on the screen after processing once the approval processing has been performed.

  Next, in S2211, when the application server confirms the completion of the workflow processing (S2008 in FIG. 3), the application server instructs the application DB 005 to commit (S2009 in FIG. 3).

  Next, in S2212, the application server determines whether a commit processing error in S2211 has occurred. In the case illustrated in FIG. 3, since it does not occur, the application server determines that S2212 is false (N), and advances the processing to S2214.

  In S2214, the application server determines whether the operation mode is the recovery mode. In the case of normal processing as shown in FIG. 3, the determination in S2214 is false (N). If the application server determines in S2214 that it is not in the recovery mode, in S2215, the workflow server 003 changes the matter state from the suspend state to the resume state (releases the suspended state). With request. And the process of this flowchart is complete | finished.

  As described above, the processing of the application server when the inconsistency does not occur between the DBs even when the error shown in S2001 to S2011 in FIG. 3 has been described.

  Hereinafter, with reference to the flowchart of FIG. 5, processing of the application server when inconsistency occurs between the DBs due to the occurrence of the error illustrated in FIG. 4 will be described.

  S2201 to S2211 are the same as those in the case of FIG.

  Next, in S2212, the application server determines whether a commit processing error in S2211 has occurred. Since FIG. 4 shows a case where a commit processing error has occurred, the application server determines that S2212 is true (Y), and advances the processing to S2213.

  In S2213, the application server performs rollback processing of the application DB 005.

  In step S2216, the application server outputs the workflow state separately stored in the memory in step S2203 to the log on the application server (FIG. 7).

  FIG. 7 is a diagram showing an output example (workflow state log) of the log output in S2216 of FIG.

  In FIG. 7, reference numeral 601 denotes a workflow status log, which corresponds to the log indicating the saved workflow status output in S2216 of FIG.

  Although not shown in FIG. 5, when an error occurs, the application server displays an error screen on the operator's client browser and instructs the user to contact the system administrator. Then, the process of the flowchart of FIG.

  In other words, in the case shown in FIG. 4, the state of the case remains in the suspend state (S2006) (since S2215 is not executed). For this reason, the workflow server 003 cannot perform other operations on the case, and does not increase data inconsistency.

  As described above, the processing of the application server when the inconsistency occurs between the DBs due to the occurrence of the error illustrated in S2001 to S2009, 2110, and 2111 in FIG. 4 has been described.

  Next, with reference to FIG. 8, the recovery procedure for the error that occurred in FIG. 4 is shown in FIG.

  FIG. 8 is a sequence chart showing a recovery procedure for the error that occurred in FIG.

  In the sequence chart of FIG. 8, the processing of the application server is performed by the CPU 101 of the information processing device that implements the application server (for example, application server 1 (001)) loads the program stored in the external storage device 104 into the RAM 102. In the following, it is described that the application server executes. Further, the processing of the workflow server 003 is realized by the CPU 101 of the information processing apparatus that implements the workflow server being loaded into the RAM 102 and executing the program stored in the external storage device 104. It is described that the server 003 executes. Further, the processing of the client browser 006 is realized by the CPU 101 of the information processing apparatus that implements the client browser 006 loading the program stored in the external storage device 104 into the RAM 102 and executing the program. It is described that the client browser 006 executes.

  The system administrator receives a notification from the user and extracts the DB update data log (FIG. 6) and the workflow status log (601 in FIG. 7) from the log file output on the application server. Then, the system administrator removes the cause of the DB error (for example, a failure that has occurred in the application DB 005) and then performs the following procedure.

  In response to the operation of the system administrator, the client browser 006 transmits a request for the application server recovery screen (FIG. 9) to the application server in S2301.

  In S2302, the application server transmits a recovery screen (FIG. 9) to the client browser 006 in response to a request from the client browser 006, and causes the client browser 006 to display the recovery screen (FIG. 9).

  FIG. 9 is a diagram illustrating an example of the recovery screen of the application server.

  As shown in FIG. 9, when the recovery screen is displayed on the client browser 006, the system administrator inputs the workflow status log (601 in FIG. 7) acquired from the log file into the workflow information item 801 on the recovery screen ( For example, input by copy and paste). Furthermore, when the transition button 802 is pressed in the recovery mode of the recovery screen by the system administrator, the client browser 006 transmits the workflow status log input in the workflow information item 801 to the application server in step S2303 for recovery. Request mode transition. Based on the request from the client browser 006, the application server sets the recovery mode in the session on the application server to true.

  In step S <b> 2304, the application server generates an application screen when an error occurs from the workflow state log received from the client browser 006.

  In step S2305, the application server transmits the application screen generated in step S2304 to the client browser 006, and causes the client browser 006 to display the application screen (FIG. 10) when an error occurs.

  FIG. 10 is a diagram showing an example of an application screen when an error occurs displayed on the client browser 006 in the recovery mode of the application server.

  At this time, the system administrator needs to input the data again by the system administrator because the data input by the end user is rolled back due to the error in the processing at the time of occurrence of the error. The content to be re-input can be extracted from the DB update data log (FIG. 6).

  For example, the system administrator re-inputs the update content acquired from the DB update data log (FIG. 6) in the remarks 901 of the application screen (FIG. 10) when an error occurs. That is, the system administrator performs the same operation as when an error occurs based on the update content acquired from the DB update data log.

  In step S2306, when the system administrator presses the approval button 902 on the application screen (FIG. 10) when an error occurs, the client browser 006 that detects this operation requests the application server to execute an approval process.

  In response to this request, the application server executes processing in the recovery mode in S2307.

  Hereinafter, the processing of the application server in the recovery mode will be described with reference to the flowchart of FIG.

  In S2201, the application server checks whether the recovery mode in the session is true. In the case of FIG. 8, the determination in S2201 is true (Y). In S2201, the application server determines that it is in the recovery mode, and advances the process to S2217.

  In step S2217, the application server reads the workflow state log (601 in FIG. 6) input from the recovery screen (FIG. 9) by the system administrator in step S2301, and restores the workflow state object in the memory. Then, the application server advances the process to S2204.

  S2204 to S2207 are the same as those in FIGS.

  In S2208, the application server checks whether the recovery mode in the session is true, and in the case of FIG. 8, since the recovery mode is true, the workflow process is not performed, and the process directly proceeds to S2210.

  In step S2210, the application server changes the workflow processing state to “processed” as illustrated in the cases of FIGS. This process needs to be updated so that it can be used to determine whether the approval button is valid or invalid based on the workflow process state even in the recovery mode.

  Next, in S2211, the application server instructs the application DB 005 to commit (S2009 in FIG. 3).

  Next, in S2212, the application server determines whether or not the commit processing error in S2211 has occurred. If no error has occurred, the application server advances the process to S2214.

  In S2214, the application server determines whether the operation mode is the recovery mode. In the case of FIG. 8, since it is in the recovery mode, the matter is not resumed, and the processing is ended as it is.

  As described above, the state of the workflow server 003 (workflow DB 004) and the data inconsistency between the application DB 005 are resolved by the procedures 2201 to 2214.

  Thereafter, the system administrator accesses the workflow management screen (FIG. 11) from the client browser 006, selects the relevant case as shown at 702 on the workflow management screen (FIG. 11), and resumes the case. A button 701 is instructed to be pressed. In response to this operation, the workflow server 003 changes the state (702) of the corresponding matter from the suspended state, that is, from the suspend state to the resume state (completed). Thereby, it becomes possible to operate the case thereafter.

  FIG. 11 is a diagram illustrating an example of a workflow management screen.

  As described above, according to the present embodiment, in a loosely coupled system, as shown in FIG. 4, when complete data consistency cannot be realized due to a failure, the information processing system of the present embodiment On the premise of data inconsistency at the time of failure occurrence, the data inconsistency is not further expanded (is in a suspended state). Then, as shown in FIGS. 8 to 11, data inconsistency can be easily and quickly restored by the operation of the administrator.

  Also, the recovery screen is the same as the screen during normal processing, and no special screen for recovery is prepared. Therefore, the burden on the developer who creates the screen for recovery is reduced, and the administrator can recover from the same screen, so that the recovery operation can be easily performed.

  Note that the case where the information processing system of the present embodiment includes the application server (001, 002), the application DB 005, the workflow server 003, and the workflow DB 004 has been described. However, instead of the workflow server 003 and the workflow DB 004, another application server and another application DB may be provided. In the case of this configuration, the configuration as described above enables consistency between the application DB 005 and other application DBs.

  It should be noted that the configuration and contents of the various data described above are not limited to this, and it goes without saying that the various data and configurations are configured according to the application and purpose.

  Although one embodiment has been described above, the present invention can take an embodiment as, for example, a system, apparatus, method, program, or recording medium, and specifically includes a plurality of devices. The present invention may be applied to a system including a single device.

  The configuration of a data processing program that can be read by each information processing apparatus constituting the information processing system according to the present invention will be described below with reference to the memory map shown in FIG.

  FIG. 12 is a diagram for explaining a memory map of a recording medium (storage medium) for storing various data processing programs that can be read by each information processing apparatus constituting the information processing system according to the present invention.

  Although not specifically shown, information for managing a program group stored in the recording medium, for example, version information, creator, etc. is also stored, and information depending on the OS on the program reading side, for example, a program is identified and displayed. Icons may also be stored.

  Further, data depending on various programs is also managed in the directory. In addition, when a program or data to be installed is compressed, a program to be decompressed may be stored.

  The functions shown in FIGS. 3, 4, 5, and 8 in this embodiment may be performed by a host computer by a program installed from the outside. In this case, the present invention is applied even when an information group including a program is supplied to the output device from a recording medium such as a CD-ROM, a flash memory, or an FD, or from an external recording medium via a network. Is.

  As described above, a recording medium in which a program code of software for realizing the functions of the above-described embodiments is recorded is supplied to the system or apparatus, and the computer (or CPU or MPU) of the system or apparatus is stored in the recording medium. It goes without saying that the object of the present invention can also be achieved by reading and executing the program code.

  In this case, the program code itself read from the recording medium realizes the novel function of the present invention, and the recording medium storing the program code constitutes the present invention.

  As a recording medium for supplying the program code, for example, a flexible disk, hard disk, optical disk, magneto-optical disk, CD-ROM, CD-R, DVD-ROM, magnetic tape, nonvolatile memory card, ROM, EEPROM, A silicon disk or the like can be used.

  Further, by executing the program code read by the computer, not only the functions of the above-described embodiments are realized, but also an OS (operating system) or the like running on the computer based on the instruction of the program code. It goes without saying that a case where the function of the above-described embodiment is realized by performing part or all of the actual processing and the processing is included.

  Furthermore, after the program code read from the recording medium is written in a memory provided in a function expansion board inserted in the computer or a function expansion unit connected to the computer, the function expansion is performed based on the instruction of the program code. It goes without saying that the case where the CPU or the like provided in the board or the function expansion unit performs part or all of the actual processing and the functions of the above-described embodiments are realized by the processing.

  Further, the present invention may be applied to a system composed of a plurality of devices or an apparatus composed of a single device. It goes without saying that the present invention can also be applied to a case where the present invention is achieved by supplying a program to a system or apparatus. In this case, by reading a recording medium storing a program represented by software for achieving the present invention into the system or apparatus, the system or apparatus can enjoy the effects of the present invention.

  Furthermore, by downloading and reading out a program represented by software for achieving the present invention from a server, database, etc. on a network using a communication program, the system or apparatus can enjoy the effects of the present invention. It becomes.

  In addition, all the structures which combined each embodiment mentioned above and its modification are also included in this invention.

It is a system configuration figure showing an example of an information processing system showing one embodiment of the present invention. It is a block diagram which shows an example of the hardware constitutions of the information processing apparatus applicable to each apparatus which comprises the information processing system shown in FIG. It is a sequence chart which shows an example of the process sequence when performing business processing with a business application and performing workflow processing with a workflow server.

It is a sequence chart.
It is a sequence chart which shows an example of the process sequence when performing business processing with a business application and performing workflow processing with a workflow server. It is a flowchart which shows an example of operation | movement of an application server. FIG. 6 is a diagram illustrating an output example (DB update data log) of a log output in S2205 of FIG. 5. FIG. 6 is a diagram illustrating an output example (workflow state log) of a log output in S2216 of FIG. 5. 5 is a sequence chart showing a recovery procedure for an error that has occurred in FIG. 4. It is a figure which shows an example of the recovery screen of an application server. It is a figure which shows an example of the application screen at the time of the error displayed on the client browser 006 in the recovery mode of an application server. It is a figure which shows an example of the management screen of a workflow. It is a figure explaining the memory map of the recording medium (storage medium) which stores the various data processing program which can be read by each information processing apparatus which comprises the information processing system which concerns on this invention.

Explanation of symbols

001 Application server 1
002 Application server 2
003 Workflow server 004 Workflow DB
005 Application DB
006 Client browser 007 network

Claims (8)

An information processing system in which a web application server on which a web application operates and a workflow server are configured to be loosely coupled via a network,
The web application server
Web application database update means for updating a web application database managed by the web application server;
Workflow database update instruction means for instructing the workflow server to update the workflow state of the workflow database managed by the workflow server after the update by the web application database update means;
When an update result indicating that the workflow state has been normally updated is received from the workflow server, a commit processing unit that performs a commit process on the web application database updated by the update unit;
When the commit process is normally completed, the workflow server is instructed to cancel the pause state of the workflow database. On the other hand, when the commit process is an error, the temporary stop not instructing to cancel the pause state is performed. Stop cancellation instruction control means;
The workflow server
In response to an update instruction from the web application server, a workflow database update unit that updates a workflow state of the workflow database;
A suspension means for temporarily suspending the workflow database updated by the workflow database update means;
Update result notification means for notifying the web application server of the update result after commit processing is performed on the workflow database that has been paused by the pause means;
In response to the suspension cancellation instruction from the web application server, the suspension cancellation means for canceling the suspension state of the workflow database;
An information processing system comprising: The web application server
Holding means for holding the workflow state of the workflow server at the start of the transaction;
If the commit process results in an error, rollback means for rolling back the web application database;
A workflow state log output unit that outputs the workflow state of the workflow server at the start of the transaction held in the holding unit to a log when rolled back by the rollback unit;
Log input receiving means for receiving an input of a log indicating the workflow state at the start of the transaction output by the workflow state log output means;
Display control means for performing control to display a recovery operation screen for performing an operation for recovering the web application database according to a log indicating a workflow state at the start of the transaction received by the input receiving means;
A recovery means for recovering the web application database in response to an operation from the recovery operation screen;
2. The information processing system according to claim 1, wherein the commit processing unit performs a commit process on the web application database recovered by the recovery unit. The web application server further includes an update content log output unit that outputs the update content to a log when the web application database is updated by the web application database update unit,
The said recovery means recovers the said web application database according to operation from the said recovery operation screen corresponding to the update content described in the log output by the said update content log output means. Item 3. The information processing system according to Item 2. The display control means performs control to display the web application screen at the time of the error occurrence as the recovery operation screen according to the log indicating the workflow state at the start of the transaction,
The recovery means corresponds to the update content described in the log output by the update content log output means, in accordance with the operation at the time of the error occurrence from the web application screen at the time of the error occurrence, the web application database The information processing system according to claim 3, wherein the information processing system is recovered. The web application server further includes setting means for setting a recovery mode as an operation mode of the web application server when the log input is accepted by the log input acceptance means.
5. The information processing system according to claim 4, wherein the web application database update unit operates as the recovery unit when the recovery mode is set. An information processing method in an information processing system in which a web application server on which a web application operates and a workflow server are configured to be loosely coupled via a network,
In the web application server,
A web application database update step in which a web application database update means updates a web application database managed by the web application server;
A workflow database update instructing unit for instructing the workflow server to update the workflow state of the workflow database managed by the workflow server after the update by the web application database updating step; ,
When the commit processing means receives an update result indicating that the workflow state has been normally updated from the workflow server, a commit processing step for performing a commit process on the web application database updated by the update step;
The suspension cancellation instruction control means instructs the workflow server to cancel the suspension state of the workflow database when the commit processing is completed normally, while if the commit processing results in an error, A pause cancellation instruction control step that does not instruct the cancellation of the stop state is executed,
In the workflow server,
A workflow database update means for updating a workflow state of the workflow database in response to an update instruction from the web application server;
A pausing step for pausing the workflow database updated by the workflow database updating step;
An update result notifying unit that performs a commit process on the workflow database that has been suspended by the suspension step, and then notifies the update result to the web application server,
An information processing method, wherein the temporary suspension canceling unit executes a temporary suspension canceling step for canceling a temporary suspension state of the workflow database in response to a temporary suspension canceling instruction from the web application server.   A program for causing a computer to execute the information processing method according to claim 6.   A computer-readable recording medium recording a program for causing a computer to execute the information processing method according to claim 6.

Images