Hi, When we promote our application from one environment to another,

senthilar over 10 years ago

Hi,

When we promote our application from one environment to another, the Data Store gets created successfully. But the Data Source is not set automatically, though the data source name is same across environments. This also caused the following error message during import:

Problems (1):
dataStore _a-0000d8bc-879d-8000-effe-010000010000_2257 218 "Sales_DataStore": The import of dataStore [id=218 uuid=_a-0000d8ab-879c-8000-affe-010000010000_2257] could not be finalized: The data store “Sales_DataStore” [id=218] was saved but cannot be published: The data source schema does not match the type mappings: Missing table: salescustomerinfo (APNX-1-4178-000) (APNX-1-4071-009)

We had to then manually set the Data Source for the DataStore by choosing from the dropdown.

Is this an issue? How can this be prevented?...

Discussion posts and replies are publicly visible

Parents

0 senthilar over 10 years ago

Eduardo, just few more points:

1) The Data Source name in both environments were same (jdbc/BusinessDS).
2) In the lower environment, we didn't create the tables manually by running a DDL. We only published the Data Store and created tables automatically (including the table mentioned in the error message above).
3) So, we were expecting the application import to automatically publish the Data Store and thereby create the tables.

This being the case, is this error expected?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 senthilar over 10 years ago

Eduardo, just few more points:

1) The Data Source name in both environments were same (jdbc/BusinessDS).
2) In the lower environment, we didn't create the tables manually by running a DDL. We only published the Data Store and created tables automatically (including the table mentioned in the error message above).
3) So, we were expecting the application import to automatically publish the Data Store and thereby create the tables.

This being the case, is this error expected?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data