HR sample installation fail on 'Alfresco 3xx contex import'

[c_bo]

Hi there,

I have Alfresco community 4.2.e , and Workdesk community 4.1.1.1-2013-10-07-dist running on Windows 7. I try to install HR sample.

When running install-workdesk-hr.bat (running as Administrator), I get the error below (awd-openair.log also attached). I'm trying to setup everything locally on my machine, but could it be the JDBC connection on port 5432 mentioned in this post from Deko?
Thanks,
   Cyril

<blockcode>
2013-12-11 16:46:48,923 [main] INFO  OwOpenAir [] - Stopping [Alfresco 3xx contex import for C:\Windows\Temp\_ My temp\alfresco-workdesk-community-4.1.1.1-2013-10-07-dist\bin\Sample Application\Human Resources Application\samples\workdesk-hr\workdesk-hr-context.xml]
2013-12-11 16:46:48,934 [main] FATAL OwOpenAir [] - fatal error on running action [Alfresco 3xx contex import for C:\Windows\Temp\_ My temp\alfresco-workdesk-community-4.1.1.1-2013-10-07-dist\bin\Sample Application\Human Resources Application\samples\workdesk-hr\workdesk-hr-context.xml]. Undoing changes.
com.wewebu.ooa.OwOAInstallError: java.net.SocketException: Connection reset
   at com.wewebu.ooa.ace.OwImportContext3xAction.installContextFiles(OwImportContext3xAction.java:189)
   at com.wewebu.ooa.ace.OwImportContext3xAction.runBare(OwImportContext3xAction.java:232)
   at com.wewebu.ooa.OwInstallActionBase.run(OwInstallActionBase.java:21)
   at com.wewebu.ooa.OwOpenAir.install(OwOpenAir.java:87)
   at com.wewebu.ooa.OwOpenAir.main(OwOpenAir.java:279)
Caused by: java.net.SocketException: Connection reset
   at java.net.SocketInputStream.read(SocketInputStream.java:196)
   at java.net.SocketInputStream.read(SocketInputStream.java:122)
   at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
   at java.io.BufferedInputStream.read1(BufferedInputStream.java:275)
   at java.io.BufferedInputStream.read(BufferedInputStream.java:334)
   at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:687)
   at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:633)
   at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:658)
   at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1323)
   at org.apache.xerces.impl.XMLEntityManager.setupCurrentEntity(Unknown Source)
   at org.apache.xerces.impl.XMLEntityManager.startEntity(Unknown Source)
   at org.apache.xerces.impl.XMLEntityManager.startDTDEntity(Unknown Source)
   at org.apache.xerces.impl.XMLDTDScannerImpl.setInputSource(Unknown Source)
   at org.apache.xerces.impl.XMLDocumentScannerImpl$DTDDispatcher.dispatch(Unknown Source)
   at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
   at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
   at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
   at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
   at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
   at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
   at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:205)
   at com.wewebu.ooa.ace.OwImportContext3xAction.installContextFiles(OwImportContext3xAction.java:145)
   … 4 more
<blockcode>

[d_evil]

Step 4 and 5 I would switch, because changing web.xml when server is running will just trigger a restart of the deployment.

Step 8 - hope it is only a typo - should be only

install-workdesk-hr.bat -ap C:/Alfresco -u myusername -p mypassword‍

instead of
<cite>install install-workdesk-hr.bat -ap C:/Alfresco -u myusername -p mypassword</cite>

Now the part I don't get:

java.net.UnknownHostException: www.springframework.org‍

Is somewhere defined to use the springframwork.org?

Btw, you don't need to deploy the workdesk for the HR-installer, it can run without.
1. Shut down Alfresco
2. delete the Folder C:\Alfresco\oat, and the files in C:\Alfresco\tomcat\shared\alfresco\extension\workdesk-…xml
3. Start the hr-installer
4. as soon as you see that it try to start alfresco, start the Alfresco tomcat/service manually
5. if successfully run, look that you have in Alfresco some structure like /HR/Dossiers
6. (if not already done) Shut down Alfresco tomcat/service and add workdesk
7. (if not already done) change workdesk/WEB-INF/web.xml to HR configuration
8. start Alfresco tomcat/service

[ajaz]

Dear D.evil,

Loads of thanks for your response. I followed the steps described by you religiously but it is not working. The required /HR/Dossiers folder does not get imported.

Step 4 as described by you
as soon as you see that it try to start alfresco, start the Alfresco tomcat/service manually

I did start Alfresco tomcat service but it ended up with the same error. The error is

FATAL OwOpenAir [] - fatal error on running action [Alfresco 3xx contex import for C:\HRApplication\samples\workdesk-hr\workdesk-hr-context.xml]. Undoing changes.
com.wewebu.ooa.OwOAInstallError: java.net.UnknownHostException: www.springframework.org
   at com.wewebu.ooa.ace.OwImportContext3xAction.installContextFiles(OwImportContext3xAction.java:189)
   at com.wewebu.ooa.ace.OwImportContext3xAction.runBare(OwImportContext3xAction.java:232)
   at com.wewebu.ooa.OwInstallActionBase.run(OwInstallActionBase.java:21)
   at com.wewebu.ooa.OwOpenAir.install(OwOpenAir.java:87)
   at com.wewebu.ooa.OwOpenAir.main(OwOpenAir.java:279)
Caused by: java.net.UnknownHostException: www.springframework.org
   at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
   at java.net.PlainSocketImpl.connect(Unknown Source)
   at java.net.SocksSocketImpl.connect(Unknown Source)
   at java.net.Socket.connect(Unknown Source)
   at java.net.Socket.connect(Unknown Source)
   at sun.net.NetworkClient.doConnect(Unknown Source)
   at sun.net.www.http.HttpClient.openServer(Unknown Source)
   at sun.net.www.http.HttpClient.openServer(Unknown Source)
   at sun.net.www.http.HttpClient.<init>(Unknown Source)
   at sun.net.www.http.HttpClient.New(Unknown Source)
   at sun.net.www.http.HttpClient.New(Unknown Source)
   at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(Unknown Source)
   at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
   at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source)
   at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
   at org.apache.xerces.impl.XMLEntityManager.setupCurrentEntity(Unknown Source)
   at org.apache.xerces.impl.XMLEntityManager.startEntity(Unknown Source)
   at org.apache.xerces.impl.XMLEntityManager.startDTDEntity(Unknown Source)
   at org.apache.xerces.impl.XMLDTDScannerImpl.setInputSource(Unknown Source)
   at org.apache.xerces.impl.XMLDocumentScannerImpl$DTDDispatcher.dispatch(Unknown Source)
   at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
   at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
   at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
   at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
   at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
   at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
   at javax.xml.parsers.DocumentBuilder.parse(Unknown Source)
   at com.wewebu.ooa.ace.OwImportContext3xAction.installContextFiles(OwImportContext3xAction.java:145)

Following steps 5, 6 7 and 8 as described by you did not yield. The end result ‘/HR/Dossiers’ is not getting imported.

Thank you again for your response.
Stay HappY

[ajaz]

On further investigation I find the following while HR installer is running:

The HR installer after copying the context : C:\HumanResourcesApplication\samples\workdesk-hr\workdesk-hr-context.xml -> C:\Alfresco\tomcat\shared\classes\alfresco\extension\workdesk-hr-context.xml successfully does not copy the model file 'workdeskHRContentModel.xml' in the extension folder.

This is the case because once HR installer restarts the Alfresco/Tomcat it fails to start-up because of the absence of the required model file.

Can anyone  assist?

Thank You

[deko]

Hi ajaz,

After reviewing the source code of the importer I found the following issues.

The workdeskHRContentModel.xml file includes the following:

<!DOCTYPE beans PUBLIC '-//SPRING//DTD BEAN//EN' 'http://www.springframework.org/dtd/spring-beans.dtd'>
‍‍‍

After reviewing how the XML file is parsed at the moment I found that we are validating the dtd here. You do not have internet connection on your machine where you are importing, right? This is causing the issue now. I will try to fix this now in code of the importer by disbaling the validation while parsing and send you a new jar file you need to replace in the importer.

Best regards,
deko

[deko]

Hi ajaz,

Attached you can find a file named oa.txt which is in fact a jar file, I just had to rename it from oa.jar to oa.txt because the forum is not accepting jar files, neither zip or rar. Could you please rename it again and replace the jar under C:\Human Resources Application\bin and try again? Thank you for contributing this useful input so far.

deko

[ajaz]

Dear Deko,
Warm Greetings!

You are right on the money from the word go. You nailed it efficiently. Your valuable help was like a breath of fresh air.  My ‘workdesk’ installation is up on its toes and is working smoothly.

Thank You
Stay HappY

[deko]

Hi ajaz,

I am happy when you are happy! Enjoy Workdesk now!

Best regards,
deko

PS: I added this fix also to the current development branch so it will be part of the next released Workdesk Community Edition.

[aditya_chaudhar]

H D.evil  and all others ,

D.evil thanks afor your tip.
In my case as well i put        'alfresco-workdesk-community-4.1.1.0-2013-08-01-dist'  in D drive

But when i copy it in C drive and rename this folder as 'aa' then process as mentioned in doc provided in this folder.

It works for me.
Steps i follow :
1. copy installation unzip in c and rename  'alfresco-workdesk-community-4.1.1.0-2013-08-01-dist'  as 'aa' ( just to minimize size of foldername)
2. go to c:\aa directory from command prompt run as administrator
3. check if my java PATH variable is set.
4 . copy install-workdesk-hr -ap C:\Alfresco -u admin -p admin  command in cmd
5. done it took around 15 min in my case to successfully install.

Thanks community for quick help.

Aditya C