Date   

License options

JK Heydt
 

Are there any legitimate alternatives to purchasing xpa 4.6 licenses other than the folks in California? I have heard about the "reseller" channel but I don't know how to contact it.

Thanks


Re: Direct SQL Output Variable For SUM Aggregrate Function Not Returned

Mike Moore
 

Andreas,

Thank you for suggesting CAST:  using that produced the exact results intended.

I am using the fully qualifying the Schema.Table, so I can quickly replace the schema name, in case the query is needed to access tables in production or test libraries in the DB/2 database server.
(I presume there is a way to use an alias defined at the beginning of a series of SQL statements).


I failed to completely obscure the data - resulting in the adult ant confusion. ;-)


Thanks again for your quick and spot-on response!





From:        "Andreas Sedlmeier" <sedlmeier@...>
To:        main@magicu-l.groups.io
Date:        07/13/2020 01:39 AM
Subject:        Re: [magicu-l] Direct SQL Output Variable For SUM Aggregrate Function Not Returned
Sent by:        main@magicu-l.groups.io




I see Ants, where's the adults ? ^^

You should leave away that column aliases and CAST the numeric value to DECIMAL. That I think you have to do always with DB2/400 gateway.
Also that SCHEMA.TABLE prefix is not needed.

Besides I can not see any reason why that would not work with direct SQL in Magic

Best regards,

Andreas




Re: Blb2File Error

Roman Goldenberg
 

Hi Wolfgang,
you can do it via sql server without magic.
this script work perfectly with sql server 2012

you need permision to run procedures in this script
https://stackoverflow.com/questions/29305600/grant-role-to-exec-stored-procedures


declare @PdfDataNewFile varbinary(max) --file from sql table
,@FullPathNewFile NVARCHAR(2048)
DECLARE CURSOR_File CURSOR FOR
(
 
--select binary field
--,output path location 
--from table 
)
OPEN CURSOR_File
 
FETCH NEXT FROM CURSOR_file INTO @PdfDataNewFile
,@FullPathNewFile
 
 
 
WHILE @@FETCH_STATUS=0
begin
declare @ObjectToken INT
 
          EXEC sp_OACreate
            'ADODB.Stream',
            @ObjectToken OUTPUT;
 
          EXEC sp_OASetProperty
            @ObjectToken,
            'Type',
            1;
 
          EXEC sp_OAMethod
            @ObjectToken,
            'Open';
 
          EXEC sp_OAMethod
            @ObjectToken,
            'Write',
            NULL,
            @PdfDataNewFile;
 
          EXEC sp_OAMethod
            @ObjectToken,
            'SaveToFile',
            NULL,
            @FullPathNewFile,
            2;
 
          EXEC sp_OAMethod
            @ObjectToken,
            'Close';
 
        EXEC sp_OADestroy
        @ObjectToken;
 
 
FETCH NEXT FROM CURSOR_File INTO @PdfDataNewFile
,@FullPathNewFile
 
end
CLOSE CURSOR_File
DEALLOCATE CURSOR_File


Re: Blb2File Error

Andreas Sedlmeier
 

On Mon, Jul 13, 2020 at 07:45 AM, Wolfgang Mayer wrote:
is there one possible to open the documents in Magix XPA 4.6?
I dont think so. I do have however no experience with XPA and OLE. I think its completely gone.

Manuall converting 360 object does not sound like so much work.

You should ask MSE for a migration path (utility). Its them who droppen OLDE support and you are certainly not the only one who suffers from this issue.

Remember: There's millions of Magic programmers and myriads of Magic applications ^^

Sorry for no help,

Andreas


Re: Direct SQL Output Variable For SUM Aggregrate Function Not Returned

Andreas Sedlmeier
 

I see Ants, where's the adults ? ^^

You should leave away that column aliases and CAST the numeric value to DECIMAL. That I think you have to do always with DB2/400 gateway.
Also that SCHEMA.TABLE prefix is not needed. 

Besides I can not see any reason why that would not work with direct SQL in Magic

Best regards,

Andreas


Direct SQL Output Variable For SUM Aggregrate Function Not Returned

Mike Moore
 

Using XPA 3.3H and DB2/400 I am trying Direct SQL for first time.

This statement works perfectly using an interactive SQL studio client:

SELECT SCHEMA.TABLE1.FLD21    AS "TourID",
       SUM(SCHEMA.TABLE2.FLD41) AS "Ants"
FROM   SCHEMA.TABLE2
INNER JOIN SCHEMA.TABLE1 ON SCHEMA.TABLE2.FLD2 = SCHEMA.TABLE1.FLD2
GROUP BY SCHEMA.TABLE1.FLD21

Returns:

TourID     Ants
CHAR (10)  DECIMAL (31, 0)
`````````` ```````````````
FSDC               4
3SD              24
SDC              71
PSD              46
F3SD               7
WSD               3
5SD               5


But when I run as Direct SQL (in place of Main Source), on the TourID value is returned.
I presume the SQL processor has created the Adults column (with the aggregate SUM) with an length of 31 and the virtual I've defined in the task's data view cannot receive a value that long.


Any suggestions?

Thanks!


Re: Blb2File Error

Wolfgang Mayer
 

Hello Roman!

It is a Microsoft 2012 SQL Database.

greetings from tyrol
wolfgang


Re: Blb2File Error

Wolfgang Mayer
 

Hi Andreas.

hm that doesn't sound good. Saving the documents manually is not really an option. there are about 350 records.
is there one possible to open the documents in Magix XPA 4.6? Then I could leave the old data records like this and all new data records are only saved to the paths to the documents.

greetings from tyrol
wolfgang


Re: Blb2File Error

Roman Goldenberg
 

Hi Wolfgang,
What database are you using?


Re: Blb2File Error

Andreas Sedlmeier
 

Hi Wolfgang,

It's not the raw application document format what you have in DB when you use OLE to write to a Blob Variable (OLE object) to there but compound (OLE) storage files. When you want the raw application format you have to revert this and Magic has no functionality to do so automatically / programmatically.

If its not a lot what you have in DB, convert your objects manually - otherwise let somebody write you a conversion tool. I am not aware of such a tool. Should be easy to implement.

Best regards,

Andreas


Blb2File Error

Wolfgang Mayer
 

Hello everybody!

I have a problem with Blb2File.
If I export documents (JPG, PDF) from a Blob variable, the files are faulty.
The files can be opened in the database.
What am I doing wrong?

I use UniPaaS 1.9 for this.

Exporting the files is necessary as this no longer works in Magic XPA 4.6 with the OLE object.

Who has an idea?

thx for help

Document opened in the database works:


Re: UserFunctionality - View by key doesnt default to the currently in use key

Peter Ashworth
 

Hi Don

Sorry never got around to replying to this. This is specifically with regards to XPA. In XPA 2.5 it was deprecated even, and was eventually brought back in 3.2.

Due to the new .net framework some of these functions like the range/locate/sort/key driven by the keyboard short cuts where no longer natively supported, and Magic have written there own component application that you can reference if you want to bring them back. Due to this they don't work like they used to and are some new flavour of it.

Range for instance is more like how sort used to be in magic 9.4 in that its a popup window were you can see all the virtual names rather than being inside the table view itself.

And they have managed to recreate the key view but it no longer parks on the current key. And I haven't found a function or ability to by expression figure out progromatically what the current key is.

Regards

Peter


Re: Has anyone an eDeveolper 9.4 runtime license (MGCSRT94) for sale?

Michael
 

No one?

Please contact me if you have one runtime license V9.4 or more.


Re: Installing Pervasive Client via Group Policy

Todd Baremore
 

Graham,

Give this a try
https://www.exemsi.com/
Todd
On 7/5/2020 10:59 PM, Graham White wrote:

Hi,

 

Does anyone know if there is a way to install the pervasive client via group policy? 

 

Group policy needs a msi installer which I have found inside the exe package but it won’t run as per the message below.

 

 

 

Regards

 

Graham White
Software Developer
Graham.White@...
EC Credit Control |  eccreditcontrol.com

 

IMPORTANT NOTICE: This e-mail message and any attachments are confidential to EC Credit Control and subject to legal privilege (which is not waived or 

lost by mistaken delivery). If you have received this e-mail in error, please advise the sender immediately and destroy the message and any attachments.  

If you are not the intended recipient you are notified that any use, distribution, amendment, copying or any action taken or omitted to be taken in reliance of 

this message or attachments is prohibited. EC Credit Control collects personal information to provide and market our services (see our privacy policy at: 

www.eccreditcontrol.co.nz – www.eccreditcontrol.com - www.eccreditcontrol.com.au for more information about use, disclosure and access). 

EC Credit Control’s liability in connection with transmitting, unauthorised access to, or viruses in this message and its attachments is limited to resupply of 

any affected message or attachments.



Installing Pervasive Client via Group Policy

Graham White
 

Hi,

 

Does anyone know if there is a way to install the pervasive client via group policy? 

 

Group policy needs a msi installer which I have found inside the exe package but it won’t run as per the message below.

 

 

 

Regards

 

Graham White
Software Developer
Graham.White@...
EC Credit Control |  eccreditcontrol.com

 

IMPORTANT NOTICE: This e-mail message and any attachments are confidential to EC Credit Control and subject to legal privilege (which is not waived or 

lost by mistaken delivery). If you have received this e-mail in error, please advise the sender immediately and destroy the message and any attachments.  

If you are not the intended recipient you are notified that any use, distribution, amendment, copying or any action taken or omitted to be taken in reliance of 

this message or attachments is prohibited. EC Credit Control collects personal information to provide and market our services (see our privacy policy at: 

www.eccreditcontrol.co.nz – www.eccreditcontrol.com - www.eccreditcontrol.com.au for more information about use, disclosure and access). 

EC Credit Control’s liability in connection with transmitting, unauthorised access to, or viruses in this message and its attachments is limited to resupply of 

any affected message or attachments.


Re: Magic XPA 4.5a on Linux: ABNORMAL TERMINATION: INTERRUPT (11) #xpa #linux #ria

Marvin VIDAL
 

Thanks for your advice, I didn't know docker has that feature. There's a lot that I still have to learn.
I'll give it a try and I hope to give my feedback.

Regards,

Marvin VIDAL


On Sat, Jul 4, 2020 at 8:42 AM Andreas Sedlmeier <sedlmeier@...> wrote:
If you run your Magic server in a docker container you can set the MAC address dynamically as a command line parameter for docker run https://docs.docker.com/engine/reference/run/
Maybe helps and works, I dont have Magic Linux (and dont need it when its hardwarebound shit)


Re: Magic XPA 4.5a on Linux: ABNORMAL TERMINATION: INTERRUPT (11) #xpa #linux #ria

Andreas Sedlmeier
 

If you run your Magic server in a docker container you can set the MAC address dynamically as a command line parameter for docker run https://docs.docker.com/engine/reference/run/
Maybe helps and works, I dont have Magic Linux (and dont need it when its hardwarebound shit)


Re: Magic XPA 4.5a on Linux: ABNORMAL TERMINATION: INTERRUPT (11) #xpa #linux #ria

Marvin VIDAL
 

If anyone has my same issue, it is because Azure changed my Mac Address. I asked for a new license file to solve it.
I hope that I can help someone else.

Best regards,

Marvin VIDAL


On Thu, Dec 26, 2019 at 6:02 PM vidal.marvin via Groups.Io <vidal.marvin=gmail.com@groups.io> wrote:
After setting up the license file in my brand new installation, i have tried to start the broker directly from the command line using "mgxparuntime" and with "startb". In both cases i got the same message in the mgerror.log file:

 
==============================================
PID 9479        26/12/2019 16:54:21
==============================================


 <-1> 26/12/2019 17:04:09.779     [Error  ] - ABNORMAL TERMINATION:  INTERRUPT (11)

Also i have tried to use STRACE to check what going wrong and it seems that it is a segmentation fault error:

 
--- SIGSEGV {si_signo=SIGSEGV, si_code=SEGV_MAPERR, si_addr=0} ---
 
This is my environment:

  • OS: Red Hat Enterprise Linux Server release 7.7 (Maipo)
  • Java: java version "1.8.0_231"
  • Magic: XPA 4.5a
It looks like all the libraries are OK:

[magicxpa@srv-vmd-ria ~]$ ldd /app/magicxpa4.5a/bin/mgxparuntime
linux-vdso.so.1 =>  (0x00007ffd061f0000)
libxerces-c-3.1.so => /app/magicxpa4.5a/lib/libxerces-c-3.1.so (0x00007f0731c69000)
libexpat.so.1 => /lib64/libexpat.so.1 (0x00007f0731a3f000)
liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00007f0731830000)
libldap_r-2.4.so.2 => /lib64/libldap_r-2.4.so.2 (0x00007f07315d1000)
libcrypto.so.10 => /lib64/libcrypto.so.10 (0x00007f073116e000)
libssl.so.10 => /lib64/libssl.so.10 (0x00007f0730efc000)
libicuio.so.50 => /lib64/libicuio.so.50 (0x00007f0730cee000)
libicui18n.so.50 => /lib64/libicui18n.so.50 (0x00007f07308ef000)
libicuuc.so.50 => /lib64/libicuuc.so.50 (0x00007f0730576000)
libicudata.so.50 => /lib64/libicudata.so.50 (0x00007f072efa2000)
libjvm.so => /usr/java/jre1.8.0_231-amd64/lib/amd64/server/libjvm.so (0x00007f072dfb8000)
libz.so.1 => /lib64/libz.so.1 (0x00007f072dda2000)
libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f072db88000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f072d984000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f072d768000)
libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f072d460000)
libm.so.6 => /lib64/libm.so.6 (0x00007f072d15e000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f072cf48000)
libc.so.6 => /lib64/libc.so.6 (0x00007f072cb7a000)
libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f072c961000)
libsasl2.so.3 => /lib64/libsasl2.so.3 (0x00007f072c744000)
libssl3.so => /lib64/libssl3.so (0x00007f072c4eb000)
libsmime3.so => /lib64/libsmime3.so (0x00007f072c2c3000)
libnss3.so => /lib64/libnss3.so (0x00007f072bf94000)
libnssutil3.so => /lib64/libnssutil3.so (0x00007f072bd64000)
libplds4.so => /lib64/libplds4.so (0x00007f072bb60000)
libplc4.so => /lib64/libplc4.so (0x00007f072b95b000)
libnspr4.so => /lib64/libnspr4.so (0x00007f072b71d000)
libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007f072b4d0000)
libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007f072b1e7000)
libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007f072afe3000)
libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007f072adb0000)
/lib64/ld-linux-x86-64.so.2 (0x00007f0732202000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f072ab79000)
libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007f072a969000)
librt.so.1 => /lib64/librt.so.1 (0x00007f072a761000)
libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007f072a55d000)
libfreebl3.so => /lib64/libfreebl3.so (0x00007f072a35a000)
libselinux.so.1 => /lib64/libselinux.so.1 (0x00007f072a133000)
libpcre.so.1 => /lib64/libpcre.so.1 (0x00007f0729ed1000)
[magicxpa@srv-vmd-ria ~]$
 
I have a Magic XPA 3.3 running smoothly on Linux, and don't have clue what's going on with 4.5a.

Thanks in advance for any help.

Best regards,
Marvin VIDAL















Re: PDF editor

gac@...
 

Hello,

I use :  https://www.win2pdf.com/

GA


Re: Invoke WS Lite and https

Andreas Sedlmeier
 

Hi Adam,

Of course its possible, only there's a TLS version issue since a while. Your Magic version only supports SSL and early TLS and if the TLS version that server you try to connect only has TLS 1.2 or above you are doomed. You can check the SSL/TLS support provided by that server here: https://www.ssllabs.com/ssltest/

If it says its secure because its only has TLS 1.2 and above you need Xpa 4.6, or do your http stuff without Magic. Which is the better plan anyways ^^

Andreas

3241 - 3260 of 196034