Search results

Thanks for your valuable inputs LarryD.

Thanks for your reply Boby! Here, the only problem that I can think of is, we are having two different transactions for order-line and item and it could be possible that order-line changes (Qty.) are committed to the database and item changes will remain uncommitted. Please suggest. Regards

Dear All, I have created one scenario to increase Order quantity (in order-line) by 5 for all orders where customer number is 10. Below is code for the same: FIND customer WHERE customer.cust-num = 10 NO-LOCK NO-ERROR. FOR EACH order WHERE order.cust-num = customer.cust-num NO-LOCK: DO...

Thanks for sharing articles. We didn't touch AI extents and there is no such OS commands used to copy AI files from one to other place, AFAIK. Please suggest if could find the exact OS command/actions/users IP that causes this issue by checking OS logs or something. Regards

Thanks for your response Tom. Downtime activity was to increase SQL width of two fields. Regards

Hello All, During a planned downtime activity, we were not able to start our database due to the error messages of “wrong creation date of AI extents”. Below are DB logs for the same: (9212) Extent /ai /db-name.a1 has the wrong creation date Thu Jan 1 01:00:00 1970, (9216) Control Area has a...