nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Schema Upgrade from AMP

renspr

Hi,

I really need to add new table to the Alfresco database schema. The schema upgrade should be performed when the AMP is loaded. Following http://wiki.alfresco.com/wiki/Schema_Upgrade_Scripts#Script_Loading I added the appropriate bean

<bean id="myUpdatePatch1" class="org.alfresco.repo.admin.patch.impl.SchemaUpgradeScriptPatch" parent="basePatch">
    <property name="id">
      <value>myUpdatePatch1</value>
    </property>
    <property name="description">
      <value>patch.schemaUpgradeScript.description</value>
    </property>
    <property name="fixesFromSchema">
      <value>0</value>
    </property>
    <property name="fixesToSchema">
      <value>116</value>
    </property>
    <property name="targetSchema">
      <value>117</value>
    </property>
    <property name="scriptUrl">
      <value>classpath:alfresco/module/myamp/dbscripts/create/2.9/${db.script.dialect}/patch1.sql</value>
    </property>
  </bean>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

to module-context.xml.

I get the following problem:

16:05:14,300 User:System INFO  [admin.patch.PatchExecuter] Checking for patches to apply …
16:05:14,824 User:System INFO  [admin.patch.PatchExecuter]    Applying patch 'myUpdatePatch1' (patch.schemaUpgradeScript.description).
16:05:14,831 User:System ERROR [admin.patch.PatchExecuter] The schema upgrade script, 'classpath:alfresco/module/myamp/dbscripts/create/2.9/${db.script.dialect}/patch1.sql', has not been run against this database.‍‍‍

It looks like that the ${db.script.dialect} property is not correctly replaced with the current dialect. Has somebody successfully run the SchemaUpgradeScriptPatch from an AMP? Are there better solutions?

Best regards,

RenÃƒÂ©

Find more posts tagged with

Comments

rdanner

<bean id="myUpdatePatch1" class="org.alfresco.repo.admin.patch.impl.SchemaUpgradeScriptPatch" parent="basePatch">
    <property name="id">
      <value>myUpdatePatch1</value>
    </property>
    <property name="description">
      <value>patch.schemaUpgradeScript.description</value>
    </property>
    <property name="fixesFromSchema">
      <value>0</value>
    </property>
    <property name="fixesToSchema">
      <value>116</value>
    </property>
    <property name="targetSchema">
      <value>117</value>
    </property>
    <property name="scriptUrl">
      <value>classpath:alfresco/module/myamp/dbscripts/create/2.9/${db.script.dialect}/patch1.sql</value>
    </property>
  </bean>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

to module-context.xml.

I get the following problem:

16:05:14,300 User:System INFO  [admin.patch.PatchExecuter] Checking for patches to apply …
16:05:14,824 User:System INFO  [admin.patch.PatchExecuter]    Applying patch 'myUpdatePatch1' (patch.schemaUpgradeScript.description).
16:05:14,831 User:System ERROR [admin.patch.PatchExecuter] The schema upgrade script, 'classpath:alfresco/module/myamp/dbscripts/create/2.9/${db.script.dialect}/patch1.sql', has not been run against this database.‍‍‍

Hi Rene!

Just wondering what you need to add a new table to Alfresco for? I don't think it's impossible but you would want to have a really good reason to do it. Can you tell us a little about it?

renspr

Hi.

Just wondering what you need to add a new table to Alfresco for? I don't think it's impossible but you would want to have a really good reason to do it. Can you tell us a little about it?

I'm working on a "Social Graph, Friend-Of-A-Friend" module similar to things you find in facebook.com or xing.com. At least this has to work with 20.000 users. To have full control how the database indexes and handles queries on that graph structure I think it is a good idea to have a distinct database table to store the graph. What do you think?

I can create the tables in code from the AMP using a component that will be executed once when the AMP ist loaded for the first time. But I think it's better to use the SchemaUpgradeScriptPatch. But this is not working for me until now. I think I have missed something.

Best regards,

RenÃƒÂ©

rdanner

Hi.

Just wondering what you need to add a new table to Alfresco for? I don't think it's impossible but you would want to have a really good reason to do it. Can you tell us a little about it?

I'm working on a "Social Graph, Friend-Of-A-Friend" module similar to things you find in facebook.com or xing.com. At least this has to work with 20.000 users. To have full control how the database indexes and handles queries on that graph structure I think it is a good idea to have a distinct database table to store the graph. What do you think?

I can create the tables in code from the AMP using a component that will be executed once when the AMP ist loaded for the first time. But I think it's better to use the SchemaUpgradeScriptPatch. But this is not working for me until now. I think I have missed something
Best regards,

RenÃƒÂ©

Hi Rene!

How does what you are building relate to alfresco? It's FOF inside alfresco ?

renspr

Hi,

How does what you are building relate to alfresco? It's FOF inside alfresco ?

Yes. Every logged in user should be able to maintain his FOAF graph. Data structure and business logic (FOAF Service) is (should be) encapsulated within an AMP. We are building our own UI so there are no planed changes to the Alfresco Webclient.