[Spce-user] Call history bug. CE mr8.4.1

[Anar Agayarov]

Dear list members, I am getting http 500 error when I am clicking call
history on the subscriber menu.

It is happening if the incoming call list or all calls selected. The
outgoing call list shows properly.

Unfortunately, I am not familiar with Perl. I would be grateful if someone
could help me.



Please check the panel log:

Jun 16 17:55:56 sw01 ngcp-panel: ERROR: fatal error, id=16190ABE78491B30,
timestamp=2020-06-16T13:55:56.430302000Z, error=?Caught exception in
NGCP::Panel::Controller::Subscriber->ajax_calls "Can't call method
"provisioning_voip_subscriber" on an undefined value at
/usr/share/perl5/NGCP/Panel/Utils/CallList.pm line 86."?



and it is panel-debug.log:



Jun 16 18:03:34 sw01 ngcp-panel: DEBUG: Path: subscriber/1/calls

Jun 16 18:03:34 sw01 ngcp-panel: DEBUG: Root::auto: disable cache

Jun 16 18:03:34 sw01 ngcp-panel: DEBUG: *** Root::auto grant access for
authenticated user

Jun 16 18:03:34 sw01 ngcp-panel: DEBUG:
NGCP::Panel::Controller::Subscriber::auto

Jun 16 18:03:34 sw01 ngcp-panel: DEBUG: contract id 3 billing profile at
2020-06-16T18:03:34 (epoch = 1592316214, tz =
DateTime::TimeZone::Asia::Tbilisi=HASH(0x55af49ac1ad0)) is Selling - 5GEL
client (effective start date = 0.000)

Jun 16 18:03:34 sw01 ngcp-panel: DEBUG: using vat_factor ''

Jun 16 18:03:34 sw01 ngcp-panel: DEBUG: Path: subscriber/1/calls/list/ajax/

Jun 16 18:03:34 sw01 ngcp-panel: DEBUG: Root::auto: disable cache

Jun 16 18:03:34 sw01 ngcp-panel: DEBUG: *** Root::auto grant access for
authenticated user

Jun 16 18:03:34 sw01 ngcp-panel: DEBUG:
NGCP::Panel::Controller::Subscriber::auto

Jun 16 18:03:34 sw01 ngcp-panel: DEBUG: contract id 3 billing profile at
2020-06-16T18:03:34 (epoch = 1592316214, tz =
DateTime::TimeZone::Asia::Tbilisi=HASH(0x55af49ac1ad0)) is Selling - 5GEL
client (effective start date = 0.000)

Jun 16 18:03:34 sw01 ngcp-panel: DEBUG: using vat_factor ''

Jun 16 18:03:34 sw01 ngcp-panel: DEBUG: entered dbdo

Jun 16 18:03:34 sw01 ngcp-panel: DEBUG: count stmt: select count(1) from
((SELECT 1 FROM ( (SELECT `me`.`id`, `me`.`update_time`,
`me`.`source_user_id`, `me`.`source_provider_id`,
`me`.`source_external_subscriber_id`, `me`.`source_external_contract_id`,
`me`.`source_account_id`, `me`.`source_user`, `me`.`source_domain`,
`me`.`source_cli`, `me`.`source_clir`, `me`.`source_ip`,
`me`.`source_gpp0`, `me`.`source_gpp1`, `me`.`source_gpp2`,
`me`.`source_gpp3`, `me`.`source_gpp4`, `me`.`source_gpp5`,
`me`.`source_gpp6`, `me`.`source_gpp7`, `me`.`source_gpp8`,
`me`.`source_gpp9`, `me`.`source_lnp_prefix`, `me`.`source_user_out`,
`me`.`destination_user_id`, `me`.`destination_provider_id`,
`me`.`destination_external_subscriber_id`,
`me`.`destination_external_contract_id`, `me`.`destination_account_id`,
`me`.`destination_user`, `me`.`destination_domain`,
`me`.`destination_user_dialed`, `me`.`destination_user_in`,
`me`.`destination_domain_in`, `me`.`destination_gpp0`,
`me`.`destination_gpp1`, `me`.`destination_gpp2`, `me`.`destination_gpp3`,
`me`.`destination_gpp4`, `me`.`destination_gpp5`, `me`.`destination_gpp6`,
`me`.`destination_gpp7`, `me`.`destination_gpp8`, `me`.`destination_gpp9`,
`me`.`destination_lnp_prefix`, `me`.`destination_user_out`,
`me`.`peer_auth_user`, `me`.`peer_auth_realm`, `me`.`call_type`,
`me`.`call_status`, `me`.`call_code`, `me`.`init_time`, `me`.`start_time`,
`me`.`duration`, `me`.`call_id`, `me`.`source_carrier_cost`,
`me`.`source_reseller_cost`, `me`.`source_customer_cost`,
`me`.`source_carrier_free_time`, `me`.`source_reseller_free_time`,
`me`.`source_customer_free_time`, `me`.`source_carrier_billing_fee_id`,
`me`.`source_reseller_billing_fee_id`,
`me`.`source_customer_billing_fee_id`,
`me`.`source_carrier_billing_zone_id`,
`me`.`source_reseller_billing_zone_id`,
`me`.`source_customer_billing_zone_id`, `me`.`destination_carrier_cost`,
`me`.`destination_reseller_cost`, `me`.`destination_customer_cost`,
`me`.`destination_carrier_free_time`,
`me`.`destination_reseller_free_time`,
`me`.`destination_customer_free_time`,
`me`.`destination_carrier_billing_fee_id`,
`me`.`destination_reseller_billing_fee_id`,
`me`.`destination_customer_billing_fee_id`,
`me`.`destination_carrier_billing_zone_id`,
`me`.`destination_reseller_billing_zone_id`,
`me`.`destination_customer_billing_zone_id`, `me`.`frag_carrier_onpeak`,
`me`.`frag_reseller_onpeak`, `me`.`frag_customer_onpeak`,
`me`.`is_fragmented`, `me`.`split`, `me`.`rated_at`, `me`.`rating_status`,
`me`.`exported_at`, `me`.`export_status`, `me`.`source_lnp_type`,
`me`.`destination_lnp_type`, ( NULL ) AS `source_cli_suppression_id`, (
select id from billing.call_list_suppressions where direction = "outgoing"
and mode in ("filter","obfuscate") and (domain = "" or domain =
me.source_domain) and me.destination_user_in regexp pattern limit 1 ) AS
`destination_user_in_suppression_id` FROM `accounting`.`cdr` `me` WHERE (
`source_user_id` = ? ) limit 1001) UNION ALL (SELECT `me`.`id`,
`me`.`update_time`, `me`.`source_user_id`, `me`.`source_provider_id`,
`me`.`source_external_subscriber_id`, `me`.`source_external_contract_id`,
`me`.`source_account_id`, `me`.`source_user`, `me`.`source_domain`,
`me`.`source_cli`, `me`.`source_clir`, `me`.`source_ip`,
`me`.`source_gpp0`, `me`.`source_gpp1`, `me`.`source_gpp2`,
`me`.`source_gpp3`, `me`.`source_gpp4`, `me`.`source_gpp5`,
`me`.`source_gpp6`, `me`.`source_gpp7`, `me`.`source_gpp8`,
`me`.`source_gpp9`, `me`.`source_lnp_prefix`, `me`.`source_user_out`,
`me`.`destination_user_id`, `me`.`destination_provider_id`,
`me`.`destination_external_subscriber_id`,
`me`.`destination_external_contract_id`, `me`.`destination_account_id`,
`me`.`destination_user`, `me`.`destination_domain`,
`me`.`destination_user_dialed`, `me`.`destination_user_in`,
`me`.`destination_domain_in`, `me`.`destination_gpp0`,
`me`.`destination_gpp1`, `me`.`destination_gpp2`, `me`.`destination_gpp3`,
`me`.`destination_gpp4`, `me`.`destination_gpp5`, `me`.`destination_gpp6`,
`me`.`destination_gpp7`, `me`.`destination_gpp8`, `me`.`destination_gpp9`,
`me`.`destination_lnp_prefix

Jun 16 18:03:34 sw01 ngcp-panel: DEBUG: count stmt bind:
60858b2e-3257-4e37-9051-079b090e1ce2,60858b2e-3257-4e37-9051-079b090e1ce2,60858b2e-3257-4e37-9051-079b090e1ce2,1001

Jun 16 18:03:34 sw01 ngcp-panel: DEBUG: result count not clipped

^C


-- 

Best Regards
Anar Agayarov
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20200616/8bce2e58/attachment-0001.html>