[lsc-users] error occurred while applying a parameter map in database sync

rakesh pothugunta rakeshnaidu4u at gmail.com
Tue Aug 13 22:43:29 CEST 2013


Hi,

I am trying to sync the data between two oracle databases and I am getting
the below error. Please find the error file, LSC file and inetorgPerson xml
file. I would greatly appreciate if someone can help me with the issue.

I am using LSC for the first time. I think I missed some configuration.

Error:

The error occurred in
file:////opt/lsc-2.0.2/bin//sql-map-config.d/InetOrgPerson.xml.
--- The error occurred while applying a parameter map.
--- Check the getInetOrgPerson-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

at
com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)
~[ibatis-sqlmap-2.3.4.726.jar:na]
at
com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
~[ibatis-sqlmap-2.3.4.726.jar:na]
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)
~[ibatis-sqlmap-2.3.4.726.jar:na]
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
~[ibatis-sqlmap-2.3.4.726.jar:na]
at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
~[ibatis-sqlmap-2.3.4.726.jar:na]
at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:94)
~[ibatis-sqlmap-2.3.4.726.jar:na]
at
org.lsc.service.AbstractJdbcService.getBean(AbstractJdbcService.java:245)
~[lsc-core-2.0.2.jar:na]
at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:672)
[lsc-core-2.0.2.jar:na]
at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:643)
[lsc-core-2.0.2.jar:na]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[na:1.6.0_33]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[na:1.6.0_33]
at java.lang.Thread.run(Thread.java:662) [na:1.6.0_33]
Caused by: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression



Thanks,
Rakesh.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lsc-project.org/pipermail/lsc-users/attachments/20130813/b1ea6859/attachment-0001.htm>
-------------- next part --------------
Aug 13 16:24:22 - WARN  - Error while looking for a specific entry with id=test1 (com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in file:////opt/lsc-2.0.2/bin//sql-map-config.d/InetOrgPerson.xml.  
--- The error occurred while applying a parameter map.  
--- Check the getInetOrgPerson-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
)
Aug 13 16:24:22 - WARN  - Error while looking for a specific entry with id=test2 (com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in file:////opt/lsc-2.0.2/bin//sql-map-config.d/InetOrgPerson.xml.  
--- The error occurred while applying a parameter map.  
--- Check the getInetOrgPerson-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
)
Aug 13 16:24:22 - DEBUG - com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in file:////opt/lsc-2.0.2/bin//sql-map-config.d/InetOrgPerson.xml.  
--- The error occurred while applying a parameter map.  
--- Check the getInetOrgPerson-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in file:////opt/lsc-2.0.2/bin//sql-map-config.d/InetOrgPerson.xml.  
--- The error occurred while applying a parameter map.  
--- Check the getInetOrgPerson-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

	at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201) ~[ibatis-sqlmap-2.3.4.726.jar:na]
	at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139) ~[ibatis-sqlmap-2.3.4.726.jar:na]
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567) ~[ibatis-sqlmap-2.3.4.726.jar:na]
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541) ~[ibatis-sqlmap-2.3.4.726.jar:na]
	at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) ~[ibatis-sqlmap-2.3.4.726.jar:na]
	at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:94) ~[ibatis-sqlmap-2.3.4.726.jar:na]
	at org.lsc.service.AbstractJdbcService.getBean(AbstractJdbcService.java:245) ~[lsc-core-2.0.2.jar:na]
	at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:672) [lsc-core-2.0.2.jar:na]
	at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:643) [lsc-core-2.0.2.jar:na]
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_33]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_33]
	at java.lang.Thread.run(Thread.java:662) [na:1.6.0_33]
Caused by: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:862) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374) ~[ojdbc6.jar:11.2.0.2.0]
	at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185) ~[ibatis-sqlmap-2.3.4.726.jar:na]
	at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221) ~[ibatis-sqlmap-2.3.4.726.jar:na]
	at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189) ~[ibatis-sqlmap-2.3.4.726.jar:na]
	... 11 common frames omitted
Aug 13 16:24:22 - DEBUG - com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in file:////opt/lsc-2.0.2/bin//sql-map-config.d/InetOrgPerson.xml.  
--- The error occurred while applying a parameter map.  
--- Check the getInetOrgPerson-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in file:////opt/lsc-2.0.2/bin//sql-map-config.d/InetOrgPerson.xml.  
--- The error occurred while applying a parameter map.  
--- Check the getInetOrgPerson-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

	at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201) ~[ibatis-sqlmap-2.3.4.726.jar:na]
	at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139) ~[ibatis-sqlmap-2.3.4.726.jar:na]
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567) ~[ibatis-sqlmap-2.3.4.726.jar:na]
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541) ~[ibatis-sqlmap-2.3.4.726.jar:na]
	at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) ~[ibatis-sqlmap-2.3.4.726.jar:na]
	at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:94) ~[ibatis-sqlmap-2.3.4.726.jar:na]
	at org.lsc.service.AbstractJdbcService.getBean(AbstractJdbcService.java:245) ~[lsc-core-2.0.2.jar:na]
	at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:672) [lsc-core-2.0.2.jar:na]
	at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:643) [lsc-core-2.0.2.jar:na]
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_33]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_33]
	at java.lang.Thread.run(Thread.java:662) [na:1.6.0_33]
Caused by: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:862) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677) ~[ojdbc6.jar:11.2.0.2.0]
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374) ~[ojdbc6.jar:11.2.0.2.0]
	at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185) ~[ibatis-sqlmap-2.3.4.726.jar:na]
	at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221) ~[ibatis-sqlmap-2.3.4.726.jar:na]
	at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189) ~[ibatis-sqlmap-2.3.4.726.jar:na]
	... 11 common frames omitted
Aug 13 16:24:22 - ERROR - Error while synchronizing ID {last_name=test2}: org.lsc.exception.LscServiceException: javax.naming.CommunicationException:   
--- The error occurred in file:////opt/lsc-2.0.2/bin//sql-map-config.d/InetOrgPerson.xml.  
--- The error occurred while applying a parameter map.  
--- Check the getInetOrgPerson-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

Aug 13 16:24:22 - DEBUG - org.lsc.exception.LscServiceException: javax.naming.CommunicationException:   
--- The error occurred in file:////opt/lsc-2.0.2/bin//sql-map-config.d/InetOrgPerson.xml.  
--- The error occurred while applying a parameter map.  
--- Check the getInetOrgPerson-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

org.lsc.exception.LscServiceException: javax.naming.CommunicationException:   
--- The error occurred in file:////opt/lsc-2.0.2/bin//sql-map-config.d/InetOrgPerson.xml.  
--- The error occurred while applying a parameter map.  
--- Check the getInetOrgPerson-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

	at org.lsc.service.AbstractJdbcService.getBean(AbstractJdbcService.java:294) ~[lsc-core-2.0.2.jar:na]
	at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:672) [lsc-core-2.0.2.jar:na]
	at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:643) [lsc-core-2.0.2.jar:na]
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_33]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_33]
	at java.lang.Thread.run(Thread.java:662) [na:1.6.0_33]
Caused by: javax.naming.CommunicationException:   
--- The error occurred in file:////opt/lsc-2.0.2/bin//sql-map-config.d/InetOrgPerson.xml.  
--- The error occurred while applying a parameter map.  
--- Check the getInetOrgPerson-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

	... 6 common frames omitted
Aug 13 16:24:22 - ERROR - Error while synchronizing ID {last_name=test1}: org.lsc.exception.LscServiceException: javax.naming.CommunicationException:   
--- The error occurred in file:////opt/lsc-2.0.2/bin//sql-map-config.d/InetOrgPerson.xml.  
--- The error occurred while applying a parameter map.  
--- Check the getInetOrgPerson-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

Aug 13 16:24:22 - DEBUG - org.lsc.exception.LscServiceException: javax.naming.CommunicationException:   
--- The error occurred in file:////opt/lsc-2.0.2/bin//sql-map-config.d/InetOrgPerson.xml.  
--- The error occurred while applying a parameter map.  
--- Check the getInetOrgPerson-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

org.lsc.exception.LscServiceException: javax.naming.CommunicationException:   
--- The error occurred in file:////opt/lsc-2.0.2/bin//sql-map-config.d/InetOrgPerson.xml.  
--- The error occurred while applying a parameter map.  
--- Check the getInetOrgPerson-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

	at org.lsc.service.AbstractJdbcService.getBean(AbstractJdbcService.java:294) ~[lsc-core-2.0.2.jar:na]
	at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:672) [lsc-core-2.0.2.jar:na]
	at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:643) [lsc-core-2.0.2.jar:na]
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_33]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_33]
	at java.lang.Thread.run(Thread.java:662) [na:1.6.0_33]
Caused by: javax.naming.CommunicationException:   
--- The error occurred in file:////opt/lsc-2.0.2/bin//sql-map-config.d/InetOrgPerson.xml.  
--- The error occurred while applying a parameter map.  
--- Check the getInetOrgPerson-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

	... 6 common frames omitted
Aug 13 16:24:22 - ERROR - All entries: 2, to modify entries: 0, successfully modified entries: 0, errors: 2
-------------- next part --------------
A non-text attachment was scrubbed...
Name: LSC.xml
Type: text/xml
Size: 2674 bytes
Desc: not available
URL: <http://lists.lsc-project.org/pipermail/lsc-users/attachments/20130813/b1ea6859/attachment-0002.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: InetOrgPerson.xml
Type: text/xml
Size: 1953 bytes
Desc: not available
URL: <http://lists.lsc-project.org/pipermail/lsc-users/attachments/20130813/b1ea6859/attachment-0003.bin>


More information about the lsc-users mailing list