[
https://issues.jboss.org/browse/TEIID-3994?page=com.atlassian.jira.plugin...
]
Steve Tran updated TEIID-3994:
------------------------------
Steps to Reproduce: (was: On a windows machine with SQL Server, create a Linked
Server with ODBC.
INSERT INTO OPENQUERY(testb, 'SELECT * FROM TestVBL.HSI_AGGR_PROC_LK')
VALUES ('TEST 1:18am', cast (getdate() as date))
)
AliasSymbol wrapping AliasSymbol error
--------------------------------------
Key: TEIID-3994
URL:
https://issues.jboss.org/browse/TEIID-3994
Project: Teiid
Issue Type: Bug
Affects Versions: 8.7.1.6_2
Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version
6.4.3,
JBoss Developer Studio 8.1.0GA with Teiid Designer plugin
9.0.3.Final.v20150810-1438-B1157
64-bit Windows 7 environment
Reporter: Steve Tran
Assignee: Steven Hawkins
Priority: Optional
Getting an error when attempting to insert a new row into an virtualized Oracle Table in
JDV.
Here's the query
INSERT INTO OPENQUERY(testb, 'SELECT * FROM TestVBL.HSI_AGGR_PROC_LK')
VALUES ('TEST 1:18am', cast (getdate() as date))
{code}
OLE DB provider "MSDASQL" for linked server "testb" returned message
"Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if
available. No work was done.".
Msg 7344, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "testb" could not
INSERT INTO table "[MSDASQL]" because of column "LK_DT". The user did
not have permission to write to the column.
{code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)