Log in to AnswerLog in to Follow
2017-07-05 12-29-36
Carlos Alfaro
mvp_badge
MVP
35Views
4Comments
Solved
[OutSystems UI] Unable to publish Version 2.8.2
Question
Reactive
Forge
outsystems-ui
Reactive icon
OutSystems UI
Forge component by Platform Maintenance
Application Type
Reactive
Platform Version
11.14.1.34396

Hello,

I'm having problems publishing the 2.8.2 version of OutSystemsUI on two different environment versions, both with the same error:

Version 11.13.2.32392

Upgrade Error

ORA-01400: cannot insert NULL into ("OSADMIN_OSNOP9"."OSSYS_ENTITY_RECORD"."DATA_ID")

ORA-06512: at line 1

While executing:

BEGIN INSERT INTO "OSADMIN_OSLT1"."OSSYS_ENTITY_RECORD" ("DATA_ID", "NAME", "SS_KEY", "ENTITY_SS_KEY", "ESPACE_ID", "IS_ACTIVE") VALUES ('', 'Disabled', '48213c15-538b-4222-a3ea-d136e608a57d', '55e54b1a-0efe-4bef-ae10-c2769129634d', 54, 1) ; END;

from file 'UpdateStaticEntityRecords.sql' of module 'OutSystemsUI'.


Version 11.14.1.34445

Upgrade Error

ORA-01400: cannot insert NULL into ("OSADMIN_OSNOP9"."OSSYS_ENTITY_RECORD"."DATA_ID")

ORA-06512: at line 1

While executing:

BEGIN INSERT INTO "OSADMIN_OSNOP9"."OSSYS_ENTITY_RECORD" ("DATA_ID", "NAME", "SS_KEY", "ENTITY_SS_KEY", "ESPACE_ID", "IS_ACTIVE") VALUES ('', 'Disabled', '48213c15-538b-4222-a3ea-d136e608a57d', '55e54b1a-0efe-4bef-ae10-c2769129634d', 28, 1) ; END;

from file 'UpdateStaticEntityRecords.sql' of module 'OutSystemsUI'.


Can you please check what can be happening?

Thank you.

C.Alfaro

0
0
05 Apr
2018-12-26 08-19-36
Gonçalo Martins
Staff
Solution

Hello Carlos. 

A new release is available (2.8.3) and double-checked on several PS versions and both with SQL Server and Oracle databases.
Thank you for your feedback and, if you're able to test it successfully please mark this as solved in order to close the thread and help community members with the same issue.

Cheers,
GM

See solution in context
2
0
05 Apr

Hi Carlos.

What was the previous version of OutSystems UI you had before doing the upgrade?

Cheers,
GM

0
0
05 Apr
2017-07-05 12-29-36
Carlos Alfaro
mvp_badge
MVP

Hello,

On both environments, the previous version was 2.8.1.

Thank you.

C.Alfaro

0
0
05 Apr

Hello Carlos.

I was able to reproduce that scenario and it's an issue on the platform end when dealing with static entities, where we have a different behavior between SQL Server and Oracle.
We'll try to do a hotfix on our end in order to unblock our users since we'll be faster than a platform release.

Cheers,
GM

2
0
05 Apr
2018-12-26 08-19-36
Gonçalo Martins
Staff
Solution

Hello Carlos. 

A new release is available (2.8.3) and double-checked on several PS versions and both with SQL Server and Oracle databases.
Thank you for your feedback and, if you're able to test it successfully please mark this as solved in order to close the thread and help community members with the same issue.

Cheers,
GM

2
0
05 Apr
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.