Mitsubishi Electric Melsec Q Series User Manual page 391

10
TROUBLESHOOTING
Symptom
Database values will not be stored in
programmable controller devices.
Job will not start up.
Table 10.21 Troubleshooting about the DB interface function
Checked item
When "Select" and "MultiSelect" are used
for a field whose data type is single type or
double type, is "Microsoft Access Driver
(*.mdb, *accdb)" selected in the ODBC
setting? (for Microsoft
® ®
Microsoft Access 2010, Microsoft
®
Access 2013, and Microsoft
2016)
Is an SQL statement called from the
processing (such as stored procedure)
executed in the database?
Has an error occurred in [Error log] of
[Working log]?
Section 7.12.5 Checking the
working log of the MES interface
module
Did the [Trigger conditions] change from
false to true completely?
Did the [Combination] of [Trigger
conditions] change from false to true
completely?
When [Value monitoring startup] is set for
[Trigger conditions], is the time for the
monitoring target device value change long
enough for the sampling interval of the
device tag?
Section 7.10.2 (6) Value monitoring
startup
Are the device tags used for trigger
conditions of jobs sampled normally?
In [Change job status] of [Remote
operation], is the job set to be disabled?
10.3.3 When operating the MES interface module
• Select "Microsoft Access Driver (*.mdb)"
in the ODBC setting.
® ®
Access 2007,
Section 8.2 (5) For Microsoft
®
Access
® ®
Access
• When using SQL Server and calling an
SQL statement from the processing
(such as stored procedure) executed in
the database, specify "SET NOCOUNT
ON" before calling.
• If an error has occurred, identify the error
cause and take corrective actions.
Section 10.2 Error Code List
• Correct the [Trigger conditions].
Section 7.10.2 Setting items in
Trigger conditions
• Start the job when the [Trigger
conditions] change from false to true.
• Correct the [Trigger conditions].
Section 7.10.2 Setting items in
Trigger conditions
• Start the job when the [Combination] of
[Trigger conditions] change from false to
true.
• Increase the time for the monitoring
target device value change. (Latch it in
the sequence program.)
• Shorten the sampling interval of the
device tag.
Section 7.8.1 Setting items in
Device Tag setting
• If an error has occurred, identify the error
cause and take corrective actions.
Section 10.2 Error Code List
• Enable the job.
Section 7.13.4 Changing the job
status
• To enable the job at startup of the
module, select [Job settings] - [Enable at
module startup].
Section 7.10.1 Setting items in Job
setting
10.3 Troubleshooting by symptom
(From the previous page)
Corrective action
®
(To the next page)
10
- 50
9
10