Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML
<span data-swiftype-index="true">
HTML Wrap
classcol span_3_of_5

Errors

This section lists the errors that may occur when checking your database.

 

Error Message

Explanation and Resolution

Invalid connection string

The connection string provided by the lookup.xml file is incorrect. This might be due to a reference to an older database that is no longer in use, or it may be a problem with your file. If the database is supposed to be working, then there is an issue with your MYOB AE/AO installation.

Please contact MYOB Support to resolve this issue.

Could not connect to the database

The MYOB AE/AO database is inaccessible. If the database is running fine for the MYOB AE/AO installations, the issue could be with permissions.

Please ensure that the person running the MYOB Invoices OnTheGo service has permission to access the database destination.

If the database is hosted in a different location to that of where MYOB AE/AO is installed, the issue could be that the person is running the service has no network access. Make sure that the person running the MYOB Invoices OnTheGo service has the appropriate privileges.

If you cannot connect to the database if may be that the connection string is invalid. See Invalid connection string above.

SQL table [AF_OnlineProvisioning] does not exist

This error could occur because the database version is invalid. MYOB Invoices OnTheGo service requires version AE 5.4.4 or later, Australia AO 2013.2 or later, or New Zealand AO 2014.0 or later.

To resolve this error, upgrade the MYOB AE/AO database, then activate MYOB Invoices OnTheGo for this database.

SQL table [AF_OnlineProvisioning] is invalid

This error could occur because the database version is invalid. MYOB Invoices OnTheGo service requires version AE 5.4.4 or later, Australia AO 2013.2 or later, or New Zealand AO 2014.0 or later.

To resolve this error, upgrade the MYOB AE/AO database, then activate MYOB Invoices OnTheGo for this database.

Database has not been provisioned to use the MYOB Invoices OnTheGo service

This error could occur because a provisioning record had not been found in the [AF_OnlineProvisioning] table. MYOB Invoices OnTheGo has not been activated for the database.

To resolve this error, follow steps 1 - 4 in Setting up MYOB OnTheGo.

SQL table [UserProperties] does not exist

This error could occur because the database version is invalid. MYOB Invoices OnTheGo service requires version AE 5.4.4 or later, Australia AO 2013.2 or later, or New Zealand AO 2014.0 or later.

To resolve this error, upgrade the MYOB AE/AO database, then activate MYOB Invoices OnTheGo for this database.

SQL table [UserProperties] is invalid

This error could occur because the database version is invalid. MYOB Invoices OnTheGo service requires version AE 5.4.4 or later, Australia AO 2013.2 or later, or New Zealand AO 2014.0 or later.

To resolve this error, upgrade the MYOB AE/AO database, then activate MYOB Invoices OnTheGo for this database.

The [PracticeToken] cannot be found in the table [UserProperties] or the [PracticeToken] is empty

This error could occur because MYOB Invoices OnTheGo has not been activated for the database.

To resolve this error, follow steps 1 - 4 in Setting up MYOB OnTheGo.

The [PracticeToken] xml format is invalid or the [CheckSum] element is missing from the [PracticeToken]

This error could occur because MYOB Invoices OnTheGo has not been activated for the database.

To resolve this error, follow steps 1 - 4 in Setting up MYOB OnTheGo.

The [CheckSum] element in the [PracticeToken] is empty

This error could occur because MYOB Invoices OnTheGo has not been activated for the database.

To resolve this error, follow steps 1 - 4 in Setting up MYOB OnTheGo.

The [CheckSum] element in the [PracticeToken] does not match the calculated check sum of the connection string in the lookup.xml file

This error could occur due to one of the following reasons:

  • The database credential changed. The lookup.xml file has been manually updated to reflect the changes.

  • The database has been moved. The lookup.xml file has been manually updated to reflect the changes.

To resolve this error, follow steps 1 - 4 in Setting up MYOB OnTheGo.



HTML
</span>
HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Using the diagnostic tool

Checking your MYOB OnTheGo service

Reading the lookup.xml file location

Loading database configurations from lookup.xml

Checking the web connections