gcorder

I am reinstalling JR on a computer that had the server software uninstalled. I downloaded JR server cp 4.7.0 and iReport 5.0. iReport 5.0 installed fine but I am getting a error during installation for the server. What can I do to get past this? I don't see an existing tomcat running as a service. I have chosen to install the bundled version of tomcat and postgresql during install. Log started 12/05/2012 at 16:29:03Preferred installation mode : win32Trying to init installer in mode win32Mode win32 successfully initializedPreparing to InstallPreparing to Install[16:29:33] Log: PostgreSQL version 9Creating directory C:Program Filesjasperreports-server-cp-4.7.0Creating directory C:Program Filesjasperreports-server-cp-4.7.0postgresqlCreating directory C:Program Filesjasperreports-server-cp-4.7.0postgresqllibCreating directory C:Program Filesjasperreports-server-cp-4.7.0postgresqllibpluginsCreating directory C:Program Filesjasperreports-server-cp-4.7.0postgresqlStackBuilderCreating directory C:Program Filesjasperreports-server-cp-4.7.0postgresqlStackBuildershareCreating directory C:Program Filesjasperreports-server-cp-4.7.0postgresqlStackBuildersharei18nCreating directory C:Program Filesjasperreports-server-cp-4.7.0postgresqlStackBuildersharei18nzh_CNCreating directory C:Program Filesjasperreports-server-cp-4.7.0postgresqlStackBuildersharei18nfr_FRCreating directory C:Program Filesjasperreports-server-cp-4.7.0postgresqlStackBuildersharei18nsv_SECreating directory C:Program Filesjasperreports-server-cp-4.7.0postgresqlStackBuildersharei18ntr_TRCreating directory C:Program Filesjasperreports-server-cp-4.7.0postgresqlStackBuildersharei18nja_JPCreating directory C:Program Filesjasperreports-server-cp-4.7.0postgresqlStackBuildersharei18nde_DECreating directory C:Program Filesjasperreports-server-cp-4.7.0postgresqlStackBuildersharei18nru_RUCreating directory C:Program Filesjasperreports-server-cp-4.7.0postgresqlshareCreating directory C:Program Filesjasperreports-server-cp-4.7.0postgresqlsharepljavaCreating directory C:Program Filesjasperreports-server-cp-4.7.0postgresqlsharetsearch_data . . . . . . . ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ break ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Unpacking C:Program Filesjasperreports-server-cp-4.7.0postgresqlbinecpg.exe Unpacking C:Program Filesjasperreports-server-cp-4.7.0postgresqlbinpgAdmin3.exe Unpacking C:Program Filesjasperreports-server-cp-4.7.0postgresqlbinpg_dump.exe Unpacking C:Program Filesjasperreports-server-cp-4.7.0postgresqlbinstackbuilder.exe Unpacking C:Program Filesjasperreports-server-cp-4.7.0postgresqlbinmsvcr90.dll [16:31:12] Creating C:Program Filesjasperreports-server-cp-4.7.0/postgresql/data [16:31:12] C:Program Filesjasperreports-server-cp-4.7.0/postgresql/data OK [16:31:12] Before running cacls [16:31:13] postgres_grantedPermissions = [16:31:13] postgres_deniedPermissions = [16:31:13] Running cacls Executing cacls "C:Program Filesjasperreports-server-cp-4.7.0/postgresql/data" /e /c /t /p gcorder:c Script exit code: 0 Script output: processed dir: C:Program Filesjasperreports-server-cp-4.7.0postgresqldata Script stderr: [16:31:15] cacls "C:Program Filesjasperreports-server-cp-4.7.0/postgresql/data" /e /c /t /p gcorder:c" [16:31:15] postgres_grantedPermissions = delete file_append_data file_execute file_generic_execute file_generic_read file_generic_write file_read_attributes file_read_data file_read_ea file_write_attributes file_write_data file_write_ea read_control standard_rights_execute standard_rights_read standard_rights_write synchronize [16:31:15] postgres_deniedPermissions = [16:31:15] Running setWindowsACL [16:31:15] postgres_grantedPermissions = delete file_append_data file_execute file_generic_execute file_generic_read file_generic_write file_read_attributes file_read_data file_read_ea file_write_attributes file_write_data file_write_ea read_control standard_rights_execute standard_rights_read standard_rights_write synchronize [16:31:15] postgres_deniedPermissions = [16:31:15] Initializing database Executing initdb.exe -U postgres -E UTF8 -D C:/PROGRA~1/JASPER~1.0/POSTGR~1/data Script exit code: 1 Script output: Script stderr: Program ended with an error exit code Error running initdb.exe -U postgres -E UTF8 -D C:/PROGRA~1/JASPER~1.0/POSTGR~1/data : Program ended with an error exit code Executing sc stop Script exit code: 1639 Script output: DESCRIPTION: Sends a STOP control request to a service. USAGE: sc stop [service name] = Optional reason code number for service stop formed with the following elements in the format: Flag:Major reason:Minor reason [E.g., 1:2:8 means Hardware: Disk (Unplanned)] Flag Major reason ------------------ --------------------------- 1 - Unplanned 1 - Other 2 - Custom 2 - Hardware 4 - Planned 3 - Operating System 4 - Software 5 - Application 64-255 - Custom Minor reason ----------------------------------- 1 - Other 2 - Maintenance 3 - Installation 4 - Upgrade 5 - Reconfiguration 6 - Hung 7 - Unstable 8 - Disk 9 - Network Card 10 - Environment 11 - Hardware Driver 12 - Other Driver 13 - Service Pack 14 - Software Update 15 - Security Fix 16 - Security 17 - Network Connectivity 18 - WMI 19 - Service Pack Uninstall 20 - Software Update Uninstall 22 - Security Fix Uninstall 23 - MMC 256-65535 - Custom = Optional comment for the reason above (127 characters maximum) Script stderr: Program ended with an error exit code Error running sc stop : Program ended with an error exit code Executing sc delete Script exit code: 1639 Script output: DESCRIPTION: Deletes a service entry from the registry. If the service is running, or another process has an open handle to the service, the service is simply marked for deletion. USAGE: sc delete [service name] Script stderr: Program ended with an error exit code Error running sc delete : Program ended with an error exit code Executing sc stop jasperreportsTomcat Script exit code: 1060 Script output: [sC] OpenService FAILED 1060: The specified service does not exist as an installed service. Script stderr: Program ended with an error exit code Error running sc stop jasperreportsTomcat : Program ended with an error exit code Executing sc delete jasperreportsTomcat Script exit code: 1060 Script output: [sC] OpenService FAILED 1060: The specified service does not exist as an installed service. Script stderr: Program ended with an error exit code Error running sc delete jasperreportsTomcat : Program ended with an error exit code

I am having difficulty figuring out how to use the various elements to insert a letter format with various fields within the letter. My questions are, do I use the Static Text, Text Field or Sub Report elements, and I suspect that I can/should place these in the detail band of the report. I have searched fairly wide but can't find my exact answer. Example: Dear $F{fname}, Thank you for your recent order in the amount of $F{amt1}. You have been a customer since $F{firstdate}. Regards, Customer Service

Worked well, thank you kindly.

Thanks for the reply. No, I have not moved any files, just stepped through the initial installation. One thing that I didn't do was to install the sample files/reports. I did locate the jt400.jar file and added it to the location you specified; restarted the services and logged back in but stll same error. I have gone back and read the JP Server Community Project Users Guide and have removed what reports that I was trying to manually install to the server and instead, went at loading reports from within iReports. Now when I have a working preview in iReports and I step through the User Guide of adding the report and resources to the Repository Navigator, I still get the Error Filling Report. My JDBC Datasource Driver: sun.jdbc.odbc.JdbcOdbcDriver URL: jdbc:odbc:sJHA2020 I find it odd that when I finish the add JasperServer Report and complete the ReportUnit Wizard in iReport, I do see the Resources folder get built in my report unit but I can't click on the resources folder and see anything within it. When I go over to the browser to view the JasperReport Server and look under the View->Repositories, I don' t see any info regarding my Datasource there. I am sure that I am missing something. Any other suggestions welcomed. Post Edited by gcorder at 08/24/2012 09:03 Post Edited by gcorder at 08/24/2012 09:50

JasperServer 4.7.0 I have built my first report in iReport and have included it in the local JasperServer repository. I have defined a datasource for the folder that I placed the report in on JS repository. Datasource test succeeds and the report previews fine in iReport. When I run the report I get the following 3 errors: =============================== The server has encountered an error. Please excuse the inconvenience. Error Message com.jaspersoft.jasperserver.api.JSException: Error filling report Error Message net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query : SELECT "CFMAST"."CFNA1", Error Message java.sql.SQLException: [iBM][system i Access ODBC Driver][DB2 for i5/OS] - Error message text unavailable. Message can not be translated successfully.