Timberline A/P - I/O error, pervasive status code 46.  Access to ......

Posted on 2013-01-21
Last Modified: 2013-11-22
I  am using Timberline Accounts payable module.  When trying to access the a/p I get an error message "error opening files".  Says that the master.CMM file may be corrupt and to use file doctor.  I go to the file doctor to fix any file problems and am receiveing an "I/O error, pervasive status code 46 - access to...." message.      I use Carbonite and was able to replace the existing file with an old backup file from a week ago (a/p module was working properly at that time).  I have read that the file may be "read only" as a result of simultaneous access from either the carbonite back up or the McAfee virus scanning software.  Any way to correct the file by removing the "read only" or could it be a different file that is causing the problem?
Question by:orlewis3
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 28

Expert Comment

by:Bill Bach
ID: 38802156
For the corrupted file, please check the PVSW.LOG file on the server or on the workstation (depending on your configuration).  If this is reporting any "System Errors", then check the files that are being reported there.

For the Status 46, this indicates that the file is ReadOnly.  This could be for any of the following reasons:
- The file is flagged ReadOnly. (Could be possible if you recovered from a CDROM).
- Your user has ReadOnly OS access rights.
- The Engine has ReadOnly OS access rights.
- The file is being actively backed up in "Deny_Write" mode.
- The file is opened by an anti-virus application at the same time the engine is trying to access it.
- The file is in the old Btrieve 5.x file format.

Most of these are self-explanatory.  Rebooting or checking access rights usually does the trick.  Note that the Engine may be loaded as "SYSTEM" on the server, so be sure to check those rights, too.  For the last item (which is highly doubtful), check this with BUTIL -STAT, or do a Stat Report from the Maintenance Utility, and see what you get.  If needed, rebuild the file.

Author Comment

ID: 38802299
Thank you for responding to my question so quickly.  I checked the PVSW.LOG file and it shows nothing, so we are good there.  With regard to access rights, do you mean right clicking the file to see if the "read only" box is checked?  I did that and it is not checked.  Not sure what other ways exist to make sure the file can be written to.  Even if the file was read only, I am still getting the message "error opening file".  I wish I was a bit more computer savvy, but unfortunately am not.  Any other guidance you can offer?
LVL 28

Accepted Solution

Bill Bach earned 500 total points
ID: 38802331
The right-click property is only one attribute, the ReadOnly flag on the file.  Right-click the folder and select Security.  Make sure that the users who are attempting to access the database, as well as the database engine itself, have access to the folder.  If you're not sure about which account the engine is running under, find the engine service, right-click properties on THAT, and go to the Logon As tab.
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


Author Comment

ID: 38840563
Thanks for your assistance in helping me solve this problem.  I have been out of town for the last 10 days and am just now getting back to this.  So far, I have not been able to solve it.  I tried installing an the oldest copy of this file using the Carbonite backup program and the program still says this file may be corrupt.  I am now thinking it is not the file that is bad, but the program that is causing the problem.  Any other thoughts?
LVL 28

Expert Comment

by:Bill Bach
ID: 38840641
Can you post the file for analysis?  If you need a secure upload location, you can send it to me by following the instructions here:

Author Comment

ID: 38841021
I kept digging around some of my older backups and found a file that was not corrupted.  It was marked as read only.  I restored that file, unchecked the read only box, and now it is working fine.  I appreciate all of your time in helping me resolve this issue.  Many thanks!

Featured Post

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Read about achieving the basic levels of HRIS security in the workplace.
Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question