- Posts: 725
- Thank you received: 15
Report stopped working
- hanisultan
-
Topic Author
- Offline
- Platinum Member
-
Less
More
7 years 11 months ago - 7 years 11 months ago #13899
by hanisultan
Report stopped working was created by hanisultan
I have a report that has been working just fine and last Friday when stopped working. I spent a lot of time trying to figure out the issue but I failed. I used the profiler to trace the query generated by the ATE, I captured the query statement and ran it on the sql server and it worked fine. So I changed how the query is generated within the ATE data object from using variables to using constant to see if the variables maybe causing the issue. What do you suggest I do? Let me know if you need anything from me to send your way.
Using 5.3.1.19
Using 5.3.1.19
Last edit: 7 years 11 months ago by hanisultan.
Please Log in or Create an account to join the conversation.
7 years 11 months ago #13900
by admin
Mike
ETL Architect
Replied by admin on topic Report stopped working
One of report objects is causing the problem.
I would start deleting objects one by one until it starts working.
You can have a situation when the report is the same but the data is different.
Also think about Null values or devision by zero
I would start deleting objects one by one until it starts working.
You can have a situation when the report is the same but the data is different.
Also think about Null values or devision by zero
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
- hanisultan
-
Topic Author
- Offline
- Platinum Member
-
Less
More
- Posts: 725
- Thank you received: 15
7 years 11 months ago #13901
by hanisultan
Replied by hanisultan on topic Report stopped working
Thank you for the suggestions. I have removed just about every object and still the report took long and produce no data. I have wrote different queries to do the same calculation the report was doing and didn't find any mathematics or logic errs. This started to happen after an update we made to ATE. Any other suggestions?
Please Log in or Create an account to join the conversation.
7 years 11 months ago #13902
by admin
Mike
ETL Architect
Replied by admin on topic Report stopped working
Report' is the third party component we use,
So we are exactly athe same position as you.
the company is called fast report.
You can ask them for assistance if you wish.
If I was you I would try to create simplified version from scratch.
So we are exactly athe same position as you.
the company is called fast report.
You can ask them for assistance if you wish.
If I was you I would try to create simplified version from scratch.
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
- hanisultan
-
Topic Author
- Offline
- Platinum Member
-
Less
More
- Posts: 725
- Thank you received: 15
7 years 11 months ago #13910
by hanisultan
Replied by hanisultan on topic Report stopped working
This was strange, after spending a lot of time and doing different things, the report just started working after I reverted all changes made to original report.
Please Log in or Create an account to join the conversation.