Salesforce

SAP Business One Troubleshooting (Magic xpi 4.5)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

SAP Business One Troubleshooting (Magic xpi 4.5)

Q1

Why can't I connect to SAP Business One?

A1

If you have problems connecting to SAP Business One from Magic xpi, verify that there is a connection to SAP Business One through the DI/API (for example, using VB).

SAPB1 2004 and 2005 are not supported on the Windows 2008 operating system. Therefore, if you try to work with one of these SAPB1 versions, you will not be able to create a connection to SAP Business One.

Q2

Why am I getting the "SAPB1 Error: Connection to the License Server Failed" error?

A2

This error comes from SAP Business One and it means that while trying to create a connection to SAP Business One there was a problem connecting to the SAPB1 license server.

This problem can be caused by the following:

  • Wrong connection details: Magic xpi uses the XML interface of the DI to connect to SAP Business One. Therefore, check that there is a connection to SAP Business One using an external tool, such as VB.

  • The SAP License Server is down or there is a network problem – Look for network problems if the License Server is on a remote machine, and check whether the License Server is up and running.

  • When Magic xpi is installed on the same machine as the SAPB1 and the SAPB1 connections are referencing localhost, other users logging in on terminal services will have a problem logging in to the SAPB1 client. The reason is that whenever an SAPB1 connector is accessed in the project, the LSRV field in the SLIC table in SBO-COMMON is updated with localhost instead of the IP address of the server. Consequently, a terminal server user will not be able to log in. The solution is to replace the reference to localhost with the IP of the server.

  • You have reached the number of concurrent users allowed by your license – Magic xpi uses the compatibility license to connect to SAP Business One. Therefore, check that it is not an SAPB1 license issue (too many users are connected).
    Note: Magic xpi opens the connection when you first try to connect to a new company and then reuses the connection (Magic xpi gets a reference to the SAPB1 company object and reuses it).

If everything checked out and you are still getting this error, we suggest contacting SAP Business One.

Q3

What are the mandatory parameters?

A3

If you do not know what the mandatory parameters are when you add an object, you should add the object from the SAP Business One client (mandatory fields only). You should then query the object from Magic xpi to see the parameters and their value in the XML.

Q4

Why is my Stored Procedure cleared?

A4

When you upgrade the SAP Business One version that is installed on your machine, the Stored Procedure is cleared, and you should create it again. If the trigger does not work, verify that the Stored Procedure exists.

Q5

Why can't I add and update objects?

A5

If you have problems when you add or update an object, you can check that the XML that was passed to SAP Business One by looking in the <Magic xpi installation>\Runtime\Temp folder, or in the UserXML. This enables you to identify where the problem is. However, this is relevant only when you are using the XML interface of the connector.

Q6

How can I overcome the "Connection to the requested SAP Business One Company database could not be established. Internal error (10): Failed to load object: SAPbobsCOM.Company" error?

A6

This error occurs when a DI API is not installed on the machine. Magic xpi communicates with SAP through the DI API. You should therefore ensure that the DI API is installed on the server where Magic xpi is installed.

Q7

Why is Magic xpi crashing when a SAPB1 step runs?

A7

This problem occurs when the wrong DI version is used. To make sure you are using the relevant DI version, you should enter the correct value in the SAPB1 resource's DI API Version parameter.

Q8

When SAPB1 is installed on my machine, the Magic xpi Studio fails to open. Why?

A8

Set the jvm_path in the magic.ini file and restart the Magic xpi Studio. This should solve the problem.

Related Topics

Reference
Attachment 
Attachment