background image

Function ....................................................................................................................................................7-110
Precautions for Correct Use 
..................................................................................................................... 7-111
Sample Programming 
...............................................................................................................................7-112

DB_ExecuteProcedure (Execute DB Stored Procedure).......................................................... 7-113

Variables ...................................................................................................................................................7-113
Related System-defined Variables
............................................................................................................7-114
Related Error Codes 
.................................................................................................................................7-114
Function 
....................................................................................................................................................7-115
Precautions for Correct Use 
.....................................................................................................................7-116
Sample Programming 
...............................................................................................................................7-116

DB_DetachProcedure (Release DB Stored Procedure Handle)...............................................7-125

Variables ...................................................................................................................................................7-125
Related System-defined Variables
............................................................................................................7-125
Related Error Codes 
.................................................................................................................................7-126
Function ....................................................................................................................................................7-126
Precautions for Correct Use 
.....................................................................................................................7-126
Sample Programming 
...............................................................................................................................7-127

Section 8 

Troubleshooting

8-1  Overview of Errors.................................................................................................................8-2

8-1-1 

How to Check for Errors..............................................................................................................8-2

8-1-2 

Errors Related to the DB Connection Service.............................................................................8-5

8-2  Troubleshooting.....................................................................................................................8-8

8-2-1 

Error Table...................................................................................................................................8-8

8-2-2 

Error Descriptions .....................................................................................................................8-16

Appendix

A-1  Task Design Procedure ........................................................................................................ A-2

A-1-1 

Startup Time of DB Connection Service..................................................................................... A-2

A-1-2 

Reference Values for Execution Time of DB Connection Instructions ....................................... A-4

A-1-3 

How to Measure Execution Time of DB Connection Instructions............................................. A-12

A-1-4 

Guideline for System Service Execution Time Ratio................................................................ A-13

A-1-5 

Checking the System Service Execution Time Ratio ............................................................... A-15

A-2  Execution Time of DB Connection Instructions .............................................................. A-18

A-2-1 

Restrictions to Execution Time of DB Connection Instructions ................................................ A-18

A-2-2 

Impact of Operation Log Recording on Execution Time of DB Connection Instructions .......... A-25

A-2-3 

How to Measure DB Response Time ....................................................................................... A-26

A-2-4 

Ensuring Equipment Performance (Takt Time) by Monitoring Instruction Execution Timeout.. A-26

A-3  Specifications...................................................................................................................... A-28

A-3-1 

General Specifications ............................................................................................................. A-28

A-3-2 

Performance Specifications ..................................................................................................... A-28

A-3-3 

Function Specifications ............................................................................................................ A-28

A-4  Version Information ............................................................................................................ A-29

A-4-1 

Unit Versions and Corresponding DB Connection Service Versions ....................................... A-29

A-4-2 

DB Connection Functions that were Added or Changed for Each Unit Version....................... A-30

A-4-3 

Unit Version, DB Connection Service Version, and Unit Version Set in the Sysmac Stu-
dio Project 
................................................................................................................................ A-30

A-4-4 

DB Connection Service Version and Connection Database Types After Changing Devices ... A-34

A-4-5 

DB Connection Service Versions and Connection Database Types/Versions ......................... A-34

Index

CONTENTS

13

NJ/NX-series Database Connection CPU Units User’s Manual (W527)

Содержание SYSMAC NX series

Страница 1: ...Machine Automation Controller NJ NX series Database Connection CPU Unit CPU Unit User s Manual W527 E1 16 NX701 20 NX102 20 NJ501 20 NJ101 20...

Страница 2: ...this publication Sysmac and SYSMAC are trademarks or registered trademarks of OMRON Corporation in Japan and other countries for OMRON factory automation products Microsoft Windows Excel and Visual B...

Страница 3: ...f designing FA systems Personnel in charge of installing and maintaining FA systems Personnel in charge of managing FA systems and facilities For programming this manual is intended for personnel who...

Страница 4: ...ies CPU Unit Built in EtherCAT Port User s Manual NJ NX series CPU Unit Built in EtherNet IP Port User s Manual NX series CPU Unit FINS Functions User s Manual NJ NX series Database Connection CPU Uni...

Страница 5: ...r s Manual NJ series Robot Integrated CPU Unit User s Manual NJ NX series CPU Unit Troubleshooting Manual Testing operation and debugging Using motion control Using EtherCAT Using EtherNet IP Using FI...

Страница 6: ...e sliders toward the back until they lock into place Level 1 heading Level 2 heading Level 3 heading Level 2 heading A step in a procedure Manual name Special information Level 3 heading Page tab Give...

Страница 7: ...efers to transferring data from Sysmac Studio to the physical Controller and upload refers to transferring data from the physical Controller to Sysmac Studio For Sysmac Studio synchronization is used...

Страница 8: ...Manual Structure 6 NJ NX series Database Connection CPU Units User s Manual W527...

Страница 9: ...ser s Manual W527 1 I 2 3 4 5 6 7 8 A 1 I 6 2 3 4 7 8 A Introduction to the DB Connection Service Index DB Connection settings Basic Operations and Status Check Programming the DB Connection Function...

Страница 10: ...ons 21 Version Types 21 Checking Versions 21 Unit Versions of CPU Units and Sysmac Studio Versions 23 Related Manuals 24 Terminology 26 Revision History 28 Section 1 Introduction to the DB Connection...

Страница 11: ...on Sysmac Studio 3 24 3 5 3 DB Connection Instruction Set 3 24 3 5 4 System defined Variables 3 25 3 5 5 Simulation Debugging of DB Connection Instructions 3 26 3 5 6 Transferring the DB Connection S...

Страница 12: ...Prevent Losing SQL Statements at Power Interruption 5 28 5 6 1 Overview 5 28 5 6 2 Procedures 5 28 5 7 Timeout Monitoring Functions 5 33 5 7 1 Timeout Monitoring Functions 5 33 5 7 2 Login Timeout 5...

Страница 13: ...Connection 7 6 Variables 7 6 Related System defined Variables 7 7 Related Error Codes 7 7 Function 7 7 Precautions for Correct Use 7 8 Sample Programming 7 9 DB_Close Close DB Connection 7 10 Variable...

Страница 14: ...se 7 73 Sample Programming 7 74 DB_ControlSpool Resend Clear Spool Data 7 78 Variables 7 78 Related System defined Variables 7 79 Related Error Codes 7 79 Function 7 79 Precautions for Correct Use 7 7...

Страница 15: ...4 Guideline for System Service Execution Time Ratio A 13 A 1 5 Checking the System Service Execution Time Ratio A 15 A 2 Execution Time of DB Connection Instructions A 18 A 2 1 Restrictions to Executi...

Страница 16: ...plying Product or iii repay or credit Buyer an amount equal to the purchase price of the non complying Product provided that in no event shall Omron be re sponsible for warranty repair indemnity or an...

Страница 17: ...FOR AN APPLICATION INVOLVING SERIOUS RISK TO LIFE OR PROPERTY OR IN LARGE QUANTITIES WITHOUT ENSURING THAT THE SYSTEM AS A WHOLE HAS BEEN DESIGNED TO ADDRESS THE RISKS AND THAT THE OMRON PRODUCT S IS...

Страница 18: ...entative at any time to confirm actual specifications of purchased Product Errors and Omissions Information presented by Omron Companies has been checked and is believed to be accurate how ever no res...

Страница 19: ...Manual Cat No W593 NJ series CPU Unit Hardware User s Manual Cat No W500 NJ series Robot Integrated CPU Unit User s Manual Cat No O037 For safety precautions on NJ501 4320 please contact our sales rep...

Страница 20: ...Manual Cat No W593 NJ series CPU Unit Hardware User s Manual Cat No W500 NJ series Robot Integrated CPU Unit User s Manual Cat No O037 For precautions for safe use on NJ501 4320 please contact our sal...

Отзывы: