topic FTR NullPointerException: Source must not be null in Alfresco Archive

FTR NullPointerException: Source must not be null

opyate — Tue, 14 Feb 2012 11:43:14 GMT

Hi,I've installed alfresco-enterprise-file-transfer-receiver-4.0.0.zip and started up the FTR (receiver).Now we're trying to transfer a folder (type cm:folder) to a remote server (same one on which FTR is running).The JAR is throwing the following exceptions:INFO: Starting ProtocolHandler ["http-bio

Re: FTR NullPointerException: Source must not be null

amandaluniz_z — Tue, 14 Feb 2012 17:35:28 GMT

Adding more info,

When removing the node and retrying the transfer, now the error getting is the following:


17:18:10,041 INFO  [org.alfresco.repo.transfer.LoggingTransferProgressMonitorImpl] Transfer Log (workspace://SpaceStore/7babe439-4f68-463c-aef7-ee9d3347991e): Status update: COMMIT_REQUESTED
17:18:10,053 INFO  [org.alfresco.repo.transfer.LoggingTransferProgressMonitorImpl] Transfer Log (workspace://SpaceStore/7babe439-4f68-463c-aef7-ee9d3347991e): Status update: COMMITTING
17:18:10,448 INFO  [org.alfresco.repo.transfer.LoggingTransferProgressMonitorImpl] Transfer Log (workspace://SpaceStore/7babe439-4f68-463c-aef7-ee9d3347991e): Error processing commit
org.springframework.dao.DataIntegrityViolationException: Error setting null parameter.  Most JDBC drivers require that the JdbcType must be specified for all nullable parameters. Cause: java.sql.SQLDataException: An attempt was made to get a data valu
e of type 'VARCHAR' from a data value of type 'OTHER'.
; SQL []; An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'OTHER'.; nested exception is java.sql.SQLDataException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'OTHER'.
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)
        at $Proxy4.insert(Unknown Source)
        at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:231)
        at org.alfresco.repo.transfer.fsr.FileTransferInfoDAOImpl.createFileTransferInfo(FileTransferInfoDAOImpl.java:64)
        at org.alfresco.repo.transfer.fsr.DbHelperImpl$5.execute(DbHelperImpl.java:131)
        at org.alfresco.repo.transfer.fsr.DbHelperImpl$5.execute(DbHelperImpl.java:128)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
        at org.alfresco.repo.transfer.fsr.DbHelperImpl.createNodeInDB(DbHelperImpl.java:127)
        at org.alfresco.repo.transfer.fsr.ManifestProcessorImpl.startManifest(ManifestProcessorImpl.java:127)
        at org.alfresco.repo.transfer.AbstractManifestProcessorBase.startTransferManifest(AbstractManifestProcessorBase.java:131)
        at org.alfresco.repo.transfer.manifest.XMLTransferManifestReader.startDocument(XMLTransferManifestReader.java:92)
        at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startDocument(AbstractSAXParser.java:284)
        at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.startDocument(XMLDTDValidator.java:663)
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.startEntity(XMLDocumentScannerImpl.java:588)
        at com.sun.org.apache.xerces.internal.impl.XMLVersionDetector.startDocumentParsing(XMLVersionDetector.java:172)
        at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:786)
        at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)
        at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:119)
        at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)
        at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)
        at javax.xml.parsers.SAXParser.parse(SAXParser.java:395)
        at javax.xml.parsers.SAXParser.parse(SAXParser.java:331)
        at org.alfresco.repo.transfer.fsr.FileTransferReceiver.commit(FileTransferReceiver.java:177)
        at org.alfresco.repo.transfer.fsr.FileTransferReceiver$1.run(FileTransferReceiver.java:247)
        at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLDataException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'OTHER'.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.dataTypeConversion(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setNull(Unknown Source)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108)
        at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:15)
        at org.apache.ibatis.executor.parameter.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:73)
        at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:61)
        at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:43)
        at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:56)
        at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:28)
        at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:87)
        at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:46)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:118)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:107)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:338)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: FTR NullPointerException: Source must not be null

lakk99 — Wed, 21 Mar 2012 03:41:09 GMT

Hi ,
Can you able to resolve this issue.

thanks,

Re: FTR NullPointerException: Source must not be null

roy_thompson — Wed, 21 Mar 2012 10:29:12 GMT

I am seeing the same thing:
"An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'OTHER'." in the FTR logs and no transfer completes.

Did you get anywhere with this?

Re: FTR NullPointerException: Source must not be null

mrogers — Wed, 21 Mar 2012 10:55:54 GMT

These look like bugs that should be raised in JIRA.

Re: FTR NullPointerException: Source must not be null

roy_thompson — Wed, 21 Mar 2012 17:48:17 GMT

Turning on debug and poking through the logs it may be a problem with a null value for root node reference …

17:32:25,996 DEBUG [org.alfresco.repo.transfer.fsr.FileTransferReceiver] Processing manifest file:c:\alfresco-ftr\ftr-staging\b340ef2a-4bda-455a-97a9-e1dd3a6d7f04\snapshot.xml
17:32:26,009 DEBUG [org.alfresco.repo.transfer.fsr.ManifestProcessorImpl] Checking that root node and corresponding folder exist: null c:/alfresco-ftr/ftr-root
…

17:32:26,021 DEBUG [java.sql.PreparedStatement] ==> Executing: select * from alf_file_transfer_info where nodeRef = ?
17:32:26,021 DEBUG [java.sql.PreparedStatement] ==> Parameters: null
…
17:32:26,026 DEBUG [org.alfresco.repo.transfer.fsr.ManifestProcessorImpl] Failed to find root node in database. Creating…
17:32:26,026 DEBUG [org.alfresco.repo.transfer.fsr.ManifestProcessorImpl] Root folder exists. Creating node record in database.
…
Translating SQLException with SQL state '22005', error code '20000', message [An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'OTHER'.]; SQL was [] for task [Error setting null parameter. Most JDBC drivers require that the JdbcType must be specified for all nullable parameters. Cause: java.sql.SQLDataException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'OTHER'.
…

I'm not sure which, but it is either the select above or the subsequent call to dbHelper.createNodeInDB(rootNodeId, "", "", "", "", true), with a null value for rootNodeId that
is causing the SQL error.

I can't work out where the root node id is supposed to come from, maybe it is not being sent properly in the xml from alfresco?

This is using community 4.0d of alfresco and FTR
I will open a jira when I get some time…

Re: FTR NullPointerException: Source must not be null

amandaluniz_z — Fri, 23 Mar 2012 09:54:20 GMT

We have it using Alfresco Enterprise 4.0.0

Re: FTR NullPointerException: Source must not be null

roy_thompson — Fri, 23 Mar 2012 11:31:31 GMT

I'm getting somewhere.

When I created my transfer target in "Transfers/Transfer Target Groups/Default Group", the rule on "Default Group" caused the type to be "Transfer Target".
This type is missing the root folder property required for file transfer targets.

You need to change the type of the transfer target to "File Transfer Target" and then populate the "Root Folder" property.

When I do this, the rootFileTransfer parameter gets passed to the FTR service and I do not get the null error.

However, I don't have it working yet, I am getting the same "Lock Timeout" error as described here http://issues.alfresco.com/jira/browse/ALF-10571

I'd be interested to see if this was your issue (Target Target vs File Transfer Target type)…

Roy

Re: FTR NullPointerException: Source must not be null

roy_thompson — Fri, 23 Mar 2012 12:05:22 GMT

quick update, I've attempted the transfer again and I did not get a timeout, the transfer completed successfully.
more testing to follow…

Re: FTR NullPointerException: Source must not be null

lakk99 — Mon, 26 Mar 2012 14:46:10 GMT

Now it deployed without errors if I create a form with cm:content.

Initial error came when if I deploy with content with ws:article ( used in the WQS) . I need to check why the error came for custom model.

the error coming from code here… I need to debug more.. if you have any thought please let me know.

 if (!ContentModel.ASSOC_CONTAINS.equals(node.getPrimaryParentAssoc().getTypeQName()) ||
                !(ContentModel.TYPE_FOLDER.equals(node.getAncestorType()) ||
                        ContentModel.TYPE_CONTENT.equals(node.getAncestorType())))
        {
            monitor.logComment(getTransferId(), 
                    "Skipping node due to either: not content; not folder; or not cm:contains: " + nodeId);
            return;
        }
‍‍‍‍‍‍‍‍‍

Thanks,

Re: FTR NullPointerException: Source must not be null

garyj — Wed, 29 Aug 2012 08:51:22 GMT

Hi All,

I am having the same issue with the

java.lang.NullPointerException: Source must not be null‍

I've create a basic site, created a few folders, uploaded some documents.

Set up the FSTR as per https://issues.alfresco.com/jira/browse/ALF-10571

Ran the replication job and it ran fine.

The I enabled the Web Quick Start and imported the financial data.

When I ran the replication job I got

java.lang.NullPointerException: Source must not be null‍

This was the case with 4.0.d and now I've upgraded to 4.0.e and the problem persists!

Has anyone had any luck with solving this issue?

GJ