[teiid-issues] [JBoss JIRA] Commented: (TEIID-901) NPE encountered when doing an INSERT into SFDC Account table

[Mark Drilling (JIRA)]

    [ https://jira.jboss.org/jira/browse/TEIID-901?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12499149#action_12499149 ] 

Mark Drilling commented on TEIID-901:
-------------------------------------

The failure was from a virtual procedure, following form:

CREATE VIRTUAL PROCEDURE 
BEGIN
		DECLARE String VARIABLES.IDSTR = SELECT Common.Account.Id FROM Common.Account;
		INSERT INTO SFDC.salesforce.Account (SFDC.salesforce.Account.Id, SFDC.salesforce.Account.MasterRecordId, SFDC.salesforce.Account.Name, SFDC.salesforce.Account.Type, SFDC.salesforce.Account.ParentId, SFDC.salesforce.Account.BillingStreet, SFDC.salesforce.Account.BillingCity, SFDC.salesforce.Account.BillingState, SFDC.salesforce.Account.BillingPostalCode, SFDC.salesforce.Account.BillingCountry) VALUES (VARIABLES.IDSTR, '', 'myTest', 'Customer', '', '123 MyStreet', 'MyTown', 'IL', '60922', 'USA') ;
END

> NPE encountered when doing an INSERT into SFDC Account table
> ------------------------------------------------------------
>
>                 Key: TEIID-901
>                 URL: https://jira.jboss.org/jira/browse/TEIID-901
>             Project: Teiid
>          Issue Type: Bug
>          Components: Salesforce Connector
>            Reporter: Mark Drilling
>            Assignee: John Doyle
>
> Attempt to insert record into the SDFC account table failed with the following exception:
> Caused by: java.lang.NullPointerException
> 	at com.metamatrix.connector.salesforce.execution.visitors.InsertVisitor.stripQutes(InsertVisitor.java:64)
> 	at com.metamatrix.connector.salesforce.execution.visitors.InsertVisitor.visit(InsertVisitor.java:44)
> 	at com.metamatrix.connector.salesforce.execution.InsertExecutionImpl.execute(InsertExecutionImpl.java:15)
> 	at com.metamatrix.connector.salesforce.execution.UpdateExecutionParent.execute(UpdateExecutionParent.java:67)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira