Hi Team,
İ try to replicate data from ms sql to oracle with lkm load. But i have error that The TDS protocol stream is not valid.
i can unload the data to the file. so i think i havent got topology problem.
There are the codes and error log at below. Can you help me?
Thank you.
SOURCE CODE
| select | |
| V_LOGİNREPORT.loginDate | as LOGINDATE, |
| V_LOGİNREPORT.GSM | as GSM, |
| V_LOGİNREPORT.ActivationDate | as ACTIVATIONDATE, |
| V_LOGİNREPORT.PlatformType | as PLATFORMTYPE, |
| V_LOGİNREPORT.PlatformVersion | as PLATFORMVERSION, |
| V_LOGİNREPORT.DeviceBrand | as DEVICEBRAND, |
| V_LOGİNREPORT.DeviceModel | as DEVICEMODEL |
| from | MWalletReports.dbo.v_loginReport as V_LOGİNREPORT |
| where | (1=1) |
TARGET CODE
insert into ODI_TEMP.C$_LOGIN_AAKIN2
(
LOGINDATE,
GSM,
ACTIVATIONDATE,
PLATFORMTYPE,
PLATFORMVERSION,
DEVICEBRAND,
DEVICEMODEL
)
values
(
:LOGINDATE,
:GSM,
:ACTIVATIONDATE,
:PLATFORMTYPE,
:PLATFORMVERSION,
:DEVICEBRAND,
:DEVICEMODEL
)
8000 : 08S01 : com.microsoft.sqlserver.jdbc.SQLServerException: The TDS protocol stream is not valid.
com.microsoft.sqlserver.jdbc.SQLServerException: The TDS protocol stream is not valid.
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.throwInvalidTDS(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSReader.throwInvalidTDS(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSReader.skip(Unknown Source)
at com.microsoft.sqlserver.jdbc.ServerDTVImpl.skipValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.DTV.skipValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.Column.skipValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.skipColumns(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.discardCurrentRow(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.close(Unknown Source)
at oracle.odi.runtime.agent.execution.sql.concurrent.FastJDBCRecordSet.close(FastJDBCRecordSet.java:124)
at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:103)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:558)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:724)