[JBoss JIRA] (TEIID-3333) Dynamic VDB deployment - JDBCMetadataProcessor NPE
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3333?page=com.atlassian.jira.plugin... ]
Steven Hawkins reassigned TEIID-3333:
-------------------------------------
Fix Version/s: 8.10
Assignee: Steven Hawkins (was: Ramesh Reddy)
The change for TEIID-1478 was not complete. If the referenced key table is not found we are still attempting to create the foreign key and thus the npe.
> Dynamic VDB deployment - JDBCMetadataProcessor NPE
> --------------------------------------------------
>
> Key: TEIID-3333
> URL: https://issues.jboss.org/browse/TEIID-3333
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.7
> Reporter: Mark Drilling
> Assignee: Steven Hawkins
> Fix For: 8.10
>
> Attachments: bad-vdb.xml
>
>
> I am getting NPE in JDBCMetadataProcessor for the attached dynamic VDB deployment in teiid 8.7 (DV61). This VDB uses the DashboardDS H2 source that comes installed with DV61.
> The NPE happens with this specific import property
> <property name="importer.TableNamePattern" value="DASHB_A%"/>
> The table name pattern is valid - there is a table named DASHB_ALLOWED_PANEL.
> If you change the pattern to DASHB_D%, the deployment is successful.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month
[JBoss JIRA] (TEIID-3334) MongoDB: invalid ip address and port number
by Ivan Chan (JIRA)
Ivan Chan created TEIID-3334:
--------------------------------
Summary: MongoDB: invalid ip address and port number
Key: TEIID-3334
URL: https://issues.jboss.org/browse/TEIID-3334
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.9.1
Environment: MongoDB with Teiid 8.9.1
Reporter: Ivan Chan
Assignee: Steven Hawkins
I got invalid IP address/ port number error when I have special character in IP address.
Caused by: java.lang.NumberFormatException: For input string: "jasper@ds041671.mongolab.com:41671"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:492)
at java.lang.Integer.valueOf(Integer.java:582)
at org.teiid.resource.adapter.mongodb.MongoDBManagedConnectionFactory.getServers(MongoDBManagedConnectionFactory.java:129
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month
[JBoss JIRA] (TEIID-3331) Problem with dynamic vdb column metadata - for salesforce source w/import property
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIID-3331?page=com.atlassian.jira.plugin... ]
Mark Drilling commented on TEIID-3331:
--------------------------------------
It looks like the columns are ok - its a problem on my side. Sorry for the confusion. I'll leave this open in case you want to change the display name and description.
> Problem with dynamic vdb column metadata - for salesforce source w/import property
> ----------------------------------------------------------------------------------
>
> Key: TEIID-3331
> URL: https://issues.jboss.org/browse/TEIID-3331
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 8.7
> Reporter: Mark Drilling
> Assignee: Ramesh Reddy
> Attachments: SFVdb-vdb.xml
>
>
> There seems to be a problem with the column metadata for dynamic vdb with salesforce source. Here is my scenario.
> 1) Deploy dynamic vdb w/SF source (attached sample). The VDB sets the 'importer.ModelAuditFields' property to 'true'.
> 2) expose the vdb as a jdbc source, then connect to it.
> 3) get the column metadata for a table using
> connection.getMetaData().getColumns(null, null, fullTableName, null)
> When the vdb has 'importer.ModelAuditFields' = true, some of the columns are missing. Here is a comparison for one of the SF tables
> AccountFeed, (importer.modelAuditFields=false)
> --------------
> Id, ParentId, Type, IsDeleted, CommentCount, LikeCount
> AccountFeed, (importer.modelAuditFields=true)
> --------------
> Id, ParentId, Type, CreatedById, CreatedDate, IsDeleted
> with modelAuditFields=true, the audit fields (CreatedById, CreatedDate) are added, but CommentCount and LikeCount are missing. It seems to clip to the same number of cols as the modelAuditFields=false case.
> Second issue (minor)
> -----------------
> The display name for the property is slightly wrong.
> line 75 of SalesForceExecutionFactory is 'Audit Model Fields' - it should be 'Model Audit Fields'.
> line 362 of SalesForceMetadataProcessor - same thing. also suggest changing the description to something like 'Determines if the salesforce audit fields are modeled'
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month
[JBoss JIRA] (TEIID-3332) Add import property to limit salesforce tables
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3332?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3332:
----------------------------------
Fix Version/s: 8.11
> Add import property to limit salesforce tables
> ----------------------------------------------
>
> Key: TEIID-3332
> URL: https://issues.jboss.org/browse/TEIID-3332
> Project: Teiid
> Issue Type: Enhancement
> Components: Salesforce Connector
> Affects Versions: 8.7
> Reporter: Mark Drilling
> Assignee: Ramesh Reddy
> Fix For: 8.11
>
>
> It would be nice to have an import property for salesforce model in a dynamic vdb, so that the tables imported could be filtered. currently there is a 'modelAuditFields' property. I'm suggesting a property to specify the table name pattern, so that I can limit the tables to a subset.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month
[JBoss JIRA] (TEIID-3331) Problem with dynamic vdb column metadata - for salesforce source w/import property
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3331?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3331:
---------------------------------------
I don't see the same thing as you with master. What sf api level are you using? I see AccountFeed without the audit option:
{code}
CREATE FOREIGN TABLE AccountFeed (
Id string(18) NOT NULL AUTO_INCREMENT OPTIONS (NAMEINSOURCE 'Id', NATIVE_TYPE 'id', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'true'),
ParentId string(18) OPTIONS (NAMEINSOURCE 'ParentId', NATIVE_TYPE 'reference', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
Type string(40) OPTIONS (NAMEINSOURCE 'Type', NATIVE_TYPE 'restrictedpicklist', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false', "teiid_sf:Picklist Values" 'TrackedChange,UserStatus,TextPost,AdvancedTextPost,LinkPost,ContentPost,PollPost,RypplePost,ProfileSkillPost,DashboardComponentSnapshot,ApprovalPost,CaseCommentPost,ReplyPost,EmailMessageEvent,CallLogPost,ChangeStatusPost,AttachArticleEvent,MilestoneEvent,ActivityEvent,ChatTranscriptPost,CollaborationGroupCreated,CollaborationGroupUnarchived,SocialPost,QuestionPost,FacebookPost,BasicTemplateFeedItem,CreateRecordEvent,CanvasPost,AnnouncementPost'),
IsDeleted boolean OPTIONS (NAMEINSOURCE 'IsDeleted', NATIVE_TYPE '_boolean', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'true'),
CommentCount integer OPTIONS (NAMEINSOURCE 'CommentCount', NATIVE_TYPE '_int', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
LikeCount integer OPTIONS (NAMEINSOURCE 'LikeCount', NATIVE_TYPE '_int', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
Title string(255) OPTIONS (NAMEINSOURCE 'Title', NATIVE_TYPE 'string', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
Body string(5000) OPTIONS (NAMEINSOURCE 'Body', SEARCHABLE 'Unsearchable', NATIVE_TYPE 'textarea', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
LinkUrl string(1000) OPTIONS (NAMEINSOURCE 'LinkUrl', NATIVE_TYPE 'url', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
RelatedRecordId string(18) OPTIONS (NAMEINSOURCE 'RelatedRecordId', NATIVE_TYPE 'reference', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
ContentData blob OPTIONS (NAMEINSOURCE 'ContentData', NATIVE_TYPE 'base64', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
ContentFileName string(255) OPTIONS (NAMEINSOURCE 'ContentFileName', NATIVE_TYPE 'string', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
ContentDescription string(1000) OPTIONS (NAMEINSOURCE 'ContentDescription', SEARCHABLE 'Unsearchable', NATIVE_TYPE 'textarea', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
ContentType string(120) OPTIONS (NAMEINSOURCE 'ContentType', NATIVE_TYPE 'string', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
ContentSize integer OPTIONS (NAMEINSOURCE 'ContentSize', NATIVE_TYPE '_int', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
InsertedById string(18) OPTIONS (NAMEINSOURCE 'InsertedById', NATIVE_TYPE 'reference', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
CONSTRAINT Id_PK PRIMARY KEY(Id),
CONSTRAINT FK_Account_ParentId FOREIGN KEY(ParentId) REFERENCES Account (Id) OPTIONS (NAMEINSOURCE 'Feeds')
) OPTIONS (NAMEINSOURCE 'AccountFeed', "teiid_sf:Custom" 'false', "teiid_sf:Supports Create" 'false', "teiid_sf:Supports Delete" 'true', "teiid_sf:Supports Merge" 'false', "teiid_sf:Supports Query" 'true', "teiid_sf:Supports Replicate" 'true', "teiid_sf:Supports Retrieve" 'true', "teiid_sf:Supports Search" 'false');
{code}
AccountFeed with the audit option:
{code}
CREATE FOREIGN TABLE AccountFeed (
Id string(18) NOT NULL AUTO_INCREMENT OPTIONS (NAMEINSOURCE 'Id', NATIVE_TYPE 'id', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'true'),
ParentId string(18) OPTIONS (NAMEINSOURCE 'ParentId', NATIVE_TYPE 'reference', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
Type string(40) OPTIONS (NAMEINSOURCE 'Type', NATIVE_TYPE 'restrictedpicklist', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false', "teiid_sf:Picklist Values" 'TrackedChange,UserStatus,TextPost,AdvancedTextPost,LinkPost,ContentPost,PollPost,RypplePost,ProfileSkillPost,DashboardComponentSnapshot,ApprovalPost,CaseCommentPost,ReplyPost,EmailMessageEvent,CallLogPost,ChangeStatusPost,AttachArticleEvent,MilestoneEvent,ActivityEvent,ChatTranscriptPost,CollaborationGroupCreated,CollaborationGroupUnarchived,SocialPost,QuestionPost,FacebookPost,BasicTemplateFeedItem,CreateRecordEvent,CanvasPost,AnnouncementPost'),
CreatedById string(18) OPTIONS (NAMEINSOURCE 'CreatedById', NATIVE_TYPE 'reference', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'true'),
CreatedDate timestamp OPTIONS (NAMEINSOURCE 'CreatedDate', NATIVE_TYPE 'datetime', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'true'),
IsDeleted boolean OPTIONS (NAMEINSOURCE 'IsDeleted', NATIVE_TYPE '_boolean', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'true'),
LastModifiedDate timestamp OPTIONS (NAMEINSOURCE 'LastModifiedDate', NATIVE_TYPE 'datetime', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'true'),
SystemModstamp timestamp OPTIONS (NAMEINSOURCE 'SystemModstamp', NATIVE_TYPE 'datetime', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'true'),
CommentCount integer OPTIONS (NAMEINSOURCE 'CommentCount', NATIVE_TYPE '_int', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
LikeCount integer OPTIONS (NAMEINSOURCE 'LikeCount', NATIVE_TYPE '_int', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
Title string(255) OPTIONS (NAMEINSOURCE 'Title', NATIVE_TYPE 'string', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
Body string(5000) OPTIONS (NAMEINSOURCE 'Body', SEARCHABLE 'Unsearchable', NATIVE_TYPE 'textarea', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
LinkUrl string(1000) OPTIONS (NAMEINSOURCE 'LinkUrl', NATIVE_TYPE 'url', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
RelatedRecordId string(18) OPTIONS (NAMEINSOURCE 'RelatedRecordId', NATIVE_TYPE 'reference', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
ContentData blob OPTIONS (NAMEINSOURCE 'ContentData', NATIVE_TYPE 'base64', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
ContentFileName string(255) OPTIONS (NAMEINSOURCE 'ContentFileName', NATIVE_TYPE 'string', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
ContentDescription string(1000) OPTIONS (NAMEINSOURCE 'ContentDescription', SEARCHABLE 'Unsearchable', NATIVE_TYPE 'textarea', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
ContentType string(120) OPTIONS (NAMEINSOURCE 'ContentType', NATIVE_TYPE 'string', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
ContentSize integer OPTIONS (NAMEINSOURCE 'ContentSize', NATIVE_TYPE '_int', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
InsertedById string(18) OPTIONS (NAMEINSOURCE 'InsertedById', NATIVE_TYPE 'reference', "teiid_sf:calculated" 'false', "teiid_sf:Custom" 'false', "teiid_sf:Defaulted on Create" 'false'),
CONSTRAINT Id_PK PRIMARY KEY(Id),
CONSTRAINT FK_Account_ParentId FOREIGN KEY(ParentId) REFERENCES Account (Id) OPTIONS (NAMEINSOURCE 'Feeds')
) OPTIONS (NAMEINSOURCE 'AccountFeed', "teiid_sf:Custom" 'false', "teiid_sf:Supports Create" 'false', "teiid_sf:Supports Delete" 'true', "teiid_sf:Supports Merge" 'false', "teiid_sf:Supports Query" 'true', "teiid_sf:Supports Replicate" 'true', "teiid_sf:Supports Retrieve" 'true', "teiid_sf:Supports Search" 'false');
{code}
And the DatabaseMetaData reflects that. So you'll want to see if this is specific to older versions or if you are seeing something else.
On the display names, yes those do seem like they should be different.
> Problem with dynamic vdb column metadata - for salesforce source w/import property
> ----------------------------------------------------------------------------------
>
> Key: TEIID-3331
> URL: https://issues.jboss.org/browse/TEIID-3331
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 8.7
> Reporter: Mark Drilling
> Assignee: Ramesh Reddy
> Attachments: SFVdb-vdb.xml
>
>
> There seems to be a problem with the column metadata for dynamic vdb with salesforce source. Here is my scenario.
> 1) Deploy dynamic vdb w/SF source (attached sample). The VDB sets the 'importer.ModelAuditFields' property to 'true'.
> 2) expose the vdb as a jdbc source, then connect to it.
> 3) get the column metadata for a table using
> connection.getMetaData().getColumns(null, null, fullTableName, null)
> When the vdb has 'importer.ModelAuditFields' = true, some of the columns are missing. Here is a comparison for one of the SF tables
> AccountFeed, (importer.modelAuditFields=false)
> --------------
> Id, ParentId, Type, IsDeleted, CommentCount, LikeCount
> AccountFeed, (importer.modelAuditFields=true)
> --------------
> Id, ParentId, Type, CreatedById, CreatedDate, IsDeleted
> with modelAuditFields=true, the audit fields (CreatedById, CreatedDate) are added, but CommentCount and LikeCount are missing. It seems to clip to the same number of cols as the modelAuditFields=false case.
> Second issue (minor)
> -----------------
> The display name for the property is slightly wrong.
> line 75 of SalesForceExecutionFactory is 'Audit Model Fields' - it should be 'Model Audit Fields'.
> line 362 of SalesForceMetadataProcessor - same thing. also suggest changing the description to something like 'Determines if the salesforce audit fields are modeled'
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month
[JBoss JIRA] (TEIID-3333) Dynamic VDB deployment - JDBCMetadataProcessor NPE
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIID-3333?page=com.atlassian.jira.plugin... ]
Mark Drilling commented on TEIID-3333:
--------------------------------------
sorry, forgot to attach...
{noformat}
16:19:56,950 WARN [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50036 VDB SvcSourceVdb_DashboardDS.1 model "DashboardDS" metadata failed to load. Reason:java.lang.NullPointerException: java.lang.NullPointerException
at org.teiid.translator.jdbc.JDBCMetdataProcessor$TableInfo.access$000(JDBCMetdataProcessor.java:47)
at org.teiid.translator.jdbc.JDBCMetdataProcessor.getForeignKeys(JDBCMetdataProcessor.java:499)
at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:134)
at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:309)
at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:57)
at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:73) [teiid-engine-8.7.1.redhat-6.jar:8.7.1.redhat-6]
at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.7.1.redhat-6.jar:8.7.1.redhat-6]
at org.teiid.jboss.VDBService$6.run(VDBService.java:395) [teiid-jboss-integration-8.7.1.redhat-6.jar:8.7.1.redhat-6]
at org.teiid.jboss.VDBService$7.run(VDBService.java:442) [teiid-jboss-integration-8.7.1.redhat-6.jar:8.7.1.redhat-6]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_45]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_45]
at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_45]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
{noformat}
> Dynamic VDB deployment - JDBCMetadataProcessor NPE
> --------------------------------------------------
>
> Key: TEIID-3333
> URL: https://issues.jboss.org/browse/TEIID-3333
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.7
> Reporter: Mark Drilling
> Assignee: Ramesh Reddy
> Attachments: bad-vdb.xml
>
>
> I am getting NPE in JDBCMetadataProcessor for the attached dynamic VDB deployment in teiid 8.7 (DV61). This VDB uses the DashboardDS H2 source that comes installed with DV61.
> The NPE happens with this specific import property
> <property name="importer.TableNamePattern" value="DASHB_A%"/>
> The table name pattern is valid - there is a table named DASHB_ALLOWED_PANEL.
> If you change the pattern to DASHB_D%, the deployment is successful.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month
[JBoss JIRA] (TEIID-3333) Dynamic VDB deployment - JDBCMetadataProcessor NPE
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3333?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3333:
---------------------------------------
What is the stacktrace?
> Dynamic VDB deployment - JDBCMetadataProcessor NPE
> --------------------------------------------------
>
> Key: TEIID-3333
> URL: https://issues.jboss.org/browse/TEIID-3333
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.7
> Reporter: Mark Drilling
> Assignee: Ramesh Reddy
> Attachments: bad-vdb.xml
>
>
> I am getting NPE in JDBCMetadataProcessor for the attached dynamic VDB deployment in teiid 8.7 (DV61). This VDB uses the DashboardDS H2 source that comes installed with DV61.
> The NPE happens with this specific import property
> <property name="importer.TableNamePattern" value="DASHB_A%"/>
> The table name pattern is valid - there is a table named DASHB_ALLOWED_PANEL.
> If you change the pattern to DASHB_D%, the deployment is successful.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month
[JBoss JIRA] (TEIID-3333) Dynamic VDB deployment - JDBCMetadataProcessor NPE
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIID-3333?page=com.atlassian.jira.plugin... ]
Mark Drilling updated TEIID-3333:
---------------------------------
Attachment: bad-vdb.xml
> Dynamic VDB deployment - JDBCMetadataProcessor NPE
> --------------------------------------------------
>
> Key: TEIID-3333
> URL: https://issues.jboss.org/browse/TEIID-3333
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.7
> Reporter: Mark Drilling
> Assignee: Ramesh Reddy
> Attachments: bad-vdb.xml
>
>
> I am getting NPE in JDBCMetadataProcessor for the attached dynamic VDB deployment in teiid 8.7 (DV61). This VDB uses the DashboardDS H2 source that comes installed with DV61.
> The NPE happens with this specific import property
> <property name="importer.TableNamePattern" value="DASHB_A%"/>
> The table name pattern is valid - there is a table named DASHB_ALLOWED_PANEL.
> If you change the pattern to DASHB_D%, the deployment is successful.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month
[JBoss JIRA] (TEIID-3333) Dynamic VDB deployment - JDBCMetadataProcessor NPE
by Mark Drilling (JIRA)
Mark Drilling created TEIID-3333:
------------------------------------
Summary: Dynamic VDB deployment - JDBCMetadataProcessor NPE
Key: TEIID-3333
URL: https://issues.jboss.org/browse/TEIID-3333
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Affects Versions: 8.7
Reporter: Mark Drilling
Assignee: Ramesh Reddy
I am getting NPE in JDBCMetadataProcessor for the attached dynamic VDB deployment in teiid 8.7 (DV61). This VDB uses the DashboardDS H2 source that comes installed with DV61.
The NPE happens with this specific import property
<property name="importer.TableNamePattern" value="DASHB_A%"/>
The table name pattern is valid - there is a table named DASHB_ALLOWED_PANEL.
If you change the pattern to DASHB_D%, the deployment is successful.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month
[JBoss JIRA] (TEIID-3332) Add import property to limit salesforce tables
by Mark Drilling (JIRA)
Mark Drilling created TEIID-3332:
------------------------------------
Summary: Add import property to limit salesforce tables
Key: TEIID-3332
URL: https://issues.jboss.org/browse/TEIID-3332
Project: Teiid
Issue Type: Enhancement
Components: Salesforce Connector
Affects Versions: 8.7
Reporter: Mark Drilling
Assignee: Ramesh Reddy
It would be nice to have an import property for salesforce model in a dynamic vdb, so that the tables imported could be filtered. currently there is a 'modelAuditFields' property. I'm suggesting a property to specify the table name pattern, so that I can limit the tables to a subset.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month