42Q Home > 42Q Release Notes

42Q Release Notes Version MES15 Portal 1.0

This Work Instruction is 42Q's corporate standard. This document is under revision control. The latest revision is located on Intranet. Once printed it is an uncontrolled copy. All alterations to this work instruction require approval. Contact the IT Global Education and Training Department to submit suggested alterations and or updates.

This edition applies to MES15 Portal 1.0 and all subsequent releases and modifications until otherwise indicated in new revisions.

Introduction

The following release notes were created to communicate with customers and clients the details of changes or enhancements made to the 42Q portal. The release notes are organized by date, with the most recent appearing first. All medically validated versions are denoted with asterisks and appear in blue font (Ex. ***April 2016***). All versions prior to a medically validated version are included in the medically validated packages.

June 2019

CR# Version: [15.5]

Medical Docker Version:

Disclaimer: This release notes belong to the Medical Validation that will be released in Aug 2019 (without a specific date).

Environment: Medical Production HA Environment

SFDC Core

Task

JIRA# MBWD-76 There are some attr_def records that have a null value in the mask field, seen on p88mdb1/dev1 anyway, which cause the attr download to fail. Need to coalesce to guarantee null is not downloaded.
JIRA# MPDI-270 SFDC DNLD problem in SFDC PC.

Enhancement

JIRA# MBWD-322 Attribute issues, Related to item 1 in MPDI-328: can't find a file attribdnld.sql in svn, but I do find downattrdef.sql.Also I do see in mdsquery.log that proximo calls downattrdef.sql.It would appear that downattrdef.sql is the file needing the change
JIRA# MBWD-321 sfdcdnld4 change to not download Conduit Options to SFDC.

Bug fix

JIRA# MBWD-236 [sfdc core] chk4att performance issue.
JIRA# MBWD-186 If an attribute group is passed as a parameter, getserialattribute returns only the attributes for that group. That has proven to cause sfdc to repeat an attribute number causing overwrite. Modify to send all attributes for a serial all of the time. Tested on mes_e68_08_uat where the issue has been seen.
JIRA# MBWD-28 getcmd can send mfgholds out of order.

Bang Bang Commands

Bug fix

JIRA# MBWD-34 Issue with E38 that avoided it to close or decrease orders in Oracle side when command CHGS03 was used, was fixed.
JIRA# MBWD-131 Issue that caused the Command CHKDFCQTY was not sending the autoend if the serial does not fail, but only if a defect is recorded.
JIRA# MBWD-307 Issue avoiding countNFF not to get initialized to false was fixed.
JIRA# MBWD-135 Legacy code now executes the autoend at the correct time.
JIRA# MBWD-145 chktimedue returning less time than needed due to rounding error was fixed.
JIRA# MBWD-311 chktimedue verified location by the length, now it does it by name.
JIRA# MPDI-310 chktimedue verified location by the length.
JIRA# MBWD-255 When a partial location name is entered a query returns only 1 location even if 2 are found. An error needs to be returned in this case.
JIRA# MBWD-310 Unit history shows a scanning location when using movetohold. This should be the location that the serial table has so that when back2wip2 is used, the correct location will be used.

New features

JIRA# MBWD-18 Command mathcompid was implemented to E43, it does not accept direct charges-

Enhancements

JIRA# MBWD-167 MES [CD] update SFDC to return "ERR ALG MAX SEQ" when algorithm sequence has reached the maximum and correcting RLSE to work as expected with function cre8mac2 on corpmes3 db mes_e80_01.
JIRA# MBWD-293 condition that truncated the container qty to a maximum of 999 was improved due to once the qty exceeded that dumpcntnr4 does not work.
JIRA# MBWD-259 Update chgpn4cnt to check generic attributes for flex field name. If a name is not found continue as before. If a flex field name is found, check that flex field for a part mask to verify new part number.

Task

JIRA# MBWD-191 Changing ilike to optimize and removing part_key from duplicate search.

Rto

Bug fix

JIRA# MBWD-283 Issue that prevented Serial Numbers to modify the Hold status even when part shortages were already released was fixed.

Task

JIRA# MBWD-269 start up mds13c on 172.18.72.203 (this is a xTO test server). And check mds13capp AppServer status.
JIRA# MBWD-279 Fix in rto_unit_info for soon migrated medical instances.

Server folder

Bug fix

JIRA# MBWD-244 Issue that caused Online call/RequestWorkOrderChange bug fix with IF statement was fixed.
JIRA# MBWD-298 Issue that caused wip_moves to be missed when conduit passes units to Comp (e60) was fixed.

Task

JIRA# MBWD-74 Limit wip moves sent to ERP (Oracle) and make it configurable for each db. This is to help keep from overloading the ERP service after a downtime.

Api folder

Task

JIRA# MBWD-265 Add trigram index to part table like e38 db and add e34 db mes_e34_03 to if branch in sql for data import for E34 Nokia.

Label commands

Enhancement

JIRA# WD-604 Remove print queue verification from print_label_engine.sql for [API].
JIRA# WD-84 part_key can now be null on MDS Printinc Core.
JIRA# WD-622 Database backup was restored for mes_e34_02 with all the values, to solve the problem in label type 29. Error: Settings have been lost.

Task

JIRA# WD-556 Perform tests with the new MDS Printing Core, tasks: WD-472/555/84 (labelfmt_v2) for [API].

Algorithms folder

Task

JIRA# MCT-188 Prevent algorithm locking if the algorithm description contains [no-lock]

Portlet folder

JIRA# MBWD-280 Compile all information for the monthly upgrade.

Services

JIRA# MBWD-109 For fail to location not in route, get dept from fail to location and use for rework dept in wip move.
JIRA# MBWD-112 Add operation to web service to receive lot data from ERP.

April 28, 2019

CR# 60168 Version: 15.9

Non-medical Docker Version: 1.3-05-20181026-62

Overview: MES Portal Non-Medical HA: Monthly Upgrade: April, 2019

Environments: MESWeb, API, MesWeb Reports, MDS Web Service Producer, MDS Labels, Patchfiles, Portal Server Information, SFDC-SFDC, SFDC Portlet, APK, PTS Webservice, CMMS, SFDC Config, MDS Patch, Command Register, Conduit, CCRS, Event Broker, Tinmon, Production Workbench.

mes_15_MESWeb-4.3.18

Bug Fixes:

The scheduler application was improved to log schedule executions in mesweb-central database in order to get statistics on the most expensive schedules execution.
A misspelling was corrected when the Shop Order report is exported.
The multiple product selection on Top Defect Evolution report was fixed.
The header names on scheduled exported file were fixed.
The comma on report results information was removed on Text or CSV exported files.

Enhancements:

Unit history report enhanced with Tooling information coming from cmmr schema.
Aging Report.

New Features:

The scheduler service will send only one call per application no matter the number of schedules configured.
Execution application matches schedules with the application being called and limits the number of times that the scheduler application calls the API. Schedules that fail more than 3 times per day are disabled.

mes_15_custom_API-1.4.1

New Features:

[AC-516] - SANM K88 - New API (Custom-API) Function for Container (As noted in DSR-440/DSR-454)
[AC-529] - SAP MSI Product Transfer E85 to K88, API's (As noted in DSR-440/DSR-454)
[AC-548] - E29 Bose Custom-API, create SNs based on algorithm and associated with Shop Order (As noted in DSR-440/DSR-454)

mes_15_MESWeb-reports-1.0.2

New Features:

PC-941 - Upload Arista Transfer reports to Plant E51 (as noted in DSR-486).
AC-301- AC‌-301 [Work-ID: 1009509] SANM E26 Arista Material Transfer Report: Upload Material Transfer report UAT fixes (as noted in DSR-486).
PC‌-878 [Work-ID: 1009814] SANM E51 Arista transfer (MESWeb Rpt Dev).

webServiceProducer.aar md5: 5e92586bb7a9ccc82cacff17334752ff

Enhancements:

Deploy update to Work Order Report operation for 42Q-Oracle Inventory Issues Project:

Jira # MBWD-320: Work Order Exception report changes for Inventory/Aging Project: 42Q Work Order Exception report is an operation in 42Q ERP web service. A requirement in Inventory/Aging Enhancements project is to see the current Oracle locations for the 42Q serials of a work order as compared to the quantities Oracle has at each operation sequence. Report change is to also return a work order's serials and their Oracle location when requested.
Jira # PAR-265: Work Order Exception report changes: deploy webServiceProducer.aar update that has work order exception report changes for 42Q vs Oracle Inventory Issues project.

mes_15_quality-spc-server-1.2.13

Bug Fixes:

JIRA#MPDI-720 Measure value is missing in Cpk/Ppk chart (as noted in DSR-491 and PAR-311)
JIRA#MPDI-524 SR#3957888 - SPC # Manual Collection Via SPC UI (as noted in DSR-491)
JIRA#MPDI-654 SR#4018731 - SPC # SPC replication problem (as noted in DSR-491 and PAR-334)
JIRA#MPDI-829 SPC charts and email alert enhancement for RFID project

mes_15_mds-labels-1.4.1

42Q APR 2019: : PAR-264: Modify logs to make them accessible in HA

Enhancements:

Jira # PAR-261: Fix community ID overflow issue (MBWD-324)
Jira # PAR-264: Modify logs to make accessible in HA (MDWD-345)

42Q-mes_mds_15.1.16_feb2019_patchfiles

A. chktimedue_v.1.6

Bug Fix
MPDI-310
SR3884147
Bug Fix for issue handling process names that are short enough to be confused with workstations.

B. get_shoporder_serial_erp_locations v 1.0 MBWD-320

C. workorderexcreport2 v 1.0 MBWD-320

D. nextgen_online_call v 1.04 MBWD-320 MBWD-342

mes_15_portal_server-information-1.12.47.190322-1

Bug Fixes:

JIRA# MPDI-597 - Bug fixes for db password visibility issue

mes_15_sfdc-sfdc-1.11.18.190308-1

Bug Fixes:

Bug fixes applied to existing medical version: mes15_sfdc-sfdc-1.11.16.180227-1 and medical version: mes15_sfdc-sfdc-1.11.12.170811-1
JIRA#MPDI-664: Unit Start Location configuration ignored when starting SNs in route.
- When a serial number is created by releasing a shop order and it is defined as a USL (Unit Start Location) location, the serial number is allowed to be scanned and start the process in any location defined as "IS START" in the route. This happens no matter than the route has defied a proper start location controlled by USL.
- Solution: SNs created by releasing a shop order, and mapped to a USL (Unit Start Location) can only be scanned from the defined USL location in the Product Route.

mes_15_sfdc-portlet-1.14.32.190315-1

Bug Fixes:

DSR-489: Deploy to uat environment (as reported in PAR-335).
JIRA#MPDI-717: Fix the special characters issue, the special characters probably exists on part number, process name and agile document name (as reported in PAR-335).
JIRA#MPDI-544: AVP fails to allow and edit/update to a chapter (as reported in PAR-335).
JIRA#MPDI-729: Bigint problem:can't list Part Number automatically on By Local Document page of Document Mapping (as reported in PAR-335).
JIRA#MPDI-543: Document Mapping won't work with the Spanish language (as reported in PAR-335).

mes_15_PSI-2.19.apk

Bug Fixes:

JIRA# MPDI-711: APK upload failed on Google Play (as noted in DSR-490).

mes_15_pts-webservice-2.2.9

Bug Fixes:

JIRA#MPDI-493 3946778 - Material quantity of Loading List is incorrect
JIRA#MPDI-496 3946838 - The Barcode Regulation of workstation is uncontrolled
JIRA#MPDI-498 3946821 - Cannot add location mapping
JIRA#MPDI-505 3948792 - Displayed Internal(day) of Feeder is not correct

mes_15_cmms-ws-2.1.2

Bug Fixes:

Current Work Order status synchronizes as expected with the Work Order status displayed in CMMS Dashboard.
Users can create a work order according to an entire production line. Assets do not need to be selected for this configuration; system creates work order as expected.
MPDI-723: Shop Order Control interfaces as expected with MFG Hold so plants can place MFG hold on a production line when incorrect or overused toolings are loaded.
MPDI-709: All filtering criteria now working as expected in PM Calendar: Assigned Group, Asset Type, and Line Number.
MPDI-708: Exported PM plans and Rescheduled PMs now display PM status properly - as text (Planned, Rescheduled, Work Order Generated, Canceled) instead of numbers.
MPDI-707: Current Work Order status synchronizes as expected with the Work Order status displayed in CMMS Dashboard.
MPDI-706: Page count refreshes as expected when users scroll between Work Order List pages using the next button.
MPDI-695: Work Order List main page does not display all work orders after a user searches for a specific work order in the top menu bar. Now working as expected.
MPDI-690: Tooling Mapping: When adding a new mapping, system shows duplicate and incorrect locations in the Location drop-down list.
MPDI-662: Conduit supports Tooling Mapping/Tooling Load-Unload modules to automatically retrieve and send Shop Floor ID data defined in Server Information module.
MPDI-699: Add time limitation (session control) on work sessions in Tooling Mapping, Tooling Load/Unload, and Tooling Manual Update Usage pages, according to session controls applied to 42Q portal.
MPDI-724: Maintenance tab data copies as expected in CMMS Asset > Copy.
MPDI-407: E85 CMMS UAT-Calibration: Calibration Needed checkbox inconsistent.

Enhancements:

CMMS Work Order: Temporary work orders created as a response to false downtimes based on up/down thresholds will not display; if downtime threshold is not exceeded, the work order will automatically be deleted.
CMMS Asset: Change Boc heading to BOC.
CMMS Asset: Change CMMS “search” and “view” GUIs for consistent look across 42Q.
MPDI-402: CMMS Admin > Add Site ID: Error message modified from “Site ID already exists” to “This site already exists. Site IDs cannot be duplicated.”
MPDI-705: Changes made in the My Asset module are reflected in the History Tracking Tab of CMMS Asset > Edit Asset.
MPDI-700: Maintenance updates for tooling type assets are reflected in the History Tracking Tab of CMMS Asset > Edit Asset.
MPDI-695: CMMS Work Order: CMMS now offers 4 types of work orders: Repair, Checklist, PM, and Maintenance (for tooling). Maintenance type work orders do not require a checklist. PM type work orders, which always require a corresponding checklist, are now created from the CMMS Preventive Maintenance module.
MPDI-680: Users can now import Tooling data defined in CMMS Asset > Maintenance Tab through the Import Assets feature in CMMS Admin > Import Assets. The following columns have been added to the template in Import assets: Maintenance Needed, Current Usage, and Last Maintenance Date.
MPDI-386: Make CMMS Project Duplicate Error Message meaningful.
MPDI-404: CMMS - Asset - Add Allows Duplicates and Spaces in ID.
MPDI-701: Enhancement: CMMS Asset > Maintenance Tab:
MPDI-701: CMMS Asset > Maintenance Tab: New fields added to Maintenance Tab: “Inherited from Asset Type” and “Group Assignments”
MPDI-698: New filter criteria added in CMMS Reports > Tooling Where Used: Shop Floor ID, Shop Order, Asset Type, Load/Unload Times.
MPDI-693: Summary change for Work Order list: 3 new columns added to CMMS Work Order to accommodate Work Orders generated from Tooling Control: Expired Date Control Maintenance, Usage Control Maintenance, Periodic Control Maintenance.
MPDI-722: Support export function for Tooling where used report.

New Features:

CMMS Reports: Asset Event History feature is now a separate submodule of CMMS Reporting. Asset Event History logs all plc signals for plants that send asset downtime data through PLCs (programmed logic controls).
OEE-Tag-Mapping: New mapping type 3 allows users to link production floor activity to assets via tag id.
CMMS Asset: Users can right hover over asset description line to view the name of the Created User.

Improvements:

JIRA # DSR-557: Patch upgrade for jig control barriers. Server: https://pts-uat.sanmina.com server.
MPDI-696: Refine jig control message.
MPDI-694:“Expire Date” label changed to “Expired Date” in Tooling Control modules.

mes_15_cmms-portlet-1.0.5 (as dependent upon cmms-ws-2.1.2)

Bug Fixes:

MPDI-699: Session control for Tooling Mapping/Load page/Manual Update Usage Bug Fix: Add time limitation on work sessions in Tooling Mapping, Tooling Load/Unload, and Tooling Manual Update Usage pages, according to session controls applied to 42Q portal.
MPDI-662: Conduit supports Tooling Mapping/Tooling Load-Unload modules to automatically retrieve and send Shop Floor ID data defined in the Server Information module.
DSR-557: Upgrade cmms portlet per dependency on event-broker-0.0.8.

mes_15_sfdc-configuration-2.8.0

New Features:

Jira # MCT-371: MFG Line - Edit Validation
Jira # MCT-372: MFG Line - Add/Edit Validation -Data Collector
Jira # MCT-378: SFDC Config - Route Step: Allow users to assign Status 20 and Status 28 Locations to Fail To Locations.

mes_15_mlc-maintenance-2.14.0

Bug Fixes:

JIRA # MPDI-714: Multi-Level Containerization Browser -> Complete Transaction -> Access Control to send Transaction with "Missing Items."
Jira # MCT-178: Complete Transaction feature disabled if the operator does not have permission to send the report when the extra components were found.

mes_15_emp-validation-class-2.3.10

Bug Fix:

JIRA #MPDI-715: Secure password for Employee Validation Maintenance

mes_15_serialized-item-tracker-2.6.3.190214

Enhancements:

42Q APR 2019: Record Receipt Date for PTS Receive: PAR-259

Record Receipt Date information when receiving a PTS material in SIT
Change Portlet to get current information coming directly from pts db to call the PTS API instead.

mes_15_command-register-1.3.2

Improvements:

JIRA #CONAD-152] - Commands - Some commands are not displaying the description.
JIRA #CONAD-153] - Auto Command - The "Select Command" list is displayed misaligned with the "Select Command" field.
JIRA #CONAD-164] - Command Register - After creating a new Macro, we need to "Refresh" the page to filter, and then the operation inside the macro is not displayed anymore.
JIRA #CONAD-177] - Process Control - When you add just "End" command for any specific process, a continuing error msg is displayed in PW.
JIRA #CONAD-183] - Profile Maintenance > Permissions labels
JIRA #CONAD-193] - Commands - ability to filter by enabled/disabled commands
JIRA #CONAD-196] - Auto Commands should support is_array/is_variadic values for Commands
JIRA #CONAD-52] - Filter Command List by provided Command Name

Bug Fixes:

JIRA #CONAD-169] - Response for Macros and Operations returns success FALSE should handle gracefully.
JIRA #CONAD-171] - Initial Resize of App happens before 2nd resize of portlet
JIRA #CONAD-172] - Scrollbars always on App

mes_15_ccrs-1.2.3

1.2.3

Fixed a character encoding bug for auto command parameter values in the Conduit Administrator, auto-commands endpoint. The API should now correctly save and load json array values for auto command parameter values with embedded double quotes and non array values with commas

1.2.2

Disabling a macro via the API (active = false) will now actually create a relevant operation-context record with disallowed = true for the client_id matching the behavior of disabling a command directly in the command register gui as well
The operations and commands subresources in the conduit-admin resource and client-command-registry resource now support a tags query parameter that takes a comma delimited list of tag values to filter the results against. The tags for each operation will include any tags originating in both mescomm in the command definition and custom tags applied in mes against the operation reference.

1.2.1 and before

Implemented the client-command-registry client_id / shop floor id based endpoints for delivering command definitions.
- automatically only delivers those commands explicitly associated with the client id
- optional parameter to include a process query parameter to further filter available commands by client_id and process name
- includes macro definitions when available and properly assigned
- Note: this endpoint had a previous, unused implementation using mescomm based macro definitions. This has been completely replaced with mes based tables reached via passing the client_id in the url.
Implemented the conduit-admin set of endpoint and associated sub resources:
- conduit-admin/<client_id>/clients
  - List the shop floor id’s defined in the mes instance targeted by the url client_id
- conduit-admin/<client_id>/workstations
  - List locations associated with the url shop floor id
- conduit-admin/<client_id>/products
  - List part numbers in the mes instance targeted by the url client id
- conduit-admin/<client_id>/processes
  - List processes available in the mes instance target by the url client id
- conduit-admin/<client_id>/auto-commands
  - Manage auto command definitions in the target catalog
- conduit-admin/<client_id>/commands
  - Manage command existence/availability in the target catalog
- conduit-admin/<client_id>/macros
  - Manage macros in the target catalog
- conduit-admin/<client_id>/operations
  - Operations are an abstraction over a command or a macro. Typically this endpoint won’t be used as the operation information should be handled when dealing with commands or macros directly.
- conduit-admin/<client_id>/operation-contexts
  - Manage which operations (commands or macros) are available (or not available) at particular context (shop floor id and optional process name.)

mes_15_event-broker-0.0.8

Enhancements:

JIRA # DSR-542: cmms_scanning_activity event consumer now sends old_location in the payload it sends to CMMS for unit-moved events.
Extra field for jig control project even consumer added to v. 0.0.8
Version 0.0.6 consists of significant alterations to the configuration format in mescomm and the addition of the cmms_scanning_activity consumer.

Bug Fixes:

eligible_unit_location - now will remove entries for units that have status 30, 40 or 60 and those events should now be correctly processed after unit movement events for the same serial numbers.
Version 0.0.7 is identical to 0.0.6 feature wise but includes some configuration bug fixes:
- When the mescomm connection drops, the service should now attempt to re-establish that connection.
- A minor race condition for triggered changes should no longer be present.

mes_15_tinmon-1.1.4

Bug Fixes:

Bug fix in Tinmon process: system updates shop orders from ERP-generated work orders as expected.

Tinmon 1.1.4 changes:

JIRA # [MPDI-423] - Tinmon - Work Order Create Proc - Error when updating shop order
JIRA # [TIN-2] - Workordercreate - Problem with update priority data
JIRA # [MBWD-277] 42Q to Oracle Interface Enhancements

Tinmon 1.1.3 changes:

JIRA # [MCT-223] - Update Priority on Shop Order Portlet

Tinmon 1.1.2 changes:

JIRA # [MCT-197] - Display ERP Quantity warning when panel_quantity is rounded up due to uneven panel

mes_15_shop-order-2.14.4

Bug Fixes:

JIRA# MCT-220 Shop Order Scheduling -> Create a new Portlet inside the existing Shop Order Control
JIRA# MCT-323 Shop Order Browser - BOM/Recipe Part Qty
JIRA# MCT-329 Shop Order Browser -> BOM Information -> Save BOM is losing the "Supply Locator" information
JIRA# MCT-369 Sort traveler per unit by step -E61
JIRA# MCT-370 Double parentheses in Traveler Type Label combo filter
JIRA# PAR-287 Shop Order Prioritization and Dashboard
JIRA# MPDI-739 BUG: Missing Activity for Remove Non-Serialized Batches - SO
JIRA# LAM-62: Print Traveler is not working through the Shop Order Release or the Shop Order Browser.

Improvement:

JIRA# MPDI-742 Improvement: Default Print Settings to Shop Order Release

mes_15_production-workbench-1.4.21.190418-1

Bug Fixes:

[PWB-20] - PW - Inputs disabled when changing station ID.
[PWB-28] - PW - Part number being scanned incorrectly.
[PWB-29] - PW - Not showing duplicated scanning template.
[PWB-34] - PW - Notification bar overlaying inputs.
[PWB-39] - PW - Breaking when Conduit message is empty.
[PWB-42] - PW - Recipe quantity issues in PW and Conduit.
[PWB-45] - PW - PS removing properties with null values.
[PWB-47] - PW - Shift+ Tab does not return the cursor to the previous prompt.
[PWB-51] - PW - Not to break when wrong locations are present.
[PWB-55] - PW - User login data gets cached.
[PWB-56] - PW - Unit was moved message does not display at Macros with Add Commend and End operations.
[PWB-57] - PW - Lutron. Production Workbench in Chrome.
[PWB-59] - PW - Client is not translating when a language is selected.
[PWB-71] - PW - Masking failure consistency.
[PWB-72] - PW - Requires serial number to be scanned to retrieve Defect/Repair codes.
[PWB-73] - PW - Commands with no prompt not being displayed.
JIRA # MPDI-260: Repair defect icon not available for a specific defect code. Defect description defined as “_” (underscore) instead of spaces.
JIRA # PWB-61: Change Production Scanning to Production Workbench in screen’s footer.
JIRA # PWB-62: Login modal changes focus when enter key is selected.
JIRA # PWB-64: When removing components from a blocked command, the system deletes the components from the unit.
JIRA # PWB-65: Cache busting for i18n maintains language translations.

Improvements:

[PWB-18] - PW - Select command input to add selected commands when enter is pressed.
[PWB-19] - PW - Notifications aligned to the right.
[PWB-21] - PW - Defect code and repair code displaying description.
[PWB-22] - PW - Command navigation logic change.
[PWB-25] - PW - Hardcoded commands cleanup.
[PWB-30] - PW - Prevent concurrent scans.
[PWB-31] - PW - Set Focus to scanning template when scanning.
[PWB-32] - PW - Change Copy right to 42Q.
[PWB-35] - PW - Capture point in time command not to use serial transaction unit.
[PWB-36] - PW - Parse Client response after submit.
[PWB-38] - PW - PS unable to navigate through PDF when viewer extension not installed.
[PWB-46] - PW - Cleanup settings after changing plant code.
[PWB-48] - PW - Adjust multiple prompt views with no document font to normal.
[PWB-50] - PW - Async Capture point in time.
[PWB-69] - PW - Select inputted command when there is only one result in the list.
[PWB-69] - PW - Worklog improvement.
[PWB-70] - PW - Refresh commands in every scan.
JIRA # PWB-62: Logout icon added.
JIRA # PWB-63:
- Notification style improvement.
- Timespan for notification to display can be defined through a new generic attribute with the following characteristics:
- Generic Attribute:
  - name: ps_notifications_time
  - table: project
JIRA # PWB-67: Station ID only required for Device station type, not process or location.

New Feature:

JIRA #MCT-230: Production scanning updates - SOM.
JIRA #PWB-11: AVP and SOM merge.
JIRA #PWB-23: Auto commands on worklog.
JIRA #PWB-24: Command template.
JIRA #PWB-26: Interactive auto commands support.
JIRA #PWB-27: Ccr replacement by Conduit command registry.
JIRA #PWB-49: Refresh the command drop-down after changing a location or process.
JIRA # PWB-66: New generic attribute allows plants to restrict permissions to supervisors when configurations are updated.
- Generic Attribute:
  - table: project
  - name: ps_configuration_supervisory
  - value: yes/true/no/false

February 9, 2019

CR# 59394 Version: 15.8

Non-medical Docker Version:1.3-05-20181026-62

Overview: MES Portal Non-Medical HA: Monthly Upgrade:

Environments: Shop Order Control, Mes-API, Production Workbench, CMMS, Mes-Connector, Print Queue, patch files, Custom Reports-jar files, Label Engine Web Service, Operation Dashboard, MesWEB Central, Mesweb, Conduit

mes_15_production-scanning-1.2.22.190207-1

Bug Fixes:

MPDI-539 AVP not properly displaying attribute steps
PWB-38 PW - PDF navigation with no extension
PWB-39 PW - Breaking when conduit message is empty

Enhancements:

PWB-32 PW - Change Copyright to 42Q

42Q-mes_mds_15.1.16_feb2019_patchfiles

Bug Fixes:

movetohold_v.2.4
JIRA # MPDI-256, JIRA # MBWD-310: !!2 move activity needs to use current serial location instead of scanning location to work like legacy

Bug Fixes:

downattrdef_v.2.3
JIRA #MPDI-328, JIRA #MBWD-322, SR3892592: change to log if null mask
JIRA # MBWD-328, JIRA # MBWD-322: return “NULL” text if mask field has null to prevent attribute download failure

Bug Fixes:

chktimedue
JIRA # MBWD-145, SR3449176: Rounding up the calculation of remaining minutes that is displayed, so command functions the same as in legacy. Will never display “Due in 0 Minutes’ now. The actual timing is still based on seconds, and is not affected.

Bug Fix:

chkatt
JIRA # MBWD-236: Performance improvement for attribute sample plans.

Bug Fix:

upactser_v.1.31
JIRA # MBWD-328: Do not update serial.pass_fail_seq if the _pass_fail_seq input parameter is zero.

Bug Fixes:

dumpcntnr4_v.1.16
JIRA #MBWD-255, SR3675803: address location selection (MBWD-255)

Bug Fixes:

chgpn4cnt_v.1.1
JIRA # MBWD-259, SWI:1008261, SR3744318: Updated function to check for existence of flex field, if not present continue as normal. If a flex field attribute is found, then a check is done for a part mask in the flex field, which defines the allowable parts that container can be changed to.

Bug Fixes:

cre8ser_v.1.03
JIRA #MBWD-191, SR3568801: removing part_key from duplicate search

Bug Fixes:

cre8ser2
JIRA #MBWD-191, SR3568801: removing part_key from duplicate search

Enhancements:

get_wip_moves1
SR3822533, JIRA #MBWD-298, JIRA# MBWD-298: configurable limit to WIP moves sent to ERP query for max wip_movement_key value changed due to possible open transactions

Enhancements:

nextgen_online_call_v.1.03
JIRA #MBWD-224: Support ERP status changes to Closed, Complete and Complete - No Charges for unreleased 42Q shop order.

Enhancements:

add_shoporder_lotnumber_v.1.2
JIRA #MBWD-323: Bug fix for Lotld attribute number.

Enhancements:

nextgen_online_call_v.1.03
JIRA #MBWD-224: Support ERP status changes to Closed,Complete and Complete - No Charges for unreleased 42Q shop order.

Enhancements:

add_shoporder_lotnumber_v.1.2
JIRA #MBWD-323: Bug fix for LotId attribute number.

mes_15_API-1.6.5.190118

Enhancement:

JIRA #MA-15 MA - Enhance the "MGF Hold" resource on mes-api in order to have a "place" and "release" hold, working with the same logic as the "MFG Hold" module on "SFDC Configuration" portlet.

mes_15_shop order control-2.11.11

Bug Fix:

[MCT-185] Shop Order Release not calculating panel_quantity correctly when deleting unused serials for non batch release
[MCT-320] Shop Order Browser - Delete Skeletons

mes_15_sfdc-config-2.7.4

Enhancement:

[MCT-314] MFG Hold - CMMS Type

Bug Fixes:

MCT-260 MFG Line -> List - Invalid error message
[MCT-206] SFDC Configuration - Part Number portlet
[MCT-365] SFDC Configuration -> Attribute Definition -> Import CSV file with an Especial Double Quote
[MCT-366] SFDC Configuration -> Attribute Definition -> Attribute Step List -> Edit/Filter Step with Especial Character on Attribute Name.
[MCT-367] SFDC Configuration -> Attribute Definition -> Attribute Name List -> Filter not working with Especial Character

mes_15_wocackpost-1.0.1.jar, wipmovepost-1.0.0.jar

Enhancements:

JIRA # MBWD-277: New workordercreateack and wipmove clients for changes to Oracle inbound services.

mes_15_label-engine--web -service-2.2.3.1

Bug Fix:

Label Engine V 2.2.3.1 is a minor release of the LE web service to address Jira LE-221: LE Startup Errors under tomcat 8.5.34, built and documented under Jira LE-222.

mes-15_OperationDashboard_3.3.8.190121

Bug Fixes:

New loading bar was added. After web call and this was successful request, next loading is going to be a bar loading, otherwise a layer loading will be displayed.
Network issue, dashboard is already available to recover itself after internet connection is alive again.
Dynamic parameters
Report calls were wrong because when user uses filter values it always got a null data from service. Now that calls are made well according filters and customer configuration.
Responsiveness behaviour working.
Target values taken from new target configuration screen in MES.

Enhancements:

Some buttons were improved to give better user experience.
Day/Night theme.
Framework changed to Angular.
Bootstrap used for responsiveness.

New Features:

New widget type grid
Remove apply button validation about snapshot name. Now that field is required just when user clicks ‘apply and save’ button
Widget object containing one or more reports
Layout screen for widget organization
Layout screen with 6x6 size
Global and individual filters
Datasource type supporting cmmsr and mesr
Same widget can contain multiple reports/charts
Text chart added for text displaying
Widgets can have displayed title or hidden title

mes_15_Sanm.MSD.Configuration_1.0.13.180926

Bug Fixes:

Delay loading data removed.

Enhancements:

Example images changed for Operation Dashboard 3.2.3 new widgets.
Data sources are now informative, user does not have to select one.

mes_15_mes-web-central-3.2.4

New Features:

Operation Dashboard configuration screen added.
Report columns can be hidden in central with /*hidden*/ tag.
Project OEE added.
New configuration on Report Dashboard screen to add the quantity of rows per widget grid.
Some icons were changed from central screen, and get users from liferay and compare them with central users for get the permissions and roles into the central project
The IsPortalUser column was added into the user screen into the central project
The way of get user profile, was changed from sanmina users to portal users
The Project column was added into the location screen
The Settings Screen was reorganized, the items were reorganized to tabs to accordion layout
New configuration on Report Dashboard screen to add the quantity of rows per widget grid.

Bug Fixes:

Fixes regarding to pagination and users locations.

Enhancements:

Task number 3, Configkey Screen from this file https://docs.google.com/document/d/1f0Tun4jACblO9BK0OBmkACTtzA2_oPpKvkW8BISHBhU/edit was added into the Central Project
Task number 5, Map Location Screen from this file https://docs.google.com/document/d/1f0Tun4jACblO9BK0OBmkACTtzA2_oPpKvkW8BISHBhU/edit was added into the Central Project
Data Source Type Screen, Config Key Screen , Data Dictionary Table Screen y Data Dictionary Field Screen from this file https://docs.google.com/document/d/1f0Tun4jACblO9BK0OBmkACTtzA2_oPpKvkW8BISHBhU/edit were added into the Central Project

mes_15_MESWeb-4.3.4

New Features:

Unit History report was enhanced with Tooling information coming from cmmr schema. This version includes Multiple Hosts change.
A Line Monitor shortcut was added in the top left, next to the username.
A new screen was added where the user can find all locations sorted by regions that the user has access.
The hidden property was added at the col model in order to hide columns that the user does not want to be displaying.
The selected parameters are hidden by default.
Multiple locations in same MESWeb application.
Application select page.
Line Monitor access from MESWeb.

Enhancements:

Each time the user enters at "Customer management" or "Customer part mapping" it will be reloaded in order to keep updated those screens.
When the user uses the share link, the link is copied to the user clipboard and the screen does not reload.
Home page design, now we have a MESWeb application description and access to some wikis.

Bug Fixes:

The same filename in the zip file and the file into file zip when using the date format in files delivered via schedule.
The save favorite was fixed, the problem was caused by the URL it was wrong.
The servlet that uses the schedule was changed to work with "multiplehost".
Shop Order summary issues with source keys on queries.

mes_15_event-broker-0.0.7

Bug Fixes:

Configuration bug fix: When the mescomm connection drops the service should now attempt to re-establish that connection
Configuration bug fix: A minor race condition for triggered changes should no longer be present
Version 0.0.6 consists of significant alterations to the configuration format in mescomm and the addition of the cmms_scanning_activity consumer
eligible_unit_location - now will remove entries for units that have status 30, 40 or 60 and those events should now be correctly processed after unit movement events for the same serial numbers

mes_15_conduit-1.6.9

Enhancements & Bug Fixes:

Fixed transaction scoping bug for large multi-transaction requests
Fixed scanning template issue preventing reconciliation of attribute scan templates
Allow support for required attributes e.g. CONDUIT_OPTIONS ATTRIBUTES_REQUIRED=YES
Added finisher_executed to the ScannedUnit unit_info blob to better inform the client when a finisher happened they may not be aware of (i.e. via auto command.)
Implementation of the Command Template mechanism to allow interactive auto commands
Transition of Scanning Template to Command Template based attribute definition and assembly component reconciliation
Added complete macro support, including the ability to directly invoke macros from clients and coalescing multi-command macros into a single result back to client
Auto commands and scanning template related command templates should only be applied when there is a transaction/scanning unit.
Now allowing macro references in table and SDE based auto commands
Implementation of conditional finishers based on configured statuses for particular commands
Allows the ability to short circuit execution of a transaction when the resultant status matches the configured conditional status
Support both finisher_on_status and halt_exec_on_status
Finisher commands will now require refreshing the unit to validate post scan attribute and assembly definitions
Implemented alternative HTTP/HTTPS server/listener implementation in addition to the still default proxygen libs
Now caching SDE data to no longer require a lookup and parse per request
Allow optional caching of attr_defs (experimental)
Added, then subsequently removed Amazon Kinesis integration
Added limited support for streaming logs entries to optionally configured Kafka brokers
Separated the concept of login from the scanning transaction unit(s). Login will now occur only once per request even when N units are being scanned.
Single transaction override now allows scanning request transaction units in a single round trip for efficiency purposes

mes_15_mes-connector-webservice-2.0.7

Bug Fix:

Not send skip board SN with “_” to PTS and Conduit

mes_15_mes-cmms-ws-2.1.0

New Feature: CMMS Improvement (Project#1006612)

Simplify Work Order flow to be more flexible
Automatically change Work Order status to overdue after escalation email sent out.
When creating Work Order, assign to default assignee of assigned group of Work Order.
Support Work Order list filter.
Email Notification can define recipient.
Simplify Work Order checklist fill-out
Support to import PM
Support to schedule PM across one day with Duration time.
Support Email Notification with Work Order’s URL link.

New Feature: Tooling Control (Project#1007324)

Add Asset Type Maintenance tab to support maintenance by usage & maintenance by expired date & auto maintenance by period
Add Asset Maintenance tab to support maintenance by usage & maintenance by expired date & auto maintenance by period configured at asset level (override configuration done at asset type level)
Support to automatically create WO and send email when tooling needs maintenance.
Support Location MFG HOLD when tooling not loaded or maintenance is expired (period, expiry date or usage).
Add Tooling Mapping to establish relationship between Location, PN and Tooling.
Add Tooling Load/Unload to load/unload tooling for production line.
Add Tooling Where Used to list out PN, Tooling ID and Locations.
Support Tooling Maintenance filter and report by add Columns in Work Order.
Support to manually update tooling usage

Bug Fix and Enhancements:

Default option for Calibration Needed to unchecked
Support to open Work Order and Export at Downtime Problem and Downtime Trend Analysis
Reschedule to valid time with invalid time as grey
Add filter criteria for Calibration
Calibration email job auto send email
Calibration date show local time
PM calendar date show local time
Error Message show detailed information

mesweb-custom-report

New Feature:

JIRA #AC-301 - [Work-ID: 1009509] E26 Arista Material Transfer Report
Custom Environment Script-42Q-20190209-WD941
Work ID 1009761 42Q Script to compare function differences between mds and custom schema

December 15, 2018

CR# 58893 Version: 15.7

Non Medical Docker Version: 1.3-05-20181026-62

Overview: Non-Medical HA Environment: SPC Application, Production Scanning, Label Engine, PCB multi-page traveler & material transfer, Mes Connector/MES-Fuji, MES-API, MDS Interfaces, CMMS Application, Site Maintenance Portlet, SFDC Portlet, MESWeb Application, Print Queues.

mes_15_production-scanning 1.2.19.181211

Bug Fixes:

MPDI-350 - Production Scanning - Single Command View is not working
PWB-9 - PW - Single prompt configurable
PWB-17 - Wrong progress bar for first command entry
PWB-2 - AVP Implementation
JIRA #MPDI-236 - PS now allows to end if the assembly items are not added.
JIRA # MCSFC-188 - Duplicate SN Issue [Reset button].
JIRA # MCSFC-180 - Remove plant code upper case in production scanning which caused document displaying issue.
JIRA # MPDI-259 - Repair code and description to be displayed while repairing a defect in Production Scanning.
JIRA # MPDI-268 - AVP config tossed when scanning by location.
JIRA #MPDI-312 - Different types of document layouts not working.

mes15_kv-production-2.10.4.2.1

Bug Fix:

JIRA # MCT-310 - Branch UAT KV Production 2.10.4.2 to add Server Info Updates.

mes15_quality_spc-portlet-1.2.13.181129-1

Enhancement:

JIRA#MS-89 improve add/edit monitor page

mes15_quality_spc-server-1.2.12.181129-1

Bug Fixes:

JIRA#MPDI-347 E68 SPC MR-chart calculating error
JIRA#MPDI-352 Duplicate SN recorded in S05_01 monitor
JIRA#MS-88 P chart data missed in the monitor by time

42Q-mes_mds_15.1.16_dec2018_patchfiles

Bug Fix:

sfdcdnld4 v1.09: updated to not return setup data items for Conduit to sfdc. Also updated to remove check of information schema so function always calculates device_code from device_number.
- MPDI-270
- MBWD-321

Bug Fix:

getserl2 v1.4: compensate for SFDC bug where serial.defect_seq is not always updated, resulting in duplicate serdef.defect_seq values. CR #58601
- MPDI-196
- MPDI-394
- SR3904866

Bug Fix:

getserialattribute v1.01: Always return all attribute defs, so sfdc does not duplicate attribute numbers when only partial attribute defs are downloaded.
- MBWD-186
- SR3554763

mes_15_mes-api 1.5.10

[MA-1] Retrieve flex fields for location, process, defects and part
[MA-2] Filter out activities based configurable list of part number for Units endpoints
[BEE-629] Appendix API - Enhancement
[NO JIRA] Altered basic serial lookup to use serial_info view instead of just serial
[BEE-980] Measurement-adapter version upgrade to 0.2.4
[BEE-1027] API's Enhancement -> Settings Out of Properties
[BEE-1200] mds-adapter version upgrade to 0.2.13
[MA-7] Appendix Resource paths rollback
[MA-9] MES API not using domain settings data
[BEE-1296] Cell Inspection redesign
[MA-12] Create endpoints to invoke AWS Lambda Functions
[BEE-1354] Appendix Resource - not getting data
[BEE-1342] APIs Attributes - Beehive
[BEE-1398] Bumblebee - Ink Miking
[BEE-1331] Cell Kanban - Redesign
[BEE-1360] API Attributes - Add messages for invalid information
[MA-13] Update the parts resource to retrieve the algorithm number info
[MA-16] TAF Endpoints - Move Endpoints from nokia-custom-api to mes-api
[MA-17] Unit - Comments - Error when the unit doesn't have comments
[MA-22] Measurement end-point is not sending shop floor id

mes_15_sfdc-config-2.7.1.181204

Bug Fixes:

[MPDI-413] Issue with sfdc route creation/updates: users unable to select an empty Fail location when adding/editing a route step in a database when there is no location in Repair status created for a shop floor id.
[MCT-221] SR# 3872657 - Route issue - Source Locations 2, 3 and 4 being wrong required when inserting subroute.

Enhancement:

[MCT-222] MFG Line Updates - SOM: Add Location Tab in Mfg Line module.

mes_15_cmms-2.0.0

Database script upgraded to v1.0.6. This upgrade involved a database upgrade and siren setting changes. No CMMS web service or portlet changes were involved.

Bug Fixes and Enhancements:

Update calc_oee function to set machinename with asset_id value.
Update calc_oee_by_machine function to set machinename with asset_id value.
Update lineoeeresult machinename value with asset_id by machine_id.
Change machine_type length from 64 to 128 characters in “MachineType”.
Change asset_name length from 32 to 128 characters in “Asset” table.
JIRA #MPDI-330: Update timezone from US/Pacific to UTC in settings.py for siren.

mes_15_label engine-2.2.3

This is a minor release, tracked under Jira LE-213, which includes the following items, each tracked under their own linked Jira items:

Bugs Fixes:

[LE-016] - LE temporary files for label fonts not getting deleted
[LE-035],[LE-161] - This bug prevents the registration (save) of a non mds schema postgresql db within LE
[LE-043] - Fix the code paths that allow forbidden characters in label names.
[LE-059] - Correct spelling mistake
[LE-099] - Provide a meaningful message to user, and ensure print attempt is recorded as a failure, when user attempts to print a label without any templates.
[ LE-202 ] - GroupId integer overflow fix.. This was initially thought to be fixed in v2.2.2, however, until the new mds-commons was used, the full scope of this issue was not understood. The remaining items for the groupid integer overflow were thus fixed under v2.2.3
[LE-203] - change token generation algorithm such that it won't allow chars that are not URI friendly

Enhancements:

[LE-106] - Add code to retry RTF to PDF conversion if the first soffice attempt fails.
[LE-049] - Identify the "start" point of all label prints in the LE logs (for support).
[LE-050] - Include Audit Print Key in the exported print history results.
[LE-053] - Auto refresh the label list after deleting a label so that actions related to "has development version" are aware of the delete.
[LE-054] - Preserve use defined filters within users session (or until cleared).
[LE-136] - Remove the very short input limit for the Add Part on the Part Number.
Mapping screen (for published labels) so that long lists of parts can be added.
[LE-214] [LE-165] - Improve the print history reporting screen by altering the order of and appropriately sizing the columns.

New Features:

None: Each of the linked Jira items contains the full details for each item. The parent (version) Jira contains all of the full version information including build notes, testing details, test reports, etc.

mes_15_site-maintenance-1.12.41a

Bug Fix:

JIRA # DSR-113: Unable to save changes in Name features/Edit mode in the site maintenance portlet.

mes15_sfdc-portlet-1.14.28.181107-1

Bug Fix:

JIRA #MCSFC-202 SFDC Portlet - Start page does not display correctly in Data Collector when the file is mapped directly from Agile, or mapped to deviation number. Page 1 always shows as default page, even when other pages were mapped to the file. Start page now working as expected.

mes_15_mes-connector/mes-fuji web service v2.0.6

Bug Fix:

JIRA #MPDI-368: E81 mes-fuji configuration->pts configuration page was blank. Fixed.

mes_15_mesweb-application v.1.4.6

Bug Fixes:

[PC-896] - Plant E04# Mesweb# Export to Excel takes too much time.
SR# 3907639 “as built report” take more than 19 mins. to export the report to excel.

New Features:

[AC-301] - Plant E26 Arista Material Transfer Report
PCB Multi Page Traveler (Show/hide attributes).

Enhancements:

[PC-779] - PCB Plants PCB New Requirement - move attributes out of process to first process.
PCB Unit history & Traveler History (replace the Oracle_route_ Id for the Streamsrv_route_seq).

CR# 58894 Version: 15.7

Overview: Non-Medical HA Environments: MESWeb Central DB, corpmesr4

mesweb_central to RDS

Architectural Change:

JIRA # DSR-244: The application won’t have any change on its functionality and no new feature is being added; this movement will only convert the current postgres mesweb_central db based on a cloud server to an Amazon Relational Database Service (RSD). It will be moved from MESR server to a new dedicated server.

November 15, 2018

CR#58636 Version: 15.6.6

Non Medical Docker Version: 1.3-05-20181026-62

Overview: Non-Medical HA

Environment: Operation Dashboard, MESWeb Central

mes_15_operation-dashboard-3.2.5.181113

Bug Fixes:

Dashboard Custome Filter Change. Report calls were wrong - users received a null data from service when filter values were applied. Calls can now be completed as expected according to filters and customer configuration.

Enhancements:

Dashboard Conguration screen Apply button improved. Remove apply button validation about snapshot name. Field is now required. User only needs to click "Apply and Save" button.

mes_15_Sanm.MSD.Configuration-1.0.13.180926

Bug Fix:

Delay loading data removed.
Example images changed for new widgets in Operation Dashboard 3.2.3
Data sources are now informative; user does not have to select one.

mes_15_Sanm.MESWeb. Central. View-2.2.1.181113

Enhancements:

Report columns can be hidden in central with /*hidden*/ tag.
Project OEE added.

November 10, 2018

CR#58529 Version: 15.5.6

Non Medical Docker Version: 1.3-05-20181026-62

Overview: Non-Medical HA Monthly Upgrade: CMMS, OEE, Employee Validation, Kit Verify Configuration, Serialized item Tracker, SFDC Config, MES Portal, MES Connector portlet, MES Connector, PTS, MDS Interfaces, SPC Application portlets, SPC Server, MES API, Operation Dashboard, SFDC webservice, PSI-APK.

mes_15_cmms-1.0.4

Bug Fixes:

CMMS Work Order Labor Time: Time zone in Labor tab will automatically reflect local time. Only users assigned to the Work Order can add and edit labor times.
CMMS Asset: Users can now add multiple emails in the Additional Emails field.
CMMS PM Calendar: Bug fix to remove error "Failure to load resource Status 404" when calendar is opened at PM Calendar.
CMMS Asset: Users can now add more than 25 companies to select from the Manufacture drop-down in CMMS Asset. Changes made in PM calendar are automatically reflected in the corresponding Work Order.
CMMS Admin: Users can add more than one user at a time to a Group in the Group module.
CMMS Calibration Tab in CMMS Asset: Now working as expected when in Edit Asset mode.
CMMS Calibration Import Asset: Calibration Status: In Use column of the template now imports fields accurately to Calibration. CMMS Calibration template fields are not consistent with .csv template after importing.
CMMS Asset Location: Location field now translates accurately in Hebrew language. Locations in Production Line also working for Hebrew translation.
PM Calendar: Sorting and filter option now supported at PM Reschedule.
CMMS Dashboard: Work Order Summary now displays in View Work Order feature of Asset Status submodule.
PM Reschedule: Supports multiple filters.

mes_cmms-webservice-2.0.0.181016

Enhancements:

Integrate CMMS with OEE.
Get Reason Code from Kepware/PLC automatically.
Get Shop Order and Cycle Time for third party system.
Get UPH and OEE target values by multiple source types.
Sync data from 4 different source types.
Map Asset Error Codes in OEE Tag Mapping to Problems in CMMS Asset.
Connect OEE to MESWeb Reports for OEE Reporting.
Add Repair Code in OEE for CMMS Work Orders by Repair.
Configure Target UPH by Department, Asset, Line, Work Center, and Location.
Integration with 42Q MES101

mes_15_empval-emp-class 2.3.7.180927

Bug Fixes:

JIRA #MCT-203 - Performance Improvement - Import Employee function.
SR# 3848362

mes_15_kv-view-configuration 2.4.4.180928

Bug Fixes:

JIRA #MCT-64 - Commons Portlet Issue.
JIRA #MCT-100 - Update KV Configuration Bundles.
JIRA #MCT-162 - Update and Test - Mes Portlet Commons due to Server Info API Update.

mes_15_serialized-item-tracker 2.5.8.180927

Bug Fixes:

SR #3827306
JIRA #MCT-200 - SIT was creating a blank serial record when manually entered.

mes_15_sfdc-config 2.6.15.180911

Bug Fixes:

JIRA #MCT-202 - Missing "Unit Started Location" when exported .csv file from Part Number portlet.
SR# 3815042

mes_15_portal_1.3-05-20181026-62

Bug Fixes:

Timeout issues. Session expires when more than one tab is open. The Javascript files from Liferay (version 6.0.5) were changed to create a listen integrated with the "Extend" button. Broadcast Channel added to trigger the extend event for all tabs.
JIRA #DSR-55

mes_15_mes-connector-2.0.5

Enhancements:

Upgrade to tomcat 8.5.
Support double lane.
Modified logs' timezone for each plant.
Modified Scan Logic.
Support load component by batch.
Support scan board to PTS by batch.

Bug Fixes:

Fix bug of MSD check with pts.
Fix bug of searching log by content.
PTS line error message support multi page.
Fix bug of DB not found for big integer type user ID.

mes_15_pts-web-service-2.2.6

Enhancements:

Implement scanning board by workstation name web service interface.
Supply function 'Location Mapping Report'.
Printer control through GUI.
Implement and improve 'Traceability for Programmed IC' function and 'Indirect Material' function.
Add a System Setting switch to process 'msd control or not for materials on board'.
Implement loading material aml validation about 'OBS-MPN' logic (including fuji verification).
Improve function 'Material Labelling' item Pb-Free Category display logic.
Improve function 'Material Labeling' and 'Reprint Material Label' item 'Country of Origin' display by System Setting configuration options.
Improve current TimeZone City related process.
Improve low performance sql 'query feeder in use' and related dao function.
Improve E85 Board Rework performance for sql server PTSR.
Correct function 'Add Deviation Note' item 'Due Date' display as Timezone process reason.
Solve the bug for RT can not be updated in OWMS-PTS interface.
Solve the bug for MSD_Level = 6 in OWMS-PTS interface.
Bug fix for parsing 'DB Url toLowerCase()' about System Setting configuration item 'Fuji Profiler Connection String'.
Fix owms error log and pts webservice log path issue.
Add Printer setup function.
Fix multi plant code issue.
Fix OWMS-PTS web service expired date issue.
Fix OWMS-PTS web service for MSD level 6 issue.
SFDC Repair/rework integration with Fujitrax improvement.
Change PTSR query view 'v_fuji_scan' to 'v_fuji_scan_detail' for 'Board Rework' function.
Resolve the bug 'Error occurred as configuration items include special character '&' when saving System Setting function Fujitrax Control category'.
Resolve the bug "print item part number char '+' will be changed to blank space" when Material Labeling related function print label.
Fix SR#3665048 too many open files issue.
Fix updated date error in print sub label.
Fix SR#3665048 unique index constraint exception.
Fix for too many PrintServiceLookup invoke.
Add new file format process for current OWMS-PTS interface.
Improve current fuji loading material validation performance.
Improve current fuji scanning board performance.
Improve OWMS-PTS interface to make it have better performance and efficienc.y
Fix current fuji loading material msd validation bug.
Improve current getServerPrinters function to only get printers from DB configuration for better performance.
Resolve json data format issue for PPC feederVerify function.
Resolve json data format issue for PPC loadSMTTool function.

mes15_quality_spc-portlet-1.2.12.180917-1

Enhancement:

JIRA#MS-83 change email title according user

mes15_quality_spc-server-1.2.11.180917-1

Bug Fixes:

SR#3827193 SPC is duplicating the serials (report by e38_02)
SR#3832491 Received a SPC alert email but can not find the alert in SPC(In CPK/PPK Chart)

Custom API 1.2.0

New Features:

The new custom-api function requested by E81 plant is to calculate 1st pass/fail qty on a process.
JIRA # AC-275: K03 Reynosa, Custom-API: get_part_info
JIRA #AC-100: Plant E81: 1st Pass/Fail Calculation

mes_15_operation-dashboard-3.2.4.180926

New Features:

Widget object containing one or more reports.
Layout screen for widget organization.
Layout screen with 6x6 size.
Global and individual filters.
Day/Night theme.
Added OEE widgets.
Datasource type supporting cmmsr and mesr.
Same widget can contain multiple reports/charts.
Text chart added for text displaying.
Widgets can have displayed title or hidden title.

Bug Fixes:

Responsiveness behaviour working.
Target values taken from new target configuration screen in MES.

Enhancements:

Framework changed to Angular.
Bootstrap used for responsiveness.

mes15_Sanm.MSD.Configuration_1.0.13.180926

Bug Fixes:

Delay loading data removed.

Enhancements:

Example images changed for Operation Dashboard 3.2.3 new widgets.
Data sources are now informative, user does not have to select one.

mes_15_Sanm.MESWeb.Central.View-2.2.0.180926

Enhancements:

Operation Dashboard configuration screen added.
Report columns can be hidden in central with /*hidden*/ tag.
Project OEE added.

42Q-mes_mds_15.1.16_oct2018_patchfiles

Bug Fixes:

SR #3529146

CR #54909

SFDC Custom Command update: chkdfcqty:
JIRA #MBWD-131
JIRA#MBWD-307
Changed endUnit option to default to true as in legacy.
Changed countNFF option to default to false as in legacy.

CR #54909

SFDC Custom Command update: moveifattdata
JIRA #MBWD-135
End command if do not find attribute matching input parameter, as in legacy.

SR# 3562696

CR #55189

SFDC Custom Command update: cre8mac2
JIRA # MBWD-70
JIRA #MBWD-71
JIRA# MBWD-78
Send RLSE as in legacy.
Display MAX SEQ when maximum sequence has been reached.

mes_15_mes-API-1.2.2.3

Enhancement:

JIRA #MA-14: Add a generic attribute endpoint to expose generic attribute information via mes-api.
Supports OEE Enhancement.

Replication 1.1.2 to support CMMSR

New Feature:

Replication source allowing for a single source database to have multiple replication "scenarios"
Cursory support for backward compatibility with existing schemas, allowing us to continue to replicate older schemas without absolutely requiring patching source and destination instances.
No longer setting dataset.rep_source_key as it isn't necessary for replication to function, which removes the need for a dataset table in the source databases at all.

mes_15_sfdc-webservice-1.12.12.17129-1

Bug Fixes:

JIRA#MCSFC-132 To support the sub exit and sub entry type display and creation.
JIRA#MCSFC-175 SFDC API does not support HA url for APK which reported from P30.

mes_15_PSI-2.17.apk

Enhancement:

SWI#1007676: New Android PDF Library (To adopt pdfium PDF Library to replace VuDroid to fix the PDF display issue).
SR#3792069/JIRA#MPDI-224: PSI app crashed/stopped issue reported by E85.

November 1, 2018

CR# 58464 Version: [15.5.5]

Non Medical Docker Version:

Overview: Non-Medical HA

Environment: multi-level container portlet

mes_15_mlc-maintenance-2.13.12.181101

Bug Fix:

JIRA #MCT-239 Plant E26_01 container printer failed to load randomly under HA production environment.
SR#3859617, P2, Emergency upgrade

October 2018

CR# 58127 Version: [15.4.5]

Medical Docker Version: 1.0.20180831-1

Overview: This fixes the agile update failure issue and direct from agile.

Environment: Medical Production HA Environment, corpmes2, corpmesr2, corpprtl2/cmmes.sanmina.com, corpmespts2, medical pts Linux server, corpmesspc2, NEW conduit server

MES Portal Server

Bug Fixes:

mes15_sfdc-portlet-1.14.16c.180813-1
● JIRA#MCSFC-184 To fix the work instruction display issue when direct from agile is yes.
● JIRA#MCSFC-163 To fix the agile document does not update into alfresco issue.

mes15_measurement-3.1.3.3

Bug Fixes:

JIRA # MEASPRD-661 MTL parser: System is out of memory (SR 3862493)
JIRA # MEASPRD-665 Measurement does not have a sign out option available when it is running embedded into the portal (SR 3841132)
JIRA # MEASPRD-671 Measurement standard Takaya parser is sending wrong data to the data to autolog wrapper to complete the shop floor communication. Defect mapping misplaced.
Parser upgraded to next version.

Alfresco/DB Server

mes15_sfdc-agile-service-1.1.1a.180813-1
● JIRA#MCSFC-163 To fix the agile document does not update into alfresco issue.

September 2018

CR# 57831 Version [15.4.4]

Non Medical Docker Version: 1.0.20180905-6

Overview: Non-Medical HA Monthly Upgrade

Print Queue, Algorithm Tool, Audit Report, Configuration Publish, Employee Validation Maintenance, Employee Validation Configuration, Generic Attribute, Labor Tracking, Multilevel Container Configuration, Multi Level Container Maintenance, Serialized Item Tracker, Siren Configuration, Siren Operation, Shop Order, SQC Configuration, Target Maintenance, CMMS portlet, CMMS Web Service, SPC Portlet, Production Scanning, Label Engine.

mes_15_sfdc-config-2.6.13.180727

SR# 3626224

Bug Fixes:

JIRA #MCT-64 - Code updated on mes-portlets-commons_2.4.3
JIRA #MCT-143 - SFDC Configuration Assembly error message now reads correctly.
JIRA #MCT-144- Part Number - Import is not working.
JIRA #MCT-162 - Update and Test - Mes Portlet Commons due to Server Info API Update.
JIRA #MCT-186 - SFDC Configuration -> Part Import Bug: allow part numbers with double quotes to be imported.
JIRA #MCT-189 - Part Number - Not saving flex field values.
JIRA #MCT-191 - Support case insensitive filter on Part Number modules.

Enhancements:

JIRA #MCT-106 - Update SFDC Config translation bundles: Mandarin, Portuguese, Spanish.
JIRA #MCT-119 - Part Maintenance - Improve Algorithm Form usability.
JIRA #MCT-187 - Route Performance Improvement (SR #3626224).
JIRA #MCT-190 - Assembly Maintenance - Increase Char Limit at Component Reference Designator.

mes_15_algorithm-tool_2.2.7.180816/

Bug Fixes:

JIRA #MCT-64 - Commons Portlet Issues to solve integer overflow problem.
JIRA #MCT-162 - Update and Test - Mes Portlet Commons due to Server Info API Update.

Enhancements:

JIRA #MCT-93 - Update Algorithm Tool Bundles.
JIRA #MCT-192 - Algorithm Portlet - Increase Char Limit to 255 at Element Description.

mes_15_audit-report _2.2.10.180816/

SR# 3609320

Bug Fixes:

JIRA #MCT-64 - Commons Portlet Issues to solve integer overflow problem.
JIRA #MCT-162 - Update and Test - Mes Portlet Commons due to Server Info API Update.
JIRA #MCT-164 - Date/Time in result list is not considering the Plant's timezone.

Enhancements:

JIRA #MCT-94 - Update Audit Bundles.

mes_15_configuration-publish_2.1.5.180816/

Bug Fixes:

JIRA #MCT-64 - Commons Portlet Issues to solve integer overflow problem.
JIRA #MCT-162 - Update and Test - Mes Portlet Commons due to Server Info API Update.

Enhancements:

JIRA #MCT-95 - Update Configuration Publish Bundles.

mes_15_employee-validation-maintenance_empval-emp-class-2.3.6.180816/

Bug Fixes:

JIRA #MCT-64 - Commons Portlet Issues to solve integer overflow problem.
JIRA #MCT-162 - Update and Test - Mes Portlet Commons due to Server Info API Update.
JIRA #MCT-193 - Cannot find some groups in EV Classes.

Enhancements:

JIRA #MCT-96 - Update Employee Validation Maintenance Bundles.

mes_15_employee-validation-configuration_empval-proc-control-2.2.5.180816/

Bug Fixes:

JIRA #MCT-64 - Commons Portlet Issues to solve integer overflow problem.
JIRA #MCT-162 - Update and Test - Mes Portlet Commons due to Server Info API Update.

Enhancements:

JIRA #MCT-97 - Update Employee Validation Configuration Bundles.

mes_15_generic-attribute_gen-attribute-maint-2.2.5.180816/

Bug Fixes:

JIRA #MCT-64 - Commons Portlet Issues to solve integer overflow problem.
JIRA #MCT-162 - Update and Test - Mes Portlet Commons due to Server Info API Update.

Enhancements:

[MCT-98] - Update Generic Attribute Maintenance Bundles.

mes_15_labor-tracking _2.4.5.180816/

Bug Fixes:

[MCT-64] - Commons Portlet Issues to solve integer overflow problem.
[MCT-162] - Update and Test - Mes Portlet Commons due to Server Info API Update.

Enhancements:

JIRA #MCT-102 - Update Labor Tracking Bundles.

mes_15_multi-level-container-configuration_2.2.5.180816/

Bug Fixes:

JIRA #MCT-64 - Commons Portlet Issues to solve integer overflow problem.
JIRA #MCT-162 - Update and Test - Mes Portlet Commons due to Server Info API Update.

Enhancements:

JIRA #MCT-104 - Update Multi-Level Container Config Bundles.

mes_15_multi-level-container-maintenance_2.13.11.180816/

Bug Fixes:

JIRA #MCT-64 - Commons Portlet Issues.
JIRA #MCT-149 - The Bundles for Lock Error message is missing for MLC Maintenance and Kit Verify.
JIRA #MCT-153 - QCCheck Point issue with Quantity Zero.
JIRA #MCT-154 - QCCheck Point -> Set ATO Code as default when none was found.
JIRA #MCT-162 - Update and Test - Mes Portlet Commons due to Server Info API Update.

Enhancements:

JIRA #MCT-103 - Update Multi-Level Container Browser/Pack Bundles.
JIRA #MCT-157 - QCCheck Point -> Enhancement -> Request Sales Order take long time.

mes_15_serialized-item-tracker_2.5.7.180816/

SR#3777024

Bug Fixes:

JIRA #MCT-64 - Commons Portlet Issues.
JIRA #MCT-162 - Update and test Mes Portlet Commons to ensure environments impacted by the Server Info API Update are working as expected.
JIRA #MCT-196 - Update Receive - Updating all Sit Ranges.
JIRA #MCT-195 - Profile SIT is not working.

Enhancements:

JIRA #MCT-109 - Update Translated SIT bundles in Mandarin, Spanish, and Portuguese).

mes_15_siren-view-configuration_2.2.14.180816/

Bug Fixes:

JIRA #MCT-64 - Commons Portlet Issues.
JIRA #MCT-162 - Update and Test - Mes Portlet Commons due to Server Info API Update.

Enhancements:

JIRA #MCT-107 - Update Siren Config Bundles.

mes_15_siren-view-operation_2.2.7.180816/

Bug Fixes:

JIRA #MCT-64 - Commons Portlet Issues.
JIRA #MCT-162 - Update and Test - Mes Portlet Commons due to Server Info API Update.

Enhancements:

JIRA #MCT-108 - Update Siren Operation Bundles.

mes_15_shop-order_2.11.11.180816/

SR#3732307

Bug Fixes:

JIRA #MCT-64]- Commons Portlet Issues.

Enhancements:

JIRA #MCT-110 - Update Shop Order Bundles.
JIRA #MCT-188 - Prevent Concurrent Algorithm Execution During Shop Order Operations.
JIRA #MCT-197 - Display ERP Quantity warning when panel_quantity is rounded up due to uneven panel.

mes_15_sqc-configuration_2.3.5.180816/

Bug Fixes:

JIRA #MCT-64 - Commons Portlet Issues.
JIRA #MCT-162 - Update and Test - Mes Portlet Commons due to Server Info API Update.

Enhancements:

JIRA #MCT-111 - Update SQC Bundles.

mes_15_target-maintenance_2.4.6.180816/

Bug Fixes:

JIRA #MCT-64 - Commons Portlet Issues.

Enhancements:

JIRA #MCT-112 - Update Target Maintenance Bundles.

mes15_production-scanning:ps-1.2.11.180907-1

Bug Fix:

JIRA # MCSFC-188 Duplicate SN Issue.
JIRA # MCSFC-184 To fix the work instruction display issue when direct from agile is yes.
JIRA # MPDI-236 PS allows to end if the assembly items are not added.

mes15_label-engine-2.2.2

SR#3821594

SR#3785708

Bug Fixes:

Label Engine V 2.2.2 is a minor release, tracked under Jira #LE-138, which includes the following items, each tracked under their own linked Jira items:

JIRA# LE-150 - LE Leak Connection (Idle Connections) & JIRA# LE-174 - Database connections not closing properly.
- JIRA #LE-179 - Create script to monitor database connections.
- JIRA #LE-177 - Perform tests to guarantee database connections are being closed properly.
JIRA #LE-202 - GroupId integer overflow fix.
JIRA #LE-124 - Effective Logging - Improvements & JIRA# LE-178 - [HA]: Unable to find Label Engine log entries in Kibana.
JIRA #LE-205 - LE ensure all temporary files are created within /tmp folder.

mes_15_MESWeb-4.4.24

CR# 57990

Bug Fix:

SR# 3824349: The application name label was modified to be applied on PostgreSQL dbs only (This caused reports reading non PostgreSQL dbs to stop running).

mes15_cmms-ws-1.0.3.180827-1 (with dependency on: mes15_cmms-portlet-1.0.2.180320-1)

Refer to: V. 1.0.3

OEE Dashboard

A, P and Q boxes are misaligned: Centralize them. Make them darker so it's easier to read from distance.
Add a SORT ASC/DESC (by OEE/TEEP) at the dashboard.
Add autocomplete and drop-down for the line and machine.

OEE Report

Allow users to Sort by columns: must be available for GRID-based reports.

Expected Cycle Time

Allow the user to key in the expected cycle time locally through the GUI.

CMMS Dashboard

JIRA# MPDI-209. Can view WO by clicking link on Summary.
Support CMMS-Portlet V1.0.1.

mes_15_cmms-portlet-1.0.2.180320-1 (refer to cmms-portlet change log)

Support multi-language.
Define user permission to show accessible modules.

mes_15_cmms-ws-1.0.2.180320-1 (refer to v1.02)

Work Request

WR Category

Support Customization Form
Each Category can link to a Customization Form
Select Trigger:
- Select WR Status or one of Fields from the available fields as a Trigger, and assign the trigger value to the desired program.
- Specify external trigger program to execute auto update and link to CMMS Master Data function.

My Requested

Add new Request:
- When WR Category is selected, the Customization form fields will display in the specified TAB.
- Edit one Request:
  - WR Category cannot be modified; changes to WR Category will affect associated Customization Form.
  - Query Fields: Add Created Date field to Date Range.
- Query Result List:
  - Add Created Date.
  - Add a button to automatically display the approvers in the current user’s approval path.
  - WR Reference info can be shown when user clicks Reference Link.
- My Approval/My Assigned:
  - Query Fields: Add Created Date Date Range.
  - Query Result List: Add Created Date.
- When clicking detailed WR, display the Customization form linked to it in specific TAB.
- Email: Show Customization form fields with values in the body of related emails.
- Query Fields: Add Created Date Date Range.
  - Query Result List: Add Created Date.
- WR Reports:
  - Query Parameters:
    - WR Category (Mandatory), WR Status, Created Date Range
  - Description:
    - Query WR to satisfy specific conditions listed in query parameters.
  - Function:
    - View, Export.
    - In query result list, click link to show detailed WR for one result.
  - Query Result fields:
    - Display WR in all fields.
    - If Customization form is linked to it, display all fields in linked Customization form.
Administration
- Add “Flexible Fields” module by Customization Form to support dynamic fields.
- Each plant can define their own flexible fields.
- Information included:
  - Display Name: define Display Name.
  - Data Type: Textbox, Numeric, Listbox, Date.
Asset
- Support Batch Import for assets
  - Change Functions to match the Calibration Import function.
  - Asset Template to be available to download with all the information in General tab, Calibration tab, and all the Flexible fields for each site.
  - Add/Edit asset
    - Add Image field In General Tab.
    - In Edit mode, users can select/replace the Image with new Image. Image should display to users In Edit/View Window.
    - Set Asset Type as Optional in Edit Window.
  - Add My Asset Module
    - Show all info in Asset Module, pls consider to use current Edit Asset window.
    - This module is to list out current assets with logic as:
      - Add Group Categories: Asset Using Group, Asset Owning Group in Admin/Group.
      - List all assets assigned to current user in Asset Using Group and Asset Owning Group submodules.
    - Other functions are same as Assets module.
  - Asset View Module
    - Users can only view Asset. Show all Asset information in the Edit Asset View to include general, flexible fields, and calibration information.
    - Add feature in Asset and Edit Asset modes that allows users to save asset details to a file on local drive or send to printer.
    - This view-only module allows users to view all assets for their plant.
  Spare Parts
  - Add new module Part Categories.
    - Fields covered: Category Name, Description, Active or not.
    - Add, Edit, Enable/DIsable, similar to other modules. And support multi categories to be selected.
  - Add new sub module: Part Categories in Add/Edit Part window.
    - Fields covered: Category Name, Description, Active or not.
    - Add, Edit, Enable/DIsable, similar to other modules. And support multi categories to be selected.
    - Add below fields in Part Info:Model, Unit Weight, Project, Picture.
    - Link new Spare Parts Project submodule to Projects in CMMS Admin module.
  - Spare Parts Receiving
    - Add below fields in Receiving when being in External source type.
      - Customs # and Customs Date
    - Add Receiving User field: when selecting from popup window by default Current User Name.
    - Add Source Type, Source fields.
      - Source Type: External, Internal and WR (but WR type is not intended to be selected by user).
      - Receiving User: combo box by default value as Current User Name.
  - Spare Parts Issuing
    - Add Source Type, Source, Current User fields in Issue Part module.
      - Source Type: External, Internal and WR (but WR type is not intended to be selected by user).
      - Current User: combo box by default value as Current User Name.
  Backend Trigger to support front-end function
  - Currently, according to analysis, there are about 3 triggers needed to be developed.
    - Customization Form & Trigger: Equipment Info Auto Update.
    - Customization Form & Trigger: Spare Parts Receiving Creation.
    - Customization Form & Trigger: Spare Parts Issuing Creation.
  August 2018
  
  CR# 57857 Version [15.4.3]
  Non Medical Docker Version: 1.0.20180829-5
  Overview: Non-Medical HA Monthly Upgrade: SPC Server/Portlet
  
  Environments: corpmes3, corpmes4, corpmes5, corpmes6, corpmes8, corpmesspc3, corpmesspc4, corpmesspc5, corpmesprtl3
  
  mes15_quality_spc-server-1.2.10.180815-1.i386.rpm
  Bug Fix:
  - SR#3801652 Rapid IIoT-SPC monitor is not being displayed.
  - JIRA#MS-81 Family ID and the value is not shown in the chart.
  - JIRA#MS-82 Family ID value is not shown in the chart.
  mes15_quality_spc-portlet-1.2.10.180815-1.i386.rpm
  Bug Fix:
  - JIRA#MS-80 Error message prompts when user deletes Family Location.
  mes_15_MESWeb-4.4.23
  New Feature:
  - Released a new report called “WIP DASHBOARD”.
  Enhancements:
  - Pool connection setting to avoid unnecessary idle connections.
  - Improved performance queries on HRxHRdashboard report.
  - Changed Parameter name "Mfg Line" to "Line".
  Bug Fix:
  SR# 3824349
  - Updated PCB Multipage Traveler report for PCB Plants
  - Added ship notify label on Unit History report.
  July 2018
  
  CR# 57271 Version [15.4.2]
  Non Medical Docker Version: 1.0.20180711-1
  Overview: Non-Medical HA Monthly Upgrade: Portlets, Conduit, Production Scanning and other fixes
  Environment: device-maintenance-portlet, sfdc-portlet, portlet-setting-hook portlet, android-device-maintenance, plant-maintenance, site-maintenance, profile-maintenance, mes-migration, user-maintenance, server-information, 42Q.Monocle.Configuration.View, 42Q-monocle-Monitor, shop-order-control, target_maintenance, quality_spc-server, conduit-production-scanning, mes15_sfdc-agile-service, Updating Production Scanning, Updates: SPC Server, Print Queues, Conduit, CMMS.
  
  Portlet Update:
  mes15_portal-device-maintenance-portlet/1.11.13.180614-1
  Enhancement:
  - JIRA#MCSFC-176 To support long int type on community and server id in Device Maintenance portlet.
  Portlet Update:
  mes15_sfdc-portlet-1.14.26.180622-1
  SR# 3760361
  Enhancement:
  - JIRA#MCSFC-179 To add a new button to check and sync agile document/part when doing document mapping.
  - JIRA#MP-87 E43 production customization document mapping.
  Bug Fix:
  - JIRA#MCSFC-184 To fix the work instruction display issue when direct from agile is yes.
  - JIRA#MCSFC-183 Update wi_doc_id field by automatically once a work instruction is replaced/remapped.
  New Functionality:
  - JIRA#MSSFC-68 EManual-CAD view option from portal data collector.
  Portlet Update:
  mes15_portal_portlet-setting-hook-1.12.38.180228-1
  Bug Fix:
  - Fix com.liferay.portal.NoSuchGroupException: No Group exists with the key{companyId=10131, name=...}
  - Change run group check periodic
  Portlet Update:
  mes15_portal_android-device-maintenance-1.12.11.180109-1
  Enhancement:
  - JIRA MP-66 Upgrade to log4j 2 (portal core portlets)
  Portlet Update:
  mes15_portal_plant-maintenance-1.12.41.180108-1
  Enhancement:
  - MP-66 Upgrade to log4j 2 (portal core portlets)
  Portlet Update:
  mes15_portal_site-maintenance-1.12.41.180108-1
  Enhancement:
  - JIRA MP-66 Upgrade to log4j 2 (portal core portlets)
  - JIRA MP-75 Improve the process of applying the change to all profiles.
  - Show mask in assign user page.
  mes15_portal_profile-maintenance-1.12.40.180109-1
  Bug Fix:
  - Fix JIRA: MP-64 Check the issue and feedback: user not erased from user group role table
  Enhancement:
  - Enhance list site performance(in assign user);
  - JIRA MP-66 Upgrade to log4j 2 (portal core portlets)
  mes15_portal_mes-migration-1.12.34.180123-1
  Enhancement:
  - MP-66 Upgrade to log4j 2 (portal core portlets)
  mes15_portal_user-maintenance-1.12.31.180305-1
  Enhancements:
  - JIRA #MP-23: User maintenance if plant has no site, it will not shown in plant combo box
  - JIRA #MP-25: Improve performance of user-maintenance-portlet
  - In User Type combo box set default value ""All"".
  - Change label ""department"" to ""Department"
  - JIRA #MP-66 Upgrade to log4j 2 (portal core portlets)
  Bug Fixes:
  - JIRA #MP-83 LDAP user can't search user in User Maintenance portlet (due to userId overflow)"
  - SR#3623108:Fix bug: user attribute not saved when add user.
  mes15_portal_server-information-1.12.45.180117-1
  Enhancements:
  - Add program WI_Storage
  - JIRA#MP-66 Upgrade to log4j 2 (portal core portlets)
  - Add protocol options for Agile_Account
  mes15_42q-monocle-Monitor-1.6.0 & MES15_42q-Moncole.Configuration.View-1.6.0
  New Functionality:
  - SR#3756960: A new layer called Machine was added. It can be turned off or turned on from monocle configuration portlet. This new layer is per workstation per the line they belong to.
  mes15_Shop-Order-Control-2.11.4.180604
  Enhancement:
  - LE-206: LE duplicate print requests - add logging to Shop Order Printing
  mes15_Target-Maintenance-2.4.2.180416
  Bug Fix:
  - SR#: 3759352: MCT-180: Profile is not working on Target Maintenance Delete Table
  mes15_sfdc-agile-service-1.1.4.180607-1
  Bug Fix:
  - SR# 3760361: JIRA#MCSFC-178 To fix Agile document lost issue that reported from E51 plant.
  Enhancement:
  - JIRA#MCSFC-182 To support multi agile instance in eManual
  mes15_conduit_production-scanning-1.2.9.180611-1
  Bug Fix:
  - JIRA# MCSFC-167 To fix the issue on checking Automatic Submit just results in a bunch of checkboxes. (Root Cause: Liferay Employee Number Information to be written into Production Scanning issue causing style call all the time without stop. This will also affect Station ID and Command loading).
  Enhancements:
  - JIRA# MCSFC-164 To Enhance the END operation to support the Auto Submit with P.I.E.
  - JIRA# MCSFC-168 To support the mesportal DB moved to RDS.
  - JIRA# MCSFC-172 To support receiving document from https protocol
  - JIRA# MCSFC-177 To support long int type community and server id in production scanning
  - JIRA# MCSFC-180 To remove plant code upper case in production scanning which caused document displaying issue
  - JIRA# MCSFC-181 To fix display module issue after production scanning integrated into portal
  mes15_quality_spc-server-1.2.8.180323-1
  Bug Fix:
  - SR#: 36481784 SPC does not see defects on OCAP(e30_01)
  mes15_cmms-portlet: 1.0.2.180320-1
  - Supoort portal server info new API
  May 2018
  
  CR# 56875 Version: [15.4.1]
  Non Medical Docker Version:
  - mes-portal-portlets:1.0.20180516-4
  - mes-portal:1.3-05-20180516-48
  - production-scanning:ps-1.2.5.180314-1
  - production-scanning:tomcat-20171023-1
  - mes-portal-proxy:1.0.3-20171023-1
  - filebeat:1.2.0
  - logspout-logstash:1.0.0
  Overview: Updated production scanning docker image
  Environment: device-maintenance-portlet, pts-portlet, production-workspace, server-info-portlet, sfdc-config, sfdc-portlet, shop-order-control, production-scanning, corpmesprtl3.sanmina.com.
  
  mes15_portal-device-maintenance-portlet-1.11.12.171220-1
  
  Enhancement:
  - JIRA#MCSFC-134 Optimize Log File for Conduit Interface Connection
  - JIRA#MCSFC-142 To upgrade server information hook service library
  mes15_sfdc-portlet-1.14.25.180511-1
  Enhancements:
  - SR#3470918 Can not select part number by mouse when uploading document.
  - SR#3098203 eManual shows wrong process (location) in "Current" and "Pass To" processes.
  - JIRA#MCSFC-136 User doesn't have to map a WI to use AVP
  - JIRA#MCSFC-141 To fix the reset icon missed issue in data collector portlet.
  - JIRA#MCSFC-134 Optimize Log File for Conduit Interface Connection
  - JIRA#MCSFC-142 To upgrade server information hook service library
  - JIRA#MCSFC-152 To support the agile url with https protocol in sfdc portlet
  - JIRA#MCSFC-168 To support the mesportal DB moved to RDS
  - JIRA#MCSFC-165 To support agile document with special characters on direct from agile = yes
  - JIRA#MCSFC-169 To fix the part number can't be selected issue in document mapping page
  - JIRA#MCSFC-173 To support the capability on querying workstation with any four letters.
  - JIRA#MCSFC-174 To clear the input value of index 0 from part number combo for Engineering Note mapping.
  mes15_sfdc-agile-service-1.1.4.180323-1
  - JIRA#MCSFC-91 Adopt log4j upgrade to 2.x
  - JIRA#MCSFC-152 To support the agile url with https protocol in sfdc portlet
  - JIRA#MCSFC-163 To fix the agile document does not update into alfresco issue
  mes15_conduit_production-scanning:ps-1.2.5.180314-1
  - MCSFC-162 To fix the employee no doesn't match with input value in PS client JIRA#MCSFC-120 Remove Wording for Production Scanning Screen
  - JIRA#MCSFC-106 To Enable sequence modification in document mapping for step work instruction.
  - SR#3576311 Suzhou Production scanning is not working at 42Q Suzhou.
  - JIRA#MCSFC-135 To fix the issue of attribute miss match with the group."
  - JIRA#MCSFC-139 To replace Java Json library and Scanned Unit object with google Json libaray.
  - MCSFC-108 Provide validation for component location and status
  - MCSFC-107 Improve the UI to try enhance the way of showing ""component"" and ""attribute"" headers
  - MCSFC-125 Consider to allow user partially submitting pre-configured components and attributes, without having to enter the ‘NEXT’ text
  - MCSFC-126 Switch the layout for WI and Command sections and make each half width
  - MCSFC-127 Optimize the ‘Information’ section"
  - MCSFC-148 Add hint for every tab in displaying as data collector module
  - MCSFC-150 The changes to support multi-language in PS client
  - MCSFC-149 Change to display a command prompt rather than command name in data collector module.
  - MCSFC-153 To fix the language drop down issue in configuration page.
  - MCSFC-154 Add a new property file to support Spanish.
  - MCSFC-155 To hide the 42Q logo when displayed from portal.
  - MCSFC-137 portal integration
  - MCSFC-90 Adopt log4j upgrade to 2.x for OEE data collection, production scanning, route builder
  - MCSFC-156 Allow operator completes unit scanning with minimum mouse and keyboard interaction.
  mes_15_PTS Portlets v1.3.4
  Enhancement:
  - Support new server information API: mes15_portal_server-information-1.12.43.171225
  mes15_sfdc-webservice-1.12.13.180131-1
  Enhancement:
  - SR#3470918 Can not select part number by mouse when uploading document
  mes15_portal_server-information-1.12.45.180117-1
  Enhancements:
  - Add program WI_Storage
  - MP-66 Upgrade to log4j 2 (portal core portlets)
  - Add protocol options for Agile_Account
  mes15_-shop-order-control: 2.10.0a
  Bug Fix:
  - JIRA#MCT-169 Support case insensitive filter on Shop Order and Part Number modules
  mes15_production-workspace-1.0.7
  Bug Fix:
  SR#3683736
  - Changing from batch mode to individual (or vice versa) requires the user to refresh the page before proceeding.
  - Inconsistent textbox focus order individual vs Batch Mode
  - Remove Multiple Scanning option on Terminal Block workspace
  - Terminator Settings can change by reboot
  - Production Workspace - Not reporting to the user about auto commands execution
  - Inconsistent focus in Serial Number text box
  - Production Workspace Improvements
  mes15_measurement-3.1.3.2
  CR: 56877
  Bug Fixes:
  - SR#3640072: Activity's audit records are not being saved on API calls. Measurement is supposed to audit all payload processing (API or Backend Service processing). Measurement CORE was changed to store audit records correctly, based on the client id.
  - SR#3637606: Measurement receiving timeout errors when processing parallel payload requests. Store function was fixed to work with temp tables instead of unlogged tables.
  ***March 2018***
  
  CR# - #55552 Version: [15.4]
  Medical Docker Version: 1.0.20180115-2
  Overview: Full Medical HA Upgrade
  Environment: Medical Production HA Environment, corpmes2, corpmesr2, corpprtl2/cmmes.sanmina.com, corpmespts2, medical pts linux server, corpmesspc2, NEW conduit server
  PSI_2.11.apk
  New Functionality:
  - The Production Scanning Interface (PSI) app handles production scanning activities on the Android Client, which includes five modules for the operator to enter production quality data:
    - Data Collector - Command mode which support over 60+ different SFDC operations in Integrated Manufacturing operation.
    - PCB Work Order - Graphical mode which supports non-serialized types of data collector operations(Work Order based). Integrates with InPlan Traveler & PCB On-Premise Content Repository.
    - Work Instruction - Mode for viewing work instructions.
    - Scan Activity - Similar to the above "Data Collector" mode but also displays historical operation activities.
    - Unit History - Production audit trail of user input for a serialized unit.
  Enhancements:
  - Packaged to comply with Play Store Security Policy
  - Introduced new HttpConnection API for DNS to support WAF
  - Support to get alfresco server from portlet to work with HA environment
  Bug Fixes:
  - SR#3589897: "Back" button is missing
  - SR#3275795: Manufacturing Help not resetting between work orders
  - SR#3383293: Work Instructions not displaying under External Network
  - Station ID can't refresh until Android application management data is cleared. (From this version, please Click ""RELOADING STATION ID"" button to update the station list to select.
  Appgarden-42Q_2.03.apk
  New Functionality:
  - Appgarden-42Q is a management application running on Android to manage device access and provide air-deployment.
  Enhancements:
  - Create MD5 while uploading APK file via apk-maintenance portlet
  - Support downloading schedule setup to reduce the pressure of network
  - Support DNS host name for air-deployment server
  - Support air-deployment under Non-Sanmina Network
  - Introduce new HttpConnection API for DNS to support WAF
  - Support to get alfresco server from portlet to work with HA environment
  Label Engine Admin View 2.2.0
  New Functionality:
  - Local Printing Enabled
  Enhancements:
  - Replaced Sanmina loading logo with 42Q
  - [LE Print History]: Renamed "Print Queue / Printer Name" to "Print Destination"
  - [LE Print History]: Filter Enhancements - View Raw Data and Local Print
  - Able to print labels with Serial Numbers that contain a space as part of its character
  Bug Fixes:
  - Fixed problem that occurs when deleting an element
  - Fixed issue where mappings would not occur for new version/copy of a label
  - Fixed multipage PDF printing to function as expected
  mes15_lbleng-view (version: 2.2.0)
  Enhancements:
  - Replaced Sanmina loading logo with 42Q
  - Extended the Printer name length to more than 10 characters.
  MESWeb Central
  mes15_Sanm.MESWeb.Central.View-1.06.0
  Enhancements:
  - New logo for 42q when the page loads
  - New icons in the menu
  - Hide submenu after select one option
  - Report Parameters: be able to select all option (*) and add a filter.
  Reports Creation
  Enhancements:
  - New screen Reports
  Bug Fixes:
  - Avoid publishing reports when a parameter is empty
  - Avoid creating more than one drilldown per column
  - Avoid duplicating sqlName in parameters
  - Be able to save reports after filling out all of the tabs.
  - Private checkbox is working
  Data Sources:
  Enhancements:
  - Be able to delete more than one record at the same time
  - Able to export data (Data Sources)
  Bug Fixes:
  - Avoid duplicate Data Source name by application
  - Show the Connection String without user and password
  - Display success and fail messages
  - Focus on the first element of the screen
  Locations:
  Enhancements:
  - Default reports and group of reports will be added when a user creates a new location.
  - Be able to delete more than one record at the same time
  - Able to export data
  Bug Fixes:
  - Avoid duplicate Locations
  - Display success and fail messages
  - Focus on the first element of the screen
  Report Groups:
  Enhancements:
  - Able to export data
  - Be able to delete more than one record at the same time
  Bug Fixes:
  - Avoid duplicate Report Group name by application
  - Display success and fail messages
  - Focus on the first element of the screen
  User Groups
  Enhancements:
  - Able to export data
  - Be able to delete more than one record at the same time
  Bug Fixes:
  - Avoid duplicate User Group name by application
  - Display success and fail messages
  - Focus on the first element of the screen
  mes15_Sanm.MESWeb.Central.View-1.5.161017
  Bug Fixes:
  - Fixed an issue when trying to add customer permissions to a user group.
  - Fixed an issue where all data sources by location were shown in the Customer’s section at the permission windows (By user and group). Now it only shows mesr data sources.
  - Fixed an issue with SQL Server connections. BounceCastle was causing the issue, it has to be removed before establishing the connection.
  mes15_Sanm.MESWeb.Central.View-1.4.160708
  New Functionality:
  - Added "Changed By" to the report version. The report’s history now will show who made a change to the report.
  Enhancements:
  - Several cosmetic issues were fixed such as button alignment, labels on summary, resize window, and the Publish report message.
  - List boxes in Roles, Report Groups, Reports, MESR Customers, Data Source are now sorted alphabetically.
  Bug Fixes:
  - Fixed a bug in User Permissions that deleted previous permissions granted if tab was not loaded.
  - Import Users now is fixed.
  - Fixed a bug that displayed predefined reports in the report search.
  - Fixed bug that displayed all report in predefined reports maintenance and predefined mapping.
  - Fixed an issue with serialization. Serial UID was added to ColModel and DrillDown Class.
  MES15_MESWeb.4.1.33.051717/
  New Functionality:
  - Unit History displays archived units (Only from the new archive model).
  MES15_MESWeb.4.1.23.050616/
  New Functionality:
  - Added Google Drive Export Option
  MES15_MESWeb.4.1.35.080117-2 - CR#55500
  Bug Fixes:
  - Fix a problem with exporting Measurement data in the Unit History report
  MES15_MESWeb.4.1.35.080117-1 - CR#55452
  Bug Fixes:
  - Fixed problem where Unit History that includes Measurement data could not be exported to any format.
  - Corrected problem with time zone on activities not matching with the correct values in db.
  - Fixed issues with unexpected serials displaying in Unit history.
  - Fixed problem with Attributes from parent serials and child serials getting mixed for batch units.
  - The label "Removed" on attributes was not displayed when an attribute is removed, The action does indicate it was removed, but the one missing is an additional label to make it more descriptive.
  - Fixed Unit History not enable those users that were granted with access on groups of users in Central.
  MDS SCHEMA CHANGES
  revision 46
  - add type and table for 2 person verification
  - add columns to soms_target_def and soms_target_param_def tables
  - add required_quantity field to bom_item
  revision 47
  - Remove duplicate employee.employee_number records and replace current employee_employee_number index with a unique one
  revision 48
  - add serdef.repair_activity_key index, delete temp one if exists
  revision 49
  - add wip_movement.serial_key index, delete temp one if exists
  revision 50
  - add supply_subinventory, supply_locator to bom_item table
  revision 51
  - add serial_ship table
  - add ship_ts to ship_notify table, not updating ts in existing records.
  revision 52
  - add activity_employee_key_idx index
  revision 53
  - add 2 new types for client team
  revision 54
  - upper index on employee.employee_number for upemplog delays
  revision 55
  - add catalog_transition table; if < 5m records migrate data and rename tables, in order to add a primary key to the catalog table. If > 5m catalog records, this revision will need to be done manually.
  revision 56
  - raise exception if catalog_transition table does not exist, or not same number of records in catalog and catalog_transition. If all good, add indexes back to catalog table.
  revision 57
  - add wip_movement_activity_key index
  revision 58
  - new double_generic_udt type
  revision 59
  - unique indexes for sample_master.name, sample_plan.name
  revision 60
  - new shop_order_op_resource table
  SFDC Core Command Changes
  autorfc
  - SR 3286377 Fix log statement errors preventing users from doing anything
  downattrdef
  - SR 3258919 Removed update on temp table. Performance issue
  downserialbyso2
  - SR 3342753 Change to send serials ordered by serial number
  getempval
  - SR3390673 Added "group by" to get rid of duplicate output records
  - SR3298776 Add grace_days to expiration_date and send 0 for grace days.
  newsampplan
  - SR 3369643 Check for empty or duplicate plan name
  upact/upactser
  - SR 3200956 Changes for sbatch wip moves july '16, NS batch action 22, wipmoves Oct '16
  upsamplog/upsampplan
  - SR 3281143 Allow to complete if foreign key violation as client allows records to be deleted.
  upserdef
  - SR 3065774 If cannot find serial with part, find by serial alone.
  - Create defect code as upper. If not found as upper, look for repair code as upper
  SFDC Custom Command Changes
  add2nextso
  - SR3244354 Wrong serial key used in add to shop order activity
  add2so1, add2so2
  - SR3050794 Coalesce to avoid null data errors
  boxgenz, boxgenztest, boxlabeng
  - SR3357445 Display error if cntnr qty does not match serials assigned
  chgso
  - SR3050794 Coalesce to avoid null data errors, now sending qty on initial prompt
  chgso3
  - SR3050794, SR3377516 Coalesce to avoid null data errors, use dummy serial on old SO if status 15/28
  chkfail3
  - SR3025997 New conversion from legacy
  clockin/clockout
  - SWI1004896 Update from department to code_name
  cre8comp
  - SR3226386 Performance enhancement. Updated component query to use upper indexes
  cre8mac2 / cre8mac3 (putalgorithmonhold api)
  - SR3287404 Corrected issue with locking to prevent simultaneous execution
  chgid60
  - SR3154572, SR3355214 Bug fix to look for serial without part- Use upper on a search, change prefix prompting decision to be like legacy
  chkprocfailq
  - SR3400324 Bug fix
  dumpcntnr4/dumpcntnr5
  - SR3043320 Allows unit_type of 100 to 109. Required by and deployed for E55
  dupchksn
  - SR3389767 Add check of existing serial in catalog table
  empdupchk
  - Planview SWI: 1002548 New custom for e90 medical.
  moveifattdata
  - SR3037717 Use sfdc_key to find location when ambiguous
  moveifnoref
  - SR3030366 New conversion from legacy
  notify
  - Planview SWI: 1003023 Enhancement to add Shop Order and Employee to notification
  showatt
  - SR3091190 Upper search on attr_name
  tsidcomp (custom e90 hybrid)
  - SR3326089 Do not send RLSE if unit already has a component
  vercmpproc
  - Planview SWI:1004505 New custom for e73 medical, probably specific to them.
  xfersnarchive
  - SR3140999 Updated to restore immediately when requested.
  Other Backend Changes
  alg_engine
  - SR3298098 Prevent late reset in the algorithms
  getActivityActionData, getActivityActionDescription
  - Support action code 88 (Ship Notify) in unit_history view
  get_config_data
  - WR 203511 Prevent failure in getting the data from config file
  get_route_steps
  - http://phabricator.sanmina.com/T1504 MDS API 2.06.00.20170104
  get_step_details
  - http://phabricator.sanmina.com/T1504 MDS API 2.06.00.20170104
  get_wip_moves1
  - CR52359 Support added to decrease run frequency for a db so it doesn't run everytime cron entry runs wip move
  movesntonextso
  - SR3185778 Adjust shop order unreleased qty only if consumed a dummy, set location key = 0 instead of null for serials updated
  nextgen_online_call
  - On qty decrease don't adjust shop order qty to be real qty
  remove_stat64_serials
  - Used by nextgen_online_call, bug with shop_order query variable name
  rollout
  - SR3026440 Prevent replace current development label
  ship_notify_serial
  - Add ship notify key to serial for any status, add ship activity and add entry to new table serial_ship
  cirrusstreamio.so and streamio.sql
  - NEW method of writing to files; used by new xfersnarchive/legacy_archive code and librelot.
  cirruspsqlFuncs.sql
  - Added db name to logging, fixed handling of versions on log files
  MDS Code Changes
  BOXGENZ
  - Added message - CNTNR QUANTITY ERROR – TRY TO PRINT LATER!
  BOXGENZTEST
  - Added message - CNTNR QUANTITY ERROR – TRY TO PRINT LATER!
  BOXLABENG
  - Added message - CNTNR QUANTITY ERROR – TRY TO PRINT LATER!
  Rollout.sql
  - Changed to check whether there is a label in the development area. If so, an error message is displayed to the user (“Dev label type <label number> already exist. Roll-out cannot be executed.”).
  get_route_steps.sql
  - Syntax changed to work with MDS API version
  get_step_details.sql
  - Updated to bring all departments of locations as an import/export feature.
  MDS Portlets
  Algorithm Tool
  Bug Fixes:
  - MCT-13 (JIRA) - Resource leak fixes (MDS-90633)
  Audit Report
  Bug Fixes:
  - MCT-8 (JIRA) - Resource leak fixes
  Configuration Publish
  Bug Fixes:
  - MCT-25 (JIRA) - Resource leak fixes (MDS-90566)
  - T672 - Change Configuration Publish Labels (MDS-90544)
  Employee Validation Maintenance
  Enhancements:
  - MCT-42 (JIRA) Able to filter the Class' employee treepanel. (MDS-90604)
  - Able to export export class' employees to CSV file.
  Bug Fixes:
  - MCT-18 (JIRA) - Resource leak fixes (MDS-90634, MDS-90635)
  - MCT-28 (JIRA) - Last Name information is exporting from main grid (MDS-90620, MDS-90623)
  - MCT-41 (JIRA) - Class' Employee paging when adding/removing employee and groups. (MDS-90605)
  - T1381 - Performance Issue when have too many records on Add window (MDS-90605)
  - T1765 - Not able to assign operators to a class that already has many operators. (MDS-90590)
  - T1907 - Users can not search fuzzily in EV (MDS-90591, MDS-90592, MDS-90593)
  - Fix Layout Issues
  Employee Validation Process Control
  Bug Fixes:
  - MCT-17 (JIRA) - Resource leak fixes (MDS-90636, MDS-90637, MDS-90638)
  - T1381 - Performance Issue when there are too many records in the Add window. (MDS-90605, MDS-90631, MDS-90630, MDS-90625, MDS-90627, MDS-90628)
  Generic Attribute
  Bug Fixes:
  - Fixes MCT-9 (JIRA) - Resource leak fixes (MDS-90639)
  Kit Verify - Configuration
  mes15_kv-configuration-2.3.1
  Bug Fixes
  - MCT-20 (JIRA) - Resource leak fixes
  - Copy Template was not working. (MDS-90609)
  Kit Verify - Production
  mes15_kv-production-2.10.4.1
  Bug Fixes:
  - MCT-21 (JIRA) - Resource leak fixes (MDS-90542, MDS-90596, MDS-90609)
  - DOC - Return the pointer of the mouse to the field to introduce the new serial or PN in KV Processing (Integration, Repair); (MDS-90610)
  - T1928 - KV did not allow to complete the Integration process when "Save". (MDS-90602 /Test Report)
  - T1951 - Assign automatically the Route when the SN was moved using SFDC (MDS-90601/ Test Report).
  - T1928 - The quantity considerate by application is required_quantity (for E79 and E35) column from bom_item table. However, if no customization is enabled we should look for quantity (standard) (MDS-90597 / Test Report)
  - T1517 - Create a new Generic Attribute that configure a flag to allow the user to skip the consolidation phase. (MDS-90579)
  - T1517 - The layout mapping selection should show the part number and part family. (MDS-90540)
  - DOC - Create a new Generic attribute kit_integration_ignore_bom_item_type (to remove any item type from Integration) (MDS-90613)
  - MCT-30 / SR 3364492 - Support to Input mask (2D Barcode, Standard Only). (MDS-90612)
  - MCT-34 / SR 3364507 - Disable Consolidation Short Feature, by generic attribute kit_enabled_short (MDS-90611)
  Labor Tracking
  Bug Fixes:
  - MCT-16 (JIRA) - Resource leak fixes (MDS-90512, MDS-90576)
  - T1686 - The Department field is optional and setting (N/A) when updating/adding a record. (MDS-90577)
  Multi-Level Containerization Configuration
  Bug Fixes:
  - MCT-14 (JIRA) - Resource leak fixes (MDS-90640)
  Multi-Level Containerization Maintenance
  New Functionality:
  - DOC / New Feature T1545 - Added Generic Attribute “complete_transaction_auto_close_shop_order”, to enable/disable the auto close shop order after perform the Complete Transaction. (MDS-90622)
  Enhancements:
  - T1545 / MCT-31 - Added the Generic Attribute “complete_transaction_extra_quantity_enabled” to allow/disallow the operator complete the transaction if there are missing or extra components. (MDS-90621)
  - T1545 - Add Generic Attribute “complete_transaction_enabled” for enable/disable the Complete Transaction. (MDS-90618)
  Bug Fixes:
  - MCT-15 (JIRA) - Resource leak fixes (MDS-90641, MDS-90650)
  Quality Batch Release
  Bug Fixes:
  - Fixes MCT-37 (JIRA) - Resource leak fixes (MDS-90661)
  Serialized Item Tracker
  mes15_serialized-item-tracker-2.4.4.171011-1.i686.rpm
  Bug Fixes:
  - Fixes MCT-22 (JIRA) - Resource leak fixes (MDS-90659, MDS-90657)
  - Fixes MCT-91 (JIRA) - Receive SIT Range not support big range of serials and attributes
  - MDS-90682:SIT -> Edit Standard (Add dozens of attributes)
  - MDS-90681:SIT -> Receive -> Manually Entered (Huge Quantity)
  SFDC Configuration
  mes15_sfdc-config-2.5.2
  Bug Fixes:
  - MCT-12 (JIRA) - Resource leak fixes (MDS-90552, MDS-90656, MDS-90658, MDS-90484, MDS-90642, MDS-90666, MDS-90643, MDS-90646, MDS-90647, MDS-90525, MDS-90655, MDS-90648, MDS-90654, MDS-90649, MDS-90652, MDS-90669, MDS-90416, MDS-90668, MDS-90667, MDS-90454, MDS-90395, MDS-90665, MDS-90503, MDS-90419)
  - MCT-40 - Pagination needed on Attribute Name List (MDS-90626)
  - MCT-43 - Fixed the Attribute Definition grid paging. (MDS-90629)
  - MCT-44 - Fixed the Part x Route Assignment Grid Paging issue (MDS-90632)
  - T1707 - SFDC Configuration -> Assembly -> Add new Component Type (MDS-90624)
  - T1885 - SFDC - Attribute Def -> Some functionalities are not working properly (MDS-90583 MDS-90581 MDS-90585 MDS-90586 MDS-90587 MDS-90588 MDS-90589)
  - T1887 - SFDC - Assembly -> The copy functionality is not working (MDS-90431)
  - T1894 - SFDC - MFG Hold -> Returning error message when the email was not sent (MDS-90582)
  - Increase defect code description to 250. (MDS-90617)
  Shop Order
  New Features:
  - T1684 - Commit Sales Order (For E85) (MDS-90571)
  Enhancements:
  - MCT-19 (JIRA) - Resource leak fixes. (MDS-90423, MDS-90422, MDS-90660, MDS-90599, MDS-90520, MDS-90435)
  - MCT-32 (JIRA) - Allow the same part number to be added multiple times in the same hierarchy level but in different order lines via the Recipe Display Maintenance screen. Make all BOM item fields editable. (MDS-90614)
  - T1906 - Return an error message in case of update bom key only on Serials and there is any serial that is locked. (MDS-90615)
  - T1952 - Serial Number Maintenance/ Assignment - Issue on manage serials quantity higher than 1 (MDS-90600)
  - T1684 - Bug fixing : Sale Order was not getting the container info when the order line doesnot have serial number (MDS-90520)
  - DOC - Add Generic attribute “allow_close_erp_shop_order” to enable/disable close ERP ShopOrder. (MDS-90616)
  - T1684 - Generic Attribute “allow_sales_order_commit” to control the access to Commit screen; (Only E85 should have access to this features) (MDS-90569)
  - T1684 - Generic Attribute to allow the user commit a sales order when we have serial numbers missing to assign; (MDS-90572)
  Siren Configuration and Operation
  Enhancements:
  - T1566 - Translations for Chinese and Portuguese.
  - T1743 - Sending the Request to the service layer in order to use the database information through Server Information
  - Fixed the buttons order regarding Save and Reset.
  - MCT-45 - Add a prefix in the json string stored in event_data (MDS-90653)
  Bug Fixes:
  - MCT-10/11 (JIRA) - Resource leak fixes. (MDS-90662, MDS-90663)
  SQC
  Enhancements:
  - Escaping Part Number and Process values so they can contain commas in csv file for importing. (MDS-90547)
  Bug Fixes:
  - MCT-23 (JIRA) - Resource leak fixes. (MDS-90664)
  Target Maintenance
  Bug Fixes:
  - MCT-24 (JIRA) - Resource leak fixes. (MDS-90644, MDS-90645)
  Measurement - 3.1.0.1
  Bug Fixes:
  - Fixed the bug that caused a Serial Number that was on WAITINGINSPECTION to be scanned and submitted again;
  - Fixed the bug that caused a Serial Number that had already been inspected INSPECTED (but was waiting for the Autolog operation to be executed) to be scanned and submitted again;
  - Fixed the bug that was allowing the user to click on the Submit button even when a Serial Number was on a Flow Error situation;
  - Measurement is now properly locking Auto SFDC locations to avoid that the same device is used by two different users. Previously the locking was considering only the device number, disregarding that the same device number can be used in different SFDC PCs;
  - Measurement is also locking Serial Numbers to avoid that two different users scan the same Serial Number;
  - Measurement was not requiring a user to re-authenticate before changing a Tooling, even when said Tooling had been inserted by another user. Now Measurement is properly asking for a user's credentials before allowing he/she to update a Tooling;
  - Improved the performance when scanning a Serial Number and also when submitting a Checklist;
  Inspection Review Bug Fixes:
  - The Ignore and False Call reviewed status now block the defect dropdown;
  - Fixed a behavior where the Inspection Review popup would unexpectedly close whenever the user selected the first item from the defect dropdown;
  - The defect dropdown is permanently disabled when an Activity has an overall defect code;
  - The inspections review date is now considering the time zone accordingly;
  Tooling Bug Fixes:
  - Fixed the high memory usage that the Tooling module was causing whenever the module was loaded;
  - Fixed the bug that was preventing users to update a Tooling name. Now it's possible to have two or more Toolings with the same name as long as they have different Revisions;
  Recipe Bug Fixes:
  - Fixed the bug that was allowing the user to insert the same display order for different Test Groups;
  - Fixed the bug that was allowing the user to insert the same display order for different Test Steps;
  Log Viewer Bug Fixes:
  - Fixed the filter Source. This filter was displaying the options from the Severity filter instead;
  System Log Bug Fixes:
  - Fixed the bug that prevented users from downloading a log file if that log file was being written by Measurement Core at that moment;
  - Now the files in the dropdown are ordered based on the last modified date. Files that were modified more recently appear first;
  Parser Bug Fixes:
  - Fixed the text present at the Test Station's bulk load popup;
  - Fixed the bug that was happening whenever the user updated a Multi Instance Dynamic Configuration. The Dynamic Configuration table wasn't being refreshed;
  Package Bug Fixes
  - Package was raising an error message after insert a new core version in a package because the core version contains whitespace;
  - Fixed the bug when the user add a new core version in a package on central, every instance where this package is installed must be updated.
  General Bug Fixes:
  - Fixed the bug that could cause the user to be redirected to the wrong landing page when clicking on the button Return to Menu (located at the top-right corner of the screen);
  Core Inspection Review Bug Fixes:
  - Now Measurement Core is responsible to set the Activity's Reviewed Status. Before this change it was up to the Parser to set this value, which increased the chance of bugs caused by the lack of this value;
  - When communicating with Conduit the defects weren't being repaired despite the fact that the Reviewed Status was Repaired. This behavior is fixed and now the defects are being properly repaired;
  - Fixed the bug that caused Measurement to always record the Station's default defect code. Now Measurement is saving the defect that was selected by the user when he/she performed the Inspection Review;
  General Bug Fixes:
  - A more user-friendly message is shown when Measurement is not able to determine whether it should use Conduit or Auto SFDC;
  - Now Measurement handles properly the Conduit response when a partnerinformedend command is executed;
  - Fixed an issue that caused Measurement to always use the content from the first processed file when processing more than one file. The content from all the files that came after the first file was never processed;
  - Now the DEBUG logs from Measurement Core are being properly recorded. Before this change, DEBUG logs were created only when a Parser was being executed;
  - Fixed a bug that was causing DEBUG logs to be duplicated;
  - Fixed the bug that caused a defect to be recorded multiple times despite the Parser being configured to group defects;
  - Now Measurement is taking in consideration the Activity Type before deciding if the Autolog will be performed and if an Activity needs to be created;
  Standard CSV Parser Bug Fixes:
  - Added the validation that checks if each Measurement present in the file has its Status properly set;
  - Fixed the bug that caused this Parser to perform the Autolog operation for Conduit despite the fact that the Station was disabled in Measurement;
  Standard JSON Parser Bug Fixes:
  - Fixed the bug where the Parser was saving theOperator's password at the wrongfield, which then caused the Auto SFDC communication to fail in the scenarios whereMeasurement needed to provide theOperator's password;
  CMMS Portlet 1.0.1
  New Functionality:
  - Add the new Asset Calibration Info Report
  - Add the Downtime Resolution Cycle Time Report
  - Calibration automatically send e-mail
  - Escalation for the PM & Calibration
  Enhancements:
  - Get rid of the add user function and retrieve the user data from the portal.
  - Add the asset name as the condition for the WO Order List Report & Equipment Downtime report
  - Add the PM Plan Date at the Work Order Edit Form
  - Add the fuzzy query for the asset portlet
  - PM: add escalation rescheduled email group and escalation rescheduled email before days,by setting these two attribute values auto send email to correlation group.
  - Add the checklist data at the PM Plan & Reschedule Report
  - Performance enhancement for the Update Downtime Report.
  - Optimize the checklist operation
  - Enhance the downtime trend analysis report for more detail information
  - Enhance the Downtime Problem Analysis report for more detail information
  - Enhance the HTTPS support
  - Enhance the CMMS Work Order Dashboard performance and add the PM detail status information.
  - Add the new web service to return the CMMS machine status
  CMMS Web Service v1.0.1
  New Functionality:
  - Add the new Asset Calibration Info Report
  - PM: add escalation rescheduled email group and escalation rescheduled email before days,by setting these two attribute values auto send email to correlation group.
  - Add the Downtime Resolution Cycle Time Report
  - Calibration automatically send e-mail
  - Escalation for the PM & Calibration
  - Add the new web service to return the CMMS machine status
  Enhancements:
  - Get rid of the add user function and retrieve the user data from the portal.
  - Add the asset name as the condition for the WO Order List Report & Equipment Downtime report
  - Add the PM Plan Date at the Work Order Edit Form
  - Add the checklist data at the PM Plan & Reschedule Report
  - Performance enhancement for the Update Downtime Report.
  - Optimize the checklist operation
  - Enhance the downtime trend analysis report for more detail information
  - Enhance the Downtime Problem Analysis report for more detail information
  - Enhance the HTTPS support
  - Enhance the CMMS Work Order Dashboard performance and add the PM detail status information.
  Bug Fixes:
  - Fixed the Work Order Assign To Me issue
  - Fixed the Part Details Report loading issue
  - The dashboard wo status drop-down menu does not work
  - Import Checklist – Site Drop-down menu does not work
  - The Add Cycle Count Submit Button doesn't work
  - The e-mail escalation issue for the PM, Calibration & Repair.
  - Import Calibration - Can not open csv file in windows
  - Import Asset - Can not open csv file in windows
  - Asset - In Calibration next calibration date error, timezone issue found by E26
  - All module - Timezone issue of diffrent browser version and different timezone - found by Tamas
  - Add the Waiting for Approval status at the Work Request.
  - Fixed the Dashboard Work Order Creation project drop-down menu issue.
  - Fixed the Calibration manual send e-mail issue
  MES-Fuji Portlet v2.0.3
  New Functionality:
  - Panelization: create panel and board bonding records and share it with other workstations/systems
  - Support MSD control: Integrate PTS MSD control with Fuji host interface
  Enhancements:
  - Skip board(scrapped board) whil auto create S/N
  - Add clear modules function in PTS-FUJI line mapping
  - User can edit FUJI line & machine name in edit function of production line settings
  MES-Fuji Web Service v2.0.2
  New Functionality:
  - Panelization: create panel and board bonding records and share it with other workstations/systems
  - Support MSD control: Integrate PTS MSD control with Fuji host interface
  Enhancements:
  - Skip board(scrapped board) whil auto create S/N
  - Add clear modules function in PTS-FUJI line mapping
  - User can edit FUJI line & machine name in edit function of production line settings
  mes15_pts-portlet- 1.3.2
  Bug Fixes:
  - Change date code and lot code at material reprinting page.
  - Add option not print physical label(just change data in database).
  - 100 percent hand placement bug fix.
  - Reset Material Quantity(Zero Offset).
  - Change feeder type list display auto-complete char size from 4 to 1 and order by len(name). Add feeder type full name match query.
  - Fix function ‘Machine Registry’ query(main report and auto-complete) related bugs.
  mes15_pts-portlet-1.3.3
  New Functionality:
  - Reset Material Quantity(Zero Offset).
  - Implement and improve 'Traceability for Programmed IC' function and 'Indirect Material' function.
  - Supply function 'Location Mapping Report'.
  - Printer control through GUI.
  Enhancements:
  - PTS Rework and Fuji Rework function integration(one UI support replace component either tracked by PTS or Fujitrax).
  - Change ‘Accept Property’ item from current read-only to selectable for current ‘Reprint Material Label’ function page.
  - 'Lot Code Required' and 'Date Code Required' switch control for function 'Material Labelling'.
  - The 'Reprint Label' function 'Inspection Date' item editable permission control.
  - Change date code and lot code at material reprinting page.
  - Add option not print physical label(just change data in database).
  - Change feeder type list display auto-complete char size from 4 to 1 and order by len(name). Add feeder type full name match query.
  - Multi-language support for touch pages.
  - Improve function 'Material Labelling' item Pb-Free Category display logic (change to base on manufacturer info pb_category value).
  - Improve function 'Material Labeling' and 'Reprint Material Label' item 'Country of Origin' display by
  - System Setting configuration options.
  Bug Fixes:
  - 100 percent hand placement bug fix.
  - Fix function 'Machine Registry' query(main report and auto-complete) related bugs.
  - Change function 'Reprint Material Label' item 'Current Quantity' max value from current current_qty value to total_qty value if System Setting switch 'Material Label Quantity Control' value is 'Yes'.
  PTS Web Service v2.1.9
  New Functionality:
  - Implement scanning board by workstation name web service interface.
  - Supply function 'Location Mapping Report'.
  - Printer control through GUI.
  - Implement and improve 'Traceability for Programmed IC' function and 'Indirect Material' function.
  - Reset Material Quantity(Zero Offset).
  - Add the new web service method to support scan board by PTS workstation without location mapping.
  Enhancements:
  - Add a System Setting switch to process 'msd control or not for materials on board'.
  - Implement loading material aml validation about 'OBS-MPN' logic (including fuji verification).
  - Improve function 'Material Labelling' item Pb-Free Category display logic.
  - Improve function 'Material Labeling' and 'Reprint Material Label' item 'Country of Origin' display by System Setting configuration options.
  - Improve current TimeZone City related process.
  - Improve low performance sql ‘query feeder in use’ and related dao function.
  - Improve E85 Board Rework performance for sql server PTSR.
  - Change date code and lot code at material reprinting page.
  - Add option not print physical label(just change data in database).
  - The PTS can support the double feeder with one single feeder barcode
  - Fuji load material and unload material MSD related control.
  - Replace '>' or '<' with '&gt' or '&lt' for only remained a few sql in report json sql configuration xml file.
  - SFDC Assembly PTS ID MSD floor life control and related verification.
  - SFDC Assembly PTS ID- add the option to switch the QTY checking on or off
  Bug Fixes:
  - Correct function 'Add Deviation Note' item 'Due Date' display as Timezone process reason.
  - Solve the bug for RT can not be updated in OWMS-PTS interface.
  - Solve the bug for MSD_Level = 6 in OWMS-PTS interface.
  - Bug fix for parsing 'DB Url toLowerCase()' about System Setting configuration item 'Fuji Profiler
  - 100 percent hand placement bug fix.
  - Change error message locale from server machine default language to English.
  - Upgrade jersey 1.x to 2.x, queryparam and pathparam are both supported in GET method in RESTful service.
  - Function 'Add AML' improvement about ‘Duplicated AML’(current logic is same p/n and same manufacturer, it need be changed to same p/n and same manufacturer and same mpn).
  - Fix function 'Machine Registry' query(main report and auto-complete) related bugs.
  PTS Web Service v 2.1.8.171214 - CR#55452
  Bug Fixes:
  - Fixed WMS material expiration date parse error.
  - Fixed Plant Code Mix when reprinting material label.
  PTS MES-Interface v2.0.8
  Bug Fixes:
  - Fixed the database connection exception issue causing the dm_config table FUJITRAX_BARCODE_LAST_UPDATE field to be empty and the Verifier-PTS label sync job to not work.
  PTS PrintQ v3.0.2
  Bug Fixes:
  - Fixed the multiple plant local timezone issue.
  MES Portal Server
  mes15_portal-device-maintenance-portlet
  Enhancements
  - Mantis#0030177 To add a column to display "Device ID" and change column name "Device" to "Device Code" in device maintenance portlet
  - Mantis#0030914 Move the function of Device Maintenance under Conduit Configuration to Device Maintenance
  - Mantis#0030985 Change the label "Shop Floor ID" to "Name" in Document Control and Device Maintenance
  mes15_portal_mes-portal-db-schema-upgrade
  New Functionality
  - Mantis#0030914 Move the function of Device Maintenance under Conduit Configuration to Device Maintenance
  Enhancements
  - Support AVP
  - Mantis#0030232: mesportal database add two columns "plant" and "community_id" add a field named "part_number" in the table "attr_ext_main" to support AVP function for Local Document
  - Mantis#0028527: Device number can't more than 999
  mes15_sfdc-portlet-1.14.16.170821-1
  Enhancements
  - Mantis#0029439 To support AVP functionality in production scanning portlet
  - Mantis#0029643 To support multi SCRP function for pcb project.
  - Mantis#0030042 To change the display style of production Attributes
  - Mantis#0030534 To support auto login data collector by employee number with character.
  - Consolidate Conduit configuration function to sfdc-portlet
  - Consolidate "Upload by step instruction" option to "Upload by Agile Part Number" option
  - Consolidate "Upload by Local Step Instruction"option to "Upload by Local document" option
  - Mantis#0030942 Change to get conduit token and conduit key from Conduit server configuration info
  - Mantis#0030985 Change the label "Shop Floor ID" to "Name" in Document Control and Device Maintenance
  - Mantis#0031183 Make document step list synchronization in Data Collector and Document
  - Mantis#0031182 Change SSH Logins Maintenance getting Users from "5000" to "50000" in sfdc-portlet
  - Mantis#0031212 To enhance the performance in SFDC command GUI portlet.
  - Mantis#0031297 To support a new sfdc download service instance for the command GUI performance issue.
  - Mantis#0031334 To improve the performance disable the function of checking agile version on every scanning.
  - Mantis#0031336 To upgrade the log4j library to 1.2.17 version.
  - Mantis#0031559 Make eManual UI of 42Q data collector self-adaption when the size of screen changed.
  - JIRA#MSSFC-39 Change the mes-api endpoint (without ending in /conduit) to getting attributes of product in sfdc-portlet.
  - JIRA#MSSFC-38 Change the URL of document according to the network protocol in data collector of sfdc-portlet.
  - "JIRA#MSSFC-34 To enhance the agile synchronization on every scanning in data collector portlet. JIRA#MSSFC-46 Work instruction file name need to support a few of special character
  Bug Fixes
  - SR#3054910 Mapping Agile Document in Cirrus fails to save when "Direct from Agile" is clicked to "Yes"
  - SR#3104879 emanual wipeout documents after scan assembly table
  - SR#3352015 42q Bug Report: e-manual : not stop old procedure document.
  - SR#3173393 The emanual is fail display PDF document
  - SR#2950986 Document Mapping - deviation displaying issue.
  - SR#3136907 Missing horizontal scroll bar on Data Collector page
  - Mantis#0030525 Fix the problem of PDF showing in AVP
  - Mantis#0031273 To fix the date and time convert issue in sfdc portlet.
  - Mantis#0031274 To fix the 'IndexOutOfBoundsException' issue in sfdc portlet on document synchronization from agile.
  Mapping of sfdc-portlet
  Enhancements:
  - Mantis#0031182 Change SSH Logins Maintenance getting Users from "5000" to "50000" in sfdc-portlet
  - Mantis#0031212 To enhance the performance in SFDC command GUI portlet.
  - Mantis#0031297 To support a new sfdc download service instance for the command GUI performance issue.
  - Mantis#0031334 To improve the performance disable the function of checking agile version on every scanning.
  - Mantis#0031336 To upgrade the log4j library to 1.2.17 version.
  - Mantis#0031559 Make eManual UI of 42Q data collector self-adaption when the size of screen changed.
  - JIRA#MSSFC-39 Change the mes-api endpoint(without ending in /conduit) to getting attributes of product in sfdc-portlet.
  - JIRA#MSSFC-38 Change the URL of document according to the network protocol in data collector of sfdc-portlet.
  - JIRA#MSSFC-34 To enhance the agile synchronization on every scanning in data collector portlet.
  - JIRA#MSSFC-46 Work instruction file name need to support a few of special character."
  Alfresco Server mes15_sfdc-agile-service
  Enhancements
  - JIRA#MSSFC-34 To enhance the agile synchronization on every scanning in data collector portlet
  Conduit Client mes15_production-scanning-tomcat
  - Tomcat server for the Production Scanning Client
  mes15_conduit-production-scanning
  New Functionality
  - Work with Conduit commands and interface to do production scanning
  - Mantis#0030882 Get defect code as list of box When add "Record Defect" command
  - Mantis#0031184 Make document step list synchronization in Production Scannin
  Enhancements
  - Mantis#0031000 Change to get authorization info from server info in Production Scanning
  - Mantis#0031040 Design Production Scanning interface with new UI, and support serial batch commands
  - Mantis#0031197 Change the prompt of alert window to "Information" when the content is "Successfully"
  - Mantis#0031230 Change to retrieve SerialNumber information with PartNumber and Revision
  - Mantis#0031198 Fix the issue of Production Scanning about non-serialized batch would be automatically split with quantity 1
  - JIRA#MCSFC-59 Change to get portal database host according to alfresco host.
  Bug Fixes
  - Mantis#0031196 Fix the issue of Production Scanning to display component ID prompt
  - Mantis#0031065 Fix the issue of Production Scanning to get documents information by external network
  - Mantis#0031199 Fix the issue of Production Scanning about user unable to enter repair code to repair a defect"
  - Mantis#0031298 Change to show documents with start page, and support to save with the value of attribute is "NEXT" in Production Scanning
  - JIRA#MCSFC-44 Change to new mes-api interface to get attributes of production.
  - JIRA#MCSFC-47 Change the mes-api endpoint(without ending in /conduit) to getting attributes of product in production-scanning.
  Shop Floor PC
  mes15_sfdc-autosfdc
  Enhancement
  - Mantis#0029445 Remove getuuid.sh function from autosfdcxml because performance issue
  mes15_sfdc-db-schema
  Enhancement
  - Mantis#0029447 Create an index for the upper("serial_number") query in serial table
  mes15_sfdc-sfdc-1.11.12.170811-1
  Enhancements
  - Mantis#0029448 CLRATT command need to support * character to match all attribute(e.g: CLRATT$R$* and CLRATT$R$*|*).
  - Mantis#0029446 ATTADD command should display Recovery Mode rather than Network Problem.
  - Mantis#0029643 To support multi SCRP function for pcb project.
  - Mantis#0029647 To add process name in json response for Cirrus APK."
  - Mantis#0029785 Control of SCRP Operation.
  - Mantis#0030213 The fail record behind the pass record when pass the unit with a repair defect.
  - Mantis#0030879 To disable PCC driver setting by default in sfdcinit.
  - Mantis#0030946 Hide mes db username and password in db.properties.
  - Mantis#0031179 Route assignment of units removed from a batch serial.
  - Mantis#0031278 To fix the tracked component doesn't follow by the option of component status in ADCMP command.
  - JIRA#MSSFC-26 Clear comments in local nodata function.
  - JIRA#MSSFC-28 Replace the dns name with sanmina.com in sfdcconfig.sh file.
  - JIRA#MSSFC-45 B defect on non-serialized batch should match with a normal unit.
  Bug Fixes
  - SR#3057257 P30 MES issue (non-serialized batch quantity lock issue)
  - Mantis#0029449 To fix the attribute data can't be removed twice issue on ATTREMOVE command"
  - SR#3163459 p5546dc1c slowness issue
  - Mantis#0029827 Error message "Invalid Entry" after submitted the batch scrap transaction"
  - SR#3181538 S30-VSY82 status problem
  - SR#3180308 Autojudgment can not fetch data
  - SR#3199267 About KMSI cirrus container qty after removing a serial
  - SR#3208887 E80# !!2QRYLOC hang issue."
  - SR#3230270 Cannot record B defect code in p5546dc1c
  - SR#3233253 About KMSI update the system
  - SR#3231531 upserdef.p failure on p5528dc3.
  - SR#3204601 Unit history as "TRVC062147000-EL-00000007013-1641" missing some process
  - SR#3219604 E52 # Cirrus # SFDC bug# "Create to" action missing for the serial with wrong revision is scanned.
  - SR#3252995 Issue with WO 9068557.
  - SR#3346958 E80-CHENNAI FACING WRONG SCANNING ISSUE.
  - SR#3335897 42Q Bug Report: Local SFDC Command "RPCMP2" reported on 20-Mar-2017.
  - SR#3352015 42q Bug Report: e-manual : not stop old procedure document.
  - SR#3173393 The emanual fail to display PDF document."
  - SR#3455474 ATTREMOVE with batches (on PCBs).
  - Mantis#0030444 e38 sample plan issue.
  mes15_sfdc-webservice
  Enhancements
  - Mantis#0029450 The operator number need to support character on EV function in web service.
  - Mantis#0029439 To support AVP functionality in production scanning portlet.
  - Mantis#0029643 To support multi SCRP function for pcb project.
  - Mantis#0030484 Add interfaces to support AVP and Route Builder
  - Mantis#0031212 To enhance the performance in SFDC command GUI portlet
  - Mantis#0031448 Add two fields to "Attribute" class in sfdc-webservice
  Bug Fixes
  - SR#3099579 Prolonged login MES connection to new server.
  mes15_sfdc-cmd-webservice
  Bug Fixes:
  - Mantis#0031297 To support a new sfdc download service instance for the command GUI performance issue
  MDS Portal Portlets
  mes15_android-device-maintenance
  Bug Fixes:
  - Fixed old version not deleting causing failure.
  mes15_android-maintenance-hook
  Bug Fixes:
  - Fixed empty version displaying in application version portlet.
  mes15_portal_audit-report
  Enhancements:
  - Function and UI improvement
  mes15_mes-migration
  Enhancements:
  - Increaseed import device UI label source shopfloorid width
  - Add/changed UI element Id.
  - Added Android Device.
  - Encrypt username/password in properties file.
  - Validate source host before migrate.
  - Added confirm box before migrate android device.
  - Show detail result after migrate android device.
  Bug Fixes:
  - Fixed Portal data migration user export and import.
  - WR#30098 Exported file should not be locked when execute.
  - WR#30095 Result not refresh after users have been imported into one site successfully.
  - WR#30096 The 'Import' popup box shows incorrect message.
  - Portal data migration phase 1, including user, profile, assignment and device.
  - Portal data migration phase 1, including user, profile, assignment and device (add audit, change role names separator to "," in assignment export/import, remove action-key)
  - Mantis#0030651: Profile not merge and refresh after import.
  - Fixed user badgeid (change from integer to string)
  - Mantis#0030662: Non-LDAP user's Email should not display in User tab of Migration Assistant.
  - Mantis#30757: Migration Assistant portlet's all operable elements need to add 'name' property in HTML.
  - Mantis#30750: Device import has problem.
  - Fixed badgeid export being null.
  - Fixed Wrap error when exporting device
  - Mantis#31173: Android Device Migration pops up blank error prompt.
  mes15_portal_patch
  Bug Fixes:
  - Remove Liferay jdbc.default.maxPoolSize jdbc.default.minPoolSize in portal-ext.properties (default c3p0 maxPoolSize is 100, minPoolSize is 10)
  - Remove Alfresco depedency
  - Fix Liferay OutOfMemory bug , refer to LPS-16621, changed java source code:HotDeployUtil, PortalLifecycle, BasePortalLifecycle, PortalLifecycleUtil, PortalSessionCreator, PortalSessionDestroyer, PortalContextLoaderListener.
  - Remove redundant log like 'No theme found for default theme id ..', changed java source code: ThemeLocalServiceImpl.
  - Fix cas login authentication handler may not pass through next while exception occur
  - Change setenv.sh GC_OPTS (GC_OPTS="-XX:+UseConcMarkSweepGC -XX:+CMSIncrementalMode -XX:LargePageSizeInBytes=128M -XX:+UseFastAccessorMethods -XX: +UseCMSInitiatingOccupancyOnly -XX:CMSInitiatingOccupancyFraction=60")
  - Fix CPU high loading problem(https://issues.liferay.com/browse/LPS-14986), update portal-service.jar
  mes15_portal_plant-maintenance
  Bug Fixes:
  - Added field "Create Date"
  - Mantis#0030454: Add plant operation should be case insensitive
  - Mantis#0030452: Name search in Plant Maintenance should be case insensitive
  - Removed sanminaType option
  - Mantis #0030529 All fields in Plant Maintenance supporting Chinese character become code when try to review and edit them
  mes15_portal_portlet-setting-hook
  Enhancements:
  - Changed company logo from Sanmina to 42Q
  - Added custom field createDate on Organization,Group and Role
  - Added custom field syncDate on Group
  - Changed badgeid type from integer to string
  - Updated check no such group logic
  - Show notifications on docker
  - Removed user expiration check and send mail logic (added in notification-client)
  - Added liferay-plugin-package.xml
  Bug Fixes:
  - Fixed bug when NoSuchGroup error occurs causing custom jsp overwrite failure(missing one jar)
  - Fixed - Portal with no CAS can't lock Non_LDAP user successfully after inputting invalid password for three times.
  - Removed the Non_LDAP user password history function
  - Fixed MPDI-82:Login page with wrong label for username (Screen name)
  - Added Non_LDAP user password history function
  mes15_portal_profile-maintenance
  Enhancements:
  - Added "Change password" by default when creating a new site profile
  - Removed "Configuration" when defining permissions
  - Added new field "created date"
  Bug Fixes:
  - Fixed profile name non case-sensitive bug
  - Mantis#0030282: Profile name in Profile Maintenance should not be case sensitive when adding a site/portal profile
  - Mantis#0030456: Changed name search in Profile Maintenance to not be case senstive
  - Mantis#0030468: Profile names should not include ',' and '+' when adding or editing a portal/site profile
  - Mantis#0030512: Non-LDAP user's Email should not display when try to assign user
  - Mantis#0030531: All fields in Profile Maintenance supporting Chinese characters become code when try to review and edit them
  mes15_portal_server-information
  Enhancements:
  - Enhancement for Cirrus MESR_Database.(add mssql/postgresql options)
  - Enhancement for the Vision project to connect to Cirrus MESR DB
  - Enhancement for Cirrus MESR_Database.(add mssql/postgresql options)
  - Add program MESWeb Execution.
  - Change dbcp datasoure properties, maxActive from 40 to 8, ...
  - Check Agile connection twice.
  - Remove WEB-INF/log4j.propeties, WEB-INF/tld.
  - Add program - Conduit_Client
  - Add program - Conduit
  - Add program - Conduit_ShopFloorID
  - Add program - SIREN
  - MES,CMMS status always active
  - Add program - Vision
  - Add SPC Version function
  - Add Vision version function
  - Server info program name code PTS IIS to Asset Management
  - Program Conduit add two field: Token and Key (need corresponding mes15_portal_mes- portal-db-schema package)
  - Program Conduit context path be unique per site
  Bug Fixes:
  - SR#3105676: Changed the field "agileurllink" to "ip".
  - Fixed inability to save when editing the SFDC / Conduit_ShopFloorID
  - Solved problem where XPath is not unique in Conduit_ShopFloorID server
  - Solved problem where XPath is not unique in cancel button
  mes15_portal_site-maintenance
  Enhancements:
  - Improved Site synchronization performance
  - Added "Last Synchronized" column
  - Added timezone to the "Last Synchronized" field
  - Added new field “created date”
  - Converted "Last synchronized" as syncDate custom field
  - Added three sync skip page friendlyurl(/meas-instance-admin,/meas-config,/measurement-operation)
  - Search user by screenname is no longer case sensitive
  - Improved "search available users" performance
  Bug Fixes:
  - Mantis #29786: Fixed an issue where related site profiles for a deleted site would remain in the database table.
  - Mantis #0030333: Fixed an issue where the Liferay default user displayed as Available Users or Current Users when assigning a user to a site.
  - Mantis #0030530: All fields in Site Maintenance that support Chinese character become code when reviewing and editing them.
  mes15_portal_user-maintenance
  Enhancements:
  - "Change password" behavior changes according to defined profile
  - Non-LDAP user can now search
  - Show user profile may contain incorrect profiles
  - Badge ID changed to string type
  - Removed Oracle Employee ID
  Bug Fixes:
  - Fixed issue causing some non-LDAP to have empty email addresses
  - Mantis#0030511: Non-LDAP user's Email should not display
  mes15_portal_vertical-menu-theme
  Enhancements:
  - Changed site logo to 42Q
  - Changed root menu from Sanmina to 42Q
  - Removed left logo if the user is not signed in
  - Only showing the left logo after the site upload logo file
  - Added support(add some images and css) for notifications
  mes15_portal_notification-client
  Enhancements:
  - Retrieve and show notifications on portal dockbar
  - Check the "user password modified date" and portal "last login date" for possible mail notifications using siren.
  - Added timeout setting for connecting to the siren server
  - Fixed some grammar error in mail/portal message body
  - Improved Mark All Read
  - Clear Liferay cache periodically during the notification check
  Bug Fixes:
  - Fixed login date check bug
  - Fixed library dependency
  - Fixed read siren properties bug (Change default siren host, clientId, and secret. These properties are environment associated and always need to change before being deployed)
  SPC
  mes15_quality_spc-server- 1.2.4.170317-1
  Enhancement:
  - Changed collect data and monitor data strategy
  - Improved performance for sendemail
  mes15_quality_spcdbconfig-1.2.2.170123-1
  New Functionality:
  - Added the commands "backupconfig" and "upgradeall" in SpcupgradeTool.java
  spcServerRefLib-1.0- 1.i386 - Initial Version
  
  January 2018
  
  CR# - 55551
  Overview: Android App Fixes and Enhancements
  Environment: Android Applications
  PSI_2.15.apk
  Bug Fixes:
  - SR#3589897: "Back" button is missing
  InPlanTravelerViewer-42Q _2.01.apk
  Enhancements
  - Editing the InPlan URL is now password controlled
  MESWeb-Viewer_1.01.apk
  Enhancements
  - Plant's Field IT can now configure MESWeb link or approved URL.
  - Adding and modifying the MESWeb link is now password controlle.d
  - Able to click and access URL to avoid entering it every time.
  - Disabled embedded zoom in and out plugin of Android platform.
  - Added ability to click/slide the bottom right of the screen to zoom in and out.
  MES15_MESWeb.4.2.15
  New Functionality
  - Custom log class to add application name in the logs.
  Enhancements
  - Changed activity_date to dtmh_slq fields and condition in query used to display date time for yield evolution report.
  Bug Fixes
  - Log4j logs format.
  - Date time format for DateTime parameter on the client.
  - Selected timeframe validation.
  November 2017
  
  CR# 55008 - Version [MES 15.4]
  Overview: Full Non Medical Upgrade
  Environments: corpmesprtl3 and HA Environments
  mes15_sfdc-portlet-1.14.18.171122-1
  Enhancement:
  - JIRA #MCSFC-119 Add a new interface in sfdc portlet to query timezone based on shop floor id for PCB.
  - JIRA #MCSFC-106 To Enable sequence modification in document mapping for step work instruction.
  LE 2.2.0
  Enhancements
  - [LE-111] - Remove "Label Request Tool" from portlets menu
  LE Web Service 2.01.20170628
  Bug Fixes:
  - [LE-109] - Apply changes on OSCommand method to retry SOffice command calls if it fails
    (RTF)
  MDS Labels
  Enhancements:
  - [LE-120] - Remove "Label Request" and "User Guide" from portlet menu
  MDS-API Web Server 2.06.00.20170104
  Bug Fixes:
  - [LE-148] - Connection Leak fixes for MDS-API
  MES15-Sanm.MESWeb.LineMonitor.WS-2.1.0
  Enhancements:
  - Branded as 42Q.
  - Datasource parameter added for retrieving a list of projects.
  - Data connection pool for getting the sources according the executed application.
  - Date Format parameter, including: YYYY-MM-DD and DD-MMM-YYYY options.
  - Gear Icon added into header lineMonitor index.html, includes: Reset and Setup options (Reset has same functionality as Line value in header).
  - Date and time in header must match with executed application.
  - Secondary header between header and charts, helps to indicate actual row (by item, workstation, Part Number and Yield/HR).
  - Item value added to every row in DataTable (in the server is index for Workstation objects).
  - Share link.
  - Added suffix “MES_XX” to every project retrieved from datasource parameter.
  - Sort on datasource parameter.
  - New Template for parameters required working in several resolutions
  - Refresh Rate parameter changed from seconds to minutes when retrieving information from server.
  - Highlight header changed from being radio button to be a checkbox (true or false).
  - Hide WIP Lines parameter changed from being radio button to be a checkbox (true or false).
  - Yield/HR percentage must be fixedTo 0 when it is 100 percent, else it must be fixedTo(2) (i.e.
  - 100% and 98.45%).
  - PieChart that indicates top 5 defects now is named Top Defects.
  - PieChart has been replaced by horizontalChart.
  - Chart titles have been aligned to middle of every chart.
  - Yield Trend Chart shows a fill under its range.
  - Item value instead of workstation-part number as indicator in Yield Chart
  - Case (Upper and Lower) for every label has been matched.
  - Sort of items in Data table is Ascending, these sort comes from the server with their respective index.
  - Just Mesr type Datasources are shown in Datasource parameter (setup.html).
  - Highlight does not increase the size of the font in current row, just changes the background of the row.
  - TargetYield changed to green color.
  Bug Fixes:
  - Circle indicator started in green color, now starts with yellow.
  - Yield Trend Chart shows 8Hrs every time.
  - TH/HR in header now indicates the SUM of TP for every Workstation indicated in DataTable.
  Mes15_Sanm.MESWeb.Central.View
  Enhancements:
  - Improved “loading” logo with 42Q gift.
  Bug Fixes:
  - Avoid publishing reports when a parameter is empty.
  - Avoid creating more than one drilldown per column.
  - Avoid duplicating sqlName in parameters.
  - Be able to save reports after fill out all the tabs.
  - New organization on Reports screen.
  - Private checkbox is working.
  - Avoid duplicating Data Source name by application.
  - Show the Connection String without user and password.
  - Show messages of success and fail.
  - Be able to delete more than one record at the same time.
  - Focus in the first element of the screen.
  - Be able to export data.
  - Avoid duplicating Locations.
  - Default reports and group of reports will be added when a user creates a new location.
  - Show messages of success and fail.
  - Be able to delete more than one record at the same time.
  - Focus in the first element of the screen.
  - Be able to export data.
  - Avoid duplicating Report Group name by application.
  - Show messages of success and fail.
  - Be able to delete more than one record at the same time.
  - Focus in the first element of the screen.
  - Be able to export data.
  - Avoid duplicating User Group name by application.
  - Show messages of success and fail.
  - Be able to delete more than one record at the same time.
  - Focus in the first element of the screen.
  - Be able to export data.
  Enhancements:
  - New logo for 42q when the page loads.
  - New icons in the menu.
  - Hide submenu after select one option.
  - Report Parameters: be able to select all option (*) and add a filter.
  MES15_Sanm.MESWeb.Central.View-1.5.161017-1
  Bug Fixes:
  - Fixed an issue when trying to add customer permissions to a user group.
  - Fixed an issue where all data sources by location where shown in the customer's section at permission windows (By user and group). Now it only shows mesr data sources.
  - Fixing an issue with SQL Server connections. BounceCastle was causing the issue, it has to be removed before establishing the connection.
  MES15_MESWeb.4.2.6
  New Features:
  - Method to create missing folders for temporary files.
  - Connection pool to archive database.
  - Connection pool to central database.
  - Connection pool to mesr databases.
  - Method to create missing folders for temporary files.
  - Ship notify action added to Unit History report.
  - MySQL database support.
  - Comma delimiter option available in scheduler when selecting txt file.
  - Unit History displays archived units (Only from the new archive model).
  - Oracle databases Support.
  - Export to Google drive.
  - Default export configuration by user.
  Enhancements:
  - SOMS reports are getting data from schema Mesr instead of schema SOMS.
  - Date time calculation on SOMS reports was change to get data from last 60 minutes.
  - Improved WIP serial and RTY reports performance.
  - Log4j properties to apply Logging standard.
  - Cleaned Logger declaration in classes.
  Bug Fixes:
  - Next run time zone for Schedules.
  - Customer prefix list.
  - Set timezone for postgres connections using pool connection.
  - Next run time zone for Schedules.
  - Customer prefix list.
  - Set timezone for postgres connections using pool connection.
  - Defect description, repair_code and defect_description are now displayed on unit history.
  - Attribute name and value are now displayed on unit history.
  - Overlap on shop order report when exporting to excel.
  - Chart grouping for yield evolution.
  - WIP column calculation on SOMS reports in showing the units currently in that location.
  - External dependency removed and included in MESWeb package.
  - New relic dependencies removed.
  MDS SCHEMA CHANGES
  revision 48
  ● add serdef.repair_activity_key index
  revision 49
  ● add wip_movement.serial_key index
  revision 50
  ● add supply_subinventory, supply_locator to bom_item table
  revision 51
  ● add serial_ship table
  ● add ship_ts to ship_notify table, not updating ts in existing records.
  revision 52
  ● add activity_employee_key_idx index
  revision 53
  ● add 2 new types for client team
  revision 54
  ● upper index on employee.employee_number for upemplog delays
  revision 55,56
  ● add primary key to catalog table
  revision 57
  ● add wip_movement_activity_key index
  revision 58
  ● new double_generic_udt type
  revision 59
  ● unique indexes for sample_master.name, sample_plan.name
  revision 60
  ● new shop_order_op_resource table
  revision 61
  ● add an upper index on attribute.attr_data
  
  MESR SCHEMA CHANGES
  Revision 28
  ● add supply_subinventory, supply_locator to bom_item table
  Revision 29
  ● add serial_ship table
  ● add ship_ts to ship_notify table
  Revision 30
  ● add upper_shop_order_number_idx on shop_order
  Revision 31
  
  ● add catalog table to allow replication from mds
  Revision 32
  ● create additional indexes on serial table
  Revision 33
  ● drop some constraints and add primary key to soms_target_def table
  
  SFDC Core Command Changes
  autorfc
  ● SR 3286377 - fix log statement errors preventing from doing anything
  downattrdef
  ● SR 3258919 - removed update on temp table, was a performance issue
  downserialbyso2
  ● SR 3342753 - change to send serials ordered by serial number
  getcmd
  ● SR3302804 Use sfdc_command_key to order the extraction of next sfdc_command
  record to be sent to sfdc.
  getempval
  ● SR3390673- Added "group by" to get rid of duplicate output records
  ● SR3298776- Add grace_days to expiration_date and send 0 for grace days.
  newsampplan
  ● SR 3369643 - check for empty or duplicate plan name
  upact/upactser
  ● SR 3200956 - changes for sbatch wip moves
  NS batch action 22, wipmoves
  upsamplog/upsampplan
  ● SR 3281143 - bug fix - allow to complete if foreign key violation
  as client allows records to be deleted.
  upserdef
  ● SR 3065774 - if cannot find serial with part, find by serial alone.
  create defect code as upper if not found as upper, look for repair code as upper
  
  SFDC Custom Command Changes
  add2nextso
  ● SR3244354 - wrong serial key used in add to shop order activity
  add2so1, add2so2
  ● SR3050794 - coalesce to avoid null data errors
  boxgenz, boxgenztest, boxlabeng
  ● SR3357445 - display error if cntnr qty does not match serials assigned
  chgso
  ● SR3050794 - coalesce to avoid null data errors, now sending qty on initial prompt
  chgso3
  ● SR3050794, SR3377516 - coalesce to avoid null data errors, use dummy serial on old
  SO if status 15/28
  ● SR 3419480 - Exit loop on first serial found, set date/time on dummy and leave as
  unit_type -1
  chkfail3
  ● SR3025997 - new conversion from legacy
  clockin/clockout
  ● SWI1004896 - Update from department to code_name
  cre8comp
  ● SR3226386 - performance enhancement, updated component query to use upper
  indexes
  cre8mac2 / cre8mac3 (putalgorithmonhold api)
  ● SR3287404 - corrected issue with locking to prevent simultaneous execution
  chgid60
  ● SR3154572, SR3355214 - bug fix to look for serial without part, use upper on a search,
  change prefix prompting decision to be like legacy
  chkprocfailq
  ● SR3400324 - fixed bug which had prevented use
  densorepnotapproved
  ● SR3448984 - Updated trigrec loop query for efficiency.
  dumpcntnr4/dumpcntnr5
  
  ● SR3043320 - allows unit_type of 100 to 109, required by E55, deployed for them
  dupchksn
  ● SR3389767 - add check of existing serial in catalog table
  matchcompid
  ● Jira MBWD-18 - new conversion to Postgresql
  moveifattdata
  ● SR3037717 - bugfix - use sfdc_key to find location when ambiguous
  moveifnoref
  ● SR3030366 - New conversion from legacy
  notify
  ● Planview SWI: 1003023 - enhancement to add Shop Order and Employee to notification
  sc3lcd
  ● Jira MBWD-51 - new conversion to Postgresql
  showatt
  ● SR3091190 - upper search on attr_name
  showcomment
  ● removed extra blank line on return
  tsidcomp (custom e90 hybrid)
  ● SR3326089 - bug fix - do not send RLSE if unit already has a component
  vercmpproc
  ● Planview SWI:1004505 - new custom for e73 medical, probably specific to them.
  xfersnarchive
  ● SR3140999 - updated to restore immediately when requested.
  alg_engine
  ● SR3298098 - Prevent late reset in the algorithms
  getActivityActionData, getActivityActionDescription
  ● Support action code 88 (Ship Notify) in unit_history view
  get_config_data
  ● WR 203511- Prevent failure in getting the data from config file
  get_empnum_shift_machine
  ● SR 3473962 -- for p27 only, remove search for machine # attribute on parent serial, if not
  found with first search.
  get_route_steps
  ● http://phabricator.sanmina.com/T1504 - MDS-API 2.06.00.20170104
  get_step_details
  ● http://phabricator.sanmina.com/T1504 - MDS-API 2.06.00.20170104
  get_wip_moves1
  ● CR52359 - support added to decrease run frequency for a db so it doesn't run everytime
  cron entry runs wip move
  ● Jira MBWD-74 -- configurable limit in gen_attribute to wip moves sent to ERP
  movesntonextso
  ● SR3185778 - bug fixes: adjust shop order unreleased qty only if consumed a dummy,
  set location key = 0 instead of null for serials updated
  nextgen_online_call
  ● On qty decrease don't adjust shop order qty to be real qty
  remove_stat64_serials
  ● Used by nextgen_online_call, bug with shop_order query variable name
  rollout
  ● SR3026440 - Prevent replace current development label
  ship_notify_serial
  ● Add ship notify key to serial for any status, add ship activity and add entry to new table
  serial_ship
  cirrusstreamio.so and streamio.sql
  ● NEW method of writing to files; used by new xfersnarchive/legacy_archive code
  and librelot.
  cirruspsqlFuncs.sql
  ● Added db name to logging, fixed handling of versions on log files
  
  MES Applications
  
  Algorithm Tool
  - Fixes MCT-13 (JIRA) - Resource leak fixings
  - Bundles Changes
  Audit report
  - Fixes MCT-8 (JIRA) - Resource leak fixings
  - Bundles Changes
  Configuration Publish
  - Fixes MCT-25 (JIRA)
  - Fixes T672 - Change Configuration Publish Labels
  - Bundles Changes
  Employee Validation Maintenance
  - Fixes MCT-18 (JIRA) - Resource leak fixings (MDS-90634, MDS-90635)
  - Fixes MCT-28 (JIRA) - Last Name information is exporting from main grid
  - Fixes MCT-41 (JIRA) - Class' Employee paging when adding/removing employee and groups.
  - Feature MCT-42 (JIRA) Applying filter on class' employee treepanel.
  - Fixes T1381 - Performance Issue when have too many records on Add window
  - Fixes T1765 - Not able to assign operators to a class with a lots of operators already.
  - Fixes T1907 - Users can not search fuzzily in EV
  - Fixes MCT-69 - Issue on delete employee accounts on portal
  Employee Validation Process Control
  - Fixes MCT-17 (JIRA) - Resource leak fixings
  - Fixes T1381 - Performance Issue when have too many records on Add window.
  Generic Attribute
  - Fixes MCT-9 (JIRA) - Resource leak fixings.
  Kit Verify - Configuration 2.3.2
  Enhancement:
  JIRA # MCT-49: Update the custom message in all the portlets with 2 icons (pin and close).
  - Close icon will close the message.
  - Pin icon will pause the message.
  - Play icon will continue showing the message.
  Kit Verify - Production
  mes15_kv-production-2.10.4.2.171011-1.i686.rpm
  - MCT-136 - KV Production -> Kit Consolidation -> Partial Save issue (MDS-90726 )
  - MCT-67 - E35 Enhancements - Complete Transaction / QC Check
  - MDS-90675:Complete Transaction (Warning Duplication Transaction - E35)
  - MDS-90677:Complete Transaction (Report Missing ATO Code - E35)
  - MDS-90692:Consolidate a Top Level Assembly - QC Checkpoint - Sales Order Not found
    - MDS-90693:Consolidate a Top Level Assembly - QC Checkpoint Fail
    - MDS-90694:Consolidate a Top Level Assembly - QC Checkpoint Fail
    - MDS-90694:Consolidate a Top Level Assembly - QC Checkpoint - Pass
    - MDS-90695:Consolidate a Top Level Assembly - Bypass QC Chekpoint
  Labor Tracking
  - Fixes MCT-16 (JIRA) - Resource leak fixings (MDS-90512, MDS-90576) - Test Report
  - Fixes T1686 - Making the Department field optional and setting (N/A) when updating/adding a record.
  Multi-Level Containerization Configuration
  - Fixes MCT-14 (JIRA) - Resource leak fixings
  - Fixes MCT-131 (JIRA) - Part Number Combobox not filtering.
  Multi-Level Containerization Maintenance
  - MCT-138 - Bug Fixing -> Add/Remove Twice same element -> Duplicating Activity
    - MDS-90727:Containerize - Remove Twice the same element (Duplication Activity Test)
    - MDS-90728:Containerize - Remove Non-Serialized Element after saved (without reload container/screen)
    - MDS-90729:Containerize - Remove Twice the same element already saved. (Duplication Action)
  - MCT-67 - E35 Enhancements - Complete Transaction / QC Check
    - MDS-90683:Complete Transaction - QC Checkpoint Failed
    - MDS-90684:Complete Transaction - QC Checkpoint Pass
    - MDS-90685:Complete Transaction - Sales Order Not found
    - MDS-90686:Complete Transaction - Force Skip Check Point
    - MDS-90687:Bypass QC Checkpoint and Complete Transaction
  Quality Batch Release
  - Fixes MCT-37 (JIRA) - Resource leak fixings (MDS-90661) - Test Report
  Serialized Item Tracker
  - Fixes MCT-22 (JIRA) - Resource leak fixings (MDS-90659, MDS-90657) - Test Report
  - Fixes MCT-91 (JIRA) - Receive SIT Range not support big range of serials and attributes
    - MDS-90682:SIT -> Edit Standard (Add dozens of attributes)
    - MDS-90681:SIT -> Receive -> Manually Entered (Huge Quantity)
  SFDC Configuration
  - Fixes MCT-12 (JIRA) - Resource leak fixings.
  - Fixes MCT-40 - Pagination needed on Attribute Name List
  - Fixes MCT-43 - Fixing the Attribute Definition grid paging.
  - Fixes MCT-44 - Part x Route Assignment Grid Paging issue
  - Fixes T1707 - SFDC Configuration -> Assembly -> Add new Component Type
  - Fixes T1885 - SFDC - Attribute Def -> Some functionalities are not working properly
  - Fixes T1887 - SFDC - Assembly -> The copy functionality is not working
  - Fixes T1894 - SFC - MFG Hold -> Returning error message when the email was not sent
  - Increase defect code description to 250.
  - Fixes: MCT-113 - MFG Hold View -> Bundle is Missing on Title
  - Fixes MCT-46 - Attribute Def. - Clone an attribute name and keep steps references
  Shop Order
  - MCT-67 - E35 Enhancements - Complete Transaction / QC Check
    - MDS-90688:Bom Information - QC Checkpoint - Pass
    - MDS-90689:Bom Information - QC Checkpoint - Sales Order not found
    - MDS-90690:Bom Information - QC Checkpoint - Fail
    - MDS-90691:Sales Order - QC Checkpoint - Fail
  - MCT-68 - Print Labels Improvements
    - MDS-90730:Shop Order Release - Print Labels by SN Range
    - MDS-90673:Shop Order Release - Print Labels (All Available Units) Range
  - MCT-63 - Flexible way to add new fields on Shop Order Information (OEE) - Display Resource
  - MDS-90732:Shop Order Browser - Display Resources (OEE) for ERP
  SQC
  - Fixes MCT-23 (JIRA) - Resource leak fixings.
  - Escaping Part Number and Process values so they can contain commas in csv file for importing.
  Target Maintenance
  - Fixes MCT-24 (JIRA) - Resource leak fixings.
  Siren Configuration and Operation
  - Fixes MCT-10/11 (JIRA) - Resource leak fixings.
  - T1566 - Translations for Chinese and Portuguese.
  - T1743 - Sending the Request to the service layer in order to use the database information through Server Information
  - Fixing the buttons order regarding Save and Reset.
  - Fixes MCT-45 - Add a prefix in the json string stored in event_data
  MES Portlets
  
  Mes15_portal_android-maintenance-hook-1.12.36.170811-1
  Bug Fixes:
  - Fix show empty version in application version portlet
  Mes15_portal_audit-report-1.12.40.171012-1
  Enhancements:
  - Search function and UI improvement
  - Improve query performance
  Bug Fixes:
  - [JIRA] (MP-22) Audit-report-portlet page shows blank some time because of no
    timeout is set
  Mes15_portal_plant-maintenance-1.12.40.171009-1
  New Functionality:
  - Add field "Create Date"
  Enhancements:
  - Remove sanminaType option
  Bug Fixes:
  - Mantis #0030529 All fields in Plant Maintenance supporting Chinese character become code when try to review and edit them
  - JIRA MP-21 Fix portal counter sequence issue
  - Mantis#0030454: Add plant operation should be case insensitive
  - Mantis#0030452: Name search in Plant Maintenance should be case insensitive
  Mes15_portal_portlet-setting-hook-1.12.37.170810-1
  New Functionality:
  - Add custom field createDate on Organization,Group and Role
  - Add custom field syncDate on Group
  - Change badgeid type from integer to string
  - Show notification on docker
  - Add Non_LDAP user password history function
  Enhancements:
  - Change company logo from Sanmina to 42Q
  - Update check no such group logic
  - Remove user expiration check and send mail logic (added in notification-client)
  - Add liferay-plugin-package.xml
  - Remove Non_LDAP user password history function
  Bug Fixes:
  - Fix bug when NoSuchGroup error occurs may cause custom jsp overwrite failure(missing
    one jar)
  - Fix issues: Portal with no CAS can't lock Non_LDAP user successfully after inputting invalid password for three times.
  - Fix MPDI-82:Login page with wrong label for username (Screen name)
  Mes15_portal_profile-maintenance-1.12.38.170829-1
  New Functionality:
  - Add "Change password" by default when create new site profile.
  Enhancements:
  - Remove "Configuration" when define permission
  - Profile add new field "created date"
  Bug Fixes:
  - Fix profile name non case-sensitive bug
  - Mantis#0030282: Profile name in Profile Maintenance should be case insensitive when add a site/portal profile.
  - Mantis#0030456: Name search in Profile Maintenance should be case insensitive
  - Mantis#0030468: Profile name should not include ',' and '+' when add or edit portal/site profile
  - Mantis#0030512: Non-LDAP user's Email should not display when try to assign user
  - Mantis#0030531: All fields in Profile Maintenance supporting Chinese character become code when try to review and edit them
  Mes15_portal_server-information-hook-1.12.40.170927-1
  Bug Fixes:
  - JIRA MP-21 Portal counter sequence issue in p88prtl1, corpmespr tl3
  Mes15_portal_server-information-1.12.40.171011-1
  New Functionality:
  - Add program MESWeb Execution.
  - Add program Conduit_Client
  - Add program Conduit
  - Add program Conduit_ShopFloorID
  - Add program SIREN
  - Add SPC Version Function
  - Add vision version function
  Enhancements:
  - Enhancement for Cirrus MESR_Database.(add mssql/postgresql options)
  - Enhancement for the Vision project to connect to Cirrus MESR DB
  - Enhancement for Cirrus MESR_Database.(add mssql/postgresql options)
  - Change dbcp datasoure properties, maxActive from 40 to 8, …
  - Check Agile connection twice.
  - Remove WEB-INF/log4j.propeties, WEB-INF/tld.
  - Server info program name code PTS IIS to Asset Management
  - Program Conduit add two field: Token and Key (need corresponding mes15_portal_mes- portal-db-schema package)
  - Program Conduit context path be unique per site
  Bug Fixes:
  - SR#3105676: change field agileurllink to ip.
  - mes,cmms status always active
  - Fix Can't save when edit SFDC / Conduit_ShopFloorID
  - Solve problem that XPath is not unique in Conduit_ShopFloorID server
  - Solve problem that XPath is not unique in cancel button
  - JIRA MP-21 Fix portal counter sequence issue
  Mes15_portal_site-maintenance-1.12.40.170930-1
  New Functionality:
  - Add last synchronized column in site maintenance.
  - Add new field “created date”
  - Add three sync skip page friendly url (/meas-instance-admin,/meas-config,/measurement-operation)
  Enhancements:
  - Site maintenance synchronize site performance improvement.
  - On Site maintenance portlet, Last synchronized field add timezone.
  - Convert "Last synchronized" as syncDate custom field
  - Search user by screenname change to case-insensitive
  - Improve search available users performance
  Bug Fixes:
  - Mantis#29786 In site maintenance when delete a site, it's related site profiles is still in database table.
  - Mantis #0030333: Liferay default user should not list in Available Users or Current Users when try to assign user in Site
  - Mantis #0030530: All fields in Site Maintenance supporting Chinese character become code when try to review and edit them
  - JIRA MP-21 Fix portal counter sequence issue
  Mes15_portal_user-maintenance-1.12.28.170216-1
  Enhancements:
  - "Change password" behavior changes according to defined profile
  - User maintenance Non-LDAP user should can search
  - User maintenance show user profile may contain incorrect profiles
  - Badge ID change to string type
  - Remove Oracle Employee ID
  Bug Fixes:
  - Fix some non-ldap user show empty email address
  - Mantis#0030511: Non-LDAP user's Email should not display
  Mes15_portal_vertical-menu-theme-1.12.36.170822-1
  Enhancements:
  - Change site logo to 42Q
  - Change root menu Sanmina to 42Q
  - Remove left logo if user not signed in.
  - Only show the left logo after site upload logo file
  - Add support(add some images and css) for notification
  Mes15_portal_notification-client-1.12.36.170728-1
  New Functionality:
  - Retrieve and show notification on portal dockbar
  - Check user password modifidate and portal last login date for possible mail notification using siren.
  Enhancement:
  - Add timeout setting for connect to siren server
  - Improve mark all read
  - Add clear Liferay cache in notification check periodically
  Bug Fixes:
  - Fix some grammar error in mail/portal message body
  - Fix login date check bug
  - Fix library dependency
  - Fix read siren properties bug (change default siren host, clientId and secret, these properties are environment associated, always need to change before deploy)
  CMMS Portlet 1.0.1
  New Functionality:
  - Add the new Asset Calibration Info Report
  - Add the Downtime Resolution Cycle Time Report
  - Calibration automatically send e-mail
  - Escalation for the PM & Calibration
  Enhancements:
  - Get rid of the add user function and retrieve the user data from the portal.
  - Add the asset name as the condition for the WO Order List Report & Equipment Downtime report
  - Add the PM Plan Date at the Work Order Edit Form
  - Add the fuzzy query for the asset portlet
  - PM: add escalation rescheduled email group and escalation rescheduled email before days,by setting
  these two attribute values auto send email to correlation group.
  - Add the checklist data at the PM Plan & Reschedule Report
  - Performance enhancement for the Update Downtime Report.
  - Optimize the checklist operation
  - Enhance the downtime trend analysis report for more detail information
  - Enhance the Downtime Problem Analysis report for more detail information
  - Enhance the HTTPS support
  - Enhance the CMMS Work Order Dashboard performance and add the PM detail status information.
  - Add the new web service to return the CMMS machine status Note: it need to work with the CMMS
  - db schema v1.0.0 or above.
  CMMS Web Service v1.0.1
  New Functionality:
  - Add the new Asset Calibration Info Report
  - PM: add escalation rescheduled email group and escalation rescheduled email before days,by setting these two attribute values auto send email to correlation group.
  - Add the Downtime Resolution Cycle Time Report
  - Calibration automatically send e-mail
  - Escalation for the PM & Calibration
  - Add the new web service to return the CMMS machine status
  Enhancements:
  - Get rid of the add user function and retrieve the user data from the portal.
  - Add the asset name as the condition for the WO Order List Report & Equipment Downtime report
  - Add the PM Plan Date at the Work Order Edit Form
  - Add the checklist data at the PM Plan & Reschedule Report
  - Performance enhancement for the Update Downtime Report.
  - Optimize the checklist operation
  - Enhance the downtime trend analysis report for more detail information
  - Enhance the Downtime Problem Analysis report for more detail information
  - Enhance the HTTPS support
  - Enhance the CMMS Work Order Dashboard performance and add the PM detail status information.
  Bug Fixes:
  - Fixed the Work Order Assign To Me issue
  - Fixed the Part Details Report loading issue
  - The dashboard wo status drop-down menu does not work
  - Import Checklist – Site Drop-down menu does not work
  - The Add Cycle Count Submit Button doesn't work
  - The e-mail escalation issue for the PM, Calibration & Repair.
  - Import Calibration - Can not open csv file in windows
  - Import Asset - Can not open csv file in windows
  - Asset - In Calibration next calibration date error, timezone issue found by E26
  - All module - Timezone issue of diffrent browser version and different timezone - found by Tamas
  - Add the Waiting for Approval status at the Work Request.
  - Fixed the Dashboard Work Order Creation project drop-down menu issue.
  - Fixed the Calibration manual send e-mail issue
  NOTE: Requires CMMS db schema v1.0.0 or above.
  
  MES-Fuji Portlet v2.0.3
  New Functionality:
  - Panelization: create panel and board bonding records and share it with other workstations/systems
  - Support MSD control: Integrate PTS MSD control with Fuji host interface
  Enhancements:
  - Skip board(scrapped board) whil auto create S/N
  - Add clear modules function in PTS-FUJI line mapping
  - User can edit FUJI line & machine name in edit function of production line settings
  NOTE: Requires MES-Fuji db schema v2.0.1 or above.
  
  MES-Fuji Web Service v2.0.2
  New Functionality:
  - Panelization: create panel and board bonding records and share it with other workstations/systems
  - Support MSD control: Integrate PTS MSD control with Fuji host interface
  Enhancements:
  - Skip board(scrapped board) whil auto create S/N
  - Add clear modules function in PTS-FUJI line mapping
  - User can edit FUJI line & machine name in edit function of production line settings
  NOTE: Requires MES-Fuji db schema v2.0.1 or above.
  
  Mes15_pts-portlet-1.3.3
  New Functionality:
  - Reset Material Quantity(Zero Offset).
  - Implement and improve 'Traceability for Programmed IC' function and 'Indirect Material' function.
  - Supply function 'Location Mapping Report'.
  - Printer control through GUI.
  Enhancements:
  - PTS Rework and Fuji Rework function integration(one UI support replace component either tracked by PTS or Fujitrax).
  - Change ‘Accept Property’ item from current read-only to selectable for current ‘Reprint Material Label’ function page.
  - 'Lot Code Required' and 'Date Code Required' switch control for function 'Material Labelling'.
  - The 'Reprint Label' function 'Inspection Date' item editable permission control.
  - Change date code and lot code at material reprinting page.
  - Add option not print physical label(just change data in database).
  - Change feeder type list display auto-complete char size from 4 to 1 and order by len(name). Add feeder
  - type full name match query.
  - Multi-language support for touch pages.
  - Improve function 'Material Labelling' item Pb-Free Category display logic (change to base on
  - manufacturer info pb_category value).
  - Improve function 'Material Labeling' and 'Reprint Material Label' item 'Country of Origin' display by
  - System Setting configuration options
  Bug Fixes:
  - 100 percent hand placement bug fix.
  - Fix function 'Machine Registry' query(main report and auto-complete) related bugs.
  - Change function 'Reprint Material Label' item 'Current Quantity' max value from current current_qty
  - value to total_qty value if System Setting switch 'Material Label Quantity Control' value is 'Yes'.
  NOTE: Requires PTS DB schema v3.57 or above.
  PTS Web Service v2.1.9
  New Functionality:
  - Implement scanning board by workstation name web service interface.
  - Supply function 'Location Mapping Report'.
  - Printer control through GUI.
  - Implement and improve 'Traceability for Programmed IC' function and 'Indirect Material' function.
  - Reset Material Quantity(Zero Offset).
  - Add the new web service method to support scan board by PTS workstation without location mapping.
  NOTE: Requires PTS DB schema v3.56
  Enhancements:
  - Add a System Setting switch to process 'msd control or not for materials on board'.
  - Implement loading material aml validation about 'OBS-MPN' logic (including fuji verification).
  - Improve function 'Material Labelling' item Pb-Free Category display logic.
  - Improve function 'Material Labeling' and 'Reprint Material Label' item 'Country of Origin' display by System Setting configuration options.
  - Improve current TimeZone City related process.
  - Improve low performance sql ‘query feeder in use’ and related dao function.
  - Improve E85 Board Rework performance for sql server PTSR.
  - Change date code and lot code at material reprinting page.
  - Add option not print physical label(just change data in database).
  - The PTS can support the double feeder with one single feeder barcode
  - Fuji load material and unload material MSD related control.
  - Replace '>' or '<' with '&gt' or '&lt' for only remained a few sql in report json sql configuration xml file.
  - SFDC Assembly PTS ID MSD floor life control and related verification.
  - SFDC Assembly PTS ID- add the option to switch the QTY checking on or off
  Bug Fixes:
  - Correct function 'Add Deviation Note' item 'Due Date' display as Timezone process reason.
  - Solve the bug for RT can not be updated in OWMS-PTS interface.
  - Solve the bug for MSD_Level = 6 in OWMS-PTS interface.
  - Bug fix for parsing 'DB Url toLowerCase()' about System Setting configuration item 'Fuji Profiler
  - 100 percent hand placement bug fix.
  - Change error message locale from server machine default language to English.
  - Upgrade jersey 1.x to 2.x, queryparam and pathparam are both supported in GET method in RESTful service.
  - Function 'Add AML' improvement about ‘Duplicated AML’(current logic is same p/n
  - and same manufacturer, it need be changed to same p/n and same manufacturer and same mpn).
  - Fix function 'Machine Registry' query(main report and auto-complete) related bugs.
  PTS MES-Interface v2.0.9
  Enhancements:
  - MES-Interface log content optimization.
  - MES-Interface unit cases addition.
  - MES-Interface work order sync performance improvement.
  Bug Fixes:
  - Fix the database connection exception issue and it will cause the dm_config table
    FUJITRAX_BARCODE_LAST_UPDATE field empty and the Verifier-PTS label sync job won’t work.
  - Improve to not write the DiD to table t_dry if the part number of the DID in fuji DB t_pbar table is null
  - Improve to set table t_pbar field pbardrytyp and field pbarmslvl as null when msd_level = 'N/A' or msd_level = '-' or msd_level = ‘1’ in fuji DB.
  PTS PrintQ v3.0.3
  New Functionality:
  - Implement and improve 'Traceability for Programmed IC' function and 'Indirect Material' function.
  Bug Fixes:
  - Fixed the multiple plant local timezone issue. This version need to work with the PTS DB schema v3.54.
  PTS PPC v4.0.2
  Enhancements:
  - E80 plant PPC resolution display improvement(fit different resolution).
  - PPC load material UI display issue improvement(currently after user input 'new feeder' item cursor focus on 'old feeder' item, requirement is that after user input 'new feeder' item cursor focus on 'station' item).
  MES API
  New Functionality:
  - Adding measurement resource
  Bug Fixes:
  - Prevent Resource Leak
  42Q Live — MES15_42q-monocle-Monitor-1.0.0.171013-1
  Overview:
  This version offers a new look and feel while offering similar functionality. Admins can upload their layout image and convert the image to match 42Q scheme, or keep the original color design. Escalation emails can be managed for critical lines, while also allowing admins to change to Acknowledge status.
  
  New Functionality:
  - Accessible via Portal.
  - Option to transform Image map when uploading.
  - Status information cards visible all the time.
  - 2 Themes available.
  - Map image preview.
  Enhancements:
  - Branded as 42Q.
  - A monitor with a new look and feel.
  - 2 Levels of additional information by Mfg line.
  - Login is required.
  Operation Dashboard - MES15_Sanm.MSD.View.2.0.7.101117
  Operation Dashboard condenses 9 statistical reports from MESWeb into graphical charts that can be accessed remotely from Android tablets, in the portal, or screens on the Shop Floor. The Dashboard displays charts based on Yield, Throughput, and Cycle Time. These charts can also display configurable Top Reports based on Yield Process, Defect, or Cycle Time Product; as well as, reports based on the Product Family. Operation Dashboard provides better visibility of a plant’s performance and capacity.
  New functionality:
  - The http calls are gzipped.
  - The log4j.properties file was added in order to log to kibana.
  - Added UserController servlet to get the customers from the corresponding user.
  - TokenProvider class added to get “dashboard_app” token.
  - Added slash at the end of every call or redirect.
  - Added war packaging instructions
  - Reports are now saving their configuration including “visible” attribute in localStorage.
  Enhancements:
  - Project compiled with sencha cmd to avoid multiple http calls for every component.
  - General TP chart labels set to 7
  - The application context path is taken from “Server Information” and not hardcoded on every call.
  - Ajax calls to save profile were changed to pass through servlet.
  - Report ID’s list are now received from portal portlet application.
  - Replaced “Top 5” legend on titles by only “Top”.
  - Report execution calls are now handled by a servlet to avoid CORS problems.
  - Report executions are called by generic user ‘dashboard_app’
  - Reports are called by id's but the id's are dynamically obtained every time the application runs
  - based on report names.
  Bug Fixes:
  - Reload problems on TP part family and Yield by product family reports fixed.
  - Yield by product family drill down fixed.
  - Hourly yield starting in different hour fixed.
  - On “Apply” button on new configuration it was showing no-data in all reports. It was corrected.
  - General TP labels was not updating on chart reload.
  - Top defect intervals fixed to get more rounded numbers.
  - Top cycle time product fixed to get more rounded numbers.
  - Parent dependencies fixed in pom
  - Fixed dependencies on pom files.
  - Removed finalName tag on pom.
  - Some objects were closed correctly.
  - Hide/Show behavior fixed for “yield” and “generaltp” reports.
  - Gradients are now local for each report and id’s were renamed.
  - Top reports can hide/show chart items.
  - Removed duplicated column in “Yield by hour” chart.
  - Centering “Daily TP” chart.
  - Report “Yield by day” now is not disappearing when no data is found.
  - Profile name synched after profile is saved.
  - Report names in config windows matched to the displayed report name.
  - Removed period at the end of the paragraphs on Demo window.
  MfgStatusDashboard_Sanm.MSD.View.2.0.0.030617
  Enhancements:
  - Dashboard integrated to portal.
  - User is able to save profiles now.
  Bug Fixes:
  - Report Fixes
  Mes15_portal-device-maintenance-portlet
  Enhancements:
  - Mantis#0030177 To add a column to display "Device ID" and change column name "Device" to "Device Code" in device maintenance portlet
  - Mantis#0030914 Move the function of Device Maintenance under Conduit Configuration to Device Maintenance
  - Mantis#0030985 Change the label "Shop Floor ID" to "Name" in Document Control and Device Maintenance
  - JIRA#MCSFC-10: PCB Item 3.2.6: Allow setup of multiple stations with the same configuration.
  - JIRA#MCSFC-26: PCB Item 3.2.15: Make it available to set Device Type to Android as default in Device Maintenance page.
  - JIRA#MCSFC-10: Associate Station ID with Department list as optional
  - JIRA#MCSFC-71: Enhance the performance on Device Search and Export function
  - JIRA#MCSFC-68: UI enhancement:e.g.Delete duplicate Shop Floor ID column, auto-adjustment according to resolution
  - JIRA#MCSFC-91: Adopt log4j upgrade to 2.8
  Mes15_portal_mes-portal-db-schema-upgrade
  New Functionality:
  - Mantis#0030914 Move the function of Device Maintenance under Conduit Configuration to
  Device Maintenance
  Enhancements:
  - Support AVP
  - Mantis#0030232: mesportal database add two columns "plant" and "community_id" add a field named "part_number" in the table "attr_ext_main" to support AVP function for
  - Local Document
  - JIRA#MP-21: Fix portal counter sequence issue
  Bug Fix:
  - JIRA#MP-21: Fix portal counter sequence issue
  mes_15_sfdc-portlet-1.13.16.171012-1
  Enhancements:
  - JIRA#MCSFC-73 Disable system out in sfdc portlet
  - JIRA#MCSFC-97 To enhance the log4j configuration to delete the expired files by automatically
  Bug Fixes:
  - JIRA#MCSFC-48 Research on use UUID instead of filename in sfdc-portlet
  Production Scanning
  Production Scanning is 42Q’s new intuitive client that utilizes Conduit: the next generation of data collection. Production Scanning takes advantage of Conduit’s ability to handle multiple operations in a single transaction, thus reducing latency and increasing bandwidth. The UI is scalable and designed to help operators execute their tasks much more efficiently.
  mes15_production-scanning-tomcat
  - Tomcat server for the Production Scanning Client
  Mes15_conduit-production-scanning
  New Functionality:
  - To work with Conduit commands and interface to do production scanning
  - Mantis#0030882 Get defect code as list of box When add "Record Defect" command
  - Mantis#0031184 Make document step list synchronization in Production Scanning
  Enhancements:
  - Mantis#0031000 Change to get authorization info from server info in Production Scanning
  - Mantis#0031040 Design Production Scanning interface with new UI, and support serial batch commands
  - Mantis#0031197 Change the prompt of alert window to "Information" when the content is "Successfully"
  - Mantis#0031230 Change to retrieve SerialNumber information with PartNumber and Revision
  - Mantis#0031298 Change to show documents with start page, and support to save with the value of attribute is "NEXT" in Production Scanning
  - JIRA#MCSFC-59 Change to get portal database host according to alfresco host.
  Bug Fixes:
  - Mantis#0031065 Fix the issue of Production Scanning to get documents information by external network
  - Mantis#0031196 Fix the issue of Production Scanning to display component ID prompt
  - Mantis#0031198 Fix the issue of Production Scanning about non-serialized batch would be automatically split with quantity 1
  - Mantis#0031199 Fix the issue of Production Scanning about user unable to enter repair code to repair a defect"
  - JIRA#MCSFC-44 Change to new mes-api interface to get attributes of production.
  - JIRA#MCSFC-47 Change the mes-api endpoint(without ending in /conduit) to getting attributes of product in production-scanning.
  Mes15_quality_spc-portlet-1.2.6.170317-1
  Enhancements:
  - Merge system parameter to global parameter
  - Improve when create monitor group , timezone will auto select by plant timezone
  - Work Request ID#1001926 Support to stop monitors of all SPC servers on portal UI
  - Support open MESR Url
  Bug Fixes:
  - Fixed add email/edit email can't load monitor
  - Add waite time option for all control chart to send MFG hold
  - When we are creating a new monitor, in the location option and we try to use the button "add to selected" doesn't work in the test instance
  - When we are creating a new monitor, in the location option and we try to use the button "add to selected" doesn't work in the test instance
  - improve view chart,data,lock,input data UI.Add support Send MFG hold for all charts excluding Pareto, DPMO and Yield
  - SR#2968735 SPC Cirrus OCAP Issue
  - SR#3017120 when location has only one item , then can not create monitor
  - SR#3082052 Functional key of Cirrus SPC can not use
  - mantis#28958 Radio control has problem
  - mantis#0028871 TV can't auto reload
  - mantis#0028963 In Edit Monitor page has problem
  - mantis#0028959 can't create monitor when select too chart type
  - mantis#0028868 Input data time is converted into local zone time
  - mantis#0028892 Search System log time is converted into local zone time
  - mantis#0028973 Collection type displays null value
  - SR#2922216 E51 SPC scale missing in Graph
  Mes15_quality_spc-server-1.2.4.171010-3
  Enhancements:
  - Change access MDS strategy for by time
  - Change update last group time strategy for by quantity
  - Change bean key from int to long
  - Change stop/disable monitor strategy
  - Change collect data ,monitor data strategy ,improve performance for sendemail
  - Import mybatis to access mds.
  - Merge system parameter to global parameter
  - Reduce configuration in db.properties,migrate centerdb to spc schema.
  - Import mybatis to access mds.
  - Merge system parameter to global parameter
  - Reduce configuration in db.properties,migrate centerdb to spc schema.
  - Fixed fangdai when user change monitor group send MFG hold setting
  - Add wait time for all control chart to send MFG hold
  - Add support MFG for all charts expect Pareto ,DPMO and Yield
  - Change db.properties ,spring-applicationContext-spc.xml for improvement database connection pools
  - Add DPMO[P-T] report
  - MES15_Quality_SPC-Server to mes15_quality_spc-server
  Bug Fixes:
  - SR#3174461 FPY chart odd spikes
  - SR#3022897 monitor create duplicate record
  - fixed auto stop monitor
  - SR#2922211 user description E51 Wrong data in Collection data. In program code miss spc server timezone message
  - SR#2922211 E51 Wrong data in Collection data.all spc collection time will show accord local time
  - mantis#0028889 output duplication log for disabled monitor when tomcat start
  - mantis#0028868 Input data time is converted into local zone time
  - mantis#28994 Select one from time isn't converted into local zone time
  - mantis#0029055 Pareto Chart not create exception record
  - mantis#29096 Lock List page local time is not correct
  - mantis#0027542 Attribute quantity can exceed 25 ,viewmoreDetail can't show Rules
  - mantis#0026838 DPMO value wrong when Monitor by time
  - WR#189224 DPMO defect types monitoring
  - WR#189224 DPMO defect types monitoring
  Mes15_quality_spcdbconfig-1.2.3.171010-1
  Enhancements:
  - change MES15_Quality_Spcdbconfig to mes15_quality_spcdbconfig
  - improve spc application name e.g spc-servere81 ->spc-server-e81
  - add deleteSpcInstance.sh restoreSpcInstance.sh for bat dealwith upgrade spc instance
  - add stop/start monitor for upgrade
  - add command backupconfig and upgradeall in SpcupgradeTool.java
  Bug Fixes:
  - WR#190518 Data saving issue when configure spcdbconfig
  Other:
  - change clone command It read folder change TOMCAT_HOME/webapps/spc-server to TOMCAT_HOME/
  - change upgradeall command It read folder change TOMCAT_HOME/webapps/spc-server to TOMCAT_HOME/
  spcServerRefLib-1.0-1
  Initial Version
  
  Mes15_quality_spc-tv-db-schema-1.1.150422-1
  Enhancements:
  - change mes15_spc_tv_db-schema to mes15_quality_spc_tv_db-schema
  October 2017
  
  CR#54543 - Version [MES 15.3.13]
  Overview: [MES Portal Non-Medical]: PTS patch 2.1.6.1
  Environment:
  - E34 local 42Q PTS server
  - Corpmespts4
  Issues updated:
  - Enhancements:
    - Add new web service "scan board by workstation name" to support TTBY/E60 42Q migration. This will simplify plant local applications integration with PTS and also will improve the performance; now the plant has to use two steps call as a workaround in order to send board scanning transaction to PTS.
  - Bug fix:
    - Fix the below two defects to support more GUAD plants moving to WMS interface new architecture
      - a. Expire time parsing error with simultaneous large transactions (like 4 transactions at the same time and each with 200 reels) from WMS
      - b. Code bug in dealing with reels with msd_level =6
  September 2017
  
  CR#54543 - Version [MES 15.3.12]
  Overview: [MES Portal HA]: Bug fixing: QCCheck-Point issue with Sale Order that contains similar ATO Codes
  Environment:
  - High Availability Portal
  Issues updated:
  Updated only the MES Portal HA Environment (Non-Medical) with the follow issues:
  - (Bug fix) SR#3508350 - 1204177 - issue with QC checkpoint:
    The QC checkpoint shows 5 times for the same lines , but those lines already exist in MES BOM
  -------------------------------------------
  CR#54429 - Version [MES 15.3.11]
  Overview: [MES Portal HA]: E35 Enhancements: QC Checkpoint
  Environment:
  - High Availability Portal
  Issues updated:
  Updated only the MES Portal HA Environment (Non-Medical) with the follow issues:
  - QC Checkpoint -PO Changes Validation: comparing Oracle Sales Order vs MES BOM for E35
  - QC checkpoint is a validation to ensure Oracle Sales Order Data and BOM MES are equal. They will use this tool in KV Consolidation, Integration , Shop Order Browser (recipe) and Containerization Module (complete transaction Button) to detect anomalies between both systems.
  August 2017
  
  CR#54308 - Version [MES 15.3.10]
  Overview: [MES Portal HA Non-Medical] and [MES Portal Corpmesprtl3]: Agile Connection Enhancements
  Environment:
  - Corpmesprtl3
  - High Availability Portal
  Issues updated:
  Important updates to the non-medical production 42Q instance:
  - Bugs:
    - JIRA [MPDI-92] - MESWeb Central: not showing the page
    - JIRA [MPDI-82] - Login page with wrong label for username (Screen name)
    - JIRA [MPDI-93] - Remove the Sanmina information at the bottom of the page
    - JIRA [MPDI-95] - Corpmesprtl3: Logos and Sanmina information in the pages
  - Enhancements:
    - JIRA [MS-22] - Preparation for SPC upgrade in production environment
  - New Features:
    - JIRA [MPDI-96] - New way to connect to Agile (new agile solution)
      - Add Agile Sync Job
      - JIRA [MSSFC-34] To enhance the agile synchronization on every scanning in data collector portlet.
      - JIRA [MSSFC-41] To research the features of log4j 2.x version.
      - JIRA [MSSFC-46] Work instruction file name need to support a few of special character.
  mes_15_sfdc-portlet-1.14.16.170824-1
  Enhancement:
  - JIRA #MSSFC-44: Add two new language properties (pt_BR and es_ES) in sfdc portlet.
  ------------------------------------------------------------
  CR#54172 - Version [MES 15.3.9]
  Overview: [MES Portal HA Non-Medical]: Move the new fixes to production
  Environment: High Availability Portal
  Issues updated:
  Bugs
  - [MPDI-55] - eManual: Not showing document and portlets not display in all screen
  - [MPDI-31] - Android Device Maintenance Not Showing Devices in Production
  - [MPDI-53] - SFDC-Portlet: Work Instructions not showing
  - [MPDI-70] - APK unable to get pushed from Portal to tablet
  - [MPDI-71] - Touch portlets problem for E81 V1
  - [MPDI-72] - Timeout in 42Q portal
  - [MPDI-74] - Server information portlet don't display
  - [MPDI-80] - Application Version is blank
  - [MPDI-81] - Application version is displayed even before you login
  July 2017
  
  CR#53853 - Version [MES 15.3.8]
  - Overview: [MES Portal HA]: E35 Enhancements and Employee Validation
  - Environment: High Availability Portal
  Issues updated:
  Update only the MES Portal HA Environment with the follow issues:
  - E35 Enhancements:
    - Warning Double Transaction from MES to Oracle
    - Missing ATO Code 100 level into the container
  - Employee Validation Module: Issue on delete employee accounts on portal. Delete on page never worked no matter there is activity /ev_log record of this employee or not (Associated to table ev_log and activity). And there is no error message prompted (SR#3436464)
  June 2017
  
  CR#53510 - Version [MES 15.3.7]
  - Overview: Apply patches to Liferay, update MDSQUERY, upgrate corpmespts2 and deploy API for E85
  - Environment: Corpmesprtl3
  Portlets updated:
  - mes15_portal_mes-migration-1.12.33.170518
  - mes15_portal_patch-1.12.35.170602-1
  - mes15_newrelic_pro_edition-3.39.1-1
  Issues updated:
  These are the changes/upgrades necessary for the portal:
  - update the latest portal migration package is mes15_portal_mes-migration-1.12.33.170518-1.i386.rpm on on corpmesprtl1 and corpmesprtl3
  - mes15_portal_patch-1.12.35.170602-1: which fixed CPU high loading problem (Liferay issues: LPS-14986)
  - mes15_newrelic_pro_edition-3.39.1-1: which update existing New Relic Java agent to v3.39.1 Pro license to cover the new feature of error analysis.
  - update mdsquery (version mdsquery-1.0.20.jar) on corpmes4 and corpmes3
  - upgrade of corpmespts2 to m3.xlarge
  - Deploy new Custom-API application with only e85 custom reports as of yet.
  - Mantis#31173: Android Device Migration pops up blank error prompt - Fixed this issue
  -------------------------------------------------------------------------------------------------
  CR#53458 - Version [MES 15.3.6]
  - Overview: Nokia Carrollton Changes/Improvements on corpmesprtl3
  - Environment: Corpmesprtl3
  Portlets updated:
  - mes15_mlc-maintenance-2.9.1.170524-3
  - mes15_kv-production-2.10.4.170525-1
  - mes15_shop-order-control-2.8.4.170525-1
  Issues updated:
  - (SR 3364492) Add the ability to use the “Input” Algorithm logic from Part number (label Data field)
  - (SR 3364499) Container validation completion to check exact SO line quantities
  - Create a new Generic attribute similar to “kit_consolidation_ignore_bom_item_type” but for kit_integration (Function to remove the Phantoms of KV) = New Generic Attribute: kit_integration_ignore_bom_item_type
  - E35 NSN custom WO - Close process, to add a switch to control whether or not ERP shop order can be manually closed in MES and/or close them upon complete transaction submit.
  - New Generic Attribute: complete_transaction_auto_close_shop_order, complete_transaction_extra_quantity_enabled
  - Return the pointer of the mouse to the field to introduce the new serial or PN in KV Processing (Integration)
  - Container status change once it has been sent to OracleTo give the user some visibility as to the Container has been already sent to Oracle previously
  - (SR 3364507) KV Consolidation to don’t allow mark the Serialized PN as short (since the the Serial numbers are created on consolidation, and can not be integrated if they haven’t been consolidated)
  - (SR 3364506) KV to don't allow more quantity for the same PN, summarizing PN or PN SN
  - KV did not allow to complete the Integration process when "Save"
  - E35 NSN custom WO - Cancel process / Generic Attribute : allow_cancel_erp_shop_order
  - we are having issues using the SIT tool with the function "Receive PTS"
  - (SR 3364501) Capability to Add the same part number/different Sales Order Lines on the Shop order recipe (Shop Order BOM).
  May 2017
  
  CR# 49521 - Version [MES 15.3.3]
  Overview: Upgrade of portlets for NSN kit verify customizations. PTS portlet upgrades to resolve issue discovered after deployment.
  Kit Verify - Production (mes15_shop-order-control-2.2.2.160420-1 )
  - Travelers reviewed, fixed format issue (NSN Customization).
  - T508 - The PTS ID is being kept when the user scans a serial number. (NSN Customization).
  - T508 - A strange component is being displayed at Consolidation screen after a tooltip is created. (NSN Customization).
  - T508 - Some improvements were made to show the correct message error to the user when we try to get Serial Number Detail. (NSN Customization).
  - T646 - On Consolidation For serialized items, implements the same logic as Integration to get CoO from Barcode. For integration, if CoO doesn't exist on 2DBarcode or mask was not configured, we consider the CoO from PTS saved on Consolidation phase for that item. (NSN Customization).
  - T646 - Refactor Packing And Integration traveler (NSN Customization).
  - + Common Changes.
  Multi-Level Containerization Maintenance (mes15_mlc-maintenance-2.1.2.160413-1)
  - T601 - Print Labels : Show print queue default for all part.
  - T637 - Print Labels Improvements:
  1. Print Mode: LE - Show Label Name and Print Queue from Label Engine.
  2. Print Mode: MDS - Enable to print the label on local (Download the label to .pdf file). It is only possible .if the label type was configured to download (has the label part 'PDF_DOWNLOAD').
  3. If the Configuration is Disable to Change, the user only is able to choose pre-configured options.
  4. Added a missing message that the Container has been closed.
  - T508 - A bug was fixed. The button "Complete Transaction" is not being shown (NSN Customization).
  - T508 - Some improvements were done to resolve performance problems (NSN Customization).
  - + Common Changes.
  Shop Order Control (mes15_shop-order-control-2.2.2.160420-1)
  - T664 - Bug fix -> MDS Portlets -> Profile for Read-Only.
  - T601 - Print Labels: Show print queue default for all part.
  - T637 - Print Labels Improvements:
  1. Print Mode: LE - Show Label Name and Print Queue from Label Engine.
  2. Print Mode: MDS - Enable to print the label on local (Download the label to .pdf file). It is only possible if the label type was configured to download (has the label part 'PDF_DOWNLOAD').
  - T673 - Sales Order permissions missing.
  - + Common Changes.
  PTS - (mes15_pts-portlet-1.2.8.160425-1)
  - The chrome browser higher version compatible issue for the Touch pop up window.
  - Support E79 Conversion customize COO, Bond/Non-bond ASP down compatible issue.
  PTS Web Service - (v2.1.4.160425-1)
  - Fix the OWMS-PTS interface web service bug.
  - Support E79 Conversion customize COO, Bond/Non-bond ASP down compatible issue.
  April 2017
  
  CR#'53135 42Q APK v1.21
  Overview: Upgrade Cirrus production environment with the latest Cirrus APK (Android emulator app ) to Version 1.21.
  All Modules:
  - Issue fixed: Station ID can't refresh until clear data at Android application management page.
  (From this version, please click "RELOADING STATION ID" button to update the station list to select).
  PCB Work Order: PCB multiscrap option
  - SR# 3365508: Cannot access multiple Unit IDs, (Employee # and password are kept in the cache).
  - SR# 3275795: 42Q APK does not reset Manufacturing Help between work orders.
  January 2017
  
  CR#'52227 Production Release [MES 15.3.3] corpmesprtl3
  Overview: Critical updates to the non-medical production 42Q instance in Virginia.
  Kit Verify - Configuration (mes15_kv-configuration-2.2.0.170111-1)
  - T1515 - Replace Sanmina images by 42Q
  Kit Verify - Production (mes15_kv-production-2.7.0.170111-1)
  - T1396 - Bug fixed: BOM changes affect the partial integrated units.
  - T1515 - Replace Sanmina images by 42Q
  - T1517 - New features: 1- Create a new Generic Attribute that configure a flag to allow the user to skip the consolidation phase. And start the process at Integration; 2 - The layout mapping selection should show the part number and part family.
  - T1545 - Customization for E35 (Standard).
  Multi-Level Containerization Maintenance (mes15_mlc-maintenance-2.5.0.170111-1)
  - T1477 - Bug fixing -> Error to input the element at Container.
  - T1545 -> Customization for E35
  - T1515 - Replace Sanmina images by 42Q
  MES15_MESWeb.4.1.29.012517/ Jan 25th, 2017
  Added:
  - Axis title defect quantity/accumulative %.
  - New columns added into "WIP Dashboard by SO (B3-B4)" and "WIP Dashboard by PN": SO Start date, HEAT_SINK, DEBUG_DISASSY, RWK_B3, RWK_B4.
  Updated:
  - Changed serial table by serial_iswip in Process parameters.
  - Temporal files separation in longfiles and shortfiles.
  Fixed:
  - Issue with date format on the Wip Display report.
  - Measurement URL builder for Unit History report.
  - Performance issues for reports Shop Order, Wip Distribution, Yield & Defect.
  October 2016
  
  Production Release of MES [MES 15.3.2]
  Overview: Bug Fixes and Enhancements to Profiles, SIT, Containerization, Shop Orders, PTS and SFDC.
  42Q APK v1.19
  All Modes:
  - Unexpected exit at Unit ID selection.
  PCB Work Order Mode: PCB multiscrap option
  - Update remaining qty once user modifies the entered defect qty
  - Show/Hide "defect qty add" column accordingly to Total SCRP QTY and remaining qty.
  MES Portal Packages:
  mes15_quality_spc-portlet-1.2.5.160928-1.rpm
  - fixed: user add/edit email , SPC monitor list can't show monitor
  - add buffer time option for all control chart before sending MFG hold
  - improve view chart,data,lock,input data UI
  - add support Send MFG hold for all charts excluding Pareto, DPMO and Yield
  mes15_portal_profile-maintenance-1.12.19.161013-1
  - Add "Change password" by default when create new site profile
  - Remove "Configuration" when define permission
  - Fix profile name not case sensitive bug
  mes15_portal_user-maintenance-1.12.19.160916-1
  - "Change password" behavior changes according to defined profile
  mes15_portal_server-information-1.12.18.160824-1
  - "Service domain" filed change from agileurllink to ip.
  - Change dbcp datasoure properties, maxActive from 40 to 8, ...
  - Check Agile connection twice.
  mes15_pts-portlet-1.3.0.161012-1
  - The remain qty value sometimes display X.0 for function 'Material Queue' because the postgresql drive package has been upgraded. We change it from X.0 to X.
  - Improve function 'Add Virtual RT' to resolve issue 'after choosing the not first Manufacturer Name but the chosen item will be the first data' and root cause is at least two same company value.
  - Improve the manufacturer information function for the package type combobox item,pb free category item and msd level item.Current values are hard code.
  - ”Replace Barcode" function new barcode upper-case issue while submitting by "Enter" action.
  - id=-1 record in table package_type
  - MSL value 2a,5a and 2A,5A in manufacture information:db is 2A while dropdown list is 2a
  - PTS log content optimization
  - com.sanminasci.scion.pts.dao.impl.PTSBaseDaoImpl.getEnquriyDataPerpage
  - Improve 'Show BOM' function and other similar sql with query parameter bom_pn_id and ecn_id.
  mes15_Sanm.MESWeb.Central.View-1.5.161017-1
  - Fixes an issue when trying to add customer permissions to a user group.
  - Fixes an issue where all data sources by location where shown in the customer's section at permission windows (By user and group). Now it only shows mesr data sources.
  - Fixing an issue with SQL Server connections. BounceCastle was causing the issue, it has to be removed before establishing the connection.
  mes15_sfdc-portlet-1.11.10.160822-1
  - Mantis#0029643 To support multi SCRP function for pcb project.
  - SR#2950986: Document Mapping - deviation displaying issue.
  MDS Portlets
  - T997 - Bug Fixed: AUTO - PUBLISH Trigger is not working due new constraints
  mes-portlet-commons 2.1.5
  - T637 - Print Labels -> Improvements - Able to get Labels and Printers on both schemas labelengine and label_engine, depends on configuration
  mes15_algorithm-tool-2.0.3.161013-1.i686.rpm
  - T744 - Bug Fixed: Edit Algorithm Element - Wrong Behavior
  - T932 - Bug Fixed: The Algorithm Crash when the user try to Edit Algorithm Number less than 20000
  mes15_audit-report-2.0.3.161013-1.i686.rpm
  - T1164 - Bug Fixing -> Unable to find history
  mes15_mlc-maintenance-2.3.1.161013-1.i686.rpm
  - T637 - Print Labels -> Improvements - Able to get Labels and Printers on both schemas labelengine and label_engine, depends on configuration
  - T1362 -> Bug Fixing - Wrong capacity on Container view screen. ie. container configuration says the capacity is 1000 but the screen displays 999999.
  mes15_serialized-item-tracker-2.3.1.161013-1.i686.rpm
  - T637 - Print Labels -> Improvements - Able to get Labels and Printers on both schemas labelengine and label_engine, depends on configuration
  - T868 - Bug Fixed: Receive Non-Serialized Batch. When the user receive non-serialized batches the SIT Range is created with quantity 0 and No serial number is created.
  - T975 - Bug Fixed: Wrong Sit Range Quantity for Non-Serialized SIT Batches
  - T1014 - Bug Fixed: Receive SIT is not validating if Part Number is on Hold
  - T1083 - Bug Fixed: Process Sit Range - Wrong Quantity
  - T1084 - Bug Fixed: Disposition SIT Range - Updates the quantity of sit range list with the first serial quantity
  - T1146 - Bug Fixed: Edit Sit Range - Wrong behavior to show attributes of Non-SN Batch
  mes15_sfdc-config-2.2.1.161013-1.i686.rpm
  - T818 - Bug Fixed: Issue on Defect Code Filter, when the plant don't have any Global Defect Codes
  - T865 - Improvement: MFG Line Performance Issue on update
  - T1013 - Attribute Def -> Attribute group will auto change when click on the form
  - T1179 - Bug Fixed: Missing revision information on part number full export file and Increase country field max length to 50
  - T1180 - Bug Fixed: Wrong subroute information on All Installed Route Steps print file
  - T1290 - New Feature: Send emails on put on Hold and Release Holds
  - T1297 - Bug Fixed: MFG Hold - Allows Put on hold empty data
  - T1335 - Bug Fixed: "Print/Export" Report Not Tally with Content in Part Number
  - T1342 - Location -> Create Data Collector Form -> Two Save buttons
  - T1357 - Bug Fixed: Mfg Hold - General issues with import
  mes15_shop-order-control-2.4.1.161013-1.i686.rpm
  - T637 - Feature: Print Labels -> Improvements - Able to get Labels and Printers on both schemas labelengine and label_engine, depends on configuration
  - T807 - Feature: Added a New field on Bom Item (Required Quantity)
  - T891 - Feature: Sales Order Browser -> Ability to assign containers to order lines
  - T970 - Bug Fixed: Serial Number Assignment creates a serial even if it is in the catalog table.
  - T1271 - Bug Fixed: No default revision value from Oracle
  - T1369 - Bug Fixed: Serial Number Assignment - Add and Remove are loading containers
  MES Server Packages:
  mdsquery-1.0.1-17.x86_64.rpm
  - update to support the minutes in timezones of India and possibly elsewhere
  mes15_mds-api_2.05.00.20160628
  - MI#0029475: Custom Code for API - HISA
  PTS Server Packages:
  mes15_pts-ws-2.1.6.161012-1
  - Support the simple csv and/or xml for the Ezpicklist Handload
  - Resolve OWMS-PTS interface thickness and orientation related issues.
  - Change report sql table join field from 'package_type.package_type_id' to 'package_type.package_type_id1'.
  - Resolve split material plant name prefix issue(two plants use one DB and current solution is hard code to substring(0,3) for getting plant name).
  - Resolve EZpicklist 'is_check_thickness' and 'is_check_orientation' transferring value issue(DB default value is -1 but current trasferring value from portal to web service is 0). Current implemented solution is a temp solution.
  - Add to table 'package_type' two records sql of which are 'insert into package_type (package_type_id1, package_type_id, package_type) values (-1, -1, 'Unknow')' and 'insert into package_type (package_type_id1, package_type_id, package_type) values (0, 0, 'Unknow')'.
  - Some scanning board related report SQL which use whole scanning_1 table query without any query condition performance improvement.
  - ” Replace Barcode" function new barcode upper-case issue while submitting by "Enter" action.
  - Function 'Add Work Order' sequence value is not generated based on DB configured sequence value.
  mes15_mes-interface-2.0.6.161012-1
  - Timezone related issues improvement for single plant.
  - Timezone process result is correct or exact for multi-plant.
  - Multi-plant configuration info generate from current sql configuration file.
  - Resolve the thread keep in runnable state issue(add a new configuration item 'runnable-state-duration' in
  interface-setting.xml).
  mes15_printq-3.0.1.161012-1
  - Fixed the multiple plant local timezone issue.
  SPC Server Packages:
  mes15_quality_spc-server-1.2.3.160929-1
  - when user change monitor group send hold URL ,this need to check all monitors in the monitor group which there are no hold record
  - add buffer time option for all control chart to before sending MFG hold
  - SR#3174461: FPY chart odd spikes
  - SR# 3005567: support MFG hold for all charts expect Pareto ,DPMO and Yield
  - SR#3182156: SPC Times wrong
  mes15_quality_spcdbconfig-1.2.1.160701-1
  - Provide new feature which helps user to stop/start monitors for upgrade spc-server process
  SFDC PC Packages:
  mes15_sfdc-webservice-1.11.10.160826-1
  - Mantis#0029643 To support multi SCRP function for pcb project.
  Portal Menu Files:
  Sanmina.com-201610141531.lar & Template_Site-201610141531.lar
  - Add the MES-Fuji configuration at Shop Floor Control -> Configuration PTS Configuration, SFDC Configuration, Panel Configuration, Fuji-PTS Line Mapping, Production Line Setting
  - Add the MES-Fuji scan portlet at the Production --> Integration Scanning
  - Add the MES-Fuji report at the Reporting -> MES-Fuji Fujitrax Scan Board Report, Production Line Errors Report, Transaction Logs Report
  - Add the PTS Add Work Order at the Administration -> PTS Administator
  42QAPK v1.18
  All Modes:
  - SFDC Host field to support hyphen in the DNS
  - Adds a break line to facilitate search of Unit IDs
  - General improve on error and warning messages to the user.
  PCB Work Order Mode:
  - PCB multiscrap option
  - Fixing bugs: Text field issues on the PCB-Scrap option, touchscreen Keyboard won't work with a couple of fields
  - Adding the validation for Remaining Qty as 0 to submit the Scrap transaction
  Backend Changes:
  MDS Schema Changes
  - No MDS or MESR schema changes
  SFDC Core Command Changes
  upactser
  - SR 3200956: - NS batch action 22, if parent already at scrap then for child ERP use parent op seq and in que for step.
  chgid60
  - SR 3154572: - Version 1.10 - remove part key from certain serial queries and add upper to the prefix + comp id
  Other Backend Changes:
  add_wipmove_defect
  - SR 3200956: - Changes for scrap multi defect for PCB. Report first defect in QCP
  get_units_by_attribute_name
  - New mds-api webservice endpoint returning units with a particular attribute_name value.
  movesntonextso
  - If did not consume a skeleton and auxiliary/unreleased quantity > 0 then adjust released quantity (panel_quantity) and set location key = 0 instead of null for modified serials
  July 2016
  
  Production Release of MES15 [MES 15.3.1] Portal [1.3-01]
  Improvements/Bug Fixes
  For 42Q
  
  MES Portal Server Packages:
  Mes Portlet commons
  - T689 - Print Label -> Label Mode: Label Engine - Bring the wrong data when it is the new Label Engine Version - When site is using the new version of Label Engine, the Label name combobox is loaded with the hibernate version data.
  - T751 - Logged User Information - If the logged user don't have the badge number updated, it will return the oracle id.
  Algorithm Tool
  mes15_algorithm-tool-2.0.2.160701-1.i686.rpm
  - T775 - Missing algorithm element details - There are set of rules around the which elements can be combined together. i.e. week custom element can only be used with the calendar type fiscal. Those rules are enforced by the portlet but in case of plant migrations, old systems could have been softer, in such case the 42Q won't even show the details of the element that should be there. Please, change the portlet so it always displays the details for an existing saved element.
  - T744 - Edit Algorithm Element - Wrong Behavior - When the user tries to edit an Algorithm Element, click on the Element type and than click on the form, these values are reset: Minimum Length; Minimum Value; Maximum Value
  Configuration Publish
  mes15_configuration-publish-1.0.0.160701-1.i686.rpm
  - T672 - Change Configuration Publish Labels
  - Label changes:
  - Pending Changes => To Publish
  - Publish History => Published
  - No change to publish => There is no configuration to publish **(publish btn should not be visible in this case)
  - T674 - Refactor Configuration Publish using ExtJS
  - T751 - Logged User Information - If the logged user don't have the badge number updated, it will return the oracle id.
  EV Maintenance (empval-emp-class)
  mes15_empval-emp-class-2.1.0.160629-1.i686.rpm
  - T743 - Unable To Print Filtered Employee - Performance issue on /employee-validation-maintenance
  - T790 - Unable to Add an Employee on Employee Maintenance - The user tries to add a new employee but the system returns an error that the employee already exists, but the filter wasn't able to find it.
  KV Production
  mes15_kv-production-2.4.0.160629-1.i686.rpm
  - T803 - New behavior for KV Control Flag; When the kv_control is false only that item will be not handled by KV, and all child items (if exists) will be controlled by KV, even the father is not.
  - T704 - Kit Verify -> New Feature -> Automatic Skip Component - After perform a skip a component, the remaining components should be skip too, following the rules: Should be belongs of the same SET number and the same part number from the component skipped.
  Labor Tracking
  mes15_labor-tracking-2.1.0.160629-1.i686.rpm
  - T741 - Logic to Hide Fields on Edit Labor tracking
  - Attendance type
  - Labor type
  - T751 - Logged User Information - If the logged user don't have the badge number updated, it will return the oracle id.
  Multi-Level Containerization Maintenance
  mes15_mlc-maintenance-2.2.0.160629-1.i686.rpm
  - T751 - Logged User Information - If the logged user don't have the badge number updated, it will return the oracle id.
  - T703 - MLC Maintenance -> Bug -> The Transaction screen is not closing when the TreeView (Complete Items) is empty. The Transaction screen is not closing when the TreeView (Complete Items) is empty and the missing items is not being displayed.
  - T692 - New features for ShopOrder and MLC Maintenance (NSN)
    1. 1 Filter the component (Multi-Level Containerization Maintenance)
  - Don't display those items which attribute is “NONE.NOMPN.No” in this category ‘SANM_TRACEABILITY’ in missing packing list form
    1. 2 Add/Edit/Delete - Reference Designator (Shop Order Browser Information)
  - BOM Reference designator UPDATE function need to be added in 42Q, (E85 & NSN)
    1. 3 Edit Traceability Code - (Shop Order Browser Information)
  - Add a function in 42Q to allow user to update this category for each item under each WO in case the source data from Oracle is not correct.
  Serialized Item Tracker
  mes15_serialized-item-tracker-2.0.2.160701-1.i686.rpm
  - T805 - When the user tries to update an Attribute Value that is a Date, the system is decreasing one day.
  - Before double click: 2016-08-05
  - After double click: 2016-08-04
  SFDC Configuration
  mes15_sfdc-config-2.2.0.160701-1.i686.rpm
  - T685 - Bug -> SFDC Configuration -> The permission for Export button wasn't working. The permission for 'Export All Installed Route Steps' button wasn't working.
  - T751 - Logged User Information - If the logged user don't have the badge number it will return the oracle id.
  - T787 - Auto Publish Trigger - Missing Operator - The employee key is missing when Auto Configuration Publish flag is on.
  Shop Order Control
  mes15_shop-order-control-2.4.0.160629-1.i686.rpm
  - T692 - New features for Shop Order and MLC Maintenance (NSN)
    1. 1 Filter the component (Multi-Level Containerization Maintenance)
  - Don't display those items which attribute is “NONE.NOMPN.No” in this category ‘SANM_TRACEABILITY’ in missing packing list form
    1. 2 Add/Edit/Delete - Reference Designator (Shop Order Browser Information)
  - BOM Reference designator UPDATE function need to be added in 42Q, (E85 & NSN)
    1. 3 Edit Traceability Code - (Shop Order Browser Information)
  - Add a function in 42Q to allow user to update this category for each item under each WO in case the source data from Oracle is not correct.
  - T687 - moreinfo1 and moreinfo2 information not available on sales order view screen - The fields moreinfo1 and moreinfo2 are not displaying are empty, however the data exists in the database.
  - T751 - Logged User Information - If the logged user don't have the badge number updated, it will return the oracle id.
  - T752 - Serial number maintenance/assignment should not be available for serialized batches - Serial number maintenance/assignment should not be available for serialized batches. Delete serial_erp_loc record whenever the serial shop_order changes. Update shop order key and unit status key in a single command.
  Target Maintenance
  mes15_target-maintenance-2.2.0.160705-1.i686.rpm
  - T696 - 2 Person PTCR Verification - Allow verification of sensitive data on Target Maintenance. The first person will configure what data is sensitive and those data will be hidden to the second person. The second person will entry again data sensitive to match.The 'Column Form' screen will have 'sensitive' field.
  - Steps:
  - 1P enter data (can edit as much time as he wants before it is validated)
  - 2P enter data
  - ANY MISMATCH: clean sensitive data , add verification, goes back to step 1,
  - ALL MATCH: save verification, target can not be updated anymore
  - T700 - Target - Column Types Float and Decimal - The fields with the Float and Decimal types are round upper to two decimal places. But the user needs to keep the exactly number of decimal places that were filed.
  - T753 - Set empty value on "default value" from numeric column
  - T804 - Add/Edit Target - Bugs -
  - Add/Edit target - Target name allow to entry "/" character.
  - Add/Edit target - Add column: is not validating empty name and the mask field is required after focus.
  mes15_le-labels-1.03.03.160617-1.i686.rpm
  - MI#0029227: HTTP 500 error / Memory Leak
  - MI#0029413: Improved logic to get GroupID based on GroupName
  - MI#0029417: Web Service not starting properly
  - MI#0029444: Bug Fixing - Retrieve data in attribute array (issues when attribute data have either space or comma)
  - MI#0029441: Bug Fixing - Part Number mapping issues when it has a group association
  - MI#0029452: Duplicating labels (container / agency labels)
  mes15_le-administration-1.03.01.160420-1.i686.rpm
  - MI#0029191: Unable to Save Database when SQL Server
  - MI#0029227: HTTP 500 error / Memory Leak
  mes15_lbleng-admin-view-2.01.01.160622-1.i686.rpm
  - MI#0029390: Printers with more than 10 characters
  mes15_lbleng-view-2.01.01.160628-1.i686.rpm
  - MI#0029227: Memory Leak
  - MI#0029391: Problem when delete an element
  - MI#0029442: [View Element Issues]: Unable to display value
  - MI#0029357: Delete Label - change refresh label list behaviour
  - MI#0029464: [LE Print History]: Filter Enhancements - View Raw Data and Local Print
  - MI#0029465: [LE Print History]: Rename "Print Queue / Printer Name" to "Print Destination"
  - MI#0029504: Unable to update token
  - MI#0029506: [Print Logs Improvements]: RTF Travelers
  - MI#0029385: enable local printing
  - MI#0029456: [Duplicating Records]: LE Print History
  - MI#0029269: Reporting screens with date pickers
  mes15_Sanm.MESWeb.Central.View-1.4.160706-1
  Added:
  - Change By to report version. The report's history now will show who made a change to the report.
  Fixes:
  - List boxes in Roles, Report Groups, Reports, MESR Customers, Data Source are now sorted alphabetically.
  - Fixed a bug in User Permissions that deleted previous permissions granted if tab was not loaded.
  - Import Users now is fixed.
  - Several cosmetic issues were fixed such as button alignment, labels on summary, resize window, publish report message.
  - A bug that shown predefined reports in the report search.
  - A bug that shown all report in predefined reports maintenance and predefined mapping
  mes15_portal_patch-1.12.13.160608-1
  - Liferay Portal Memory Leaks (OutOfMemoryError)
  mes15_portal_server-information-1.12.12.160526-1
  - Enhancement for the Vision project to connect to 42Q MESR DB
  mes15_portal_android-device-maintenance-1.12.10.160425-1
  - Fix old version not deleted and may deploy failure.
  mes15_sfdc-portlet-1.11.10.160707-1
  - SR#3104879: emanual wipeout documents after scan assembly table
  mes15_quality_spc-portlet-1.2.2.160624-1
  - SR#3082052: Functional key of 42Q SPC can not use
  - SR#3017120: SPC issue - can not create monitor
  - SR#2968735: SPC 42Q OCAP Issue
  - Add / Edit Monitor Group change: read Shop Floor Time Zone from Plant Maintenance portlet.
  - Mantis#28958: Radio control has problem
  - Mantis#0028871: TV can't auto reload
  - Mantis#0028963: In Edit Monitor page has problem
  - Mantis#0028959: can't create monitor when select too chart type
  - Mantis#0028868: Input data time is converted into local zone time
  - Mantis#0028892: Search System log time is converted into local zone time
  - Mantis#0028994: Select one from time isn't converted into local zone time"
  - Work ID#1001926 42Q SPC Server Management tool
  MES Server Package:
  LE Web Service (lbleng-webservice.war, version 2.01.20160628)
  - MI#0029392: New Web Service Methods (Ability to retrieve back production labels and print queues);
  - MI#0029385: Enable local printing (Ability to download locally a ZPL or RTF);
  MESR Server Package:
  MES15_MESWeb.4.1.24.070616
  Added:
  - Support Nagios monitor.
  - Merlin Dispatch Report.
  - WIP Dashboard By SO (B3) Report.
  - WIP Dashboard By SO (B4) Report.
  - WIP Dashboard By PN Report.
  - PCBA SMKT Aging.
  - WIP Dashboard by SO (B4) all customers.
  - WIP Dashboard by SO (B4-B3).
  - Wip Detail.
  - Report Traveler History
  Changes:
  - Added missing entries for Arista's WIP Dashboard report.
  - JS,CSS dependencies added as local.
  - Field "Line Group" set as required in Labor Efficiency and Productivity report.
  - Available part number list is refreshing when customer prefix is added or removed in customer management section.
  - Removed “SCI” from logo sending by email.
  Fixes:
  - Fixed permission by group customers.
  - Issue with Yield&Defect drill down when Shop Order selected in Period / Order parameter.
  - Weekly Yield Export was fixed.
  - Error format in percentage NaN.00%. for Y & D report
  - Correct Sanmina logo on schedule report messages.
  - Bad calculation and parameter not configured to replace in main query to Weekly Yield Report.
  SFDC PC Packages:
  mes15_sfdc-sfdc-1.11.10.160620-1
  - Mantis#0029448: CLRATT command need to support * character to match all attribute(e.g: CLRATT$R$* and CLRATT$R$*|*).
  - Mantis#0029446: ATTADD command should display Recovery Mode rather than Network Problem.
  - Mantis#0029449: To fix the attribute data can't be removed twice issue on ATTREMOVE command"
  - SR#3057257: P30 MES issue (non-serialized batch quantity lock issue)
  mes15_sfdc-autosfdc-1.11.10.160616-1
  - Mantis#0029445: Remove getuuid.sh function from autosfdcxml because performance issue
  mes15_sfdc-webservice-1.11.10.160617-1
  - Mantis#0029450: The operator number need to support character on EV function in web service
  mes15_sfdc-db-schema-1.11.10.160616-1
  - Mantis#0029447: Create an index for the upper("serial_number") query in serial table
  PTS Server Packages: mes15_pts-portlet-1.2.9.160630-1
  New version bug/enhancement description:
  - Convert the Mydata SMT machine file format.
  - Support the NPI plant multi Reference Designater at the Add Deviation Note.
  - Improve the Show BOM window layer format to display the Part Number properly.
  - Convert the Add Work Order from ASP to 42Q version.
  - Fix the automatically highlight tracked items at the picklist upload portlet.
  - Fix the issue which the Part Number are not showing in read once they are classified as traceable at Ezpicklist.
  - Migrate the label date format, PB_CATEGORY from file configuration into the System Setting.
  - Support the Fuji multiple Profiler repair/rework.
  - Fix the scan board creation/update time issue.
  This version is compatible with PTS DB schema v3.53.
  
  PTS Web Service v2.1.5.160627-1
  New version bug/enhancement description:
  - Convert the Mydata SMT machine file format.
  - Fix the Break Panel issue which the second side is correct.
  - Fix the Feeder Slot/Station extra space issue for the Ezpicklist.
  - Convert the Add Work Order from ASP to 42Q version.
  - Migrate the label date format, PB_CATEGORY from file configuration into the System Setting.
  - Support the Fuji multiple Profiler repair/rework.
  - Fix the wrong Picklist name display issue at the Touch Material Load portlet.
  - Fix the scan board creation/update time issue.
  This version is compatible with PTS DB schema v3.53.
  
  SPC Server Packages:
  - mes15_quality_spc-portlet-1.2.1.160624-1
  SR#3082052: Functional key of 42Q SPC can not use
  - SR#3017120: SPC issue - can not create monitor
  - SR#2968735: SPC 42Q OCAP Issue
  - Add / Edit Monitor Group change: read Shop Floor Time Zone from Plant Maintenance portlet
  - Mantis#28958: Radio control has problem
  - Mantis#0028871: TV can't auto reload
  - Mantis#0028963: In Edit Monitor page has problem
  - Mantis#0028959: can't create monitor when select too chart type
  - Mantis#0028868: Input data time is converted into local zone time
  - Mantis#0028892: Search System log time is converted into local zone time
  - Mantis#0028994: Select one from time isn't converted into local zone time
  - Work ID#1001926: 42Q SPC Server Management tool
  mes15_quality_spc-server-1.2.1.160624-1
  - SR#3022897 monitor create duplicate record
  - Mantis#0029055 Pareto Chart not create exception record
  - Mantis#0028889 output duplication log for disabled monitor when tomcat start
  - Mantis#0028868 Input data time is converted into local zone time
  - SR#2922211 E51 Wrong data in Collection data
  - Change : all spc server create time will show local time
  - DPMO[P-T] report
  - Auto stop monitor issue
  mes15_quality_spcdbconfig-1.2.0.160314-1
  - Support to batch delete SPC server instances for upgrade purpose, automatically backup db.properties files for instances, and record delete operation in log
  - Support to batch restore SPC server instances for upgrade purpose, automatically restore previously backup db.properties files for instances, and record restore operation in log
  Backend Changes
  MDS SCHEMA CHANGES
  revision 46
  - add type and table for 2 person verification
  - add columns to soms_target_def table and soms_target_param_def
  - add column required_quantity to bom_item
  revision 47
  - Remove duplicate employee.employee_number records and replace current employee_employee_number index with a unique index
  MESR SCHEMA CHANGES
  revision 26
  - add column required_quantity to bom_item to match mds schema
  revision 27
  - add columns to soms_target_def table and soms_target_param_def to match mds schema
  SFDC CORE COMMAND CHANGES
  get_employee_key
  - SR#3083620: Version 2.00 - Handle concurrent transactions attempting to create the same employee_number.
  sampledown
  - SR#2940813: performance update to use upper index on short_workstation, as sample download was timing out on some dbs.
  sfdcdnld4
  - SR#3115716: to address sfdc download failure if integer fields in sfdc_setup are null.
  upactser, upact
  - changes/fixes for (Viking) for serialized batch wip moves
  upatts
  - released pgsql version replacing java version; for performance improvements
  SFDC CUSTOM COMMAND CHANGES (!! commands)
  add2nextso, add2so1, add2so2, chgso, denso_sers_db_update
  - added coalesce to prevent possible null error
  back2wip2
  - changed to use trim on activity.al comparison as some have trailing spaces
  boxlabeng, labeng, print_label_engine
  - MI0029284 - Update to support both hibernate and non-hibernate, determined by generic attribute.
  chgso3
  - SR#3050794: - Added coalesce(unitcount,0) to avoid null errors
  chkfail3
  - SR#3025997: - initiial conversion to postgres
  dumpcntnr4, dumpcntnr5
  - SR#3043320: - support containers 100-109 for Fermoy, and changed loop to select statements to prevent errors
  moveifattdata
  - SR#3037717: - use sfdc_key to help prevent ambiguous locations
  moveifnoref
  - SR#3030366: - initial conversion to postgres
  notify
  - SWI:1003023 - Add Shop Order and Employee to !!1Notify.nn cmd
  operator_clock_in
  - SR#3054952: - corrected logic error on handling of labor_type_key - used by clockin command
  showatt
  - SR#3091190: - updated qry to attr_name to upper(a.name)
  OTHER BACKEND CHANGES
  add_bom_item, add_update_bom_item
  - updated default values for new field required_quantity
  add_mfghold, autodefhold
  - SR#3029319: New api function for creating a new mfg_hold record.
  - Use the new add_mfghold() api in order to update group_mfg_hold_key in new mfg_hold records.
  add_wipmove_defect
  - corrected action 12 query
  alg_eng_unload_alg
  - Updated to add defaults to all return variables instead of null
  aggregate_unit_history
  - add a data field that concatenates data1 and data2
  bloodhound_packageline
  - SR#3068662:
  1. Removed the verification is the sub-assembly has already failed before.
  2. Removed the verification is the sub-assembly has already moved to Kill.
  3. Added a check if the single sub-assembly is on "WFPK"(Hard Coded) location before fail to/pass to otherwise "Flow error-<Current workstation>".
  4. Improved the log and error message in case there is no WFPK route step. "Route step was not properly created - part_key:<sub-assembly part-key>".
  42Qpsql.so
  - SR#3029319: - Fixed bug that sent strmask function to the weeds in some obscure mask situations.
  get_activity_work_shift
  - include check for empty shift variable
  get_serials_by_attribute_name_and_value
  - MI#0029475 - new webservice for mds-api 2.05
  get_wip_moves_pcb
  - scrap move needs employee and shift of move activity instead of the defect activity for the scrap
  import_std_cost
  - New backend cron procedured, initially needed for PCB
  mds_labels/rollout
  - Adding a check if there is already a development label created when moving the label from prod to dev and return an error if there is.
  - replication support added to mes.cmms
  - RTO code was incorporated into mds deployments
  serial_update_trg
  - Add support for optional backward moves. Flag to enable is custom_code 1485.
  - SR#3036454: For serialized batches use container_quantity for wip move quantity if container_quantity > serial.quantity
  ***April 2016***
  
  Production Release of MES15 [MES 15.3.0] Portal 1.12
  Production Release of MES15 [MES 15.3.0.1]
  Improvements/Bug Fixes
  For Cirrus
  
  MES Portal Side
  
  mes15_algorithm-tool-2.0.1.160406-1
  - T527 - Bug Fixing - Algorithm Tool -> Reset Serial Number is not working.
  - T582 - All import need support extension file in case sensitive
  - + General Changes
  - + Common Changes
  mes15_audit-report-2.0.1.160406-1
  - Timeout Logic Changed
  - Bundles Version and Multi-Language implemented
  - Portlet Title - Multilanguage
  - + General Changes
  - + Common Changes
  mes15_empval-emp-class-2.0.1.160406-1
  - Fixing some Permission issues
  - Bundles Version and Multi-Language implemented
  - Portlet Title - Multilanguage
  - Layout Fixed: Employee Tree was adjusting in accordance to the items and the fieldsets were bigger than the portlet
  - + General Changes
  - + Common Changes
  mes15_empval-proc-control-2.0.1.160406-1
  - Fixing some Permission issues
  - Bundles Version and Multi-Language implemented
  - Portlet Title - Multilanguage
  - Update all process_groups with the correct mds_option
  - Changed pctrl_key from option_key to mds_option_key
  - Select All processes on Process Maintenance was not working well
  - + General Changes
  - + Common Changes
  mes15_gen-attribute-maint-2.0.1.160406-1
  - Bug Fixed - Allowed Gen Attribute with GenAttrDefinition but no GenAttr record was not been shown in the add form
  - Add formatQueryLimit and Removed maxrows and offset - findAllGenericAttributes
  - + General Changes
  - Bug Fixed: T676 - Pagination change was not working
  - + Common Changes
  mes15_kv-configuration-2.1.0.160406-1
  - + General Changes
  - + Common Changes
  mes15_kv-production-2.1.0.160406-1
  - T508 - The PTS ID is being kept when the user scan a serial number.
  - T508 - A strange component is being display at Consolidation screen, after a tooltip is created.
  - T508 - Some improvements was made to show the correct message error to user, when we try to get Serial Number Detail.
  - T646 - On Consolidation For serialized items, implements the same logic as Integration to get CoO from Barcode. For integration, if CoO doesn't exists on 2DBarcode or mask was not configured, we consider the CoO from PTS saved on Consolidation phase for that item.
  - T646 - Refactor Packing And Integration traveler
  - + Common Changes
  mes15_labor-tracking-2.0.0.160406-1
  - Fixing Permission
  - Allow Supervisor privileges to Generic Super Users
  - MI# 0027128: Labor Tracking - Bugs Fixed:
  - - Set SupervisorId if the user is a ldap and not exist on the selected database
  - - if End Date Labor is null, don't parse it to Timestamp
  - - Reviewed the Date Validation on Labor Maintenance
  - - Removed double mask on Edit Labor Maintenance
  - - Labor Employee - it was setted the wrong Attendance Type as default. Absence instead of Labor"
  - Set Labor Type Null in case of absence
  - View Only Permissions
  - + General Changes
  - T664 - Bug fix -> MDS Portlets -> Profile for Read-Only
  - + Common Changes
  mes15_mlc-configuration-2.0.1.160406-1
  - T637 - Print Labels Improvements
  - Allow the user to configure a set of configuration options to use on Container Pack Close/Print
  - Allow user to Disable Print Configuration on container pack
  - General Changes
  - + Common Changes
  mes15_mlc-maintenance-2.1.1.160406-1
  - T637 - Print Labels Improvements:
  - Print Mode: LE - Show Label Name and Print Queue from Label Engine.
  - Print Mode: MDS - Enable to print the label on local (Download the label to .pdf file). It is only possible if the label type was configured to download (has the label part 'PDF_DOWNLOAD')
  - If the Configuration is Disable to Change, user only be able to choose pre-configured options.
  - Added a missing message that the Container has been closed
  - T508 - A bug was fixed. The button "Complete Transaction" is not being showed.
  - T508 - Some improvements were done to resolve performance problems
  - + Common Changes
  mes15_serialized-item-tracker-2.0.1.160406-1
  - T582 - All import need support extension file in case sensitive
  - T600 - Create a new end-point to create / Receive a Sit Range.
  - T601 - Print Labels : Show print queue default for all part.
  - T637 - Print Labels Improvements:
  - Print Mode: LE - Show Label Name and Print Queue from Label Engine.
  - Print Mode: MDS - Enable to print the label on local (Download the label to .pdf file). It is only possible if the label type was configured to download (has the label part 'PDF_DOWNLOAD')
  - + General Changes
  - + Common Changes
  mes15_sfdc-config-2.1.4.160406-1
  - T663 - Bug Fixed -> Allows Duplicated Attribute Names with different CamelCase but when the user selects one, the combobox is getting lost and always picking the last one.
  - T664 - Bug Fixed-> No View-Only Route Profile available
  - T640 - Bug Fixed-> Attribute Maintenance -> Report Incorrect Header-> "Attribute Definition Steps List"
  - T609 - Setup Data Editor performance improvement
  - T664 - Bug fix -> MDS Portlets -> Profile for Read-Only
  - T671 - Edit Assembly Step clears Shop Floor ID and Component Location Combobox
  - + Common Changes
  mes15_shop-order-control-2.2.1.160406-1
  - T664 - Bug fix -> MDS Portlets -> Profile for Read-Only
  - T637 - Print Labels Improvements:
  - Print Mode: LE - Show Label Name and Print Queue from Label Engine.
  - Print Mode: MDS - Enable to print the label on local (Download the label to .pdf file). It is only possible if the label type was configured to download (has the label part 'PDF_DOWNLOAD')
  - T664 - Sales Order permissions missing
  - + Common Changes
  mes15_sqc-configuration-2.1.1.160406-1
  - T664 - Bug fix -> MDS Portlets -> Profile for Read-Only
  - + Common Changes
  mes15_lbleng-admin-view-2.01.00.160330-1
  - Mantis# 0028213-Fix MS SQL Server SSL issues
  - Mantis# 0028257-Remove User Guide
  - Mantis# 0028492 - app config not showing
  mes15_lbleng-view-2.01.00.160330-1
  - Mantis# 0028213-Fix MS SQL Server SSL issues
  - Mantis# 0028257-Remove User Guide
  - Mantis# 0029109-Fix printing bug related to custom join params
  - Mantis# 0029119-Change substringbyindex such that it returns when startpos > length (instead of exception and termination of printing)
  - WR# 00196478 - Feature Add: For MES Databases, auto enable the standard tables / joins and create the standart custom joins
  - Enhancement-remove possible memory/resource leaks
  mes15_portal_android-maintenance-hook-1.12.1.151211-1
  - Add downDate, downLimit for device download at specified datetime
  mes15_portal_android-device-maintenance-1.12.6.160301-1
  - Mantis# 0028940: Lowercase Asset No. hasn't converted to uppercase
  - SWI# 1001981: APP Maintenance enhancements
  - Allow to configure APK downloading quantity at the same time
  - Allow to configure the time during for an APK download
  - Revise the error message “Invalid Sync Interval”
  - Remove the “Today” button in task calendar, and displays time using the local plant time zone
  - Mantis# 0028537: The value of “Download Limit” changes back to the default ""2"" after refreshing task list"
  - Add Refresh button in APP Maintenance
  - "Download” should be revised to “Start downloading”
  - In “Change Sync Interval” setting, retrieves and displays the original value
  - In Search field, add “All” to the Group and Status drop down boxes
  - “Items” should be revised to “devices” in Task Detail and device list
  - Add “Detail” clickable link to pop up task detail window
  - “Hours ahead” textbox is not allowed to input decimal
  - In Task Detail, it’s not necessary to display “Completed”
  - In APK Maintenance portlet, displays implication to remind user to re-upload APK for those APKs that have no MD5"
  - Mantis# 0028401: Task can't be cancelled if one device is in downloading
  - Mantis# 0028399: All apk's MDS field are displaying empty at APK Maintenance portlet
  - Mantis# 0028400: Upload Time is inconsistent with portal server time issue
  - Correct some check logic.
  - Beautify app maintenance tooltip content
  - Mantis# 0028420: Tablet can't receive installation task when apk file downloads completed
  - Task detail record orderd by asset no."
  - Add download time to schedule
  - Display task result at the Task column
  - Android Maintenance UI improvement
  - Access Alfresco improvement (use cached)"
  - Create MD5 while uploading APK file via apk-maintenance portlet
  - Support to disable portal to uninstall appgarden
  mes15_portal_plant-maintenance-1.11.17.151103-1
  - Mantis# 0026184: Data list empty or not update after saving the changes (load twice)
  - Mantis# 0027628: Search Action need input double space issue
  mes15_portal_profile-maintenance-1.12.8.160401-1
  - Just one click to expand / collapse all sub-nodes
  - Mantis# 0026184: Data list empty or not update after saving the changes (load twice)
  - "- ""+"" is not allowed in profile name, prevent potential application error.
  - Handle line break in description.
  - Change to profile name case sensitive.
  - Mantis# 0027725: Inactive users haven't shown on the assign profile page.
  - Mantis# 0027628: Search Action need input double space issue
  - Mantis #0029186: site profile name display error when define permissions
  mes15_portal_site-maintenance-1.12.4.160112-1
  - SWI #1001982: Page overwritten needs to be configurable
  - Mantis# 0026184: Data list empty or not update after saving the changes (load twice)
  - Not check sfdc underneath when enable site
  - Mantis# 0026174: Add or Edit Site failed in Site Maintenance
  - Mantis# 0027740: Portal profile not show in assign profile page
  - Mantis# 0027628: Search Action need input double space issue"
  - Mantis# 0027628: Search Action need input double space issue
  - Mantis# 0027720: Site admin's role isn't removed when remove site admin from site
  - Mantis# 0027721: Assigned profile isn't removed when remove user from site
  mes15_portal_user-maintenance-1.12.4.160121-1
  - SWI# 1001984: User Maintenance Batch Operation
  mes15_portal_vertical-menu-theme-1.12.7.160321-1
  - Change webkit-scrollbar style to extjs default
  - Remove the Portal version number that displays at the bottom right corner"
  - Change the version number on the page bottom-right corner to 1.11
  mes15_alfresco-patch-1.12.6.160308-1
  - SR# 2955782: Mapping Processes in Agile
  mes15_sfdc-portlet-1.11.8.160316-1
  - SR# 2955782 Mapping Processes in Agile (fail to upload ppt issue in E20)
  - Mantis# 0028858 Improve the emulator portlet display according to screen resolution
  mes15_portal_server-information-1.12.7.160317-1
  - Mantis# 0028890: "Server Name" spelling error when add or edit MES/CMMS server
  mes15_portal_patch-1.12.8.160331-1
  - Liferay performance improvement according to "MES Portal Performance Best Practice" (maxThreads=""450"", addd Xms size when physical memory greater than 16G, etc)
  - SWI# 1001982: MES Portal - Page overwritten needs to be configurable (modify portal-impl.jar to skip dashboard when synchronizing)
  mes15_portal_portlet-setting-hook-1.12.5.160203-1
  - SWI# 1001985: MES Portal 'Add - More' not able to view all items
  mes15_httpd_patch-1.12.8.160331-1
  - Performance improvement according to document "MES Portal Performance Best Practice
  Shop Floor PC:
  mes15_sfdc-autosfdc-1.11.9.160401-1
  - Mantis# 0029185 Fix autosfdc issue of system down returns 10
  - SR# 2982961/Mantis# 0029021: Enhance T/t command when with the option line 'CHANGE_T_CMMD_ERR_CODE' set to 'N'
  mes15_sfdc-webservice-1.11.8.160309-1
  - Mantis# 0028995 Create a new interface in sfdc webservice to get device list from mes portal database (for BE apk)
  mes15_sfdc-sfdc-1.11.9.160401-1
  - Mantis# 0029184 Fix upemplog data format issue.
  - Mantis# 0029183 Change JSON sending the new field to be optional - Viking issue.
  - Mantis# 0029182 Enhance sfdcdnld to support the multipass function via scan_loc table configuration
  mes15_sfdc-nagios-1.11.7.151027-1
  - SR# 2789011 Critical nagios error messages on P3450DC1 & P3450DC5 SFDC PCs
  CMMS Tool
  
  CMMS Admin
  mes15_cmms-admin-2.1.3.160414-1
  - Missing Export Functionality (User) T614
  - Fields are showing bigger than the size of the screen (cut the field) T619
  - Missing Export Functionality (Group) T622
  - Change the field name “Approving” for other more related to the functionality T623
  - Add / Edit Escalation->Change the field name “Location” to “Department” T625
  - Add / Edit Escalation->Change the Tab “Email” do “Additional Email” T626
  - Add / Edit Escalation-> Select Group should have filter option T628
  - Manual Missing Info: not explain the Location field during the ADD / Edit functionality T629
  - SR#2922977: Inactive department is available for creating/editing Group. T655
  - SR#2922982: Inactive Group is available for creating/editing Escalation. T656
  CMMS Spare Part
  mes15_cmms-spare-part-2.1.3.160414-1
  - SR#2961027: Inactive machine types are still available for use. T654
  CMMS Asset
  mes15_cmms-asset-2.1.3.160414-1
  - SR#2961027: Inactive machine types are still available for use. T654
  - SR#2922986: Inactive Problem Type is available for creating/editing a Problem. T657
  - SR#2961024: Inactive Problem is available for creating/editing a Machine Type. T658
  - SR#2961024: Inactive Location is available for creating/editing a production line. T659
  - SR#2961032: Inactive Production Lines are available for creating/editing Assets. T661
  - SR#2968558 PM's WO are not created, regardless the time specified on "Create Wo Before". All the attached PM should have a corresponding WO, but none have been created.
  - SR# 2983971: Edit Work Order - PM - Assigned T632
  - Disabled Checklist is available in the tool. T678
  - Disabled Problem Category is available in the tool T679.
  CMMS Work Order
  mes15_cmms-work-order-2.1.3.160414-1
  - Show wrong time on Calendar and Schedule T633
  - SR#2968558: PM's WO are not created, regardless the time specified on "Create Wo Before". All the attached PM should have a corresponding WO, but none have been created.
  - SR#2984119: Edit Work Order->Add Labor: Used hours should be calculated automatically after the user selects the Start/End Dates. (Google 2.2 already do this automatically). T662
  - PM - Save - When the PM has many assets, the save request can expire. T684
  AppGarden APK version v1.02
  - Support MD5 while uploading APK file via apk-maintenance portlet
  - To support downloading schedule setup to reduce the pressure of network
  - SR# 2995438: To fix the issue of crashing under Android 5.0 Version.
  Inplan Traveler Viewer APK version v1.02
  - Release of a new APK for the PCB division , Inplan Traveler Viewer APK
  - Inplan traveler viewer APK access the PCB Inplan viewer website but not in a common web browser but this APK, in order to limit the access to other websites.
  - This android APK its also deployable through MES portal and the existing Appgarden apk
  Backend Changes
  MDS SCHEMA CHANGES
  revisions 45
  - add serial_key index on serial_erp_loc for performance improvement
  SFDC CORE COMMAND CHANGES
  No changes
  SFDC CUSTOM COMMAND CHANGES (!! commands)
  dupchke, rmvtcomp
  - SR#3012004: fixed performance issue
  gencntsn
  - Added overlay to the function as we added a new parameter _shop_order_key to container customized algorithms.
  labelfmt_v2
  - Fixed a bug with eu_date, the correct sequence should be dd/mm/yyyy and was printing mm/dd/yyyy.
  - SR#3006786: - changed eu_date to use cloc_timestamp() rather than current_date. Details in SR.
  OTHER BACKEND CHANGES
  add_update_bom_item, add_bom_item, enable_editable_gen_attr
  - now matching bom items on part, op seq and step
  apollolot, apollo_lotdata
  - Version 2.10 - SR3004684- Removed the LF from md5 checksum files by using 'printf' rather than 'echo' to create the files.
  bloodhound_move_ser_man.sql, bloodhound_packageline.sql, bloodhound_move_ser.sql
  - SR#3009360
  movesntonextso
  - set serial location to null and clear serial_erp_loc
  serial_update_trg
  - support status 40 for shop order changes
  xfersnarchive, code to restore units from archive
  - initial version
  March 2016
  
  Production Release of MES15 [MES 15.2.4]
  Improvements/Bug Fixes
  For Cirrus
  
  MES Portal Side
  • mes15_cmms-work-order-2.0.2.160324-1
  - SR# 2984010: Calendar displays WO's with wrong creation time T630
  - SR# 2983971: Edit Work Order - PM - Assigned T632
  Cirrus 'APK v1.12'
  All Modes:
  - Interface added to improve the performance and stability for cirrus APK to get Station ID and Unit ID.
  - Made enhancement on the SFDC connection error when switching unit ID.
  PCB Work Order Mode:
  - New Icons for Display Scrap and Completed units
  - Manufacturing Help option, update logic to support the Engineering Job Name (i.e Tool Number) with no suffixes for Manufacturing and pull the proper documents from local directories.
  - To support RJCT qty for 99999 at max.
  - To fix the issue of OP code difference between apk and Traveler.
  Backend Changes
  MDS SCHEMA CHANGES
  revision 44
  - create extension tablefunc
  - create compound upper index on location short and long_workstation with sfdc_key
  SFDC CORE COMMAND CHANGES
  downserialbyso, downserialbyso2
  - SR#2915329: update to no longer allow status 30 units, as first used on K05 Viking.
  SFDC CUSTOM COMMAND CHANGES (!! commands)
  passbyso
  - Planview Project 1002042 - Original release
  OTHER BACKEND CHANGES
  Checkout_newso (called by movesntonextso)
  - changed to consider dummy skeletons + the not released quantity to check whether this enough room on the new SO or not
  /integration/shop_order_scrap_complete_quantity
  - took into account the quantity of the serial records
  February 2016
  
  'Production Release of MES15'[MES 15.2.3] Target Maintenance
  Improvements/Bug Fixes
  
  For Cirrus
  
  MES Portal Side:
  
  • mes15_sfdc-portlet-1.11.7.160119-1
  Mantis#0028527: Device number can't more than 999
  Mantis#0028317: Change the function name to lower case on repair note process
  SR#2920206: Document Mapping
  
  • mes15_portal-device-maintenance-portlet-1.11.7.160113-1
  Mantis#0028527: Device number can't more than 999
  
  • mes15_portal_mes-portal-db-schema-upgrade-1.12.4.160115-1 (for upgrade) / mes15_portal_mes-portal-db-schema-1.12.4.160115-1 (for new installation)
  Mantis#0028527:Device number can't more than 999
  
  • mes15_quality_spc-portlet-1.2.151218-1
  SR#2922216: E51 SPC scale missing Graph
  View MESWeb Unit History report after clicking Affected S/Ns
  SR#2936687: when create monitor,but spc show 'The monitor name already exist.' "
  Support DPMO[P-T] report
  Create monitor for multiple locations at once
  Mantis#0026619: DPMO all type defect opportunity can't be changed
  Mantis#0026629: DPMO and Rule configuration doesn't display when edit monitor"
  Mantis#0027172: Empty status in lock maintenance
  WR#190517: Ability to View all SPC Locks on a page
  
  • mes15_mlc-maintenance-2.1.160206-1
  Improves container element's tree view looking and feel
  
  • mes15_shop-order-control-2.1.160206-1
  Fixes an issue on the Shop Order Release that prevented the units from being released at the USL defined for the SO's Part Number
  Fixes an issue on the Shop Order Release that allowed an invalid starting serial number to be released
  Enables manual revision assignment feature on Shop Order Release for Shop Orders with 'create skeleton' option is enabled on the Part Number
  Adds support to shop order revison NULL, being treated as empty in this case
  
  • mes15_target-maintenance-2.1.160201-1
  Initial Release, through a rich user graphical interface this package provides a powerful and flexible tool for targets management, such as SOMS, Six Sigma Spec/Control Limits, etc.
  
  • mes15_siren-configuration-2.1.160206-1
  Fixes UI resizing issues
  
  • mes15_kv-configuration-2.0.151218-1
  Fixes issues to map reference designator on large pictures
  
  • mes15_kv-production-2.1.160203-1
  Adds BOM Item Substitute support
  
  • mes15_sfdc-config-2.1.160203-1
  Now supports exponent character formatting (e.g., ²) in the defect code description
  Adds base34 device number support
  Adds Flex Fields tab on Part and Location forms
  
  • mes15_sqc-configuration-2.0.160203-1
  Fixes an issue on the Import SOMS Target routine to prevent it from wipe all soms tables off
  
  • mes15_Sanm.MESWeb.Central.View-1.3.160210-1
  Misspelled word in New Report view.
  Bug in SQL query validation that did not allow to user to save the report query failed in one or more data source(but valid in at least one data source).
  Fixed issue at Data source view and Report group view with location combo box.
  Bug that did not show a report that is not assigned to a group/application. Now orphan reports are shown on the search.
  Add Location panel now shows the loading mask when accept button is clicked so it won't save a lot of locations.
  Bug that messed up with report testing operation.
  New JDBCSQL driver was added. Now reports that connect to SQL Server can be tested.
  Depot Code parameter can now be configured with a max limit selection.
  
  Shop Floor PC:
  • mes15_sfdc-sfdc-1.11.7.160201-1
  SR#2955002: Tablet Application Cirrus-20150730.
  Mantis#0028674 Change the device number max limit to 28743"
  Mantis#0028656 Change the function name back to sfdcdnld4 from sfdcdnld5
  Mantis#0028527 Device number can't more than 999.
  Mantis#0028536 Sample does not move to sample plan location.
  SR#2861632: RPSCMP - Component swap issue.
  Mantis#0028575 emvdnld failed at more than 400000 records.
  SFDC supports more than 999 devices
  Mantis#0028497 Defect code quantity can't more than 999
  Mantis#0028529 The partial released non-serialize batch doesn't be able to scan at the first location."
  SR#2903732: Cirrus -- SUBATT Issue, upload timezone for SUBATT command, and "MEASKEY' command
  
  • mes15_sfdc-webservice-1.11.7.160120-1
  Mantis#0028527 Device number can't more than 999
  Mantis#0028317 Change the function name to lower case on repair note process
  SR#2922624: Cirrus -- serial number report cannot display unit"
  
  • mes15_sfdc-autosfdc-1.11.7.160108-1
  SFDC supports more than 999 devices
  Mantis#0028527 Device number can't more than 999
  SR#2897250: MES Tablets on N1 production down
  
  • mes15_sfdc-db-schema-1.11.7.160108-1
  SFDC supports more than 999 devices
  Mantis#0028527 Device number can't more than 999
  Mantis#0028210: SFDC database dnld data is null (Change unique index to normal index)
  Mantis#0028099 SFDC download very slowly.
  Mantis#0027811 Release SFDC DB schema for E81 EV issue
  
  • Cirrus APK
  Support unit id count limit as 100.
  Mantis#0028527 Device number can't more than 999.
  
  Backend Changes
  MDS SCHEMA CHANGES
  No changes
  SFDC CORE COMMAND CHANGES
  autorfc, getclvl, newclvl
  - WR#192743: clevel core sfdc updates to set clevel_key and delete empty containers
  getempval(employee validation download)
  - SR#2940804: - add 'distinct' to 2 queries for performance issue when using process_groups
  getserl2
  - SR#2966707: - updates to return data properly when in catalog table, and fix bug in numcomprecs calculation
  sfdcnld4, compute_devicecode, convert_to_devicecode
  - added device_code as last field of scanner information to allow larger device numbers, for PCBs.
  upcomp2
  - SR#2966679: - Change 'UNDEFINED' component part number to as SFDC should be sending on tracked component removal.
  SFDC CUSTOM COMMAND CHANGES (!! commands)
  addDefRepairNote, delDefRepairNote
  - don't do sfdcgui lookup. Instead look at defcode enable
  chgpn4cnt, chgpn4cnt_bg
  - SR#2935242: - Assign new c_level_key to each container to match the new part_key.
  removefromlot
  - SR#2945054: initial conversion to Cirrus
  rptcntnr
  - Performance improvement
  ***December 2015***
  
  Production Release of MES15 [MES 15.2.2.1]
  Improvements/Bug Fixes
  
  For Cirrus
  
  MES Portal Side:
  - mes15_portal-device-maintenance-portlet-1.11.7.151023-1
  - Mantis#0027698 JSQLConnect library should be deleted
  - mes15_portal-system-log-portlet-1.11.7.150729-1
  - Mantis#0027698 JSQLConnect library should be deleted
  - mes15_portal_portlet-setting-hook-1.11.14.150907-1
  - Mantis#0027772 Expiration check time is different between restart liferay and touch web.xml
  - mes15_sfdc-portlet-1.11.7.151209-1
  - Mantis#0028317: Change the function name to lower case on repair note process.
  - SR#2903686: Bug Report: Cirrus: Administration - SFDC AdministrationTask Scheduler - Chose END date.
  - SR#2905700: Batch Creation Problem GO LIVE
  - Mantis#0028125: In the Add Sub Attribute tab, the command SUBATT.LOC can't add attribute successfully.
  - Mantis#0028115: In the Remove Unit and Add Component tabs, the location fields only show partial of defined locations for some reason.
  - Mantis#0028171: Inability to automatically log into unit ID with portal user's employee ID.
  - Mantis#0028176: Batch process GUI enhancements.
  - Mantis#0028118: Engineer notes search interface not works
  - SR#2834299: K05 - Eng notes can´t be setup in emanual
  - mes15_sanm.mesweb.central.view-1.2.151210-1
  - Added:
  - New way to connect to Central Database through MES Server Information.
  - A predefined parameter called Depot Code was created for rTO reports.
  - Added <%compile%> and <%result%> feature in order to enable the use of temporary tables and precompiled code in the report queries.
  - Fixed:
  - Fix error msg when save an invalid sql code
  - Fix misspelling Data source type label
  - The name of the default value in the checkbox parameter was changed by "val" to match with model.
  - Fix infinite loop on Parameter class in Core project.
  - Fix a bug on Report Builder window that was causing that in certain circumstances did not allow to location combo box show information.
  - Fixed an issue with column names that was provoking missing data on the client.
  - Changes:
  - Display the Customer tab to User group permission
  - Hidden add predefined report
  Shop Floor PC:
  - mes15_sfdc-sfdc-1.11.7.151111-1
  - SR#2885429 Invalid or wrong quantity caused autocmd lost the ATTADD
  - mes15_sfdc-webservice-1.11.7.151208-1
  - Mantis#0028317 Change the function name to lower case on repair note process
  - SR#2897250 MES Tablets on N1 production down
  - Mantis#0028125 In the Add Sub Attribute tab, the command SUBATT.LOC can't add attribute successfully
  November 2015
  
  'Production Release of MES15'[MES 15.2.2] CMMS
  Improvements/Bug Fixed
  
  For Cirrus
  
  MES Portal Side:
  
  • mes15_portal_server-information-1.11.17.151103-1
  Added CMMS and renamed JMDS to MES.
  Mantis #0026184: Data list empty or not update after saving the changes (load twice).
  
  • mes15_alfresco-patch-1.11.17.151029-1
  Replace data source dbcp with c3p0.
  
  • mes15_lbleng-admin-view-2.0.151110-1
  
  • mes15_lbleng-view-2.0.151110-1
  
  • mes15_shop-order-control-2.0.151111-1
  Fixed an issue that prevents a serial number from being assigned to a new route after serial number assignment.
  Fixed an incorrect “Wrong Serial Number Format” validation on serial number assignment.
  
  • mes15_sfdc-config-2.0.151111-1
  Fixed Part x Route list paging issue.
  Fixed Data Collector Maintenance list paging issue.
  Fixed validation and format issues on attribute import/export.
  
  • mes15_mlc-maintenance-2.0.151111-1
  Performance enhancements.
  
  • mes15_algorithm-tool-2.0.151020-1
  Fixed issues to add Week Custom algorithm elements.
  
  • MES15_MESWeb.4.1.15.111415
  Added column “Ref Designator” to Defect Serial report.
  Value “oracle_route_id” added to the PCB Unit History report.
  The “About” attribute was added to the home class and the release notes property was added to the file appsetting.
  Added validation to null values when exporting to CSV Unit History report.
  Added source key to part number and customer to convert to unique key (p.part_key+p.source_key)
  Changed process to extract measurement data from measurement webservice to support the new functions on measurement db.
  Improved performance when exporting Unit History with Measurement data.
  Fixed an issue that was causing missing data in columns.
  Fixed a bug that generated a wrong query on Defect Serials report.
  Fixed a bug that led to the app crashing in the TP Serials report.
  
  SPC Server Side:
  
  • mes15_quality_spc-server-1.2.151014-1
  Improve SPC DB schema connection pool to reduce connection amount (spring-applicationContext-spc.xml change).
  
  • mes15_quality_spcdbconfig-1.2.151013-1
  Improve SPC DB schema connection pool to reduce connection amount.
  
  October 2015
  
  Production Release of MES15 [MES 15.2.1.2]
  Improvements/Bug Fixed:
  
  For Cirrus
  
  MES Portal Side:
  
  • mes15_portal_portlet-setting-hook-1.11.14.150831-1
  Fixed "No Such Group" issue
  
  • mes15_sfdc-portlet-1.11.7.150820-1
  SR#2782684: queryDocListAction very slow in Cirrus corpmesprtl1 , Avg time (ms): 33,500.
  Mantis#27769 Document Mapping portlet couldn't save changes on the Start and End page.
  
  • mes15_portal_android-maintenance-hook-1.11.9.150626-1
  WR#192184: Android App market development.
  
  • mes15_portal_android-device-maintenance-1.11.10.150810-1
  WR#192184: Android App market development.
  Mantis#0027732: Error prompt info shaded by the Add device window.
  Mantis#0027696: No translation location in two android maintenance portlets.
  Mantis#0027597: Last Sync time display error issue.
  Mantis#0027596: Search device by status issue.
  Mantis#0027695: ""Type"" display null when edit android device.
  Mantis#0027696: No translation location in two android maintenance portlets.
  Improve language translation for en_US, zh_CN."
  Add more translation for en_US, zh_CN8.
  Add language translation for en_US, zh_CN.
  Change to local dynamic ip if alfresco ip is wrong.
  Add permission control to APK Maintenance portlet and Device Maintenance portlet.
  Move portlet category to Administration.
  Modify spec to copy alfresco xml/webscript to destination.
  
  • mes15_portal_patch-1.11.15.150921-1
  Mantis#0027763: Import .lar file failed after upgraded packages and restart liferay.
  Mantis#0027344: “Sanmina Universal Login” disappear at login page.
  Mantis#26594: NonLDAP user login failed prompt account locked.
  Mantis#27079: LDAP User's Job title is incorrect.
  
  • mes15_pts-portlet-1.2.5.150925-1
  SR#2792508: Missing production lines - Production Setup ( GUI display issue )
  Fixed not set default IP & port from local storage issue after printed labels.
  AML upload function enhancement for manufacture name and manufacture pn can be empty at same time.
  Add FUJIFLEXAPGO,SIEMENS,PHILIPS machine model.
  Fixed data length exceed than columns issue for Upload BOM & AML.
  Update Application Resource for es_MX language
  Add loading list report function at the Ezpicklist.
  Display deleted feeder with green color.
  Add plant code for some URL of Hand Placement portlet.
  Phanton BOM (Convert from ASP to Cirrus )
  Split Label enhancement with reprint original label.
  
  • mes15_shop-order-control-2.0.150902-1
  Fixed an issue that prevented users from assigning a revision to a shop order at the release when the create skeleton option is checked.
  Fixed an issue with the release notes not being updated on the Shop Order information in Shop Order Browser.
  Fixed the unit scan date/time display on the Shop Order Information screen.
  
  PTS Server Side:
  
  • pts-ws-2.1.1.150925-1
  Improve sql 'queryBoardHandlingMaxBakeTime' to not filter floor_life and msd_start_time comparison.
  AML upload function enhancement for manufacture name and manufacture pn can be empty at same time.
  Add more machine type ("FUJIFLEXAPGO,PHILIPS,SIEMENS" ) for ezpicklist web.
  Set for file upload max size to 10M.
  Update Application Resource for es_MX language.
  Fixed Production Setup page display 25 records issue.
  Add loading list report function at the Ezpicklist
  Resolve issue while production online processing validation 'Location:X and device:Y aleady online
  in line:Z' the filter condition is changed from 'line_id' to 'line_id' and 'ws_id'.
  Display deleted feeder with green color.
  Phanton BOM ( Convert from ASP to Cirrus )
  Split Label enhancement with reprint original label.
  
  MDS:
  SR#2837901: Oracle-MES Interaced - Job Not Moving OP Seq in Oracle
  Fixed Map by Process option to trigger WIP moves.
  Updated version of downseqsosn2.p
  Updated library with enhanced log printing.
  
  SFDC:
  • mes15_sfdcsfdc1.11.7.1509161
  Mantis#0027823: Shutdown MDS request executor thread when stop/restart sfdc service.
  Mantis#0027867: Non serial batch flow error after split batch.
  Mantis#0027800: Change socket log format for multithreading issue trace.
  Mantis#0027699: Change the channel count from 5 to 1.
  
  (Note: Since mes15_sfdcsfdc1.11.7.1507291 and later version, the default channel count has been changed from 5 to 1 so we will no longer need to manually update the setting from the sfdcinit.tpl file. However, on the Production if there are plants who have particularly used 5 as the default value for high volume business, we will need to manually change the setting from 1 to 5 for them after the upgrade)
  
  Anroid side:
  • appgarden-20150720-1.apk
  
  September 2015
  
  CR#47215 Production Release of MES15 [MES 15.2.1.1]
  Improvements/Bug Fixed:
  
  For Cirrus
  MES Portal side:
  • mes15_sfdc-config-2.0.1509021
  Fixed an issue on attribute maintenance that prevented users from saving multiple attribute steps.
  Improved part BOM upload performance.
  Improved part defect opportunities upload performance.
  Fixed search in Multi-Pass Locations in the Data Collector screen.
  Fixed Sample Plan counter reset issue.
  Fixed "copy and paste" issues on comboxbox components.
  Enhanced Part Number import performance.
  Added support to CSV, HTML, PDF and XLS export file formats.
  Assembly Maintenance: Added support to Custom Component type.
  Route Maintenance: Fixed an issue that prevented user from add subroute steps.
  Shop Floor Id: Added a logic to ensure that a user can only update the SFDC Clients assigned to MDS database of the current logged SITE.
  SR#2652325: Added a loading mask for the combobox fields and improved the code to get locations for multiple source fields all at once.
  i18n support.
  Attribute Maintenance: Enhancements on Copy window and reset.
  SR# 2546899: Assembly Maintenance: Fixed a bug on assembly export functionality.
  Data Collector: Fixed a bug in the main grid paging.
  Record Component: Business Logic review.
  Revision Change: Usability enhancements. Fixed wrong messages on Summary section.
  Defect Code: Fixed a bug in the Defect Codes’ import routine when desired file had one of following chars "[]\\^$.|?*+(),"
  
  •mes15_mlc-maintenance-2.0.1508281
  Added PTS non-serialized command (available per customization only).
  Improved the performance of the Container Browser screen.
  Prevent users from containerizing an element twice.
  Added support to CSV, HTML, PDF and XLS export file formats.
  SR#2694225: Container loses its revision when it is reopened and closed.
  Container Browser performance enhancements.
  P23191 PG COPS Replacement Export Container file format review. New logic for Order Line information based on Business Model (ATO, and NonATO).
  SR#2694225: Container loses its revision when it is reopened and closed.
  SR#2695567: Cannot print container # via Label Engine system.
  i18n support
  Added support to pallet sheet printing.
  WR#180152: [Measurement] E55 BloodHound / Custom Containerization App
  
  • mes15_shop-order-control-2.0.1508281
  SR#2802270: Fixed an issue that prevented users from assigning multiple serial numbers (from order to B) through Serial Number Assignment
  SR#2800606: Fixed an issue with file downloading.
  Fixed the "copy and paste" issue on comboxbox components.
  Added support to CSV, HTML, PDF and XLS export file formats.
  Refactored the delete unstarted units and delete shop order features to be unit archive aware.
  MI#26929: Some Serial Number cannot be printed on Shop Order Browser.
  P23191 PG COPS Replacement
  Added Manual Sales Order Request feature.
  More information on Sales Order information.
  Changed the WIP traveler report to fit the requirements.
  i18n support.
  Show Operation Sequence's Op Code information on Shop Order portlet.
  Shop Order Information, new file for "User Defined".
  
  August 2015
  
  Production Release of MES15 [MES 15.2.1] Xcellerator / MESWeb 4.1
  Improvements/Bug Fixed:
  
  For Cirrus
  SFDC PC Side:
  • mes15_sfdc-sfdc-1.11.7.150710-1
  WR#183757: Xcellerator - Multi-threading changes
  WR#186518: Consolidate upload commands development and test
  SR#2621853:When using Cirrus portal Part change function created duplicate s/n"
  WR#186519: EMVDNLD and Socket Log changes."
  WR#178127: DTC IN USE.
  WR#181620: Login Reset for SFDC v1.10.
  WR#182742: SFDC holds all PNs when SPC monitor sends SPC Hold.
  WR#186804: Re-build packages to v1.11
  WR#192380: Make changes to SFDC 7.03 in order to support new component type
  WR#188652: SRX - Sampling failures
  Mantis#0026218: NON serialize batch qty error after sfdc dnld empty."
  Mantis#0026456: System time couldn’t get updated when doing SFDC restart.
  Mantis#0026253: MERGBSN action record display in wrong way.
  Fix the upload order issue, including the functions of uphpu, upSampleLog, upSamplePlan
  Resolve the network problem
  Change the interface to muti-line mode for !!command
  Removed the logic of non-serialized batch automatically calling SPLTNBSN
  Mantis#0027615: Missed Component part number at upcomp2 for Custom Component
  SR#2762722: BE - Component assembly-key >999
  Mantis#0027551: RPCMP and RPCMP2 dislays 'New comp_id?' on the next-to location
  Mantis#0027502: mes15_sfdc-sfdc-1.11.7.150618-1]Replace Comp_id fail (issue of RPCMP and RPCMP2 reset sfdc device and cause re-login)
  SR#2740821: MESWEB Wrong History display (activity.i1 issue)
  
  • mes15_sfdc-db-schema-1.11.7.150527-1
  WR#192380: Make changes to SFDC 7.03 in order to support new component type
  WR#186519: EMVDNLD and Socket Log changes.
  WR#186518: Multi-threading and consolidated up command changes
  WR#186804: Re-build packages to v1.11
  
  • mes15_sfdc-webservice-1.11.7.150305-1
  WR#188711: [MES Android] APK Issue List Follow up and Fix
  WR#186519: EMVDNLD and Socket Log changes
  WR#186804: Re-build packages to v1.11
  WR#186395: [PCB] To Support Location Description for Each location
  Mantis#26432: EV Expiration Date Mismatch
  Mantis#0026326: Socket log is empty
  To fix the issue of APK: poor performance. Description: when scanning serial number at APK side, "Wait!" message for 1 or 2 minutes.
  
  • mes15_sfdc-tomcat-log-1.11.7.150120-1
  WR#186804: Re-build packages to v1.11
  
  • mes15_sfdc-autosfdc-1.11.7.150120-1
  WR#186804: Re-build packages to v1.11
  
  • mes15_sfdc-install-1.11.7.150120-1
  WR#186804: Re-build packages to v1.11
  
  • mes15_sfdc-nagios-1.11.7.150120-1
  WR#186804: Re-build packages to v1.11
  
  • mes15_sfdc-sanm-repo-1.11.7.150120-1
  WR#186804: Re-build packages to v1.11
  
  • mes15_sfdc-sudo-patch-1.11.7.150120-1
  WR#186804: Re-build packages to v1.11
  
  Portlet side:
  • mes15_sfdc-portlet-1.11.7.150729-1
  WR#193495: [Agile/MES Integration] Updated Value Validation with Implemented Value
  WR#193013:[PCB] Engineering Notes Missing at MESWEB Report
  WR#192774:[Agile/MES Integration] Part Number list of Values Match with MES
  WR#192773:[Agile/MES Integration] Mapping should not be deleted once Implememented
  WR#192771:[Agile/MES Integration]Keep the index until deviation """"Implement""""
  WR#192770:[Agile/MES Integration] One Acknowledgement per Cover Page"""
  WR#192772: [Agile/MES Integration] More Serials should be able to be Added.
  WR#189508: Multi-language support for sfdc portlets
  WR#189082: [Agile/MES Integration] Cover Page and Deviation Mapping for BE
  WR#187446: [Agile / MES Integration] To Support Unit QTY for Deviation
  WR#187304: [PCB] Engineering Notes for Independent Route Option
  WR#187159: [PCB] Support to Display Work Order Units for Rework Step
  WR#186644: [PCB] To Support Engineering Notes Mapping under Route Independence
  WR#186804: Re-build packages to v1.11
  Mantis#0027204: [mes15_sfdc-portlet-1.11.7.150515-1]Upload Gencad fail.
  Mantis#0027159: eManual not send out alert mail when WI will be expired
  Mantis#0027084: document type is not the type be defined in document type portlet.
  Mantis#0027143: Agile PN document mapping failure.
  Mantis#0027159: eManual not send out alert mail when WI will be expired.
  Mantis#0027160: Fail to check PDF by URL
  Mantis#0027062: Upload document, when select shop floor id, always be first.
  Engineering notes missing issue for MESWEB
  Mantis#0027159: eManual not send out alert mail when WI will be expired.
  Mantis#26406: sfdc portlet System Information widget, 'MDS' label change to 'IP'"
  Mantis#0026421: Upload PDF by URL - Fail to Save
  Mantis#0026379: Task Scheduler will remove all created tasks after one task has been executed or updated.
  Mantis#26394: Historical Yield/Defects doesn't show date range."
  Mantis#0026383: Label Display Issue.
  Mantis#0026379: Task Scheduler will remove all created tasks after one task has been executed or updated."
  SR#2623725: Emulator display all locations.
  Mantis#0027692: Fail to upload .cad file.
  
  MES Portal side:
  
  • mes15_sfdc-config-2.0.150806-1
  Fixes Sample Plan counter reset issue.
  Fixes "copy and paste" issues on comboxbox components.
  Enhances Part Number import performance.
  Adds support to CSV, HTML, PDF and XLS export file formats.
  Assembly Maintenance: Added support to Custom Component type.
  Route Maintenance: Fixed an issue that prevented user from add sub-route steps.
  Shop Floor Id: Added a logic to ensure that a user can only update the SFDC Clients assigned assigned to MDS database of the current logged SITE
  SR#2652325: Added a loading mask for the combo-box fields and improved the code to get locations for multiple sources fields all at once.
  i18n support.
  Attribute Maintenance: Enhancemets on Copy window and reset.
  Assembly Maintenance: Fixed a bug (SR# 2546899) on assembly export functionality.
  Data Collector: Fixed a bug in the main grid pagging.
  Record Component: Business Logic review.
  Revision Change: Usability enhancements. Fixed wrong messages on Summary section.
  Defect Code: Fixed a bug in the Defect Codes's import routine when desired file had one of following chars "[]\\^$.|?*+(),"
  
  • mes15_kv-production-2.0.150806-1
  Fixes UI resize issues on chrome.
  Adds support to CSV, HTML, PDF and XLS export file formats.
  Fixes T472 : No S/N available on "Kit Processing by Serial Number" screen.
  Fixes T473 : Print Traveler report - Problem on Serialized Components.
  Defined default defect (KVDC), sympton (KVSC) and repair (KVRC) codes. These codes can be adjusted by admins.
  Fixed T460 : The Component Mask Validation is case sensitive, and by definition, component id are upper case. The system must make the input all upper case automatically.
  
  • mes15_mlc-maintenance-2.0.150806-1
  Prevents users from containerizing an element twice.
  Adds support to CSV, HTML, PDF and XLS export file formats.
  SR#2694225: Container loses its revision when it is reopened and closed.
  Container Browser performance enhancements.
  P23191 PG COPS Replacement - Export Container file format review. New logic for Order Line information based on Business Model (ATO, and Non-ATO).
  SR#2694225: Container loses its revision when it is reopened and closed.
  SR#2695567: Cannot print a container # via Label Engine system.
  i18n support
  Added support to pallet sheet printing
  WR#180152: [Measurement] E55 BloodHound / Custom Containerization App
  
  • mes15_serialized-item-tracker-2.0.150806-1
  General performance improvement.
  Adds support to CSV, HTML, PDF and XLS export file formats.
  Added support to SFDC Attributes and new its new Mask (Data Type) validation on Receiving SN range.
  Performance Improvements
  i18n support.
  Fixed "Add Attribute" activity wrong attribute number information.
  Fixed serial number sort in every screen.
  
  • mes15_shop-order-control-2.0.150806-1
  Fixes the "copy and paste" issue on comboxbox components.
  Adds support to CSV, HTML, PDF and XLS export file formats.
  Refactored the delete unstarted units and delete shop order features to be unit archive aware.
  Mantis#26929 - Some Serial Number cannot be printed on Shop Order Browser.
  P23191 PG COPS Replacement.
  Add Manual Sales Order Request feature.
  More information on Sales Order information.
  Changed the WIP traveler report to fit on the requirements.
  i18n support.
  Show Operation Sequence's Op Code information on Shop Order portlet.
  Shop Order Information, new file for "User Defined".
  
  • mes15_Sanm.MESWeb.Central.View-1.0.150730-1
  Bundles translated to Spanish and Chinese.
  Report builder
  Import multiple users in User screen and Mapping User Group in User Group screen.
  Internationalization
  Manage permission to User Group.
  Manage permission by Data Source to User and User Group.
  New parameter: Long Location List Box.
  Connect to oracle DB.
  Fix error msg when saving an invalid sql code
  Fix misspelling Data source type label.
  The name of the default value in the checkbox parameter was changed by "val" to match with model.
  Fix DB Conn issue - translate the wrong message to Spanish.
  Fix DB Conn issue - when set a wrong ip
  Fix labels without internationalization.
  Fixed error messages that were not being displayed properly.
  Fixed bugs about security manager permission: Display locations according to the role assigned to the user.
  Display the Customer tab to User group permission.
  Hidden add pre-report.
  Execute DD from the History.
  Allow to map pre defined reports to SOMS.
  Allow to delete a unused Location.
  
  • mes15_sanm.mesweb.central.view-1.01.141121
  Location module
  Data source module
  Report module (publish and pre-defined reports functionalities only)
  Report groups module
  User module
  
  • MES15_MESWeb.4.1.1.011215
  Scheduler Snapshots.
  RTY Report.
  Predefined reports for pcb(fit wip report,pcb Unit history).
  Second grouping level to Wip distribution.
  
  •MES15_MESWeb.4.1.2.020515
  The problems with Workstation Monitor report.
  Parameter Rate failed with decimals.
  Target was calculated bad and the colors.
  
  • MES15_MESWeb.4.1.3.030215
  Customer mapping to show only the available part numbers.
  Header for Measurement on Unit History.
  Customer mapping to show only the available part numbers.
  Line filer parameter.
  Customer drop down list parameter.
  RTY process global process.
  Timezone for Top defect evolution and Yield evolution reports.
  
  •MES15_MESWeb.4.1.4.032315
  Formatting excel columns on custom reports.
  long workstation parameter.
  Export in Yield & Defect report.
  Timezone for parameter selected on exports.
  
  • MES15_MESWeb.4.1.5.032515
  Issues with schedules, the issues was that it didn't save the files in a ftp server.
  Timezone for parameter selected on exports.
  Field file name in schedule was modified to allow put the current date also it is able to put only a part of a current date.
  Condition way to get the component on unithistory.Component class.
  SnapShotDateTime
  In HourValue and MinuteValue, the date was initializing in the milliseconds instead of Hour/minute. Set methods were changed.
  SnapShotDateRange Seconds was hardcoded to 0.
  
  • MES15_MESWeb.4.1.6.051515
  Validation to avoid nulls values in the file's name.
  
  •MES15_MESWeb.4.1.7.052215
  Unit history measurement updated to add new columns.
  PCB Unit history With eng. notes and instructions.
  Yield and defect dates issue.
  External and Internal application working with the same files configurable from the database.
  Export excel 2007 working to all reports
  
  • MES15_MESWeb.4.1.8.071015
  Be Cell Print MFG Report.
  Container Pick list Report.
  Monitoring resources with javamelody.
  Save execute reports as Sanapshot and schelude in the activity database.
  Yield and defect dates issue.
  Change Export to excel 2007.
  
  • MES15_MESWeb.4.1.9.072215
  The CheckBoxParameter class in the com.sanmina.mesweb.core.context package was removed , now the reports are using the CheckBoxParameter class in the com.sanmina.mesweb.core.context.reports package, this changed is to have the same core project in central and execution.
  Set the application timezone when the datasource is a postgres database.
  
  • MES15_MESWeb.4.1.10.080615
  The date was added at file's name when the all reports when are exported.
  The action column was added correctly on the Yield & Defect report.
  Set the application timezone when the datasource is a postgres database.
  Fixed Lot Unit History.
  Fixed problem when the Container Number not exists, exception was captured.
  The JsonProperty "moduleSelect" was added to validate if the serials are containers, lots or pallets in client side and can show the correct information.
  The method "exportToExcel2007" was added to RTY report.
  The total yield field is calculated correctly in the export method to RTY report.
  In the export method to RTY report was added the cell to show the product when the report is filter by Global Process/Product or Local Process/Product.
  Custom format to the CSV export to the Unit History report.
  PTS Side:
  
  • mes15_ptsportlet1.2.4.1506291
  MSD- completed condition to stop floor life issue.
  Added searching by WO condition for MSD Board Expired report.
  Scan Board Touch added the report to show the scanning board status information.
  New ezpicklist portlet supports the Fujicampgo and Panasonic, Universal, Fujiflexaxml, Handload format without Java Applet.
  New label printing portlet- label printing, label reprint, print sub-label, split/transfer label without Java Applet.
  NOTE: PTS db v3.47 and web service PTS Web Service v2.1.0.1506291 required.
  
  • MESInterface v2.0.2
  Add the MSD data into the VerifierPTS interface.
  Master Part Number register.
  Customized parts remaining time for warning remind.
  Enhance the table default value.
  This version need to work with the PTS DB schema v3.48.
  
  • PTS Web Service v2.1.0.150629-1
  WR#194352: Unable to print PTS material label.
  SR#2714921: Feeder Registry Error
  MSD Complete condition to stop floor life issue.
  Add searching by WO condition for MSD Board Expired report.
  Scan Board Touch need to add the report to show the scanning board status information.
  New ezpicklist portlet suport the Fujicampgo and Panasonic, Universal, Fujiflexaxml, Handload format without Java Applet
  New label printing portlet label printing, label reprint, print sublabel, split/transfer label without Java Applet
  Control the Load Material & Scan Board for the migration by project
  NOTE: This version need to work with the PTS DB schema v3.47 or above and portlet version mes15_ptsportlet1.2.4.1506291.
  
  For Legacy v6.3:
  
  • sfdc3-6.3-02
  WR#189486: Multi-threading and consolidated testing for SFDC 6.1
  SR#2740821: MESWEB: Wrong History display (activity.i1 issue)
  
  • sfdc-db-schema-6.3-01
  WR#189486: Multi-threading and consolidated testing for SFDC 6.1
  
  • sfdc-collector-gui-6.1-02
  Compatible with project Xcellerator, no code change
  
  • sfdc-webservice-1.4-22
  Compatible with project Xcellerator, no code change
  
  • autosfdcxml-2.14-08
  Compatible with project Xcellerator, no code change
  
  • sfdc-batchprocess-gui-6.1-02
  Compatible with project Xcellerator, no code change
  
  • sfdc-local-web-6.1-03
  Compatible with project Xcellerator, no code change
  
  • sfdc-command-gui-6.1-02
  Compatible with project Xcellerator, no code change
  
  • sfdc-install-1.0-04
  Compatible with project Xcellerator, no code change
  
  May 2015
  
  Production Release of MES15 [MES 15.2.0] Portal 1.11
  Improvements/Bug Fixed:
  MES Portal Side:
  
  • mes15_mlc-maintenance-1.4.150421-1
  SR#2695567: Cannot print a container # via Label Engine system.
  SR#2694225: Container loses its revision when it is opened and closed.
  Mantis#26926: Container loses its revision when it is reopened and closed.
  Open and Close a Container without touching its elements.
  Print Label Engine label by Multi-level Container.
  Container Browser performance enhancements.
  P23191 PG COPS Replacement - Export Container file format review. New logic for Order Line information based on Business Model (ATO, and Non-ATO).
  
  • mes15_shop-order-control-1.4.1500421-1
  Mantis#26929: Some Serial Numbers cannot be printed on the Shop Order Browser.
  Print MDS Label by Shop Order Browser.
  Refactored the delete unstarted units and delete shop order features to be unit archive aware.
  P23191 PG COPS Replacement:
  - Add Manual Sales Order Request Feature
  - More Information on Sales Order Information
  - Changed the WIP Traveler Report to fit on the requirements.
  • mes15_sfdc-portlet-1.11.7.150414-1
  WR#189508: Multi-language support for sfdc portlets
  WR#189082: [Agile/MES Integration] Cover Page and Deviation Mapping for BE
  WR#187446: [Agile / MES Integration] To Support Unit QTY for Deviation
  WR#187304: [PCB] Engineering Notes for Independent Route Option
  WR#187159: [PCB] Support to Display Work Order Units for Rework Step
  WR#186644: [PCB] To Support Engineering Notes Mapping under Route Independence
  WR#186460: [PCB] Engineering Notes History For MESWEB
  SR#2623725: Emulator display all locations
  Mantis#26406: sfdc portlet System Information widget, 'MDS' label change to 'IP'"
  Mantis#0026421: Upload PDF by URL - Fail to Save
  Mantis#0026379: Task Scheduler will remove all created tasks after one task has been executed or updated
  Mantis#26394: Historical Yield/Defects doesn't show date range
  Mantis#0026383: Label Display Issue
  Mantis#0026379: Task Scheduler will remove all created tasks after one task has been executed or updated
  Mantis#26394: Historical Yield/Defects doesn't show date range
  Document Mapping By Agile Release Date.
  Hourly sync job - provide the function on "Download& Service" under SFDC portlet to manually execute syncing
  Hourly sync job - support to show the sync backend log at "System Logs" under SFDC portlet.
  Deviation time based - By Agile Deviation Number when mapping start/end date are empty
  By Agile Deviation Number - Mapped deviation Mark as mapped as in By Agile Release Date option, the lack of this same function allows to map the same deviation multiple times.
  
  • mes15_sfdc-config-1.3.150421-1
  SR#2652325: Product Route-Cannot see Location List
  SR#2546899: Assembly Export to .csv
  Mantis#26774: Shop Floor ID lists all Shop Floor clients for all sites. Should be a filtered list.
  Shop Floor ID: Added a logic to ensure that a user can only update the SFDC clients assigned to MDS database of the current logged site.
  Added a loading mask for the combo-box fields and improved the code to get locations for multiple source fields all at once.
  Assembly Maintenance bug fix for assembly export functionality and added support to Custom Command type.
  Route Maintenance: Fixed an issue that prevented the user from adding sub-route steps.
  Attribute Maintenance enhancements on Copy window and reset.
  Data Collector bug fix in the main grid paging.
  Record Component business logic review.
  Revision Change enhancements. Fixed wrong messages on Summary section.
  Defect Code bug fix in the import routine when a desired file has one of the following characters: “[]\\^$.|?*+(),”
  Fixed T460: The Component Mask Validation is case sensitive, and by definition, Component IDs are upper case. The system must make the input all upper case automatically.
  
  • mes15_portal_portlet-setting-hook-1.11.3.150326-1
  WR#185572: Alpha or non numeric character supported at Oracle
  WR#186872: Support Configurable Email Server
  WR#187927: To Support to deactivate User if Supervisor Empty
  Mantis#26595: Assigned users are removed from the site sometimes
  Add audit report when session expired or user logout.
  Improve web path get method.
  
  • mes15_portal_mes-portal-db-schema-upgrade-1.10.6.150122-1
  PTS failed to add sever at server information portlet.
  
  • mes15_portal_server-information-1.11.2.150311-1
  WR#189078: SFDC Uniqueness Control under Server Info.
  WR#186078: [Agile/MES Integration] To Support External Agile Server.
  Mantis#0026570: Check SFDC status can't display in status field.
  
  • mes15_portal_mes-migration-1.11.1.150213-1
  WR#185572: Alpha or non numeric character supported at Oracle
  
  • mes15_portal_user-maintenance-1.11.3.150323-1
  WR#185572: Alpha or non numeric character supported at Oracle.
  WR#188124: Impersonating User Failure.
  Mantis#26640: Search user shouldn't distinguish uppercase and lowercase.
  Mantis#26595: Assigned users are removed from the site sometimes.
  
  • mes15_portal_site-maintenance-1.11.4.150331-1
  WR#189077: Portal Profile should Apply to New Site
  WR#189078: SFDC Uniqueness Control under Server Info
  WR#184595: MESWEB Link no Overwriting when Synnchronizing Site
  WR#189077: Portal Profile should Apply to New Site
  Mantis#26595: Assigned users are removed from the site sometimes (enhance add site logic)
  Delete missing pages when syncing sites
  
  • mes15_portal_patch-1.11.4.150409-1
  Support multiple porltet title.
  
  • mes15_mlc-configuration-1.4.150419-1
  SR#2689309: Copy Multi-level Container Configuration keeps the reference to the original dimension table.
  Mantis#26922: Multi-level Configuration > Copy the Container Config > Dimensions must not be changed.
  Copy Multi-level Container Configuration keeps the reference to the original dimension table.
  Fixed a dimension’s form layout on Container Configuration form.
  
  • mes15_serialized-item-tracker-1.4.150421-1
  IR: Important performance enhancements.
  Added support to SFDC Attributes and new its Mask (Data Type) validation on Receiving SN range.
  
  • mes15_portal_profile-maintenance-1.11.4.150416-1
  SR#2691080: Increase Ajax connection timeout, fix possible define permissions page show blank.
  Add exception catch for web action (to print log for profile operations).
  
  SFDC PC Side:
  
  • mes15_sfdc-sfdc-1.11.7.150403-1
  WR#183757: Xcellerator - Multi-threading changes
  WR#186518: Consolidate upload commands development and test
  SR#2621853: When using Cirrus portal Part change function created duplicate s/n"
  WR#186519: EMVDNLD and Socket Log changes."
  WR#178127: DTC IN USE.
  WR#181620: Login Reset for SFDC v1.10.
  WR#182742: SFDC holds all PNs when SPC monitor sends SPC Hold.
  WR#186804: Re-build packages to v1.11
  Mantis#0026218 NON serialize batch qty error after sfdc dnld empty."
  Mantis#0026456 System time couldn’t get updated when doing SFDC restart.
  Mantis#0026253 MERGBSN action record display in wrong way.
  Fix the upload order issue, including the functions of uphpu, upSampleLog, upSamplePlan.
  Resolve the network problem.
  Change the interface to muti-line mode for !!command.
  Removed the logic of non-serialized batch automatically calling SPLTNBSN.
  
  • mes15_sfdc-db-schema-1.11.7.150120-1
  WR#186519: EMVDNLD and Socket Log changes.
  WR#186518: Multi-threading and consolidated up command changes
  WR#186804: Re-build packages to v1.11
  
  • mes15_sfdc-webservice-1.11.7.150305-1
  WR#188711: [MES Android] APK Issue List Follow up and Fix
  WR#186519: EMVDNLD and Socket Log changes
  WR#186804: Re-build packages to v1.11
  WR#186395: [PCB] To Support Location Description for Each location
  Mantis#26432 EV Expiration Date Mismatch
  Mantis#0026326 Socket log is empty
  To fix the issue of APK: poor performance. Description: when scanning serial number at APK side, "Wait!" message for 1 or 2 minutes.
  
  • mes15_sfdc-tomcat-log-1.11.7.150120-1
  WR#186804: Re-build packages to v1.11
  
  • mes15_sfdc-autosfdc-1.11.7.150120-1
  WR#186804: Re-build packages to v1.11
  
  • mes15_sfdc-install-1.11.7.150120-1
  WR#186804: Re-build packages to v1.11
  
  • mes15_sfdc-nagios-1.11.7.150120-1
  WR#186804: Re-build packages to v1.11
  
  • mes15_sfdc-sanm-repo-1.11.7.150120-1
  WR#186804: Re-build packages to v1.11
  
  • mes15_sfdc-sudo-patch-1.11.7.150120-1
  WR#186804: Re-build packages to v1.11
  
  PTS Side:
  
  • PTS Web Service v2.0.8.1.150206-1
  New version bug description:
  Mantis#0026376: The Replace Bar-code display information does not match with the real situation.
  Mantis#0026387: The Feeder type history feature does not work properly.
  
  • mes15_ptsportlet1.2.3.1504291
  SR#2650175: fixed the Board In Model time data display issue.
  Mantis#0026574: Body Thickness default value is 0.01 in Manufacturer Info.
  Mantis#0026572: Should transfer lower case to capital letter in Workstation Maintenance function.
  BOM Export
  BOM/PN Upload
  Multiple Language support (Chinese, Portuguese, partial Hungarian and partial Spanish).
  OWMSPTS interface MSD default value bug, changed from mane mandatory to optional.
  Resolved process_number issue while creating first production setup record.
  Improved search function in define pick list when search pick list value is empty.
  (Portal) Material queue code improve for MATERIAL_QUEUE_PREVIOUS_MATERIAL_CONFIRM
  NOTE: PTS db v3.47 and web service ptsws2.0.9.1505081 required.
  
  • mes15_ptsportlet1.2.2.1505251
  Added the enhancement for the Touch Load Material & Scanning Board.
  Fixed the Label Locator displaying issue
  NOTE: PTS db v3.46 and web service ptsws2.0.8.2.1504241 required.
  
  • DB version 3.47
  CREATE SEQUENCE IF NOT EXISTS seq_bom_export_config_id
  CREATE TABLE IF NOT EXISTS bom_export_config
  Add MATERIAL_QUEUE_PREVIOUS_MATERIAL_CONFIRM configuration
  CREATE SEQUENCE seq_ic_program_config_id
  CREATE TABLE ic_program_config
  CREATE INDEX ic_program_config_bom_pn_id_idx
  CREATE SEQUENCE seq_ic_program_id
  CREATE TABLE ic_program
  CREATE INDEX ic_program_component_id_idx
  CREATE INDEX ic_program_component_id_idx
  CREATE INDEX ic_program_original_pn_id_idx
  CREATE INDEX ic_program_program_pn_id_idx
  CREATE SEQUENCE seq_indirect_material_config_id
  CREATE TABLE indirect_material_config
  CREATE INDEX indirect_material_config_bom_pn_id_idx
  ALTER TABLE part_number_ext ADD COLUMN application_instance character varying(24) not null default ;
  ALTER TABLE part_number_ext_log ADD COLUMN application_instance character varying(24) not null default ;
  Add APPLICATION_INSTANCE_CONTROL configuration
  Add APPLICATION_INSTANCE_TYPE configuration
  NOTE: This v3.47 is Compatible for mes15_ptsportlet1.2.3.1504291 or above version.
  
  • DB version 3.46
  CREATE INDEX user_info_upper
  Add the INSPECTION_BEFORE_LABELING configuration
  CREATE SEQUENCE seq_table_ext_id
  CREATE TABLE table_ext
  CREATE INDEX table_ext_tablename_fieldname_idx
  ALTER TABLE component_1 ADD COLUMN package_type_id integer not null default 0;
  CREATE SEQUENCE seq_accept_property_id
  CREATE TABLE accept_property
  ALTER TABLE accept_property OWNER TO grp_admin;
  Add the accept_property configuration
  Add fujitrax_control configuration
  ALTER SEQUENCE seq_package_type_id1 RESTART WITH 50;
  Add FEEDER_FULL_MAINTENANCE_USAGE configuration
  ALTER TABLE tooling ADD COLUMN full_maintenance_current_usage integer not null default 0;
  CREATE OR REPLACE FUNCTION query_wip_part(integer, integer, integer)
  ALTER FUNCTION query_wip_part(integer, integer, integer)
  NOTE: This v3.46 is Compatible for mes15_ptsportlet1.2.020141021 or above version.
  
  • PTS Web Service v2.0.9.150508-1
  SR#2650175: fix the Board In Model time data display issue.
  Mantis#0026574: Body Thickness default value is 0.01 in Manufacturer Info.
  Mantis#0026572: Should transfer lower case to capital letter in Workstation Maintenance function.
  BOM Export
  BOM/PN Upload Replacement.
  Multiple Language support ( Chinese, Portugese, partial Hungarian and partial Spanish )
  OWMSPTS interface MSD default value bug, change it from mane mandatory to optional.
  Resolve process_number issue while creating first production setup record.
  Improve search function in define pick list when search pick list with empty value
  (Portal)Material queue code improve for MATERIAL_QUEUE_PREVIOUS_MATERIAL_CONFIRM
  NOTE: PTS DB schema v3.47 or above and portlet version mes15_ptsportlet1.2.3.150429 required.
  
  • PTS Web Service v2.0.8.2.1504241
  Fix the SFDCPTS local mapping integration scanning issue.
  NOTE: PTS DB schema v3.4.6 or above and portlet version mes15_ptsportlet1.2.2.1505251 required.
  
  January 2015
  
  OVERVIEW: CR#xxxxx - Patch release - MES15 SFDC Version 1.10. This release may be used by all non-medical plants.
  New feature:
  - SR#2612362: eManual doesn't display docs - Cirrus Portal
  - SR#2621853: When using Cirrus portal Part change function created duplicate s/n
  SFDC PC rpm Package:
  - mes15_sfdc-sfdc-1.10.7.150122-1.i386.rpm
```
Step 1: yumconfig
- Enter YUM FTP Server IP, [172.18.72.200]: 172.18.72.200
- Enter YUM FTP Server User Name, [sfdc3]: sfdc3
- Enter YUM FTP Server Password: ******
Step 2: sfdc3 stop
Step 3: rpm -e --nodeps mes15_sfdc-sfdc
Step 4: yum clean all 
Step 5: yum install mes15_sfdc-sfdc-1.10.7.150122-1
Step 6: sfdc config
Step 7: sfdc dnld (also attribdnld and emvdnld if needed)
Step 8: sfdc start
```
  SFDC Portlet rpm Package:
  - mes15_sfdc-portlet-1.10.7.150109-1.i386.rpm
```
Step 1: rpm -qa|grep MES15_SFDC_portlet (to check if there is any old sfdc-portlet rpm packages installed with MES15 prefix)
Step 2: rpm -qa|grep mes15_sfdc-portlet (to check if there is any sfdc-portlet rpm packages installed with mes15 prefix but are not latest)
Step 3: rpm -e --nodeps MES15_SFDC_portlet (or rpm -e --nodeps mes15_sfdc-portlet, if the server installs mes15 version of sfdc-portlet)
Step 4: <wait for about 1 minute for liferay to clean up garbage of the old package>
Step 5: yum clean all
Step 6: yum install mes15_sfdc-portlet-1.10.7.150109-1
```
  January 2015
  
  OVERVIEW:: CR#45090 - Production Release of MES15 [1.3.141113-1.i686] - Upgrade Cirrus production environments with latest code releases: Improvements and Bug Fixes.
  Improvements/Bug Fixed:
  
  MES Portal Side:
  mes15_portal_application-version
  - Supported multiple language for all functionality;
  - mes15_portal_cas-mesportal-database-support;
  - Non-LDAP user will be locked when keyin wrong password for 3 times. 15 minutes later, once correct password keyin, system still allow to login;
  mes15_portal_audit-report
  - Enhanced audit report to show records correctly;
  - Supported multiple language for all functionality;
  mes15_portal-device-maintenance-portlet
  - Supported Station ID and Device ID Selection on Android apk for PCB project;
  mes15_portal_vertical-menu-theme
  - Supported multiple language for all functionality;
  - Assign user page. Line / Page control;
  mes15_portal_server-information-hook
  - Supported multiple language for all functionality;
  - Supported document mapping with plant's NAS drive for PCB project;
  mes15_portal_portlet-setting-hook
  - Prohibited automatic account creation in portal;
  - Supported multiple language for all functionality;
  - Supported customized Cirrus Logo and customer logo;
  - Enhanced external customer supervisor email address;
  mes15_portal_profile-maintenance
  - Supported multiple language for all functionality;
  - Supported site admin to assign Portal profile to their site user;
  - Show Profile Name when Assigning User;
  - Assign user page. Line / Page control;
  mes15_portal_server-information
  - Supported multiple language for all functionality;
  - Supported document mapping with plant's NAS drive for PCB project;
  - Encrypted password when adding Agile_Account Server;
  - Supported PTS HTTPS web services link;
  mes15_portal_user-maintenance
  - Supported to view profiles which are already assigned to the user;
  - Supported to impersonate site user for Site admin;
  - Supported multiple language for all functionality;
  - Assign user page. Line / Page control;
  mes15_portal_site-maintenance
  - Supported multiple language for all functionality;
  - Removed site admin check box from site maintenance;
  - Supported customized Cirrus Logo and customer logo;
  - Assign user page. Line / Page control;
  mes15_portal_mes-welcome
  - Supported multiple language for all functionality;
  mes15_portal_plant-maintenance
  - Supported Outside Customer in one MES Portal including SANM and non-SANM plant;
  - Supported multiple language for all functionality;
  mes15_portal_mes-migration
  - Supported import user from xls or csv file;
  - Supported multiple language for all functionality;
  mes15_mlc-configuration
  - Fixed a dimension's form layout on Container Configuration form;
  mes15_mlc-maintenance
  - Added support to pallet sheet printing;
  - 180152(WR) [Measurement] E55 BloodHound / Custom Containerization App;
  mes15_serialized-item-tracker
  - Fixed "Add Attribute" activity wrong attribute number inforamtion;
  - Fixed serial number sort in every screen;
  mes15_sfdc-config
  - Attribute Maintenance: Enhancements on Copy window and reset;
  - Assembly Maintenance: Fixed a bug (SR# 2546899) on assembly export functionality;
  - Data Collector: Fixed a bug in the main grid paging;
  - Record Component: Business Logic review;
  - Revision Change: Usability enhancements. Fixed wrong messages on Summary section;
  - Defect Code: Fixed a bug in the Defect Codes's import routine when desired file had one of following chars "[]\\^$.|?*+(),";
  mes15_shop-order-control
  - Show Operation Sequence's Op Code information on Shop Order portlet;
  - Shop Order Information, new file for "User Defined";
  mes15_Sanm.MESWeb.Central.View
  Administration Module: the administrator user is able to manage the following sub-modules:
  - Location Maintenance:
  This module allows Administrators to add, edit, or delete locations. Also located in this module is the ability to add, edit, or delete server names;
  - Data Source Maintenance:
  This module allows the Administrator to add a data source based on the name, description, location, database type, and connection parameters associated to the database type;
  - Reports:
  The Reports Module was developed for employees with Security Manager (specific Location) and Administrator (all locations) roles. The Reports module allows the user to edit copy or publish reports;
  - Report Groups:
  With this module the Administrator and Security Manager users can access report group maintenance to perform searches, create, edit or delete report groups and add reports to groups;
  Access Control Module: the Access Control module was developed for employees with Administrator and Security Manager roles. With the Access Control module, the Administrator is able to search, add, delete or edit users or user groups;
  - User Maintenance:
  This module allows Administrators to manage user permissions and edit user information. With this portlet, administrators can assign Administrator permissions to specific users for assigned locations and edit the user’s information;
  
  mes15_sfdc-portlet
  - Support 'DTC in USE' message in cirrus version;
  - Support PCB plant using cirrus, enhance SFDC non-serialized batch behavior to support PCB business needs;
  - Ehnance Batch Process GUI to handle over 10,000+ active downloaded SOs;
  - Security Improvement per HPFOD;
  - SFDC LOGOUT command will still auto-login;
  - Default Document Display Not Work;
  - Fixed issue of process field not filtered by part number on document upload page;
  - Download and Services portlet - Download option out of order;
  mes15_quality_spc-portlet, mes15_spc-tv-db-schema
  - Language Bundle - add support [Spanish, Chinese ,English];
  - No any response when export lock list to excel;
  - The save button can be clicked without inputting any information in the Add Monitor Group page;
  - "rules" isn't translated in Create Monitor;
  - The Chinese interface is inconsistent with the English interface;
  SFDC PC Side:
  mes15_sfdc-sfdc
  - Support 'DTC in USE' message in cirrus version;
  - Support PCB plant using cirrus, enhance SFDC non-serialized batch behavior to support PCB business needs;
  - Enhance SFDC local attribute commands and support NEXT command;
  - Ehnance Batch Process GUI to handle over 10,000+ active downloaded SOs;
  - SFDC issue with underbar characters in location name;
  - Make the changes for Unique component as the same with non-tracked;
  - MFG hold issue;
  - EV Auto Logout at Shift End not call uphpu;
  - Container Qty issue;
  - Non-serialized batch miss saving data when recording defect;
  - Display "Invalid Entry" for invalid defect code -1;
  - SFDC holds all PNs when SPC monitor sends SPC Hold;
  - Call PTS ID return Invalid Entry error message when Add component;
  mes15_sfdc-db-schema
  - Increase route.name column size in SFDC;
  - Create a unique index on component table for batch quantity issue;
  mes15_sfdc-webservice
  - Support PCB plant using cirrus, enhance SFDC non-serialized batch behavior to support PCB business needs;
  - Ehnance Batch Process GUI to handle over 10,000+ active downloaded SOs;
  - Fixed Manual Moves issue in SFDC Portlet;
  - Fixed issue of document not display on start process;
  mes15_sfdc-sudo-patch
  - Re-build packages according to the new naming conversion;
  mes15_sfdc-autosfdc
  - Re-build packages according to the new naming conversion;
  mes15_sfdc-sanm-repo
  - Re-build packages according to the new naming conversion;
  mes15_sfdc-nagios
  - Re-build packages according to the new naming conversion;
  mes15_sfdc-install
  - Re-build packages according to the new naming conversion;
  mes15_sfdc-tomcat-log
  - Re-build packages according to the new naming conversion;
  tomcat-7.0-47.01
  - Re-build packages according to the new naming conversion;
  SPC Server Side:
  mes15_quality_spcdbconfig
  - Code change per HPFOD;
  - Defects are repeated calculated in a short time;
  - Two SPC data displayed in the same revision after edit this monitor;
  - One revisions includes all the month's input data after collect CPK/PPK by month via manual input type;
  - In the Pareto chart, user sees a No Records on the Exception tab after clicked the Affected SNs button;
  - Issues of saving 'Hide monitors with no data in chart in the past(hours)' on 'Spc System Parameter;
  - When Collection by Time, System sends out emails before the time interval ends;
  - Monitor list page can't load filter number;
  mes15_quality_spc-server
  - Single SPC server supports multiple plants;
  - Tomcat hot deployment and undeployment technique;
  PTS Side:
  
  • mes15_ptsportlet1.2.120141205
  Mantis#0026075: Cannot unload the high-value material whose DN usage is 0.001.
  Mantis#0025807: Material Run Out won’t stop and it can continue scan the board.
  Mantis#0025939: Throw out exception when update system setting.
  NOTE: PTS db v3.4.6 required.
  
  • PTS Web Service v2.0.8.1.1412041
  Mantis#0026075: Cannot unload the highvalue material whose DN usage is 0.001.
  Mantis#0025807: Material Run Out won't stop and it can continue scan the board.
  
  NOTE: PTS DB schema v3.4.6 or above required.
  
  December 2014
  
  OVERVIEW: New Features, Enhancements and Bug Fixes. This release is targeted for those of plants who already runs on cirrus Amazon cloud for non-medical. It can not be used for plants to upgrade directly from early version of SFDC to cirrus version.
  New Features:
  - WR#173808 Non-serialized Batches Changes for PCB
  - WR#180153 [PCB] Multilogin NSB requirements
  - WR#178127 No DTC in use message
  Enhancements:
  - WR#184672: [PCB] To Support to Display Available QTY for each Station
  - WR#183272: Location Key written into unit_Status-key
  - WR#182420: [PCB apk] Defect Code Order Change
  - WR#181622: SFDC Local Attribute Commands
  - WR#181163: [PCB] Change to operationSpltNBSN and createseqsonum
  - WR#179650: Package Name Change per Name Convention
  - WR#175752: Container Qty issue
  - WR#185759: [SFDC] Wrong Message for Fail to and Pass to Prompt
  - WR#180755: Batch Process GUI enhancement
  - WR#184777: Auto Login issue with EV enabled
  - WR#184327: [Agile/MES Integration] Deviation integration in cirrus.APK Beta Version
  - WR#184233: [PCB] Error message for Item status not active
  - WR#182742: SFDC holds all PNs when SPC monitor sends SPC Hold
  - WR#184120: [PCB] Non-serialized batch miss saving data when recording defect
  - WR#183912: Display "Invalid Entry" for invalid defect code -1
  - WR#182419: [SFDC] Bugs - Local Attribute Commands
  - WR#182191: [PCB] Fix Multilogin requesting the Quantity Twice
  - WR#180153: Autocmd gets executed prior to prompt split, and SFDC exits the loop for current SN transaction when manually enter 'SPLTNBSN' command
  - WR#179076: EV Auto Logout at Shift End not call uphpu
  - WR#183544: MES/Agile Deviation integration in cirrus.APK (Phrase 2)
  - WR#183268: Station ID based on SFDC Host to APK.
  - WR#183051: [Agile/MES Integration] Deviation Cover Page action in XML format
  - WR#180754: Security Improvement - HPFOD
  - WR#182669: [PCB] Engineering Notes not Display
  - WR#182322: [PCB] Auto Mapping with Plant's Network Drive
  - WR#182245: [PCB] Date & Time on the header Interface Change
  - WR#182192: [PCB] Document Mapping Portlet changes with shop order optional
  - WR#182195: [PCB] Unit ID Selection Bug Fix
  - WR#181618: [PCB] To Support Station ID and Device ID Selection on Android apk
  - WR#179529: [PCB Project] Json Interface for call to MDS from APK
  - WR#179900: Task scheduler changes
  - WR#179528: [PCB Project] To Support to Document Mapping with Plant's Drive (cont.)
  Bug Fixes:
  - Mantis#0026176: Emulator - Show 'DTC in Use' after sfdc restart
  - Mantiss#0026154: SN be in complete status, it can be scan in any location in the route
  - Mantis#0025861: Call PTS ID return Invalid Entry error message when Add component
  - Mantis#0025290: Return Connection to pts error after PRCDFC command
  - Mantis#0025953: PCB multi-login issue
  - Mantis#0025621: [PCB] SFDC shows 'Wrong Quantity' when splitting non-serialized batch
  - Mantis#25612: [PCB] SFDC couldn’t select non-serialized batch with quantity over than 100
  - Mantis#25547: [PCB] Login Reset
  - Mantis#25295: PCB - Non-serialized batch issue
  - Mantis#0025291: Route by Process changes for Flow error issue
  - Mantis#24997: No Flow Control
  - Mantis#25048: SFDC issue with underbar characters in location name
  - Mantis#25106: minor conversion issue in SFDC 7(loc_date field still exist in OperationCntnr.java)
  - Mantis#25104: Remove or replace unique component need to call upcomp2.p function
  - Mantis#25105: Make the changes for Unique component as the same with non-tracked
  - Mantis#25234: MFG hold issue
  - Mantis#0026092 SFDC doesn't show DTC in Use when user switching to unit ID.
  - Mantis#0026091 DTC IN USE - Autologout doesn't take effect
  - Mantis#0026080 User fails to update document parameter
  - Mantis#0026047 SFDC LOGOUT command will still auto-login
  - Mantis#0026045 Default Document Display Not Work
  - Mantis#0026026 Process Flow Section Issues
  - Mantis#0025963 Return HTTP Status 500 exception when export excel from system log.
  - Mantis#0025935 process not be filter by part number
  - Mantis#0025842 Batch Process is temporarily unavailable
  - Mantis#25504: Batch process ID are missing for test automation
  - Mantis#0025383 Download and Services portlet - Download option out of order.
  SFDC PC rpm Packages:
  - mes15_sfdc-db-schema-1.10.4.140923-1.i386
  - mes15_sfdc-autosfdc-1.10.2.140819-1.i386
  - mes15_sfdc-sudo-patch-1.10.2.140819-1.i386
  - mes15_sfdc-tomcat-log-1.10.2.140820-1.i386
  - mes15_sfdc-nagios-1.10.2.140820-1.i386
  - mes15_sfdc-sanm-repo-1.10.2.140820-1.i386
  - mes15_sfdc-sfdc-1.10.7.141230-1.i386
  - mes15_sfdc-webservice-1.10.7.141219-1.i386
  - mes15_sfdc-install-1.10.2.140820-1.i386
  - tomcat-7.0-47.01.i386
```
Step 1: yumconfig
- Enter YUM FTP Server IP, [172.18.72.200]: 172.18.72.200
- Enter YUM FTP Server User Name, [sfdc3]: sfdc3
- Enter YUM FTP Server Password: ******
Step 2: rpm -qa|grep MES15 (to check if there is any old rpm packages installed with MES15 prefix)
Step 3: rpm -qa|grep mes15 (to check if there is any rpm packages installed with mes15 prefix but are not latest)
Step 4: rpm -qa|grep tomcat (to check tomcat version)
Step 5: sfdc3 stop
```
  If target PC has MES15 packages installed, remove them with following section of steps:
```
Step 6: rpm -e --nodeps MES15_SFDC_sfdc MES15_SFDC_db-schema MES15_SFDC_webservice MES15_SFDC_autosfdc
Step 7: rpm -e --nodeps MES15_SFDC_sudo-patch MES15_SFDC_tomcat_log MES15_SFDC_install MES15_SFDC_nagios MES15_SFDC_sanm-repo
```
  If target PC has mes15 packages installed, remove them with following section of steps:
```
Step 6: rpm -e --nodeps mes15_sfdc-sfdc mes15_sfdc-db-schema mes15_sfdc-webservice mes15_sfdc-autosfdc
Step 7: rpm -e --nodeps mes15_sfdc-sudo-patch mes15_sfdc-tomcat-log mes15_sfdc-install mes15_sfdc-nagios mes15_sfdc-sanm-repo
```
  If target PC has installed tomcat with version under tomcat-7.0-47.01, remove it with following steps:
```
Step 8: rpm -e --nodeps tomcat
```
  Execute below steps to install latest SFDC packages:
```
Step 9: yum clean all 
Step 10: yum install tomcat-7.0-47.01 (Skip if tomcat is already with 7.0-47 therefore didn't get removed in step#8)
Step 11: yum install mes15_sfdc-sfdc-1.10.7.141230-1 mes15_sfdc-db-schema-1.10.4.140923-1 mes15_sfdc-webservice-1.10.7.141219-1 mes15_sfdc-sudo-patch-1.10.2.140819-1
Step 12: yum install mes15_sfdc-autosfdc-1.10.2.140819-1 mes15_sfdc-sanm-repo-1.10.2.140820-1 mes15_sfdc-nagios-1.10.2.140820-1 mes15_sfdc-install-1.10.2.140820-1 mes15_sfdc-tomcat-log-1.10.2.140820-1
Step 13: sfdc config
Step 14: sfdc dnld (also attribdnld and emvdnld if needed)
Step 15: sfdc start
```
  MES15 Portal 1.0 SFDC-Portlet rpm Package:
  - mes15_sfdc-portlet-1.10.7.141229-1
```
Step 1: rpm -qa|grep MES15_SFDC_portlet (to check if there is any old sfdc-portlet rpm packages installed with MES15 prefix)
Step 2: rpm -qa|grep mes15_sfdc-portlet (to check if there is any sfdc-portlet rpm packages installed with mes15 prefix but are not latest)
Step 3: rpm -e --nodeps MES15_SFDC_portlet (or rpm -e --nodeps mes15_sfdc-portlet, if the server installs mes15 version of sfdc-portlet)
Step 4: <wait for about 1 minute for liferay to clean up garbage of the old package>
Step 5: yum clean all
Step 6: yum install mes15_sfdc-portlet-1.10.7.141229-1
```
  November 2014
  
  OVERVIEW:: CR#44764 - Production Release of MES15 [1.3.141113-1] - Deployment of updated code to support E90 COPS Migration to Production.
  Improvements/Bug Fixed:
  MES15_MLC-Configuration
  - i18n support.
  - Fixed a dimension's form layout on Container Configuration form.
  MES15_MLC-Maintenance
  - i18n support.
  - Added support to pallet sheet printing.
  - Fixed a bug on containerization warning sounds player (and icon).
  MES15_Serialized-Item-Tracker
  - i18n support.
  - Fixed "Add Attribute" activity wrong attribute number information.
  - Fixed serial number sort in every screen.
  MES15_SFDC-Config
  - Attribute Maintenance:
    - Enhancements on Copy window and reset.
  - Assembly Maintenance:
    - Fixed a bug (SR# 2546899) on assembly export functionality.
  - Data Collector:
    - Fixed a bug in the main grid paging.
  - Record Component:
    - Business Logic review.
  - Revision Change:
    - Usability enhancements. Fixed wrong messages on Summary section.
  MES15_shop-order-control
  - i18n support.
  - Show Operation Sequence's Op Code information on Shop Order portlet.
  - Shop Order Information, new file for "User Defined".
  • mes15_ptsportlet1.2.020141021
  WR#178297: Please add one more data format for the Cirrus label code.
  WR#166523: Reel Inspection value check & block if failed in NXT.
  WR#177513: SFDCPTS interface not working for SFDC PC p18dc2.
  Mantis#25619: Error message email with empty information.
  Mantis#25620: High value material is not confirmed but can be used to joint material
  Mantis#25505: Material is not unloaded actually after Unload all function in Unload Material(Touch) page
  Mantis#25737: Production line cannot offline and the error message is null.
  Mantis#25786: Prompt material's package isn't opened after Load Prepare Material.
  Mantis#25785: MSD material which has already loaded to a workstation and it's MSD control is terminated cannot be unloaded now.
  Mantis#25789: A new printed MSD material which package should be opened when used in Joint Material.
  Mantis#25780: Throw out exception in Scan Barcode when the workstation name like "MSDWK2\" or others.
  Mantis#25549: Error message email with empty production line name if jointed material's qty is 0 22.
  Mantis#25550: Error message email with empty production line name and workstation name if jointed material has been held.
  Mantis# 25575: MSD control issue in Material Queue.
  Mantis#25507: High-value material issue in Material Queue.
  Mantis#25671: Spend time is blank in WIP Board Report when terminate the MSD material.
  Mantis#25632: Upload a new picklist and the workstation (Scan Point/Reflow Oven) will define the new picklist automatically.
  Mantis#25675: Default value of package type in Material Labeling is incorrect.
  Mantis#25676: Error in MSD level6 in OWMSPTS handle.
  Mantis#24520: Throw java.lang.Exception: net.sf.json.JSONException: Unquotted string 'NULL' in Material Labeling.
  Check Scan Side Match Up for Reflow Oven or Scanning Point.
  Checked a curious component qty issue, and the root cause is that current component has been jointed unsuccessfully as it is in use.
  Checked error message mail with some curious and time serial loading material data, and the root cause is that operator try loading material sometimes.
  Checked error message mail with empty information issue, and the root cause is sending mail issue while jointing material.
  Checked out the root cause that jig cannot be used normally for 2nd side case.
  Bug fix of Joint Material for old Material Qty and error message mail with empty information.
  The bug fix for Reprint when print the expired material.
  Please add one more data format for the cirrus label code WR#178297
  Coding of Long term solution for Rejected material label/MSD level6 in OWMSPTS handle
  NOTE: PTS db v3.4.6 required.
  
  • DB version 3.48
  delete from config_detail where param_code = 'FUJI_TRAX_DB_CONNECTION_STRING';
  update config_detail set param_code = 'FUJI_VERIFIER_DB_CONNECTION_STRING' where param_code ='FUJI_VERIFY_DB_CONNECTION_STRING';
  update config_detail set para_displayname = 'Fuji Verifier Connection String:', cata_id = (select cata_id from config_catagory where cata_code = 'fujitrax_control') where param_code = 'FUJI_VERIFIER_DB_CONNECTION_STRING';
  update config_detail set para_displayname = 'Fuji Profiler Connection String:', cata_id = (select cata_id from config_catagory where cata_code = 'fujitrax_control') where param_code = 'FUJI_PROFILER_DB_CONNECTION_STRING';
  NOTE: This v3.48 is Compatible for mes15_ptsportlet1.2.3.1504291 or above version and it is compatible for the MESInterface v2.0.2 or above.
  
  • MESInterface v2.0.1.1410211
  WR#166523: The Material Block enhancement to hold the material wihout sending to the Fujitrax Verifier DB.
  WR#175519: Fujitrax PTS Reel Database Transfer Issue.
  WR#177331: duplicated MPN PN for the PTSR replication.
  WR#175519: incorrect material quantity. It is the user incorrect operation error, however, it has been enhanced it at the latest PTS MES interface.
  WR#176232: Tomcat hang issue.
  The reset zero percentage configuration and apply in System Setting and MESInterface.
  Check and enhancement the high I/O consuming issue in MESInterface/PTS WEB Service.
  NOTE: PTS DB schema v3.46 required.
  
  July 2014
  
  OVERVIEW:: CCN#xxxxxx - Production Release of MES15 [1.9.140725-1] - deployment of Enhancements and Bug Fixes.
  
  MES15_SFDC
  Improvements/Bug Fixed:
  - When installing SFDC portlet, the ftp service is already installed as dependency;
  - Bug fixed for display documents (uploaded pdf) in Chrome. The bug has been fixed by removing the Mozilla specific function from docview.js that's under sfdc-portlet/js/emulator/;
  - Task Scheduler pop-up error box updated: removed the non-sense "Please addundefinedportlet!" popup message when user selects a shop floor ID from the Task Scheduler portlet;
  - Fixed an edge case on the Batch Process portlet: when employee number is 0 the Login popup displays "Please wait" message forever until user navigates away from the page, or close the browser;
  - Batch process login "sucessfully" spell mistake updated: changed the wording from 'sucessfully' to 'successfully';
  July 2014
  
  OVERVIEW:: CCN#xxxxxx - Production Release of MES15 [1.2.140708-1] - deployment of new functionalities, feature requests, Enhancements and Bug Fixes.
  
  mes15_mlc-maintenance
  Improvements:
  - Performance Enhancements;
  - Layout Enhancemets;
  mes15_gen-attribute-maint
  New Feature:
  - Added Support for non-project table generic attributes.
  - FIX: Allowed Generic Attributes with GenAttrDefinition but no GenAttr record to be shown in the form to be added.
  mes15_serialized-item-tracker
  New Feature:
  - WR#176395: New generic attribute (project:receive_sit_range_default_optional_attributes) that will control which attributes will prompted when receiving a serial number range in SIT. The default attributes are "LOT Code, Date Code, MPN". These attributes can be added to, removed, or replaced with new attribute values. Default attribute values will be comma separated items, allowing for multiple default attributes to be configured.
  Bug Fixed:
  - WR#176395: Fixed "add attribute" activity param when receiving a serial number range in SIT.
  mes15_sfdc-config
  Bug fixing:
  - Comp location key remains when changing assembly type General Enhancements on Mfg Hold and Revision Change;
  Improvements:
  - Layout Enhancements;
  mes15_shop-order-control
  New Feature:
  - WR#176182: New Generic Attributes (shop_order:oracle_release_default_options and shop_order:standard_release_default_options) that will control which options are checked by
  default in Shop Order Release Wizard. Available options: "create_skl, non_sn_batch, def_rev, def_order_line, def_usl, print_label, create_file, create_notes, print_unit_trav, print_wip_unit_trav, print_order_trav, link_so";
  Bug Fixing:
  - Fixed Release Wizard cross browser layout issues;
  Improvements:
  - Sales Order Browser and Order Line SN Assign enhancement;
  PTS Side:
  
  MESInterfacev2.0 mesinterface2.0.0031914
  - Support multiple plant feature for both OPI (OraclePTS interface) and Fuji Verifier PTS interface.\
  PrintQ version v3.0 printq3.0.0031114
  - Support multiple plant feature.
  PTS Web Service Module version 2.0.7051914
  - SR#2412776: New Label Reprint Receive Date Error and the P/N description filed not print at the label.
  NOTE: PTS Portlet MES15_PTSPortlet1.1.0031114 or above and PTS DB v3.4.5 or above required.
  
  PTS Web Service Module version 2.0.7031914
  - WR#158759: Need option to Hold under MPN and Material on hold in PTS
  - WR#156828: PTS Load Material enhancement
  - WR#151876: Feeder half year maintenance request
  - Provide the Scanning integration WEB Service with Workstation name (no need location mapping.
  - Support multiple plant web service.
  - Support the different Timezone.
  NOTE: PTS Portlet MES15_PTSPortlet1.1.0031114 or above and PTS DB v3.4.5 or above required.
  
  PTS Web Service Module version 2.0.6
  - Enhance update the Manufacturer PN description at the ERPPTS web service.
  PTS Web Service Module version 2.0.5
  - Add the Location parameter at the ERPPTS web service.
  PTS Web Service Module version 2.0.4
  - New ERPPTS web service (special customized interface).
  PTS Web Service Module version 2.0.3.2
  - Fixed the Virtual RT and Label printing issue.
  PTS Web Service Module version 2.0.3.1
  - Fixed the user account information for the Touch Load/Unload Material.
  PTS Web Service Module version 2.0.3
  - Insert the OWMS COO data filed into the PTS database.
  PTS Web Service Module version 2.0.2
  - Work BOM bug fixed for Material Where Used report.
  - Panasonic & GSM picklist enhancement.
  PTS Web Service Module version 2.0.1
  - OWMSPTS Null exception handling.
  PTS Web Service Module version 2.0.0
  - Restful web service format for SFDCPTS scanning mapping.
  - Restful web service format for SFDCPTS Repair.
  - New PTS web service for Java conversion function.
  - New MDSPTS Work BOM Interface.

Internal:42Q Detailed Release Notes

Contents

Introduction

***June 2019***

April 28, 2019

February 9, 2019

December 15, 2018

November 15, 2018

November 10, 2018

November 1, 2018

***October 2018***

September 2018

August 2018

July 2018

May 2018

***March 2018***

January 2018

November 2017

October 2017

September 2017

August 2017

July 2017

June 2017

May 2017

April 2017

January 2017

October 2016

July 2016

***April 2016***

March 2016

February 2016

***December 2015***

November 2015

October 2015

September 2015

August 2015

May 2015

January 2015

January 2015

December 2014

November 2014

July 2014

July 2014

Navigation menu

Search

June 2019

October 2018

March 2018

April 2016

December 2015