Time Tracking v 1.0.0.4 

   

CompanyTicketSummaryEmployeeTime CategoryBillableTime SpentEvent DateNotes
 30603R&D - Research & DevelopmentEddie OlivaR&D - Internal DevNo2.5005/01/2025QA Maintenance work and researching on the Subscriber Portal Patch as Injee needs to check in various sql scripts from the patch into TFS.
 30604R&D - Time OffJoe TaschnerR&D - Time OffNo8.0005/01/2025Joe Out
 30607R&D - Internal MeetingsEddie OlivaR&D - Internal MeetingsNo0.5005/01/2025Daily Meeting.
 30605R&D - Support AssistanceAlex DongR&D - Sustained EngineeringNo1.0005/01/2025Login to Gabon database, check index fragmenation, reindexed order distribution related tables
 30715PS meetingInjinash GooshPS - InternalNo0.5005/01/2025morning status meeting.
 30607R&D - Internal MeetingsAlex DongR&D - Internal MeetingsNo0.5005/01/2025Daily Team Meeting
 36251Agent Web AppEddie OlivaR&D - Internal DevNo3.0005/01/2025Testing updates from the Agent WebApp and writing up new bugs.
 34296R&D Product AdvancementInjinash GooshR&D - Internal Research/TrainingNo6.0005/01/2025working on payment process flow change. apply payment from service side.
Antigua Public Utility Authority37394Inconsistency with assignment of D100 BID to Fibre BID - TrystanYola GreenSupport - Customer SupportNo1.0005/01/2025watch video and communication with Developer on the LINKING not always working
 36251Agent Web AppAlex DongR&D - Internal DevNo1.5005/01/2025Sprint planning and demo meeting with Covalance to discuss issues related to task items and backlog grooming
Antigua Public Utility Authority37431No email confirmation SelfcareYola GreenSupport - Customer SupportNo2.0005/01/2025Found a message to the first acount Not finding anthing for second account to either address but do see data for that account =LU -_LU 270348--27033 dr.piper23@gmail.com pipersb2000@yahoo.com _USK 190303 select * from PDSA.pdsaUser where LoginName like '%chantalphillip@outlook.com%'order by LastLoginDate desc --this one found select * from PDSA.pdsaUser where LastName like '%Piper%'order by LastLoginDate desc Select * from Subscriber.Users where pdsaUserId ='1471' Select * from Subscriber.Users where pdsaUserId ='1469'
 36251Agent Web AppAlex DongR&D - Internal DevNo3.5005/01/2025Reviewed outstanding AzureDevops items from the team, provided feedback Tested and fixed the issues team reported. Continue the development of CRM APIs - Balances tab
Tonga Communications Corp36487Managed Services- TCC till June 2027Yola GreenSupport - Managed ServicesNo0.5005/01/2025Checked TCC back up before weekend and make sure that only ten there and have access. Validated that the swl jobs are running no erros
 30562MISC Support (Department Use Only) - Internal ReportingEddie OlivaSupport - Internal ReportingNo1.0005/01/2025Responding to emails and questions.
 36457Local VM MaintenanceEddie OlivaR&D - Sustained EngineeringNo1.0005/01/2025Maintenance on my local VMs
 37336Progresif SQL Job Archive OSSRawUsage & OSSUsage errorAlex DongR&D - Sustained EngineeringNo1.5005/01/2025I have updated the configurations and tested the stored procedures that get called by the jobs as well, I then re-enabled the jobs. We will keep an eye on the logs to make sure the jobs are running correctly.
 37432No email confirmation SelfcareInjinash GooshR&D - Sustained EngineeringNo1.0005/01/2025Hi Yola, I manually update those 2 account active, the fix will be in the next patch with the payment changes. Thank you,
Antigua Public Utility Authority37394Inconsistency with assignment of D100 BID to Fibre BID - TrystanYola GreenSupport - Customer SupportNo0.5005/01/20255. TT37394 - Inconsistency with assignment of D100 BID to Fiber BID Videos detailing the behaviour within the test and production environments have been uploaded to the A360 user desktops on 172.16.32.164 in the following folder: "Assignment Provisioning Inconsistency"
Antigua Public Utility Authority37415Options for Different Rate Codes not shown for Rate Changes in SelfCare - TrystanYola GreenSupport - Customer SupportNo2.0005/01/2025research what the requires are for self care for a package to be visable and must be in a package with a Contract commiment rate code Must have the stvp.ParameterName = 'DATA_SERVICENAME' in the switch package
ATN International37406List of tables storing CPNI and PCI informationYola GreenSupport - Customer SupportNo0.5005/01/2025Dipak has contacted me and requested this to be left open till he can review further
Digicel Bermuda37416Digicel CSR Issue reported from Site visitYola GreenSupport - Customer SupportNo1.0005/01/2025Follow up with Digicel on GSM TB
Progresif Cellular Sdn Bhd.37421Error response and failure status for SMS notification logYola GreenSupport - Customer SupportNo0.5005/01/2025Check back n services and monitor during my day
Strata Networks37151Strata OSS360 client update.Yola GreenSupport - Customer SupportNo0.5005/01/2025Sent schedule for upgrade
Progresif Cellular Sdn Bhd.37421Error response and failure status for SMS notification logYola GreenSupport - Customer SupportNo0.5005/02/2025Respond and updae tt to close
Strata Networks37151Strata OSS360 client update.Yola GreenSupport - Customer SupportNo0.5005/02/2025 still need the quote for TT 37387-follow up internal
ATN International37411OneComm Bermuda - Unable to return item on account 20085664Yola GreenSupport - Customer SupportNo0.5005/02/2025Follow up on deploymen/Testing
CCT Boatphone37176Random Question Marks in Blast SMSYola GreenSupport - Customer SupportNo1.0005/02/2025Callw ith Kyle on status and close out for prior TT that was deployed
ATN International37435BDC-incorrect bill display Eddie OlivaSupport - Customer SupportNo0.5005/02/2025Deployed fix onto TSS_Test and Sent email to One Comm so they can test and verify.
Antigua Public Utility Authority37431No email confirmation SelfcareYola GreenSupport - Customer SupportNo0.5005/02/2025Review changes
ATN International37435BDC-incorrect bill display Yola GreenSupport - Customer SupportNo1.5005/02/2025Recaculate the balance and retested -same issue- query tables get invoices and
 37434Customer recieving error when trying to pay their bill through selfcareInjinash GooshR&D - Sustained EngineeringNo1.0005/02/2025Hi Yola, The issue is the Display name on card has special character we enable to decode. I modified the name and replaced the character with ASCII one. please ask customer to make another test. Thank you,
Antigua Public Utility Authority37433Customer recieving error when trying to pay their bill through selfcareYola GreenSupport - Customer SupportNo1.0005/02/2025 Review- Internal discussion with MY and IG on findings and create RD TT- for further review
 37437BDC- incorrect bill display Alex DongR&D - Sustained EngineeringNo0.5005/02/2025Worked with Joe to discuss the issue and identify the fix
 37438Duplicate Account Name is displaying the same Account Multiple times in the GridJoe TaschnerR&D - Sustained EngineeringNo0.5005/02/2025:SUMMARY Prod Update Dup Name returns duplicates update to remove duplicates :PROCEDURS $/Series7/SQL/Procedures/syDupAccountNameSelect2AP.sql 29373
 37438Duplicate Account Name is displaying the same Account Multiple times in the GridEddie OlivaR&D - Sustained EngineeringNo0.5005/02/2025Wrote up bug found
 36251Agent Web AppJoe TaschnerR&D - Internal DevNo2.5005/02/2025Team meeting on Agent Wep App Discussed and tested Payment Tender and Change bugs reviewed how the VFP app works so we can write up the user story Discussed Invoice Creation issues on how the DueDate is updated when using Next Bill Traced the process stepped through and tested Contract Add which is now working
 36251Agent Web AppEddie OlivaR&D - Internal DevNo4.0005/02/2025Testing the Agent WebApp on new changes and bug fixes. Wrote up bugs found while testing. Responding on tickets that require feedback.
 37397Inconsistency with assignment of D100 BID to Fibre BID - TrystanInjinash GooshR&D - Sustained EngineeringNo1.0005/02/2025Hi Joe, From CALIX provisioning it calls SP APUA_SIPLineStatusChangeD20AP however the call on Apr 17th did not create DE requests in D100, but it created Apr 30th as expected. _BID ftth5600008 _BID 2685600008 calix calls select top 100 * from acSystemInterfaceQueue where UnitSystemKey in (213698, 213352,213348,213346) and Command like 'DE%' order by 1 desc d100 calls select top 100 * from acSystemInterfaceQueue where UnitSystemKey in (213696, 213349,213347,213345) and Command like 'DE%' order by 1 desc Thank you,
 30715PS meetingInjinash GooshPS - InternalNo0.5005/02/2025morning status meeting.
 37397Inconsistency with assignment of D100 BID to Fibre BID - TrystanJoe TaschnerR&D - Sustained EngineeringNo3.0005/02/2025reviewing the code and discussing this with the team This is being called by Provisioning however there is no logging to tell why the procedure did not work at this time. Suggestion is to add logging to the procedure. From Injinash: From CALIX provisioning it calls SP APUA_SIPLineStatusChangeD20AP however the call on Apr 17th did not create DE requests in D100, but it created Apr 30th as expected. _BID ftth5600008 _BID 2685600008 • calix calls select top 100 * from acSystemInterfaceQueue where UnitSystemKey in (213698, 213352,213348,213346) and Command like 'DE%' order by 1 desc • d100 calls select top 100 * from acSystemInterfaceQueue where UnitSystemKey in (213696, 213349,213347,213345) and Command like 'DE%' order by 1 desc
 34296R&D Product AdvancementInjinash GooshR&D - Internal Research/TrainingNo5.0005/02/2025continue working on payment process flow change.
 37437BDC- incorrect bill display Eddie OlivaR&D - Sustained EngineeringNo1.5005/02/2025Working with Joe on fixing this bug.
 37437BDC- incorrect bill display Joe TaschnerR&D - Sustained EngineeringNo2.5005/02/2025:SUMMARY Issue 37437 - - incorrect bill display at OneComm EPatch :SQL\Procedures SQL/Procedures/acBECalcAccountSPCCDataAP.sql 29004 :NOTE this is only one version back please assign ASAP Team After testing on 2 different databases we have confirmed the latest version of acBECalcAccountSPCCDataAP.sql fixes the problem with the missing 15 dollars.
 36251Agent Web AppAlex DongR&D - Internal DevNo1.5005/02/2025Daily Checkin and Deisgn Review meeting with team - Discussed testing related issues and various project updates, tested and discussed the bugs team reported
 36251Agent Web AppAlex DongR&D - Internal DevNo3.0005/02/2025Reviewed outstanding AzureDevops items from the team, provided feedback Tested and fixed the issues team reported. Continue the development of CRM APIs - Balances tab
 30605R&D - Support AssistanceAlex DongR&D - Sustained EngineeringNo2.5005/02/2025TT# 37418 - Invoice Distribution crash I have verified that Gabon doesn’t have the custom SP that had performance issue like APUA, it’s using the common SP odBaseInvBIDListXAP and it doesn’t need to be rewritten. After I purged the orphaned data from od tables and re-indexed all the od and invoices tables, it seems the order distribution is running fine and a lot faster now, below is the job for the latest TB which took 20 mins to complete.
 30607R&D - Internal MeetingsAlex DongR&D - Internal MeetingsNo0.5005/02/2025Daily Team Meeting
 30607R&D - Internal MeetingsEddie OlivaR&D - Internal MeetingsNo0.5005/02/2025Daily Meeting.
 30607R&D - Internal MeetingsJoe TaschnerR&D - Internal MeetingsNo0.5005/02/2025daily team meeting
 30562MISC Support (Department Use Only) - Internal ReportingEddie OlivaSupport - Internal ReportingNo1.0005/02/2025Responding to emails and questions.
 30592MISC Support (Department Use Only) - Internal Staff Meetings & EventsYola GreenSupport - Internal Staff Meetings & EventsNo0.5005/02/2025Daily
 37397Inconsistency with assignment of D100 BID to Fibre BID - TrystanJoe TaschnerR&D - Sustained EngineeringNo0.5005/05/2025follow up sent log info to the team Hi Team, This was tested locally in pieces, however my access to this file was denied. APUA_SIPLineStatusChangeD20AP.sql If isnull(@Status,'') <> '' Begin insert into syEventLog (EventTime, SourceName, SourceID, MessageType ,MessageNum , Description ) select getdate(), 'SIPD20' as SourceName, @SystemInterfaceQueueKey as SourceID, 'I' as MessageType, 0 as MessageNum, 'SIPD20 Called' + @Status End IF @Status = 'DE' OR @Status = 'DU' BEGIN If isnull(@SIPUnitSystemKey,0) > 0 Begin insert into syEventLog (EventTime, SourceName, SourceID, MessageType ,MessageNum , Description ) select getdate(), 'SIPD20' as SourceName, @SIPUnitSystemKey as SourceID, 'I' as MessageType, 0 as MessageNum, 'SIPD20 Deact Called' + @Status End Thanks Kind Regards, Joe
 30609R&D - G&AJoe TaschnerR&D - G&ANo0.5005/05/2025gen admin record time pc and azure reboots
 30562MISC Support (Department Use Only) - Internal ReportingEddie OlivaSupport - Internal ReportingNo1.5005/05/2025Working on support issues as Yola is out.
 34068M&S ManagementYola GreenSupport - G&ANo40.0005/05/2025Illuminate 2025
 37427Digicel CSR Issue reported from Site visitEddie OlivaR&D - Sustained EngineeringNo0.5005/05/2025Reviewed and sent email to Yola regarding the update needed out at Digicel to fix some of the issues being reported by them.
 34296R&D Product AdvancementInjinash GooshR&D - Internal Research/TrainingNo7.5005/05/2025payment changes are made, running test with Eddie.
 37427Digicel CSR Issue reported from Site visitJoe TaschnerR&D - Sustained EngineeringNo2.0005/05/2025review top 6 issues in depth and found duplicates and sent them to the team also communicated a fix for future duplicates from being created
 37438Duplicate Account Name is displaying the same Account Multiple times in the GridEddie OlivaR&D - Sustained EngineeringNo1.5005/05/2025Tested and committed the update.
 37427Digicel CSR Issue reported from Site visitJoe TaschnerR&D - Sustained EngineeringNo2.0005/05/2025continued to investigate all of the log issues
Tonga Communications Corp37439commit bill for April - is very slowEddie OlivaSupport - Customer SupportNo1.5005/05/2025Investigating and found out SQL Server is using the Maximum RAM on the server. It should be set to 80% of the total RAM on the server. Re-configured the SQL Server to only use 80% of the system RAM. I let Nela know he'll need to reboot the server for the configuration to take into effect.
 37427Digicel CSR Issue reported from Site visitJoe TaschnerR&D - Sustained EngineeringNo3.0005/05/2025more revieing of the logs and found a procedure that will help performance once applied at Digicel for large accounts AT Digicel this would be the best account to test the performance gain exec sp_executesql N'Exec ful_AB_GetActiveBIDsAP @CustomerKey = @P1 , @Language = @P2 ',N'@P1 float,@P2 varchar(3)',713,'ENG' :PROCEDURES SQL/Procedures/ful_AB_GetActiveBIDsAP.sql 29093
 36251Agent Web AppEddie OlivaR&D - Internal DevNo3.0005/05/2025Working on Agent Web APP on testing bug fixes and new features.
Strata Networks37151Strata OSS360 client update.Eddie OlivaSupport - Customer SupportNo3.0005/06/2025Upgraded Strat's production db to version 7.6.1.79.
Progresif Cellular Sdn Bhd.37440Password configuration in sqlEddie OlivaSupport - Customer SupportNo0.7505/06/2025Reviewed TT, responded and closed
Gabon Telecom37441Bank Deposit SplitEddie OlivaSupport - Customer SupportNo0.2505/06/2025Review TT.
 37427Digicel CSR Issue reported from Site visitJoe TaschnerR&D - Sustained EngineeringNo3.0005/06/2025review the remainder of the Aris log dbf reviewed code behind and procedures to determine next steps
 37427Digicel CSR Issue reported from Site visitJoe TaschnerR&D - Sustained EngineeringNo2.0005/06/2025modified and tested acUnitAndEquipmentAP for performance increase went from 17 milliseconds to 4 miliseconds with modifications turned in code change to QA :PROCEDURES SQL/Procedures/acUnitAndEquipmentAP.sql 29374
 37427Digicel CSR Issue reported from Site visitJoe TaschnerR&D - Sustained EngineeringNo1.0005/06/2025Research uncovered the following procedure to be applied when possible to in crease Fullilment and CRM screens. Comms with Eddie on getting this applied at Digicel. This Change speeds up the procedure by 80 percent At Digicel this would be the best account to test the performance gain exec sp_executesql N'Exec ful_AB_GetActiveBIDsAP @CustomerKey = @P1 , @Language = @P2 ',N'@P1 float,@P2 varchar(3)',713,'ENG' :PROCEDURES SQL/Procedures/ful_AB_GetActiveBIDsAP.sql 29093
 37443Unapplied Customer PaymentEddie OlivaR&D - Sustained EngineeringNo0.2505/06/2025Created and assigned ticket to Injee.
Antigua Public Utility Authority37442Unapplied Customer PaymentEddie OlivaSupport - Customer SupportNo1.0005/06/2025Reviewed and assigned R&D ticket
Antigua Public Utility Authority37431No email confirmation SelfcareEddie OlivaSupport - Customer SupportNo0.5005/06/2025Responding to emails and getting confirmation on upgrading Apua's production subscriber portal.
 36251Agent Web AppEddie OlivaR&D - Internal DevNo2.5005/06/2025Testing new updates from the Agent Web App. Meeting with Joe and going over one of the tickets to agree on how it's supposed to work.
Antigua Public Utility Authority37442Unapplied Customer PaymentEddie OlivaSupport - Customer SupportNo0.2505/06/2025Recieved information from Tijon and closed the ticket.
 37425Unapplied Payment from SelfCare not Applied in OSS360 - TrystanEddie OlivaR&D - Sustained EngineeringNo1.5005/06/2025Testing update from Injee as he was asking for feedback.
ATN International37338OneComm - Payment failed with message "Missing field(s): CardExpiration" but posted in OSS360Eddie OlivaSupport - Customer SupportNo1.0005/06/2025Checked compatibility on Danielle's request to add TT#37411 along with this deployment next week. Checked compatibility and added update to this minipatch.
 36251Agent Web AppJoe TaschnerR&D - Internal DevNo1.0005/06/2025worked with Eddie on the new Duplicate feature turned in by Covalance determined the function worked as requested comms to Alex that the Ticket is closed
 36251Agent Web AppJoe TaschnerR&D - Internal DevNo1.5005/06/2025sprint planing and showcase of new features with Covalance on the Agen Web app Promote Optional Rate Code Contract add and select feature
 30562MISC Support (Department Use Only) - Internal ReportingEddie OlivaSupport - Internal ReportingNo1.0005/07/2025Responding to emails in the support inbox.
 30603R&D - Research & DevelopmentJoe TaschnerR&D - Internal DevNo1.0005/07/2025reviewing the followUP processes from 2013 there have been minimal changes however there are still some bugs in the legacy code
 36251Agent Web AppEddie OlivaR&D - Internal DevNo1.0005/07/2025Meeting with Joe and Alex and going over the next iteration.
 37437BDC- incorrect bill display Joe TaschnerR&D - Sustained EngineeringNo0.5005/07/2025comms with QA on a new issue
 36251Agent Web AppJoe TaschnerR&D - Internal DevNo1.5005/07/2025Agent Web app new future phases discussed such as CRM, Sales/Invoice, Fulfillment Rate Change, ExchangeID, Transfer, Deact/React.
 37427Digicel CSR Issue reported from Site visitJoe TaschnerR&D - Sustained EngineeringNo1.0005/07/2025comms with Alex on item 9 which he will update the service to fix this as it could be an issue with all the fields not just the comments
 37427Digicel CSR Issue reported from Site visitJoe TaschnerR&D - Sustained EngineeringNo4.0005/07/2025Spent time on acServiceInterfaceQueue option 9 issue Alex is looking into the Service to see if all the failures can be addressed. Hi Inji and Alex, For this issue from Digicel TT37427 complaint 9. acOFSCCreateActivityFTTHAP.sql. I am seeing that we do not filter out the VOIP IDs when adding the request to the Queue like the OFSCUpdateActivity does. This account 00005634613 did a Rate Plan change to go off of the VOIP plan and stopped the VOIP number in acUnitSystemsDetail. I remember we added logic to keep the number in acUntiSystemDetail but with Start and Stop Dates set to the same so it is there but stopped. Digicel is complaining about the Failed Status in the request and they think it is from a number not being a number which I did not fully understand it is in the TT37427. Please read below these details and see if you understand my proposal. exec _LU 00005634613 Acct Name CustomerKey Status Type ----------------------- ----------- ------------------- ---------------------------------------- Sacha Andrews 551117 Active Edit Rating FTTH Consumer exec _BID 310005006021 RatePlan Status StartDate ----------------------------------------- ------------- ----------------------- Biggest TV & Broadband A 2025-01-31 22:00:20.800 Biggest TV, Broadband & Voice I 2023-08-24 21:25:37.183 select ServiceName, Method, Status, StatusDate, Response from acServiceInterfaceQueue where ServiceInterfaceQueueKey = 1153546 ServiceName Method Status StatusDate Response ---------------------------------------- ---------------------------------- ------ ----------------------- ----------------------------------------------------- OracleFieldServiceInbound create_activity F 2025-04-28 10:06:26.280 Failed to create activity, error detail: BadRequest select ParameterGroup, ParameterValue from acServiceInterfaceQueueParams where ServiceInterfaceQueueKey = 1153546 and ParameterValue = '4412963129' ParameterGroup ParameterValue ------------------------------------------------------------------------- ------------------------------------ command1.appointment.properties.property22 4412963129 Procedure acOFSCCreateActivityFTTHAP.sql does not filter out StartDate and StopDate on phone numbers from acUnitSystemsDetail. Proposal:::: Since they are complaining about the number I would like to change the Procedures for Create Activity to not pick up the Detail row on create activity when the row is not active. select Detail, StartDate, StopDate from acUnitSystemDetail where UnitSystemKey = 1114975 Detail StartDate StopDate ---------------- ----------------------- ----------------------- 4412963129 2025-01-31 22:00:20.800 2025-01-31 22:00:20.800 Please respond if you think this may help and I will update the procedures. Thanks Kind Regards, Joe
Strata Networks37151Strata OSS360 client update.Eddie OlivaSupport - Customer SupportNo1.5005/07/2025Glade sent in an email of an issue after the upgrade about not able to edit and verify the CC number on the Contract Terms. In investigating there is an update which I checked the compatibility and created a minipatch and deploye out at Strata's test db A360Training. i asked Glade to test and verify before deploying onto production.
Digicel Bermuda37365Customer's 50 free call allowance not showing on Invoice Account 4537403Eddie OlivaSupport - Customer SupportNo1.0005/07/2025Verifying fix after Alex re-rated the usage on the account in question. I can see the correct 50 on the invoice now.Responded to Makeba's email.
ATN International37435BDC-incorrect bill display Eddie OlivaSupport - Customer SupportNo1.0005/07/2025Reviewing new issues reported by lissa and let Joe know about the new issue.
Progresif Cellular Sdn Bhd.37440Password configuration in sqlEddie OlivaSupport - Customer SupportNo0.5005/07/2025Responded to Amalina's email and sent her a link about SQL Server password complexity.
Gabon Telecom37441Bank Deposit SplitEddie OlivaSupport - Customer SupportNo2.0005/07/2025Trying to re-create issue but still have questions on this issue as I'm not sure what the Bank Deposit slips are that Gabon is referring to.