PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Error 11  (Read 1284 times)

Jeffrey Ferreira

  • Diamond Member
  • *****
  • Posts: 178
  • I must have taken a wrong turn at Albuquerque.
    • View Profile
Error 11
« on: August 07, 2023, 11:29:15 AM »
Hi All,
I had an odd situation happen.
I do this thing where I first create record to make sure it exists before I extract it.
I got a dom on line 21027 and i cannot figure out why?
does anyone have any insight on how this could/might happen

20002 let MFIM01=unt; open (MFIM01,iol=*,rec=CF$)"MFIM01"
21024 let CF.SALES_ORDER_NUMBER$=SALES_ORDER_NUMBER$
21025 let CF.LOCK_ALLOCATIONS$="Y"
21026 write (MFIM01,dom=*next) ! Do Not Step On Record If It Exists
21027 extract (MFIM01,key=SALES_ORDER_NUMBER$,kno=0)


« Last Edit: August 07, 2023, 11:40:46 AM by Jeffrey Ferreira »

keith.mcbride

  • Member
  • **
  • Posts: 12
    • View Profile
Re: Error 11
« Reply #1 on: August 07, 2023, 01:48:49 PM »
Is it possible the file is corrupted. I believe we had same situation a few years ago and rebuilding the file seemed to fix it

Jeffrey Ferreira

  • Diamond Member
  • *****
  • Posts: 178
  • I must have taken a wrong turn at Albuquerque.
    • View Profile
Re: Error 11
« Reply #2 on: August 07, 2023, 01:56:55 PM »
i guess it is possible. but it is such a small file. i did a keyed load on it and i'll check to see if it happens again...thank you

Mike King

  • Diamond Member
  • *****
  • Posts: 3818
  • Mike King
    • View Profile
    • BBSysco Consulting
Re: Error 11
« Reply #3 on: August 08, 2023, 10:57:45 AM »
Do you have any Unique alternate keys on the file.  If so then the write may fail with a DOM error due to the alternate key.

For example you might have a Order record with a primary key of order number, and a unique alternate of customer number and PO number.  If the customer/PO number were already on file you would get an DOM error of the write.
Mike King
President - BBSysco Consulting
eMail: mike.king@bbsysco.com