The Record Has Never Been Selected - smmActivities

(0) Share

Report

Posted on by Doug E.

I have a piece of code that works 90% the other 10% occasionally it breaks and I receive the "record has never been selected" error. I've checked smmActivities table up and down and while I'm sure there's something I'm missing it just isn't evident to me. Is there something my code is missing? Why does it work sometimes and other times it doesn't?

This code is meant to reassign open activities to a worker when assigned to new territory.

Thanks in advance,

Doug

static void AssignActivitiesByCustomer(Args _args)
{
    CustTable                   _custTable;
    smmActivityParentLinkTable  _smmActivityParentLinkTable;
    smmActivities               _smmActivities;


    while select *  from _custTable where _custTable.MainContactWorker == HcmWorker::findByPersonnelNumber("000297").RecId
    {
        while select * from _smmActivityParentLinkTable where _smmActivityParentLinkTable.RefTableId == 77 && _smmActivityParentLinkTable.RefRecId == _custTable.RecId
        {
            _smmActivities = smmActivities::find(_smmActivityParentLinkTable.ActivityNumber, true);
             if(_smmActivities.Closed == NoYes::No)
            {
                if(_custTable.MainContactWorker != _smmActivities.ResponsibleWorker)
                {
                    _smmActivities.ResponsibleWorker = _custTable.MainContactWorker;
                    _smmActivities.update();

                }
            }

        }
    }
info("Complete");
}

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report
Hio Doug,

Maybe there are no matching smmActivities records for the times they are failing. You can have a check for that to get rid of this error -

static void AssignActivitiesByCustomer(Args _args) { CustTable _custTable; smmActivityParentLinkTable _smmActivityParentLinkTable; smmActivities _smmActivities; while select * from _custTable where _custTable.MainContactWorker == HcmWorker::findByPersonnelNumber("000297").RecId { while select * from _smmActivityParentLinkTable where _smmActivityParentLinkTable.RefTableId == 77 && _smmActivityParentLinkTable.RefRecId == _custTable.RecId { _smmActivities = smmActivities::find(_smmActivityParentLinkTable.ActivityNumber, true); if(_smmActivities && _smmActivities.Closed == NoYes::No) { if(_custTable.MainContactWorker != _smmActivities.ResponsibleWorker) { _smmActivities.ResponsibleWorker = _custTable.MainContactWorker; _smmActivities.update(); } } } } info("Complete"); }

Was this reply helpful? Yes No
Verified answer

vinitgoyal2005 6,332 on at

Like (1)

Report
Hi,

Add a condition to check if _smmActivities exists.

static void AssignActivitiesByCustomer(Args _args) { CustTable _custTable; smmActivityParentLinkTable _smmActivityParentLinkTable; smmActivities _smmActivities; while select * from _custTable where _custTable.MainContactWorker == HcmWorker::findByPersonnelNumber("000297").RecId { while select * from _smmActivityParentLinkTable where _smmActivityParentLinkTable.RefTableId == 77 && _smmActivityParentLinkTable.RefRecId == _custTable.RecId { _smmActivities = smmActivities::find(_smmActivityParentLinkTable.ActivityNumber, true); if(_smmActivities && _smmActivities.Closed == NoYes::No) { if(_custTable.MainContactWorker != _smmActivities.ResponsibleWorker) { _smmActivities.ResponsibleWorker = _custTable.MainContactWorker; _smmActivities.update(); } } } } info("Complete"); }

Was this reply helpful? Yes No
Suggested answer

Mohsin Khalid 501 on at

Like (0)

Report

Doug what you can also do is refresh the _smmActivites buffer before you set the reference. There is a bug in X++ on using same buffers for different values in while loops. add line below before line 12

_smmActivities.refresh();

_smmActivities = smmActivities::find(_smmActivityParentLinkTable.ActivityNumber, true);

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Doug,

Have you checked if you have orphaned records in smmActivityParentLinkTable with non existing activityNumber (you can create non exist join query to check it)? There could be some process that deletes activity without cleaning linkTable and it's causing issues in your code.

As a quick solution, you can check if activity exists, but who know how the system will behave in other processes.

Was this reply helpful? Yes No
Doug E. 5 on at

Like (0)

Report

Thanks for the quick response everyone! Adding the check for existing records allowed me to proceed with the job for this user.

Was this reply helpful? Yes No