AnsweredAssumed Answered

More than one Alfresco schema was found when querying the database metadata.

Question asked by guille on Nov 20, 2018


Hi.

 

1) i stopped Alfresco running on RDBMS oracle
2) copied tables (pentaho) Oracle --> MySQL (some more modifications, but not looks like relevant)
3) start ALfresco pointing to MySQL

 

I got the error:

 

Caused by: org.alfresco.error.AlfrescoRuntimeException: 10200000
More than one Alfresco schema was found when querying the database metadata.
   Limit the database user's permissions or set the 'hibernate.default_schema' property in 'custom-hibernate-dialect.properties'.
        at org.alfresco.repo.domain.schema.SchemaBootstrap.countAppliedPatches(SchemaBootstrap.java:510)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:708)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1372)
        ... 34 more

 


I adjust the fie:
/opt/tompru57clon/shared/classes/alfresco-global.properties
setting up values like

 

root@hv-sv-000606 tompru57clon # grep -v "#" /opt/tompru57clon/shared/classes/alfresco-global.properties

dir.root=/alfresco/repositorios/aplicaciones

db.username=usu_alfresco
db.password=******
db.pool.initial=10
db.pool.max=100

 

db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://mysql5.6-pru.cji.junta-andalucia.es:3307/alfrapl?useUnicode=yes&characterEncoding=UTF-8

index.recovery.mode=AUTO

authentication.chain=alfrescoNtlm1:alfrescoNtlm,ldap2:ldap,ldap3:ldap,ldap5:ldap

 

alfresco.rmi.services.host=0.0.0.0

 

avm.rmi.service.port=50601
avmsync.rmi.service.port=50602
attribute.rmi.service.port=50603
authentication.rmi.service.port=50604
repo.rmi.service.port=50605
action.rmi.service.port=50606
wcm-deployment-receiver.rmi.service.port=50607
monitor.rmi.service.port=50608

 

cifs.enabled=true
cifs.localname=tompru57clon
cifs.domain=
cifs.broadcast=255.255.255.255
cifs.bindto=tompru57clon
cifs.tcpipSMB.port=1445
cifs.netBIOSSMB.sessionPort=1139
cifs.netBIOSSMB.namePort=1137
cifs.netBIOSSMB.datagramPort=1138
cifs.platforms=linux,solaris,macosx
cifs.ipv6=disabled
cifs.hostannounce=true

Outcomes