web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Error Opening a Temp T...
Microsoft Dynamics GP (Archived)

Error Opening a Temp Table

(0) ShareShare
ReportReport
Posted on by Community Member

I'm getting below error accessing a temp table and not sure what's wrong. Any help ? Temp table is of type Memory. 

An open operation on table 'XXXXX_Temp' has caused an unknown error (46).

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    I think u may wrongly created the Temp table when u creating Temp table make sure physical address is "temp" it won't get error.

  • Community Member Profile Picture
    Community Member on at

    Thanks, Table is created properly. I am getting this error intermittently. I also tried to follow few other articles which asks to clear the temp folder and exclude .idx, .dat files from any antivirus.  but still no luck.

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,095 Most Valuable Professional on at

    According to docs.faircom.com/.../52855.htm

    Ctree Error 46 is FUSE_ERR

    File number is already in use. If possible, increase the FILES setting in the server (or the fils parameter of INITISAM() for standalone). In releases after V10.3, the default for MAX_FILES_PER_USER has been increased from 2048 to 32767 to avoid file opens failing due to the lower limit.

    Also see MBS document: c-tree and FairCom Server Error Codes

    Look at CTERROR.PDF in the Dexterity Manuals folder.

    How many ctree (temp or memory) tables are you trying to open?

    David

  • Community Member Profile Picture
    Community Member on at

    Hi David,

    Thanks for your reply, I'm on Dex 8.0 standalone app. So i think for now the only option is to increase the settings. Where exactly do i need to specify the setting ?

    There is a set of 3 function (uses temp table ) which is called in a loop for say 500+ times and it end up with this error in between.

    Thanks,

    Himal

  • Verified answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,095 Most Valuable Professional on at

    Hi Himal

    Are you passing the table buffer when you make the call?

    If you pass the table buffer you can avoid re-opening the table (or if temp, re-creating it).

    It will give better performance and less chance of error.

    Better still............... Just use a later Dexterity version.

    David

  • Community Member Profile Picture
    Community Member on at

    I think it is passing the table buffer as parameter at all the places. but it could be missing somewhere. I'll check it out.

    Yes, agree that upgrade is the best option. But I'm not sure how much time would it take to upgrade from 8.0 to latest version and what all issue come up. So will be doing upgrade when time permits.

    By the way, Is there any setting for Dex 8.0 (One you mentioned above - INITISAM ) so it can increase the # of temp files ? If it does, then how can i set it ?

    Thanks,

    Himal

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,095 Most Valuable Professional on at

    I don't know that you can change the setting with the ctree implementation built into Dexterity.

    I think it used to be possible with the DOS FILES=XX command in the Config.sys, but this is not valid anymore.

    David

  • Community Member Profile Picture
    Community Member on at

    Hi David,

    Thanks for your help. Temp table was used for different purpose in different script. added the script to close them explicitly and then it seems to be working cool.

    Appreciate your help; You saved a day!

    Cheers,

    Himal

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans