Skip to Content
1

B1WS Error -226

Dec 11, 2017 at 10:50 AM

110

avatar image
Former Member

Hi,

what does B1WS Error -226 mean? I am unable to get an error with text description.

Kind regards,

Kevin

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Victor Nilo Feb 28 at 09:18 PM
0

I am having the same issue. Happens when I call login function with the following information:

  'DatabaseServer' => '192.10.10.2',
  'DatabaseName'   => 'TEST',
  'DatabaseType'   => 'dst_MSSQL2012',
  'CompanyUsername'=> 'manager',
  'CompanyPassword'=> 'holypassword',
  'Language'       => 'ln_Spanish',
  'LicenseServer'  => '192.10.10.2:40000'

When I put wrong information in purpose I receive several descriptive error messages (as expected).

Please, help us. In my case, this is driving me crazy...

Share
10 |10000 characters needed characters left characters exceeded
Victor Nilo Mar 01 at 04:41 PM
0

Also tried with SOAP UI

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:log="LoginService">
   <soapenv:Header/>
   <soapenv:Body>
      <log:Login>
         <!--Optional:-->
         <log:DatabaseServer>192.10.10.2</log:DatabaseServer>
         <!--Optional:-->
         <log:DatabaseName>TEST_SPEEDWORKS</log:DatabaseName>
         <!--Optional:-->
         <log:DatabaseType>dst_MSSQL2012</log:DatabaseType>
         <!--Optional:-->
         <log:CompanyUsername>manager</log:CompanyUsername>
         <!--Optional:-->
         <log:CompanyPassword>WONDERFULPASSWORD</log:CompanyPassword>
         <!--Optional:-->
         <log:Language>ln_Spanish</log:Language>
         <!--Optional:-->
         <log:LicenseServer>192.10.10.2:40000</log:LicenseServer>
      </log:Login>
   </soapenv:Body>
</soapenv:Envelope>

Response:

<env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope">
   <env:Body>
      <env:Fault>
         <env:Code>
            <env:Value>env:Receiver</env:Value>
            <env:Subcode>
               <env:Value>env:-226</env:Value>
            </env:Subcode>
         </env:Code>
         <env:Detail>
            <Command>Login</Command>
         </env:Detail>
      </env:Fault>
   </env:Body>
</env:Envelope>

What else could be?

Share
10 |10000 characters needed characters left characters exceeded
Danilo Kasparian Mar 01 at 10:16 PM
0

Please, try to connect using the server name instead of the IP

Show 4 Share
10 |10000 characters needed characters left characters exceeded

Yes, in my case I tried both. By IP and by name I'm gettting the same error. As I mentioned above, I put wrong information in purpose and I got normal error messages such a:

  • Invalid database type.
  • License server not found.
  • Invalid language.

And there are several other. BUT I found out that when I put wrong information for:

  • DatabaseServer
  • DatabaseName
  • CompanyUsername
  • CompanyPassword

I'm still getting -226 error no matter if it is wrong or right. Why? Is the Webservice not reaching the SQL Server instance/server (everything in the same server))? Is a component from S1WS Webservice not being able to connect? If so, what other setting are needed to get rid of this error?

0

Try to check the LoginService.wsdl in your server, and add your SQL type there

Also in DI Server file

C:\Program Files (x86)\SAP\SAP Business One ServerTools\DI_Server\Interface\InterfaceRep.xml

Add this node

<dst_MSSQL2012>7</dst_MSSQL2012>

Hope it helps

0

I added dst_MSSQL2012 on WSDL file as u said.

Checked InterfaceRep also but that node already exists.

Finally ran SOAPUI and still getting error -226.

Could be something between IIS and SQL Server Instance? SAP Business One clients (localhost and remote) does not have trouble connecting to SQL Server.

0

Did you try to connect to DI Server without B1WS? If it works then the error probably is IIS

0