I'm trying to use the DevStudio .xls upload function to dynamically create a file and associated master and I'm getting the following message after selecting the file and clicking "Next":
"An HTTP 500 error has been returned while processing the web components. The application server log contains information on why this error has occurred. Contact your application administrator or your software vendor support center for further assistance."
I tried this on two different machines. One localhost and the other zLinux.
Also, how do I get the server log files? ThanksThis message has been edited. Last edited by: Kerry,
Linux/zVM/WF7.6.11
June 10, 2010, 02:36 PM
Francis Mariani
Is it a large file? I have had trouble uploading a large file, so I create a copy with only 10 rows - upload that so that the Master gets generated, then copy the real file from the desktop to the server folder.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
June 10, 2010, 03:01 PM
dojo
No, my test file has three columns and three rows.
Linux/zVM/WF7.6.11
June 10, 2010, 03:05 PM
Tom Flynn
From the documentation:
The Upload Data File option is available from the Master Files folder while developing in the Projects or Data Servers areas.
Interestingly, I go through the motions of this function - I get a message that the file was successfully uploaded and Master created, but it does not show up in the app folder! I retry the upload and I get a message that the file already exists - I select replace, the file still does not show up in the app folder.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
I remember I had nothing but problems with this feature. I was told that the installed Java version must be what the Dev Studio requirements explicitly recommend - a newer version and nothing works.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
June 10, 2010, 03:33 PM
Francis Mariani
Nope, just does not work, I must have a newer version of Java than what is required.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
June 10, 2010, 03:34 PM
Tom Flynn
Hey Francis,
Don't have access to the JAVA version that's on the server. I'll find out...
Possibly it is a Windows Vista, Windows 7, or Excel problem. I made sure to save the file in .xls (Excel 97-2003) format and it doesn't work, however, .csv DOES work under Windows Vista(64bit) on localhost. I'll keep playing with it.
Linux/zVM/WF7.6.11
June 10, 2010, 03:35 PM
Francis Mariani
It's the Java version of the PC where you're running Dev Studio.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
June 10, 2010, 03:37 PM
Francis Mariani
H:\>java -version
java version "1.6.0_03"
Java(TM) SE Runtime Environment (build 1.6.0_03-b05)
Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode, sharing)
Probably not good for Dev Studio 7.6.8. The version of Dev Studio is also important.
I am not changing the Java version on my PC! I did what was recommended by I.B. Tech Support and downgraded Java and I ended up with a mess!
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
June 10, 2010, 03:41 PM
dojo
That sounds like a probable cause. I'll leave this un-solved for now and use the .csv as a work-around. It would be nice to avoid that step, though. Thanks for the info!
Linux/zVM/WF7.6.11
June 10, 2010, 03:48 PM
Tom Flynn
java version "1.6.0_03"
Java(TM) SE Runtime Environment (build 1.6.0_03-b05)
Java HotSpot(TM) 64-Bit Server VM (build 1.6.0_03-b05, mixed mode)
7.6.7 Dev Studio, 7.6.10 Reporting Server, moving all to 7.6.11 at Fiscal Year close, end of June...
This is off the Reporting Server, that I remote in to...
Behind the scenes with Upload File, IBI use apaches POI, a set of java classes that read Excel files. I think this is why the java version is important.
FYI
I should appologise, that an app I wrote years ago caused Upload File to be written.