nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

EXO API End Point Issue with BOM - 500 Internal Server Error

NickC

Hi all,

Was wondering if anyone could shed some light on an issue I am having, only when calling the https://exo.api.myob.com/bom/ endpoint.

Other endpoints work for this client except BOMs.

See attached for the errors being recorded.

And also an error message below:

The Billomat_hdr table does have extra fields but there are no null values.

Thank you!

apierror.doc

Find more posts tagged with

Accepted answers

Will_H

Hi @NickC ,

Just so you know, you've posted in the public MYOB API forum, which is for the AccountRIght/Essentials API. Theoretically, you should have access to the Exo specific board at: https://community.myob.com/t5/EXO-API/ct-p/EXOAPI

(Note, a valid Developer license is required to access that forum. If you don't have access, let me know and I'll get the Forum team to fix your identity up).

Referring to your API Error log I see 2 styles of errors there;

Error 503, Unavailable, which is the message we were experiencing during yesterdays Exo API outage.

And:

2020-04-07 15:26:25.5413:ExceptionAttributes:9:ERROR:UNHANDLED EXCEPTION STOCK_ITEMS table has different number of SELLPRICE columns comparing to number defined in PRICE_NAMES. Column in question is SELLPRICE11
EXCEPTION: System.Exception: STOCK_ITEMS table has different number of SELLPRICE columns comparing to number defined in PRICE_NAMES. Column in question is SELLPRICE11
   at MYOB.ED.EXO.Cloud.Model.Repository.BomRepository.LoadSellPrices(Object data)
   at MYOB.ED.EXO.Cloud.Model.Repository.BomRepository.Map(Object data)

This appears to be saying that the problem is with the PRICE_NAMES table having a different number of sellprices compared to the STOCK_ITEMS table. I've never specifically dealt with this error for.

If you need me to review the individual database, please submit a Service Request and put the database in via FTP. Or at least, send me via email:

The contents of the PRICE_NAMES table
The schema for the STOCK_ITEMS table.

All comments

Will_H

Hi @NickC ,

(Note, a valid Developer license is required to access that forum. If you don't have access, let me know and I'll get the Forum team to fix your identity up).

Referring to your API Error log I see 2 styles of errors there;

Error 503, Unavailable, which is the message we were experiencing during yesterdays Exo API outage.

And:

2020-04-07 15:26:25.5413:ExceptionAttributes:9:ERROR:UNHANDLED EXCEPTION STOCK_ITEMS table has different number of SELLPRICE columns comparing to number defined in PRICE_NAMES. Column in question is SELLPRICE11
EXCEPTION: System.Exception: STOCK_ITEMS table has different number of SELLPRICE columns comparing to number defined in PRICE_NAMES. Column in question is SELLPRICE11
   at MYOB.ED.EXO.Cloud.Model.Repository.BomRepository.LoadSellPrices(Object data)
   at MYOB.ED.EXO.Cloud.Model.Repository.BomRepository.Map(Object data)

This appears to be saying that the problem is with the PRICE_NAMES table having a different number of sellprices compared to the STOCK_ITEMS table. I've never specifically dealt with this error for.

If you need me to review the individual database, please submit a Service Request and put the database in via FTP. Or at least, send me via email:

The contents of the PRICE_NAMES table
The schema for the STOCK_ITEMS table.

NickC

Just setup a test connection, stripped BOM hdr and lines to one record, removed all extra fields and updated nulls.

Same error: HTTP/1.1 500 Internal Server Error

They are on Windows Server 2008 R2

Might be a Windows thing? Just strange I can query other tables.

@Will_H ?? Help?