Problem whith relativity

Questions and answers regarding general SQL and backend databases

Problem whith relativity

Postby Manolo_Etec » Thu Oct 25, 2012 1:45 pm

Good morning from the sunny and warm Canary Islands.

I have a problem with a solution that is accesing data thru Relativity.

It is table view a form that, after a number of rows, no information is shown. I´ve been digging on this and I guess that the problem is because the error I see in the server log.

The code I´m using to load data in the forms foundset is:

Code: Select all

function onShow(firstShow, event) {

   fvFormTitle = 'Rutero';


   var _SQL = 'SELECT RutNumdia, RutNumord, RutNumsem, RutNumven FROM mrutas WHERE rutnumven=?';

   forms.lstClientesRutero.foundset.loadRecords(_SQL, [globals.currentUsuarioID])
   forms.lstClientesRutero.foundset.sort('rutnumsem asc, rutnumdia asc, rutnumord asc')

}


and the error I get in the server log:


Imagen_1.PNG
Imagen_1.PNG (73.17 KiB) Viewed 3569 times


Imagen_2.PNG
Imagen_2.PNG (75.5 KiB) Viewed 3569 times



I do not know if it might help but this is the table structure:

Imagen_3.PNG
Imagen_3.PNG (15.44 KiB) Viewed 3569 times



This occurs only in webclient, in smartclient work fine

Can anyone help me on this?

Thanks in advance
Manuel López
Etec Programación SL
manuel@etecsoft.com
http://www.etecsoft.com
User avatar
Manolo_Etec
 
Posts: 66
Joined: Fri Sep 12, 2008 3:58 pm

Re: Problem whith relativity

Postby ProRM » Thu Oct 25, 2012 3:47 pm

Hi Manolo,

What version of Relativity are you using? I found a bug fix on that error on an old Relativity version 3.23. It is very strange that runs fine under Smartclient but not under Webclient. Are you trying the same sql in both?

Have you tried another SQL tool to test that sql? It seems to be related to data present in Cobol files as you mention that Servoy shows some data and stop at a certain place.

Regards,
User avatar
ProRM
 
Posts: 107
Joined: Thu Sep 18, 2008 10:24 pm
Location: Uruguay

Re: Problem whith relativity

Postby Manolo_Etec » Fri Oct 26, 2012 1:19 pm

Thanks Juan Manuel for reply

Responding to your questions

I am using the same sql both smart client and web client

In the eclipse sql explorer in prespective works well

To view the version I got an ls unix, and I get this

[root @ management relativity-ds] # ls-l

Total 20

-rwxrwxrwx 1 root root 81 February 17, 2011 make_rst

drwxrwxrwx 4 root root 12288 October 26 9:31 RelRM12.05

-rwxrwxrwx 1 root root 66 February 17, 2011 RUNACTIVE

[root @ management relativity-ds] # pwd

/ opt / relativity-ds

[root @ management relativity-ds] #

I do not know if the directory 'RelRM12.05' is the version.
Manuel López
Etec Programación SL
manuel@etecsoft.com
http://www.etecsoft.com
User avatar
Manolo_Etec
 
Posts: 66
Joined: Fri Sep 12, 2008 3:58 pm

Re: Problem whith relativity

Postby ProRM » Fri Oct 26, 2012 5:43 pm

Hi Manolo,

It´s very strange that works fine on Smart and not on Web, if the data is the problem. I have sent a newest JDBC Relativity Driver to Juan Antonio today. Please let me know the results and if the problem persists you will need to open a case with LiveRMC or Servoy Spain in order to study the problem with Relativity.

Regards,
User avatar
ProRM
 
Posts: 107
Joined: Thu Sep 18, 2008 10:24 pm
Location: Uruguay

Re: Problem whith relativity

Postby Manolo_Etec » Mon Oct 29, 2012 12:07 pm

Thanks Juan Manuel.

I proved the new Jdbc Relativity Driver, but does not work.

I will talk with LiveRMC or Servoy Spain to solve the problem
Manuel López
Etec Programación SL
manuel@etecsoft.com
http://www.etecsoft.com
User avatar
Manolo_Etec
 
Posts: 66
Joined: Fri Sep 12, 2008 3:58 pm


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 4 guests

cron