Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Steve Burney]

Hello everyone!
We have concurrent licenses for 98 GP users and we have about 78 GP logins today.
We have one user who can log into GP but immediately gets the following screen shot.
We have searched for temp files that could be causing this but I am searching for more resolutions in case anyone has a suggestion.
Any assistance would be appreciated!
Thanks, Steve

——————————
Steve Burney
Senior Systems Architect
Nissan Trading Corporation, Americas
Lebanon, TN United States
steve.burney@us.nitco.co

Chairman, Nashville (TN) GPUG Chapter
GPUG Ruby Award 2018
GPUG All Star 2017
Twitter @SteveBurney

GP2016 R2
MRCU14
——————————

[David Musgrave]

Hi Steve

Their local workstation’s drive that holds the %TEMP% folder is full.

Simples

David

FYI: This is a memory table (stored as a ctree table in the local workstation’s %TEMP% folder) used by Field Level Security (written by me) to store trigger tags.  GP Power Tools and a number of other products that use memory tables or local temporary tables would have similar issues when the local hard disk is full.

——————————
David Musgrave MVP, GPUG All-Star

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com
——————————
——————————————-

[Bruce Strom]

Elaborating on what David Musgrave is saying, most of the Report Writer reports also create temp tables on the “local” workstation, which would be the Citrix metaframe or RDS server in many large installs.

——————————
Bruce Strom
Programmer Analyst
Associated Grocers of Florida / Supervalu
Sunrise FL
——————————
——————————————-

[David Musgrave]

Actually, you will find more local temp files used on windows rather than reports.

Reports should use SQL temp files so that the SQL optimisation in the report writer can work. As long as all tables are SQL tables the Report Writer can use a single Select statement with joins rather than reading records from each table row by row.

Also anywhere the temporary data can be expected to get to a large size, developers should use SQL temp tables and not local ctree temporary tables.

I cover this when I train Dexterity. Next training planned for the week before Summit in Orlando. ??

Regards

David

——————————
David Musgrave MVP, GPUG All-Star

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com
——————————
——————————————-

[Bruce Strom]

Why are so many of the Great Plains TEMP tables actually CTree tables?  Why don’t they change them to be SQL tables?
I was told by Dexterity support that they made a change some versions back, now all memory tables are actually TEMP SQL tables.

——————————
Bruce Strom
Programmer Analyst
Associated Grocers of Florida / Supervalu
Sunrise FL
——————————
——————————————-

[David Musgrave]

Hi Bruce

Local Ctree Temporary tables are faster and have much less overhead when creating and removing them. Local hard drive is still faster than network.

Only if they will have large amounts of data, will be used with reports or you want to use SQL optimised commands such as range where or populating with insert into from a select statement should you use SQL Temporary tables.

The change with Memory tables was to remove them from contiguous physical memory because if they got too big they would cause crashes. So instead, they are implemented using local ctree tables in a temporary folder in the system’s TEMP folder. So they are not as fast as they were, but more stable and still faster than SQL.

Memory tables are available for the entire time an instance of GP is running when temporary tables are only in scope while the form or procedure that created them is open/active.

Regards

David

——————————
David Musgrave MVP, GPUG All-Star

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com
——————————
——————————————-

[Bruce Strom]

Thanks for the insight.  I brought this up, in part, because we had problems with our local cTree temp files throwing errors until we added resources to our Citrix metaframe servers, I thought it would be useful info for everyone.

——————————
Bruce Strom
Programmer Analyst
Associated Grocers of Florida / Supervalu
Sunrise FL
——————————
——————————————-