Exports-String or Binary Data will be Truncated

Exports-String or Binary Data will be Truncated

In doing an export out of OLX you may receive the error "String or Binary Data will be Truncated".  What OLX is telling you is that you have a field in the data you are exporting that exceeds the field length in the file that you are moving the data into.  We have witnessed this when lengthy data has been copied into a comments column by accident.  This is something that you could quite possibly find on your own but it would be best to enter a help desk ticket as we will be able to determine fairly quickly where the problem lies.

    • Related Articles

    • Imports-String or Binary Data would be Truncated

      When importing you may see this error occur. Please go to the line item that is throwing the error and look at your product offers. If your product offer name or description is lengthy you will need to reduce it. Generally if the description spills ...

    • Exports and Reports will not download in OLX

      Periodically when Microsoft Windows updates are done your security settings can be reverted. This can turn pop up blockers on and also reset your settings for prompts and downloads. When running exports or reports out of OLX such as the flattened ...

    • SEVERE: ERROR in Function: LoadMomOrderLine Conversion from string "NO_SOLICITING" to type 'Integer' is not valid.

      Message: SEVERE: ERROR in Function: LoadMomOrderLine Conversion from string "NO_SOLICITING" to type 'Integer' is not valid. Explanation:  This exception indicates that you are importing a file with a header row. The import is attempting to import the ...

    • Test credit card numbers that will pass a Mod10 check

      Test credit card numbers that will pass a Mod10 check are sometimes needed for testing purposes as well as for using tokenization in applicable editions of the OrderLogix application. Below is a list of test card numbers that will pass a Mod10 check. ...

    • Error:Cast to String to Type Double is not Valid

      When importing if the error message Cast to String to Type Double is not Valid essentially means that there is an association that is missing.  Try checking to see that there is a valid corresponding value for every product offer in the file.  If ...