My Oracle Support Banner

DBS::query Error "Selection set not consistent with number of rows returned" (Doc ID 1493403.1)

Last updated on OCTOBER 21, 2021

Applies to:

Oracle Utilities Network Management System - Version and later
Oracle Network Management for Utilities - DMS - Version to [Release 1.10]
Information in this document applies to any platform.


Attempting to create a call via Call Entry generates this error:

09/07 16:14:15: callEntry:17209 0x1,ctp=0x00000001001e6018,"" **ERROR** DBS::query: while processing 'select id, supply_idx, geo_code, account_number, account_name, address, address_building, mail_address_1, mail_address_2, mail_address_3, mail_address_city, mail_address_st, mail_address_zip, mail_address_city_st, mailing_address, city_state, zip_code, town, phone_area, phone_number, account_type, apt, feeder_id, device_id, meter_number, meter_route, meter_route_sequence, priority, c_priority, d_priority, k_priority, revenue, avg_revenue, rate_name, life_support, op_center, ohug, tariff_type, county_code, cycle, cust_priority, meter_point_status, serv_loc_id, meter_id, cust_id, service_st_num, service_st_name, service_st_suffix, service_st_dir, service_st_apt, street, amr_enabled, meter_device, amr_collection_method, service_drop, component_id, hazard_condition, driving_directions, email, new_h_cls, new_h_idx, new_supply_idx, NULL, NULL, NULL, NULL, c.h_cls, c.h_idx from ces_customers c where h_cls = <cls> and h_idx = <idx> and rownum < 102'
Selection set not consistent with number of rows returned,
found 1 rows in selection set, supposed to find 2,
selection[0] = 'ID




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.