Table of Contents

Why is “-2147483647” in my address field?

Issue

IMW is crashing when trying to generate a sliding spot report.

Explanation

When trying to generate a sliding spot report, IMW crashes and closes. This is due to the value of “-2147483647” being in the database. This large negative number was generated when a blank was entered into the database instead of the default “0”.

Solution

First the records need to be located which contain this variable.

1)Create a new report (UtilitiesCustomizeReportFileNew) selecting only CaseID, date, address 1(or block 1 or milepost 1), and address 2 (or block 2 or milepost 2) as the fields to use in the report.
2)Generate an all data diagram.
3)Create an Accident List from this diagram.
4)Select the report we created above, and sort first by address 1 (or block 1 or milepost 1). Scan each record to see if this number appears (it should be towards the top since the data is decending and this is a negative number).
5)Create another Accident List from the same diagram chosing address 2 (or block 2 or milepost 2). Again, the affected records may be listed at the top of the report.
6)Once you have all the records which contain this variable, go into the IMW Editor (UtilitiesDatabaseIMW Edit), and make sure a zero is entered where there are blanks (only in the address/block/milepost fields).

Once these corrections are made, the sliding spot feature should work properly.

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?