Hi Satchu

My apologies for the late response. 

Your error message was a known issue in earlier versions of Sage Intelligence (BIC) but may perhaps still be an issue.

A) Old  FRD report version

The first advise I can give you is to make sure that you make use of the latest Financial Report Designer, ver 1-9,  and run it on the latest Evolution version 10.0.0.062. So please consider upgrade if needed.

B) Advice from Sage Intelligence SA 

Secondly, please also consider the advice provided by Sage Intelligence SA (the old Alchemex) in 2014

When the report attempts to run out BICore reaches a 1GB limit when rendering data which results in the out of memory error, we have done further tests where we tried to execute the SQL query from within excel and this seems to work fine, which does basically concludes that our software cannot handle the data amount that is being transferred into excel.

I have spoken to our product owner and advised her of the situation that we are currently facing and unfortunately she has advised that it is very unfortunate that our software cannot handle the data being passed through, our programme is designed that as soon as BICore reaches the maximum of 1GB of memory use it will unfortunately throw out an error.

The only solution that we have for the client in this case is for the client to run out the report for shorter intervals (e.g. 6 months) as this has been tested and works perfectly.

 I do understand that this wasn’t the clients expected solution, but I do hope that they will be able to use the workaround that has been tested.

Kind regards

Bennie 

Hi Satchu

My apologies for the late response. 

Your error message was a known issue in earlier versions of Sage Intelligence (BIC) but may perhaps still be an issue.

A) Old  FRD report version

The first advise I can give you is to make sure that you make use of the latest Financial Report Designer, ver 1-9,  and run it on the latest Evolution version 10.0.0.062. So please consider upgrade if needed.

B) Advice from Sage Intelligence SA 

Secondly, please also consider the advice provided by Sage Intelligence SA (the old Alchemex) in 2014

When the report attempts to run out BICore reaches a 1GB limit when rendering data which results in the out of memory error, we have done further tests where we tried to execute the SQL query from within excel and this seems to work fine, which does basically concludes that our software cannot handle the data amount that is being transferred into excel.

I have spoken to our product owner and advised her of the situation that we are currently facing and unfortunately she has advised that it is very unfortunate that our software cannot handle the data being passed through, our programme is designed that as soon as BICore reaches the maximum of 1GB of memory use it will unfortunately throw out an error.

The only solution that we have for the client in this case is for the client to run out the report for shorter intervals (e.g. 6 months) as this has been tested and works perfectly.

 I do understand that this wasn’t the clients expected solution, but I do hope that they will be able to use the workaround that has been tested.

Kind regards

Bennie 

Thanks for the feedback.

I will try the New FRD V9.

Upgrading will come later because they are running integrated external apps.

Will keep you posted.

Good, I hope you'll be successful, Satchu!

Hi Bennie

Tried running the report on FRD V9.

Same problem.

Also note that I was getting the same error on a database without any transactions.

It only had all the chart of accounts.

I did a Copy Company (Excluding Transactions).

So I dont think its related to data size being exceeded if there's no transactions.

Any other options ??

Regards, Satchu Archary

Hi Satchu

Thanks for the detailed feedback.

Do me a favor please: Log your query with Evolution Support in the usual way but clearly request it be send for my attention.

I will then formally investigate it for you as a normal incident query and report back to you. Of course we will have to also address it with Sage Intelligence SA 

But just one question: 

You mentioned above you copied the report layout to unlock it.

If you run the standard FRD 1-9 report without copying it first, do you then still observe the same Timeout error?

Please paste the screenshot of the error in this chat.

Kind regards

Bennie 

Hi Bennie

Thanks for the feedback.

i Dis run the report first before doing the copy.

I had the same error..

I will send the query to support.

Once you get the query, I can upload the data without any transactions.

so you can see at first hand, the issues.

Regards,

Satchu Archary 

Good, no problem, Satchu

I'll await the query then via our Support Department

Blessings!

Bennie 

Get the same. we use to change timeout settings with plconfig application but that seem to not work anymore

Hi Cor

I sent you a mail with some further questions to help us log this matter with Sage Intelligence