Maintenance and Troubleshooting

quicksandwalleyeInternet and Web Development

Oct 31, 2013 (3 years and 8 months ago)

280 views

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training


Anti
-
virus


Database


ODBC


Application Server


7i Server


Network


Managing Server Resources


Common Troubleshooting


Support Website

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

Anti
-
Virus

Should be from a major software provider

Should include Spyware protection

*Not provided by SBI

Recommended for all computers that access
IFAS

Should be set to update automatically

Please remember it is your responsibility to
maintain server protection!

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

Transaction Log Management

Ensure Transaction Logs are being reset /
cleared on schedule

Verify the logs are sized appropriately for
your transactions


File System Maintenance

Checkdsk (Windows)

Defrag (Windows)

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

Database


Rebuilding Indexes / Statistics

Indexes should be rebuilt weekly, or
immediately after a large data load

Table space Management

Be proactive!

Monitor available capacity, expand before
it’s needed!

Review Log Files!

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

ODBC


SQL Server

Trusted vs Non
-
Trusted

Trusted connections validate with the locally
authenticated Windows User

Non
-
Trusted requires a username/password

Dynamic Ports

By default, SQL Server utilizes dynamic ports

If a firewall is between SQL Server and client, static
ports will be required

Static Ports

Default static port is 1433

A new port will be required for each additional instance

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

Application and 7i Server

Windows Maintenance

Apply Windows Security Updates

Point Windows server to a Time Server (ntp)


File System Maintenance

Checkdsk (Windows)

Defrag (Windows)


Anti
-
virus

Maintain current and updated Antivirus software

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

Managing Server Resources
-

Windows

Use the Performance Monitor provided with Windows
to monitor System over time

Typical monitor points are:

CPU

Idle time

RAM

Available

The IFAS Services

Network Reads/Writes

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

7i Server

Review your Event Viewer

Errors encountered by end users will frequently be
recorded in the Application Log

File System Cleanup

.xml files generated from CDD are deposited in c:
\

or
c:
\
inetpub
\
wwwroot
\
IFAS7
\
cddxml

Old Installation files (Backups) “x:
\
Program
Files
\
SunGard
\
backup”

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

Common Troubleshooting


Provide the following information when calling
helpdesk for support.

Version and build (listed in registry)

Last time you had an update

During what process did the problem occur

What has changed or occurred recently at the
site

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

Troubleshooting

Network

Turn off unnecessary protocols

Make certain your DNS servers are live

Make sure ports 1433 SQL, 80 HTTP, 636 SSL LDAP, 389
LDAP, 3268 are open

It is best to keep the 7i servers and database/application
server on the same physical network device


Network
-

Security

For Web Servers accessible outside of the network, employ a
DMZ

SSL is Supported for our Web Based Products

SSL Certificates can be created by the client, or purchased
from a reputable Vendor

Remember, the greatest risk comes from within!

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

Troubleshooting SQL DB Server


-
If your ODBC connection to the SQL DB
Server does not allow you to connect using a
SQL user like bsidba. Make sure that mixed
mode authentication (SQL Server and
Windows Authentication mode) is turned on.
Check the properties of the Server (Instance
Level). Restart the instance

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

Troubleshooting

Application Server


-
Make sure IUSR_IFAS matches across all servers and is a
member of the administrators group

-
Under Services make sure ipc_daemon is owned by
IUSR_IFAS and the password is set correctly.


Telnet session is not working properly

-
Go to properties on my computer/advanced

-
Environment variables

Under user variables for home make sure the value is set to:

%HOMEDRIVE%%HOMEPATH%

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

Troubleshooting 7i Server

Data Processing Services does not appear:

In command prompt, navigate to the /Program
Files/SunGard/bin run these in order

btnetsvc /unregserver

btmqhost /unregserver

btmqhost /regserver

btnetsvc /service


To re
-
register the Workflow service, issue these
commands from the same location, again observing
the order listed:

btwfsvc /unservice

btwfeng /unregserver

btwfeng /regserver

btwfsvc /service

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

Dcomcnfg Configuration

Go to start
-
> run and type in dcomcnfg.


This pulls up the component services
menu.


Then click on component services, computers, my computer, DCOM config

Bi
-
Tech Admin Application

Identity Tab
-

Under the Identity tab the "The launching user" option should be selected.

Bi
-
Tech Cold Storage Print Service

Identity Tab
-

Under the Identity tab the "This user" option should be selected. The "User"
should be IUSR_IFAS (IUSR_IFAS should be a user local to the server.) To choose
IUSR_IFAS click on the "Browse" button. Then in the "Browse for Users" window first
make sure that the drop down box labeled "List Names From:" has the servers name in it.
Then highlight IUSR_IFAS under the "Names" list and click the "Add" button. Then click
on the OK button to return to the "Identity" tab. Enter IUSR_IFAS's password in the
"Password" and "Confirm Password" text boxes. Click on the "OK" button to accept the
changes

Bi
-
Tech IFAS Service Manager

Identity Tab
-

Under the Identity tab the "The System Account (Services only) option
should be selected.

Bi
-
Tech Message Processing Host

Identity Tab
-

Under the Identity tab the "This user" option should be selected. The "User"
should be IUSR_IFAS (IUSR_IFAS should be a user local to the server.)

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

Bi
-
Tech Pooled Object Manager

Identity Tab
-

Under the Identity tab the "This user" option should be selected. The "User"
should be IUSR_IFAS (IUSR_IFAS should be a user local to the server.)

Bi
-
Tech Report Server

Identity Tab
-

Under the Identity tab the "This user" option should be selected. The "User"
should be IUSR_IFAS (IUSR_IFAS should be a user local to the server.)

Bi
-
Tech Trace Application

Identity Tab
-

Under the Identity tab the "The launching user" option should be selected.

Bi
-
Tech Workflow Engine

Identity Tab
-

Under the Identity tab the "This user" option should be selected. The "User"
should be IUSR_IFAS (IUSR_IFAS should be a user local to the server.)

Bi
-
Tech Workflow Service

Identity Tab
-

Under the Identity tab the "The System Account (Services only) option
should


When done with dcomcnfg run an
IISRESET

-
Click on Start > Run

-
In the Run text box enter the command iisreset and click on the OK button.


A window will
appear stating it is Shutting Down Internet Information Services (IIS)

and then will show
that is it Restarting IIS.


When this window goes away, IIS on the server

has

been reset.

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

Internet Explorer Errors

Error 404 Page not found

Error 408 Request Time out

Error 500 Internal Server Error


Typical Internet Explorer
Configuration

Trusted Site

Allow pop
-
ups

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

7i pages

http://<webserver>/IFAS7

http://<webserver>/IFAS7/home

http://<webserver>/IFAS7/home/customize

http://<webserver>/IFAS7/home/finance/activeusers.ascx


DO

http://<webserver>/IFAS7/Documents/CDDReports.aspx

http://<webserver>/IFAS7/Documents/IFASOutput.aspx

http://<webserver>/IFAS7/Jobs/Monitor.aspx


AO

http://<webserver>/IFAS7/home/applicant


EO

http://<webserver>/IFAS7/emponline


BO

http://<server>/ifas7/bidonline

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

Request Broker

The Request Broker information
page is available on the
“Request Broker” tab.

This page provides basic
statistical information about the
performance of request
processing on the server.

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

Flush Server Cache

For performance reasons the 7i Servers
cache a lot of information.

However, updates may take place during
the normal business hours that require
the servers to release the cached
information and fetch the updated
versions.


A tool on the tools panel of this plug
-
in
allows the user to execute a Flush Cache
request to the server.

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

To clear the cache:

In System Admin 7i Server Admin
\
Utilities
\
Monitor Server
\
Flush Server Cache

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

Status Log

The plug
-
in
maintains a history
of the server’s
monitoring
processes in the
“Status Log” tab.

This allows the
administrator to
look back a the
history of this
server’s status
checks.

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

At http://support.bi
-
tech.com you can find:


Knowledge Base Link

Known Issues

Library

Division name or
department here

PROPRIETARY INFORMATION

Maintenance and Troubleshooting

BusinessPLUS System Administrator Training

Questions?


Related Knowledge Base Items:

5542 Master Index for PC Products

6121 Failed to Open Nucleus Socket Error

7155 Workflow Models Missing