Commit Graph

  • 51da9ef7c2 http, hurl for api testing extra-files phares@iscn5cg20977xq 2025-08-21 11:28:11 -07:00
  • 722bc63bdb Changed VOID and PACKAGING LOT_EVENTS to COMMENT type events. Modified code to only add them if lot is in new LOT table. master Infineon\StieberD 2025-08-20 16:27:11 -07:00
  • 1f2777cd18 Updated service to pass in a user id when placing a lot on hold Infineon\StieberD 2025-08-20 15:29:52 -07:00
  • 10bf8bf878 Consolidated OPEN to LOT_START. Consolidated INCREASE_WAFER_QTY to BONUS_WAFER_QTY. Fixed bug in Lot_Services. Fixed bug in Copy_Lot_Operation_Record_To_SQL. Infineon\StieberD 2025-08-20 15:22:48 -07:00
  • 1a572a31b2 modified legacy lot operation logging to be per lot instead of per date and legacy operation Infineon\StieberD 2025-08-20 10:42:18 -07:00
  • 098f740585 Removed lot events for non-epipro RDS lots in lieu of logging Infineon\StieberD 2025-08-20 10:00:43 -07:00
  • 89bb3e479b Reworded the error to be inclusive of all missing metrology results from WO_MAT_QA record Infineon\Ouellette 2025-08-18 15:01:04 -07:00
  • 60522d74c1 Improvements suggested by Daniel. Infineon\Mitchem 2025-08-18 10:43:33 -07:00
  • 3561b41a7b Resolve rebase oddities. Infineon\Mitchem 2025-08-18 09:56:58 -07:00
  • a636198128 Create new services. Infineon\Mitchem 2025-07-10 08:26:17 -07:00
  • adc247fd4c added CHRON_ID to LOT_EVENT table to have a sequential integer for debugging Infineon\StieberD 2025-08-13 15:53:30 -07:00
  • a094971d7d ErrorMsg wasn't initialized. Added initialization at the top of the service Infineon\Ouellette 2025-08-15 18:39:12 -07:00
  • 47b54f6a16 Had an instance of an RDS being deleted. Looking into root cause. Interim fix including blocking ALL RDS deletions. Infineon\Ouellette 2025-08-17 17:51:09 -07:00
  • 804258a167 Mona_Services was interferring with error checking and returning. Used buffered error message to return and error properly Infineon\Ouellette 2025-08-15 17:44:26 -07:00
  • 6d552ab824 Added error checking to scan_services to check for null wo_mat records Infineon\Ouellette 2025-08-15 17:27:29 -07:00
  • 2fbf41d528 re-order the error checking Infineon\Ouellette 2025-08-15 16:29:58 -07:00
  • ba2faa8c9f Found most likely root cause of WO_MAT records getting cleared at 1UNLOAD. Infineon\Ouellette 2025-08-15 16:24:37 -07:00
  • 0a2d53d173 added delete from sql routines for LOT_EVENT and related tables Infineon\StieberD 2025-08-15 14:37:27 -07:00
  • 844de71599 removed temporary 1D scan allowance that was in place to exhaust existing inventory with old labels Infineon\StieberD 2025-08-14 16:51:30 -07:00
  • 494988d394 Restored obj_RDS('MetPropFlag') to previous version for performance reasons. Refactored Supplement_Services to improve performance. Infineon\StieberD 2025-08-14 13:15:21 -07:00
  • e1c7544fac Fixed bug for new PSN stage met tests Chase Tucker 2025-08-08 11:45:22 -07:00
  • 6d5c9c0ab7 removed code to add LOT_EVENT records for legacy WO_MAT log events Infineon\StieberD 2025-08-13 16:31:38 -07:00
  • a8dff61cfa Enhanced Error Checking Infineon\Ouellette 2025-08-13 14:35:00 -07:00
  • 09d2d13e63 Created methods to provide Metrology Services with JSON source for SLL Section Infineon\Ouellette 2025-08-12 17:44:49 -07:00
  • 14331fcf49 Added in missing Lot Operation Id to event records Infineon\Ouellette 2025-08-13 13:22:14 -07:00
  • 667831a003 added support for mestsa024ec Infineon\StieberD 2025-08-13 12:25:34 -07:00
  • 82b74f0b96 Enable BioRad Stratus pdsf usage phares@iscn5cg20977xq 2025-08-13 09:41:52 -07:00
  • f4f63c28e3 Added JSON body and response logging to CreateNewOrder service. Modified how reactor log comments are added for ABORT_ALARM NICA orders. Modified ABORT_ALARM solution to not trigger on WAITING_FOR_MAINTENANCE_UNSCHEDULED Infineon\StieberD 2025-08-12 16:24:12 -07:00
  • 1f2b73797b Enable BioRad pdsf usage phares@iscn5cg20977xq 2025-08-12 07:52:13 -07:00
  • 54eaf15598 Increased the MAX_NUM_CASS$ equate to 150 as we have a workorder with more than 96 WO_MAT ID's Infineon\Ouellette 2025-08-08 11:44:44 -07:00
  • fffadaa1c3 Found that the location of the cassettes being added were first being sorted in an ascending order within a LOCATE loop. Infineon\Ouellette 2025-08-07 14:55:21 -07:00
  • a6da80dc3c Revert "Created temporary workarounds to QA Metrology not getting set correctly." Ouellette Jonathan (CSC FI SPS MESLEO) 2025-08-07 18:07:28 +00:00
  • 3125225639 Created temporary workarounds to QA Metrology not getting set correctly. Infineon\Ouellette 2025-08-06 16:20:43 -07:00
  • f54331eb0e Fixed HgCV frequency bug Chase Tucker 2025-08-05 12:46:25 -07:00
  • 847483f603 Added new Stratus Qual Data Import method to stop using BioRad Qual Data Import for Stratus runs phares@iscn5cg20977xq 2025-08-04 13:28:32 -07:00
  • 88281fff05 Added a query param in GetWOMatKeys service to only get WOMat Keys that are not VOID Infineon\Ouellette 2025-08-04 17:16:16 -07:00
  • 8499d03ef8 modified update work order services to throttle better Infineon\StieberD 2025-08-01 08:26:27 -07:00
  • 3186ec1ad6 Bug fix to ensure correct WM_OUT key is identified and created. Added services to ensure WM_IN and WM_OUT indexes are maintained. Infineon\StieberD 2025-07-31 13:55:07 -07:00
  • 898f21b73d Refactored error checking to utilize ErrorMsg variable so that errors make their way back to the calling routine. Infineon\Ouellette 2025-07-29 15:54:29 -07:00
  • f7ee12a78d Fixed a bug where the ProcessProcedureQueue service would write an invalid record to the PROC_QUEUE2 table when failing to read a record. Infineon\StieberD 2025-07-30 09:48:56 -07:00
  • 475df5ba54 Minor bug fix in UpdateWorkOrderData. Modified ProcessRequest service to dump record for troubleshooting purposes. Infineon\StieberD 2025-07-30 09:24:02 -07:00
  • 28a8a10ba2 Not sure how this bug was re-introduced. 99% sure we pushed this to prod. Infineon\Ouellette 2025-07-29 16:16:32 -07:00
  • 6934799e92 Added troubleshooting logs to find cause of LBLCHK transactions going missing Infineon\Ouellette 2025-07-29 14:06:51 -07:00
  • 03f42dedea updated UpdateWorkOrderData service to correct WO_MAT records containing multiple RDS keys Infineon\StieberD 2025-07-29 13:34:57 -07:00
  • 033e3baee8 added condition to search RDS table for matching WO_MAT record to correct index Infineon\StieberD 2025-07-29 12:52:06 -07:00
  • 4bfae8e7b7 minor fix to prevent an error message from being displayed on brand new work orders Infineon\StieberD 2025-07-29 12:03:55 -07:00
  • 0f0c735023 added SYSOBJ check to the PostProcedure service to prevent invalid procedures from getting posted to the procedure queue Infineon\StieberD 2025-07-29 11:54:53 -07:00
  • 4eee1b0f0a modified check to look at WO_MAT record instead of WO_STEP to see if RDS already exists for a given cassette Infineon\StieberD 2025-07-29 11:21:43 -07:00
  • e2e8731316 Removed uneccessary transaction postings Infineon\StieberD 2025-07-29 10:52:39 -07:00
  • a21f41fd29 modified service to dispatch a single job at a time to avoid clogging up the SRP Engine Server Infineon\StieberD 2025-07-29 09:33:11 -07:00
  • 2bbc5c065d updated service to remove keys if lot is voided Infineon\StieberD 2025-07-28 15:08:11 -07:00
  • 9e54865e1e moved procedure call from WO_MAT_ACTIONS to a standalone service to avoid posting too many transactions Infineon\StieberD 2025-07-28 14:34:20 -07:00
  • c7f1f86249 SP1 Misfit bug fix Mike Phares 2025-07-25 17:41:25 -07:00
  • c89bb6b3d4 added services and triggers to manually add index transactions to keep indexes up-to-date Infineon\StieberD 2025-07-25 16:28:54 -07:00
  • 71daf317f0 Added filtering criteria to only return available met tests relevant to the current operation Infineon\Ouellette 2025-07-25 11:05:34 -07:00
  • a48f47ddc9 modified WO_REC form to select WO_MAT keys instead of relying on WO_LOG<WO_MAT_KEY> field. Infineon\StieberD 2025-07-24 16:57:21 -07:00
  • 6396264e64 added combobox dropdown options to the CALIB_LIST form Infineon\StieberD 2025-07-24 09:05:19 -07:00
  • 8f233705a2 added call to clean array to prevent null values from truncating the list Infineon\StieberD 2025-07-23 15:54:30 -07:00
  • b159e1aa27 fixed bug preventing rec rel jobs from posting if vendor code doesn't match expected vendor code Infineon\StieberD 2025-07-23 09:44:12 -07:00
  • de2e6af5f7 Merged PR 21598: Refactored receive and release codebase. Stieber Daniel (CSC FI SPS MESLEO) 2025-07-23 15:40:25 +00:00
  • 84da66ccd5 Enable SP1 pdsf usage Mike Phares 2025-07-22 08:48:23 -07:00
  • 49e77a769f Release JSON handles in SCAN_SERVICES Chase Tucker 2025-07-18 09:31:19 -07:00
  • 490bfe21d4 Modified ship label printing routine to use the epi part number instead of the customer part number. Modified UpdateFailedWafers service to use the transaction queue to avoid clobbering WO_MAT records. Infineon\StieberD 2025-07-21 15:23:52 -07:00
  • 2aaed8944e Merge branch 'master' of https://tfs.intra.infineon.com/tfs/FactoryIntegration/_git/OpenInsight Infineon\StieberD 2025-07-18 12:56:28 -07:00
  • ef104f889c Added in a check for the active flag when adding an operation to a lot. Added in material handler group to the CanUserModifyLot check Infineon\Ouellette 2025-07-17 17:20:10 -07:00
  • ea156489f1 Merged PR 21245: Added in a check for the active flag when adding an operation to a lot. Added... Ouellette Jonathan (CSC FI SPS MESLEO) 2025-07-22 00:31:04 +02:00
  • e1a44a7687 changed delimiter used for the background process queue so that all native delimiters are protected Infineon\StieberD 2025-07-18 12:08:09 -07:00
  • c890a25d46 removed hgcv pattern from control plan Infineon\StieberD 2025-07-17 13:30:23 -07:00
  • 836b8c47a9 Merged PR 21153: Updated listing of FI Label Printer IP Address Ouellette Jonathan (CSC FI SPS MESLEO) 2025-07-16 23:23:10 +02:00
  • aabd4c3a91 Merged PR 21151: Return To Fab Operations and Processing Ouellette Jonathan (CSC FI SPS MESLEO) 2025-07-16 21:17:07 +02:00
  • b607432be4 Merged PR 21055: Added two new tools at request of engineering. TBI #1 and SCOPE #6 Ouellette Jonathan (CSC FI SPS MESLEO) 2025-07-16 17:36:41 +02:00
  • 3debdce91e Revert "RDS JSON caching to minimize processing" Chase Tucker 2025-07-15 20:52:07 -07:00
  • 4689b861d7 RDS JSON caching to minimize processing Chase Tucker 2025-07-10 13:47:56 -07:00
  • 350116fddc Modified WO_MAT_ACTIONS to not block write operations if critical fields are cleared. Instead it will restore the critical values and allow the write operation to continue. Infineon\StieberD 2025-07-15 12:51:20 -07:00
  • 59aed72156 modified changed OEngine memory logging to post to MonA instead Infineon\StieberD 2025-07-15 09:41:48 -07:00
  • e97162dc1e fixed routines posting procedures with value marks instead of the new service delimiter Infineon\StieberD 2025-07-14 15:13:45 -07:00
  • 2a6c0afddf refactored codebase to not rely on WO_LOG calculated column indexes Infineon\StieberD 2025-07-11 13:27:14 -07:00
  • b53e805929 Merged PR 20879: Initial commit. Ouellette Jonathan (CSC FI SPS MESLEO) 2025-07-14 20:55:07 +02:00
  • 804b590773 added check to verify PROC_NAME exists before invoking Infineon\StieberD 2025-07-14 09:36:07 -07:00
  • cd64511871 Scanner employee caching Chase Tucker 2025-07-09 14:52:33 -07:00
  • 2226f3112b added input checking to prevent runtime errors on bad input Infineon\StieberD 2025-07-14 09:17:28 -07:00
  • 184d2c2cba cache the TW type list Chase Tucker 2025-07-09 10:58:58 -07:00
  • 5830705c7d removing HF-Strip step from Oxide Epi Parts per Mark Cousten Infineon\StieberD 2025-07-11 16:02:07 -07:00
  • 1d32ec4fbb minor bug fix to release lock if record not updated Infineon\StieberD 2025-07-11 10:44:14 -07:00
  • eb85afaf35 Updated WO_LOG_ACTIONS to also set the legacy status field in the WO_LOG table. Updated GetIQSViolationData to only update the Reactor record if something has changed. Infineon\StieberD 2025-07-11 07:59:48 -07:00
  • 269e5f9bd4 cache TW Lot JSON unless changed Chase Tucker 2025-07-08 17:33:20 -07:00
  • d4ce96337b fixed bug in GetAvailableMakeupWafers which was using the CustPartNo instead of the EpiPartNo to find available makeup wafers Infineon\StieberD 2025-07-10 09:16:00 -07:00
  • af6cd757de Remove TW_All_Signed CC dependency Chase Tucker 2025-07-02 09:54:36 -07:00
  • ce252bf885 added additional checks in WO_LOG WRITE_PRE action to only set the closes date and closed status if the work order is not already closed Infineon\StieberD 2025-07-08 11:08:54 -07:00
  • 28d5b81b30 added triggers to calculate and store the scrapped quantity of a work order and auto close the work order when the scrap quantity and ship quantity equal the total work order quantity Infineon\StieberD 2025-07-07 17:40:32 -07:00
  • 563871008e Move WO_MAT_LOG creation to background Chase Tucker 2025-07-02 12:51:06 -07:00
  • 272b2ce7d8 updated copy and delete record from sql routines to allow for a null pkey Infineon\StieberD 2025-07-07 16:13:27 -07:00
  • 14c77d9edf Merged PR 20357: Fixed typo in log object reference. Ouellette Jonathan (CSC FI SPS MESLEO) 2025-07-08 00:38:42 +02:00
  • d15cd38daf added UpdateOpenWorkOrderStatuses and UpdateWorkOrderStatus services Infineon\StieberD 2025-07-02 12:50:00 -07:00
  • e3dbea2b7a fixed service manager group name Infineon\StieberD 2025-07-07 11:48:36 -07:00
  • 01fa3f8202 fixed logic determining which wafers can be NCRed Infineon\StieberD 2025-07-03 16:55:15 -07:00
  • 98ac420462 Modified copy and delete record to sql routines to lock the queue record before attempting to prevent long running copy or delete calls form being processed more than once and wasting resources. Infineon\StieberD 2025-07-03 14:03:39 -07:00
  • 5ca3778719 VNAV bug fix Infineon\StieberD 2025-07-02 09:54:16 -07:00
  • 5d27afcd68 minor bug fix Infineon\StieberD 2025-07-01 14:41:29 -07:00
  • c786fce37b Deprecating old services. Refactored codebase to not use SwapResources GoSub. Infineon\StieberD 2025-07-01 14:14:04 -07:00