{SOLVED}

This message has been edited. Last edited by: Shruthi Joshi,

I gett he following error in Dev. Studio......

Error open/update/close ETLSTATS DB; RC = 506
(FOC506) SU. NO DATA WAS FOUND FOR THE FILE:
DB: ETLLOG ;INFO call failed (segment level): RC = 762
DB: ETLLOG ;INFO call failed (field level): RC = 762
segment ETLLOG ; field DATE not found
Request baseapp/testprocess submitted. Please, wait for request to complete.
(ICM18762) Job ID: 2009-05-06-16-25-31t3cp00000005_00000012
segment ETLLOG ; field DATE not found
segment ETLLOG ; field DATE not found
segment ETLLOG ; field DATE not found
(ICM18763) Request baseapp/testprocess complete
Error open/update/close ETLLOG DB; RC = 762
(FOC762) THE 'WHEN' CLAUSE CAN APPEAR ONCE FOR EACH 'ON' OPTION

The message

(FOC506) SU. NO DATA WAS FOUND FOR THE FILE:
DB: ETLLOG

is telling you that it find the FOCUS file ETLLOG.

Probably because you are attempting to run a DataMigrator flow on a NON DataMigrator server.

If it IS a DataMigrator server then you need to recreate the log and statistics tables which you can do from the DMC or WC.

hi clif,

Thanks for your reply,

I palyed around with different options and I was able to get the solution.....

my issue is solved..

request to close the ticket........

thanks

quote:

request to close the ticket

Shruthi,

Just so that there is no confusion in your mind, this forum is not the Tech Support desk and there is no concept of "ticket". The good folks on this forum respond out of the kindness of their hearts and you should be aware that by raising a topic on this forum it is not akin to raising a case with Tech Support.

If you are refering to the request by the forum administrators to add a status to your posts when they are considered solved, then you have to do the business by editing your first post and amending the subject line to include the tag [SOLVED].

So to do this, go to the first post that you made in this topic and look at the icons on the bottom line of that post - you should see three. The mniddle one is the one you need to click to edit your post.

T

[SOLVED]Originally posted by Shruthi Joshi:
Hi,

I am trying to call DM Process flow from Devloper studio procedure, I have to pass 2 parameters from Dev. Studio procedure to Data migrator process flow....

I use the following code in Dev. Studio

-DEFAULT &&STARTSALARY = &&STARTSALARY;
-DEFAULT &&ENDSALARY = &&ENDSALARY;

EX CMASAP REQ_NAME=testprocess, CM_ASYNC=OFF, PARMS="&&STARTSALARY=&STARTSALARY, &&ENDSALARY=&ENDSALARY"

The parameters are not passing to DM rocess flow...

In the DM process flow I have a stored procedure which will take parameters from that it will pass to 2 data flows.

In the DM 2 data flows, 1st flow i am filtering with start and end salary, in the second data flow I am just migrating all the data without any conditions........

Please help on this as I need it asap....

Webfocus verison 7.6.8 and have DM with Webfocus.....

Thanks in adavance[/QUOTE]

[SOLVED]

Thanks for the help..........

Hi Shruthi,
Could you please share your solution. We are trying to create a similar WF procedure to launch a DM job using CMASAP. This is the error I get so far.

 

 Error open/update/close ETLSTATS  DB; RC = 506
 (FOC506) SU. NO DATA WAS FOUND FOR THE FILE:
 DB: ETLLOG  ;INFO call failed (segment level): RC =  762
 DB: ETLLOG  ;INFO call failed (field level): RC = 762
 segment ETLLOG  ; field DATE         not found
 Request production_dm/pv_test_flow submitted. Please, wait for request to
 complete.
 (ICM18762) Job ID: 2013-09-04-10-09-23t3cp00000930_00000001
 segment ETLLOG  ; field DATE         not found
 segment ETLLOG  ; field DATE         not found
 segment ETLLOG  ; field DATE         not found
 segment ETLLOG  ; field DATE         not found
 (ICM18822) Communication Error
 Error open/update/close ETLLOG  DB; RC = 762
 (FOC762) THE 'WHEN' CLAUSE CAN APPEAR ONCE FOR EACH 'ON' OPTION 

Please see my answer posted May 07, 2009 11:38 AM. I believe it applies to your situation.