Hi, We are getting the following error in one of our environment.

It seems that at some point the DT_MODEL table of this environment was wiped out or the environment was reverted to a previous date but the the primary data source doesn't match that timestamp.

Since you are running Appian 6.6.1 this is what you can do:

1. Create an application and add the data store. Use the check missing dependencies to add the required data types. Do you see the data store is pointing to old CDTs? like MYCDT^1?
2. If not, then export the application and review the export log to determine what CDTs are the problematic ones
3. Delete those CDTs from the Data Management tab and reimport them
4. Update your Data Store via Impact Analysis or manually to point to the new version of the CDT instead of ^1 (DO NOT DELETE ENTITIES NOR THE DATA STORE just use Impact Analysis or manually remap but don't delete anything)
5. See if you can now verify the data store.

If you still can't:

1. Stop the application server
2. Comment out the primary DS in custom.properties

#conf.data.primary.datasource=xxxxxx

3. Start the application server
4. Delete the problematic CDTs again
5. Reimport the CDTs
6. Stop the application server
7. Uncomment the primary DS
8. Start the application server
9. This should have assigned new local and external IDs to these data types. Just remap the data store so it points to the latest version of the CDTs(DO NOT DELETE ENTITIES NOR THE DATA STORE just use Impact Analysis or manually remap but don't delete anything)
10. Validate the data store.

Hi Eduardo,

We have performed the instructions above but when we verified at Step 10, we got this errors:

An error occurred while attempting to verify the data store:

The following types cannot be used, because they do not have a definition in the primary data source: [contactView (id=6194), ...] (APNX-1-4172-000)


Can you advise on what we should do next?

Regards,

Rully

It seems I changed the order of my instructions when I formatting them for the post. Here's the updated list (there's a slight change on when to delete the CDTs)


1 Stop JBoss
2 Comment out the primary data source from custom.properties by adding a # at the beginning of the conf.data.primary.datasource property
3 Start JBoss
4 Create an application with the CDTs
5 Export the application
6 Stop JBoss
7 UNcomment the primary data source from custom.properties by REMOVING the # at the beginning of the conf.data.primary.datasource property
8 Start JBoss
9 Delete these CDTs from the problematic environment
10 Import the application from step 4
11 Select these CDTs and run impact analysis to update any object referencing their deleted version

Hi Eduardo,

We followed the new instructions. But on step 10, "import the application from step 4", we did an inspect before doing the actual import. The inspect gave the following error for each datatype:

datatype {http...}...ailsView "{http...tables/ref/}...ilsView": An error occurred while creating datatype [uuid={http://.../tables/ref/}...ilsView]: An error occurred while trying to save the type information to the primary data source. No types have been imported. Cause: could not init listeners (APNX-1-4050-002) (APNX-1-4071-007)

Can you advise on what we should do next?

Regards,
Subroto

Try the import directly without the inspect.

Hi Eduardo,

I did the import without inspect but it did not work. Still giving the same error messages

An error occurred while trying to save the type information to the primary data source. No types have been imported. Cause: could not init listeners (APNX-1-4050-002) (APNX-1-4071-007)
com.appiancorp.ix.ConsumerException: type=datatype, srcId={ww...di/.../}...itView, dstId=null, cause=com.appiancorp.suiteapi.type.config.xsd.exceptions.XsdImportEcoreSaveException: An error occurred while trying to save the type information to the primary data source. No types have been imported. Cause: could not init listeners (APNX-1-4050-002), object=com.appiancorp.ix.data.DatatypeHaul@ca1b2aa
          at com.appiancorp.ix.ImportConsumer.consume(ImportConsumer.java:32)
          at com.appiancorp.ix.Transport.doTransport(Transport.java:362)
          at com.appiancorp.ix.Transport.transport(Transport.java:299)
          at com.appiancorp.ix.Transport.bind(Transport.java:131)
          at com.appiancorp.ix.Transport.bind(Transport.java:180)
          at com.appiancorp.ix.Transport.transportAll(Transport.java:206)
          at com.appiancorp.ix.TransportDriver.transportAll(TransportDriver.java:37)
          at com.appiancorp.ix.AbstractDriver.runTransport(AbstractDriver.java:68)
          at com.appiancorp.applications.ImportApplicationsAction.runIx(ImportApplicationsAction.java:148)
          at com.appiancorp.applications.ImportApplicationsAction.doImport(ImportApplicationsAction.java:123)
          at com.appiancorp.applications.ImportApplicationsAction.main(ImportApplicationsAction.java:102)
          at com.appiancorp.common.struts.BaseUpdateAction.executeImpl(BaseUpdateAction.java:291)
          at com.appiancorp.common.struts.BaseAction.execute(BaseAction.java:437)
          at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
          at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
          at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
          at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
          at com.appiancorp.ap2.EntryFilter.doFilter(EntryFilter.java:40)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
          at org.apa


Is there anything else that we can do?

Regards,
Subroto

If you keep scrolling down there should be a "Caused by" (not "cause" but "Caused by"), can you paste here the message of eac "Caused by" you see please? just the Caused by line with its message

Hi Eduardo,

These are the four "caused by" messages that seem to repeat for each data type:

Caused by: com.appiancorp.suiteapi.type.config.xsd.exceptions.XsdImportEcoreSaveException: An error occurred while trying to save the type information to the primary data source. No types have been imported. Cause: could not init listeners (APNX-1-4050-002)

Caused by: org.hibernate.HibernateException: could not init listeners

Caused by: org.hibernate.search.SearchException: Unable to initialize directory provider: com.appiancorp.tempo.rdbms.EventFeedEntry

Caused by: org.hibernate.search.SearchException: Unable to create index directory: D:\\appian\\bin\\jboss\\jboss-5.1.0.GA\\bin\\<install_dir>\\_admin\\search-local\\index-primary for index com.appiancorp.tempo.rdbms.EventFeedEntry

Regards,
Subroto

It seems you uncommented more than what was required in custom.properties. At a glance this is an issue with this property

conf.data.primary.datasource.search.index

which kind of makes sense since the prefix matches the one you were supposed to uncomment for the primary data source. My suggestion is to search for the word install_dir and make sure that property is commented out then restart the application server.

Also review carefully what else you uncommented when uncommenting conf.data.primary.datasource it seems this was done through search and replace so there can be other places impacted.

Thank you for your help Eduardo. Your suggestion regarding the custom properties did work. I was able to import the CDTs and am now running impact analysis now. Will keep you informed about the results.