Symptoms

1. When looking at the Server ID field in Administration >> License Details, the value $action.serverId appears. This may result in an upgrade problem documented at CONF-10576.
2. When looking at the Server ID field in Administration >> License Details, the value $action.sid appears. Or when looking at the Server-ID field in Administration >> System Information, the value n.v. appears.

Cause

1. There is no Server ID on the database.
2. There is a Server ID on the database, but it's somehow malformed and hence Confluence couldn't pick it up.

Resolution

Always backup your data before performing any modifications to the database.

Cause #1

1. If you are using Confluence 3.x and above, to find your Server ID:
   
   1. Open <your-confluence-home-folder>/confluence.cfg.xml

   2. Find the confluence.setup.server.id property:

      <property name="confluence.setup.server.id">XXXX-XXXX-XXXX-XXXX</property>

      Note the Server ID

   3. Proceed to Step 3
      
      
2. If you are using Confluence 2.x you will need the below jsp to view your Server ID:
1. Shut down Confluence
2. Put the serverid.jsp in <your-confluence-insall-folder>/confluence/admin/
3. Start Confluence again.
4. Visit http://confluence.example.com/admin/serverid.jsp (changing the URL to point to your Confluence installation).
   
   

3. Check the Server ID in the database:

   select * from BANDANA where bandanakey = 'confluence.server.id';

   It should return an empty result. If so, proceed with the next step. Otherwise, it should be the cause #2.

   
   

4. Insert the correct Server ID by running the following SQL query against Confluence database:

   INSERT INTO BANDANA VALUES (FREE-BANDANAID-VALUE, '_GLOBAL', 'confluence.server.id', '<string>Your-Server-ID</string>');

   Please remember to change Your-Server-ID to your server ID value.

   Please remember to change FREE-BANDANAID-VALUE to a free ID value. The BANDANAID value for the serverID is one of the earliest entries in the bandana table (less then 20) so if it is missing there will be a gap in the sequence. Use the value of the missing entry for FREE-BANDANAID-VALUE in the above insert statement. If there is no gap, increment the highest value that is two digits or less by one and use that.

5. Restart Confluence

Cause #2

1. Ensure that the Server ID in the database is in correct format. It should look something like this in BANDANA table, otherwise, Confluence won't be able to understand it.

   BANDANAID	BANDANACONTEXT	BANDANAKEY	BANDANAVALUE
   6	_GLOBAL	confluence.server.id	<string>XXXX-XXXX-XXXX-XXXX</string>

   Note the string tag.

    

2. If it is not correct, modify it by running the following SQL query:

   update BANDANA set bandanavalue = '<string>XXXX-XXXX-XXXX-XXXX</string>' where bandanakey = 'confluence.server.id';

3. Restart Confluence