Can anybody please tell me why my query fails in Cognos?

Question

I am trying to Left join some queries and I am getting some errors. It will run for the first time and when I ran it for the second time it gave me a different error message. Then I try to run it for the 3rd time, it gave me another different error. I could not capture 1 st error. 

Is there any other better solution or better way to achieve this?

I did some research for this error, I am pretty sure it not something with time or limits since it runs few times. 

2nd Error

Please tell me if the there better and efficient way I can do this. 

Thank you 

Answer 1

This might help get you started We want to find out where the error is occuring

Is it the data? Could there be unexpected data? Unusual characters that break a join? the model? the report? etc

1. Do not delete your work

Copy your report and use that to experiment. This way you can always get back to your starting point

2. Divide and conquer

Take each of the queries as a separate list - no joins

Do the individual lists run?

Does the data look the way you would expect?

3. Run over a small, known part of the data

Can you run a filtered request that just returns a few rows of data you are familiar with?

Like company 1, employee 123, year 2021, month 6 If the query works.

Then run it with the filters more open (like all employees). If it breaks, probably something in the data that needs to be handled

4. Check for scenarios

For example, Try the report where you would get a null due to an outer join