Report Error

[vamsioracle]

hi

I am working with a custom report, I try to change the code as per requirement and when i click ok , it errors out and report builder closes. I tried for almost 10 times

'I says Report builder has encountered a problem and needs to close.We are Sorry for the inconvenience.'

What might the problem all the data is lost and i have to start all over again from the first.
Please help me

[amitpatel66]

hi

I am working with a custom report, I try to change the code as per requirement and when i click ok , it errors out and report builder closes. I tried for almost 10 times

'I says Report builder has encountered a problem and needs to close.We are Sorry for the inconvenience.'

What might the problem all the data is lost and i have to start all over again from the first.
Please help me

Do you mean you are not able to save the changes or not able to execute the report??

Please provide what you are trying to modify?

[vamsioracle]

Actually the datamodel has a query with one table. I added one more table and two join conditions in the where clause. after doing this it is taking long time to connect to the database and suddenly i get that report error. The report error dialog box has two buttons, debug and cancel.
the report closes for both and the changes are not saved.


thank u

[amitpatel66]

Actually the datamodel has a query with one table. I added one more table and two join conditions in the where clause. after doing this it is taking long time to connect to the database and suddenly i get that report error. The report error dialog box has two buttons, debug and cancel.
the report closes for both and the changes are not saved.


thank u

I think the session is expiring because of some syntax error in your query, or say "object does not exist error". Did you try connecting to the databse from report builder and then try modifying your query and check what happens?

[vamsioracle]

I tried that way too and the result is te same. No Change. I connect to the clients database through VPN. Will this create any problem.

[amitpatel66]

I tried that way too and the result is te same. No Change. I connect to the clients database through VPN. Will this create any problem.

Not really. Are you able to connect to the database from SQLPLUS? If Yes,
Then try this:

Take the query from the reports builder, modify as you want and run that in SQL PLUS and check if it executes fine.

[vamsioracle]

I got it. When i try to add an extra table, SQL is hanging. ?Might be over load problem

[amitpatel66]

I got it. When i try to add an extra table, SQL is hanging. ?Might be over load problem

Now check if the modified query executes by hardcoding some values in WHERE condition and you get result atleast after filtering the data by hardcoding. Then you could probably look at using HINTS to improve the performance by forcing your query to use an index for the table that you are including in the Query.