p_cir_61: creating schedule for 4 days only; "Couldn't create Booking Record"
- Article Type: General
- Product: Aleph
- Product Version: 19.01
Description:
After setting up the necessary tables in Aleph, I ran the Advanced Booking job, p_cir_60 to create the 2 week schedule. However, the schedule is only created for 4 days. When I attempt to place a request for one of those days, I get the error message, "Remote Service Error(c0467 create 62) - Couldn't create Booking Record".
I've successfully setup Advanced Booking on two other V19 Test databases with no problems.
Note: the www_server.conf has "setenv www_item_schedule 14".
Resolution:
I see this in the abc50_p_cir_60.00086 log:
retrieving z321 records
Schedule Dates: 20100302 - 20100323
Looking with SQL, I see that the z320's which have been created are from Mar. 19 - Mar. 23:
SQL> select Z320_START_DATE, count(*) from z320 group by Z320_START_DATE;
Z320_START_DATE COUNT(*)
--------------- ----------
20100223 19381
20100319 30421
20100320 26005
20100321 30421
20100322 30421
20100323 30421
Only the 0319-0323, the last five days which should have been created, were actually created.
The presence of the 20100223 records seems odd.
I wanted to delete all of the z320's and z321's, to start over clean. When we ran p_cir_61 with Mar 24th as the latest date: "The date can't be after 3 days ago".
So you can't use that to delete future schedules.
We used util a/17/1 to drop/recreate the z320 and z321.
After that, running p_cir_60 with today as the start date and today + 21 as the end date was successful.
- Article last edited: 10/8/2013