| View previous topic :: View next topic |
| Author |
Message |
supergeniusdan
Joined: 29 Sep 2006
Posts: 2
Location: Aurora, Colo.
|
 Posted: Fri Sep 29, 2006 3:07 pm Post subject: Excessive file errors |
 |
|
I have been working with this for weeks and finally felt I had all the bugs worked out, but this came back. I am consolidating an old Notepager and not as old Pagegate server onto newer hardware. I have taken and copied the databases for each, and exported the databases for both as well to a location on the new server. I proceed to install Pagegate 4.0 on the new server, then on it’s first start, point to the old notepager DB, followed by the upgrade notification. I accept and it upgrades the database fine. Then I start to import the old pagegate items (carriers.txt, groupmem.txt etc.) And they all import perfectly, until I reach the recip.txt. At this point I would receive the message
[b]PG Admin Fatal Error
Excessive file errors: 75 Path/File access error in Procedure: update_cgi_userlist
“OK” to continue or “Cancel” to stop.[/b]
In my testing I verified file permissions, and I’m the domain admin with full rights to this domain member server, but found that after reaching this point I was able to run the “Rebuild Database” tool, and then the import would work fine.
Now, I’m on the new server following all I had done before in test, and I receive this same error message. I have tired several times to rebuild the database, and still unable to import the 561 user (recip.txt) file. All the others (carrier, groupmem, connect and settings.txt) imported fine from the exact location. Having successfully done this in test using production data I even tried exporting the recip.txt data from it and still receive the same error. I’m stumped.
Thanks for your input.
|
|
| Back to top |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4387
|
| Posted: Fri Sep 29, 2006 3:18 pm Post subject: |
|
|
| You may be running into a #NULL# value problem in the import of the recipients. If you would, please email the old database and the files you want to import to support@notepage.com - I'd like to have a look at the data. |
|
| Back to top |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4387
|
| Posted: Fri Sep 29, 2006 3:57 pm Post subject: |
|
|
| For whatever reason, there's a double entry of your "All" recipient in the recip.txt file. All you should have to do is edit out the double entry or just remove the "All" entry entirely. After that, it should import the 561 recipient entries. |
|
| Back to top |
|
supergeniusdan
Joined: 29 Sep 2006
Posts: 2
Location: Aurora, Colo.
|
| Posted: Mon Oct 02, 2006 11:31 am Post subject: |
|
|
| I took your suggestion and tried removing the duplicate “All” entry, and even removed the entire line and am still not able to import this file. Proceeding with this thought process of a single entry causing this I attempted to isolate the offending line. I started by removing all but the top 10 lines, but this too failed. I then took the top 10 lines from the file and it again failed. The part of this that is most confusing is I’m exporting this recip.txt file from the same version of PageGate I’m trying to import to. I have reviewed the comma separated items and it all seems to be right on. I have even run a line by line (for the first ten lines) comparison of an export from the new server (upgrade of the NotePage database) and these exports, and it’s all consistent. I am really at a loss on why it won’t import.
|
|
| Back to top |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4387
|
| Posted: Fri Oct 06, 2006 8:58 am Post subject: |
|
|
I've gone a little cross-eyed trying to figure out why the export/import wasn't working and then it dawned on me that there was an easier way to do it, especially since you have the old database still on hand.
The database file in the pagegate.mdb.zip file that you sent had a 21MB database dated 9/29/2006.
Open the file with Access and go to Tools - Compact and Repair Database. You'll notice that after the compact and repair, the file goes from being 21MB to 5.4MB. Chances are, that original database had some form of header corruption in it, which may have been why the export/import didn't work so well.
In any event, after you compact and repair the database, take that pagegate.mdb file and copy it into the new Pagegate directory. It'll ask if you want to overwrite the file, say yes.
Run the PageGate Admin again.
It'll ask if you want to upgrade the database from version 3 to version 4, say yes.
Run the PageGate Admin one more time and you're good to go. |
|
| Back to top |
|
|
