Browse Ask a Question
 
Tools
Rss Categories

RedRook-ShipWorks-No Orders Are Flowing Into ShipWorks

Author: Jeff Burge Reference Number: AA-03080 Views: 684 Created: 02/06/2017 04:02 PM Last Updated: 02/23/2017 10:54 AM 0 Rating/ Voters

Information

 

No orders are flowing into Shipworks

1.       Run the health check at http://servername/healthcheck.aspx

a.       If health check page cannot be loaded

                                                               i.      Check that server is online

                                                             ii.      Ensure connectivity on web ports between client and server

                                                            iii.      Check IIS logs for further information

b.      If Database connection fails

                                                               i.      Check that the connection string is correct including username and password.

                                                             ii.      Check that database is available and queryable in SSMS

                                                            iii.      Ensure DB user has dbowner permissions to database.

                                                           iv.      Check SQL Server logs for further information

c.       If web service check fails

                                                               i.      In this unlikely event where IIS is up, but pages are not responsive IIS logs will need to be checked for further information

2.       Query USR_VI_PS_SHIP_IFACE to ensure there are actually orders modified since the current cutoff date being sent by ShipWorks using:

SELECT TOP 100 TKT_NO, LST_MODIFIED_DT FROM USR_VI_PS_SHIP_IFACE ORDER BY LST_MODIFIED_DT DESC

a.       If the orders in question are not showing up in the view the CP dealer will need to troubleshoot the view SQL code to determine cause and correct

b.      If there are orders with newer dates that are not transferring there will need to be an escalation to engineering to perform a code trace


Info Ask a Question