This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hi All,
We are unable to download the workorders to excel when the count is more than 400 with Interneal Server error page coming up.This is not happening with any of the other applications.More over,in the logs there is no error message even after setting the application on debug mode.
Any help on the issue will be appreciated.
Maximo Version 7.5.0.5
websphere version 7.0.0.15
I hate to ask this (because I hate when people ask me this) but… what browser are you using? Have you tried using different ones? I have had the same issues on and off when a new browser version is deployed.
Miranda
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: Sunday, May 01, 2016 5:19 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Unable to download workorders from list tab when the count is more than 400
Hi All,
We are unable to download the workorders to excel when the count is more than 400 with Interneal Server error page coming up.This is not happening with any of the other applications.More over,in the logs there is no error message even after setting the application on debug mode.
Any help on the issue will be appreciated.
Maximo Version 7.5.0.5
websphere version 7.0.0.15
Maximo Download limit of 200
Technote (FAQ)
Question How can I download more than 200 records using the download function of Maximo?
Answer Modify the webclient.maxdownloadrows property value in the webclient.properties file.
1. Open a webclient.properties
(under <maximo_root>\applications\maximo\properties)
2. Add or modify an existing property. value -1 will allow excel to download all records from the list tab.
- webclient.maxdownloadrows=<limit of records' number>
After making this change, save the properties file and rebuild the Maximo EAR file for the changes to take effect.
A setting of -1 will result in unlimited download records from the List tab, however it will result in any download from a lookup dialog to default to the out of the box limit of 200 rows.
A setting higher than 200, for example 300, will result in the lookup limit being that specified value but the List tab will also be limited by the same amount.
IBM Maximo Download limit of 200 - United States http://www-01.ibm.com/support/docview.wss?uid=swg21622350
IBM Maximo Download limit of 200 - United States http://www-01.ibm.com/support/docview.wss?uid=swg21622350 Modify the webclient.maxdownloadrows property value in the webclient.properties file. 1. Open a webclient.properties (under <maximo_root>\applications\maximo\properties) 2.
View on www-01.ibm.com http://www-01.ibm.com/support/docview.wss?uid=swg21622350
Preview by Yahoo
Hi, This issue is happening in other browsers as well. Regards, Mahadevan. On Tue, May 3, 2016 at 6:24 PM, Miranda Anderson miranda.anderson@cssd.ab.ca [MAXIMO] <MAXIMO@yahoogroups.com> wrote: > > > I hate to ask this (because I hate when people ask me this) but… what > browser are you using? Have you tried using different ones? I have had the > same issues on and off when a new browser version is deployed.
The max download rows property is given value -1 so it should not be an issue. Please suggest what else needs to be checked. On May 5, 2016 7:30 AM, "swkim@getty.edu [MAXIMO]" <MAXIMO@yahoogroups.com> wrote: > > > Maximo Download limit of 200 > > Technote (FAQ) > Question How can I download more than 200 records using the download > function of Maximo? > Answer Modify the webclient.maxdownloadrows property value in the > webclient.properties file. > 1. Open a webclient.properties > (under <maximo_root>\applications\maximo\properties) > 2. Add or modify an existing property. value -1 will allow excel to > download all records from the list tab. > - webclient.maxdownloadrows=<limit of records' number> > > After making this change, save the properties file and rebuild the Maximo > EAR file for the changes to take effect. > A setting of -1 will result in unlimited download records from the List > tab, however it will result in any download from a lookup dialog to default > to the out of the box limit of 200 rows. > A setting higher than 200, for example 300, will result in the lookup > limit being that specified value but the List tab will also be limited by > the same amount.
I am able to download PO/PR which are more than 2000 records from the list
tab,but only while trying to download the workorders(around 25k),it gives
an internal error.Any help/suggestions please.
On Fri, May 6, 2016 at 6:17 PM, Mahadevan Ramakrishnan <
mahadevan.r@praxis.ae> wrote:
> The max download rows property is given value -1 so it should not be an
> issue. Please suggest what else needs to be checked.
> On May 5, 2016 7:30 AM, "swkim@getty.edu [MAXIMO]" <MAXIMO@yahoogroups.com>
> wrote:
>
>>
>>
>> Maximo Download limit of 200
>>
>> Technote (FAQ)
>> Question How can I download more than 200 records using the download
>> function of Maximo?
>> Answer Modify the webclient.maxdownloadrows property value in the
>> webclient.properties file.
>> 1. Open a webclient.properties
>> (under <maximo_root>\applications\maximo\properties)
>> 2. Add or modify an existing property. value -1 will allow excel to
>> download all records from the list tab.
>> - webclient.maxdownloadrows=<limit of records' number>
>>
>> After making this change, save the properties file and rebuild the Maximo
>> EAR file for the changes to take effect.
>> A setting of -1 will result in unlimited download records from the List
>> tab, however it will result in any download from a lookup dialog to default
>> to the out of the box limit of 200 rows.
>> A setting higher than 200, for example 300, will result in the lookup
>> limit being that specified value but the List tab will also be limited by
>> the same amount.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> IBM Maximo Download limit of 200 - United States
>> http://www-01.ibm.com/support/docview.wss?uid=swg21622350
>>
>> IBM Maximo Download limit of 200 - United States
>> http://www-01.ibm.com/support/docview.wss?uid=swg21622350 Modify the
>> webclient.maxdownloadrows property value in the webclient.properties file.
>> 1. Open a webclient.properties (under
>> <maximo_root>\applications\maximo\properties) 2.
>>
>>
>>
>> View on www-01.ibm.com
>> http://www-01.ibm.com/support/docview.wss?uid=swg21622350
>> Preview by Yahoo
>>
>>
>>
>>
>>
>>
>>
>>
>
--
*Mahadevan*
*Technical Consultant*
*Praxis Solutions JLT*
*P.O. Box: 486080, Dubai, U.A.E.*
Mob : +971 50 2139580
Tel : +971 4 434 7632
Fax : +971 4 429 8765
Email : mahadevan.r@praxis.ae <jayant.surana@praxis.ae>
Website : www.praxis.ae
I'm not even going to bother testing downloading 25k work orders. You're likely running out of memory or resources to pull such a big mboset. There's a lot of data that gets pulled in for just one work order. What does the maximo SystemOut.log say?
There is no error in Sysout or syserror,even turned on the sql to
debug/info but could not get any statements that could cause the downlaod
to fail.
Regards
On Tue, May 10, 2016 at 6:40 PM, swkim@getty.edu [MAXIMO] <
MAXIMO@yahoogroups.com> wrote:
>
>
> I'm not even going to bother testing downloading 25k work orders. You're
> likely running out of memory or resources to pull such a big mboset.
> There's a lot of data that gets pulled in for just one work order. What
> does the maximo SystemOut.log say?
>
>
>
>
>
--
*Mahadevan*
*Technical Consultant*
*Praxis Solutions JLT*
*P.O. Box: 486080, Dubai, U.A.E.*
Mob : +971 50 2139580
Tel : +971 4 434 7632
Fax : +971 4 429 8765
Email : mahadevan.r@praxis.ae <jayant.surana@praxis.ae>
Website : www.praxis.ae
First let's be clear, I agree entirely that the download process is not
really suitable for so many records, you should be looking at integration
mechanisms or SQL exports.
That said, in what manner does it fail? Do you get bored of waiting and
give up? Do you get an error message? Does a JVM crash? If you have the
root logger at INFO you should be getting MBO counts every minute for the
WORKORDER mbo, how high does it rise while attempting the export? At the
high point what is the JVM reporting for free heap? Do you get core dumps?
(it is not uncommon for a JVM to be configured such that it crashes and
restarts, people often mistake this for it not having crashed at all.
Chris.
On Wed, May 11, 2016 at 3:13 AM, Mahadevan Ramakrishnan
mahadevan.r@praxis.ae [MAXIMO] <MAXIMO@yahoogroups.com> wrote:
>
>
> There is no error in Sysout or syserror,even turned on the sql to
> debug/info but could not get any statements that could cause the downlaod
> to fail.
>
> Regards
>
> On Tue, May 10, 2016 at 6:40 PM, swkim@getty.edu [MAXIMO] <
> MAXIMO@yahoogroups.com> wrote:
>
> >
> >
> > I'm not even going to bother testing downloading 25k work orders. You're
> > likely running out of memory or resources to pull such a big mboset.
> > There's a lot of data that gets pulled in for just one work order. What
> > does the maximo SystemOut.log say?
> >
> >
> >
> >
> >
>
> --
> *Mahadevan*
>
> *Technical Consultant*
>
> *Praxis Solutions JLT*
>
> *P.O. Box: 486080, Dubai, U.A.E.*
>
> Mob : +971 50 2139580
>
> Tel : +971 4 434 7632
>
> Fax : +971 4 429 8765
> Email : mahadevan.r@praxis.ae <jayant.surana@praxis.ae>
>
> Website : www.praxis.ae
>
>
>
>
>
Hi All,
Just opening this thread again.
We have around 25k workorders in the system as of today and the users were able to download the workorders list to excel without any issue 3 months back.
We had a database server migration 3 months back where the data center moved from one service vendor to another and ever since the users are unable to download even 400 workorders.
All the properties in Maximo have remained the same like the system property which controls the download(it is set to -1,meaning unlimited download),but I cant get to the cause why the download is failing with an error status 500-Internal server error.
I did check the logs and put all the root loggers to DEBUG mode but could not find any hint to the problem.
Kindly suggest.
Have you tried to download a smaller set of records such as 20? What happens then?
How long is the download taking before you get the 500 error.
It might be a timeout issue where the processing is taking too long and another setting is kicking in. Its a way for the system to protect itself from running long tasks and bringing the system down.
If the 500 error is occurring say exactly after 60 seconds... your move to the new data center would be causing it. Either the speed at which records are being downloaded is too slow, or there is some sort of firewall or network configuration that's causing delays.
the 500 error should be recorded into SystemOut.log - that's curious no error message is showing up.
Hard to say without knowing your full setup.