Search found 66 matches

by aluthra48
Thu Jul 09, 2009 11:36 am
Forum: General
Topic: The number of logs for a mult-instantiated parallel job
Replies: 16
Views: 4240

I changed the setting to auto-purge, enable auto-purge, older than 2 days, and this seems to work.

Thanks all
by aluthra48
Thu Jul 09, 2009 10:32 am
Forum: General
Topic: The number of logs for a mult-instantiated parallel job
Replies: 16
Views: 4240

Sorry that I didn't quite explain myself. In disabling the auto-purge, I occassionally got RT LOG error I mentioned. On attempting to do so again, it would apply the change without giving any errors. Once it did not give any errors, I assumed the auto-purge had been disabled. Then I ran the sequence...
by aluthra48
Thu Jul 09, 2009 10:31 am
Forum: General
Topic: The number of logs for a mult-instantiated parallel job
Replies: 16
Views: 4240

Sorry that I didn't quite explain myself. In disabling the auto-purge, I occassionally got RT LOG error I mentioned. On attempting to do so again, it would apply the change without giving any errors. Once it did not give any errors, I assumed the auto-purge had been disabled. Then I ran the sequence...
by aluthra48
Wed Jul 08, 2009 11:26 am
Forum: General
Topic: The number of logs for a mult-instantiated parallel job
Replies: 16
Views: 4240

Hello, That solution did not work. What was curious though, was that on some occassions, as I went about disabling auto-auto purge, it would return with an error message "Unable to return an attached job, Cannot open file RT_LOG". I assume it is due to the log being locked at that point in...
by aluthra48
Wed Jul 08, 2009 9:35 am
Forum: General
Topic: The number of logs for a mult-instantiated parallel job
Replies: 16
Views: 4240

Thanks.

I will report back soon.
by aluthra48
Wed Jul 08, 2009 9:22 am
Forum: General
Topic: The number of logs for a mult-instantiated parallel job
Replies: 16
Views: 4240

In order to disable auto-purge, I selected "view log", then Job====>clear log. I checked "Auto-purge" and unchecked "Auto purge enabled for this job". However, after saving, I return to clear log, and I see "Immediate purge" still checked. I can do the same, w...
by aluthra48
Wed Jul 08, 2009 8:49 am
Forum: General
Topic: The number of logs for a mult-instantiated parallel job
Replies: 16
Views: 4240

Yes, each as a different invocation id. As suggested, I plan to view log for the multi-instantiated job, check auto-purge and "auto purge enabled for this job" and select 25 for "Up to previous (job runs)", as it requires a number from 1 thru 25. I assume this is what the suggest...
by aluthra48
Wed Jul 08, 2009 8:28 am
Forum: General
Topic: The number of logs for a mult-instantiated parallel job
Replies: 16
Views: 4240

The number of logs for a mult-instantiated parallel job

Hello, I have a multi-instantiated parallel job that is executed repeatedly in many sequence jobs. The problem I have is that I seem to be able to retain the logs for the latest 6 executions. That is, if there are 10 sequence jobs, each calling the multi-instantiated job once, I expect to see 10 log...
by aluthra48
Mon Jun 29, 2009 11:19 am
Forum: General
Topic: Reading XML files - Repetition elements
Replies: 10
Views: 16913

Thank you, I have it working now.
by aluthra48
Mon Jun 29, 2009 11:16 am
Forum: General
Topic: Calling a MSSQL Stored procedure
Replies: 7
Views: 5705

Thanks, I will try this. To make it work, I made the following changes: 1. Changed the stored proc to bypass the insert/delete logic, if there are no rows to insert/delete 2. Create an output parameter in the sp, and write it out to a peek stage from the stppx stage. While this works, I will try the...
by aluthra48
Fri Jun 26, 2009 2:50 pm
Forum: General
Topic: Calling a MSSQL Stored procedure
Replies: 7
Views: 5705

Actually, with the stppx configured as mentioned above I get a syntax error. I am sorry, I have tried several permutations that I have lost sight of what configuration gave what error message in the logs. The error message is: APT_CombinedOperatorController,0: Fatal Error: Fatal: [IBM(DataDirect OEM...
by aluthra48
Fri Jun 26, 2009 2:20 pm
Forum: General
Topic: Calling a MSSQL Stored procedure
Replies: 7
Views: 5705

What I meant by "to do so" was how do I configure the stppx stage so that the sp does not abort if there are no rows that can be deleted or inserted? I have selected procedure type "Transform" as I am providing parameters to the sp. Here's the coding for the procedure call syntax...
by aluthra48
Fri Jun 26, 2009 1:41 pm
Forum: General
Topic: Calling a MSSQL Stored procedure
Replies: 7
Views: 5705

Calling a MSSQL Stored procedure

I want to execute a stored procedure using the STPPX stage and I'd like some help with the following 2 questions: The STPPX stage requires an input link. This is fine if the sp requires parameters, as then I can use the input link to provide the parameters to the sp. But what if no parameters are re...
by aluthra48
Thu Jun 18, 2009 9:26 am
Forum: General
Topic: Reading XML files - Repetition elements
Replies: 10
Views: 16913

Thank you all, I will try it. I have been busy with some other issues, and will get back to this and try it out as soon as I can.

Thanks once again
by aluthra48
Tue Jun 16, 2009 3:05 pm
Forum: General
Topic: Reading XML files - Repetition elements
Replies: 10
Views: 16913

I get it. Right now, I have an external source stage -----> xml stage-----> peek stage. This was set up for purposes of experimentation. What I would need is an external source stage---->copy stage with several output links, each to an xml input stage, and each of these xml input stages having an ou...