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>

[deko]

Hi there,

The import script is not using a database connection at all, so it cannot be a port issue for the DB.

Have you launched your console (cmd) as administrator? Could you try to run the batch file directly from C: as your path is very long already and Windows is limited to 255 characters here, which could in fact cause URL problems then.

I will try to reproduce this issue tomorrow with the same stack as described by you.

Best regards,
Dennis

[c_bo]

Hi Dennis,

Thanks.

Yes, the CMD is run as administrator.
I moved the

Sample Application‍

folder to

C:\‍

and it fails with the same error. Log attached with 2 attempts: with Alfresco stopped, and then started.

Is there any other way to load the sample data?

Best regards,
   Cyril

<blockcode>
2013-12-12 09:34:17,179 [main] FATAL OwOpenAir [] - fatal error on running action [Alfresco 3xx contex import for C:\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)
</blockcode>

[deko]

Hi again,

I just installed Alfresco 4.2.e on my local Win7 (x64) machine and for me the HR Sample Application installer from Workdesk 4.1.1.1 Community (2013-10-07) finished successfully without any errors.

I found this post, where a community user ran into the same issue as you and could solve the issue by running cmd.exe as administrator:

http://forums.alfresco.com/forum/installation-upgrades-configuration-integration/alfresco-workdesk-c...

When you say you ran CMD as administrator you mean running it by selecting "Run as administrator" from the right click context menu and not just as a user with admin privilieges right?

When you re-ran the installer did you run it for a clean fresh installed Alfresco Community? Because when you re-ran it on a already failed one it might fail and fail again. Did you configure Community Edition services to start automatically? This is recommended as the script can then work standalone without user inputs and just waits for the services to restart.

Unfortunately there is no other way at the moment to import the data. As not only the content model is imported but also some dossier folders and some documents. Maybe in the near future we should think about using an AMP file for importing the content model and an included ACP file which comes with the sample data.

Best regards,
Dennis

PS: If you can´t reinstall a clean Community Edition as you have already some data in there you have to ensure that you deleted the Importer logs (the folder C:\Alfresco\oat) and the imported content model files (file C:\Alfresco\tomcat\shared\classes\alfresco\extension\workdeskHRContentModel.xml and file C:\Alfresco\tomcat\shared\classes\alfresco\extension\workdesk-hr-context.xml). If the files don´t exist the rollback of the previousimport try was fine.

[c_bo]

Thanks again Dennis.

Yes I did Run as an administrator the CMD. The Alfresco install can be re-done, so I will give it a try and let you know.
Best Regards,
   Cyril

[c_bo]

Hi,

I uninstalled Alfresco, installed it again, and ran HR sample install. The same error occured (log attached).
Any suggestion welcome.
Thanks,
   Cyril

[deko]

Hi c_bo,

As I already tried yesterday and was successfully able to run the importer version used by you with the same Alfresco CE 4.2.e on a Win XP and a Win 7 client, I don´t know what else I could suggest. Only things I could think of are environmental issues with your machine.

1. Do you have the chance to use a test virtual machine to run the setup there?

2. Is there anything special in your current setup? Did you use default values for Alfresco CE, i.e. port 8080 and C:\Alfresco?

3. How is the script call in your console? Is it:

install-workdesk-hr.bat -ap C:\Alfresco -u admin -p your_password

4. Which Java version do you have installed?

5. Did you setup Alfresco CE services to start automatically?

6. Which installer file for Alfresco CE 4.2.e did you use?

Best regards,
Dennis

[c_bo]

Hi Dennis,

<blockquote>
1. Do you have the chance to use a test virtual machine to run the setup there?
</blockquote>
I will investigate this direction.

<blockquote>
2. Is there anything special in your current setup? Did you use default values for Alfresco CE, i.e. port 8080 and C:\Alfresco?
</blockquote>
Nothing special I can think of. Default values of the installer were used.

<blockquote>
3. How is the script call in your console? Is it:install-workdesk-hr.bat -ap C:\Alfresco -u admin -p your_password
</blockquote>
Yes, that is the call I used. I need to add JRE/bin to the console classpath before that call.

<blockquote>
4. Which Java version do you have installed?
</blockquote>

java version "1.7.0_45"
Java(TM) SE Runtime Environment (build 1.7.0_45-b18)
Java HotSpot(TM) 64-Bit Server VM (build 24.45-b08, mixed mode)
‍‍‍‍‍

<blockquote>
5. Did you setup Alfresco CE services to start automatically?
</blockquote>
No, it is setup for manual start.

<blockquote>
6. Which installer file for Alfresco CE 4.2.e did you use?
</blockquote>
Installer file is:

alfresco-community-4.2.e-installer-win-x64.exe‍

.

What connection is failing here? Protocol, port? Any test recommended to manually test it?

Thanks for your support.
   Cyril

[d_evil]

Hi Cyril,

first you should change the location of the HR App, I see your path is very long.
I moved my to the root of my 😧 partition (D:/HRApp/install-…bat).

The problem could be based on how the files are loaded (URL.toStream()) and I had to stop and start the Service (Alfresco tomcat) even though the console is started with Adminstration rights.

And you don't need to install Alfresco new, if you want to run the installer again remove following files:
- {Alfresco-location}/oat
- {Alfresco-location}/tomcat/shared/classes/alfresco/extension/workdesk…xml (two files)

Define the port where Alfresco is running with the -cp parameter when starting the App-installer, and then it run successful.

Hope that helps.

[ajaz]

HR Sample Application failed in my case as well. Let me explain what I did:

Step 1. Fresh installation of Alfresco Community 4.2e on windows 7 [C:\Alfresco]
Step 2. Stopped Alfresco
Step 3. put workdesk folder in C:\Alfresco\tomcat\webapps\ from alfresco-workdesk-community-4.1.1.0-2013-08-01-dist.zip
Step 4. Restarted Alfresco
Step 5. Open web.xml located in C:\Alfresco\tomcat\webapps\workdesk\WEB-INF and commented deploy#WEB-INF/conf/opencmis</param-value> and uncommented <param-value>deploy#WEB-INF/conf/opencmis_hr</param-value>
Step 6. Copy Human Resources Application folder from the alfresco-workdesk-community-4.1.1.0-2013-08-01-dist
Step 7. Open 'cmd' as 'Run As Administrator'
Step 8. from 'cmd' command prompt C:\Human Resources Application> install install-workdesk-hr.bat -ap C:/Alfresco -u myusername -p mypassword

And we get error as :

FATAL OwOpenAir [] - fatal error on running action [Alfresco 3xx contex import for C:\Human Resources Application\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