jsscollectdata (counts Item information)
- Organization of this page
Description
This command summarizes Item information. Note that the command summarizes the Item information from all the process work boards managed by JP1/Service Support regardless of the status of the process work boards. The stored Item information is not summarized.
The values displayed in the main window (Item status) are based on the statistics summarized by using the jsscollectdata command. The data that is output to a file in the Accumulation data output to file window is also based on the statistics summarized by using the jsscollectdata command.
The Item statistics are retained for a different length of time depending on use. The following table describes the retention periods for Item statistics depending on use.
|
Use for Item statistics |
Retention period |
|---|---|
|
Display in the main window (Item status) |
30 days starting from one day before the day when the command is executed |
|
Daily reports |
62 days starting from one day before the day when the command is executed |
|
Monthly reports |
96 months starting from one day before the day when the command is executed |
The command can also be automatically executed from the JP1/Service Support - Task Service service.
Format
jsscollectdata {-s | -a}
Required execution permission
Administrator permissions
Storage folder
JP1/SS-path\bin\
Arguments
-s
Updates Item statistics daily. When you specify this argument, the command compares the new statistics with the existing statistics in the database and adds only the difference within the applicable retention period. In addition, the command deletes the statistics that have exceeded the retention periods.
-a
Specify this option, for example, immediately after version upgrade or data migration, or when you want to summarize all statistics again. After you execute the jsscollectdata command with this option, we recommend that you execute the jssdbreclaim.bat command to release the free space in the database (except for the first time you execute the jsscollectdata command). Do not specify this option for updating Item statistics daily.
Return values
|
Return value |
Meaning |
|---|---|
|
0 |
Normal end |
|
1 |
Abnormal end |
Prerequisites for executing the command
-
For details about which services need to be active or inactive when this command is executed, see Status of services when commands are executed in Chapter 12. Commands.
-
When you execute the jsscollectdata command with the -a option, we recommend that you activate only the JP1/Service Support - DB Server service.
Remarks
-
Executing the jsscollectdata command daily repeats deletion and addition of Item statistics. For this reason, you need to occasionally re-organize the database. Execute the jssdbrorg.bat command (reorganizes the Item management database) once a year.
-
Only one jsscollectdata command can be executed at a time.
-
If you use Ctrl+C to cancel the jsscollectdata command while the command is being executed, Item statistics might fail to be summarized. For this reason, do not cancel the command during execution by using Ctrl+C. If you happen to do so, wait for a while and re-execute the command.
-
While the jsscollectdata command is being executed from the JP1/Service Support - Task Service service, if the JP1/Service Support - Task Service service stops, the command is also forcibly ended. If that occurs, Item statistics might fail to be summarized.
-
If the size of code data to be summarized increases, the capacity of the Item management database might reach the upper limit and the jsscollectdata command might not be successfully executed. If that occurs, output the summarized Item statistics to a CSV file, delete unnecessary Items, and then execute the jsscollectdata command.
-
Execution of the jsscollectdata command might take a long time depending on the number of registered Items, the number of times Items were updated, and the number of Item forms. Execute the jsscollectdata command when the access load is low (for example, at night).