Top
Systemwalker Desktop Keeper Troubleshooting Guide
FUJITSU Software

2.2 Troubles at Database Construction

1. Error occurred when DB creation script (DTKCreateDB.sql) is being executed.


Error message

"SQL Server does not exist or access has been denied".
  * Error message of the SQL Server.

Target Version/Edition

BE V12.0L10

BE V12.0L20

BE V13.0.0

BE V13.2.0

BE V13.3.0

V14.0.0/V14.0.1

SE V12.0L20

SE V13.0.0

SE V13.2.0

SE V13.2.1

SE V13.3.0

V14.1.0

V14.2.0


Cause

It is output when it is unable to access to SQL Server for some reasons.


[Confirmation Points]

Execute the following command and confirm if the error message "SQL Server does not exist or access has been denied" is displayed.

    osql -U sa -P pass -S Server Name\Instance name
    Specify capital letters for option switch (-U -P -S).

[Resolution]

The error that occurs in the execution result of the osql command is not caused by Systemwalker Desktop Keeper. Consult Microsoft Corporation about SQL Server.


2. After the makeuser command is input, the message of "Default management user is not registered" appears, and user cannot be added.


Error message

"Default management user is not registered"

Target Version/Edition

BE V12.0L10

BE V12.0L20

BE V13.0.0

BE V13.2.0

BE V13.3.0

V14.0.0/V14.0.1

SE V12.0L20

SE V13.0.0

SE V13.2.0

SE V13.2.1

SE V13.3.0

V14.1.0

V14.2.0


Cause

The installation method of the SQL Server used in Systemwalker Desktop Keeper may contain mistakes.


[Resolution]

Install after setting [Default Installation] in the parameters during installation of the SQL Server.

During customized installation, do not modify the initial value in the setting of [Collation Sequence] (specified name of collation sequence: [Japanese], sort: [Distinguish Accent]).


3. Error occurred at 95% of processing during the database construction.


Target Version/Edition

BE V12.0L10

BE V12.0L20

BE V13.0.0

BE V13.2.0

BE V13.3.0

V14.0.0/V14.0.1

SE V12.0L20

SE V13.0.0

SE V13.2.0

SE V13.2.1

SE V13.3.0

V14.1.0

V14.2.0


Cause

Error occurs when the maximum value can be set is exceeded in the setting process of DSI automatic extension of the database being used.

Specific conditions of occurrence are:

[Occurrence Conditions]

When specifying the log cases during database construction, the case number of file operation logs (Note 1) or number of non-file operation logs (Note 2) is specified to over 62,000,000 cases.

Note 1: Calculation method of "Number of File Operation Logs": number of sets x number of file operation logs x number of months to be saved x 31.

Note 2: Calculation method of "Number of Non-file Operation Logs": number of sets x number of non-file operation logs x number of months to be saved x 31.

[Resolution]

Apply the content after emergency correction of T000302WP-01.


4. Database construction fails.


Target Version/Edition

BE V12.0L10

BE V12.0L20

BE V13.0.0

BE V13.2.0

BE V13.3.0

V14.0.0/V14.0.1

SE V12.0L20

SE V13.0.0

SE V13.2.0

SE V13.2.1

SE V13.3.0

V14.1.0

V14.2.0


Cause

An error may occur when the Windows logon ID does not satisfy the following condition.

[Resolution]

Login with the user ID that satisfies the following condition and execute again.