Support

From Fishbowl

Jump to: navigation, search
Support
Related Pages
iReport
Create an Online Account
Release Notes
Fishbowl Flow Chart
Fishbowl Road Map
Fishbowl Hosted Services
Fishbowl Hot Keys
Supported Operating Systems
Supported QuickBooks Versions

Contents

Renew Support Contract
Jump to top of page

You can check the status of your support contract by clicking the License key status Icon Button.png License key status button near the top-right corner of the client.

Renew Support Contract.png

The support contract can be renewed online at anytime by clicking the blue link at the bottom of the message. For more information, contact your Account Sales Executive.

Extend the Client Inactivity Time
Jump to top of page

The following instructions will allow each client to have a longer inactivity time (the Fishbowl server will need to be stopped during this process):

  1. Right-click the Fishbowl Server icon in the system tray and select Options.
    Server Options.png
  2. Select Yes to stop the server and disconnect all users.
  3. Click the Server tab, adjust the Inactivity Time, and then click OK.
    Client Inactivity time.png
  4. Right-click the server icon and select Start.

Adjust memory allocation

The amount of memory allocated to Fishbowl can affect the performance of Fishbowl and the performance of the computer. If the amount of memory is too low, Fishbowl may run slowly. If the amount of memory is too high, the computer may run slowly. Based on the amount of memory that is available on each computer, the Fishbowl installer will automatically estimate the ideal amount of memory to allocate to Fishbowl. If necessary, the amount of memory can be manually adjusted during installation or after installation.

Memory allocation during installation

If Fishbowl is being installed or upgraded, the amount of memory allocated to Fishbowl can be adjusted during installation. Click here if Fishbowl has already been installed.

Follow the steps below to adjust the Fishbowl memory allocation during installation.

  1. Run the Fishbowl installer and proceed to the Installation Mode step.
  2. Select Current Fishbowl User and then check Configure Advanced Settings.
    Advanced Install Settings.png
  3. Proceed to the Memory Settings step and adjust the memory allocation as desired.
    Adjust Memory During Install.png
  4. Complete the installation wizard as usual. Repeat these steps on each Fishbowl computer.

Memory allocation after installation

Memory allocation can also be adjusted after Fishbowl has already been installed. Click here if Fishbowl is being installed or upgraded.

Follow the steps below to adjust the Fishbowl Server memory allocation after installation.

  1. Right-click the Fishbowl Server icon in the system tray and click Options. Then click Yes to stop the server and disconnect all clients.
    Server Options.png
  2. Click the Server tab and adjust the server memory allocation as desired and then click OK.
    Adjust Server Memory After Install.png
  3. Right-click the Fishbowl Server icon in the system tray and click Start to start the server again.

Follow the steps below to adjust the Fishbowl Client memory allocation after installation.

  1. Open the C:\Program Files\Fishbowl\client\bin folder. The actual path may vary depending on where Fishbowl was installed.
  2. Open the Fishbowl Client.vmoptions file in a text editor, such as Notepad.
  3. Enter the amount of memory desired for the Fishbowl Client.
    Adjust Client Memory After Install.png
  4. Save and close the file. Repeat these steps on each Fishbowl Client computer.

Export Fishbowl Table Data via Excel
Jump to top of page

Data can be queried and exported from Fishbowl by using the Small.Data.png Data module.

Defining the Status terms within Fishbowl
Jump to top of page

Several Modules within Fishbowl have a status column describing the current position the line items or overall order is in. The following list describes the status for Modules within Fishbowl:

Pick Status

Depending on each item's situation, they will have a specific type of Pick Status. The first column of information in the Pick's Order screen is the Line Status. This field is populated by one of seven icons (shown below):

Receiving Status

Within the Small.Receiving.png Receiving module users have the ability to receive and reconcile the order in its entirety (which is done by using the module toolbar icons) or they may receive and reconcile each line item individually (which is done by using the component toolbar). Whether the order is completed in its entirety, or by each line item, the following status descriptions remain true:

Purchase Order

The status for the Purchase Order is found in the top right corner of the Purchase Order General subtab. This does not reflect the line item status, rather the order in its entirety.

Sales Order

Database maintenance
Jump to top of page

We recommend that you run database maintenance about once a month. To run database maintenance, open the Fishbowl Server Administration application. This can be found in the program list under Fishbowl or by browsing to C:\Program Files\Fishbowl\server\bin\Fishbowl Server Administration.exe.

Fishbowl Server Administration Maintenance.png

On the Database tab, right-click the database and select Database Maintenance.

Viewing the database
Jump to top of page

The data stored in the Fishbowl database can be viewed in the Small.Data.png Data module. This is helpful for extracting specific data used for reporting, or for troubleshooting.

Viewing the log files
Jump to top of page

Fishbowl will log any errors to text files stored in the logs folder (default location is C:\Program Files\Fishbowl\logs). Follow these steps to check for an error when something unexpected happens in Fishbowl.

  1. Open the fbserver.log and fbclient.log files.
  2. Scroll through the document looking for indented text. Often this text will contain some information about what is causing the error.
  3. If the problem persists, make a copy of the log files and have them accessible when contacting Fishbowl support.

The logging level can also be increased to show more detail and some of the database queries.

  1. Double-click the server tray icon.
  2. Select the Logging tab.
    Logging level.png
  3. Move the slider and/or select the option to show queries.

Run eve.bat and client.bat

When troubleshooting a problem in Fishbowl, it may be helpful to use the .bat files to run Fishbowl. This will open an additional window that displays errors and information that may not be visible when running Fishbowl in the traditional way.

NOTE: It is usually easier and faster to view the log files, instead of running eve.bat and client.bat.

Follow the steps below to launch the Fishbowl Server using eve.bat

  1. On the server computer, open the C:\Program Files\Fishbowl\server\bin folder. The actual path may vary depending on where Fishbowl was installed.
  2. Double-click the eve.bat file.
  3. Important information and errors will be output to the command window.
    Fishbowl Server Console.png

Follow the steps below to launch the Fishbowl Client using client.bat

  1. On the client computer, open the C:\Program Files\Fishbowl\client\bin folder. The actual path may vary depending on where Fishbowl was installed.
  2. Double-click the client.bat file.
  3. Important information and errors will be output to the command window.
    Fishbowl Client Console.png

Error messages are typically indented, making it easier to spot the issue. Reading the error message, or having the error message text available when calling Fishbowl Support can often help resolve the issue more quickly.

Troubleshooting
Jump to top of page

Understanding Fishbowl Errors

Many Fishbowl errors will be displayed in a window similar to the one below. Some error windows may also display a proposed fix to the problem. For example, the message below indicates that the street is missing from the address.

Fishbowl Error.png

Clicking the Double Arrow Icon Button.png Double Arrow button will display more information about the error.

Expanded Fishbowl Error.png

Clicking the Copy Icon Button.png Copy button will copy all information about the error to the clipboard, allowing the error to be pasted into an email or saved for reference.

Clicking the Check for Fix link will open a page on the wiki that may contain more information about fixing the error.

Server is Unable to Connect to Database

Error: The Fishbowl Server is unable to connect to database

Reason: During the install, part of Fishbowl may have been blocked by firewalls and/or anti-viruses on the computer. Or Firebird may need to be reinstalled.

Resolution: Reinstall Fishbowl

If you continue to experience problems with the database connecting, contact technical support at 800-774-7085 ext 3

Server unable to connect.png

Client is Unable to Connect to Database

Error: The Fishbowl Client was unable to successfully connect to your database

Reason: The Server Address and Server Port could be incorrect on the client machine. The client would also not connect if the Fishbowl Server was not started on the server computer.

Resolution:

Click on the details tab on the client login screen. Next, click on the Search Button.png Search button by the server address field and make sure the IP address being broadcast is the same as your server IP address. You can check your server IP address by right clicking on your Fishbowl server icon (on the server computer) and going up to show. Your IP address and port number will be displayed here. Whatever IP address and Port number showing on the server is what each client will also need in order to connect.

On your server computer make sure your Fishbowl server is running in the system tray. If it is not, start the server on that computer and then try to connect your client.

Client unable to connect.png

Username and Password

Error: Unknown username and password

Reason: The password or username is incorrect or not recognized by Fishbowl as valid.

Resolution: Check to see if the keyboard is on CAPS LOCK. Passwords are case-sensitive. On new databases and the Bicycles database, the default username is admin and the and password is admin.

Username: admin

Password: admin

Unknown username and password.png

In the event that the admin password is forgotten, Fishbowl Support can reset the password.

Errors when starting the Fishbowl Service

If you are having problems starting the Fishbowl Service, try doing the following:

Error:

"Database appears to have problems. Please contact Fishbowl for assistance."

  1. Make sure that the Firebird Service is running as a true service and that it is started and set to automatic. To check this go to Start | Control Panel | Administrative Tools | Services and search for the Firebird Server (fbserver).
  2. Make sure that the database file that you are trying to open actually exists in the Fishbowl\Database\Data directory.
  3. Disable any personal/software firewall programs on the server computer. Any hardware firewalls should be ok. Port 28192 and port 3050 needs to be open.
  4. Uninstall and reinstall Fishbowl. During the reinstall make sure that the user of the computer is logged in as the administrator so that the Firebird Service may be installed properly. Also during the reinstall make sure that any software firewall, anti-virus and spam blocking software are completely disabled.

Error:

"Unable to complete network request to host 'localhost' "

  1. First reboot the computer. By default the Fishbowl Service is set to start when the computer is turned on. Once the computer is turned on see if the Fishbowl service appears in the System Tray of your computer and that the status light has turned to green. If that doesn't do it then continue to step 2.
  2. Make sure that the Firebird Service is running as a true service and that it is started and set to automatic. To check this go to Start | Control Panel | Administrative Tools | Services and search for the Firebird Server.
  3. Make sure that the database file that you are trying to open actually exists in the Fishbowl\Database\Data directory.
  4. Disable any personal/software firewall programs on the server computer. Any hardware firewalls should be ok. Port 28192 needs to be open.
  5. Uninstall and reinstall Fishbowl. During the reinstall make sure that the user of the computer is logged in as the administrator so that the Firebird Service may be installed properly.

Begin Session Error

Begin Session Error 2.png

Possible error messages

Resolutions:

  1. Open QuickBooks
    • Make sure QuickBooks can launch on the same computer that the Fishbowl Server is running.
    • Try to open QuickBooks, if you get an error message from QuickBooks that reads "There appears to be a problem with the database service that is managing access to the company file. QuickBooks can attempt to fix the database service. Would you like QuickBooks to fix the problem?" Click yes to this error message.
    • The export to QuickBooks should now work.
  2. Restart QuickBooks
    • Make sure QuickBooks can launch on the same computer that the Fishbowl Server is running.
    • If QuickBooks will not start, in the task manager under Processes, check the box at the bottom that says Show processes from all users.
    • End any tasks that says Fishbowl, java.exe or javaw.exe as these are part of Fishbowl.
    • Also, end the process QBW32.EXE as this is part of QuickBooks.
    • Now restart both QB and FB and continue steps 1-2 above.
  3. Reconfigure Fishbowl's Accounting Configuration
    • Make sure QuickBooks can launch on the same computer that the Fishbowl Server is running.
    • Open the accounting module in Fishbowl.
    • Go to the Configuration tab.
    • Click "Test Connection" if the connection is green you should be able to export.
    • If the connection fails click the accounting configuration wizard button
    • Complete the configuration wizard. Note: Be sure you do your account mapping are correct on step 4 of the configuration wizard by selecting "Choose from existing QuickBooks accounts".

Invalid Reference to QuickBooks Sales Rep

Error: The Fishbowl user "admin" does not have a QuickBooks sales rep with matching initials (ADM).

Reason: The specified sales rep in the error does not exist in the sales rep list in QuickBooks. If they do exist, their initials have been changed and are not identical to the initials for that sales rep in Fishbowl.

Resolution: In QuickBooks, go to Lists | Customer and Vendor Profile Lists | Sales Rep list. Find the name of the sales rep trying to export over and make sure the initials shown for them are identical to the initials given in Fishbowl (Note: even spaces will make a difference). If the sales rep does not exist in QuickBooks, create the rep with the exact same initials given in Fishbowl and then export again.

QB salesrep error.png

Invalid Reference to QuickBooks Customer or Vendor

Error: Bob Jones already exists in one of these QuickBooks' lists. Sales Rep, Customer, Job, Vendor, Employee.

Reason: Neither QuickBooks nor Fishbowl allows the same name to be used for customer, vendor, or employee. If the name already exists in one of those areas it will need to be modified in QuickBooks.

Resolution: Go to QuickBooks and find the specified customer name under the vendor, customer, or employee list. (For example, if you had the error on a customer name, that customer likely already exists in QB as either a vendor or employee. If the error is on a vendor name, that name likely already exists in QB under the customer or employee list) Wherever the name is found, you will need to slightly modify it so Fishbowl can create the name under either the vendor or customer list when it exports.

For Example, if you had the customer name of Bob Jones on a FB invoice, and had that same name in QuickBooks as a vendor, you would need to go to QuickBooks and change Bob’s name under the vendor list. You then need to create Bob Jones as a customer in QuickBooks exactly as he is created in Fishbowl. (Note: You have the choice to just change the vendor name and then export again. Fishbowl will automatically create the customer name in QuickBooks)

Invalid Reference to Customer.png

Personal tools
Namespaces
Variants
Actions
Navigation
Other Pages
Toolbox
Print/export
Translate