+ Start a Discussion
Dave ParadiseDave Paradise 

Superbadge Business Administration Specialist Superbadge Challenge 3 - Open Support Cases Report

I'm currently working on Challenge 3 and am dealing with trying to fix this error:
Challenge Not yet complete... here's what's wrong: 
The report 'Open Support Cases' contains records of the incorrect status. Please check the filter.
 
For the Open Support Cases, I created a Custom Report Type linking Accounts and Cases and have the groupings and fields set up as specified. For the filter, I've tried "Closed equals False" and "Status not equal to Closed" for the Cases, but neither of those worked.

If anyone who has passed this challenge can provide input on what's wrong with this report. It'll be much appreciated.

Open Support Cases Report Screenshot
Best Answer chosen by Dave Paradise
Maheshkumar Selvaraj 10Maheshkumar Selvaraj 10
The Report type should be of 'Cases' and not 'Accounts And Cases'

All Answers

Maheshkumar Selvaraj 10Maheshkumar Selvaraj 10
The Report type should be of 'Cases' and not 'Accounts And Cases'
This was selected as the best answer
Dave ParadiseDave Paradise
I was able to figure it out and pass the challenge last night. For whatever reason I couldn't find the pre-built Cases Report Type at first and made my own, but that didn't work either. No problems after I found the right Report Type.

Thanks.
Luis Igualada 4Luis Igualada 4
I have an error in my new Trailhead Playground environment created from scratch.

When I try to validate the third step it shows me the following error:
User-added image
It shows me the following error and the ORG is created from scratch:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Challenge Not yet complete... here's what's wrong: 
There was an unexpected error while verifying this challenge. Usually this is due to some pre-existing configuration or code in the challenge Org. We recommend using a new Developer Edition (DE) to check this challenge. If you're using a new DE and seeing this error, please post to the developer forums and reference error id: IYWTYILJ
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Can someone please help me?
Dave ParadiseDave Paradise
Hi Luis,

That error usually appears when the checker is trying to de-reference a null object. Do you have the reports/dashboards in the proper folder and have the second dashboard configured properly?

Also, since this question is marked as Solved, it will be better to re-ask your question in a new thread.
Luis Igualada 4Luis Igualada 4
Hi @Dave Paradise, 

I have logout my trailhead environment and I have re-logged in and when I tried to validate the test again I passed OK without having changed anything in my ORG. Very extrange.

Thank you very much for the quick answer.
Patrick KaiserPatrick Kaiser
Hey guys maybe you can help me.

I've createt the Open Support Cases Report as shown below. And I get the error: The report 'Open Support Cases' contains records of the incorrect status. Please check the filter.

I already changed the filter from the open field to closed or to status. But all this changes dont work. From the description of the report, this is what i would expect here.

Maybe someone can help me here.
 User-added image
Dave ParadiseDave Paradise
Hi Patrick,

Try changing the Date Field to Date/Time Opened.
Patrick KaiserPatrick Kaiser
@Dave Paradise, i tried all 3 field under case information. None of them worked for me.
Dave ParadiseDave Paradise
By chance did you delete an earlier "Open Support Cases" report and create a new one in the same playground?
Patrick KaiserPatrick Kaiser
No i did this error once for the report badge ;)
Patrick KaiserPatrick Kaiser
I found the "error" i had to change the filter to: Status equals "New, Working, Escalated"

which makes not so much sens to me but okay ... would be more logical to just check the open flag
Dave ParadiseDave Paradise
Yeah, I don't see what else could be wrong. My setup is-
* Built-in Cases report type.
* Date/Time Opened for All Dates
* Closed equals False
Groupings, columns, and data are the same.
Dave ParadiseDave Paradise
Ah, I typed that last reply before seeing your latest. Congrats on fixing it.
SUBHRA JYOTI SENSUBHRA JYOTI SEN
Hi while checking Challenge 3 I am getting the following error
"Challenge Not yet complete... here's what's wrong: 
Couldn't find a component that is 5 cells by 5 cells."
Rajanee verma 2Rajanee verma 2
I am getting this error in my new Trailhead Playground environment created from scratch.

When I try to validate the third step it shows me the following error:

User-added image

I am stuck. Please help. As I see, there are many people, who faced this same error, Can someone confirm, If they were able to complete this Superbadge, Post they faced this error. It already spoiled my 2 hours. :-(
Rupa NRupa N
@Rajanee verma 2,

I solved my challenge 3.I got the same message as yours.I created my dashboard components but did not check the chart size. That's where my problem was.Check the components and also the chart size.Hope this solves your problem too.Thanks.
Chris PetersenChris Petersen
Challenge Not yet complete... here's what's wrong: 
There was an unexpected error while verifying this challenge. Usually this is due to some pre-existing configuration or code in the challenge Org. We recommend using a new Developer Edition (DE) to check this challenge. If you're using a new DE and seeing this error, please post to the developer forums and reference error id: UYANUYQD
Jordi MONTOLIUJordi MONTOLIU
I am stucked at this Superbadge since long time because of Challenge 3.... I am getting the error: "Found an incorrect number of values for the 'Account Distribution' component." Can anyone that have passed the Challenge post a screenshot on their Accounts by Market report? Thank you
Adil JafferAdil Jaffer
I"m seeing the following error on this challenge :Challenge Not yet complete... here's what's wrong: 
There was an unexpected error while verifying this challenge. Usually this is due to some pre-existing configuration or code in the challenge Org. We recommend using a new Developer Edition (DE) to check this challenge. If you're using a new DE and seeing this error, please post to the developer forums and reference error id: VQJSTICV"

this is a new org i'm using just for this challenge... any ideas?
Chris Vasilenko DEVChris Vasilenko DEV
Same issue as @adil Jaffer.  New Trailhead Playground.  Can't pass test Receiving Error?
There was an unexpected error while verifying this challenge. Usually this is due to some pre-existing configuration or code in the challenge Org. We recommend using a new Developer Edition (DE) to check this challenge. If you're using a new DE and seeing this error, please post to the developer forums and reference error id: ECYRHNOL

Anyone have any ideas?
Kushal GargKushal Garg
User-added image
Above is the error


User-added image
This is what is required to do

User-added image
This is the report i have created,what to do to fix the error.
Xayaseth BoudsadyXayaseth Boudsady
What were the 3 filters applied?
Jhenya Agapova 16Jhenya Agapova 16
If you are getting this error, try refreshing your dashboards immediately before clicking 'Check Challenge'. 

User-added image
Charles Yoo 19Charles Yoo 19
@Dave

Yeah, I think Salesforce fudged on this one. I ran the report types with the following:
* Built-in Cases report type
* Date/Time Opened for All Dates
* Open equals True
This didn't work, but this setup

* Built-in Cases report type
* Date/Time Opened for All Dates
* Closed equals False 
This DID work, which doesn't make any sense since it's THE SAME return values and the one above. Total BS if you ask me. 
 
Austin ShinAustin Shin
Thank you Charles! 

I changed the from 'Open equals True' to 'Closed equals False' and it finally worked. I agree that using 'Open equals True' should have worked as well as they get the same results. 
Kavita Badgujar 10Kavita Badgujar 10

User-added image
I was receiving this error message while solving the "Business Administration Specialist" Stage 3 challange. But after several attempts I was able to resolve this issue. The solution worked for me is as below;
NOTE: Switch to the Lightning Experience to create report.

1. Click on create a new report.
2. Choose the Cases report type. 
3. Include the fields Case Owner, Subject, and Case Reason and drop report as column field.
4. On Left corner, click in Outline option.
5. Observe the Group Rows option, add the grouping first by Account Name then Priority.
6. Go to the Filters option and add filter "Status equals New". (Note: By default there will be three filters will be present. So keep them as it is. Filters available "Show me = All Cases"; "Opened Date = All Time"; "Unit = Hours").
7. Save & Run the report as mentioned in the challange theory.

Solution Image1: 

User-added image
Solution Image 2:
User-added image

Please mark this answer as a best answer if helped you in any way.

Thank you.

 
Christian Abel 8Christian Abel 8
Logging off and logging back on finally did it for me.  Tried just evaluating Open as True - then went back to Status Equals New, Working, Escalated.  After changing to that and logging out and logging back in, it worked.
Yamini MachhaYamini Machha
I too got the same error , applying Filters option and add filter "Status equals New" resolved the issue