Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

Info

This page is for the Classic Operations App. For the Operations App please see Import Audit Log.

Anchor
top
top

Table of Contents

...

X X .ImportPKID: Critical error. You will need to contact Technical Support to troubleshoot this type successfully, or "False" if the import was not completed successfully

Field Name

Description

CustID

The customer id associated to the X Stream importthe import. If the CustID is 0 or -1, the import was unsuccessful.

Import Start Date

The date and time that the import started.

Import Complete Date

The date and time that the import was completed.

LastProcessedTime

The date and time that the import was last processed. This is updated after every order/route stop is imported.

Type

The type of import:

  • ROWS: Import done by using the Remote Order Web Service.

  • ASN:

  • Route file import.

  • On Demand: On demand order file import.

  • UNPOST:

  • Route import that was unposted from the system.

  • CANCELLED: On demand order import that was cancelled and removed from the system

  • .

TotalSuccessful

Total number of successful orders or route stops imported. Updates per every order/route stop imported.

TotalFailed

Total number of failed imports.

TotalConsolidated

Total number of consolidated orders or route stops imported. Updates per every order/route stop posted.

IPAddress

IP address of where the files were imported from.

ImportFileName

Directory path to the processed folder where the imported file is located.

Errors

A clickable link that will bring up a text file providing the error information if there were any errors when processing, or the XML post info for a ROWS type. 

Complete"True" if the

Whether or not an import was completed

.

  • True - Import was processed successfully.

  • False - Critical error. You will need to contact Technical Support to troubleshoot this type.

  • Blank - Import has a Type of “UNPOST”.

Alternate Lookup

Alternate Lookup of the customer associated with the import. 

...

Failed Import and Error Text

If you experience any problems when importing your integration, you can find an error message in the Import Audit Log identifying what went wrong. 

To view the error text double click on the link in the Errors column. This will open the ImportError.txt file in Notepad ++. 

Tip

Quick Tips

  • Any routed imports that fail due to a deadlock will be unposted to prevent partial stops from being created. You can re-run the failed file to complete the import. 

  • For ASN or On Demand type imports, find "<ErrDescription>". 

...

Excerpt

ErrDescription: Processing orders not allowed outside your customer list

(error) Problem:  The Internet User for the integration does not have permission to create orders or route stops for the specified Customer ID.  Internet User credentials are required to authenticate the request to insert orders and route stops into your system for a given customer.  

(tick) Solution:  Open the Internet User record in Maintenance > Internet Users, used for the integration in question.  Check the "Allowed Customer Accounts" list, and ensure the checkbox is marked for all additional customers to be used for the integration configuration.

Image RemovedImage Added

ErrDescription: User ID and/or Password Invalid

(error) Problem:  The Internet User for the integration is attempting to use invalid user ID and/or password credentials, as specified on the internet user record.  

(tick) Solution:  Contact CXT Technical Support to repair the integration configurations.  Please ensure the user ID and password are not changed without CXT Software involvement.

Image RemovedImage Added

ErrDescription: Type mismatch

(error) Problem:  During the process of the import configuration translating data from the inbound file into a readable format for X Import, one or more fields were translated into a format that is not acceptable in the database.  For example (as pictured below), alpha characters in the CustID field, which is expected to be a numeric integer value.

(tick) Solution:  Review all XML elements in the error file for unexpected values.  Make the necessary corrections to the ASN file to ensure valid data is pushed to the database for the next import.  Retry the import.

ErrDescription: There is no service available for this request

(error) Problem:  Parameters set on the order type are inconsistent with the data attempting to be imported in the file.  Possibly, the order type does not have X Internet hours of operation enabled (which is required for integration imports), or the calculated distance is outside of specified bounds.

(tick) Solution:  Check that the Order Type hours of operation are enabled, and the appropriate days / hours are checked.  Confirm the order attempting to be imported does not exceed any maximum distance configurations.

     

ErrDescription: CalculateRateStamp failed - Header Error. Rate chart [x] for this order type does not exist 

[x] is based on the rate chart assigned to the customer being imported to. This occurs for route stops only.

(error) Problem:  The imported route stop was unable to find a Stamp Rate Chart on the associated customer's rate chart.  

(tick) Solution:  Check the rate chart grouping assigned to the customer for the imported route stop.  Navigate to Maintenance > Rate Charts and confirm a Stamp Rate Chart exists in the appropriate rate chart group.  If a chart does not exist, a new rate chart will need to be created, use the small down-arrow to the right of the "New" button in the toolbar at the top, and scroll down to "Stamp Rate Chart"

The file is not importing, no audit trail is visible is the X Stream > Import Audit Log

(error) Problem:  If an X Stream > Import Audit Log is not visible (indicating the file was not available to attempt processing and product an error message), the issue likely lies with the file transmission. 

(tick) Solution:  Check the Error box (visible, if an error is present, in the bottom right area) within the X Stream Definition's schedule, to determine the failure.  To open the schedule, double-click the highlighted schedule in the bottom left box of the X Stream Definition you set up for file transmission.  

Back to top.