Error when submitted report in Web

Hi Guys.
I have a report when launh in fat client this work perfect, but when submitted this same report in web not work.
The log show this error:


21 Jan 2011 18:22:25,586 [SEVERE] MSUAREZ - [METADATA] Retrieved JDENET.tempFileDir, using C:\JDE_HOME\targets\JDV812\temp
21 Jan 2011 18:22:25,820 [SEVERE] MSUAREZ - [METADATA] Cause exception java.util.zip.ZipException: duplicate entry: RDASPEC/R55LL29.Z55LL001.6.1.4.0.0.xml
java.util.zip.ZipException: duplicate entry: RDASPEC/R55LL29.Z55LL001.6.1.4.0.0.xml
at java.util.zip.ZipOutputStream.putNextEntry(ZipOutputStream.java:188)
at com.peoplesoft.pt.e1.metadata.fileAccess.WriteRepository.insert(Unknown Source)
at com.peoplesoft.pt.e1.metadata.dataAccess.SpecWriteFileAccessImpl.insert(Unknown Source)
at com.peoplesoft.pt.e1.metadata.dataAccess.SpecWriteFileAccessImpl.insert(Unknown Source)
at com.jdedwards.jas.SubmitUBEXML.getOverrideSpecForUBE(Unknown Source)
at com.jdedwards.jas.SubmitUBEXML.packageSpecsAndSubmit(Unknown Source)
at com.jdedwards.jas.SubmitUBE.launchUBE(Unknown Source)
at com.jdedwards.jas.JDEOWDirect.jdeOWDirect(Unknown Source)
at com.jdedwards.jas.JDEOWDirect.processServerRequest(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.jdedwards.jas.ServletProxy.callServerComponent(Unknown Source)
at com.jdedwards.jas.ServletProxy.servletProxy(Unknown Source)
at com.jdedwards.jas.ServletProxy.dispatch(Unknown Source)
at com.jdedwards.jas.net.NetConnection.callJAS(Unknown Source)
at com.jdedwards.jas.net.NetManager.processRequest(Unknown Source)
at com.jdedwards.jas.net.NetManager.callJAS(Unknown Source)
at com.jdedwards.jas.net.NetManager.callJAS(Unknown Source)
at com.jdedwards.jas.net.NetManager.callLaunchUBEWeb(Unknown Source)
at com.jdedwards.runtime.er.SysFunctionStatement.launchBatchApp(Unknown Source)
at com.jdedwards.runtime.er.SysFunctionStatement.execute7(Unknown Source)
at com.jdedwards.runtime.er.SysFunctionStatement.execute6(Unknown Source)
at com.jdedwards.runtime.er.SysFunctionStatement.execute5(Unknown Source)
at com.jdedwards.runtime.er.SysFunctionStatement.execute4(Unknown Source)
at com.jdedwards.runtime.er.SysFunctionStatement.execute3(Unknown Source)
at com.jdedwards.runtime.er.SysFunctionStatement.execute2(Unknown Source)
at com.jdedwards.runtime.er.SysFunctionStatement.execute(Unknown Source)
at com.jdedwards.runtime.er.StatementBlock.execute(Unknown Source)
at com.jdedwards.runtime.er.IfStatement.execute(Unknown Source)
at com.jdedwards.runtime.er.StatementBlock.execute(Unknown Source)
at com.jdedwards.runtime.er.ERModule.executeEventRules(Unknown Source)
at com.jdedwards.runtime.engine.form.FormEngine.doEvent(Unknown Source)
at com.jdedwards.runtime.vtcomponent.form.VTForm.doEvent(Unknown Source)
at com.jdedwards.runtime.engine.ButtonEngine.onClick(Unknown Source)
at com.jdedwards.runtime.vtcomponent.VTHyperMenuExit.sysPressButton(Unknown Source)
at com.jdedwards.runtime.vtcomponent.VTHyperMenuExit.onClick(Unknown Source)
at com.jdedwards.runtime.vtcomponent.VTHyperMenuExit.processVirtualEvent(Unknown Source)
at com.jdedwards.runtime.virtual.OWVirtual.processVTEvent(Unknown Source)
at com.jdedwards.runtime.virtual.OWVirtual.processEventLoop(Unknown Source)
at com.jdedwards.runtime.virtual.OWVirtual.showWindow(Unknown Source)
at com.jdedwards.runtime.virtual.OWVirtual.startForm(Unknown Source)
at com.jdedwards.runtime.er.FormInterconnectStatement.execute(Unknown Source)
at com.jdedwards.runtime.er.StatementBlock.execute(Unknown Source)
at com.jdedwards.runtime.er.IfStatement.execute(Unknown Source)
at com.jdedwards.runtime.er.StatementBlock.execute(Unknown Source)
at com.jdedwards.runtime.er.IfStatement.execute(Unknown Source)
at com.jdedwards.runtime.er.StatementBlock.execute(Unknown Source)
at com.jdedwards.runtime.er.IfStatement.execute(Unknown Source)
at com.jdedwards.runtime.er.StatementBlock.execute(Unknown Source)
at com.jdedwards.runtime.er.IfStatement.execute(Unknown Source)
at com.jdedwards.runtime.er.StatementBlock.execute(Unknown Source)
at com.jdedwards.runtime.er.ERModule.executeEventRules(Unknown Source)
at com.jdedwards.runtime.engine.form.FormEngine.doEvent(Unknown Source)
at com.jdedwards.runtime.engine.form.FindBrowseEngine.processOK(Unknown Source)
at com.jdedwards.runtime.vtcomponent.form.VTForm.processOK(Unknown Source)
at com.jdedwards.runtime.engine.ButtonEngine.onClick(Unknown Source)
at com.jdedwards.runtime.vtcomponent.VTHyperMenuExit.sysPressButton(Unknown Source)
at com.jdedwards.runtime.vtcomponent.VTHyperMenuExit.onClick(Unknown Source)
at com.jdedwards.runtime.vtcomponent.VTHyperMenuExit.processVirtualEvent(Unknown Source)
at com.jdedwards.runtime.virtual.OWVirtual.processVTEvent(Unknown Source)
at com.jdedwards.runtime.virtual.OWVirtual.processEventLoop(Unknown Source)
at com.jdedwards.runtime.virtual.OWVirtual.run(Unknown Source)
at com.jdedwards.base.util.ThreadPool$WorkerThread.run(Unknown Source)
21 Jan 2011 18:22:25,820 [SEVERE] MSUAREZ - [METADATA] JDESpec error code = SPEC_DATA_CREATE_FAILURE com.peoplesoft.pt.e1.base.metadata.dataAccess.JDESpecException: MetaData object could not be created.

Well, because of these references in your attachment:

[ QUOTE ]
...Unhandled exception in populateWebVersionTable
Failed to select versions from F983051 table


[TABLE_SPECS_PHYSICAL_TABLE_MISMATCH] Columns in table specification for Table F983051 do not match those in database SRBP00EO00


Cause exception java.util.zip.ZipException: duplicate entry: RDASPEC/R55LL29.Z55LL001.6.1.4.0.0.xml


SubmitUBE.launchUBE() : Exception thrown during UBE submission! | Report Name : R55LL29, Version Name : Z55LL001, Server Name : null, User Name : MSUAREZ com.jdedwards.system.kernel.LaunchUBEException: MetaData object could not be created.


[/ QUOTE ]

There is one issue which matches your problem exactly, bug report 11039103 (link).

In part, it states: "There is an existing SAR BUG:7207928 for the issues with
business views with joins on same table. The UBEs with such business views will not get submitted from web client. They fail wiht the below errors."

It goes on to list errors very much like the ones above. Then it states: "Customers can bypass these errors by removing the data sequence and data selection from the report and including the sequence at the event rules level. But with this approach there is an another issue with data selection," and then lists a couple of scenarios.

This issue was closed with status 09 - Closed, Not a Bug.

There was also another issue I saw where a table conversion UBE, after checking the box for Data Selection, could be submitted from a fat client, but not from the web. The solution here was to uncheck the Data Selection box, or apply the fix in Tools Release 8.98.3.0 or later.

Do either of these sound like your UBE?

Hi Ken

This problem is very rare, with our developers saw that the problem occurred in a business view this had 5 tables and the log files mentioned a problem in the sorting the information provided by the view.

for fix this let's change the logic in the business view.

Thank's for your help.

Regards

</font><blockquote><font class="small">En réponse à:</font><hr />
There was also another issue I saw where a table conversion UBE, after checking the box for Data Selection, could be submitted from a fat client, but not from the web. The solution here was to uncheck the Data Selection box, or apply the fix in Tools Release 8.98.3.0 or later.
Do either of these sound like your UBE?

[/ QUOTE ]


Hi klwong :
How to uncheck the Data Selection box for the user or for a report.???