News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Running error

Microsoft Dynamics GP (Archived)

Running error

(0) Share

Report

Report

Posted on by cwang

365

While we run script as following: ( GP script SQL )

RUN ONLY THIS PORTION IF IT IS "STILL RUNNING" BUT ONLY DO THIS IF YOU ARE SURE ITS NOT}

set 'D_Batch Source' of table S_Batch_Activity_MSTR to "JTETRX";

set 'D_Batch #' of table S_Batch_Activity_MSTR to "JTETRX";

set 'D_User ID' of table S_Batch_Activity_MSTR to "PCONT";

change table S_Batch_Activity_MSTR;

remove table S_Batch_Activity_MSTR;

warning "Process Completed";

IT show us error message box as:

A remove operation on table "S_Batch_Activity_MSTR' failed, because the record could not be locked.

Please help !

*This post is locked for comments

All responses Img

All responses (4)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Running error

It sounds like you don't have a save table anywhere in your code which will add the record to the database table. You are setting the field values of the table buffer but not saving the table buffer to the database.

When you installed Dex it should have installed a copy of SANSCRIPT.pdf which is one of the Online Help Manuals. It will explain all the commands much better than I can.
cwang 365 on at

Like (0)

Report

RE: Running error

can you tell me some command about GP,

Release table

get table

change table

remove table

save table

others
cwang 365 on at

Like (0)

Report

RE: Running error

Ok. I do as you said. It seems table no record, whatever we do the set process, why? can you tell me?
Community Member Microsoft Employee on at

Like (0)

Report

RE: Running error

It sounds to me like the record does not exist.

I would usually use err() to test I have the record before removing it.

e.g.

change table S_Batch_Activity_MSTR;

if err() = OKAY then

remove table S_Batch_Activity_MSTR;

end if;

If you know the record does exist and there is some other issue you might like to try adding a check error to give you more information on why the change didn't work.

e.g.

change table S_Batch_Activity_MSTR;

check error;

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans