In some cases, the registration process of log information for IM-LogicDesigner database output may fail.

 
[Occurrence conditions]
This occurs when a flow with a flow ID size greater than 50 is executed in IM-Logic Designer.

[Cause]
This is because the size of the column "product_resource_id" of the table "imtn_system_log" is defined as 50 even though the flow ID of IM-LogicDesigner can be set up to 100 characters.

[Workaround]
Extend the size of the corresponding table column.
Please execute the following SQL.

・For Oracle Database
  ALTER TABLE imtn_system_log MODIFY(product_resource_id VARCHAR2(100));

・For PostgreSQL
  ALTER TABLE imtn_system_log ALTER COLUMN product_resource_id TYPE VARCHAR(100);

・For Microsoft SQL Server
  ALTER TABLE imtn_system_log ALTER COLUMN product_resource_id NVARCHAR(100);

[Handling method]
SQL will be provided to modify the table definition.

*This issue is scheduled to be fixed in "2024 Spring".
Relationed bug: #36798 IM-LogicDesigner's database output log information registration process may fail.
https://issue.intra-mart.jp/issues/36798

--Target-------------------------------------------------------------------------
iAP/Accel Platform/2023 Autumn(Hollyhock)
--------------------------------------------------------------------------------

FAQID:1316
Was this article helpful?
0 out of 0 found this helpful
Powered by Zendesk