Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    (SOLVED) Unable to Pass Parameters in CMASAP
Go
New
Search
Notify
Tools
Reply
  
(SOLVED) Unable to Pass Parameters in CMASAP
 Login/Join
 
Member
posted
{SOLVED}

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


WebFocus 7.6.8
Data Migrator 7.6.8
Windows XP
HTML,Excel
 
Posts: 15 | Registered: February 26, 2009Reply With QuoteReport This Post
Member
posted Hide Post
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


WebFocus 7.6.8
Data Migrator 7.6.8
Windows XP
HTML,Excel
 
Posts: 15 | Registered: February 26, 2009Reply With QuoteReport This Post
Guru
posted Hide Post
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.
 
Posts: 380 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Member
posted Hide Post
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


WebFocus 7.6.8
Data Migrator 7.6.8
Windows XP
HTML,Excel
 
Posts: 15 | Registered: February 26, 2009Reply With QuoteReport This Post
Expert
posted Hide Post
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
 
Posts: 5575 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Member
posted Hide Post
[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]


WebFocus 7.6.8
Data Migrator 7.6.8
Windows XP
HTML,Excel
 
Posts: 15 | Registered: February 26, 2009Reply With QuoteReport This Post
Member
posted Hide Post
[SOLVED]

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


WebFocus 7.6.8
Data Migrator 7.6.8
Windows XP
HTML,Excel
 
Posts: 15 | Registered: February 26, 2009Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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 


-********************
Sandbox: 8205
Dev: 8201M
Prod:8009
-********************
 
Posts: 216 | Location: Houston,TX | Registered: June 11, 2004Reply With QuoteReport This Post
Guru
posted Hide Post
Please see my answer posted May 07, 2009 11:38 AM. I believe it applies to your situation.
 
Posts: 380 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    (SOLVED) Unable to Pass Parameters in CMASAP

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.