beCPG PLM Community

Hi,

Ovf template is just for demo purpose is not supposed to work remotly.
I you download the ZIP files with all the AMPs and follow the installation instructions :

https://www.becpg.fr/redmine/projects/becpg-community/wiki/Install-doc

It should not override your passwords.

Regards

I have double checked the install. I had a working install with password. The password was set in global properties and is still there,

changing this hash does not work, nor does it fix the password.

Maybe is not a password problem at all. Can you connect to http://localhost:8080/alfresco ?

Can you provide your logs and installation details.

Regards

Well, figuring I had a working alfresco setup, and can repeat this process with any download of 4.2 alfresco community. Then i ran your java instructions and it continually does this, I would say there is a code issue with your installer overwriting something

It reminds me another issue I had with another clients alfresco setup.

I think your install changes the conf and makes this issue.

https://forums.alfresco.com/forum/installation-upgrades-configuration-integration/installation-upgrades/objid-already-use

Which is confirmed by

2014-10-28 13:36:00,012  ERROR [quartz.core.ErrorLogger] [SolrTrackerScheduler_Worker-2] Job (Solr.CoreTracker-alfresco threw an exception.
 org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.alfresco.error.AlfrescoRuntimeException: 09280073 GetModelsDiff return status is 404]

There is nothing more that infuriates me more than developers being lazy, and blaming problems on other things.

The fact i had a working install, then i do this and get this error is proof in pudding the other people "not" reporting it is not a real defense, or even a logical defense. You think I want to buy your product after I hear that out of your mouth? I hate people who intentionally skip out on working on a problem and just blaming others for their clear coding problems. I think most simply assumed your software doesnt work. Personally. The simple fact I have to come here to ask if your templated vm can talk on a network speaks volumes. Normally I would not care, but you have the audacity to act like this then want to sell a enterprise version of this product.

Appears the host logic wise is altered by your install process......

Question is how to fix this issue.

Alfreso logs

16:51:28,818 WARN [org.hibernate.cfg.SettingsFactory] Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2079)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
    at java.lang.Thread.run(Thread.java:722)
Caused by: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
    at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
    at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
    at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
    at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
    at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)
    at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
    at org.postgresql.Driver.makeConnection(Driver.java:393)
    at org.postgresql.Driver.connect(Driver.java:267)
    at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
    at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
    ... 106 more
Caused by: java.net.ConnectException: Connection refused
    at java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
    at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
    at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:391)
    at java.net.Socket.connect(Socket.java:579)
    at java.net.Socket.connect(Socket.java:528)
    at java.net.Socket.<init>(Socket.java:425)
    at java.net.Socket.<init>(Socket.java:208)
    at org.postgresql.core.PGStream.<init>(PGStream.java:62)
    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
    ... 118 more
16:51:28,848 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tenantService' defined in file [/opt/alfresco-4.2.c/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/mt/mt-context.xml]: Cannot resolve reference to bean 'tenantAdminDAO' while setting bean property 'tenantAdminDAO'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tenantAdminDAO' defined in class path resource [alfresco/dao/dao-context.xml]: Cannot resolve reference to bean 'repoSqlSessionTemplate' while setting bean property 'sqlSessionTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repoSqlSessionTemplate' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Cannot resolve reference to bean 'repoSqlSessionFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repoSqlSessionFactory' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Cannot resolve reference to bean 'dialectResourceLoader' while setting bean property 'resourceLoader'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectResourceLoader' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Cannot create inner bean 'org.springframework.beans.factory.config.PropertyPathFactoryBean#faf3f71' of type [org.springframework.beans.factory.config.PropertyPathFactoryBean] while setting bean property 'dialectClass'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.beans.factory.config.PropertyPathFactoryBean#faf3f71' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialect' defined in class path resource [alfresco/hibernate-context.xml]: Cannot resolve reference to bean '&sessionFactory' while setting bean property 'localSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [alfresco/hibernate-context.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)

...

Your logs show that you are using 4.2.c version instead of 4.2.f

Regards

Confirmed working status with 4.2f.

Sorry for the problems.

Thank you for your help.

I have noticed this problem located at

https://www.becpg.fr/redmine/boards/5/topics/308?r=311#message-311

I have the error Could not get project reports 'http://10.10.26.92:8080/share/proxy/alfresco//becpg/report/exportsearch/templates/pjt:project'.

I disabled solr per recommendations and still get the same error.

Report server, comes bundle with PLM or with enterprise version. It's a separate war files including birt engine.
You can download it from sourceforge plm zip file and try to install it under your Tomcat.

Regards

Same for BI analytics before you ask for.

I do not see a download for BI or that listed anywhere on your site... on source forge. Do you have one?

I unzipped plm and it has many war files.

Appears you cant even not use plm? Why not document this?

Installed plm and still have same issue.

I reinstalled with the plm zip only.

Everything appears to work.

Well, now I cannot create hierarchy

I get a blank 404 page.

Url is

Looking at the forums I cant find a fix....

http://10.10.26.92:8080/share/proxy/alfresco/becpg/entity/datalists/data/node?itemType=pjt%3Aproject&dataListName=projectList&pageSize=5000&site=&sort=pjt:projectHierarchy2&sortId=ProjectList&repo=true&format=xls&metadata=%7B%22fields%22%3A%5B%22cm_name%22%2C%22bcpg_code%22%2C%22cm_title%22%2C%22cm_description%22%2C%22pjt_projectHierarchy1%22%2C%22pjt_projectHierarchy2%22%2C%22pjt_projectOrigin%22%2C%22pjt_projectSponsor%22%2C%22pjt_projectManager%22%2C%22pjt_projectObservers%22%2C%22bcpg_entityTplRef%22%2C%22pjt_projectEntity%22%2C%22pjt_projectPriority%22%2C%22pjt_projectState%22%2C%22pjt_projectStartDate%22%2C%22pjt_projectDueDate%22%5D%2C%22filter%22%3A%7B%22datagridFirstTimeNav%22%3Atrue%2C%22filterId%22%3A%22projects%22%2C%22filterData%22%3A%22InProgress%22%2C%22filterOwner%22%3A%22Alfresco.component.AllFilter%22%2C%22action%22%3A%22filterChanged%22%2C%22flagged%22%3Afalse%2C%22decrepitate%22%3Afalse%2C%22stop%22%3Afalse%2C%22filterParams%22%3A%22fts(%3Dpjt%5C%5C%3AprojectState%3A%5C%22InProgress%5C%22)%22%7D%2C%22page%22%3A1%7D

Any idea on how to fix this now?

Hi,

becpg-plm and report are only opensourced from some month now, so is not as documented as it should be.
Documentation of community will come from the community or when we have time to do it.

BI feature is only enterprise feature, and will stay as it because it need's some extra steps to setup it.
Report server are part of plm community zip file and can be extract and install it under project.
This is not documented yet because we consider that project reporting is an EE only tool (Even if community member can setup it with some basic skills).

Enterprise version comes with an installer that make this install steps automatised.

In your case:

- You want to test all the features: ask for an online demo account 
 - You want to use the community version and contribute to it:
      - You should have some alfresco development skills to understand the code make contribution, improve it and install it properly
      - We will be pleased to help you for real issue (not mistaken installation)
      - Documentation is light and will be more consistent over the time (or contributed)
 - You want all the feature, support, accompanying and ready to use installation, ask for the EE version

Regards

This is pretty simple stuff, I cant even use any portion of any of your products.

I would consider them unusable. No need to buy something that doesnt work.

Best of luck with your products.

Confirmed with multiple installs, and multiple tries that no one can use this product or add a project without the error cannot add item.

If anyone sees this on google, realize there is no way to setup this software to get it to work, with any module or any of the instructions. There is a reason other people in these forums post about not being able to get past cannot add item. Then disappear.

Hopefully this saves you some time.

Hi,

Instead of making a smear campaign, maybe you can attach your log to see where is your issue.
You can also try to be more precise, doesn't work is not enought.

I mean your product version OS, database, installation procedure, step to reproduce, screenshot and so on.

It will be a lot more interresting for the community that your previous comments.

Regards