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");
}

All responses (5)

Answers (2)

Doug E. 5 on at

Like (0)

Report

RE: The Record Has Never Been Selected - smmActivities

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

Sergei Minozhenko 23,091 on at

Like (0)

Report

RE: The Record Has Never Been Selected - smmActivities

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.
Suggested answer

Mohsin Khalid 501 on at

Like (0)

Report

RE: The Record Has Never Been Selected - smmActivities

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);
Verified answer

vinitgoyal2005 6,330 on at

Like (1)

Report
RE: The Record Has Never Been Selected - smmActivities

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"); }
Verified answer

Gunjan Bhattachayya 35,421 on at

Like (1)

Report
RE: The Record Has Never Been Selected - smmActivities

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"); }