[
https://issues.jboss.org/browse/TEIIDDES-2447?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-2447:
----------------------------------------
Upgraded jars via TEIIDDES-2580. Tested Import Teiid DDL file with the following content
and the pick-list values seemed to be in order.
{code}
CREATE FOREIGN TABLE FlintStones (
RejectionReason__c string(255) OPTIONS (NATIVE_TYPE 'picklist',
"teiid_sf:calculated" 'false', "teiid_sf:Custom"
'true', "teiid_sf:Defaulted on Create" 'false',
"teiid_sf:Picklist Values" '0.00 Amount not approved,Backdate Subsc
Start-date,Billing/Shipping Info Missing,Billing Account Number Invalid,Billing Acct/Info
Incorrect/Missing,Billing Address Incorrect,Billing Address Missing,Contract
Incorrect/Missing/Unsigned,Contract Missing/Not Signed,Contract Numbers Incorrect,Contract
Numbers Missing,Co-Terms Info Incorrect/Missing,Credit Card Declined,Credit
Related/Payment Terms Issues,Credit Status/Payment Terms Issues,Customer Hold or Delivery
Delay,Cut-Off Time Exceeded,Description Missing,Discount Not Approved,Duplicate Order,EU
Login Incorrect/Missing,Finance Approval Required,Handwritten Change Not
Acceptable,Incorrect Account Classification,Incorrect SKUs,Invalid RH Entitlement
Login,Legal/BD Review & Approval,Legal Agreement not attached / Missing,Legal
Approval,Legal Approval Required,Legal Entity Not Correct,Login/Acct #
Invalid/Missing,Missing Pages,Missing Reference to Existing Agreement,Missing
Signatures,Missing SKUs,New Party / Account Request,No PO Letter needs Approval,No PO
Letter Required,Other,Payment Terms Missing,Payment Terms Not Approved,PO/Credit Card Info
Incorrect/Missing,PO Missing,PO not attached / missing,Pricing Incorrect,Product/Discount
Approval Required,Qty/Price/Products Not Equal,Renewal Dates are Incorrect/Missing,Renewal
Info/Start Date Needed,Renewal Information Incorrect/Missing,Sales Mgmt or PM Approval
Required,Shipping Address Incorrect,Shipping Address Missing,Shipping Info
Incorrect/Missing,SKU/Qty/Currency/Price Incorrect,SKU Qty/Price/Desc Issue,Start/End Date
Missing,Start Date Over 14 Days Old,Subsc Dates/Term Issue,Tax Info
Missing/Incorrect,Unclear - Auto entitlement Vs Keys,VAT # Missing/Incorrect,VAT number
missing/incorrect,Waiting Saba # or CM# or Others'' Info,Wrong Billing Acct#,Wrong
Currency'),
OMComments__c string(255) OPTIONS (SEARCHABLE 'Unsearchable', NATIVE_TYPE
'textarea', "teiid_sf:calculated" 'false',
"teiid_sf:Custom" 'true', "teiid_sf:Defaulted on Create"
'false')
);
{code}
Failed to import SalesForce Metadata
------------------------------------
Key: TEIIDDES-2447
URL:
https://issues.jboss.org/browse/TEIIDDES-2447
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Reporter: Ramesh Reddy
Assignee: Barry LaFond
Priority: Blocker
Fix For: 9.0.3
Attachments: sfddl (1).ddl
Using the Teiid Connection import, the attached DDL has been retrived from salesforce
instance. However Designer fails to import it, and gives NO clue as to what is wrong.
1) The DDL should be successfully imported
2) When there is something wrong that Designer does not understand it needs to give a
meaningful error, as per the location of the file and context
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)