Can't run EOD

[corbin]

We are unable to run the UPS End of Day right now. It is throwing errors on the client workstations.

When I try to run ShipRushDBManager, Repair/Index Rebuild I get:

DBISAM Engine Error #9217 Error reading from the table or backup file 'PrintableDocument'

I have tried purging older shipments and also get the same error. I'm stuck at this point and really need to be able to close EOD from yesterday and start shipping today.

[SYSOPR]

Sorry to hear there are issues.

The steps are probably these steps:

- check the shiprushserver.log file, it may help us understand why / what the EOD error is
- The dbmanager can only be used on the shiprush db server system, when all copies of SR are closed (including stopping the service)

If the above doesn't get you there, I suggest opening a paid support call so a tech can help out.

[corbin]

I called into support who told me to follow these instructions: http://www.zfirm.com/knowledge_bases.../srxa-0251.txt

Unfortunately, those instructions duplicate what I have already described. Any other suggestions?

[SYSOPS]

Locate the ShipRushServer.log which will be in the database\dblock folder. Please email that into support at shiprush dot com. We can review the log to see why the EOD is failing (if it's different than the error you're getting trying to run a repair).

Here's the kbase article on the error in question:
http://www.zfirm.com/knowledge_bases.../srxa-0251.txt

Possible alternate solution, looking at the error you've posted:
On a workstation, see if there's a database folder with the PrintableDocument files available
If so, make sure ShipRush is completely exited on all machines and stop the Z-Firm Shipping Service on the server
Remove the PrintableDocument files from the database on the server (don't delete, move for now or have a copy, just in case)
Take the PrintableDocument files from another machine and replace in the database on the folder

Start the service and see if you can process EOD again.

SYSOPS

[TogsTeam]

We're having the same issues, but it's probably because I hashed something up - I had to migrate our SR Server files from an XP box to a temporary Win7 box after the former crashed, and I may have overwritten the wrong files. Relevant srs.log contents are shown below. I installed SR9 UPS Pro on the new Win7 box, then copied over the files from the old directory, and adjusted the DBISAM values to match the new location. I've also just downloaded and installed/repaired SR9, and rebooted after each step, but it still can't run the EOD.

The main SR engine is working, we have shipments in the db, and it knows that it hasn't done an EOD, as I keep getting prompted for it.

From the log:
4/12/2012 3:27:14 PM 9.6.0.49709 EOD Start processing EOD request
4/12/2012 3:27:15 PM 9.6.0.49709 EOD Processing EOD, 3 activities found
4/12/2012 3:27:17 PM 9.6.0.49709 EOD Processing Activity 1, ID: "107550", started: 2012-04-10 14:16:04, Shipments: 14
4/12/2012 3:27:18 PM 9.6.0.49709 EOD (ID=107550) PLD File Name: "c:\program files\z-firm llc\shiprush v9\PLD\201204121527183610.PLD"
4/12/2012 3:27:22 PM 9.6.0.49709 ERROR (ID=107550) PLD Encoding failed: Account/Mailbox pair not found in the UPS subsystem ('Y56A35'/'SYSTEM_MOS09068117630231')
4/12/2012 3:27:23 PM 9.6.0.49709 EOD Processing Activity 2, ID: "107665", started: 2012-04-10 16:14:53, Shipments: 3
4/12/2012 3:27:23 PM 9.6.0.49709 EOD (ID=107665) PLD File Name: "c:\program files\z-firm llc\shiprush v9\PLD\201204121527230101.PLD"
4/12/2012 3:27:23 PM 9.6.0.49709 ERROR (ID=107665) PLD Encoding failed: Account/Mailbox pair not found in the UPS subsystem ('Y56A35'/'SYSTEM_MOS09068117630231')
4/12/2012 3:27:24 PM 9.6.0.49709 EOD Processing Activity 3, ID: "107733", started: 2012-04-12 13:27:43, Shipments: 11
4/12/2012 3:27:24 PM 9.6.0.49709 EOD (ID=107733) PLD File Name: "c:\program files\z-firm llc\shiprush v9\PLD\201204121527248192.PLD"
4/12/2012 3:27:25 PM 9.6.0.49709 ERROR (ID=107733) PLD Encoding failed: Account/Mailbox pair not found in the UPS subsystem ('Y56A35'/'SYSTEM_MOS09068117630231')
4/12/2012 3:27:26 PM 9.6.0.49709 Manifest (TUPSManager.IntExecuteManifest) Alert! UPS did not receive your shipping data. Please stop using ShipRush and contact ShipRush support.

One or more errors performing End-Of-Day. See "shiprushserver.log" file for details.
4/12/2012 3:27:28 PM 9.6.0.49709 ERROR Alert! UPS did not receive your shipping data. Please stop using ShipRush and contact ShipRush support.

One or more errors performing End-Of-Day. See "shiprushserver.log" file for details.
4/12/2012 3:27:29 PM 9.6.0.49709 MAIL Start checking/processing mail
4/12/2012 3:27:29 PM 9.6.0.49709 MAIL Receiving UPS Mail
4/12/2012 3:27:32 PM 9.6.0.49709 MAIL Checking mail (CONFIG) - Listed 0 messages
4/12/2012 3:27:32 PM 9.6.0.49709 MAIL Checking mail (DIST) - Listed 0 messages
4/12/2012 3:27:33 PM 9.6.0.49709 MAIL Checking mail (ADDR VAL) - Listed 0 messages
4/12/2012 3:27:34 PM 9.6.0.49709 REDIST UPS Distributable Mail is processed: sVersion: "", sDistrType: "", sDistrID: ""
4/12/2012 3:27:35 PM 9.6.0.49709 MAIL (TUPSManager.ProcessMail) Error processing UPS Mail : UPS File Distribution: Mail attacment is missing [07111703260744.89721812]
4/12/2012 3:27:36 PM 9.6.0.49709 REDIST UPS Distributable Mail is processed: sVersion: "", sDistrType: "", sDistrID: ""
4/12/2012 3:27:36 PM 9.6.0.49709 MAIL (TUPSManager.ProcessMail) Error processing UPS Mail : UPS File Distribution: Mail attacment is missing [08061603150554.16992988]
4/12/2012 3:27:38 PM 9.6.0.49709 PC_CONFIG PC_Config update message NOT prepared - No changes detected
4/12/2012 3:27:39 PM 9.6.0.49709 MAIL Sending UPS Mail
4/12/2012 3:27:39 PM 9.6.0.49709 MAIL 0 messages to send
4/12/2012 3:28:54 PM 9.6.0.49709 EOD Start processing EOD request
4/12/2012 3:28:54 PM 9.6.0.49709 EOD Processing EOD, 4 activities found
4/12/2012 3:28:55 PM 9.6.0.49709 EOD Processing Activity 1, ID: "107550", started: 2012-04-10 14:16:04, Shipments: 14
4/12/2012 3:28:55 PM 9.6.0.49709 EOD (ID=107550) PLD File Name: "c:\program files\z-firm llc\shiprush v9\PLD\201204121528555650.PLD"
4/12/2012 3:28:56 PM 9.6.0.49709 ERROR (ID=107550) PLD Encoding failed: Account/Mailbox pair not found in the UPS subsystem ('Y56A35'/'SYSTEM_MOS09068117630231')
4/12/2012 3:28:56 PM 9.6.0.49709 EOD Processing Activity 2, ID: "107665", started: 2012-04-10 16:14:53, Shipments: 3
4/12/2012 3:28:56 PM 9.6.0.49709 EOD (ID=107665) PLD File Name: "c:\program files\z-firm llc\shiprush v9\PLD\201204121528566101.PLD"
4/12/2012 3:28:57 PM 9.6.0.49709 ERROR (ID=107665) PLD Encoding failed: Account/Mailbox pair not found in the UPS subsystem ('Y56A35'/'SYSTEM_MOS09068117630231')
4/12/2012 3:28:57 PM 9.6.0.49709 EOD Processing Activity 3, ID: "107733", started: 2012-04-12 13:27:43, Shipments: 11
4/12/2012 3:28:57 PM 9.6.0.49709 EOD (ID=107733) PLD File Name: "c:\program files\z-firm llc\shiprush v9\PLD\201204121528574682.PLD"
4/12/2012 3:28:57 PM 9.6.0.49709 ERROR (ID=107733) PLD Encoding failed: Account/Mailbox pair not found in the UPS subsystem ('Y56A35'/'SYSTEM_MOS09068117630231')
4/12/2012 3:28:58 PM 9.6.0.49709 EOD Processing Activity 4, ID: "107841", started: 2012-04-12 15:28:30, Shipments: 0
4/12/2012 3:28:58 PM 9.6.0.49709 EOD (ID=107841) No PLD data generated (Empty Activity). PLD FILE NOT SAVED.
4/12/2012 3:28:58 PM 9.6.0.49709 Manifest (TUPSManager.IntExecuteManifest) Alert! UPS did not receive your shipping data. Please stop using ShipRush and contact ShipRush support.

One or more errors performing End-Of-Day. See "shiprushserver.log" file for details.
4/12/2012 3:28:59 PM 9.6.0.49709 ERROR Alert! UPS did not receive your shipping data. Please stop using ShipRush and contact ShipRush support.

One or more errors performing End-Of-Day. See "shiprushserver.log" file for details.
4/12/2012 3:28:59 PM 9.6.0.49709 MAIL Start checking/processing mail
4/12/2012 3:28:59 PM 9.6.0.49709 MAIL Receiving UPS Mail
4/12/2012 3:29:00 PM 9.6.0.49709 MAIL Checking mail (CONFIG) - Listed 0 messages
4/12/2012 3:29:01 PM 9.6.0.49709 MAIL Checking mail (DIST) - Listed 0 messages
4/12/2012 3:29:02 PM 9.6.0.49709 MAIL Checking mail (ADDR VAL) - Listed 0 messages
4/12/2012 3:29:03 PM 9.6.0.49709 REDIST UPS Distributable Mail is processed: sVersion: "", sDistrType: "", sDistrID: ""
4/12/2012 3:29:03 PM 9.6.0.49709 MAIL (TUPSManager.ProcessMail) Error processing UPS Mail : UPS File Distribution: Mail attacment is missing [07111703260744.89721812]
4/12/2012 3:29:03 PM 9.6.0.49709 REDIST UPS Distributable Mail is processed: sVersion: "", sDistrType: "", sDistrID: ""
4/12/2012 3:29:03 PM 9.6.0.49709 MAIL (TUPSManager.ProcessMail) Error processing UPS Mail : UPS File Distribution: Mail attacment is missing [08061603150554.16992988]
4/12/2012 3:29:04 PM 9.6.0.49709 PC_CONFIG PC_Config update message NOT prepared - No changes detected
4/12/2012 3:29:05 PM 9.6.0.49709 MAIL Sending UPS Mail
4/12/2012 3:29:05 PM 9.6.0.49709 MAIL 0 messages to send

[SYSOPS]

You cannot copy the database from the old to the new. There are registry files that are needed for UPS Pro. That appears to be the issue here.

Remoted into the system, reset a few values in the registry so that they were correct from the old system and tried the EOD again. Back up and working.

Discussed using the ShipRushDBManager Save System State for a proper move of the database for UPS Pro users.

SYSOPS

[SYSOPL]

For more information on the ShipRush DB Manager and how to properly move a UPS Pro installation from one pc to another, please refer to this page in the help file:

http://www.zfirm.com/Product_Documen...se_Manager.htm