[OPT-7419] Reports are missing after upgrade from 3.10.x to 3.11.x

Type: Bug Report
Resolution: Fixed
Priority: L3 - Default
Fix Version/s: 3.11.3
Affects Version/s: 3.11.0, 3.11.1, 3.11.2
Component/s: None
Labels:
- SUPPORT
- current_release

Effort:
Not defined

What/Where is the issue ?

After the upgrade to 3.11.0 reports are missing in the UI because their definition sources where updated to have the C8 default tenantId.

Environment: C7/ C8SaaS/ C8SM

Optimize version : 3.11.0
ES version : 7.17.9
OS + Browser version :

Steps to reproduce:

Start Optimize 3.10.4
Create process report (doesn't matter if in- or outside of collection) with a definition source
Create some collections and add some definition sources
Stop Optimize
Alter some data in ES to have "zeebe" datasource
Perform upgrade to 3.11.0
Start Optimize
All reports are gone
collection scopes are misconfigured (default tentant ID for scopes)

Observed behavior:

Reports are gone.

Expected behavior:

Reports are visible after the upgrade, report tenant ID and collection scopes should not have changed after upgrade.

Testing Notes:

This will be fixed with 3.11.3 (so in step 4, perform upgrade to 3.11.3)

Additional Information:

optimize-single-process-report before upgrade:
```
"tenantIds": [ null ]
```
optimize-single-process-report after upgrade
```
"tenantIds": [ "<default>" ]
```
It looks like the upgrade script set the tenantId to the default tenant used in C8.

optimize-collection index after upgrade:

"scope": [
                            {
                                "tenants": [
                                    "<default>"
                                ],
                                "definitionKey": "invoice-assign-approver",
                                "id": "decision:invoice-assign-approver",
                                "definitionType": "decision"
                            },
                            {
                                "tenants": [
                                    "<default>"
                                ],
                                "definitionKey": "invoice",
                                "id": "process:invoice",
                                "definitionType": "process"
                            },
                            {
                                "tenants": [
                                    "<default>"
                                ],
                                "definitionKey": "invoiceClassification",
                                "id": "decision:invoiceClassification",
                                "definitionType": "decision"
                            },
                            {
                                "tenants": [
                                    "<default>"
                                ],
                                "definitionKey": "ReviewInvoice",
                                "id": "process:ReviewInvoice",
                                "definitionType": "process"
                            }
                        ]

This is the controller panel for Smart Panels app

Michal Dytko created issue - 13/Nov/23 3:42 PM

Michal Dytko made changes - 13/Nov/23 3:42 PM

Description

Original: h3. What/Where is the issue ?
      After the upgrade to 3.11.0 reports are missing in the UI.


    h3. Environment: C7/ C8SaaS/ C8SM
        Optimize version : 3.11.0
        ES version : 7.17.9
        OS + Browser version :

    h3. Steps to reproduce:
   # Start Optimize 3.10.4
   # Create process report (doesn't matter if in- or outside of collection)
# Stop Optimize
# Perform upgrade to 3.11.0
# Start Optimize
# All reports are gone


    h3. Observed behavior:
       Reports are gone.


    h3. Expected behavior:
        Reports are visible after the upgrade

    h3. Additional Information:
optimize-single-process-report before upgrade:
{code}
"tenantIds": [
                                    null
                                ]
{code}
optimize-single-process-report after upgrade
{code}
"tenantIds": [
                                    "<default>"
                                ]
{code}

It looks like the upgrade script set the tenantId to the default tenant used in C8.

Below script can be used to mitigate the issue:
{code}
curl --location --request POST 'http://localhost:9200/optimize-single-process-report_v11/_update_by_query?pretty' \
--header 'Content-Type: application/json' \
--data-raw '{
    "script": {
        "source": "for (int i = 0; i < ctx._source.data.definitions.length; i++){ ctx._source.data.definitions[i].tenantIds = [ null ];}",
        "lang": "painless"
    },
     "query": {
        "bool": {
            "must": [
                {
                            "match": {
                                "data.definitions.tenantIds": "<default>"
                            }
                        }


            ]
        }
    }
}'
{code}

New: h3. What/Where is the issue ?
      After the upgrade to 3.11.0 reports are missing in the UI.


    h3. Environment: C7/ C8SaaS/ C8SM
        Optimize version : 3.11.0
        ES version : 7.17.9
        OS + Browser version :

    h3. Steps to reproduce:
   # Start Optimize 3.10.4
   # Create process report (doesn't matter if in- or outside of collection)
# Stop Optimize
# Perform upgrade to 3.11.0
# Start Optimize
# All reports are gone


    h3. Observed behavior:
       Reports are gone.


    h3. Expected behavior:
        Reports are visible after the upgrade

    h3. Additional Information:
optimize-single-process-report before upgrade:
{code}
"tenantIds": [ null ]
{code}
optimize-single-process-report after upgrade
{code}
"tenantIds": [ "<default>" ]
{code}

It looks like the upgrade script set the tenantId to the default tenant used in C8.

Below script can be used to mitigate the issue:
{code}
curl --location --request POST 'http://localhost:9200/optimize-single-process-report_v11/_update_by_query?pretty' \
--header 'Content-Type: application/json' \
--data-raw '{
    "script": {
        "source": "for (int i = 0; i < ctx._source.data.definitions.length; i++){ ctx._source.data.definitions[i].tenantIds = [ null ];}",
        "lang": "painless"
    },
     "query": {
        "bool": {
            "must": [
                {
                            "match": {
                                "data.definitions.tenantIds": "<default>"
                            }
                        }


            ]
        }
    }
}'
{code}

Joshua Windels made changes - 13/Nov/23 10:52 PM

Status

Original: Triage [ 10612 ]

New: In Development [ 10312 ]

Joshua Windels made changes - 13/Nov/23 10:52 PM

Assignee

Original: Joshua Windels [ joshua.windels ]

New: Helene Waechtler [ helene.waechtler ]

Helene Waechtler made changes - 14/Nov/23 9:39 AM

Labels

New: SUPPORT

Helene Waechtler made changes - 14/Nov/23 9:39 AM

Fix Version/s

New: 3.11.3 [ 18692 ]

Helene Waechtler made changes - 14/Nov/23 9:40 AM

Affects Version/s		New: 3.11.2 [ 18690 ]
Affects Version/s		New: 3.11.1 [ 18591 ]
Affects Version/s		New: 3.11.0 [ 18496 ]

Helene Waechtler made changes - 14/Nov/23 10:17 AM

Description

Original: h3. What/Where is the issue ?
      After the upgrade to 3.11.0 reports are missing in the UI.


    h3. Environment: C7/ C8SaaS/ C8SM
        Optimize version : 3.11.0
        ES version : 7.17.9
        OS + Browser version :

    h3. Steps to reproduce:
   # Start Optimize 3.10.4
   # Create process report (doesn't matter if in- or outside of collection)
# Stop Optimize
# Perform upgrade to 3.11.0
# Start Optimize
# All reports are gone


    h3. Observed behavior:
       Reports are gone.


    h3. Expected behavior:
        Reports are visible after the upgrade

    h3. Additional Information:
optimize-single-process-report before upgrade:
{code}
"tenantIds": [ null ]
{code}
optimize-single-process-report after upgrade
{code}
"tenantIds": [ "<default>" ]
{code}

It looks like the upgrade script set the tenantId to the default tenant used in C8.

Below script can be used to mitigate the issue:
{code}
curl --location --request POST 'http://localhost:9200/optimize-single-process-report_v11/_update_by_query?pretty' \
--header 'Content-Type: application/json' \
--data-raw '{
    "script": {
        "source": "for (int i = 0; i < ctx._source.data.definitions.length; i++){ ctx._source.data.definitions[i].tenantIds = [ null ];}",
        "lang": "painless"
    },
     "query": {
        "bool": {
            "must": [
                {
                            "match": {
                                "data.definitions.tenantIds": "<default>"
                            }
                        }


            ]
        }
    }
}'
{code}

New: h3. What/Where is the issue ?

After the upgrade to 3.11.0 reports are missing in the UI.
h3. Environment: C7/ C8SaaS/ C8SM

Optimize version : 3.11.0
ES version : 7.17.9
OS + Browser version :
h3. Steps to reproduce:
# Start Optimize 3.10.4
# Create process report (doesn't matter if in- or outside of collection)
# Stop Optimize
# Perform upgrade to 3.11.0
# Start Optimize
# All reports are gone

h3. Observed behavior:

Reports are gone.
h3. Expected behavior:

Reports are visible after the upgrade

*Testing Notes:*

This will be fixed with 3.11.3 (so in step 4, perform upgrade to 3.11.3)
h3. Additional Information:

optimize-single-process-report before upgrade:
{code:java}
"tenantIds": [ null ]
{code}
optimize-single-process-report after upgrade
{code:java}
"tenantIds": [ "<default>" ]
{code}
It looks like the upgrade script set the tenantId to the default tenant used in C8.

Below script can be used to mitigate the issue:
{code:java}
curl --location --request POST 'http://localhost:9200/optimize-single-process-report_v11/_update_by_query?pretty' \
--header 'Content-Type: application/json' \
--data-raw '{
    "script": {
        "source": "for (int i = 0; i < ctx._source.data.definitions.length; i++){ ctx._source.data.definitions[i].tenantIds = [ null ];}",
        "lang": "painless"
    },
     "query": {
        "bool": {
            "must": [
                {
                            "match": {
                                "data.definitions.tenantIds": "<default>"
                            }
                        }


            ]
        }
    }
}'
{code}

Helene Waechtler made changes - 14/Nov/23 11:37 AM

Status

Original: In Development [ 10312 ]

New: Ready for Testing [ 10008 ]

Michal Dytko made changes - 14/Nov/23 11:42 AM

Description

Original: h3. What/Where is the issue ?

After the upgrade to 3.11.0 reports are missing in the UI.
h3. Environment: C7/ C8SaaS/ C8SM

Optimize version : 3.11.0
ES version : 7.17.9
OS + Browser version :
h3. Steps to reproduce:
# Start Optimize 3.10.4
# Create process report (doesn't matter if in- or outside of collection)
# Stop Optimize
# Perform upgrade to 3.11.0
# Start Optimize
# All reports are gone

h3. Observed behavior:

Reports are gone.
h3. Expected behavior:

Reports are visible after the upgrade

*Testing Notes:*

This will be fixed with 3.11.3 (so in step 4, perform upgrade to 3.11.3)
h3. Additional Information:

optimize-single-process-report before upgrade:
{code:java}
"tenantIds": [ null ]
{code}
optimize-single-process-report after upgrade
{code:java}
"tenantIds": [ "<default>" ]
{code}
It looks like the upgrade script set the tenantId to the default tenant used in C8.

Below script can be used to mitigate the issue:
{code:java}
curl --location --request POST 'http://localhost:9200/optimize-single-process-report_v11/_update_by_query?pretty' \
--header 'Content-Type: application/json' \
--data-raw '{
    "script": {
        "source": "for (int i = 0; i < ctx._source.data.definitions.length; i++){ ctx._source.data.definitions[i].tenantIds = [ null ];}",
        "lang": "painless"
    },
     "query": {
        "bool": {
            "must": [
                {
                            "match": {
                                "data.definitions.tenantIds": "<default>"
                            }
                        }


            ]
        }
    }
}'
{code}

Assignee:: Unassigned

Reporter:: Michal Dytko

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Created:: 13/Nov/23 3:42 PM

Updated:: 15/Nov/23 1:38 PM

Resolved:: 15/Nov/23 1:38 PM

Details

Description

What/Where is the issue ?

Environment: C7/ C8SaaS/ C8SM

Steps to reproduce:

Observed behavior:

Expected behavior:

Additional Information:

mgm-controller-panel

This is the controller panel for Smart Panels app

Attachments

Activity

People

Dates

Salesforce