CMDBuild Forum

Alfresco Integration

I'm trying to integrate Alfresco (v3.4) with CMDBuild.  I have Alfresco installed and running and I am able to ftp to it and transfer a file using FileZilla.  I cannot seem to get the CMDBuild integration to work however.  When I attached a file to an a card, CMDB hangs and the file transfer does not complete.  I have to kill the browser page.  Within Alfresco, the file appears in the right location, in but with a 0 byte size.  Any thoughts as to what the problem could be?  I tried to follow the CMDBuild documentation but I found the Alfresco integration section a bit hard to follow.  For example, do i need to create a cmdbuildCustomModel.xml fileand a cmdbuild-custom-model-context.xml file?

Dear Dan,
 
no, you don't need to create custom XML files (they are needed for advanced features only). Are you able to post CMDBuild's log?
 
Best regards.
 
-- Davide Pavan
 
Previously Dan wrote:

I'm trying to integrate Alfresco (v3.4) with CMDBuild.  I have Alfresco installed and running and I am able to ftp to it and transfer a file using FileZilla.  I cannot seem to get the CMDBuild integration to work however.  When I attached a file to an a card, CMDB hangs and the file transfer does not complete.  I have to kill the browser page.  Within Alfresco, the file appears in the right location, in but with a 0 byte size.  Any thoughts as to what the problem could be?  I tried to follow the CMDBuild documentation but I found the Alfresco integration section a bit hard to follow.  For example, do i need to create a cmdbuildCustomModel.xml fileand a cmdbuild-custom-model-context.xml file?

 

1 Like

Previously Tecnoteca wrote:

Dear Dan,
 
no, you don't need to create custom XML files (they are needed for advanced features only). Are you able to post CMDBuild's log?
 
Best regards.
 
-- Davide Pavan
 
Previously Dan wrote:

I'm trying to integrate Alfresco (v3.4) with CMDBuild.  I have Alfresco installed and running and I am able to ftp to it and transfer a file using FileZilla.  I cannot seem to get the CMDBuild integration to work however.  When I attached a file to an a card, CMDB hangs and the file transfer does not complete.  I have to kill the browser page.  Within Alfresco, the file appears in the right location, in but with a 0 byte size.  Any thoughts as to what the problem could be?  I tried to follow the CMDBuild documentation but I found the Alfresco integration section a bit hard to follow.  For example, do i need to create a cmdbuildCustomModel.xml fileand a cmdbuild-custom-model-context.xml file?

 

INFO  2014-03-24 07:31:32 [jsonrpc ] Calling url /attachments/uploadattachment

WARN  2014-03-24 07:31:32 [dms     ] error changing directory

org.cmdbuild.dms.exception.DmsError: org.cmdbuild.dms.exception.DmsError: error

changing working directory to 'Id101'

        at org.cmdbuild.dms.exception.DmsError.forward(DmsError.java:51)

        at org.cmdbuild.dms.alfresco.ftp.AlfrescoFtpClient.changeDirectory(Alfre

scoFtpClient.java:164)

        at org.cmdbuild.dms.alfresco.ftp.AlfrescoFtpClient.changeDirectory(Alfre

scoFtpClient.java:143)

        at org.cmdbuild.dms.alfresco.ftp.AlfrescoFtpClient.upload(AlfrescoFtpCli

 

When I upload a file (or attempt to) from within cmdbuild it creates the path and a zero byte file of the correct name. I verified this from Alfresco itself. Also If I manually FTP via CLI it successfully uploads the file so I know alfresco is working correctly. It seems there is something wrong with the CMDBuild config.

 

I've also gotten this error

 

ERROR 2014-03-24 07:46:57 [cmdbuild] error uploading file 'BP1028_iSCSI_For_FC_Pros.pdf' to card 'EMCVNX' with id '101'

org.cmdbuild.dms.exception.DmsError: java.util.IllegalFormatConversionException: d != java.lang.String

        at org.cmdbuild.dms.exception.DmsError.forward(DmsError.java:51)

        at org.cmdbuild.dms.alfresco.AlfrescoDmsService.upload(AlfrescoDmsService.java:99)

        at org.cmdbuild.dms.ForwardingDmsService.upload(ForwardingDmsService.java:40)

.......

 

        at org.cmdbuild.dms.alfresco.AlfrescoDmsService.upload(AlfrescoDmsService.java:92)

        ... 44 more

ERROR 2014-03-24 07:46:57 [jsonrpc ] A org.cmdbuild.exception.DmsException occurred calling method class org.cmdbuild.servlets.json.Attachments.uploadAttachment: DMS_ATTACHMENT_UPLOAD_ERROR

 

Dear Josh,
 
we've tried to replicate your issue but with no success.
 
Please, find the file named "log4j.properies" within CMDBuild installation, edit it setting property "log4j.logger.dms" to "DEBUG". Then restart CMDBuild and try again the upload operation.
 
Then, are you able to provide us the full stacktrace and the DMS configuration (file dms.conf)?
 
Best regards.
 
--
CMDBuild Team
 
Previously Josh wrote:

INFO  2014-03-24 07:31:32 [jsonrpc ] Calling url /attachments/uploadattachment

WARN  2014-03-24 07:31:32 [dms     ] error changing directory

org.cmdbuild.dms.exception.DmsError: org.cmdbuild.dms.exception.DmsError: error

changing working directory to 'Id101'

        at org.cmdbuild.dms.exception.DmsError.forward(DmsError.java:51)

        at org.cmdbuild.dms.alfresco.ftp.AlfrescoFtpClient.changeDirectory(Alfre

scoFtpClient.java:164)

        at org.cmdbuild.dms.alfresco.ftp.AlfrescoFtpClient.changeDirectory(Alfre

scoFtpClient.java:143)

        at org.cmdbuild.dms.alfresco.ftp.AlfrescoFtpClient.upload(AlfrescoFtpCli

 

When I upload a file (or attempt to) from within cmdbuild it creates the path and a zero byte file of the correct name. I verified this from Alfresco itself. Also If I manually FTP via CLI it successfully uploads the file so I know alfresco is working correctly. It seems there is something wrong with the CMDBuild config.

 

I've also gotten this error

 

ERROR 2014-03-24 07:46:57 [cmdbuild] error uploading file 'BP1028_iSCSI_For_FC_Pros.pdf' to card 'EMCVNX' with id '101'

org.cmdbuild.dms.exception.DmsError: java.util.IllegalFormatConversionException: d != java.lang.String

        at org.cmdbuild.dms.exception.DmsError.forward(DmsError.java:51)

        at org.cmdbuild.dms.alfresco.AlfrescoDmsService.upload(AlfrescoDmsService.java:99)

        at org.cmdbuild.dms.ForwardingDmsService.upload(ForwardingDmsService.java:40)

.......

 

        at org.cmdbuild.dms.alfresco.AlfrescoDmsService.upload(AlfrescoDmsService.java:92)

        ... 44 more

ERROR 2014-03-24 07:46:57 [jsonrpc ] A org.cmdbuild.exception.DmsException occurred calling method class org.cmdbuild.servlets.json.Attachments.uploadAttachment: DMS_ATTACHMENT_UPLOAD_ERROR

 

 

Is there somewhere I can upload the files to? Or an email address I can send them to?

You can zip and attach all them to a post on this forum.
 
Best regards.
 
Previously Josh wrote:

Is there somewhere I can upload the files to? Or an email address I can send them to?

 

There's no mechanism here to attach files to a post.

 

 

Dear Josh,
 
I'll send you a private mail then you can reply to it attaching files.
 
Best regards.
 
-- CMDBuild Team
 
Previously Josh wrote:

There's no mechanism here to attach files to a post.

 

 

 

Previously Josh wrote:

WARN  2014-03-24 07:31:32 [dms     ] error changing directory

org.cmdbuild.dms.exception.DmsError: org.cmdbuild.dms.exception.DmsError: error

changing working directory to 'Id101'


I got the same warning, after reviewing my installation i noticed that i forgot to create the AlfrescoCatagory inside alfresco. The error is a bit confusing i must say.

Dear CMDBuild team:
 
I am confused with "Alfresco Setup" Page with these items:
 
"Alfresco Setup" --> "Repository" --> "Web service path" and "Application", which two of these items are not well documented in you technical manual. 
 
And I am not good at JSP technology, PLS give me a hand. 
 
your sincerely.
 
a user from China.
{http://www.alfresco.org/ws/service/repository/1.0}RepositoryFault:<ns1:errorCode>0</ns1:errorCode><ns1:message>java.lang.IllegalStateException: Failed to resolve to a single NodeRef with parameters (store=workspace:SpacesStore uuid=null path=/app:fmpkunshan/app:fmpkunshan/cm:cmdbuild/cm:Employee/cm:Id122), found 0 nodes.</ns1:message>
 
Hi 
Has this issue been resolved ?
I'm having exactly the same problem. Ftp files directly to Alfresco works but not when uploaded via cmdbuild - it appears as zero in file size.
Any help would be appreciated.
Thanks
Shawn
 
 
 
Previously Tecnoteca wrote:
Dear Josh,
 
I'll send you a private mail then you can reply to it attaching files.
 
Best regards.
 
-- CMDBuild Team
 
Previously Josh wrote:

There's no mechanism here to attach files to a post.