WarOne

Hello. im developing an ETL process using JaspersoftETL 5.6.2 Community version. What im trying to do is to extract a database from different server and save it to a diffrent server. For example: Server A have a database with tables and data. Server B have an empty database, no table at all. I want to extract all the table including its content to server B using ETL process. i want to make it as short as possible. There is a total of 300++ tables to be extracted. Both server are using PostgreSQL. i manage to retrieve the list of tables that i want using SQL command at the tPostgresqllnput_1 component. The list of names will then act as an iteration to another tPostgresqlInput_2 component. Which will perform row insertion to a tPostgresqlOutput component. the tPostgresqlOutput will also been set with "create table if not exist" on the 'Action on table' option. i hope i explain it clear enough. tPostgresqlInput_2 component schema needs to be dynamic. so it will change its schema based on the original schema on server A. can this be achieved? here is a screenshot of what i have done so far:

Hi, i was developing an ETL process using Jaspersoft ETL v5.6.2 community version. It doesn't involve complicated process. here is the screenshot Now, every component in this image have the tStatCatcher Statistic option on. When i run the job it produce this error Exception in thread "main" java.lang.StackOverflowErrorat sun.util.calendar.ZoneInfo.getOffsets(ZoneInfo.java:271)at sun.util.calendar.ZoneInfo.getOffsets(ZoneInfo.java:248)at java.util.GregorianCalendar.computeFields(GregorianCalendar.java:2276)at java.util.GregorianCalendar.computeFields(GregorianCalendar.java:2248)at java.util.Calendar.setTimeInMillis(Calendar.java:1140)at java.util.GregorianCalendar.<init>(GregorianCalendar.java:621)at java.util.Calendar.createCalendar(Calendar.java:1030)at java.util.Calendar.getInstance(Calendar.java:968)at routines.system.StatCatcherUtils$StatCatcherMessage.<init>(StatCatcherUtils.java:53)at routines.system.StatCatcherUtils.addMessage(StatCatcherUtils.java:148)at routines.system.StatCatcherUtils.addMessage(StatCatcherUtils.java:153)at mpnmps.mps_benchmark_0_1.mps_benchmark.tStatCatcher_1Process(mps_benchmark.java:13840)at mpnmps.mps_benchmark_0_1.mps_benchmark.tStatCatcher_1Process(mps_benchmark.java:13841)at mpnmps.mps_benchmark_0_1.mps_benchmark.tStatCatcher_1Process(mps_benchmark.java:13841) the error is gone when i disabled tStatCatcher_1 and tFileOutputExcel_2. what is wrong with the task. can somebody explain it to me and how can i solve this issue. thanks in advance

wow. hozawa and elizam. i didn't read the specification. truly sorry for my question. thank you guys! i just logged on as superuser and when i set the theme, the login page is changed also. thanks

Hai. i have a problem here. i believe i have read that overrides_custom.css is the last css file that will be called. thus, any changing of the css should be done here. but my problem is, after i set it as an active theme, it does affect every page but not the login page. it seem when i go to the login page, there are no changes at all. i view the source code at the login page using my browser and sure enough, there are no override_custom.css file that have been called. is there anything gone wrong here. im using jasperreport server version 6. please help

Hi. firstly, pardon me for any bad english. i have a very simple question regarding jasperreport server. i logged in as jasperadmin and add a new theme and have modified it. now, i know you can download the theme from the interface but where can i find the exact directory for this saved theme. i looked at apache-tomcat/webapps/jasperserver/themes but my theme was not there? where does it store my custom theme? thanks ADD: To make sure you guys understand what i really want, let me tell you my situation right now. i have updated from jasperserver 5 to 6. but my own custom theme is lost. luckily, i have made a backup of the webapps folder before upgrading. so i need to retrieve the custom theme from the backup folder so i could copy it to the upgraded one. so thats why i need to know where is the directory

This is a screenshot of one of my ETL job. As you can see tMap_1 will produce output to site_out and site_out_update (Both is tMSSqlOutput component). On my tJava_1 i have the following simple code (as shown in the bottom of the image). When i run this, the console output the word "test" 2 times. Which i assumed tJava_1 have been executed 2 times by both site_out and site_out_update. My really simple question is how to make tJava_1 executed only once? to make it clear, tJava_1 will be executed only after tMap_1 have already finished inserting all the data to both site_out and site_out_update. Can somebody help me on this. Is there a component which can combine both the OnComponentOk link into 1 or something. Please help. thanks in advance P/S: pardon my bad english if any :p P/S: in the picture, i have mispelled syntax. (it suppose to be "System ..." not "Syatem ...") ignore it please. just pretend im using the right one :P

hi, i need to create a data source which will connect my report to informix DB. i have downloaded ifxjdbc.jar, ifxjdbcx.jar, ifxtools.jar, ifxsqlj.jar, ifxlang.jar and ifxlsupp.jar and then i copied all the files to apache-tomcat/lib then restart the server. but when i create a new datasource, the informix is not on the dropdown list. is there anymore setup that i need to configure? please help...