Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Monarch Server

Hello All,

Looking for a way that I can bring in some data to date prep studios, then input the export into the classic model this way I can have filtered exports on the server. Do I have to set up a two part process? One that imports the data, manipulates it and exports out (Data Prep). Then another automation piece that ingest that export into the classic model to export the filter value summaries? I am having difficulty getting it out of data prep and into the model under the visual process on the server in one piece.

------------------------------
Vanessa Tanner
Manager Optimization Services
Gap Inc Store Labs
San Francisco NM
(505) 462-0455
------------------------------

Find more posts tagged with

English

Monarch

Accepted answers

Baba_Majekodunmi_703

Hi Vanessa,

Just wanted to reply here to close the loop. Can you confirm that we did find a solution and that the information is here:

https://community.datawatch.com/viewdocument/automated-named-filter-exports-by-c-1?CommunityKey=161a78d6-2987-4579-9719-8e9a8cb50621&tab=librarydocuments

Best Regards,
Baba

------------------------------
Baba Majekodunmi
Solutions Consultant
Altair Engineering Inc.
Alexandria VA
+1 800.988.4739
------------------------------
-------------------------------------------
Original Message:
Sent: 10-24-2019 09:53 AM
From: Vanessa Tanner
Subject: Monarch Server

Hello All,

Looking for a way that I can bring in some data to date prep studios, then input the export into the classic model this way I can have filtered exports on the server. Do I have to set up a two part process? One that imports the data, manipulates it and exports out (Data Prep). Then another automation piece that ingest that export into the classic model to export the filter value summaries? I am having difficulty getting it out of data prep and into the model under the visual process on the server in one piece.

------------------------------
Vanessa Tanner
Manager Optimization Services
Gap Inc Store Labs
San Francisco NM
(505) 462-0455
------------------------------"

All comments

Steve_Caiels

Hi Vanessa,

The following should do what you need.

The Table Export from the Classic Model will not start until all the "actions" leading into it have completed. The file path from the Data Prep Export must match the input to the Classic model.

Note the difference between the solid and dotted lines. The dotted lines can almost be considered "properties" of the icons they feed. So the Workspace is a property of the Data Prep Export and the input file and model are properties of the Classic export.

The workflow is shown by the solid line. The first "action" is the Data Prep export. Once that is complete, the next action is the Table Export.

Regards,
Steve.

------------------------------
Steve Caiels
Professional Services
Altair
------------------------------
-------------------------------------------
Original Message:
Sent: 10-24-2019 09:53 AM
From: Vanessa Tanner
Subject: Monarch Server

Hello All,

Looking for a way that I can bring in some data to date prep studios, then input the export into the classic model this way I can have filtered exports on the server. Do I have to set up a two part process? One that imports the data, manipulates it and exports out (Data Prep). Then another automation piece that ingest that export into the classic model to export the filter value summaries? I am having difficulty getting it out of data prep and into the model under the visual process on the server in one piece.

------------------------------
Vanessa Tanner
Manager Optimization Services
Gap Inc Store Labs
San Francisco NM
(505) 462-0455
------------------------------"

Vanessa_21460

Hi Vanessa,

The following should do what you need.

The Table Export from the Classic Model will not start until all the "actions" leading into it have completed. The file path from the Data Prep Export must match the input to the Classic model.

Note the difference between the solid and dotted lines. The dotted lines can almost be considered "properties" of the icons they feed. So the Workspace is a property of the Data Prep Export and the input file and model are properties of the Classic export.

The workflow is shown by the solid line. The first "action" is the Data Prep export. Once that is complete, the next action is the Table Export.

Regards,
Steve.

------------------------------
Steve Caiels
Professional Services
Altair
------------------------------
-------------------------------------------
Original Message:
Sent: 10-24-2019 09:53 AM
From: Vanessa Tanner
Subject: Monarch Server

Hello All,

Looking for a way that I can bring in some data to date prep studios, then input the export into the classic model this way I can have filtered exports on the server. Do I have to set up a two part process? One that imports the data, manipulates it and exports out (Data Prep). Then another automation piece that ingest that export into the classic model to export the filter value summaries? I am having difficulty getting it out of data prep and into the model under the visual process on the server in one piece.

------------------------------
Vanessa Tanner
Manager Optimization Services
Gap Inc Store Labs
San Francisco NM
(505) 462-0455
------------------------------"

Hello Steve,

Thank you for your reply I tried to set it up this way however now I am facing the following error I get to about 92% of the table export then this appears.

Export failed. No value given for one or more required parameters. Datawatch.Common.Exceptions.DatawatchSdkException: Export failed at DynamicModule.ns.Wrapped_IItemExecutor_39d4340fb0d14de5bb6785758179edd1.Execute(ExecutableItem executableItem) at Datawatch.Services.DataPump.Processing.ProcessDesignerServices.NodeExecutors.CommonNodeExecutor.Execute(ExecutionNode executableItem) at Datawatch.Services.DataPump.Processing.ProcessDesignerServices.NodeExecutors.NodeExecutionManager.Execute(ExecutionNode executionNode, IUnityContainer container) at Datawatch.Services.DataPump.Processing.ProcessDesignerServices.NodeExecutors.NodeExecutionManager.ExecuteNode(ExecutionNode node, IUnityContainer container, ConcurrentBag`1 stopNodes)

Do you know what would be causing this?

------------------------------
Vanessa Tanner
Manager Optimization Services
Gap Inc Store Labs
San Francisco NM
(505) 462-0455
------------------------------
-------------------------------------------
Original Message:
Sent: 10-29-2019 10:35 AM
From: Steve Caiels
Subject: Monarch Server

Hi Vanessa,

The following should do what you need.

------------------------------
Steve Caiels
Professional Services
Altair
------------------------------

Original Message:
Sent: 10-24-2019 09:53 AM
From: Vanessa Tanner
Subject: Monarch Server

Hello All,

Looking for a way that I can bring in some data to date prep studios, then input the export into the classic model this way I can have filtered exports on the server. Do I have to set up a two part process? One that imports the data, manipulates it and exports out (Data Prep). Then another automation piece that ingest that export into the classic model to export the filter value summaries? I am having difficulty getting it out of data prep and into the model under the visual process on the server in one piece.

------------------------------
Vanessa Tanner
Manager Optimization Services
Gap Inc Store Labs
San Francisco NM
(505) 462-0455
------------------------------"

Steve_Caiels

Hello Steve,

Thank you for your reply I tried to set it up this way however now I am facing the following error I get to about 92% of the table export then this appears.

Export failed. No value given for one or more required parameters. Datawatch.Common.Exceptions.DatawatchSdkException: Export failed at DynamicModule.ns.Wrapped_IItemExecutor_39d4340fb0d14de5bb6785758179edd1.Execute(ExecutableItem executableItem) at Datawatch.Services.DataPump.Processing.ProcessDesignerServices.NodeExecutors.CommonNodeExecutor.Execute(ExecutionNode executableItem) at Datawatch.Services.DataPump.Processing.ProcessDesignerServices.NodeExecutors.NodeExecutionManager.Execute(ExecutionNode executionNode, IUnityContainer container) at Datawatch.Services.DataPump.Processing.ProcessDesignerServices.NodeExecutors.NodeExecutionManager.ExecuteNode(ExecutionNode node, IUnityContainer container, ConcurrentBag`1 stopNodes)

Do you know what would be causing this?

------------------------------
Vanessa Tanner
Manager Optimization Services
Gap Inc Store Labs
San Francisco NM
(505) 462-0455
------------------------------
-------------------------------------------
Original Message:
Sent: 10-29-2019 10:35 AM
From: Steve Caiels
Subject: Monarch Server

Hi Vanessa,

The following should do what you need.

The Table Export from the Classic Model will not start until all the "actions" leading into it have completed. The file path from the Data Prep Export must match the input to the Classic model.

Note the difference between the solid and dotted lines. The dotted lines can almost be considered "properties" of the icons they feed. So the Workspace is a property of the Data Prep Export and the input file and model are properties of the Classic export.

The workflow is shown by the solid line. The first "action" is the Data Prep export. Once that is complete, the next action is the Table Export.

Regards,
Steve.

------------------------------
Steve Caiels
Professional Services
Altair
------------------------------

Original Message:
Sent: 10-24-2019 09:53 AM
From: Vanessa Tanner
Subject: Monarch Server

Hello All,

Looking for a way that I can bring in some data to date prep studios, then input the export into the classic model this way I can have filtered exports on the server. Do I have to set up a two part process? One that imports the data, manipulates it and exports out (Data Prep). Then another automation piece that ingest that export into the classic model to export the filter value summaries? I am having difficulty getting it out of data prep and into the model under the visual process on the server in one piece.

------------------------------
Vanessa Tanner
Manager Optimization Services
Gap Inc Store Labs
San Francisco NM
(505) 462-0455
------------------------------"

Hi Vanessa,

Nothing specific, I'm afraid. But the fact that it is getting to 92% suggests that it is something in the export itself rather than an issue with the input file or model.

It doesn't look like an issue with the 'chain' to me, but it might be worth testing with just the Classic part to be sure. Sometimes, network or virtual drives can be slow to report file status, for example, so that may be causing a strange locking issues on the Data Prep export.

Please check the properties for the table export and make sure everything is complete and correctly defined. For example, was the export initially designed with a filter called "MyData" that has now be renamed to "My_Data". Additionally, if you are using any naming macros, could there be any illegal characters that are not allowed in destination format (file names, Excel sheet names etc).

If you can't find anything, I suggest contacting Altair Support via https://www.datawatch.com/support/ or support@datawatch.com. They should be able to arrange a screen share to investigate further.

Regards,
Steve.

------------------------------
Steve Caiels
Professional Services
Altair
------------------------------
-------------------------------------------
Original Message:
Sent: 10-29-2019 03:51 PM
From: Vanessa Tanner
Subject: Monarch Server

Hello Steve,

Thank you for your reply I tried to set it up this way however now I am facing the following error I get to about 92% of the table export then this appears.

Export failed. No value given for one or more required parameters. Datawatch.Common.Exceptions.DatawatchSdkException: Export failed at DynamicModule.ns.Wrapped_IItemExecutor_39d4340fb0d14de5bb6785758179edd1.Execute(ExecutableItem executableItem) at Datawatch.Services.DataPump.Processing.ProcessDesignerServices.NodeExecutors.CommonNodeExecutor.Execute(ExecutionNode executableItem) at Datawatch.Services.DataPump.Processing.ProcessDesignerServices.NodeExecutors.NodeExecutionManager.Execute(ExecutionNode executionNode, IUnityContainer container) at Datawatch.Services.DataPump.Processing.ProcessDesignerServices.NodeExecutors.NodeExecutionManager.ExecuteNode(ExecutionNode node, IUnityContainer container, ConcurrentBag`1 stopNodes)

Do you know what would be causing this?

------------------------------
Vanessa Tanner
Manager Optimization Services
Gap Inc Store Labs
San Francisco NM
(505) 462-0455
------------------------------

Original Message:
Sent: 10-29-2019 10:35 AM
From: Steve Caiels
Subject: Monarch Server

Hi Vanessa,

The following should do what you need.

------------------------------
Steve Caiels
Professional Services
Altair

Original Message:
Sent: 10-24-2019 09:53 AM
From: Vanessa Tanner
Subject: Monarch Server

Hello All,

Looking for a way that I can bring in some data to date prep studios, then input the export into the classic model this way I can have filtered exports on the server. Do I have to set up a two part process? One that imports the data, manipulates it and exports out (Data Prep). Then another automation piece that ingest that export into the classic model to export the filter value summaries? I am having difficulty getting it out of data prep and into the model under the visual process on the server in one piece.

------------------------------
Vanessa Tanner
Manager Optimization Services
Gap Inc Store Labs
San Francisco NM
(505) 462-0455
------------------------------"

Baba_Majekodunmi_703