06/29/2022 01:02:44: Starting job 06/29/2022 01:02:44: Begin SyncIn: Multi Repo Import: Hold to Shared Create PT1 - UAT 1: Item_Staging, 2: Product_Staging Option: Encoding: UTF-8 Sync Language: en Check Column Count: false Check Column Data Type: false Validate After SyncIn : true Produce Export of Errors: false Send SavedSet to Workflow: false Check Required Attributes: false Disallow Null Primary Keys: false Auto-Generate sequence values: true Produce SavedSet of Removed Items: false Check for changed data before Update: false Worksheet Number (for Excel input only): 0 Keep Repository Values if source data is null: false Update Primary Key columns for existing items: false Force 1st-Time Sync (bulk insert; no updates or duplicate checks): false Check For Non-Primary Key Data Errors (multiple repository import only): false Check For Business Key Data Errors: false Create Items Only (no update allowed) for repository Product_Staging: true Create Items Only (no update allowed) for repository Item_Staging: true Update Items Only (no insert allowed) for repository Product_Staging: false Update Items Only (no insert allowed) for repository Item_Staging: false SavedSet: NewHoldRecords06/29/2022 01:02:32 Job FileName: //PIM-APP01/shared/Imports/holdCreate-20220629010233952.csv Error FileName: //PIM-APP01/logs/import/syncInErrorRowscf9f93e2-7b70-4673-8bd2-124542b4ac7d.csv Import FileName: //PIM-APP01/shared/Imports/holdCreate-20220629010233952.csv Alternate Primary Keys: true Delete Custom File when completed: false Allow Insert With Alternate Primary Keys and Auto-Sequence Generation: false Allow External Triggers: true Is Deduplication Process Import: false Item_Staging Mapped Columns: COLUMN NAME: Feature - Benefit Bullet 01 MAPPED TO: Feature - Benefit Bullet 01 COLUMN NAME: Feature - Benefit Bullet 10 MAPPED TO: Feature - Benefit Bullet 10 COLUMN NAME: Vendor ID MAPPED TO: Vendor ID COLUMN NAME: Search Keywords MAPPED TO: Search Keywords COLUMN NAME: Item Length UOM MAPPED TO: Item Length UOM COLUMN NAME: US Minimum Advertised Price (MAP) MAPPED TO: US Minimum Advertised Price (MAP) COLUMN NAME: Feature - Benefit Bullet 20 MAPPED TO: Feature - Benefit Bullet 20 COLUMN NAME: Taxonomy Level 3 MAPPED TO: Taxonomy Level 3 COLUMN NAME: Feature - Benefit Bullet 08 MAPPED TO: Feature - Benefit Bullet 08 COLUMN NAME: Feature - Benefit Bullet 15 MAPPED TO: Feature - Benefit Bullet 15 COLUMN NAME: Call for Pricing MAPPED TO: Call for Pricing COLUMN NAME: Feature - Benefit Bullet 16 MAPPED TO: Feature - Benefit Bullet 16 COLUMN NAME: Manufacturer Short Name MAPPED TO: Manufacturer Short Name COLUMN NAME: Collection Name MAPPED TO: Collection Name COLUMN NAME: Item Name MAPPED TO: Item Name COLUMN NAME: Special Features MAPPED TO: Special Features COLUMN NAME: Eclipse XREF Brand Short Name MAPPED TO: Eclipse XREF Brand Short Name COLUMN NAME: Item Width MAPPED TO: Item Width COLUMN NAME: Future List Price (MSRP) Effective Date MAPPED TO: Future List Price (MSRP) Effective Date COLUMN NAME: Selling UOM MAPPED TO: Selling UOM COLUMN NAME: Manufacturer Model # (Series) MAPPED TO: Manufacturer Model # (Series) COLUMN NAME: Special Order MAPPED TO: Special Order COLUMN NAME: Country Of Origin 2 MAPPED TO: Country Of Origin 2 COLUMN NAME: Future US List Price (MSRP) MAPPED TO: Future US List Price (MSRP) COLUMN NAME: Spec Sheet URL MAPPED TO: Spec Sheet URL COLUMN NAME: Load Factor MAPPED TO: Load Factor COLUMN NAME: Future US Minimum Advertised Price (MAP) MAPPED TO: Future US Minimum Advertised Price (MAP) COLUMN NAME: Obsolete Date MAPPED TO: Obsolete Date COLUMN NAME: Prop 65 - Contains Chemicals that Cause Birth Defects (Calif Prop65) MAPPED TO: Prop 65 - Contains Chemicals that Cause Birth Defects (Calif Prop65) COLUMN NAME: Country Of Origin 4 MAPPED TO: Country Of Origin 4 COLUMN NAME: Prop 65 - Contains Chemicals that Cause Cancer (Calif Prop65) MAPPED TO: Prop 65 - Contains Chemicals that Cause Cancer (Calif Prop65) COLUMN NAME: Recall Details MAPPED TO: Recall Details COLUMN NAME: UL Listed MAPPED TO: UL Listed COLUMN NAME: Vendor Short Name MAPPED TO: Vendor Short Name COLUMN NAME: Short Description MAPPED TO: Short Description COLUMN NAME: Manufacturer Warranty MAPPED TO: Manufacturer Warranty COLUMN NAME: Standard Cost MAPPED TO: Standard Cost COLUMN NAME: Feature - Benefit Bullet 17 MAPPED TO: Feature - Benefit Bullet 17 COLUMN NAME: Prop 65 - CAS Number MAPPED TO: Prop 65 - CAS Number COLUMN NAME: Hazard Class MAPPED TO: Hazard Class COLUMN NAME: Information Effective Date MAPPED TO: Information Effective Date COLUMN NAME: Components MAPPED TO: Components COLUMN NAME: Watersense MAPPED TO: Watersense COLUMN NAME: UPC11 MAPPED TO: UPC11 COLUMN NAME: Price Sheet Number MAPPED TO: Price Sheet Number COLUMN NAME: Prop 65 - List the Chemicals contained that cause Cancer per California Proposition 65 MAPPED TO: Prop 65 - List the Chemicals contained that cause Cancer per California Proposition 65 COLUMN NAME: Marketing Copy MAPPED TO: Marketing Copy COLUMN NAME: Item Weight UOM MAPPED TO: Item Weight UOM COLUMN NAME: cUL Listed MAPPED TO: cUL Listed COLUMN NAME: Feature - Benefit Bullet 02 MAPPED TO: Feature - Benefit Bullet 02 COLUMN NAME: Item Length MAPPED TO: Item Length COLUMN NAME: CEC Certified MAPPED TO: CEC Certified COLUMN NAME: Taxonomy Level 5 MAPPED TO: Taxonomy Level 5 COLUMN NAME: Lifestyle Image URL MAPPED TO: Lifestyle Image URL COLUMN NAME: Packaging Level MAPPED TO: Packaging Level COLUMN NAME: ETL Listed MAPPED TO: ETL Listed COLUMN NAME: List Price (MSRP) Effective Date MAPPED TO: List Price (MSRP) Effective Date COLUMN NAME: DOE Certified MAPPED TO: DOE Certified COLUMN NAME: Feature - Benefit Bullet 13 MAPPED TO: Feature - Benefit Bullet 13 COLUMN NAME: Prop 65 - California Warning Label (Text) MAPPED TO: Prop 65 - California Warning Label (Text) COLUMN NAME: ASME A112_18_1 Certified MAPPED TO: ASME A112_18_1 Certified COLUMN NAME: Prop 65 - California Warning Label (Digital Asset) MAPPED TO: Prop 65 - California Warning Label (Digital Asset) COLUMN NAME: Manufacturer Part # (MPN) MAPPED TO: Manufacturer Part # (MPN) , IMPORT KEY # - 1 COLUMN NAME: Packing Group MAPPED TO: Packing Group COLUMN NAME: Sequence MAPPED TO: Hold Sequence COLUMN NAME: Prop 65 - List the Chemicals contained that cause Birth Defects per California Proposition 65 MAPPED TO: Prop 65 - List the Chemicals contained that cause Birth Defects per California Proposition 65 COLUMN NAME: Future MAP Price Effective Date MAPPED TO: Future MAP Price Effective Date COLUMN NAME: Item Status Reason MAPPED TO: Item Status Reason COLUMN NAME: Item Height MAPPED TO: Item Height COLUMN NAME: US List Price (MSRP) MAPPED TO: US List Price (MSRP) COLUMN NAME: Additional Warnings or Disclaimers MAPPED TO: Additional Warnings or Disclaimers COLUMN NAME: Package Depth MAPPED TO: Package Depth COLUMN NAME: Taxonomy MAPPED TO: Taxonomy COLUMN NAME: Warranty Period MAPPED TO: Warranty Period COLUMN NAME: ADA Compliant MAPPED TO: ADA Compliant COLUMN NAME: Install Instructions URL MAPPED TO: Install Instructions URL COLUMN NAME: UN Number MAPPED TO: UN Number COLUMN NAME: Manufacturer Category MAPPED TO: Manufacturer Category COLUMN NAME: Item Status MAPPED TO: Item Status COLUMN NAME: Item has Restrictions MAPPED TO: Item has Restrictions COLUMN NAME: Admin Notes MAPPED TO: Admin Notes COLUMN NAME: O&M URL MAPPED TO: O&M URL COLUMN NAME: Packaging Type MAPPED TO: Packaging Type COLUMN NAME: Price Sheet UOM MAPPED TO: Price Sheet UOM COLUMN NAME: Feature - Benefit Bullet 09 MAPPED TO: Feature - Benefit Bullet 09 COLUMN NAME: Feature - Benefit Bullet 22 MAPPED TO: Feature - Benefit Bullet 22 COLUMN NAME: Previous Manufacturer Model # MAPPED TO: Previous Manufacturer Model # COLUMN NAME: Package Length MAPPED TO: Package Length COLUMN NAME: Package Width MAPPED TO: Package Width COLUMN NAME: Taxonomy Level 1 MAPPED TO: Taxonomy Level 1 COLUMN NAME: Base Unit of Measure MAPPED TO: Base Unit of Measure COLUMN NAME: Master UPC MAPPED TO: Master UPC COLUMN NAME: Parts List URL MAPPED TO: Parts List URL COLUMN NAME: Feature - Benefit Bullet 12 MAPPED TO: Feature - Benefit Bullet 12 COLUMN NAME: Prop 65 - California Warning Required MAPPED TO: Prop 65 - California Warning Required COLUMN NAME: Assembly Instruction Video Link - URL MAPPED TO: Assembly Instruction Video Link - URL COLUMN NAME: Source Code MAPPED TO: Source Code COLUMN NAME: Alternate Image URL4 MAPPED TO: Alternate Image URL4 COLUMN NAME: Market Availability Date MAPPED TO: Market Availability Date COLUMN NAME: Restrictions MAPPED TO: Restrictions COLUMN NAME: Does this Product Have a Warranty MAPPED TO: Does this Product Have a Warranty COLUMN NAME: Primary Image URL MAPPED TO: Primary Image URL COLUMN NAME: Package Depth UOM MAPPED TO: Package Depth UOM COLUMN NAME: Item Width UOM MAPPED TO: Item Width UOM COLUMN NAME: IMAP Exempt MAPPED TO: IMAP Exempt COLUMN NAME: Item Height UOM MAPPED TO: Item Height UOM COLUMN NAME: MAP Price Effective Date MAPPED TO: MAP Price Effective Date COLUMN NAME: Feature - Benefit Bullet 21 MAPPED TO: Feature - Benefit Bullet 21 COLUMN NAME: Taxonomy Level 4 MAPPED TO: Taxonomy Level 4 COLUMN NAME: cETL Listed MAPPED TO: cETL Listed COLUMN NAME: Package Weight UOM MAPPED TO: Package Weight UOM COLUMN NAME: SEO Keywords MAPPED TO: SEO Keywords COLUMN NAME: Item has MSDS (SDS) MAPPED TO: Item has MSDS (SDS) COLUMN NAME: Title 20 Compliant MAPPED TO: Title 20 Compliant COLUMN NAME: Taxonomy Level 6 MAPPED TO: Taxonomy Level 6 COLUMN NAME: GTIN (Global Trade Item Number) MAPPED TO: GTIN (Global Trade Item Number) COLUMN NAME: Country Of Origin 3 MAPPED TO: Country Of Origin 3 COLUMN NAME: Eclipse Description Basic MAPPED TO: Eclipse Description Basic COLUMN NAME: UNSPSC Code MAPPED TO: UNSPSC Code COLUMN NAME: Package Length UOM MAPPED TO: Package Length UOM COLUMN NAME: UPC12 MAPPED TO: UPC12 COLUMN NAME: Feature - Benefit Bullet 18 MAPPED TO: Feature - Benefit Bullet 18 COLUMN NAME: Normalized Manufacturer Name MAPPED TO: Manufacturer Name COLUMN NAME: Web Description MAPPED TO: Web Description COLUMN NAME: Feature - Benefit Bullet 04 MAPPED TO: Feature - Benefit Bullet 04 COLUMN NAME: Net Package Quantity UOM MAPPED TO: Net Package Quantity UOM COLUMN NAME: CSA Certified MAPPED TO: CSA Certified COLUMN NAME: Future Discount Class MAPPED TO: Future Discount Class COLUMN NAME: Dark Sky MAPPED TO: Dark Sky COLUMN NAME: Feature - Benefit Bullet 03 MAPPED TO: Feature - Benefit Bullet 03 COLUMN NAME: Feature - Benefit Bullet 14 MAPPED TO: Feature - Benefit Bullet 14 COLUMN NAME: Manufacturer Subcategory MAPPED TO: Manufacturer Subcategory COLUMN NAME: Taxonomy Level 2 MAPPED TO: Taxonomy Level 2 COLUMN NAME: Is Recalled MAPPED TO: Is Recalled COLUMN NAME: Eclipse Description Enriched MAPPED TO: Eclipse Description Enriched COLUMN NAME: Warranty Type MAPPED TO: Warranty Type COLUMN NAME: Item Weight MAPPED TO: Item Weight COLUMN NAME: Feature - Benefit Bullet 19 MAPPED TO: Feature - Benefit Bullet 19 COLUMN NAME: Item Depth UOM MAPPED TO: Item Depth UOM COLUMN NAME: Package Height UOM MAPPED TO: Package Height UOM COLUMN NAME: Purchase UOM MAPPED TO: Purchase UOM COLUMN NAME: Recommended or Related Items MAPPED TO: Recommended or Related Items COLUMN NAME: Package Height MAPPED TO: Package Height COLUMN NAME: Hazardous per DOT MAPPED TO: Hazardous per DOT COLUMN NAME: Feature - Benefit Bullet 05 MAPPED TO: Feature - Benefit Bullet 05 COLUMN NAME: SDS URL MAPPED TO: SDS URL COLUMN NAME: Reportable Quantities MAPPED TO: Reportable Quantities COLUMN NAME: Item Status Notes MAPPED TO: Item Status Notes COLUMN NAME: Alternate Image URL3 MAPPED TO: Alternate Image URL3 COLUMN NAME: Feature - Benefit Bullet 07 MAPPED TO: Feature - Benefit Bullet 07 COLUMN NAME: Net Cost MAPPED TO: Net Cost COLUMN NAME: Package Width UOM MAPPED TO: Package Width UOM COLUMN NAME: Energy Efficient MAPPED TO: Energy Efficient COLUMN NAME: Is Kit MAPPED TO: Is Kit COLUMN NAME: Alternate Image URL2 MAPPED TO: Alternate Image URL2 COLUMN NAME: Item Depth MAPPED TO: Item Depth COLUMN NAME: Alternate Image URL5 MAPPED TO: Alternate Image URL5 COLUMN NAME: UN Proper Shipping Name MAPPED TO: UN Proper Shipping Name COLUMN NAME: EAN (European Article Number) MAPPED TO: EAN (European Article Number) COLUMN NAME: Vendor Description MAPPED TO: Vendor Description COLUMN NAME: Feature - Benefit Bullet 06 MAPPED TO: Feature - Benefit Bullet 06 COLUMN NAME: Minimum Purchase Quantity MAPPED TO: Minimum Purchase Quantity COLUMN NAME: Net Package Quantity MAPPED TO: Net Package Quantity COLUMN NAME: Country Of Origin 1 MAPPED TO: Country Of Origin 1 COLUMN NAME: Warranty Type of Effective Date MAPPED TO: Warranty Type of Effective Date COLUMN NAME: All Feature Bullets MAPPED TO: All Feature Bullets COLUMN NAME: Package Weight MAPPED TO: Package Weight COLUMN NAME: Feature - Benefit Bullet 11 MAPPED TO: Feature - Benefit Bullet 11 COLUMN NAME: Eclipse XREF Manufacturer Short Name MAPPED TO: Eclipse XREF Manufacturer Short Name COLUMN NAME: TSCA Title VI Compliant MAPPED TO: TSCA Title VI Compliant COLUMN NAME: Alternate Image URL1 MAPPED TO: Alternate Image URL1 COLUMN NAME: Normalized Manufacturer Brand Name MAPPED TO: Manufacturer Brand Name , IMPORT KEY # - 2 COLUMN NAME: Title 24 MAPPED TO: Title 24 COLUMN NAME: Discount Class MAPPED TO: Discount Class COLUMN NAME: Required Parts MAPPED TO: Required Parts Product_Staging Mapped Columns: COLUMN NAME: Normalized Manufacturer Brand Name MAPPED TO: Manufacturer Brand Name , IMPORT KEY # - 2 COLUMN NAME: Manufacturer Model # (Series) MAPPED TO: Manufacturer Model # (Series) , IMPORT KEY # - 1 COLUMN NAME: Product Name MAPPED TO: Product Name COLUMN NAME: Normalized Manufacturer Name MAPPED TO: Manufacturer Name COLUMN NAME: Taxonomy MAPPED TO: Taxonomy Begin SyncIn for importConfig: Hold to Shared Create PT1 - UAT 06/29/2022 01:02:44: Start reading data 06/29/2022 01:02:44: Done reading data 06/29/2022 01:02:44: Initialized 1 batches in 57ms 06/29/2022 01:02:44: Starting batches 1 Row 16: This row not updated due to import selections. Manufacturer Model # (Series): 4875.80, Manufacturer Brand Name: Viega Row 18: This row not updated due to import selections. Manufacturer Model # (Series): LE280T, Manufacturer Brand Name: Bradford White Row 20: This row not updated due to import selections. Manufacturer Model # (Series): RE250T, Manufacturer Brand Name: Bradford White Row 22: This row not updated due to import selections. Manufacturer Model # (Series): LE330S, Manufacturer Brand Name: Bradford White 06/29/2022 01:02:44: Processed batch 1 in 229ms 06/29/2022 01:02:50: Product_Staging: Sync In Process Succeeded! 06/29/2022 01:02:50: Processed 7 records 06/29/2022 01:02:50: Begin SyncIn batches for: Item_Staging 06/29/2022 01:02:50: Starting batches 2 Error during batch processing: Error saving repository data record: . User "system" (1) in session 121150599 does not have permission to create this record in repository "Item_Staging" with permission 16435.; retrieval qry=select * from UPDATES_138305_0 where item_id in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) order by item_id Error during batch processing: Error saving repository data record: . User "system" (1) in session 121150599 does not have permission to create this record in repository "Item_Staging" with permission 16435.; retrieval qry=select * from UPDATES_138305_0 where item_id in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) order by item_id Error during batch processing: Error saving repository data record: . User "system" (1) in session 121150599 does not have permission to create this record in repository "Item_Staging" with permission 16435.; retrieval qry=select * from UPDATES_138305_0 where item_id in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) order by item_id Error during batch processing: Error saving repository data record: . User "system" (1) in session 121150599 does not have permission to create this record in repository "Item_Staging" with permission 16435.; retrieval qry=select * from UPDATES_138305_0 where item_id in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) order by item_id Error during batch processing: Error saving repository data record: . User "system" (1) in session 121150599 does not have permission to create this record in repository "Item_Staging" with permission 16435.; retrieval qry=select * from UPDATES_138305_0 where item_id in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) order by item_id Error during batch processing: Error saving repository data record: . User "system" (1) in session 121150599 does not have permission to create this record in repository "Item_Staging" with permission 16435.; retrieval qry=select * from UPDATES_138305_0 where item_id in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) order by item_id Error during batch processing: Error saving repository data record: . User "system" (1) in session 121150599 does not have permission to create this record in repository "Item_Staging" with permission 16435.; retrieval qry=select * from UPDATES_138305_0 where item_id in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) order by item_id Error during batch processing: Error saving repository data record: . User "system" (1) in session 121150599 does not have permission to create this record in repository "Item_Staging" with permission 16435.; retrieval qry=select * from UPDATES_138305_0 where item_id in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) order by item_id Error during batch processing: Error saving repository data record: . User "system" (1) in session 121150599 does not have permission to create this record in repository "Item_Staging" with permission 16435.; retrieval qry=select * from UPDATES_138305_0 where item_id in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) order by item_id Error during batch processing: Error saving repository data record: . User "system" (1) in session 121150599 does not have permission to create this record in repository "Item_Staging" with permission 16435.; retrieval qry=select * from UPDATES_138305_0 where item_id in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) order by item_id Error during batch processing: Error saving repository data record: . User "system" (1) in session 121150599 does not have permission to create this record in repository "Item_Staging" with permission 16435.; retrieval qry=select * from UPDATES_138305_0 where item_id in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) order by item_id Error during batch processing: Error saving repository data record: . User "system" (1) in session 121150599 does not have permission to create this record in repository "Item_Staging" with permission 16435.; retrieval qry=select * from UPDATES_138305_0 where item_id in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) order by item_id Exception during batch #2 processing: Invalid object name 'B_SYNCIN_BATCH_138305_2'.; retrieval qry=select * from UPDATES_138305_0 where item_id in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) order by item_id 06/29/2022 01:02:54: SyncIn process failed to complete 06/29/2022 01:02:56: SyncIn process failed to complete SYNC_JOB_ERROR 06/29/2022 01:02:56: Processed 0 records Number of Items with Data Truncation Errors: 0 06/29/2022 01:02:56: Ending job 06/29/2022 01:02:56: Begin Validation: Option: All Items Repository: Item_Staging Validation Type: Items from Saved Set Saved Set: NewHoldRecords06/29/2022 01:02:32 doDynamicAttrCheck: false doLogFileWrite: true 06/29/2022 01:02:56: Validating catalog "Item_Staging" to format EPIM Completed validation of 0 records 0 records had errors with a total of 0 errors