Bug #246
openAGTDST Upload issue
Added by Greg Krabbenhoft almost 2 years ago. Updated over 1 year ago.
0%
Description
This one will be difficult to track down, but it's imperative we do so.
Intermittently, when utilizing the AGTDST upload function, the system will place all agents being uploaded as subs to the currently logged in affiliate rather than the affiliate set in the upload file. Please check all variable references in the code and make sure it's not pulling the wrong affiliate information. Attached is a sample upload file that Denny provided for this troubleshooting.
Files
IIABAZ Member List 6.15.23.csv (44.9 KB) IIABAZ Member List 6.15.23.csv | Greg Krabbenhoft, 06/21/2023 01:11 PM | ||
clipboard-202306271057-n0rhp.png (31.3 KB) clipboard-202306271057-n0rhp.png | George Howington, 06/27/2023 06:04 PM | ||
clipboard-202306271058-3zsms.png (20.2 KB) clipboard-202306271058-3zsms.png | George Howington, 06/27/2023 06:05 PM |
Updated by George Howington almost 2 years ago
- File clipboard-202306271057-n0rhp.png clipboard-202306271057-n0rhp.png added
- File clipboard-202306271058-3zsms.png clipboard-202306271058-3zsms.png added
Hi Vaibhav,
For this ticket, please use the credentials under IIIIIODEN. Once logged on, please search in affiliates for "GESINJ." Then you select "manage AGT/DSTs". In this area, click 'upload agtdsts", etc... What's happening, these AGTDST's should be created under "GESINJ." Unfortunately, there appears to be a glitch where they are created under "IIIIIODEN".
Let me know if you have any questions and thank you,
--George
Updated by Vaibhav Kamthe almost 2 years ago
@George,
I confirmed the behaviour again and unable to reproduce the bug.
Here is what I tried:
I accessed the agtdst section, as per the steps which you have provided in one of the comment. I observed that agtdst entries are getting uploaded to correct aff_id.
| 240435 | NULL | c313d4d9a8cde142ce0e7178c9fa7a1e | 0 | 0 | 0 | 0 | | | 1671 | 0 | | 2023-06-30 13:42:03 | 0 | | 220 E. 16th Street, Ste 2 | Yuma | 3969 | 85364-4714 | | vanessa@yumarmg.com | Yuma Risk Management Group | 0 | | 0 | 0 | 0 | 0 | 0 | | | | | | | | |--------------+----------------------------------+------------+-----------------+--------------------+-----------------------+-----------------------+---------------------+--------+-------------+--------------+---------------------+---------+-------------+---------------------------+------+-------+------------+-------+---------------------+----------------------------+-------------+-------+-------------------+-------------------+--------------------+-------------------+-----------------+--------------------+------------------+---------------+------------+--------------------+------------------+-----------------+---------------+
1 row in set (0.006 sec)
id | agtdst | password | locked_out | failed_attempts | password_timestamp | force_password_change | recover_pass_question | recover_pass_answer | aff_id | office_code | manager_over | timestamp | enabled | description | address | city | state | zip | phone | email | agent_name | agent_issue | templ | view_agtdst_maint | edit_agtdst_maint | admin_agtdst_maint | sweep_from_agtdst | sweep_to_agtdst | sweep_from_account | sweep_to_account | tax_id_number | applied_id | state_of_operation | termination_date | enrollment_date | renewal_email |
--------------+----------------------------------+------------+-----------------+--------------------+-----------------------+-----------------------+---------------------+--------+-------------+--------------+---------------------+---------+-------------+---------------------------+------+-------+------------+-------+---------------------+----------------------------+-------------+-------+-------------------+-------------------+--------------------+-------------------+-----------------+--------------------+------------------+---------------+------------+--------------------+------------------+-----------------+---------------+
MariaDB [polmaker]> select * from aff where id=1671;-----------+--------+------------+----------------+--------------------+-----------+-------------+---------+---------+----------+--------------+---------------------+---------------+-------------+---------------------+------+----------------------+--------------------------+---------+---------------------+
| id | affid | sub_of | full_affid | username | password | cookie_id | accesslevel | enabled | deleted | templ | report_group | broker_report_group | agtdst_master | last_update | ts | dead | docusign_envelope_id | docusign_envelope_status | api_key | agent_issue_api_key |-----------+--------+------------+----------------+--------------------+-----------+-------------+---------+---------+----------+--------------+---------------------+---------------+-------------+---------------------+------+----------------------+--------------------------+---------+---------------------+
| 1671 | INJ | 1645 | GESINJ | 1671__username | 0ac6ca2f__password | 0 | 10 | 1 | 0 | iig-2015 | , | , | 12345 | 1604602852 | 2021-09-28 16:04:15 | 0 | | | | |-----------+--------+------------+----------------+--------------------+-----------+-------------+---------+---------+----------+--------------+---------------------+---------------+-------------+---------------------+------+----------------------+--------------------------+---------+---------------------+
Updated by Vaibhav Kamthe almost 2 years ago
I would suggest one thing in this case.
Whenever we are trying to use this AGTDST upload feature, Can we give it try from fresh incognito web browser window?
Because I suspect, the issue could be occurring due to multiple open sessions for number of affiliates within the same web browser window.
Thanks!
Updated by Vaibhav Kamthe over 1 year ago
- Status changed from New to Resolved
- Assignee changed from Vaibhav Kamthe to Greg Krabbenhoft
Feel free to reopen this issue again, as we haven't heard back from Denny after proposing a way out to upload the agtdst file.