PPG2 EPO Troubleshooting

Here are some details on understanding the SQL Server Management Studio Express screen to trouble shoot the new PPG EPO issues.

This new process uses SQL, there are SQL tables setup to record and send results to the customer. Below is a SQL command to view the results for a certain customer and to understand the columns we have.

1. Open up the SQL Server Management (Express) on the PERFXP machine and click on Connect then in left hand box, click the + next to Databases then the click on PSWSRequest folder

2. Then click on New Query and copy and past the below command:

select * from xml_request where targetcustomer = '4985' AND CREATED >= '2009-02-27'

*Change customer # and date and click Execute and a box will appear below with the results

3. Three columns are important (depending on what you are looking for) RequestType, XmlRequest and Updated

Request Type – Can be ConfirmRequest, ShipNoticeRequest or ColUpdateRequest

Confirm Request: From PPG to Customer contains details about the order, success or failure on part#s

Ship Notice Request: Confirm that items on order were shipped

Col Update Request: Request for any updates from Customer to Perfection

Xml Request – The data in the file. Can be looked at by just click on the box and doing a copy and past into Note pad

Update – The status of the request. If it is null then request has not been pick up by customer, when there is a date this tells you when it got loaded into the customer’s system.

173.15.211.245

4. This tip has to with the Perfection Util service and that it will not work if a Tech folder is not created on the C drive. Everything will seem to work but the PO will never de sent. I looked at the Event Viewer under Applications and it gave the error (tech dir not found) on startup of the service.