[Jasper Talend Bigdata ETL 5.5.1 TAC not loading in linux]

sorry hozawa... it got resolved after tomcat restart... so i didnt update... but is a regular recurring problem as tomcat logs dont show any error info.

[Adhoc Report Schedule for lastweek or last month]

we are using, JasperServer 6.3.0

[Adhoc Report Schedule for lastweek or last month]

Hi,

I've adhoc reports created using Adhoc View, but business needs to schedule those reports with parameters last 7 days or last month like that... Currently we can give the parameter as some hardcoded date. But we need that to change dynamically for last 7 days...

 

can any one suggest 

thanks

[tssh component erroring out with csvloader of voltdb]

permissions issue...and resolved...

[tssh component erroring out with csvloader of voltdb]

its permission issue... got it...

[tssh component erroring out with csvloader of voltdb]

Hi,

I need to execute a volt linux command using Talend job. So im using tssh component. I tried by echo below command and then by calling a sh script (which will have below cmd). It is throwing error below error..
test.sh: line 1: csvloader: command not found   

csvloader --file=test.out --user=name --password=pwd --servers=localhost --port=21210 --separator="#" --noquotechar -p Table.insert

I tried by placing the above command directly in tssh compoent and then echo  `above command` and then keeping it in sh script.. 

Can any one help me with this ... Im not sure if im missing something here ?
Appreciate any help here...
thanks
reddy

[how to change sender email id (admin@company.com) from TAC notifications]

Right, looks like that is the only option. thank you andrew

[Not able to insert Data into Voltdb]

thanks Ben

[how to change sender email id (admin@company.com) from TAC notifications]

Hi,

I've Talend 6.0.1 installed and running fine. The logins are all changed to the users name, but the email notifications still come from admin@company.com which was default login. Can anyone help me where to change this so that the sender id will change for all tac notifications...

thanks 

prakash

[TAC 5.5.1 Jobs show running from hours but there is no any message or error]

Hi All,

 

We have TAC 5.5.1 running from last few months without any issues. But from yesterday teh jobs show running for hours ... and when i see the log nothing is there.. so seems something is wrong.

tried to find details from catalina.out but there is nothing in it too..

 

can any one help me quickly what is wrong here..

thanks 

prakash

[Not able to insert Data into Voltdb]

can any one answer or help me here?

 

[Not able to insert Data into Voltdb]

Hi Guys,

I have a requirement to insert data into voltdb using Talend.

Im able to get data from Voltdb using tJDBCInput but when i try to insert records into Voltdb using tJDBCOutput , it throws an error.

 

[statistics] connecting to socket on port 3387

[statistics] connected

Exception in component tJDBCOutput_1

java.sql.SQLFeatureNotSupportedException

at org.voltdb.jdbc.SQLError.noSupport(SQLError.java:65)

at org.voltdb.jdbc.JDBC4Connection.setAutoCommit(JDBC4Connection.java:446)

at j4u_test.etl_volt_test_0_1.etl_volt_test.tFileInputDelimited_1Process(etl_volt_test.java:1580)

at j4u_test.etl_volt_test_0_1.etl_volt_test.tJDBCInput_1Process(etl_volt_test.java:1230)

at j4u_test.etl_volt_test_0_1.etl_volt_test.runJobInTOS(etl_volt_test.java:2248)

at j4u_test.etl_volt_test_0_1.etl_volt_test.main(etl_volt_test.java:2082)

[FATAL]: j4u_test.etl_volt_test_0_1.etl_volt_test - tJDBCOutput_1 null

[statistics] disconnected

 

thanks

prakash

[Report scheduler doesnt have create schedule button active]

I'm not finding any buttons related to create schedule, but i can see Job ID, Job Name, Owner, State, LastRun  NextRun and Enabled menu ... 

regards

rpr

[Report scheduler doesnt have create schedule button active]

Hi, I installed Jasper report server 6.3.0 on redhat linux and after creating a report when i go to create schedule the buttons are greyed out..

appreciate any help if i missed anything here...

 

thanks 

rpr

[How to launch a report or dashboard after user login to Jasperserver as his homepage]

Hi All,

I'm new to Jasper and Using Jaspersoft 6.1 version.

I have a requirement to launch a default report or dashboard to each user immediately after  login. Is it possible, if so how to configure it.

As of now for any user after login it launches a default page with Data sources / Domains / Adhoc views / Dashboard etc...

Appreciate any of your expertise response in advance.

Thanks and Rgds

[Jasper Talend Adminstration center link is not loading up]

Hi,

I installed TibcoJaspersoft Bigdata ETL 5.5.1 on linux box and when I started the service and launched the TAC it asked for login details and then it got struck.

When I closed hte browser and relaunched also it is not asking any login details but just stays there... Tomcat is fine.

plz help me.

 

[sapjco.jar and sapjco3.jar]

 

 

Hi,

I have installed a Jasper Bigdata ETL and when I launch the Studio on windows 8 machine, It gets struck in the create job window. When I verify the log, it says jar files missing. Tried to download from google  but no luck. It says SAP customer details. How can it is referring to these dlls without need. If so Jasper should have them inbuilt.

!MESSAGE one third party library file [C:Jaspersoft5.5.1studioJETLBigData-r118616-V5.5.1libjavasapjco.jar] was not found, it is required for bundle [org.talend.repository.sapwizard], please download it and place in [C:Jaspersoft5.5.1studioJETLBigData-r118616-V5.5.1libjava]

 

 

 

[Jaspersoft Studio - Variable with formula]

Hi,

I'm new to Jasper Reports. I'm using Jasper Studio to create reports and as part of requirement i have to use a variable to get the % of the fields. So added a variable with expression field2/field1 in the expression editor. I'm getting compilation error.

The operator / is undefined for the argument type(s) java.math.BigDecimal, java.math.BigDecimal

                value = ((java.math.BigDecimal)field_TARGET_SUC.getValue()) / ((java.math.BigDecimal)field_TARGET.getValue()); //$JR_EXPR_ID=8$
 

can any one help me to fix it.

I'm not sure what to select for Value Class name for calculations ?

thanks

 

[how to refer a text field with formula in another text field]

I'm new to Jasper Reports and I'm using iReport 5.6.0

I have a requirement where there is textfield1 with calculations and then I need to add another textfield2 based on the result of the textfield1. How to refer it? Can any of you plz help me.

Also another question is I have an Excel Report with multiple calculations. I want to build a report with all formulas in Jasper Report. How can I use formulas like IFERROR(A5/A4,0) or  

IFERROR((ABS(($L5-$Q5)-0))/SQRT((((($H5*$L5)+($O5*$Q5))/($H5+$O5))*(1-((($H5*$L5)+($O5*$Q5))/($H5+$O5)))*((1/$H5)+(1/$O5)))),"NA")

Thanks