Sanjay Kumar Sahu
Rank: #352
33Views
17Comments
Where to find the below aggregate error?
Question
Reactive
Application Type
Reactive

Hi Folks,


I'm getting following error while testing my aggregate output. Where can I see detailed info of this error like exact which column is causing this issue?

Thanks,

Sanjay

0
0
on 2020-12-28
Copy link to comment
Shweta Gedam
Rank: #286

Hi Sanjay,

Could you please show us what filter you have applied in your aggregate?

0
0
on 2020-12-28
Copy link to comment

Hello Shweta,


This is the filter I used : 

But the question is about where can I find the error ? I could sort out the issue if I can see detailed info of the error, but as it is showing while testing, I cannot see in service center.


Thanks,

Sanjay

0
0
on 2020-12-28
Copy link to comment
Dorine Boudry
Rank: #129

Replying to Sanjay Kumar Sahu's comment on 28 Dec 2020 12:04:27

Well, 

As this is only preview going wrong, maybe you can publish and test your app with same id 1011.

Maybe you'll get the same error and can then check in service center.

0
0
on 2020-12-28
Copy link to comment

Replying to Dorine Boudry's comment on 28 Dec 2020 12:15:58

Hi Dorine,


I'm not getting any error while publishing and also while debugging to GetData flow. I'm just not getting data on my page. So I'm very much relying on this test feature as it is the only place I' seeing this error.

0
0
on 2020-12-28
Copy link to comment
Kilian Hekhuis
mvp_badge
MVP
Rank: #2

Hi Sanjay,

Do you have any calculated columns in there? An error like that shouldn't appear when simply displaying the content of an entity.


0
0
on 2020-12-28
Copy link to comment
Sachin Waghmare
Rank: #400

Hi Sanjay,

Based on the error, it looks like you are converting an attribute having binary data type to text (nvarchar/varchar) in your aggregate? Do you have any calculated attribute in your aggregate?

Thanks & Kind Regards,

Sachin

0
0
on 2020-12-28
Copy link to comment

Hello Kilian and Sachin,


There is no calculated column in aggregate perhaps it does have groups and I'm also grouping Binary Data to get it in result along with other grouped columns. Can it be a reason? But when I debug, I can see aggregate is properly fetching data, though not showing in screen.


Thanks,

Sanjay

0
0
on 2020-12-28
Copy link to comment
Sachin Waghmare
Rank: #400

Hi Sanjay,

It might be the case since you are grouping Binary data with other text attributes causing this issue. Another question where do you displaying the binary data on screen and which control you have used to display the binary data?

Thanks & Regards,

Sachin

0
1
on 2020-12-29
Copy link to comment
Kilian Hekhuis
mvp_badge
MVP
Rank: #2

Replying to Sachin Waghmare's comment on 29 Dec 2020 07:55:32

Sachin,

It's not possible to "group binary data with other text attributes", grouping is always on a single column/attribute!

1
1
on 2020-12-29
Copy link to comment
Kilian Hekhuis
mvp_badge
MVP
Rank: #2

Hi Sanjay,

To debug this, I'd start with a simple aggregate that works, and then add complexity in steps, and see where it goes wrong. Without knowing what exactly causes this error, it's difficult to think of a solution.

0
0
on 2020-12-29
Copy link to comment
Sachin Waghmare
Rank: #400

Replying to Kilian Hekhuis' comment on 29 Dec 2020 08:37:01

This is what I had mentioned into my comments that since he is grouping the attribute having binary data with other data type attributes might be causing the issue.

0
1
on 2020-12-29
Copy link to comment
Kilian Hekhuis
mvp_badge
MVP
Rank: #2

Replying to Sachin Waghmare's comment on 29 Dec 2020 09:22:38

No, you cannot do that, that's not how grouping works. Please refrain from replying if you don't know how things work.

0
0
on 2020-12-29
Copy link to comment

Replying to Kilian Hekhuis' comment on 29 Dec 2020 08:38:15

That's a good idea Kilian, I'm going to try it now.

0
0
on 2020-12-30
Copy link to comment

Replying to Sachin Waghmare's comment on 29 Dec 2020 07:55:32

Thanks for response Sachin, I'm also thinking same. I'm displaying image in in-built image widget in web page so it can't be issue. 

I will try this with simple POC and observe the issue.

0
0
on 2020-12-30
Copy link to comment
Rohan Hanumante
Rank: #443

Hi Sanjay,

It is giving error while searching in the aggregate, Right?

What I think is that while retrieving the records from the DB there is one or more column having the data type is text that you changed from data type Binary and at that time that column have binary data in that column and that was there only after changing it to Text. That's why it showing error. That what I understand from the error.


1
1
on 2020-12-29
Copy link to comment
Kilian Hekhuis
mvp_badge
MVP
Rank: #2

Hi Rohan,

I'm not sure what you mean. It's not possible to change the data type of an Attribute if the types aren't compatible, the database won't allow it. You can't have a mix of binary/text in a database column (or any other mix for that matter).

0
0
on 2020-12-29
Copy link to comment

Thanks to all of you for providing valuable suggestions! 

I have solved the issue but in different way. As grouping binary data with text data could slowdown performance, I removed binary column(and entity) from aggregate and post that I checked if there is any binary data for any record, and only then I fetched binary data in a new aggregate. It is working fine and faster also. 


The only thing I could not figure out is why aggregate was showing error in test mode perhaps it was able to fetch all data. To verify it, I copied executed SQL query and tried with Advance SQL widget, Here I get same data without any error.


0
0
on 4th Jan
Copy link to comment