Question

Cannot insert/delete data of (custom) table

  • 25 April 2023
  • 3 replies
  • 89 views

Userlevel 4
Badge +11

 

Hi all,

I created a new table to make the description of task-template can be defined based on language, and have setup the custom metadata.

Table definition is:

CREATE TABLE c_task_template_descr( 
task_template_id NVARCHAR(32) NOT NULL ,
locale_code NVARCHAR(128) NOT NULL ,
ext_description NVARCHAR(256) ,
created_by NVARCHAR(32) ,
created_dttm DATETIME ,
modified_by NVARCHAR(32) ,
modified_dttm DATETIME ,
constraint c_task_template_descr_PK PRIMARY KEY CLUSTERED (task_template_id, locale_code))

Custom metadata - Relation Def:

 

Inserting the data from Task Template screen (custom) returned an error like shown in the screenshot below. 

FYI, the first data I inserted using SQL DML statement, insert.

Using XML message,  

<perform_mass_insert>
  <parameters>
    <select>
    </select>
    <update>
      <update_c_task_template_descr>
        <c_task_template_descr>
          <task_template_id>PM</task_template_id>
          <locale_code>DE-DE</locale_code>
          <ext_description>Testing Description DE-DE</ext_description>
        </c_task_template_descr>
      </update_c_task_template_descr>
    </update>
  </parameters>
  <transaction_size>100</transaction_size>
  <synchronous>Y</synchronous>
</perform_mass_insert>

I got this result:

<perform_mass_insert_result>
<response>0 transactions executed successfull, 1 transactions caused error.</response>
</perform_mass_insert_result>

 

When the “Delete” button is clicked, nothing happens.

 

Did I miss anything in the table configuration?

 

Look forward to your input.

Thanks in advance,

~Juni

 

 

 

 


3 replies

Userlevel 6
Badge +26

Hey @JuniSihombing 

Is the insert works from the UI?

Why are you using <perform_mass_insert>? Try using mass_update instead.

XML Name Syntax should be 

<mass_update_c_task_template_descr>

Try also using <transaction_size>1</transaction_size> instead of <transaction_size>100</transaction_size>

You need to double click the tab in UI designer and add the table name

 

Cheers!

Userlevel 4
Badge +11

Thanks for the response @Shneor Cheshin.

 

Yes, I setup the view-id in the design.

 

I use perform_mass_insert because in the post FSM6 - Mass Insert from XML Hierarchy Select | IFS Community. it is mentioned that baseline mass_update does not support inserts.

 

Userlevel 6
Badge +26

Hi @JuniSihombing 

Sorry. I lost you a bit.

I now understand you are trying to add records from the UI, is that correct?

Did you search the server log? XML log?

Cheers!

Reply