FW: As400 Import Error

Fritz,

I just spoke to Marilyn again and she could not find any emails regarding this.
Before I make changes to take them off we need to ask David, Myron and Chuck to see if it is ok with them.

Thank you,
Charmaine

From: Charmaine A. Gray
Sent: Friday, November 11, 2016 9:23 AM
To: Fritz Piepmeier
Subject: RE: As400 Import Error

I spoke with Marilyn about this and she said that David or Myron wanted it set up to have the previous year's data.
Marilyn is looking in her emails to see if she can find out who and why.

Charmaine

From: Charmaine A. Gray
Sent: Thursday, November 03, 2016 2:55 PM
To: Fritz Piepmeier
Subject: RE: As400 Import Error

This is what Lori had written up below. I checked the CL and it is sending 14, 15, 16 and current year as intended. Do they want it changed??

0028.20 * d. Update CL programs WPCUS1C and WPREP1C
0028.21 * These programs should update prior 5 years as that is
0028.22 * the number of years sales portal stores. REP and CUS
0028.23 * can change from year to year so that is why all five
0028.24 * years of these files must be included.
0028.25 * See previous copies of WPCUS1(X) and WPREP1(X).


From: Fritz Piepmeier
Sent: Thursday, November 03, 2016 11:05 AM
To: Charmaine A. Gray
Subject: FW: As400 Import Error

I changed the update previous year option to N on the WPMENU opt 10 but I am still getting the error like it is trying to push more than 2017


Fritz
ph 515-677-4032
cell 515-360-8276

From: Travis R. Smith [mailto:TSmith@xxxxxxxxxx]
Sent: Thursday, November 03, 2016 9:54 AM
To: Fritz Piepmeier <fjpiepmeier@xxxxxxxxxxxxx<mailto:fjpiepmeier@xxxxxxxxxxxxx>>
Cc: Eric Hoefing <EHoefing@xxxxxxxxxx<mailto:EHoefing@xxxxxxxxxx>>; David Thompson <dpthompson@xxxxxxxxxxxxx<mailto:dpthompson@xxxxxxxxxxxxx>>; Scott A. Meredith <SMeredith@xxxxxxxxxx<mailto:SMeredith@xxxxxxxxxx>>
Subject: RE: As400 Import Error

Fritz,

The reason that the import procedure is having this error is because the data being imported in from the WCUS and WREP files in the AS400 system still has 2014, 2015, and 2016 crop year data in them. The Import Procedure is expecting that crop years that should not be changed any more would not show up in the imported data.

Would it be possible to have Charmaine only include the current crop year data in these files for import?

Thanks,
[cid:image003.png@01D23BFE.28A946C0]Travis Smith|Senior Application Developer
11122 Aurora Avenue * Des Moines, IA 50322
T/F: 1 (855) SAFE.NAV * F: (515) 223.7219
acsltd.com<http://www.acsltd.com/> | LinkedIn<https://www.linkedin.com/company/acs_5?trk=biz-companies-cym> | Twitter<https://twitter.com/ACScompass>| Facebook<https://www.facebook.com/ACS-Associated-Computer-Systems-920731861300089/timeline/>

From: Fritz Piepmeier [mailto:fjpiepmeier@xxxxxxxxxxxxx]
Sent: Thursday, October 27, 2016 8:53 AM
To: Travis R. Smith <TSmith@xxxxxxxxxx<mailto:TSmith@xxxxxxxxxx>>
Cc: Eric Hoefing <EHoefing@xxxxxxxxxx<mailto:EHoefing@xxxxxxxxxx>>; David Thompson <dpthompson@xxxxxxxxxxxxx<mailto:dpthompson@xxxxxxxxxxxxx>>; Scott A. Meredith <SMeredith@xxxxxxxxxx<mailto:SMeredith@xxxxxxxxxx>>
Subject: As400 Import Error

Travis, they had me run a manual update of the portal yesterday and I noticed it generated an error on the ImportTerritoryDSM step. I looked at the history and I see it has been doing it for a while.

The first error is on set @newID where a DSM is set a primary on more than one territory

The second error is occurring on deleting a record from TerritoryDSM because of a foreign key constraint to CornHybrids.


Fritz Piepmeier
IT Director
Stine Seed Co.<http://www.stineseed.com/>
22555 Laredo Trail
Adel IA 50003
(800) 362-2510
ph (515) 677-4032
mobile (515) 360-8276
fax (515) 677-2716
[Stine_2C]<http://www.stineseed.com/>