p_sdi_01 errors: "Unable to retrieve user" and "No email is defined for user"
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Description:
We are just beginning to use SDI to aggregate RSS feeds for our users, and in doing some tests, I have noticed several error messages in the log. (See below.)
What might be causing these errors, and do they affect the data that is (or is not) being transmitted to the users?
Error: Unable to retrieve user - 10
Error: Unable to retrieve user - 10
...
Error: Unable to retrieve user - 11
Error: Unable to retrieve user - 11
...
Error: Unable to retrieve user - ABC000009034
Error: No email is defined for user - SBS000000084
Error: No email is defined for user - SBS000005206
Resolution:
The "Unable to retrieve user" error indicates that the user doesn’t exist in the database.
I don't find any patrons with the id's of 10, 11, or ABC000009034. The z325 (SDI patron profile) records with these id's are from 2002-4:
abc00@ALEPH0> select z325_open_date from z325 where z325_rec_key like '10 %';
**** Hit return to continue ****
Z325_OPEN_DATE
--------------
20020716
20020716
20020716
20020716
20020721
20020721
20020721
20020721
20020721
20020922
20021211
20030212
20030212
20030212
20030212
20030529
16 rows selected.
abc00@ALEPH0> select z325_open_date from z325 where z325_rec_key like '11 %';
**** Hit return to continue ****
Z325_OPEN_DATE
--------------
20030204
20030210
20030211
20030211
20030212
20030212
20030212
20030212
20030212
20030212
20030212
20030212
20030212
20030213
20030213
20030213
20030213
20030213
20030514
20030616
abc00@ALEPH0> select z325_open_date from z325 where z325_rec_key like 'ABC000009034%';
**** Hit return to continue ****
Z325_OPEN_DATE
--------------
20040322
I suggest that you use this SQL to delete them:
SQL> delete from z325 where z325_rec_key like '10 %' or z325_rec_key like '11 %' or z325_rec_key like 'ABC000009034%';
Or you could simply do util a/17/1 for the abc00 z325 to reinitialize it and start over.
As far as the "No email is defined for user", you will need to check the address records for the patrons shown.
(You should back up the z325 table, using p_file_03, before you do either of the above.)
- Article last edited: 10/8/2013