KFAA30955-E
SQL or command processing was canceled and the transaction was rolled back. (information 1 = aa....aa, information 2 = bb....bb) (M+J+O)
Processing of the SQL statement or command was canceled and the transaction was rolled back. <SQLSTATE: 5B002>
When a transaction is forced to terminate using the adbcancel command, the application program is disconnected from the HADB server. Check in the SQL results information whether the application program has been disconnected from the HADB server, and then check whether a KFAA70001-I message was output immediately afterwards.
- aa....aa:
-
Troubleshooting information 1
- bb....bb:
-
Troubleshooting information 2
- S:
-
Ignores this SQL statement.
- Action:
-
Carefully review the SQL statement, and then re-execute it.
This message is also displayed if processing of the adbreorgsystemdata command timed out. In such a case, take one of the following corrective actions:
-
Increase the timeout period of the adbreorgsystemdata command.
Increase the value specified for the --timeout option, and then re-execute the adbreorgsystemdata command.
-
Stop the SQL statement or command that places the adbreorgsystemdata command in wait status.
Release the adbreorgsystemdata command from the wait status. For details about how to stop the SQL statement or command that caused the wait status, see Reorganization of a system table and lock control in the HADB Setup and Operation Guide. Then, re-execute the adbreorgsystemdata command.
-