cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Business One cannot detect server & database on subsequent application launch

Former Member
0 Kudos

SAP B1 is installed on a workstation and the SAP B1 server is installed on a server. All SAP required ports are allowed between workstation and server. From the workstation, I can telnet to the server's IP on the required ports just fine. I'm running as admin on the workstation.

Now here's the problem, if I delete all the files under %USERPROFILE%\Local Settings\Application Data\SAP\SAP Business One and run SAP B1 for the first time, it will detect my server setting and database just fine. Once I have run it for the first time, it will create the following files under %USERPROFILE%\Local Settings\Application Data\SAP\SAP Business One:

If I close SAP B1 and then launch it again, it will fail to detect the server setting and database. The server will just show (local):

The only way to fix this is to close SAP, then delete the b1-current-user.xml file from %USERPROFILE%\Local Settings\Application Data\SAP\SAP Business One. Inside the b1-current-user.xml file, it makes references to the registry.binary files in the same folder. It looks alright to me, I've looked up a few forum posts and my config looks normal.

Here's my config:

<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<!DOCTYPE configuration SYSTEM "b1-conf.dtd">
<configuration>
  <node name="REGISTRY">
    <node name="HKEY_CURRENT_USER">
      <node name="SOFTWARE">
        <node name="SAP">
          <node name="SAP Manage">
            <node name="SAP Business One">
              <leaf kind="single" name="SearchPicker" type="String">
                <value>Y</value>
              </leaf>
              <leaf kind="single" name="CFLPicker" type="String">
                <value>Y</value>
              </leaf>
              <leaf kind="single" name="TransPicker" type="String">
                <value>Y</value>
              </leaf>
              <leaf kind="single" name="DatePicker" type="String">
                <value>Y</value>
              </leaf>
              <leaf kind="single" name="CalculatorPicker" type="String">
                <value>Y</value>
              </leaf>
              <leaf kind="single" name="RoundFormatPicker" type="String">
                <value>Y</value>
              </leaf>
              <leaf kind="single" name="CFLMark" type="String">
                <value>N</value>
              </leaf>
              <leaf kind="single" name="SearchMark" type="String">
                <value>N</value>
              </leaf>
              <leaf kind="single" name="CanTranslateMark" type="String">
                <value>N</value>
              </leaf>
              <leaf kind="single" name="LogPath" type="String">
                <value>C:\Users\MyUser\Local Settings\Application Data\SAP\SAP Business One\Log\BusinessOne\</value>
              </leaf>
              <leaf kind="single" name="LogPathOverride" type="String">
                <value>N</value>
              </leaf>
              <node name="LogIN">
                <leaf kind="single" name="ServerType" type="Binary">
                  <value>C:\Users\MyUser\Local Settings\Application Data\SAP\SAP Business One\-REGISTRY-HKEY_CURRENT_USER-SOFTWARE-SAP-SAP_Manage-SAP_Business_One-LogIN-ServerType-ServerType.binary</value>
                </leaf>
                <leaf kind="single" name="Server" type="Binary">
                  <value>C:\Users\MyUser\Local Settings\Application Data\SAP\SAP Business One\-REGISTRY-HKEY_CURRENT_USER-SOFTWARE-SAP-SAP_Manage-SAP_Business_One-LogIN-Server-Server.binary</value>
                </leaf>
                <leaf kind="single" name="Company" type="Binary">
                  <value>C:\Users\MyUser\Local Settings\Application Data\SAP\SAP Business One\-REGISTRY-HKEY_CURRENT_USER-SOFTWARE-SAP-SAP_Manage-SAP_Business_One-LogIN-Company-Company.binary</value>
                </leaf>
                <leaf kind="single" name="Port" type="Binary">
                  <value>C:\Users\MyUser\Local Settings\Application Data\SAP\SAP Business One\-REGISTRY-HKEY_CURRENT_USER-SOFTWARE-SAP-SAP_Manage-SAP_Business_One-LogIN-Port-Port.binary</value>
                </leaf>
                <leaf kind="single" name="CompanyName" type="Binary">
                  <value>C:\Users\MyUser\Local Settings\Application Data\SAP\SAP Business One\-REGISTRY-HKEY_CURRENT_USER-SOFTWARE-SAP-SAP_Manage-SAP_Business_One-LogIN-CompanyName-CompanyName.binary</value>
                </leaf>
              </node>
            </node>
          </node>
        </node>
      </node>
    </node>
  </node>
</configuration>

I have tried going to C:\Program Files\SAP\SAP Business One\Conf and C:\Program Files (x86)\SAP\SAP Business One\Conf and deleted the b1-current-user.xml and then repeat the above steps again, same issue. I have checked the b1-local-machine.xml and it has the correct server settings and port no problem. Again, the issue only occurs on subsequent SAP launches, but it is not an issue for the first launch.

My admin has full control access to the %USERPROFILE%\Local Settings\Application Data\SAP\SAP Business One folder, so it's not a permission issue either. The SAP services on the server are all running OK.

I've also tried using a newly created local administrator account on the workstation and tested, still the same issue.

Accepted Solutions (0)

Answers (0)