View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000282 | SymmetricDS | Bug | public | 2010-01-09 10:59 | 2012-06-22 18:45 |
| Reporter | Assigned To | ||||
| Priority | high | ||||
| Status | closed | Resolution | won't fix | ||
| Product Version | 1.7.10 | ||||
| Summary | 0000282: unable to reading batch from server | ||||
| Description | [09.06.10 17:54:27:649 NOVST] 00000024 E UOW=null source=org.jumpmind.symmetric.web.SymmetricServlet class=org.jumpmind.symmetric.web.AbstractServlet method=logException org=null prod=null component=null thread=[WebContainer : 2] Error while processing GET request for externalId: null, node: tmp1-1 at host (ip) java.lang.RuntimeException: 42000Error during SQL: select decode(t."AGREEMENT_ID", null, '', '"'||cast(t."AGREEMENT_ID" as number(30,10))||'"') ||','|| decode(t."WS_ID", null, '', concat(concat('"',replace(replace(t."WS_ID",'\','\\'),'"','\"')),'"')) ||','|| decode(t."REQUEST_ID", null, '', '"'||cast(t."REQUEST_ID" as number(30,10))||'"') ||','|| decode(dbms_lob.getlength(t."DATA"), null, '', '"'||sym_blob2clob(t."DATA")||'"') ||','|| decode(t."PRINT_SHEET_ID", null, '', '"'||cast(t."PRINT_SHEET_ID" as number(30,10))||'"') ||','|| decode(t."EDIT_SHEET_ID", null, '', '"'||cast(t."EDIT_SHEET_ID" as number(30,10))||'"') from AGREEMENT t where t.WS_ID = 'tmp1' at org.jumpmind.symmetric.service.impl.DataExtractorService$1.doInConnection(DataExtractorService.java:272) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:342) at org.jumpmind.symmetric.service.impl.DataExtractorService.writeInitialLoad(DataExtractorService.java:244) at org.jumpmind.symmetric.service.impl.DataExtractorService.writeInitialLoad(DataExtractorService.java:222) at org.jumpmind.symmetric.service.impl.DataExtractorService.extractInitialLoadWithinBatchFor(DataExtractorService.java:217) at org.jumpmind.symmetric.extract.csv.StreamReloadDataCommand.execute(StreamReloadDataCommand.java:52) at org.jumpmind.symmetric.extract.csv.CsvExtractor16.write(CsvExtractor16.java:40) at org.jumpmind.symmetric.service.impl.DataExtractorService$ExtractStreamHandler.dataExtracted(DataExtractorService.java:491) at org.jumpmind.symmetric.service.impl.DataExtractorService$2.doInConnection(DataExtractorService.java:420) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:342) at org.jumpmind.symmetric.service.impl.DataExtractorService.selectEventDataToExtract(DataExtractorService.java:409) at org.jumpmind.symmetric.service.impl.DataExtractorService.databaseExtract(DataExtractorService.java:349) at org.jumpmind.symmetric.service.impl.DataExtractorService.extract(DataExtractorService.java:302) at org.jumpmind.symmetric.transport.handler.PullResourceHandler.pull(PullResourceHandler.java:59) at org.jumpmind.symmetric.web.PullServlet.handlePost(PullServlet.java:66) at org.jumpmind.symmetric.web.PullServlet.handleGet(PullServlet.java:49) at org.jumpmind.symmetric.web.SymmetricServlet.handleGet(SymmetricServlet.java:133) at org.jumpmind.symmetric.web.AbstractServlet.doGet(AbstractServlet.java:98) at javax.servlet.http.HttpServlet.service(HttpServlet.java:718) at javax.servlet.http.HttpServlet.service(HttpServlet.java:831) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1655) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1595) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:104) at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:895) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:932) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:500) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178) at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864) at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:183) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83) at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165) at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1550) Caused by: java.sql.SQLException: ORA-00904: "SYM_BLOB2CLOB": invalid identifier at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:925) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1132) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:977) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3500) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3545) at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1102) at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:723) at org.jumpmind.symmetric.service.impl.DataExtractorService$1.doInConnection(DataExtractorService.java:253) ... 42 more | ||||
| Tags | No tags attached. | ||||
|
|
oracle.xml.patch (1,329 bytes)
Index: oracle.xml
===================================================================
--- oracle.xml (revision 3485)
+++ oracle.xml (working copy)
@@ -80,12 +80,12 @@
</property>
<property name="clobColumnTemplate">
<value>
- <![CDATA[ decode(dbms_lob.getlength($(tableAlias)."$(columnName)"), null, '', '"'||replace(replace($(tableAlias)."$(columnName)",'\','\\'),'"','\"')||'"') ||','||]]>
+ <![CDATA[ case when $(tableAlias)."$(columnName)" is null then null else '"' || replace(replace($(tableAlias)."$(columnName)",'\','\\'),'"','\"') || '"' end ||','||]]>
</value>
</property>
<property name="blobColumnTemplate">
<value>
- <![CDATA[ decode(dbms_lob.getlength($(tableAlias)."$(columnName)"), null, '', '"'||$[sym.sync.table.prefix]_blob2clob($(tableAlias)."$(columnName)")||'"') ||','||]]>
+ <![CDATA[ case when $(tableAlias)."$(columnName)" is null then null else '"' || fn_sym_blob2clob($(tableAlias)."$(columnName)") || '"' end ||','||]]>
</value>
</property>
<property name="numberColumnTemplate">
|
|
|
This sounds like a configuration issue. Does sym_blob2clob exist and is it accessible to the database user? |