Monday, December 28, 2015

Caused by: java.sql.SQLRecoverableException: No more data to read from socket at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1200)

Caused by: java.sql.SQLRecoverableException: No more data to read from socket at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1200)

C:\ProgramData\Oracle\Java\javapath;
E:\app\gursingh\product\11.2.0\dbhome_1\bin;
C:\Program Files (x86)\Intel\iCLS Client\;
C:\Program Files\Intel\iCLS Client\;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;
C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x64;
C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;
C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;
C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;
C:\Program Files\Java\jdk1.7.0_65\bin\;C:\Program Files (x86)\MySQL\MySQL Server 5.6\bin;
C:\Program Files\TortoiseGit\bin;C:\Program Files (x86)\Skype\Phone\;
C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;E:\a_installation\SQLServer\110\Tools\Binn\;C:\Program Files\Microsoft SQL Server\110\DTS\Binn\;
E:\a_installation\SQLServer\110\Tools\Binn\ManagementStudio\;
C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\;E:\a_installation\SQLServer\110\DTS\Binn\


I faced this error while using kettle while transformation execution
Steps in transformation

1. Table Input (Get date (data_type - DATE) from some table, this date will pass in next "table input")
2. Table Input (Simple select query with where clause "where coalesce(Created_date,modified_date) > coalesce(to_date(?,'any format'),to_date('any default date','any date format')" )

Above error populate at second step while conversion of date type string,
I have googled it, as a solution i found it is a driver issue, but for me its not a driver issue, it is data-type conversion error.

Solution:
As a solution i have added one more step in transformation:

1. Table Input (Get date (data_type - DATE) from some table, this date will pass in next "table input")
2. "Select values" [in "metadata" tab - change datatype of date to "STRING"]
3. Table Input (Simple select query with where clause "where coalesce(Created_date,modifieddate) > coalesce(to_date(?,'any format'),to_date('any default date','any date format')" )

No comments:

Post a Comment

web stats