pull values from database and pass to tRunJob as values for parameters

[Anonymous]

I have a table (pic 1) that contains information that I want to, pull with tMSSqlInput and, pass as Context Parameters, via tRunJob (pics 2-5), to a sub-Job (dummy process currently, shown in pic 8, the actual process is what is deactivated above in the pic). I want it to loop through every row in the table and pass the information to tRunJob.
But I am having trouble getting the main routine to work (pics 6 & 7)

Starting job MainRoutine_DeleteFiles at 17:13 03/06/2008.
Exception in thread "main" java.lang.Error: Unresolved compilation problems:
notifications.copy_of_subroutine_deletefiles_2_0.Copy_of_SubRoutine_DeleteFiles cannot be resolved to a type
notifications.copy_of_subroutine_deletefiles_2_0.Copy_of_SubRoutine_DeleteFiles cannot be resolved
notifications.copy_of_subroutine_deletefiles_2_0.Copy_of_SubRoutine_DeleteFiles cannot be resolved
notifications.copy_of_subroutine_deletefiles_2_0.Copy_of_SubRoutine_DeleteFiles cannot be resolved
notifications.copy_of_subroutine_deletefiles_2_0.Copy_of_SubRoutine_DeleteFiles cannot be resolved
connecting to socket on port 3432
connected
connecting to socket on port 4426
connected
Job MainRoutine_DeleteFiles ended at 17:13 03/06/2008.

[Anonymous]

Hello strpdsnk
Where do use the value of TargetFolder field in your child job? Can you upload a screenshot of child job?
Best regards

shong

[Anonymous]

ok I activated part of the actual subjob I want it to run, not the dummy part
Pictures:
1 - Main Routine
2 - Sub Routine - first step
3 - Sub Routine - first step
4 - Sub Routine - first step
5 - Sub Routine - dummy and actual processes shown
Error with original tJavaRow code (row3.TargetFolder=row2.TargetFolder.replaceAll("\\\\","\\\\\\\\")

Starting job Copy_of_MainRoutine_DeleteFiles_a at 14:00 05/06/2008.
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\ )
at notifications.copy_of_subroutine_deletefiles_2_0.Copy_of_SubRoutine_DeleteFiles.tFileList_1Process(Copy_of_SubRoutine_DeleteFiles.java:525)
at notifications.copy_of_subroutine_deletefiles_2_0.Copy_of_SubRoutine_DeleteFiles.runJobInTOS(Copy_of_SubRoutine_DeleteFiles.java:1005)
at notifications.copy_of_subroutine_deletefiles_2_0.Copy_of_SubRoutine_DeleteFiles.runJob(Copy_of_SubRoutine_DeleteFiles.java:905)
\gwpack\import\|*.zip|45.0
\\gwpack\\import\\||
at notifications.copy_of_mainroutine_deletefiles_a_0_1.Copy_of_MainRoutine_DeleteFiles_a.tMSSqlInput_2Process(Copy_of_MainRoutine_DeleteFiles_a.java:964)
at notifications.copy_of_mainroutine_deletefiles_a_0_1.Copy_of_MainRoutine_DeleteFiles_a.runJobInTOS(Copy_of_MainRoutine_DeleteFiles_a.java:1193)
Job Copy_of_MainRoutine_DeleteFiles_a ended at 14:00 05/06/2008.

and I updated the code in tJavaRow to include the other 2 columns:

row3.TargetFolder=row2.TargetFolder.replaceAll("\\\\","\\\\\\\\");
row3.Extension_FileName=row2.Extension_FileName;
row3.NumDaysRetain=row2.NumDaysRetain;

Error with modified tJavaRow code

Starting job Copy_of_MainRoutine_DeleteFiles_a at 14:01 05/06/2008.
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\ )
at notifications.copy_of_subroutine_deletefiles_2_0.Copy_of_SubRoutine_DeleteFiles.tFileList_1Process(Copy_of_SubRoutine_DeleteFiles.java:525)
at notifications.copy_of_subroutine_deletefiles_2_0.Copy_of_SubRoutine_DeleteFiles.runJobInTOS(Copy_of_SubRoutine_DeleteFiles.java:1005)
at notifications.copy_of_subroutine_deletefiles_2_0.Copy_of_SubRoutine_DeleteFiles.runJob(Copy_of_SubRoutine_DeleteFiles.java:905)
\gwpack\import\|*.zip|45.0
\\gwpack\\import\\|*.zip|45.0
at notifications.copy_of_mainroutine_deletefiles_a_0_1.Copy_of_MainRoutine_DeleteFiles_a.tMSSqlInput_2Process(Copy_of_MainRoutine_DeleteFiles_a.java:966)
at notifications.copy_of_mainroutine_deletefiles_a_0_1.Copy_of_MainRoutine_DeleteFiles_a.runJobInTOS(Copy_of_MainRoutine_DeleteFiles_a.java:1195)
Job Copy_of_MainRoutine_DeleteFiles_a ended at 14:01 05/06/2008.

The sub job I want to send these context parameter values to is the job I was working on here 2920

[Anonymous]

This is still giving me problems. See my last post above.

[Anonymous]

Ok, I can pass one row from tMSSqlInput to tRunJob (pics 1-3)
And, I've tested it out, and using the same format (tMSSqlInput --row1 (main)--> tRunJob) works when you've got multiple rows being pulled from the database. It just does one row at a time.

[_AnonymousUser]

Hello everybody,
maybe anyone could help me.
I'm beginning to use Talend Open Studio and I already get error messages.
Here is the message I get:

Starting job test2 at 14:27 19/06/2008.
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
at module_4.test2_0_1.test2.main(test2.java:7727)
Job test2 ended at 14:27 19/06/2008.
I really can settle this problem and so, I can't keep on working.
Thank you.

[Anonymous]

1. you should post a new topic for this problem
2. you need to be more specific about what you've done - ie screenshots!

[Anonymous]

I also encountered similar issue and I got the resolution by changing the slash type (from back slash to front slash) while mentioning my target file address.

[Anonymous]

Hi,
I am working on loading data from a file to a table created in hive.
The error is as follows:
Exception in thread "main" java.lang.Error: Unresolved compilation problem: Invalid escape sequence (valid ones are  \b  \t  \n  \f  \r  \"  \'  \\ )
at local_project.just_hive_0_1.just_hive.tHiveConnection_1Process(just_hive.java:354)at local_project.just_hive_0_1.just_hive.runJobInTOS(just_hive.java:1115)at local_project.just_hive_0_1.just_hive.main(just_hive.java:972)
I also tried using\\, but it dint work