Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
(SOLVED) Unable to Pass Parameters in CMASAP
 Login/Join
 
Shruthi Joshi
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, 2009Report This Post
Shruthi Joshi
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, 2009Report This Post
Clif
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.


N/A
 
Posts: 397 | Location: New York City | Registered: May 03, 2007Report This Post
Shruthi Joshi
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, 2009Report This Post
Tony A
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: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Shruthi Joshi
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, 2009Report This Post
Shruthi Joshi
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, 2009Report This Post
vaayu
Guru
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: 8206.10
Dev: 8201M
Prod:8009
-********************
 
Posts: 289 | Location: Houston,TX | Registered: June 11, 2004Report This Post
Clif
Guru
posted Hide Post
Please see my answer posted May 07, 2009 11:38 AM. I believe it applies to your situation.


N/A
 
Posts: 397 | Location: New York City | Registered: May 03, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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-2020 Information Builders