[GE users] ARCO export pdf error

Jana Olivova Jana.Olivova at Sun.COM
Thu Jul 24 12:56:24 BST 2008


    [ The following text is in the "ISO-8859-1" character set. ]
    [ Your display is set for the "ISO-8859-10" character set.  ]
    [ Some special characters may be displayed incorrectly. ]

Hi Arturo,

Issue has been filed and will be fixed in 6.1u5 and 6.2

http://gridengine.sunsource.net/issues/show_bug.cgi?id=2676

The issue you are mentioning is a known issue and is fixed in 6.2 
Release, in order to fix that we used a different pdf library. I am not 
sure if this will be fixed in 6.1.
http://gridengine.sunsource.net/issues/show_bug.cgi?id=2648
http://gridengine.sunsource.net/issues/show_bug.cgi?id=2649

The error usually happens  when there is too  many rows in the result   
(how  many is too many is hard to say). try to constrain your query 
either by using the LIMIT keyword, or by specifying a time interval for 
which you want to query the data (i.e. past month), instead of pulling 
all the data.

Regards,

Jana Olivova

Arturo Giner Gracia wrote:
> Thanks for the solution. I would like to show the integer, but it 
> doesn't matter.
>
> And other error with pdf export :
>
> 24/07/2008 12:42:04|lxsrv2|ule.ExportResultServlet.handle|E|Can't 
> export result: Could not load the translet class 'GregorSamsa'.
>                              
> javax.xml.transform.TransformerConfigurationException: Could not load 
> the translet class 'GregorSamsa'.
>                                
> com.sun.org.apache.xalan.internal.xsltc.trax.TemplatesImpl.defineTransletClasses(TemplatesImpl.java:331) 
>
>                                
> com.sun.org.apache.xalan.internal.xsltc.trax.TemplatesImpl.getTransletInstance(TemplatesImpl.java:349) 
>
>                                
> com.sun.org.apache.xalan.internal.xsltc.trax.TemplatesImpl.newTransformer(TemplatesImpl.java:382) 
>
>                                
> com.sun.org.apache.xalan.internal.xsltc.trax.TransformerFactoryImpl.newTransformer(TransformerFactoryImpl.java:624) 
>
>                                
> com.sun.grid.arco.export.PDFResultExport.export(PDFResultExport.java:114)
>                                
> com.sun.grid.arco.ResultExportManager.export(ResultExportManager.java:113) 
>
>                                
> com.sun.grid.arco.web.arcomodule.ExportResultServlet.handle(ExportResultServlet.java:133) 
>
>                                
> com.sun.grid.arco.web.arcomodule.ExportResultServlet.doGet(ExportResultServlet.java:78) 
>
>                                
> javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
>                                
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>
> The query is this:
>
> SELECT username AS "User", job_number AS "Job Id", ju_hostname AS 
> "Hostname", start_time AS "Start", end_time AS "Finish", 
> wallclock_time/86400 AS "Wallclock Time" FROM view_job_times,  
> sge_job_usage, sge_job   WHERE ju_parent=j_id and 
> job_number=j_job_number  and wallclock_time/86400>1
> GROUP BY job_number
> ORDER BY end_time DESC
>
> Where is the error? and which can be the solution?
>
> Thanks
> Arturo
>
>
> Jana Olivova escribió:
>> Hi Arturo,
>>
>> I think I know where in the code this converter for BigInteger is 
>> missing. We have changed the PDF generation for 6.2, so I will need 
>> to do some test.
>>
>> The quick solution that comes in my mind is not to use the 
>> cast...just SUM(cpu)/3600 AS cpu, where of course you will get the 
>> decimal number not the integer.
>>
>> Jana
>>
>> Arturo Giner Gracia wrote:
>>> Hi Jana,
>>>
>>> This is sql string:
>>>
>>> SELECT date_format(start_time, '%Y-%m-01') AS time, project, 
>>> CAST(SUM(cpu)/3600 AS UNSIGNED) AS cpu, CAST(SUM(mem)/3600 AS 
>>> UNSIGNED) AS mem, SUM(io) AS io FROM view_accounting WHERE 
>>> start_time > (current_timestamp - interval 1 year) GROUP BY 
>>> date_format(start_time, '%Y-%m-01'), project
>>>
>>> You can see that in one of the attached files.
>>> In the other file, you can see the result when I select the option 
>>> "pdf" in the "export as:" option.
>>>
>>> I suppose there is any problem with any of the types of the query, 
>>> but I don't know how to fix it.
>>>
>>> Thanks
>>> Arturo
>>>
>>>
>>> if there is still the error
>>> Jana Olivova escribió:
>>>> Hi Arthuro,
>>>>
>>>> Can you also send me the sql string of the query, whose result are 
>>>> you trying to export, ans possibly how this result looks like 
>>>> (screen shot, or just the table with data, if it is a simple table).
>>>>
>>>> Thanks
>>>>
>>>> Jana
>>>>
>>>> Arturo Giner Gracia wrote:
>>>>> Hi Jana,
>>>>>
>>>>> I'm using mysql-5.0.26-16 and the error is this when I try to 
>>>>> export the result of a query to pdf:
>>>>>
>>>>> 3/07/2008 11:43:17|lxsrv2|ule.ExportResultServlet.handle|E|Can't 
>>>>> export result: Converter for type class java.math.BigInteger not 
>>>>> registered
>>>>>                              java.lang.IllegalArgumentException: 
>>>>> Converter for type class java.math.BigInteger not registered
>>>>>                                
>>>>> com.sun.grid.arco.ResultConverter.getConverter(ResultConverter.java:75) 
>>>>>
>>>>>                                
>>>>> com.sun.grid.arco.ResultConverter.objToStr(ResultConverter.java:56)
>>>>>                                
>>>>> com.sun.grid.arco.QueryResult.createResult(QueryResult.java:504)
>>>>>                                
>>>>> com.sun.grid.arco.ExportContext.getXmlResult(ExportContext.java:244)
>>>>>                                
>>>>> com.sun.grid.arco.export.PDFResultExport.export(PDFResultExport.java:92) 
>>>>>
>>>>>                                
>>>>> com.sun.grid.arco.ResultExportManager.export(ResultExportManager.java:113) 
>>>>>
>>>>>                                
>>>>> com.sun.grid.arco.web.arcomodule.ExportResultServlet.handle(ExportResultServlet.java:133) 
>>>>>
>>>>>                                
>>>>> com.sun.grid.arco.web.arcomodule.ExportResultServlet.doGet(ExportResultServlet.java:78) 
>>>>>
>>>>>                                
>>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
>>>>>                                
>>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>>>>>
>>>>> Thanks for your help
>>>>> Arturo
>>>>>
>>>>>
>>>>> Jana Olivova escribió:
>>>>>> Hi Arturo,
>>>>>>
>>>>>> Sorry for replying this late. can you give me more details about 
>>>>>> this issue. Which database are you using, how does the query look 
>>>>>> like, and how does the result of the query look like (the actual 
>>>>>> data).
>>>>>>
>>>>>> Thanks
>>>>>>
>>>>>> Jana
>>>>>>
>>>>>> Arturo Giner Gracia wrote:
>>>>>>> Dear SGE users,
>>>>>>>
>>>>>>> I have SGE 6.1u4 with ARCO installed. The problem is that I 
>>>>>>> can't export to PDF with ARCO.
>>>>>>> The error is:
>>>>>>>
>>>>>>> Can't export result: Converter for type class 
>>>>>>> java.math.BigInteger not registered
>>>>>>>
>>>>>>> Does anyone know how can I fix this?
>>>>>>>
>>>>>>> Thanks
>>>>>>> Arturo
>>>>>>>
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------------ 
>>>>>>
>>>>>>
>>>>>> --------------------------------------------------------------------- 
>>>>>>
>>>>>> To unsubscribe, e-mail: users-unsubscribe at gridengine.sunsource.net
>>>>>> For additional commands, e-mail: users-help at gridengine.sunsource.net
>>>>>
>>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------ 
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: users-unsubscribe at gridengine.sunsource.net
>>>> For additional commands, e-mail: users-help at gridengine.sunsource.net
>>>
>>>
>>>
>>> ------------------------------------------------------------------------ 
>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------ 
>>>
>>>
>>>
>>> ------------------------------------------------------------------------ 
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: users-unsubscribe at gridengine.sunsource.net
>>> For additional commands, e-mail: users-help at gridengine.sunsource.net
>>>   
>>
>> ------------------------------------------------------------------------
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe at gridengine.sunsource.net
>> For additional commands, e-mail: users-help at gridengine.sunsource.net
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at gridengine.sunsource.net
For additional commands, e-mail: users-help at gridengine.sunsource.net




More information about the gridengine-users mailing list