Export to excel : Error no class found

[Former Member]

Hello Experts,

I am facing a problem  while exporting the data into excel sheet.

DC1 : i have created library dc which contains jxl.jar file in library folder

DC2 : j2ee library DC--->DC1 is the used dc in this and DC2 build and deployed successfully

DC3 : webdynpro dc -->DC1 and DC2s are used DC  (checked build time and runtime)

error  :

The initial exception that caused the request to fail, was:

java.lang.NoClassDefFoundError: jxl/format/CellFormat

at com.pasteur.sku.global.wd.app.wdp.InternalVTab_Bord_SKU.<init>(InternalVTab_Bord_SKU.java:462)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:274)

Both DC2 and DC3 s are successfully build and deployed

How to confirm that the jar file is exist in j2ee library by using visual admin

please help me out to fix the issue

Thanks in advance for your reply.

Regards,

Fayaz Shaik.

[Sharathmg]

Its a nightmare. I have faced it regularly, in spite of implementing it many a times.

To facilitate, I had posted a blog on this issue. Refer the blog for solutions:

Best Regards,

Sharath

[Former Member]

Hello Sharath,

Thanks for you reply

I already seen this and i follewed the same

Still the issue is persist

Regards,

Fayaz Shaik

[Sharathmg]

Try to restart your portal server. If possible, check the availability of jars on the server as my guess is that error is during deploy time.

Best Regards,

Sharath

[Former Member]

Hello sharath,

please let me know the process hot to check jars on server

server restart may required?

Regards,

Fayaz Shaik

[Sharathmg]

If I recollect, under visual admin, Web Dynpro java node the deployed DC should be available. On selecting it you should be able to see the deployed jars.

Maybe research on net or try the old, trial and errors approach on the server to find the jars.

[Former Member]

I dont have admin rights

in the deploy of j2ee library i can jxl.jar file

Isn't mean that jas available on server?

[Sharathmg]

Well, there could be a chance that its missed out. Hence, in my blog I suggested to check the .SDA file for the presence of the jar files. Check it once more and redeploy.

Maybe try to create a new DC for the jars and deploy it. Just a simple name change trick.

Regards,

Sharath

[Former Member]

Hello sharath,

Issue was not yet resolved

Is there anything to be check ?

Thanks in advance for your reply

Regards,

Fayaz Shaik.

[Sharathmg]

Just to clarify, is the error while compiling/building/deploying/runtime?

[Former Member]

only at run time

[Sharathmg]

Then, its because at runtime when the application tried to look for the external api containing the excel methods then it does not find the jar on the server.

The compiler works as the IDE is able to locate it within its folders.

Check the deploy DC. Build a separate DC and try it. Check if the necessary references(if any any) are configured. - No direct solution, just Plain Old, keep doing it again and again till you find the actual issue.

All the best.

Regards,

Sharath