Mysql database connection error

I am now gettin this error.
ERROR rendering error page [/control/error], but here is the error text: org.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen [component://common/widget/CommonScreens.xml#GlobalDecorator]: java.lang.IllegalArgumentException: Template location is empty (Template location is empty)

Di you run the install script? it looks to me like you are missing seed data

I just managed to tart it so that it created a mysql database… but when i just try to see some tables they do not have some data. Do i need to reintsall? let me try

Yeah, well, you switched database. Starting it will only check for and create tables, but it doesn’t install the seed data (installation data). So your system is not properly setup. You ran the installer on another database and you will have to do it here again.

yes i managed to install seed data, i am now trying to understand where the requests url go, how the logic is processed and how data are modifiedor querried from the database.

As answered in Scipio structure , it is best to dig into the developer docs for getting a good understanding on the concepts. The documentation was written in such a way, that you can start from top article (architecture) and read until you reach “Events and Actions”. You should always read sub-pages too (in this case the detailed info on controller and Screens, decorators etc.).

Hi, I’m trying to setup the application on AWS and use MySQL RDS. While trying to configure the application, some tables are not created as a result of which the application does not load. Snippet of error log below,

 [java] 2019-09-03 18:02:53,333 |main                 |EntityDataLoader              |E| [loadData]: Error loading XML Resource "file:/usr/local/scipio-erp-master/framework/entityext/data/EntityScheduledServices.xml"; Error was: A transaction error occurred reading data
 [java] org.xml.sax.SAXException: A transaction error occurred reading data
 [java] 	at org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:445) ~[ofbiz-entity.jar:?]
 [java] 	at org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:404) ~[ofbiz-entity.jar:?]
 [java] 	at org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:262) [ofbiz-entity.jar:?]
 [java] 	at org.ofbiz.entityext.data.EntityDataLoadContainer.loadContainer(EntityDataLoadContainer.java:499) [ofbiz-entityext.jar:?]
 [java] 	at org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:246) [ofbiz-entityext.jar:?]
 [java] 	at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:237) [ofbiz-base.jar:?]
 [java] 	at org.ofbiz.base.start.Start.startStartLoaders(Start.java:345) [ofbiz.jar:?]
 [java] 	at org.ofbiz.base.start.Start.start(Start.java:399) [ofbiz.jar:?]
 [java] 	at org.ofbiz.base.start.Start.main(Start.java:138) [ofbiz.jar:?]
 [java] Caused by: org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT APPL_ENUM_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM ENTITY_SYNC_INCLUDE WHERE ENTITY_SYNC_ID=? AND ENTITY_OR_PACKAGE=? (Table 'scipiodb.ENTITY_SYNC_INCLUDE' doesn't exist) (SQL Exception while executing the following:SELECT APPL_ENUM_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM ENTITY_SYNC_INCLUDE WHERE ENTITY_SYNC_ID=? AND ENTITY_OR_PACKAGE=? (Table 'scipiodb.ENTITY_SYNC_INCLUDE' doesn't exist))
 [java] 	at org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1349) ~[ofbiz-entity.jar:?]
 [java] 	at org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:463) ~[ofbiz-entity.jar:?]

Assuming that you have followed the database configuration guide (https://www.scipioerp.com/community/developer/installation-configuration/configuration/#database-configuration)

Have you run the install script?

You can either run: install.sh or ./ant load-demo or ./ant load-extseed to do so. It will create the database and install the datasets for you. The difference here being, that load-extseed installs minimum data and load-demo installs all data, including demo data. For a start, i would recommend to load demo data and then prepare your own “minimum” install datasets for a production system.