7 Troubleshooting
7-33
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
7
The SQL statement could not be stored in the Spool memory because its maximum capacity was exceeded.
Source PLC Function Module Source details Instruction Detection
Effects
User program
Continues. Operation The relevant instruction will end according to
The DB connection failure has
been continuing due to network
failure or other factors.
Recover from the network failure. Control from the user program like
below.
Check the Spool memory usage
using a DB_GetConnectionStatus
instruction, and when the Spool
memory usage has exceeded a
certain value, do not execute the
DB_Insert nor DB_Update
instructions.
Or, check the DB Connection
status using a
DB_GetConnectionStatus
instruction, and when the status
has changed to Connected, resend
the SQL statements stored in the
Spool memory using a
DB_ControlSpool instruction.
The resend processing of the
SQL statements stored in the
Spool memory has not been
executed (when the Resend
spool data parameter is set to
Manual).
Resend the SQL statements
stored in the Spool memory using
a DB_ControlSpool instruction
after establishing the DB
Connection again.
Check the DB Connection status
using a DB_GetConnectionStatus
instruction, and when the status
has changed to Connected, resend
the SQL statements stored in the
Spool memory using a
DB_ControlSpool instruction.
Attached
information
Attached information 1: Error Location
Attached information 2: Error Location Detail, Rung Number. For a program section, the rung number from the
start of the section is given. For ST, the line number is given.
Attached information 3: Instruction Name and Instruction Instance Name Where Error Occurred. If there is
more than one instruction, all of them are given. If the instruction cannot be identified, nothing is given.
Attached information 4: Expansion Error Code (ErrorIDEx)
To Next Page
Loading...
