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
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
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
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
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
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
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
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.
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.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
