Uploaded image for project: 'Red Hat Fuse'
  1. Red Hat Fuse
  2. ENTESB-11700

Error during publishing Salesforce VDB

XMLWordPrintable

    • Fuse 7.5 Sprint 52 - Bug fix

      I have a salesforce connection. I created a Virtualization and into it, i created a view for Account table from salesforce connection.

      I was able to preview data for that view.

      However, when I published the VDB, the result of deploying was Error and in the VDB pod was following error:

      java.lang.IllegalStateException: Failed to deploy the VDB file
      	at org.teiid.spring.autoconfigure.TeiidServer.deployVDB(TeiidServer.java:328) ~[teiid-spring-boot-starter-1.2.0-SNAPSHOT.jar!/:1.2.0-SNAPSHOT]
      	at org.teiid.spring.autoconfigure.TeiidPostProcessor.onApplicationEvent(TeiidPostProcessor.java:150) ~[teiid-spring-boot-starter-1.2.0-SNAPSHOT.jar!/:1.2.0-SNAPSHOT]
      	at org.teiid.spring.autoconfigure.TeiidPostProcessor.onApplicationEvent(TeiidPostProcessor.java:53) ~[teiid-spring-boot-starter-1.2.0-SNAPSHOT.jar!/:1.2.0-SNAPSHOT]
      	at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:172) ~[spring-context-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
      	at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:165) ~[spring-context-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
      	at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:139) ~[spring-context-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
      	at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:402) ~[spring-context-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
      	at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:359) ~[spring-context-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
      	at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:896) ~[spring-context-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
      	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.finishRefresh(ServletWebServerApplicationContext.java:162) ~[spring-boot-2.1.7.RELEASE.jar!/:2.1.7.RELEASE]
      	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:552) ~[spring-context-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
      	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141) ~[spring-boot-2.1.7.RELEASE.jar!/:2.1.7.RELEASE]
      	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:743) [spring-boot-2.1.7.RELEASE.jar!/:2.1.7.RELEASE]
      	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:390) [spring-boot-2.1.7.RELEASE.jar!/:2.1.7.RELEASE]
      	at org.springframework.boot.SpringApplication.run(SpringApplication.java:312) [spring-boot-2.1.7.RELEASE.jar!/:2.1.7.RELEASE]
      	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1214) [spring-boot-2.1.7.RELEASE.jar!/:2.1.7.RELEASE]
      	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1203) [spring-boot-2.1.7.RELEASE.jar!/:2.1.7.RELEASE]
      	at io.integration.Application.main(Application.java:9) [classes!/:na]
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_191]
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_191]
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_191]
      	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_191]
      	at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) [SalesforceVDB-1.0.0.jar:na]
      	at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) [SalesforceVDB-1.0.0.jar:na]
      	at org.springframework.boot.loader.Launcher.launch(Launcher.java:51) [SalesforceVDB-1.0.0.jar:na]
      	at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:52) [SalesforceVDB-1.0.0.jar:na]
      Caused by: org.teiid.deployers.VirtualDatabaseException: TEIID40095 TEIID31092 Foreign Key definition on view SalesforceConnection.Account points to non-existent table DandBCompany on schema SalesforceConnection. Fully qualify the Reference Table name including the schema name.
      	at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:847) ~[teiid-runtime-12.3.0-SNAPSHOT.jar!/:12.3.0-SNAPSHOT]
      	at org.teiid.spring.autoconfigure.TeiidServer.deployVDB(TeiidServer.java:325) ~[teiid-spring-boot-starter-1.2.0-SNAPSHOT.jar!/:1.2.0-SNAPSHOT]
      	... 25 common frames omitted
      

      I have uploaded the whole log to the attachment.

        1. dv-salesforcevdb-1-9k5hg.log
          14 kB
        2. previewVDB.png
          previewVDB.png
          143 kB
        3. VDB.png
          VDB.png
          34 kB

            rhn-engineering-vhalbert Van Halbert (Inactive)
            mkralik@redhat.com Matej Kralik
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: