[WARNING] Unknown Ptg 3d (61) ?

[nullman]

Is this warning something that should concern me? I see this in the log (details follow) when an Excel spreadsheet is added, or possibly when the Excel spreadsheet in Alfresco is manipulated in some way.

Because I have another thread about Alfresco shutting down on me I've been taking a careful look at the logs and wasn't sure if this should be a concern. I only see one other post in the forum with that warning, but didn't see a response to their post.

When I did a search on the web I saw that this warning has something to do with Jakarata POI and Excel.

[WARNING] Unknown Ptg 3d (61)
java.lang.reflect.InvocationTargetException
   at sun.reflect.GeneratedConstructorAccessor195.newInstance(Unknown Source)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
   at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:224)
   at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:160)
   at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:163)
   at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:210)
   at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:191)
   at org.alfresco.repo.content.transform.PoiHssfContentTransformer.transformInternal(PoiHssfContentTransformer.java:79)
   at org.alfresco.repo.content.transform.AbstractContentTransformer.transform(AbstractContentTransformer.java:241)
   at org.alfresco.repo.content.transform.AbstractContentTransformer.transform(AbstractContentTransformer.java:206)
   at org.alfresco.repo.search.impl.lucene.LuceneIndexerImpl.indexProperty(LuceneIndexerImpl.java:1488)
   at org.alfresco.repo.search.impl.lucene.LuceneIndexerImpl.createDocuments(LuceneIndexerImpl.java:1190)
   at org.alfresco.repo.search.impl.lucene.LuceneIndexerImpl.updateFullTextSearch(LuceneIndexerImpl.java:1789)
   at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:169)
   at sun.reflect.GeneratedMethodAccessor224.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
   at $Proxy3.index(Unknown Source)
   at org.alfresco.repo.search.impl.lucene.fts.FTSIndexerJob.execute(FTSIndexerJob.java:36)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:191)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)
Caused by: java.lang.ArrayIndexOutOfBoundsException
   at java.lang.System.arraycopy(Native Method)
   at org.apache.poi.hssf.record.UnknownRecord.<init>(UnknownRecord.java:62)
   at org.apache.poi.hssf.record.SubRecord.createSubRecord(SubRecord.java:57)
   at org.apache.poi.hssf.record.ObjRecord.fillFields(ObjRecord.java:99)
   at org.apache.poi.hssf.record.Record.fillFields(Record.java:90)
   at org.apache.poi.hssf.record.Record.<init>(Record.java:55)
   at org.apache.poi.hssf.record.ObjRecord.<init>(ObjRecord.java:61)
   … 28 more
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

1.3.0 Community (windows bundle) installed. Windows 2003 Server.

[kevinr]

The Apache POI library is used to extract text data from various MS Office formats including Excel, it is however not 100% perfect and does occasionally fail to handle certain spreadsheets etc. I believe this error suggests a bug in the POI library where it cannot deal with the spreadsheet you are loading into Alfresco.

Thanks,

Kevin