[MAGNOLIA-8222] content app publish fail Created: 09/Nov/21  Updated: 11/Nov/21  Resolved: 11/Nov/21

Status: Closed
Project: Magnolia
Component/s: None
Affects Version/s: 5.7
Fix Version/s: None

Type: Bug Priority: High
Reporter: violayang Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File author_log.png     PNG File publish-yanl.PNG     JPEG File publish_log1.PNG.jpg     PNG File publish_log2.PNG    
Template:
Acceptance criteria:
Empty
Task DoD:
[ ]* Doc/release notes changes? Comment present?
[ ]* Downstream builds green?
[ ]* Solution information and context easily available?
[ ]* Tests
[ ]* FixVersion filled and not yet released
[ ]  Architecture Decision Record (ADR)
Bug DoR:
[ ]* Steps to reproduce, expected, and actual results filled
[ ]* Affected version filled
Date of First Response:

 Description   

Steps to reproduce

  1.  create a content app and build it to a jar
  2.  install the jar in public and author 
  3.  add a new item in the app
  4.  click publish

Expected results

Can public the item by using the "Publish" button in content app

Actual results

Have publish issues.

Author error log:

Public error log:

Workaround

The content app could publish in Dev env, but fail in UAT env. However, if use Jcr browser the item could publish successful.

Development notes

The publish action in yaml

 



 Comments   
Comment by Richard Gange [ 09/Nov/21 ]

Hello viola.yang-

It looks to me that you have a missing table:

That seems to be at the root of the issue.

Are you a customer or partner? If so, can you kindly tell me which one.

Thanks
Rich

Comment by violayang [ 11/Nov/21 ]

Hello Rich,

Thank you for your help! 

We have check the database and find that table PM_PRODUCTS_REFS was missing when the content app install. 

 After I create the table in both public and author instance database, the issue is fix.

Viola

Comment by Richard Gange [ 11/Nov/21 ]

Fantastic. Thanks for letting me know about it. Cheers!

Generated at Mon Feb 12 04:30:44 CET 2024 using Jira 9.4.2#940002-sha1:46d1a51de284217efdcb32434eab47a99af2938b.