You are viewing limited content. For full access, please sign in.

Question

Question

Laserfiche Server version for a Database with a schema of 7.2.1

asked on November 15, 2021

Hi all,

 

Just a quick question, which Laserfiche Server version does a Database with a schema of 7.2.1 belong to?

One of our customer’s Laserfiche Server crashed but their Volumes and Databases were intact on a separate hard disk drive. We saw on one of their client computers that they’re using Client 9.1, we didn’t know which Server version they were using so we just assumed it was also Server 9.1. We were able to attach their Databases on a SQL Express 2014 instance, and installed Server and Client 9.1 on a test machine. When we tried registering the repository we received a "9110 - The database schema is the wrong type or is not a supported version.". And when we checked the schema version, it was 7.2.1.

 

Any info would be greatly appreciated, thank you.

0 0

Answer

SELECTED ANSWER
replied on November 15, 2021

As John said, if they were using version 9.1 of the desktop client, this is not the correct database as the desktop client needs to be on the same or a lower version as the server.

If they were using version 7, then you will need to migrate to version 9.

1 0

Replies

replied on November 15, 2021

If one client was 9.1, I would just install the latest version unless there is a reason not to. It will auto upgrade schema from version 8+ and the thick clients are backwards compatible.

If it really is a 7.2.1 schema(not sure where this is coming from) you will need a special upgrade program.

1 0
replied on November 15, 2021

Thank you for the response John. We did try registering the repository on a Server (and Client) 10.4.3 install, however it did not auto upgrade the database schema, we received the same "9110 - The database schema is the wrong type or is not a supported version." error message.

We ran this SQL query on the database and found out it is 7.2.1.

SELECT [optionname]
      ,[optionvalue]
  FROM [dboptions]
  WHERE [optionname] = 'version'

0 0
SELECTED ANSWER
replied on November 15, 2021

As John said, if they were using version 9.1 of the desktop client, this is not the correct database as the desktop client needs to be on the same or a lower version as the server.

If they were using version 7, then you will need to migrate to version 9.

1 0
replied on November 15, 2021

Thank you Miruna, we'll see about migrating their database to version 9.

0 0
replied on November 15, 2021

Are you sure it is the correct database and not an old backup? Are the modified dates on the files recent? If you look in the TOC table, what's the latest value in the "modified" column?

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.