Bentley Communities
Site
Search
User
Site
Search
User
Product Communities
AssetWise
ALIM | Exor
Cancel
ALIM | Exor
ALIM | Exor - Wiki
'Divisor is equal to zero' error in UKPMS reports
Sign In
-
Exor - Wiki
+
ALIM Document Manager
An Attempt to Reset Your Password Has Failed
+
AWLRS
+
Exor Asset Manager
+
Exor CIM / FIM
+
Exor Document Manager
+
Exor Enquiry Manager
+
Exor Information Manager
+
Exor Information Manager TMA Reporting Pack
+
Exor Maintenance Manager
+
Exor Maintenance Mobile
+
Exor MapCapture
+
Exor MapCapture (ESRI)
+
Exor MCI MapCapture Interface
+
Exor Network Event Manager
+
Exor Network Manager
+
Exor Oracle
Exor Problems and Solutions
+
EXOR product placeholder
Exor Public Enquiry Manager API
+
Exor Schemes Manager
+
Exor Spatial Manager
+
Exor Street Gazetteer Manager
Exor Streetworks Manager
Exor Streetworks Mobile
+
Exor Structures Manager
Exor Structures Mobile
+
Exor TMA Noticing Manager
+
Exor TMA Permitting Manager
-
Exor UKPMS
Error at point 14 when running a pass
+
HMDIF Load - Exor UKPMS
+
Network Selection - Exor UKPMS
REP-300 error
-
Reports - Exor UKPMS
'Divisor is equal to zero' error in UKPMS reports
Blank UKP0040 report
Performance CI Report - Exor UKPMS
RCI fault ORA-00936 in UKP0026
+
Survey Load - Exor UKPMS
Survey tolerance errors
+
UKPMS Pass - Exor UKPMS
+
Transportation Intelligence Gateway
Unable to connect to Power BI dataset
+
Video Series for Exor
Working From Home with Exor
+
AssetWise ALIM for Transportation
Questions about this article, topic, or product? Click here.
'Divisor is equal to zero' error in UKPMS reports
Applies To
Product(s):
Exor UKPMS
Version(s):
04.05.40.01
Environment:
N\A
Area:
Reports
Subarea:
N\A
Original Author:
Kristijonas N., Bentley Technical Support Group
Problem Description
Several UKPMS reports result in
ORA-01476: divisor is equal to zero error
.
Steps to Resolve
Create views in ukp0050 form.
Check if view
v_ukpms_road_section
exists in the database and if it has records in it. Contact Bentley Support if you found that it does not exists or has no data.
If
v_ukpms_road_section
looks OK please contact Bentley support and ask for a script (ukp_missing_attribs.sql) that checks if all sections in your Network selection have values entered for attributes like road type, road hierarchy and number of lanes.
If running the script there are listed sections whose lanes are ‘0’ (zero), so these sections should be excluded because these sections stop the report. Solution is to exclude these sections from the particular pass (or create another pass without these sections) and run the report again.
ORA-01476
ukp_missing_attribs
attribs
Exor
exor ukpms
divisor
equal to zero
Share
History
More
Cancel
Created by
Kristijonas
When:
Mon, Jan 19 2015 5:00 AM
Last revision by
renatas
When:
Fri, Apr 12 2019 3:14 AM
Revisions:
7
Comments:
0
Recommended
Related