Knowledge Base Article 5

ASSP Error: "Is not a valid integer value" when Launching Forecasting.exe in SalesLogix

Version: All

Platform: All

Problem:

Error when launching the Forecasting.exe of the Advanced Sales SolutionPack. When Forecasting.exe is launched, it scans the SLXMEMODATA table and queries the table based on the condition SLXMEMODATA.TYPE = 1. It then calls the data contained in the TextBLOB field, SLXMEMODATA.DATA. If the TextBLOB is empty, it returns a value of NULL, which is not a valid integer value.

Solution:

Delete the record containing the null SLXMEMODATA.DATA field. The next time Forecasting.exe is launched, the error will not be generated.

How to determine the contents of a TextBLOB field:

Firstly, Use DB Explorer to view the TextBLOB field. If the TextBLOB is null, the DATA field will contain [Memo]. If there is data in the TextBLOB, the DATA field will contain [MEMO] (all uppercase). Using DB Explorer, double-click on [Memo] in the DATA field, where the SLXMEMODATA.TYPE field = 1. This will display the contents of the TextBLOB. In Workgroup Administrator, go to Tools > Execute SQL and run the following SQL statement to return the desired data set: SELECT DATA FROM SLXMEMODATA WHERE TYPE = 1

Error examples:

 “Is not a valid integer value”

Back to the List of Errors