Internal:42Q Detailed Release Notes

Cirrus > Cirrus Release Notes

The following release notes were created to communicate with customers and clients the details of changes or enhancements made to the Cirrus 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.

October 2016

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

Cirrus APK 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

July 2016

Production Release of MES15 [MES 15.3.1] Portal [1.3-01]

Improvements/Bug Fixes

For Cirrus

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 cirrus 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 Cirrus, (E85 & NSN)
  1. 3 Edit Traceability Code - (Shop Order Browser Information)
• Add a function in Cirrus 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 Cirrus, (E85 & NSN)
  1. 3 Edit Traceability Code - (Shop Order Browser Information)
• Add a function in Cirrus 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 Cirrus 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 Cirrus SPC can not use
• SR#3017120: SPC issue - can not create monitor
• SR#2968735: SPC Cirrus 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 Cirrus 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 Cirrus 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 Cirrus 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 Cirrus SPC can not use

• SR#3017120: SPC issue - can not create monitor
• SR#2968735: SPC Cirrus 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: Cirrus 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>".

cirruspsql.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

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 22 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 02 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 14 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 25 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 08 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.