Reward of affiliate program is not accrued

Problem

The referrer is not accrued the reward under the referral program.

Solution

Execute the command:

Command

/usr/local/mgr5/sbin/billmaintain --command affiliatemonthly

View the log

Apr 10 19:31:21 [27229:4642] core_module INFO Request [billmaintain][root] 'affiliate=1&func=affiliate.process&month=2019%2D05%2D01&out=xml&referal=7&referer=6'
Apr 10 19:31:21 [27229:4642] db EXTINFO begin transaction
Apr 10 19:31:21 [27229:4642] db EXTINFO Query: 'SELECT COUNT(*) FROM affiliate a LEFT JOIN account2group a2g ON a2g.account=6 AND a2g.accountgroup=a.account_group LEFT JOIN account2group rest ON rest.account=6 AND rest.accountgroup=a.account_group_restrict WHERE a.id='1' AND (a.account_group IS NULL OR a2g.account IS NOT NULL) AND rest.account IS NULL'
Apr 10 19:31:21 [27229:4642] backtrace EXTINFO mgr_err::Access::Access(std::string const&, std::string const&) (lib/libmgr.so.5.197.0 + 0x4d) [*0x7f5e154ec593]
Apr 10 19:31:21 [27229:4642] backtrace EXTINFO aAffiliateProcess::Execute(isp_api::Session&) const (lib/billmgr.so + 0x2043) [*0x7f5e112ebbca]
Apr 10 19:31:21 [27229:4642] backtrace EXTINFO isp_api::Action::Run(isp_api::Session&) const (lib/libispapi.so.5.197.0 + 0x7a) [*0x7f5e112ee4db]
Apr 10 19:31:21 [27229:4642] backtrace EXTINFO isp_api::InternalCall(isp_api::BaseConnection const&, isp_api::Authen const&, isp_api::Action const&) (lib/libispapi.so.5.197.0 + 0x63b) [*0x7f5e1373b458]
Apr 10 19:31:21 [27229:4642] backtrace EXTINFO ispcore::ProcessRequest::ProcessApi1() (lib/libbase.so.5.197.0 + 0x208) [*0x7f5e1373e960]
Apr 10 19:31:21 [27229:4642] backtrace EXTINFO ispcore::ProcessRequest::operator()() (lib/libbase.so.5.197.0 + 0x1580) [*0x7f5e1373f5ef]
Apr 10 19:31:21 [27229:4642] backtrace EXTINFO mgr_thread::Handle::Impl<mgr_thread::List::Impl<ispcore::ProcessRequest> >::run() (lib/libbase.so.5.197.0 + 0x5f) [*0x7f5e10a9146f]
Apr 10 19:31:21 [27229:4642] backtrace EXTINFO ??? (lib/libmgr.so.5.197.0 + 0x0) [*0x7f5e162aadd5]
Apr 10 19:31:21 [27229:4642] backtrace EXTINFO ??? (/lib64/libpthread.so.0 + 0x0) [*0x7f5e15fd3ead]
Apr 10 19:31:21 [27229:4642] backtrace EXTINFO ??? (/lib64/libc.so.6 + 0x6d) [*(nil)]
Apr 10 19:31:21 [27229:4642] libmgr ERROR Error: Type: 'access' Object: 'affiliate' Value: '1'
Apr 10 19:31:21 [27229:4642] action EXTINFO Get message for error in action 'affiliate.process' for level 30
Apr 10 19:31:21 [27229:4642] action EXTINFO Get message for error in action 'mgrerror_access' for level 30
Apr 10 19:31:21 [27229:4642] db EXTINFO rollback transaction
Apr 10 19:31:21 [27229:4642] action EXTINFO Get message for error in action 'msgerror' for level 30
Apr 10 19:31:21 [27229:4642] libmgr EXTINFO Thread 5a57275dea627325 finished

If an error appears in the log, as in the block above, then the referrer is connected to the referral program, but does not meet all its conditions. For example, he is not a member of the required group or is a member of a forbidden group.