# Server ID Shows as $action.serverId,$action.sid or n.v.

#### お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

## 症状

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.

## 原因

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.

## ソリューション

#### 原因 #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. 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 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. Confluence を再起動します。

#### 原因 #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.

BANDANAIDBANDANACONTEXTBANDANAKEYBANDANAVALUE
6_GLOBALconfluence.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. Confluence を再起動します。