function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Lawrence Pfaff 8Lawrence Pfaff 8 

Superbadge Data Integration Challenge 9 - Internal Server Error

Hello,

I am receiving and Internal Server Error when accessing the external data for invoices. 
Internal Server Error

My project is created correctly. When I change the Status of the Project to Billable, the invoices related list appears and the status is changed to Billed. The invoices related list only shows the same error text as above.

User-added image

I found a knowledge article that indicates that this may be a external server issue.

https://help.salesforce.com/articleView?amp;language=en_US&id=000228082&type=1

I have been working on this error for sa couple of days now and do not have any idea how to proceed. Any suggestions would be greatly appreciated.

Thank you
Clive PhillipsClive Phillips
I am getting the same error, can someone please help us out.
Devender TharejaDevender Thareja
I am getting same error at challenge 9.
I am able to sync & validate the billing services data source, that creates invoice object. When I try to brouse data using invoice tab or a soql query, I get an error :
External Object Error
An error occurred while connecting to the external system. Please try again, or contact your administrator. Attempted to reach this URL: https://sb-integration-is.herokuapp.com/odata/invoices?$top=26&$orderby=id&$inlinecount=allpages&$select=id. Error received from the external system: 500: Internal Server Error

Could someone please advise what to do.
Robb BlobRobb Blob
Hi,
I'm getting the same error aswell. As stated in another thread (https://developer.salesforce.com/forums/?id=9060G000000I3xZQAS), the xml in https://sb-integration-is.herokuapp.com/odata/ seems to be lacking a slash between 'com' and 'data':
xml:base="http://sb-integration-is.herokuapp.comodata/"

I tried to access 'https://sb-integration-is.herokuapp.com/odata/invoices' through the browser, and I get an Internal Server Error too. I did all the required steps without a problem, Validation & Sync worked flawlessly, associated the indirect ID and created the related list. It should be working.

Let's see if we get some assistance from the Trailhead team.
Robb BlobRobb Blob

Just bringing some more info to the table.

Just bringing some more info to the table.

Ángel Vela MartínezÁngel Vela Martínez

Greetings,

I have the same error... Any solution form Trailhead Team?

Challenge Not yet complete... here's what's wrong: 
There was an unexpected error in your org which is preventing this assessment check from completing: System.ExternalObjectException: An error occurred while connecting to the external system. Please try again, or contact your administrator. Attempted to reach this URL: https://sb-integration-is.herokuapp.com/odata/invoices?$top=2&$inlinecount=allpages&$select=id. Error received from the external system: 500: Internal Server Error
Vitaly MininVitaly Minin
https://sb-integration-is.herokuapp.com/odata/invoices?
Should show a list of invoices like here:
https://orderdb.herokuapp.com/orders.svc/Orders?
list of Orders, but response from server is error 500
 
Linda PavareLinda Pavare
Hello,
I have the same problem.
Robb BlobRobb Blob

It's already working for me, just passed the superbadge!

In case you get an error about incorrect fields in invoices__x, remember to change the label/name of them to BillAmount, BillDate, and ProjectRef, with no spaces!

Devender TharejaDevender Thareja
It is fixed now. I just successfully finished.