Hitachi

Hitachi Advanced Database Messages


KFAA31377-E

The number of recursions in the recursive query exceeds the maximum (aa....aa). (M+J+O)

The number of recursions in the recursive query exceeds the maximum number of recursions aa....aa. <SQLSTATE: 5100L>

aa....aa:

Maximum number of recursions

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Correct the SQL statement according to the following actions:

  • The number of recursions in the recursive query exceeds the maximum number of recursions. Increase the maximum number of recursions.

  • An infinite loop might have occurred in the recursive query. Revise the termination condition of the recursive query, and then eliminate the infinite loop.