• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
I'm attempting to load a file of Blackwell records and I'm getting errors in the log (Error: problems in Z68 record: z68-rec-key - 00686128800001). Why is this happening?

Resolution:
Here are the errors reported in your log file:

Error: problems in Z68 record: z68-rec-key - 00686128800001

Error number: 0424
000000001 - (0424)Invalid sublibrary.
Error number: 0419
000000002 - (0419)Mismatch between order's unit and vendor's order unit.

If you correct the first error regarding the sublibrary, the other will clear up. I think the problem with the Order's sublibrary is caused by your default table. It's possible to specify the sublibrary for both the Item record (z30):

Z30-SUB-LIBRARY

and the sublibrary for the Order record (z68)

Z68-SUB-LIBRARY

There are some sites that actually used different sublibraries for the two, but this is rare. Generally you only have to specify the Z30-SUB-LIBRARY and it's value will also be used for the z68. You have only defined Z30-SUB-LIBRARY in your table. This would be OK, except it appears from the log that you specified that Items shouldn't be created. Without items, the order doesn't know what sublibrary to use. If you explicitly define Z68-SUB-LIBRARY in your table, the job will run fine.

• Article last edited: 10/8/2013