Unable to export app

[nnavarrete]

I am having issues exporting my app across instances. I am getting this error message 'Error: Widget - more than one record found with same timestamp'. Could I get help determining what this error message is telling me and how to fix it? Thank you. 6.3.20240724.0

image (5).png

[Johnny Major]

What is the exact version you're exporting from and the exact version you're importing to?

[nnavarrete]

6.3.20240724.0 to 6.3.20240724.0

[sean.lanktree]

When an app, widget, or data source is imported into another instance, we attempt to find a match for each item based on the creation timestamp.

Application

• Table: VVAPPS
• Column: VVCTS

Widget

• Table: VVWDG100
• Column: VVCTS

Data Source

• Table: VVDTA100
• Column: VVCTS

Suppose I have an application that looks like the following:

• Name: “Customers”
• Id: 2000
• Created: 2024-08-09-13:00:00:000000

Widgets

• Name: “Customer List”
• Id: 2100
• Created: 2023-12-31-12:00:00:000000

Data Source

• Name: “Customers”
• Id: 1500
• Created: 2023-06-01-15:00:00:000000

Next, we are going to export/import this application from the DEVELOPMENT instance to the PRODUCTION instance. For each item in the application, we check if it already exists in the PRODUCTION instance by using the timestamp for each object. For example, if we are checking to see if the “Customer List” widget already exists, we would look for a widget record with the same timestamp: “2023-12-31-12:00:00:000000”. If we find a match, we know to overwrite this ID.

In your case, we are finding multiple records with the same timestamp. Suppose we found multiple widget records with the creation timestamp of “2023-12-31-12:00:00:000000”. When this happens, we show an error message because we do not know which widget ID to overwrite.

Theoretically, this condition should not occur, but it is a leftover effect from a previous bug (since fixed) where an object was stamped with the same creation timestamp.

How to fix it:

Let’s use the same example above. On the PRODUCTION instance, look for duplicate values of VVCTS in table VVWDG100. If you find a duplicate, compare that widget record to the one in DEVELOPMENT.

Suppose I found two records with the same timestamp. One of the records is for the “Customer List” widget. I would then look at that same record from the DEVELOPMENT instance and see that its timestamp is “2023-06-01-15:00:00:000000”. On PRODUCTION, I would leave the “Customer List” widget record unchanged but change the other record to “2023-06-01-15:00:00:000001”.

[nnavarrete]

I was able to export my app. Thank you for the informative post.