Baanboard.com

Go Back   Baanboard.com > Forum > General Topics > General Discussion & Chat

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 12th May 2006, 19:08
ckassab's Avatar
ckassab ckassab is offline
Member
 
Join Date: Dec 2004
Location: Guadalajara, Jalisco, México
Posts: 45
ckassab is on a distinguished road
Baan: VI,V - DB: Oracle,SQL Server - OS: SUN, Windows
BaaN Ole Broker Server (BOBS)

We have published a project that could be interesting for some people, if you are interested, please read the nex short FAQ and let us know your opinion.


Short FAQ:

What is BOBS?

BOBS is the effort to create and interface for Baan to be connected to other applications at a similar way that baan open world does but with a low cost and still being effective.


What is the BOBS license?

BOBS ha a GPL license, so feel free to use as you want, just accept the GPL license.

Where can i get more information about BOBS?

Please go to the next link:

BaanOleBrokerServer Home

And feel free to post any idea or question in this forum.
Reply With Quote
  #2  
Old 13th May 2006, 07:09
patvdv's Avatar
patvdv patvdv is offline
Board Master
 
Join Date: Aug 2001
Location: Belgium
Posts: 2,167
patvdv is on a distinguished road
Baan: n/a - DB: n/a - OS: AIX, HP-UX, Linux
I cannot comment on the intrinsic merits of BOBS but I am very happy to see a Baan add-on being released as Open Source Software! Well done Carlos!
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2017 baanboard.com/baanforums.com
Reply With Quote
  #3  
Old 14th May 2006, 20:00
ckassab's Avatar
ckassab ckassab is offline
Member
 
Join Date: Dec 2004
Location: Guadalajara, Jalisco, México
Posts: 45
ckassab is on a distinguished road
Baan: VI,V - DB: Oracle,SQL Server - OS: SUN, Windows
Thank you Patrick.

I hope many people use BOBS to help their companies and they help to optimize BOBS too.


Carlos Kassab
__________________
Consultant
ERP BaaN Tools
BaaN Exchange
BaaN OLE Automation
JasperSoft OLAP Business Intelligence.
BOBS Main Developer
Reply With Quote
  #4  
Old 14th June 2006, 19:48
ckassab's Avatar
ckassab ckassab is offline
Member
 
Join Date: Dec 2004
Location: Guadalajara, Jalisco, México
Posts: 45
ckassab is on a distinguished road
Baan: VI,V - DB: Oracle,SQL Server - OS: SUN, Windows
BaaN Ole Broker Server (BOBS) Update

I have updated BOBS due to minor bug fixes:

- The warning email was allways being sending when disconecting a session and it was being sending to the incorrect mailbox.

Note. If your have tested BOBS, i would like to hear from your experience, just drop me an email to carlos.kassab AT gmail dot com


Thank you

Carlos Kassab
__________________
Consultant
ERP BaaN Tools
BaaN Exchange
BaaN OLE Automation
JasperSoft OLAP Business Intelligence.
BOBS Main Developer
Reply With Quote
  #5  
Old 21st June 2006, 23:44
r_nagu's Avatar
r_nagu r_nagu is offline
Senior Member
 
Join Date: Mar 2002
Location: ~
Posts: 231
r_nagu is on a distinguished road
Baan: BaaN IV - DB: Oracle 8 - OS: UNIX
Carlos,

First of all let me congratulate you for your efforts in writing a open source connectivity for BaaN.

I downloaded your zip files (both binaries and source) and extracted the binary files and followed your instructions in the BOBSFAQ.html file. Now, when I try to start the BOBS server (BaaNOleBrokerServer.exe) I get the following error.

--------------------------------------------------------------------------
Files\Baan\lib\user\baantwobsp.bwc Configuration file not found. Please verify the correct file name.
--------------------------------------------------------------------------

I know that I have the baantwobsp.bwc file (which is the default) in the “c:\Program Files\Baan\lib\user” folder. I have double checked it. Not sure what the problem is.

Thanks,
NS
Reply With Quote
  #6  
Old 22nd June 2006, 06:49
ckassab's Avatar
ckassab ckassab is offline
Member
 
Join Date: Dec 2004
Location: Guadalajara, Jalisco, México
Posts: 45
ckassab is on a distinguished road
Baan: VI,V - DB: Oracle,SQL Server - OS: SUN, Windows
Problems starting BaaNOleBrokerServer.exe

Quote:
Originally Posted by r_nagu
Carlos,

First of all let me congratulate you for your efforts in writing a open source connectivity for BaaN.

I downloaded your zip files (both binaries and source) and extracted the binary files and followed your instructions in the BOBSFAQ.html file. Now, when I try to start the BOBS server (BaaNOleBrokerServer.exe) I get the following error.

--------------------------------------------------------------------------
Files\Baan\lib\user\baantwobsp.bwc Configuration file not found. Please verify the correct file name.
--------------------------------------------------------------------------

I know that I have the baantwobsp.bwc file (which is the default) in the “c:\Program Files\Baan\lib\user” folder. I have double checked it. Not sure what the problem is.

Thanks,
NS
r_nagu,

Thank you for your congratulations i hope more people use it and help BOBS to have more features.

I think the problem is that you installed the baan client in "Program Files", please install baan client in c:\baan or any other folder that does not have blank spaces. I have seen some different problems when you install baan client in a folder with blank spaces.

And please, let me know if it resolved your problem.

Carlos Kassab
__________________
Consultant
ERP BaaN Tools
BaaN Exchange
BaaN OLE Automation
JasperSoft OLAP Business Intelligence.
BOBS Main Developer
Reply With Quote
  #7  
Old 22nd June 2006, 23:54
r_nagu's Avatar
r_nagu r_nagu is offline
Senior Member
 
Join Date: Mar 2002
Location: ~
Posts: 231
r_nagu is on a distinguished road
Baan: BaaN IV - DB: Oracle 8 - OS: UNIX
Thanks for getting back.

I uninstalled BW client and installed it under C:\Baan. Now when I try to start the BOBS server, I get the following error message:

-------------------------------------------------------
Can not start BaaN Ole Broker Service:
The requested address is not valid in its context
-------------------------------------------------------

Thanks,
NS
Reply With Quote
Sponsored Links
  #8  
Old 23rd June 2006, 06:43
ckassab's Avatar
ckassab ckassab is offline
Member
 
Join Date: Dec 2004
Location: Guadalajara, Jalisco, México
Posts: 45
ckassab is on a distinguished road
Baan: VI,V - DB: Oracle,SQL Server - OS: SUN, Windows
BOBS -> The requested address is not valid in its context

Quote:
Originally Posted by r_nagu
Thanks for getting back.

I uninstalled BW client and installed it under C:\Baan. Now when I try to start the BOBS server, I get the following error message:

-------------------------------------------------------
Can not start BaaN Ole Broker Service:
The requested address is not valid in its context
-------------------------------------------------------

Thanks,
NS
r_nagu,

It seems baan was started succesfully, if you have a firewall active where BOBS is installed, please first check your firewall is not blocking the port where BOBS is listening.

AND if it does not work, in order i can help you, could you please post the next:
1.- What is the Operating system where you are installing BOBS? and do you have all patches? for windows,
2.- .NET 2.0 was succesfully installed?
3.- What is your BaaN version?
4.- Have you set correcly the default connection to baan?, rigth clicking with the mouse and setting the default?

5.- Please post too your BOBS config file "BaaNOleBrokerServer.config"



Carlos Kassab
__________________
Consultant
ERP BaaN Tools
BaaN Exchange
BaaN OLE Automation
JasperSoft OLAP Business Intelligence.
BOBS Main Developer
Reply With Quote
  #9  
Old 23rd June 2006, 23:10
r_nagu's Avatar
r_nagu r_nagu is offline
Senior Member
 
Join Date: Mar 2002
Location: ~
Posts: 231
r_nagu is on a distinguished road
Baan: BaaN IV - DB: Oracle 8 - OS: UNIX
Carlos,
I have no firewall and see below for the information you asked for.

1. Windows XP and patches are up-to-date.
2. .NET 2.0 framework is installed and working.
3. BaaN IVc (BW client version is B40c.75).
4. I have set the default connection to BaaN.
5. See the attached for the config file. (the serverIP address is been changed in the attached file but I have the real IP address in the config file that I am using).

Thanks,
NS
Attached Files
File Type: txt BaaNOleBrokerServerconfig.txt (1.3 KB, 105 views)
Reply With Quote
  #10  
Old 24th June 2006, 06:30
ckassab's Avatar
ckassab ckassab is offline
Member
 
Join Date: Dec 2004
Location: Guadalajara, Jalisco, México
Posts: 45
ckassab is on a distinguished road
Baan: VI,V - DB: Oracle,SQL Server - OS: SUN, Windows
Quote:
Originally Posted by r_nagu
Carlos,
I have no firewall and see below for the information you asked for.

1. Windows XP and patches are up-to-date.
2. .NET 2.0 framework is installed and working.
3. BaaN IVc (BW client version is B40c.75).
4. I have set the default connection to BaaN.
5. See the attached for the config file. (the serverIP address is been changed in the attached file but I have the real IP address in the config file that I am using).

Thanks,
NS
Hi r_nagu,

I understand that Windows XP firewall is inactive?, it sounds strange to me but just confirm it.

I saw in your config file that you only changed the IP address on the server, it seems that the problem is with WinSocks; i found this in a forum with the same error "The requested address is not valid in its context" in a .NET app:
This is may be because the IP is not a valid IP on your computer, or maybe the port is binded to another application.

I suggest you use the ip address 127.0.0.1(just to confirm the ip is the problem, BOBS must work with any IP address) and try to start the server; if it does not work, change the port to 32002 and restart BOBS.

Please let me know what happened.

Carlos Kassab
__________________
Consultant
ERP BaaN Tools
BaaN Exchange
BaaN OLE Automation
JasperSoft OLAP Business Intelligence.
BOBS Main Developer
Reply With Quote
  #11  
Old 26th June 2006, 21:27
r_nagu's Avatar
r_nagu r_nagu is offline
Senior Member
 
Join Date: Mar 2002
Location: ~
Posts: 231
r_nagu is on a distinguished road
Baan: BaaN IV - DB: Oracle 8 - OS: UNIX
Carlos,
That’s it. My IP address was the one creating problems. I should have checked it first. After I specified the correct IP address, it stated working. I was able to start the server and also write/query data using the sample client program.

Now I was just trying to see how this would behave in a read/write extensive situation. I opened up four instances of the client and started to write data from all four clients. It did perform very well during first round but during the second turn and subsequent turns, the client hangs and would take few seconds to unfreeze and perform the actions.

Other than that it works great and again congratulations on your effort.

Thanks,
NS
Reply With Quote
  #12  
Old 27th June 2006, 18:40
ckassab's Avatar
ckassab ckassab is offline
Member
 
Join Date: Dec 2004
Location: Guadalajara, Jalisco, México
Posts: 45
ckassab is on a distinguished road
Baan: VI,V - DB: Oracle,SQL Server - OS: SUN, Windows
I hope you can use in an application

Quote:
Originally Posted by r_nagu
Carlos,
That’s it. My IP address was the one creating problems. I should have checked it first. After I specified the correct IP address, it stated working. I was able to start the server and also write/query data using the sample client program.

Now I was just trying to see how this would behave in a read/write extensive situation. I opened up four instances of the client and started to write data from all four clients. It did perform very well during first round but during the second turn and subsequent turns, the client hangs and would take few seconds to unfreeze and perform the actions.

Other than that it works great and again congratulations on your effort.

Thanks,
NS
Hi r_nagu,

I hope you can use BOBS in some application and give some feedback and improve the project if posible.

regards

Carlos Kassab
__________________
Consultant
ERP BaaN Tools
BaaN Exchange
BaaN OLE Automation
JasperSoft OLAP Business Intelligence.
BOBS Main Developer
Reply With Quote
  #13  
Old 27th July 2006, 01:57
ckassab's Avatar
ckassab ckassab is offline
Member
 
Join Date: Dec 2004
Location: Guadalajara, Jalisco, México
Posts: 45
ckassab is on a distinguished road
Baan: VI,V - DB: Oracle,SQL Server - OS: SUN, Windows
New documentation

Hi all,

I have uploaded a new file, it is a howto write an ASP .NET app to access BaaN using BOBS.

I have been seeing that when using with baan IV, some times the baan client is slow executing the apps(as r_nagu noted before), when using in a web environment can not be easy to see it, maybe here we do not have nothing to do if somebody knows what to do in order to do the client faster, please let me know.

Regards

Carlos Kassab
__________________
Consultant
ERP BaaN Tools
BaaN Exchange
BaaN OLE Automation
JasperSoft OLAP Business Intelligence.
BOBS Main Developer
Reply With Quote
  #14  
Old 21st September 2006, 08:29
boXer14's Avatar
boXer14 boXer14 is offline
Junior Member
 
Join Date: Jun 2005
Posts: 26
boXer14 is on a distinguished road
Baan: BaaN IV c4 sp22 - DB: Oracle - OS: Unix
Hi Carlos, all

First, thanks very much Carlos for doing and sharing BOBS. I guess it can open new perspectives for BaaN users.

I finally succeeded to run the server after some probs. On first attemps, when i run BOBS, it was hanging for a while and send msg:

Can not start BaaN service:System.Runtime.InteropServices.COMException (0x80080005): Retrieving the COM class factory for component with CLSID {00000000-4000-11CE-AAA8-00608C50C597} failed due to the following error: 80080005.

The prob was the class name in my default bwc file that wasn't "Baan4.Application" but "Baan4.application.ovi"

Now that it's same value in BOBS and in my bwc file, server runs fine.

I would like now to use BOBS in OpenOffice macros (OOo Basic), but i've no clue how to do... If one of you knows, it will be great help for me.

Olivier
Reply With Quote
  #15  
Old 25th September 2006, 19:07
ckassab's Avatar
ckassab ckassab is offline
Member
 
Join Date: Dec 2004
Location: Guadalajara, Jalisco, México
Posts: 45
ckassab is on a distinguished road
Baan: VI,V - DB: Oracle,SQL Server - OS: SUN, Windows
BOBS and OpenOffice

Quote:
Originally Posted by boXer14
Hi Carlos, all

First, thanks very much Carlos for doing and sharing BOBS. I guess it can open new perspectives for BaaN users.

I finally succeeded to run the server after some probs. On first attemps, when i run BOBS, it was hanging for a while and send msg:

Can not start BaaN service:System.Runtime.InteropServices.COMException (0x80080005): Retrieving the COM class factory for component with CLSID {00000000-4000-11CE-AAA8-00608C50C597} failed due to the following error: 80080005.

The prob was the class name in my default bwc file that wasn't "Baan4.Application" but "Baan4.application.ovi"

Now that it's same value in BOBS and in my bwc file, server runs fine.

I would like now to use BOBS in OpenOffice macros (OOo Basic), but i've no clue how to do... If one of you knows, it will be great help for me.

Olivier

Hi Olivier,

You are wellcome, I am glad you are spending time with BOBS, i hope BOBS help you to solve your problems.

Virtually BOBS can connect from any other language that can deal with sockets.


I am not a developer of OpenOffice Basic.

I have been looking how you can do the connection to BOBS and i found the next information:

1.- It seems that the actual versions of openoffice have problems with sockets, according to this topic:
http://www.oooforum.org/forum/viewtopic.phtml?p=68632

The good news here is that it seems it is resolved in 2.0.4 version of openoffice, but you will need to know how to develop a program using tcp/ip sockets connection with openoffice basic.

At this moment i have a lot of work to do and i can not to test this, but if you follow the same rules that in the C# client example it must works, the steps are:


a) Connection: Create a socket connection to the server, following the basic instructions.
b) Send the client id text: ClientID = "otdslsdllbobsts|bobstest.end( )|" + DateTime.Now + "\r\n";

c) Wait that BOBS answer with an OK text:
if (ReceivedData != "OK")
{
m_processState = STATE.DISCONNECT;
if not received ok, you are not connected.
}

If you received OK, now you are connected and you can send and receive data to/from the BOBS

sample in C#:
clientSocket.Send(Encoding.Default.GetBytes(BaaNCommand));
size = clientSocket.Receive(data);

Remember allways to close the connection in the next way:

first, sending the next text:
clientSocket.Send(Encoding.Default.GetBytes("[EOS]\r\n"));
size = clientSocket.Receive(data);

C# is waiting to receive data but do not use this data. you must cath all exceptions, i do not know if openoffice basic handle the exceptions.

If you continue with this development, post your questions in this forum in order i can help you and others can see a way to connect to BOBS from OpenOffice.

Regards

Carlos Kassab
__________________
Consultant
ERP BaaN Tools
BaaN Exchange
BaaN OLE Automation
JasperSoft OLAP Business Intelligence.
BOBS Main Developer
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Ervaren Baan specialist ICT Builder Jobs and Resumes 3 5th February 2005 06:37
Invitation to SSA Global's BaaN User Group Meeting in Bangkok nopadon ไทยฟอรัม 0 12th January 2005 19:25
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 11:49
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 19:44


All times are GMT +2. The time now is 20:54.


©2001-2017 - Baanboard.com - Baanforums.com