Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Manufacturing Execution System

Resolved Issues

  • Last UpdatedJan 06, 2023
  • 10 minute read

This section describes important resolved issues in MES 2023, listed by their Change Request number.

IMS 539797

Create WO from Process fails if the first operation includes a specification and the next operation has multiple entities. Cannot insert duplicate key in object 'dbo.job_spec'.

IMS 560891

Shifts not changing on some entities tracking labor.

IMS 561009

Editing a final reason for a utilization event does not change the Category; it is leaving the original one.

IMS 564097

Ending multiple jobs at one time takes a long time.

IMS 564325

Stateless API StorageExec.ReduceInv() method's Dateout parameter is not saved in the MES database.

IMS 565784

MES service is timing out when executing stored procedure sp_U_Sample_UpdateStatus.

IMS 577706

Undeploy/deploy of OCO causes rolling counters to improperly increment when using input source.

IMS 620413

The latest start time and required finish time for jobs on a multi-operation process are incorrect when percent to start is configured.

IMS 626235

Can't end a job with multiple long running jobs in the database.

IMS 644716

Entity Allowable Reason Group settings are getting cleared when viewing them and then adding a new allowable reason group to a different entity.

IMS 690874

Linking an item to a process times out when thousands of entities are associated to operations in the process

IMS 739856

The Stateless API Prod.ItemReasGrpEntLink.GetReasons method is ignoring item_id.

IMS 740518

Item and item class specification are not saved when removing another one.

IMS 805244

Create Work Order from Process times out.

IMS 826084

Control rule check is skipped when multiple entities have same characteristic, there are different request times, and the later request time sample results are recorded before the earlier sample.

IMS 826093

Middleware configuration does not accept the user in the username@domain format.

IMS 828969

Support single sign-on when MES .NET control is used in AVEVA OMI and the auto login user property is enabled.

IMS 831519

HF L00159969 for MES 6.0: On a Terminal Server node, MES middleware periodically denies connections and fails to record or read data.

IMS 834929

HF L00159969 for MES 6.2: On a Terminal Server node, MES middleware periodically denies connections and fails to record or read data.

IMS 840286

Using Australian regional settings (dd/mm/yyyy), MES Client can create a work order but cannot update a work order.

IMS 860392

Related to HF L00153970: With 64-bit applications, the error "Client Proxy configuration settings are missing" is logged.

IMS 861467

Stored procedure sp_i_Item_Cons_AddConsPostExec allows for NULL shift start time, which makes queries of the item_cons table to be slow.

IMS 888530

IMS 860392 for 6.2: Related to HF L00153970: With 64-bit applications, the error "Client Proxy configuration settings are missing" is logged.

IMS 1052245

MES service deadlock occurs when executing stored procedure sp_U_Sample_UpdateStatus while inserting a new result at the same time.

IMS 1055331

MES Web API SampleCharLink method does not provide the UOM and number of decimals properties.

IMS 1092380

Importing an attribute item with a space character using SCC is creating a record when it shouldn't.

IMS 1148093

Continuation of IMS 826084 for Xbar-Sigma chart: Control rule check is skipped when multiple entities have the same characteristic, there are different request times, and the later request time sample results are recorded before the earlier sample.

IMS 1209336

HF 826084 and 1148093 for MES 6.2: Control rule check is skipped when multiple entities have same characteristic, there are different request times, and the later request time sample results are recorded before the earlier sample.

IMS 1330272

Data Editor is showing the wrong wo_id on the Utilization tab.

IMS 1398371

The migration script for migrating from MES 5.3 to 6.0 generates the error "Cannot insert duplicate key in object 'dbo.job_history'." (multiple job positions starting at the same time).

IMS 1427402

The user has an apostrophe in their name and cannot log into MES.

IMS 1434375

An OS User was moved to a group other than local Administrator and can no longer log in to MES.

IMS 1437263

The stored procedure sp_U_Job_Hour_History_RefreshQtysAndTimes takes more than a minute to complete.

IMS 1440740

ItemProd.UpdateSpecific method cannot update created_at date.

IMS 1441052

An arithmetic overflow error occurs when converting IDENTITY to data type int in the job_hour_history table (row_id now is Big_Int).

IMS 1503396

The migration script for migrating from MES 5.3 to 6.0 generates the error "Cannot insert duplicate key in object 'dbo.job_history'." (duplicate job_event records in the original database).

IMS 1516792

Related to L00153800: Ending a paused job sets the job end utilization state when another job is still running.

IMS 1555706

Inserting messages into the rejected message table fails in Russian time zones.

IMS 1560981

Creating a new shift schedule interferes with existing calendar frequencies on other entities.

IMS 1562267

Utilization Control does not update Category fields when changing downtime reason.

IMS 1569379

Quality Web API Result (Post) to update an existing record does not flag the result as superseded.

IMS 1577968

Web API for splitting the current utilization event (Split Next) generates 3 events instead of 2 events.

IMS 1585235

IMS 1555706 for 5.3: Inserting messages into the rejected message table fails in Russian time zones.

IMS 1589005

After creating a new bom_ver for a parent item that contains a sub-item, the BOM item operation links for the sub-item are removed.

IMS 1592357

Setting OEE basis calculation to 1 (KPI per job) in the oee_exec table still calculates OEE KPIs by shift.

IMS 1595508

Job_event.quantity is an integer when it should be a real.

IMS 1605342

Reducing production of production counts recorded by the OCO fails in Operator or MDM Job Management Form because a different user is registered with the production vs reduction transaction.

IMS 1613590

HF 577706 for MES 6.1: Undeploy/deploy of OCO causes rolling counters to improperly increment when using input source.

IMS 1615207

Create Work Order from Process creates only one job for a process with a single operation and multiple entities.

IMS 1626643

In a complex process with a multilevel BOM, setting a subitem as the produced item at an operation times out.

IMS 1645833

OCO with push production on reset is recording the rollover value instead of just the incremental amount on reset command when the counter has an input source from I/O that also is changing to 0.

IMS 1655505

Related to HF IMS 805244: Create Work Order from Process fails to create job BOM records.

IMS 1677808

MES Web API Swagger JSON file for MDM updated to pass body parameters in the DirectAccess API (POST) within Work Tasks web API activity.

IMS 1679737

Shift change process timing out - slow sp_U_TPM_Stat_RefreshTimes.

IMS 1691063

Canceling a work order with jobs running on multiple job positions only cancels the job on job position 0.

IMS 1698736

Cannot set the produced item for an operation in a process with complex BOMs.

IMS 1729228

OEE KPI Control generates an error when the OEE value equals 0.

IMS 1735473

Occasionally sample status stays "Ready" even when results have been recorded. Similar to HF L00145710.

IMS 1747702

MES Web API to retrieve utilization records missing spare and category fields.

IMS 1758256

HF 560891 for MES 6.2: Shifts are not changing on some entities tracking labor.

IMS 1758257

HF 564097 for MES 6.2: Ending multiple jobs at one time takes a long time.

IMS 1758342

HF 539797 for MES 6.2: Create WO from Process fails if the first operation includes a specification and the next operation has multiple entities. Cannot insert duplicate key in object 'dbo.job_spec'.

IMS 1776370

Migration from MES 5.0 to 6.2 generates unique key constraint errors on job_history table.

IMS 1781018

Continuation of HF 1747702: MES Web API to retrieve utilization records missing spare and category fields.

IMS 1786715

In MES Client, the Add Frequency Link dialog stops populating when editing Sample Plans after opening and closing it multiple times.

IMS 1791526

HF 1679737 for MES 6.2: Shift change process timing out - slow sp_U_TPM_Stat_RefreshTimes.

IMS 1808716

Related to HF 1691063: MES Web API does not pause jobs running on multiple job positions; it can only pause the job at job position 0. Fix also includes changes from HF 1691063.

IMS 1839546

After migration to MES 6.2, the job_hour_history table might not include production counts from AddProdPostExec if the timestamp doesn't match the job record.

IMS 1847823

With large amounts of data within an hour, Purge process times with query size set to 1 hour.

IMS 1853100

Related to HF 1691063: MES Web API does not end jobs running on multiple job positions; it can only end the job at job position 0.

IMS 1860171

Cannot set the produced item for an operation in a process when the operation name is greater than 10 characters.

IMS 1869589

HF 1735473 for MES 6.2: Occasionally sample status stays "Ready" even when results have been recorded. Similar to HF L00145710.

IMS 1875623

Item Inventory Add incorrectly defaults status_cd to grade_cd in the stored procedure.

IMS 1877180

MES Client crashes when opening item specifications if the user’s access level is NULL.

IMS 1882057

vw_prod_events is much slower to execute compared with MES 2014.

IMS 1885754

Item consumption from a storage entity with ‘Multiple lots/items stored here become indistinguishable' does not set the segment_requirement_id and segment_response_id fields in the item_cons table.

IMS 1886463

Cannot register an application with AIM to call the MES Web API through a service-to-service token.

IMS 1891768

Cannot edit entity attributes in the MES Web Portal.

IMS 1903067

A new OS user cannot use MES Web API functions in Enterprise Console if they don't log in to the MES provider or MES Client application first.

IMS 1905658

An arithmetic overflow error occurs in the stored procedure that calculates statistics when characteristics have very large sample sizes.

IMS 1905962

Cloning a job does not transfer the serial_no_source field to the cloned job.

IMS 1953213

When there are multiple OCOs with storage enabled on an engine, restarting the engine might leave some OCOs in Connecting status.

IMS 1985700

On a French OS with comma as the decimal separator, MES QualityCharacteristicDetail Report generates the error "Subreport could not be shown" even with the correct security setting.

IMS 2007701

Control rule violations are triggered with first result instead of waiting for the minimum sample size before evaluating control rules.

IMS 2011639

Utilization group spare fields are not loaded in the MES Client editor.

IMS 2030255

Modifying the start time of the shift schedule for the active shift to an earlier time is updating the current shift's start time, causing an overlap with a previous shift.

IMS 2060346

The JobExec.AddConsDirect method logs created_at_local in the server time zone instead of the entity's site time zone.

IMS 2070351

job_bom Spare fields are truncated when creating WO from process, splitting, or cloning a job

IMS 2072146

The JobExec.AddProd method does not populate rmLotNo and rmSublotNo.

IMS 2076937

A pulled sample transitions from In Progress to Ready when the expiration time elapses instead of transitioning to Late.

IMS 2086178

Duplicate key error when setting the produced item for a process with complex routing.

IMS 2089008

The SRO attributes RecentSampleX.SampleStatus and .ControlRuleViolation have a 10-second delay.

IMS 2141338

HF 1330272 for MES 6.2: Data Editor is showing the wrong wo_id under the Utilization tab.

IMS 2160659

Calling Pause Job with no job information (only job position) fails to pause the job.

IMS 2160919

Required finish time for jobs created from a process with two initial operations do not match.

IMS 2198972

Shift breaks are missing in the shift_to_go table for shifts that span across midnight.

L00143038

Upgrades will fail if a table with a same name but different schema exists in MES database.

L00149773

expiry_date column is recorded in local time only.

L00149839

Milliseconds are not stripped off from the created_at_local and created_at_utc fields in the item_prod table.

L00151587

Sample generation offset automatically shifts after midnight - Added new Start Delay option for Calendar Frequency.

L00152300

When MES Service is changing shifts for a site not in the same timezone as where it is running, the records in shift_history are being created either before or after they should be.

L00152573

Creating an instance of Sample Recording Object (SRO) logs unhandled errors when there is a default Area defined. The work around is to not have a default area or to ignore the messages.

L00152703

Slowness in calling the API Prod.ItemProcessLink.Add method after many items and BOMs are linked.

L00153893

The ItemInv.Add method does not accept NULL for grade and state - Method marked as obsolete and documentation improved.

L00155839

Memory leak in Internet Explorer11/MS Edge when staying on a collection page such as line collection or work order collection. This is a Microsoft known issue and is addressed in the Chromium version of Edge.

L00157474

Incorrect timestamp values are recorded to the job_event table when recording backflush consumption.

L00157709

Setting 'Log storage entity changes' is not logging changes to spare_intx in the storage_ent_transfer table.

L00158123

The following properties of the imported OMI apps cannot be saved in the OMI configuration (fixed in OMI 2020 R2):

  • CDKPIFilter and ReasonGroupColors in the Counts and Duration control

  • OEEKPIFilter in the OEE KPI control

  • UtilizationFilter in the Utilization control

L00158991

The Prod.Sublot.Rename method does not work when there is inventory.

L00159022

Using PEM attributes in the OCO objects to report production/consumption for the same jobs on different entities at the same time results in not being able to stop the second job.

L00159062

Jobs running for over a month take a long time to end and can time out.

L00159144

Users are unable to log in to MES Client when one of the OS Groups to which the user belongs is deleted.

L00159262

HF L00159062 for MES 6.1: Jobs running for over a month take a long time to end and can time out.

L00159359

Pausing/suspending a job in the MES Client Job Queue does not update certain fields in the job and job_history tables.

L00159432

Deploying OCO with a PEM instance that references 'MyContainer' causes warnings in the logger.

L00159500

OCO Job attributes are stuck in the initializing state after a reboot.

L00159604

MES Client APR will crash if an archive job is created and then the system parameter for the Archive Root Directory is changed.

L00159669

When selecting an entity class in MES Client, the attributes are not updated.

L00159775

Related to CR L00159262: Changing the utilization event for an entity that has been in the same state for over a month takes 1 minute.

L00159891

When production is recorded during the first seconds of a new shift (shift change in progress), the shift information logged is for the previous shift, not the new one.

L00159969

On a Terminal Server node, the MES middleware periodically denies connections and fails to record or read data.

TitleResults for “How to create a CRG?”Also Available in