New Afaria Installation

[former_member197903]

db-error.jpgHello Team,

We currently have Afaria Server installed since SP4 to SP27 and we would like to decommission the servers. and created new servers.

For new servers do we need to Install the Afaria from SP04 to SP27 or just SP27 installation is fine ?

We have SQL17 db, we will copy from old server and connect on new server. Do we need any extra procedure here ?

Regards,

Vinayak

[former_member105680]

Hello VP,

I highly recommend following our best practice moving Afaria server to another system. See following KBA for more details:

https://launchpad.support.sap.com/#/notes/1990189

Thanks,

Aziz

[former_member197903]

Can we setup new server with directly installating SP27 ? or need to start from SP04 to SP27 ?

[former_member186998]

Hi VP,

I think that requires either every service pack along the released upgrade path.

2540303 - Afaria Upgrade Path - Service Pack Application

Thanks,
Atsushi

[former_member197903]

I dont need answer in assumation, i need extact answer that can we setup new server with SP27 or need to come from SP05 ?

[former_member186998]

Hi VP,

I confirmed this matter.
The answer to that is the following.
Each SP will only upgrade from the previous two but you can start new any time. So just install SP27 for a new server.

Thanks,
Atsushi

[former_member197903]

Thank you for the confirmation.

I get the error as attached in question. I have taken backup of db SQL17 of Afaria SP27 and on new server i copied the backup file, created new service, and during Afaria SP27 installation i get the error as in attached file.

Error:

The Afaria database selected does not have a collation configuration that is case insensitive and accent sensitive for NCHAR data type.

Cancel and choose a new database with a collation that is case insensitive and accent sensitive. Otherwise, if you select OK and continue with the current installation, it is possible that some Afaria features may not work properly because of these settings.

We have already tried with case sensitive but no luck.

Regards,

VP

[former_member186998]

Hi VP,

This problem corresponds to the following note.
1959803 - Afaria doesn't support case-sensitive database environments
You must rebuild database according to this note.

Thanks,
Atsushi

[former_member197903]

Could you please provide us the step by step to unload and reload the data on new database.

[former_member186998]

Hi VP,

You must create new database in conformity with database requirements. And you load data of original database in new database.

1. Create a new database.(case-sensitivity = Ignore)
Initialization utility (dbinit)
Database Requirements
Preparing an SAP SQL Anywhere Database

For example:
dbinit -p 8192 -z "UCA(CaseSensitivity=Ignore;AccentSensitivity=Respect)" -zn "UCA(CaseSensitivity=Ignore;AccentSensitivity=Respect)" -i -t "Afaria.log" "C:\temp\new\Afaria.db"

2. Reload the data which unloaded an existing database to a new database.
Unload utility (dbunload)

For example:
dbunload -c "UID=DBA;PWD=passwd;DBN=old;DBF=C:\temp\old\Afaria.db" -ac "UID=DBA;PWD=passwd;DBN=new;DBF=C:\temp\new\Afaria.db"

If the new database must have the same file name as the original database, then use the DBN connection parameter to give each database a unique temporary name. The following command loads a copy of the old database into a new database that has the same file name Afaria.db.

Thanks,
Atsushi

[former_member186998]

Hi VP,

We provide following KBA.

2338319 - Supported upgrade paths - Afaria

> We have SQL17 db, we will copy from old server and connect on new server. Do we need any extra procedure here ?
When you set up Afaria Server, you only choose this database. Of course it is necessary for you to start a database.

FYI
2363629 - About database(SQL Anywhere) support of Afaria 7 SP17
Upgrade Step 3-4

Thanks,
Atsushi

[former_member197903]

Can we setup new server with directly installating SP27 ? or need to start from SP04 to SP27 ?