Unable login to Alfresco after migrate to local

rdy — Fri, 19 Feb 2021 03:36:06 GMT

Hi, i was unable to login to alfresco after migrate it to local environtment. from the login form this is the message that i get. i alsoo already checked to database that the user is exist.

Wrong Username / Password

And here is the log from here i see that the connection is successful but not sure what is the issue making me cannot logging in.

Feb 19, 2021 11:11:01 AM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: Loaded APR based Apache Tomcat Native library 1.1.32 using APR version 1.4.6.
Feb 19, 2021 11:11:01 AM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
Feb 19, 2021 11:11:01 AM org.apache.catalina.core.AprLifecycleListener initializeSSL
INFO: OpenSSL successfully initialized (OpenSSL 1.0.1m 19 Mar 2015)
Feb 19, 2021 11:11:01 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-apr-127.0.0.1-8080"]
Feb 19, 2021 11:11:01 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-apr-8009"]
Feb 19, 2021 11:11:01 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8443"]
Feb 19, 2021 11:11:01 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 590 ms
Feb 19, 2021 11:11:01 AM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Feb 19, 2021 11:11:01 AM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.x
Feb 19, 2021 11:11:01 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor /alfresco/tomcat/conf/Catalina/localhost/share.xml
Feb 19, 2021 11:11:03 AM org.apache.catalina.core.ApplicationContext log
INFO: No Spring WebApplicationInitializer types detected on classpath
Feb 19, 2021 11:11:03 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
2021-02-19 11:11:06,941 INFO [config.packaging.ModulePackageManager] [localhost-startStop-1] Found 1 module package(s)
2021-02-19 11:11:06,943 INFO [config.packaging.ModulePackageManager] [localhost-startStop-1] Alfresco / Google Docs Share Module, 3.0.3, The Share side artifacts of the Alfresco / Google Docs Integration.

2021-02-19 11:11:07,265 INFO [extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor freemarker for extension ftl
2021-02-19 11:11:07,267 INFO [extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor javascript for extension js
2021-02-19 11:11:07,268 INFO [extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor freemarker for extension ftl
2021-02-19 11:11:07,269 INFO [extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor javascript for extension js
2021-02-19 11:11:08,584 INFO [extensions.webscripts.DeclarativeRegistry] [localhost-startStop-1] Registered 386 Web Scripts (+0 failed), 404 URLs
2021-02-19 11:11:08,584 INFO [extensions.webscripts.DeclarativeRegistry] [localhost-startStop-1] Registered 8 Package Description Documents (+0 failed)
2021-02-19 11:11:08,585 INFO [extensions.webscripts.DeclarativeRegistry] [localhost-startStop-1] Registered 0 Schema Description Documents (+0 failed)
2021-02-19 11:11:08,656 INFO [extensions.webscripts.AbstractRuntimeContainer] [localhost-startStop-1] Initialised Surf Container Web Script Container (in 1376.5647ms)
2021-02-19 11:11:08,658 INFO [extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor freemarker for extension ftl
2021-02-19 11:11:08,659 INFO [extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor javascript for extension js
Feb 19, 2021 11:11:08 AM org.apache.catalina.core.ApplicationContext log
INFO: org.tuckey.web.filters.urlrewrite.UrlRewriteFilter INFO: loaded (conf ok)
Feb 19, 2021 11:11:08 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring FrameworkServlet 'Spring Surf Dispatcher Servlet'
Feb 19, 2021 11:11:08 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deployment of configuration descriptor /alfresco/tomcat/conf/Catalina/localhost/share.xml has finished in 7,427 ms
Feb 19, 2021 11:11:08 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor /alfresco/tomcat/conf/Catalina/localhost/solr4.xml
Feb 19, 2021 11:11:08 AM org.apache.catalina.startup.SetContextPropertiesRule begin
WARNING: [SetContextPropertiesRule]{Context} Setting property 'debug' to '0' did not find a matching property.
Feb 19, 2021 11:11:11 AM org.apache.catalina.core.ApplicationContext log
INFO: No Spring WebApplicationInitializer types detected on classpath
2021-02-19 11:11:13,497 INFO [solr.component.AsyncBuildSuggestComponent] [coreLoadExecutor-5-thread-2] Initializing SuggestComponent
2021-02-19 11:11:13,497 INFO [solr.component.AsyncBuildSuggestComponent] [coreLoadExecutor-5-thread-1] Initializing SuggestComponent
2021-02-19 11:11:13,640 INFO [solr.component.AsyncBuildSuggestComponent] [Suggestor-alfresco-1] Loading suggester index for: shingleBasedSuggestions
Feb 19, 2021 11:11:13 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deployment of configuration descriptor /alfresco/tomcat/conf/Catalina/localhost/solr4.xml has finished in 4,768 ms
Feb 19, 2021 11:11:13 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor /alfresco/tomcat/conf/Catalina/localhost/alfresco.xml
2021-02-19 11:11:13,663 INFO [solr.component.AsyncBuildSuggestComponent] [Suggestor-alfresco-1] Loaded suggester shingleBasedSuggestions, took 23 ms
Feb 19, 2021 11:11:18 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/core_rt is already defined
Feb 19, 2021 11:11:18 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/core is already defined
Feb 19, 2021 11:11:18 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/core is already defined
Feb 19, 2021 11:11:18 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/fmt_rt is already defined
Feb 19, 2021 11:11:18 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/fmt is already defined
Feb 19, 2021 11:11:18 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/fmt is already defined
Feb 19, 2021 11:11:18 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/functions is already defined
Feb 19, 2021 11:11:18 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/permittedTaglibs is already defined
Feb 19, 2021 11:11:18 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/scriptfree is already defined
Feb 19, 2021 11:11:18 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/sql_rt is already defined
Feb 19, 2021 11:11:18 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/sql is already defined
Feb 19, 2021 11:11:18 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/sql is already defined
Feb 19, 2021 11:11:18 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/xml_rt is already defined
Feb 19, 2021 11:11:18 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/xml is already defined
Feb 19, 2021 11:11:18 AM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/xml is already defined
Feb 19, 2021 11:11:18 AM org.apache.catalina.core.ApplicationContext log
INFO: No Spring WebApplicationInitializer types detected on classpath
Feb 19, 2021 11:11:18 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
2021-02-19 11:11:20,099 ERROR [alfresco.solr.SolrInformationServer] [SolrTrackerScheduler_Worker-1] Error parsing http port:8080,address="127.0.0.1"
2021-02-19 11:11:22,474 INFO [alfresco.repo.admin] [localhost-startStop-1] Using database URL 'jdbcostgresql://localhost:5432/alfresco' with user 'alfresco'.
2021-02-19 11:11:22,476 INFO [alfresco.repo.admin] [localhost-startStop-1] Connected to database PostgreSQL version 9.4.4
2021-02-19 11:11:25,654 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Ignoring script patch (post-Hibernate): patch.db-V4.2-metadata-query-indexes
2021-02-19 11:11:25,654 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Ignoring script patch (post-Hibernate): patch.db-V5.1-metadata-query-indexes
2021-02-19 11:11:30,939 INFO [extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor Repository Template Processor for extension ftl
2021-02-19 11:11:30,940 INFO [extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor Repository Script Processor for extension js
2021-02-19 11:11:32,239 INFO [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]
2021-02-19 11:11:32,280 INFO [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted] complete
2021-02-19 11:11:32,315 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbcostgresql://localhost:5432/alfresco, UserName=alfresco, PostgreSQL Native Driver
2021-02-19 11:11:32,315 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.hibernate.dialect.PostgreSQLDialect.
2021-02-19 11:11:33,661 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] No changes were made to the schema.
2021-02-19 11:11:33,907 INFO [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]
2021-02-19 11:11:34,034 INFO [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1] complete
2021-02-19 11:11:34,649 ERROR [repo.descriptor.RepositoryDescriptorDAOImpl] [localhost-startStop-1] updateDescriptor:
org.springframework.dao.DataIntegrityViolationException: No ContentData value exists for ID 4
at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl.getContentData(AbstractContentDataDAOImpl.java:185)
at org.alfresco.repo.domain.node.NodePropertyHelper.makeSerializableValue(NodePropertyHelper.java:671)
at org.alfresco.repo.domain.node.NodePropertyHelper.collapsePropertiesWithSameQNameAndListIndex(NodePropertyHelper.java:579)
at org.alfresco.repo.domain.node.NodePropertyHelper.convertToPublicProperties(NodePropertyHelper.java:407)
at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$PropertiesCallbackDAO.findByKey(AbstractNodeDAOImpl.java:2588)
at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$PropertiesCallbackDAO.findByKey(AbstractNodeDAOImpl.java:1)
at org.alfresco.repo.cache.lookup.EntityLookupCache.getByKey(EntityLookupCache.java:323)
at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.getNodePropertiesCached(AbstractNodeDAOImpl.java:2517)
at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.getNodeProperties(AbstractNodeDAOImpl.java:2057)
at org.alfresco.repo.node.db.DbNodeServiceImpl.getPropertiesImpl(DbNodeServiceImpl.java:1580)
at org.alfresco.repo.node.db.DbNodeServiceImpl.getProperties_aroundBody56(DbNodeServiceImpl.java:1571)
at org.alfresco.repo.node.db.DbNodeServiceImpl$AjcClosure57.run(DbNodeServiceImpl.java:1)
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)
at org.alfresco.traitextender.RouteExtensions.intercept(RouteExtensions.java:93)
at org.alfresco.repo.node.db.DbNodeServiceImpl.getProperties(DbNodeServiceImpl.java:1568)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.alfresco.repo.lock.mem.LockableAspectInterceptor.invoke(LockableAspectInterceptor.java:136)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy25.getProperties(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at

Can anyone help me on this issue?

Re: Unable login to Alfresco after migrate to local

sufo — Fri, 19 Feb 2021 11:59:05 GMT

Did you also migrate alf_data directory? Maybe you migrated database but not the data stored on a file system (just guessing that the error below is about it).

2021-02-19 11:11:34,649 ERROR [repo.descriptor.RepositoryDescriptorDAOImpl] [localhost-startStop-1] updateDescriptor:
org.springframework.dao.DataIntegrityViolationException: No ContentData value exists for ID 4

Re: Unable login to Alfresco after migrate to local

cristinamr — Fri, 19 Feb 2021 14:56:44 GMT

Which alfresco version did you migrate? could you please provide us a little more details of you migration proccess?

topic Re: Unable login to Alfresco after migrate to local in Alfresco Forum

Unable login to Alfresco after migrate to local

Re: Unable login to Alfresco after migrate to local

Re: Unable login to Alfresco after migrate to local