Demand Mass Review - See APPSERVER LOGS

Thnaks for your helo Ned. Put my thinking cap hat on and was able to figure it out. 

For any future person with a similar problem, i did this below: 

You was correct in the fact that the program didnt take into account demand entry. So it had erased the ship to information in demand entry. I could still view the PO through a BAQ but it was just a ghost pos. I re-porcess those three POs and problem was solved.

Just by talking it out, i was able to figure it out. Thanks Ned!

Jose!

Hello All!


I am using Vantage 8.03.409C. We periodically remove shipto information form our database through a .p program that Epicore developed for us. (This speeds up customer service  order entry).


Last night i ran this .p file on a customer that is now EDI. in doing so this i causing an error when i go to Demand Review which says see app server logs.


When i go to the logs, it says it cant find the Ship To record but all of the orders in Demand Entry have the Ship to record. What can i do to remove this as i can use demand mass review right now. Any help is appreciated.


[15/09/02@11:44:25.318-0400] P-005408 T-007028 1 AS -- (Procedure: 'as/activate.p' Line:380) Incoming call from 2KFGW5JC1:1

[15/09/02@11:44:25.318-0400] P-005408 T-007028 4 AS AS -- TRACE: SINGLE-RUN Procedure bo/DemandEntry.p:GetList START (8458)

[15/09/02@11:44:25.318-0400] P-005408 T-007028 3 AS AS         requestID= NULL

[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS -- ** No ShipTo record is available. (91)

[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS -- ** 4GL Debug-Alert Stack Trace **

[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS -- --> getAddrList Server/bo/DemandEntry.p (d:\epicor\mfgsys803\Server\bo\DemandEntry.r) at line 37660

[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS --     demandHeadAfterGetRows Server/bo/DemandEntry.p (d:\epicor\mfgsys803\Server\bo\DemandEntry.r) at line 33005

[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS --     getListRowLoaded Server/bo/DemandEntry.p (d:\epicor\mfgsys803\Server\bo\DemandEntry.r) at line 40095

[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS --     GetList Server/bo/DemandEntry.p (d:\epicor\mfgsys803\Server\bo\DemandEntry.r) at line 14196


Do i have to do a quert search in sql for all null shipto information and remove them?

First, that sounds sorta like a bad idea in the first place, but to answer your question, I would suggest you get in touch with Epicor about what your solution should be since the problem has stemmed from a program they wrote for you.

 

Without knowing any more than what is below, it sounds like the program was written and doesn’t check to make sure that the ShipTo information isn’t tied to an existing order prior to being deleted, thus giving you errors.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 02, 2015 11:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Demand Mass Review - See APPSERVER LOGS

 




Hello All!

 

I am using Vantage 8.03.409C. We periodically remove shipto information form our database through a .p program that Epicore developed for us. (This speeds up customer service  order entry).

 

Last night i ran this .p file on a customer that is now EDI. in doing so this i causing an error when i go to Demand Review which says see app server logs.

 

When i go to the logs, it says it cant find the Ship To record but all of the orders in Demand Entry have the Ship to record. What can i do to remove this as i can use demand mass review right now. Any help is appreciated.

 

[15/09/02@11:44:25.318-0400] P-005408 T-007028 1 AS -- (Procedure: 'as/activate.p' Line:380) Incoming call from 2KFGW5JC1:1

[15/09/02@11:44:25.318-0400] P-005408 T-007028 4 AS AS -- TRACE: SINGLE-RUN Procedure bo/DemandEntry.p:GetList START (8458)

[15/09/02@11:44:25.318-0400] P-005408 T-007028 3 AS AS         requestID= NULL

[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS -- ** No ShipTo record is available. (91)

[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS -- ** 4GL Debug-Alert Stack Trace **

[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS -- --> getAddrList Server/bo/DemandEntry.p (d:\epicor\mfgsys803\Server\bo\DemandEntry.r) at line 37660

[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS --     demandHeadAfterGetRows Server/bo/DemandEntry.p (d:\epicor\mfgsys803\Server\bo\DemandEntry.r) at line 33005

[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS --     getListRowLoaded Server/bo/DemandEntry.p (d:\epicor\mfgsys803\Server\bo\DemandEntry.r) at line 40095

[15/09/02@11:44:25.349-0400] P-005408 T-007028 1 AS --     GetList Server/bo/DemandEntry.p (d:\epicor\mfgsys803\Server\bo\DemandEntry.r) at line 14196

 




Thanks Ned. The program does check to make sure that there are no open orders. it only removes the ship to information of closed/payed orders from months prior to the day i remove them. I have a call in with them but trying to see if i figure this out since they take forever and CS cant process the orders.

For a minute if we remove the back story and just focus on the fact that when i do a search in demand entry for this particular customer i get the error about no ship to information.

All the orders that have come into demand entry have the ship to information. It was a ship to prior to demand entry being implemented that was removed

The error points to the get list method finding a null value. When i did a query in sql, i didnt get no null values. Am i missing something?

It could be empty, not a null value, they are different and when Epicor deletes something they don’t usually make it null, they usually just delete it, thus making it an empty field.

 

I don’t know the details of the program enough to say for certain, I am just telling you what it sounds like happened, and it sounds like something stripped the ShipTo info out of open orders and based on what you describe, it sounds like  it would be a fault in the program they wrote.

 

This is something important, you should be on the phone escalating this with Epicor, and in a webex with them showing them the problem, preferably with whatever developer of theirs wrote that .p for you to make sure it’s actually doing what it’s supposed to be doing.

 

The flaw might be in the program checking closed orders, and deleting the shipto’s from closed orders, but not making sure there are no open orders that have the same shipto also connected to it. I don’t know this for sure is the problem, just a hunch based on what you described.

 

Hopefully I am wrong and it really is something completely different.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 02, 2015 3:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Demand Mass Review - See APPSERVER LOGS

 



Thanks Ned. The program does check to make sure that there are no open orders. it only removes the ship to information of closed/payed orders from months prior to the day i remove them. I have a call in with them but trying to see if i figure this out since they take forever and CS cant process the orders.

 

For a minute if we remove the back story and just focus on the fact that when i do a search in demand entry for this particular customer i get the error about no ship to information.

 

All the orders that have come into demand entry have the ship to information. It was a ship to prior to demand entry being implemented that was removed

 

The error points to the get list method finding a null value. When i did a query in sql, i didnt get no null values. Am i missing something?