About saibabu

saibabu · ‎08-31-2018

Hi Dijke, Thank u so much it works fine now and dumping tables after using this --result-file

saibabu · ‎08-30-2018

here am trying this command from talend after build the job am calling in ubuntu server which my sql placed in it. again am getting the same issue mysqldump: Couldn't find table: ">" -- MySQL dump 10.13 Distrib 5.7.23, for Linux (x86_64) -- -- Host: 192.168.20.21 Database: kafnu -- ------------------------------------------------------ -- Server version 5.7.23-0ubuntu0.16.04.1 /*!40101 SET @old_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @old_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @old_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @old_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @old_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @old_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @old_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @old_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

saibabu · ‎08-30-2018

Both cases r not working showing as could n't find table ">"

saibabu · ‎08-29-2018

Hi am trying to dump mysql database tables using tsystem component in talend main syntax :- "mysqldump -u user-p dbname tablename > file.sql" using this am getting error like mysqldump: Couldn't find table: ">" after modified syntax : - mysqldump -u user-p dbname tablename like this am getting dump completed successfully but file not found.if i given path and file it's showing error how to resolve this ??? please suggest

saibabu · ‎08-29-2018

i have used the both ways using java row i gave like this context.insert = "INSERT INTO CHECK_IN(CoworkerId,CoworkerFullName ) VALUES (" + row7.CoworkerId+ "," +row7.CoworkerFullName+ ")"; (in tjavarow) tdbinput--->tjavarow | | subjob tfixedflowinput--tmap--tfileoutputdelimited tfixedflowinput - given context.insert as fixed in column1 and map to tfileoutputdelimited here i get only one insert statement but it's not iterate the all records

saibabu · ‎08-28-2018

i tried this way but am getting empty page help me. is any other way to generate the .sql file?

saibabu · ‎08-28-2018

Yes, i want insert scripts.also i have used tsystem component using by this command "mysqldump -u talenduser -p db name table name > output.sql" but am not getting the result ,getting error as mysqldump: Couldn't find table: ">" can u pls suggest me to resolve this error

saibabu · ‎08-27-2018

Hi , Am trying to get the .sql file as output for insert scripts from tmysqlinput as source, but i did not get any solution for this scenario. how can i achieve for this method

saibabu · ‎08-27-2018

Hi , Can u please tell me how to get the insert scripts from source like as txt,csv,xlsx .i need .sql file as output which have insert scripts. Advance thanks,

saibabu · ‎04-16-2018

Hello Thwabi, Thanks for ur reply can u please give me the suggestion to resolve the issue ,which file to be placed for this error case'Kindlw awaiting for ur great reply asap Best regards, Sai babu

saibabu · ‎04-11-2018

Hi , I have .bat file which applied given a trigger action in an task scheduler to run every day @ 3 pm daily.In this case am getting error while .bat file running "warn no appenders could be found for logger <net.sf.jasperreports.engine.xml.jrxml digestor factory> " in the prompt .Even the process is complete in back end using this .bat file but the .bat file is not closing automatically by this issue. As per trigger action in scheduler Next day @ 3 pm again it need to start the .bat file but it was showing the error : "Process is happening by the another user " to resolve this error need to close the .bat file..How can i resolve this?Please help me for this Thanks & Regards, Sai babu

saibabu · ‎03-27-2018

am getting files with data when i run this job in studio, its fine totally in both cases (run in through studio and .bat file ) with out any errors .But, only getting the issue from .bat file execution run for sometimes it's not giving the output file in the output path folder i have checked surrounded folders also but no use Finally, i didn't get any errors from my job while run in studio and .bat file for sometimes am not able to get the file generation like today it giving the output files next day won't get after next day it giving the output files like this happens

saibabu · ‎03-23-2018

@rhall_2_0 here after calling tOraclesp component am fetching data from table to excel file Actually, using batch file (.bat file) i run the job ,from this files are not generated in the output path. sometimes the files are generating in output path excel and sometimes the files are not generating.i don't why it happens like this could u pls help me to resolve this issue

saibabu · ‎03-23-2018

Hi , I am facing below issue of my ta-lend job: Some times my job was not able to generate output files after calling t Oracle Sp_1 ,which executed successfully in Database level .But ,the output files are not generating Which i declared the path in the t File Output Excel_1.Please help me on this. Regards, Saibabu

Date Registered	‎05-30-2017 11:12 PM
Date Last Visited	‎12-06-2018 07:40 AM
Total Messages Posted	15
Total Kudos Received	1

About saibabu

Re: unable to dump mysql database table using tsys...

Re: unable to dump mysql database table using tsys...

Re: unable to dump mysql database table using tsys...

unable to dump mysql database table using tsystem ...

Re: unable to get output .sql file from db source

Re: unable to get output .sql file from db source

Re: unable to get output .sql file from db source

unable to get output .sql file from db source

Re: Printing SQL Queries generated by Output Compo...

Re: Error message :warn no appenders could be foun...

Error message :warn no appenders could be found fo...

Re: Not able to generate output files

Re: Not able to generate output files

Not able to generate output files