smallela さんのグループアクティビティ

cui_default_mwt_onSaveAsCommand failed

smallela — Fri, 19 Feb 2021 07:27:37 GMT

Hi,

On "SaveAs" operation on ECN, getting "The method "cui_default_mwt_onSaveAsCommand" failed." alert message.

Someone please kindly let me know how to proceed.

-MSS

Have difficulty to maintain checkbox in Part BOM Structure grid

smallela — Thu, 21 Jan 2021 14:54:35 GMT

Hi,

I am able to track part HAS_CHANGE_PENDING Boolean value and show as text value under newly created column in Part BOM Structure grid.

But have difficulty to maintain checkbox control instead as text value(0 or 1).

You help will be highly appreciated.

Regards,

SMallela

Ask A Question I

Tue, 12 Jan 2021 13:41:44 GMT

Ask a question in a forum.

ECN columns into My InBasket

smallela — Tue, 12 Jan 2021 13:41:44 GMT

Hi,

I have added ECN's Title and Priority coilumns in all Poly Source item types under MyInBasket item type.

Also have added the column into SQL query type.

While trying to create same properties in InBasket Task, getting following message:

<SOAP-ENV:Envelope xmlns:SOAP-ENV="">schemas.xmlsoap.org/.../"><SOAP-ENV:Body><SOAP-ENV:Fault xmlns:af="">www.aras.com/.../faultcode><faultstring><![CDATA[Invalid column name 'priority'.

Invalid column name 'title'.

Invalid column name 'priority'. in SQL: CREATE VIEW [INBASKET_TASK] AS SELECT COALESCE('321BD822949149C597FD596B1212B85C', NULL) as ITEMTYPE, [WORKFLOW_TASK].assigned_to as assigned_to, [WORKFLOW_TASK].classification as classification, [WORKFLOW_TASK].config_id as config_id, [WORKFLOW_TASK].container as container, [WORKFLOW_TASK].container_type_id as container_type_id, [WORKFLOW_TASK].created_by_id as created_by_id, [WORKFLOW_TASK].created_on as created_on, [WORKFLOW_TASK].css as css, [WORKFLOW_TASK].current_state as current_state, [WORKFLOW_TASK].due_date as due_date, [WORKFLOW_TASK].generation as generation, [WORKFLOW_TASK].icon as icon, [WORKFLOW_TASK].id as id, [WORKFLOW_TASK].instructions as instructions, [WORKFLOW_TASK].is_current as is_current, [WORKFLOW_TASK].is_released as is_released, [WORKFLOW_TASK].item as item, [WORKFLOW_TASK].item_type_id as item_type_id, [WORKFLOW_TASK].keyed_name as keyed_name, [WORKFLOW_TASK].language_code_filter as language_code_filter, [WORKFLOW_TASK].locked_by_id as locked_by_id, [WORKFLOW_TASK].major_rev as major_rev, [WORKFLOW_TASK].managed_by_id as managed_by_id, [WORKFLOW_TASK].minor_rev as minor_rev, [WORKFLOW_TASK].modified_by_id as modified_by_id, [WORKFLOW_TASK].modified_on as modified_on, [WORKFLOW_TASK].my_assignment as my_assignment, [WORKFLOW_TASK].name as name, [WORKFLOW_TASK].new_version as new_version, [WORKFLOW_TASK].not_lockable as not_lockable, [WORKFLOW_TASK].owned_by_id as owned_by_id, [WORKFLOW_TASK].permission_id as permission_id, [WORKFLOW_TASK].priority as priority, [WORKFLOW_TASK].start_date as start_date, [WORKFLOW_TASK].state as state, [WORKFLOW_TASK].status as status, [WORKFLOW_TASK].team_id as team_id, [WORKFLOW_TASK].title as title FROM [WORKFLOW_TASK] UNION ALL SELECT COALESCE('9DC36DF7F0234A3E8CFFE2A20AB78CCE', NULL) as ITEMTYPE, [PROJECT_TASK].assigned_to as assigned_to, [PROJECT_TASK].classification as classification, [PROJECT_TASK].config_id as config_id, [PROJECT_TASK].container as container, [PROJECT_TASK].container_type_id as container_type_id, [PROJECT_TASK].created_by_id as created_by_id, [PROJECT_TASK].created_on as created_on, [PROJECT_TASK].css as css, [PROJECT_TASK].current_state as current_state, [PROJECT_TASK].due_date as due_date, [PROJECT_TASK].generation as generation, [PROJECT_TASK].icon as icon, [PROJECT_TASK].id as id, [PROJECT_TASK].instructions as instructions, [PROJECT_TASK].is_current as is_current, [PROJECT_TASK].is_released as is_released, [PROJECT_TASK].item as item, [PROJECT_TASK].item_type_id as item_type_id, [PROJECT_TASK].keyed_name as keyed_name, [PROJECT_TASK].language_code_filter as language_code_filter, [PROJECT_TASK].locked_by_id as locked_by_id, [PROJECT_TASK].major_rev as major_rev, [PROJECT_TASK].managed_by_id as managed_by_id, [PROJECT_TASK].minor_rev as minor_rev, [PROJECT_TASK].modified_by_id as modified_by_id, [PROJECT_TASK].modified_on as modified_on, [PROJECT_TASK].my_assignment as my_assignment, [PROJECT_TASK].name as name, [PROJECT_TASK].new_version as new_version, [PROJECT_TASK].not_lockable as not_lockable, [PROJECT_TASK].owned_by_id as owned_by_id, [PROJECT_TASK].permission_id as permission_id, [PROJECT_TASK].priority as priority, [PROJECT_TASK].start_date as start_date, [PROJECT_TASK].state as state, [PROJECT_TASK].status as status, [PROJECT_TASK].team_id as team_id, [PROJECT_TASK].title as title FROM [PROJECT_TASK]]]></af:legacy_detail><af:exception message="Invalid column name 'priority'.
Invalid column name 'title'.
Invalid column name 'priority'. in SQL: CREATE VIEW [INBASKET_TASK] AS SELECT COALESCE('321BD822949149C597FD596B1212B85C', NULL) as ITEMTYPE, [WORKFLOW_TASK].assigned_to as assigned_to, [WORKFLOW_TASK].classification as classification, [WORKFLOW_TASK].config_id as config_id, [WORKFLOW_TASK].container as container, [WORKFLOW_TASK].container_type_id as container_type_id, [WORKFLOW_TASK].created_by_id as created_by_id, [WORKFLOW_TASK].created_on as created_on, [WORKFLOW_TASK].css as css, [WORKFLOW_TASK].current_state as current_state, [WORKFLOW_TASK].due_date as due_date, [WORKFLOW_TASK].generation as generation, [WORKFLOW_TASK].icon as icon, [WORKFLOW_TASK].id as id, [WORKFLOW_TASK].instructions as instructions, [WORKFLOW_TASK].is_current as is_current, [WORKFLOW_TASK].is_released as is_released, [WORKFLOW_TASK].item as item, [WORKFLOW_TASK].item_type_id as item_type_id, [WORKFLOW_TASK].keyed_name as keyed_name, [WORKFLOW_TASK].language_code_filter as language_code_filter, [WORKFLOW_TASK].locked_by_id as locked_by_id, [WORKFLOW_TASK].major_rev as major_rev, [WORKFLOW_TASK].managed_by_id as managed_by_id, [WORKFLOW_TASK].minor_rev as minor_rev, [WORKFLOW_TASK].modified_by_id as modified_by_id, [WORKFLOW_TASK].modified_on as modified_on, [WORKFLOW_TASK].my_assignment as my_assignment, [WORKFLOW_TASK].name as name, [WORKFLOW_TASK].new_version as new_version, [WORKFLOW_TASK].not_lockable as not_lockable, [WORKFLOW_TASK].owned_by_id as owned_by_id, [WORKFLOW_TASK].permission_id as permission_id, [WORKFLOW_TASK].priority as priority, [WORKFLOW_TASK].start_date as start_date, [WORKFLOW_TASK].state as state, [WORKFLOW_TASK].status as status, [WORKFLOW_TASK].team_id as team_id, [WORKFLOW_TASK].title as title FROM [WORKFLOW_TASK] UNION ALL SELECT COALESCE('9DC36DF7F0234A3E8CFFE2A20AB78CCE', NULL) as ITEMTYPE, [PROJECT_TASK].assigned_to as assigned_to, [PROJECT_TASK].classification as classification, [PROJECT_TASK].config_id as config_id, [PROJECT_TASK].container as container, [PROJECT_TASK].container_type_id as container_type_id, [PROJECT_TASK].created_by_id as created_by_id, [PROJECT_TASK].created_on as created_on, [PROJECT_TASK].css as css, [PROJECT_TASK].current_state as current_state, [PROJECT_TASK].due_date as due_date, [PROJECT_TASK].generation as generation, [PROJECT_TASK].icon as icon, [PROJECT_TASK].id as id, [PROJECT_TASK].instructions as instructions, [PROJECT_TASK].is_current as is_current, [PROJECT_TASK].is_released as is_released, [PROJECT_TASK].item as item, [PROJECT_TASK].item_type_id as item_type_id, [PROJECT_TASK].keyed_name as keyed_name, [PROJECT_TASK].language_code_filter as language_code_filter, [PROJECT_TASK].locked_by_id as locked_by_id, [PROJECT_TASK].major_rev as major_rev, [PROJECT_TASK].managed_by_id as managed_by_id, [PROJECT_TASK].minor_rev as minor_rev, [PROJECT_TASK].modified_by_id as modified_by_id, [PROJECT_TASK].modified_on as modified_on, [PROJECT_TASK].my_assignment as my_assignment, [PROJECT_TASK].name as name, [PROJECT_TASK].new_version as new_version, [PROJECT_TASK].not_lockable as not_lockable, [PROJECT_TASK].owned_by_id as owned_by_id, [PROJECT_TASK].permission_id as permission_id, [PROJECT_TASK].priority as priority, [PROJECT_TASK].start_date as start_date, [PROJECT_TASK].state as state, [PROJECT_TASK].status as status, [PROJECT_TASK].team_id as team_id, [PROJECT_TASK].title as title FROM [PROJECT_TASK]" type="Aras.Server.Core.InnovatorDatabaseException"><af:innerException message="Invalid column name 'priority'.
Invalid column name 'title'.
Invalid column name 'priority'." type="System.Data.SqlClient.SqlException"/></af:exception></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope>

Please let me know what is missing and need to be done to create and get each ECN’s TITLE and PRIORITY values for each ECN in MyInBasket.

Your help will be highly appreciated!

Configurable InBasket - Error on Save

greglc — Fri, 18 Jan 2019 03:55:14 GMT

My company is using Aras Innovator 11.11.

Following the Aras Innovator 11.0 - Configurable InBasket.pdf to the letter for adding a new column to existing InBasket PolySource ItemTypes (Workflow and Project), I get an error after adding the property to the Inbasket Task (parent) ItemType and clicking save.

I'm adding property called related_eco, Data Type = Item, Data Source = Express ECO.

The error suggests I have an invalid column name, but I can't discern the cause of the error. Has anyone encountered this, or can anyone point out the probably obvious error I've made? Here's the error text (sorry, it's a long error):

Invalid column name 'related_eco'. Invalid column name 'related_eco'. in SQL: CREATE FUNCTION [secured].[INBASKET_TASK] ( @type VARCHAR(32), @identity_list VARCHAR(MAX), @ip_address VARCHAR(32), @cur_user_id CHAR(32), @perms_having_can_get NVARCHAR(MAX) ) RETURNS TABLE AS RETURN ( SELECT [secured].[PROJECT_TASK].assigned_to AS assigned_to, [secured].[PROJECT_TASK].classification AS classification, [secured].[PROJECT_TASK].config_id AS config_id, [secured].[PROJECT_TASK].container AS container, [secured].[PROJECT_TASK].container_type_id AS container_type_id, [secured].[PROJECT_TASK].created_by_id AS created_by_id, [secured].[PROJECT_TASK].created_on AS created_on, [secured].[PROJECT_TASK].css AS css, [secured].[PROJECT_TASK].current_state AS current_state, [secured].[PROJECT_TASK].due_date AS due_date, [secured].[PROJECT_TASK].generation AS generation, [secured].[PROJECT_TASK].icon AS icon, [secured].[PROJECT_TASK].id AS id, [secured].[PROJECT_TASK].instructions AS instructions, [secured].[PROJECT_TASK].is_current AS is_current, [secured].[PROJECT_TASK].is_released AS is_released, [secured].[PROJECT_TASK].item AS item, [secured].[PROJECT_TASK].item_type_id AS item_type_id, [secured].[PROJECT_TASK].keyed_name AS keyed_name, [secured].[PROJECT_TASK].language_code_filter AS language_code_filter, [secured].[PROJECT_TASK].locked_by_id AS locked_by_id, [secured].[PROJECT_TASK].major_rev AS major_rev, [secured].[PROJECT_TASK].managed_by_id AS managed_by_id, [secured].[PROJECT_TASK].minor_rev AS minor_rev, [secured].[PROJECT_TASK].modified_by_id AS modified_by_id, [secured].[PROJECT_TASK].modified_on AS modified_on, [secured].[PROJECT_TASK].my_assignment AS my_assignment, [secured].[PROJECT_TASK].name AS name, [secured].[PROJECT_TASK].new_version AS new_version, [secured].[PROJECT_TASK].not_lockable AS not_lockable, [secured].[PROJECT_TASK].owned_by_id AS owned_by_id, [secured].[PROJECT_TASK].permission_id AS permission_id, [secured].[PROJECT_TASK].related_eco AS related_eco, [secured].[PROJECT_TASK].start_date AS start_date, [secured].[PROJECT_TASK].state AS state, [secured].[PROJECT_TASK].status AS status, [secured].[PROJECT_TASK].team_id AS team_id, COALESCE ('9DC36DF7F0234A3E8CFFE2A20AB78CCE', NULL) AS ITEMTYPE,[secured].[PROJECT_TASK].id_$_permission AS id_$_permission FROM [secured].[PROJECT_TASK](@type, @identity_list, @ip_address, @cur_user_id, @perms_having_can_get) UNION ALL SELECT [secured].[WORKFLOW_TASK].assigned_to AS assigned_to, [secured].[WORKFLOW_TASK].classification AS classification, [secured].[WORKFLOW_TASK].config_id AS config_id, [secured].[WORKFLOW_TASK].container AS container, [secured].[WORKFLOW_TASK].container_type_id AS container_type_id, [secured].[WORKFLOW_TASK].created_by_id AS created_by_id, [secured].[WORKFLOW_TASK].created_on AS created_on, [secured].[WORKFLOW_TASK].css AS css, [secured].[WORKFLOW_TASK].current_state AS current_state, [secured].[WORKFLOW_TASK].due_date AS due_date, [secured].[WORKFLOW_TASK].generation AS generation, [secured].[WORKFLOW_TASK].icon AS icon, [secured].[WORKFLOW_TASK].id AS id, [secured].[WORKFLOW_TASK].instructions AS instructions, [secured].[WORKFLOW_TASK].is_current AS is_current, [secured].[WORKFLOW_TASK].is_released AS is_released, [secured].[WORKFLOW_TASK].item AS item, [secured].[WORKFLOW_TASK].item_type_id AS item_type_id, [secured].[WORKFLOW_TASK].keyed_name AS keyed_name, [secured].[WORKFLOW_TASK].language_code_filter AS language_code_filter, [secured].[WORKFLOW_TASK].locked_by_id AS locked_by_id, [secured].[WORKFLOW_TASK].major_rev AS major_rev, [secured].[WORKFLOW_TASK].managed_by_id AS managed_by_id, [secured].[WORKFLOW_TASK].minor_rev AS minor_rev, [secured].[WORKFLOW_TASK].modified_by_id AS modified_by_id, [secured].[WORKFLOW_TASK].modified_on AS modified_on, [secured].[WORKFLOW_TASK].my_assignment AS my_assignment, [secured].[WORKFLOW_TASK].name AS name, [secured].[WORKFLOW_TASK].new_version AS new_version, [secured].[WORKFLOW_TASK].not_lockable AS not_lockable, [secured].[WORKFLOW_TASK].owned_by_id AS owned_by_id, [secured].[WORKFLOW_TASK].permission_id AS permission_id, [secured].[WORKFLOW_TASK].related_eco AS related_eco, [secured].[WORKFLOW_TASK].start_date AS start_date, [secured].[WORKFLOW_TASK].state AS state, [secured].[WORKFLOW_TASK].status AS status, [secured].[WORKFLOW_TASK].team_id AS team_id, COALESCE ('321BD822949149C597FD596B1212B85C', NULL) AS ITEMTYPE,[secured].[WORKFLOW_TASK].id_$_permission AS id_$_permission FROM [secured].[WORKFLOW_TASK](@type, @identity_list, @ip_address, @cur_user_id, @perms_having_can_get) )

smallela さんの グループ アクティビティ

cui_default_mwt_onSaveAsCommand failed

Have difficulty to maintain checkbox in Part BOM Structure grid

Ask A Question I

ECN columns into My InBasket

Configurable InBasket - Error on Save

smallela さんのグループアクティビティ