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