v24.4 database creation

[Michael Ham]

I would like to build my clean database using DB Load and not the One Installer. I can't find a list and order of schema files to load. Is one available?

[Markus Embacher]

Hi Michael,

use DBLoad and provide it with \Automation.Platform\db\general\24.4\UC_UPD.TXT as the input file. This file contains all the instructions to build the schema. DBLoad will handle all the required steps internally.

Regards, Markus

[Michael Ham]

I've reproduced this twice. Suggestions?  DB Load, select upgrade file...

U00037180 Collation in Database: 'Latin1_General_100_CI_AS_SC_UTF8'.

U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: dedc9610  DB-HDBC: dedccac0

U00003591 UCUDB - DB error info: OPC: 'SQLExecDirect' Return code: 'ERROR'

U00003592 UCUDB - Status: '42S02' Native error: '208' Msg: 'Invalid object name 'UC_VERSI'.'

U00003592 UCUDB - Status: '42000' Native error: '16945' Msg: 'The cursor was not declared.'

Cannot convert to text/ntext or collate to 'Latin1_General_100_CI_AS_SC_UTF8' because these legacy LOB types do not support UTF-8 or UTF-16 encodings

[Michael Dolinek]

Hi @Michael Ham

if you are using Windows, please do not forget to configure those Windows machines properly where the AE or the Utilities are executed. You should also consider applying this OS-setting where Windows-Agents v24.0 (and up) are running.

Windows Settings > Time & language > Language & region > Administrative language settings > Change system locale, and check Beta: Use Unicode UTF-8 for worldwide language support

The naming might vary depending on the Windows version used.

see https://docs.automic.com/documentation/webhelp/english/AA/21.0/DOCU/24.4.0/Automic%20Automation%20Guides/Content/Installation_Common/PreparationSteps/PrepareAEDB_MSSQL.htm

Michael

------------------------------
Michael K. Dolinek

Engineering Program Manager | Agile Operation Division
Broadcom Software
------------------------------

[Michael Ham]

Replaced the new database. I attempted to load the initial file for DB load with success. I've made progress now.  Please confirm that loading the uc_ini.txt file is correct.

[Markus Embacher]

uc_ini.txt is loaded by uc_upd.txt automatically. It's not required to load it manually

[Michael Ham]

I have to admit that I missed the translation character data option in the ODBC connection.  Correcting that allowed an install with the uc_upd.txt DB Load.

>>>When creating a new data source to SQL Server, do not select the checkbox Perform translation for character data.