-
Bug
-
Resolution: Done
-
Blocker
-
fuse-7.x-GA
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.
- is caused by
-
TEIID-5816 DDLStringVisitor should exclude dangling foreign keys
- Resolved
- relates to
-
ENTESB-10894 Support Salesforce as source in Data Integration In Syndesis
- Done