I’m using the Reservation Asynchronous APIs for BI purposes. It works fine for the most part. However, the workflow fails sometimes for a couple of properties, for a certain range of dates. That is, I was able to download the reservations for those properties for all periods except for a gap where the calls fail.
All that is different between the successful and failed calls are the "endLastModifiedDate" and "startLastModifiedDate" parameters. The entire rest of the workflow is scripted the same way. The dates are valid and located between date ranges that were passed successfully before.
The process starts behaving weirdly for the failed dates in the response of “Check status of Reservation Daily Summary process”. It returns, every time, after dozens of retries:
When I anyway try to use the summaryId in the URL under the “Location” header to make a call to the “Get results of Reservations Daily Summary.” endpoint, I get the response below:
{
"type": "Bad Request",
"title": "ORA-20001: P$M$S-1400P$M$S: ORA-01400: cannot insert NULL into (\"OPERA\".\"TMP_TAXCALC_E\".\"TROOMCATEGORY\") at OPERA.PKG_RATE_PRICE[r592916](5543) : -20001",
"status": "NotProcessed",
"detail": "ORA-20001: P$M$S-1400P$M$S: ORA-01400: cannot insert NULL into (\"OPERA\".\"TMP_TAXCALC_E\".\"TROOMCATEGORY\") at OPERA.PKG_RATE_PRICE[r592916](5543) : -20001",
"o:errorCode": "OPERAWS-ODE09998",
"language": "en"
}
What could be behind this error? Thank you in advance.