Hello,
I am using graphql query to export report, but the issue is when the requested data is too large report.render(false); throw a timeout 100 sec error. I tried increasing the timeout but there is no such option provided by stimulsoft in the latest version too, so i would really like to know the way to solve this issue. This is my code ---
history.DataLoadedAt = DateTime.UtcNow;
await dbContext.SaveChangesAsync();
report.ReportCacheMode = StiReportCacheMode.On;
LogTime(sw, $"[{_report.Name}] Report Render started");
report.Render(false);
LogTime(sw, $"[{_report.Name}] Report Rendered");
history.ReportRenderedAt = DateTime.UtcNow;
await dbContext.SaveChangesAsync();
this is my graphql query --
query zz($search: String!) {
meenadev_suggestedPatientLists(
skip: 0
take: 900000
where: {
and: [
{ treatment: { providerCategories: { any: true } } }
{ name: { contains: $search } }
]
}
) {
items {
id
name
userId
providerCategories {
PayerProgram: name
}
patient {
NationalId: govCode
nationalityNavigation {
countryCode
name
}
partner {
PatientName: name
birthday
}
}
treatment {
id
TreatmentName: name
TreatmentState: state
policy {
code
name
}
meenaRisk {
RiskName: name
}
payerTag {
PayerRisk: name
}
providerCategories {
MeenaProgram: name
}
}
}
}
}
I have also attached the designer --
Timeout 100 sec error when fetching data from graphqlSource query
-
ShakeebAhmed
- Posts: 26
- Joined: Wed Nov 12, 2014 2:22 pm
Timeout 100 sec error when fetching data from graphqlSource query
- Attachments
-
- 3.png (371.98 KiB) Viewed 190 times
-
Lech Kulikowski
- Posts: 7602
- Joined: Tue Mar 20, 2018 5:34 am
Re: Timeout 100 sec error when fetching data from graphqlSource query
Hello,
There are no timeout settings for GraphQL in the designer. Try to check the IIS timeout settings.
Also, you can retrieve data in your code in the DataSet and then provide it to the report with the RegData() method.
Thank you.
There are no timeout settings for GraphQL in the designer. Try to check the IIS timeout settings.
Also, you can retrieve data in your code in the DataSet and then provide it to the report with the RegData() method.
Thank you.