Date   

XPA Creating Invalid MS-SQL

Steven Burrows
 

XPA 2.5d and MSSQL 2014 – Some sites are getting random but regular issues with weird SQL Error message stating that they don’t have sufficient permissions to do an UPDATE or INSERT.

This is rubbish as the Application Role they are running under has sys_admin.

Running the SQL Profiler, we find the SQL being processed is something like (snipped for breverty)

 

EXEC sp_executesql N'UPDATE ….using parameters upto :P12', N'@P1 ….@P12',

1, 97, 260000000000005, 19, 350000000000001, 25, 649999999999999, 100, 1, 97, 260000000000005, 19, 350000000000001, 25, 649999999999999, 95, '1901-01-02 00:00:01', '100000003';

 

Try and run this in SMS and it reports “Procedure or function has too many arguments specified.”

Quite right its an error, there are 6 MORE Parameters passed than can be received !

After scratching my beard for a little, I noticed that some of those “,” should be “.”, they are FLOATS! It should be

 

EXEC sp_executesql N'UPDATE ….using parameters upto :P12', N'@P1 ….@P12',

1, 97.260000000000005, 19.350000000000001, 25.649999999999999, 100, 1, 97.260000000000005, 19.350000000000001, 25.649999999999999, 95, '1901-01-02 00:00:01', '100000003';

 

 

Anyone seen anything so horrid before ?

Could this be some regional setting ?

Any clues before I wrestle with MSE ?

This only happens on a customers site of course.

 

 


Steven Burrows

 


Re: Direct SQL

Jackson, Adam
 

took off user name and password from connection settings in application and now works!!  Need to check if credentials needed but at least got to bottom of it. Thanks

Adam Jackson|Project Manager - Business Systems|McLaren Racing Limited


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
Sent: Thursday, August 10, 2017 12:20:01 PM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL
 

Have looked at database settings and there are a couple of secret names used in “database information” window for username and password. Have asked my DBA to see if that account has sufficient permissions

 

Adam Jackson | Project Manager – Business Systems | McLaren Racing Limited

McLaren Technology Centre, Chertsey Road, Woking, Surrey GU21 4YH, UK

 

T  +44 (0) 01483 261039

E  adam.jackson@...

W  www.mclaren.com

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Tim Downie
Sent: 10 August 2017 12:14
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Did you apg the magic task that has your sql statement - if not try this.

Are you using trusted sql security...or user name/password in magic.ini?


Next thing is run and sql magic task to get sql pid.
Sql.task with exec sp_who...from memory
Then sql profile this session.

Im thinking somehow magic is connnecting with a different user/permission


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
Sent: Thursday, 10 August 2017 11:00:32 AM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Change of tack – moved to trying:

 

select distinct count(loginame) as 'user_count' from sys.sysprocesses

 

 

 

In MSSQL get 75, in excel get 75 in xpa get 1

 

As before I just cut and pasted the query from MSSQL into both excel and xpa. In xpa I just ran APG and then program. Little or no interference from me as possible yet the simplest of programs does not work – beyond frustrated.

 

In log with customer setting I get below and when I copy back into MSSQL it works ok.

 

<106109614830671264> 10/08/2017 11:57:22.265     [Action ] -      ,89021  SET IMPLICIT_TRANSACTIONS ON

<106109614830671264> 10/08/2017 11:57:22.265     [Action ] -      ,89021  

                STMT: select distinct count(loginame) as 'user_count' from sys.sysprocesses

<106109614830671264> 10/08/2017 11:57:22.265     [Action ] -      ,89021  

                STMT: select distinct count(loginame) as 'user_count' from sys.sysprocesses

<106109614830671264> 10/08/2017 11:57:22.265     [Action ] -      ,89021  logical cursor: using COMMAND :Default result Set

<106109614830671264> 10/08/2017 11:57:22.281     [Action ] -      ,89037                  FETCH Read0

<106109614830671264> 10/08/2017 11:57:22.281     [Action ] -      ,89037  SET IMPLICIT_TRANSACTIONS OFF

 

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Jackson, Adam
Sent: 10 August 2017 08:52
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Tried with full developer trace and the only RESULT line was the one record I am getting which BTW is for my connection so could this be a permissions thing? Our DBA says not and all the time my record was the first record I did not question it but now the first record according to MSSQL studio is a NULL/blank record so if my results set was limited to 1 record then surely I would get that?

 

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Jackson, Adam
Sent: 10 August 2017 08:26
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

HI,

 

Tried that and got below which seems OK. Still only showing one record in xpa but 7 in MSSQL Studio

 

 

<158285391664954432> 10/08/2017 08:19:11.271     [Action ] -     >>Starts load Batch Task - 'C:Get User Count' in Modify mode (Task Instance: 6631, Resident)

<158285391664954432> 10/08/2017 08:19:11.271     [Action ] -     Ends Load Task

<158285391664954432> 10/08/2017 08:19:12.597     [Action ] -     Task Mode Change - Modify

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Load records

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Read Transaction 0

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Commit Transaction 0

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Starts Record Suffix

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -       Flow - Call SubTask :: Get count

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -         Write Physical Transaction 6632

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -         2,99398  SET IMPLICIT_TRANSACTIONS ON

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -          ,99398  

                STMT: SELECT distinct

    loginame as LoginName

FROM

    sys.sysprocesses

WHERE

    DB_NAME(dbid)='Javelin'

GROUP BY

 loginame

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -          ,99398  

                STMT: SELECT distinct

    loginame as LoginName

FROM

    sys.sysprocesses

WHERE

    DB_NAME(dbid)='Javelin'

GROUP BY

 loginame

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -          ,99398  logical cursor: using COMMAND :Default result Set

<158285391664954432> 10/08/2017 08:19:12.643     [Action ] -          ,99414              FETCH Read0

<158285391664954432> 10/08/2017 08:19:12.643     [Action ] -          ,99414  SET IMPLICIT_TRANSACTIONS OFF

<158285391664954432> 10/08/2017 08:19:12.643     [Action ] -         Commit Transaction 6632

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Open DB Table - 'C:\Users\adam.jackson\AppData\Local\Temp\MG1761615828539166495443070.mem (#0) (W,N)'

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         >>Starts load Online Task - 'Get count' in Query mode (Task Instance: 6632)

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Ends Load Task

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Task Mode Change - Query

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Read Transaction 0

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Load records

<158285391664954432> 10/08/2017 08:19:12.721     [Action ] -         Commit Transaction 0

<158285391664954432> 10/08/2017 08:19:12.721     [Action ] -         Flow - Variable Column  'LoginName' (Step Forward) 

 <158285391664954432> 10/08/2017 08:19:14.967     [Action ] -         >>  Processing Event  [Close]  Control Name :  [ N/A ]

 <158285391664954432> 10/08/2017 08:19:14.983     [Action ] -         >>  Processing Event  [Exit]  Control Name :  [ N/A ]

 <158285391664954432> 10/08/2017 08:19:14.983     [Action ] -         Starts Closing Online Task - 'Get count' (Task Instance: 6632)

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       <<Ends Close Task

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       Task Mode Change - Modify

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       Flow - Condition: Exp = 78, Result = False

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       Flow - Call SubTask :: Update [Not Executed]

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -     Ends Record Suffix

<158285391664954432> 10/08/2017 08:19:16.043     [Action ] -     Starts Closing Batch Task - 'C:Get User Count' (Task Instance: 6631)

<158285391664954432> 10/08/2017 08:19:16.075     [Action ] -   <<Ends Close Task

<158285391664954432> 10/08/2017 08:19:16.075     [Action ] -   >>  Processing Event  [Exit System]  Control Name :  [ N/A ]

 <158285391664954432> 10/08/2017 08:19:16.075     [Info   ] -   Context released :

 

 

 

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Tim Downie
Sent: 09 August 2017 22:09
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Hi
Turn on the sql gateway logging - the answer to your problem will be in there


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
Sent: Wednesday, 9 August 2017 2:57:33 PM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

No, it is online query with no/before as end task conditions. I literally just pasted query into direct SQL screen, pressed APG option and chose browse then run program. The direct sql task is a sub task of a yes/after batch task that calls the direct sql task in TP but I would expect the online direct SQL task to show me all records

 

Adam Jackson|Project Manager - Business Systems|McLaren Racing Limited


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Erwin van den Assem via Groups.Io <erwin.assem@...>
Sent: Wednesday, August 9, 2017 9:08:45 AM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Hi Adam

May be End task condition is set to Yes and Evaluate condition is set to After updating record in Task properties.
What does the Magic logfile tells you ?

 

Erwin


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478

The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


Re: Direct SQL

Jackson, Adam
 

Have looked at database settings and there are a couple of secret names used in “database information” window for username and password. Have asked my DBA to see if that account has sufficient permissions

 

Adam Jackson | Project Manager – Business Systems | McLaren Racing Limited

McLaren Technology Centre, Chertsey Road, Woking, Surrey GU21 4YH, UK

 

T  +44 (0) 01483 261039

E  adam.jackson@...

W  www.mclaren.com

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Tim Downie
Sent: 10 August 2017 12:14
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Did you apg the magic task that has your sql statement - if not try this.

Are you using trusted sql security...or user name/password in magic.ini?


Next thing is run and sql magic task to get sql pid.
Sql.task with exec sp_who...from memory
Then sql profile this session.

Im thinking somehow magic is connnecting with a different user/permission


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
Sent: Thursday, 10 August 2017 11:00:32 AM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Change of tack – moved to trying:

 

select distinct count(loginame) as 'user_count' from sys.sysprocesses

 

 

 

In MSSQL get 75, in excel get 75 in xpa get 1

 

As before I just cut and pasted the query from MSSQL into both excel and xpa. In xpa I just ran APG and then program. Little or no interference from me as possible yet the simplest of programs does not work – beyond frustrated.

 

In log with customer setting I get below and when I copy back into MSSQL it works ok.

 

<106109614830671264> 10/08/2017 11:57:22.265     [Action ] -      ,89021  SET IMPLICIT_TRANSACTIONS ON

<106109614830671264> 10/08/2017 11:57:22.265     [Action ] -      ,89021  

                STMT: select distinct count(loginame) as 'user_count' from sys.sysprocesses

<106109614830671264> 10/08/2017 11:57:22.265     [Action ] -      ,89021  

                STMT: select distinct count(loginame) as 'user_count' from sys.sysprocesses

<106109614830671264> 10/08/2017 11:57:22.265     [Action ] -      ,89021  logical cursor: using COMMAND :Default result Set

<106109614830671264> 10/08/2017 11:57:22.281     [Action ] -      ,89037                  FETCH Read0

<106109614830671264> 10/08/2017 11:57:22.281     [Action ] -      ,89037  SET IMPLICIT_TRANSACTIONS OFF

 

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Jackson, Adam
Sent: 10 August 2017 08:52
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Tried with full developer trace and the only RESULT line was the one record I am getting which BTW is for my connection so could this be a permissions thing? Our DBA says not and all the time my record was the first record I did not question it but now the first record according to MSSQL studio is a NULL/blank record so if my results set was limited to 1 record then surely I would get that?

 

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Jackson, Adam
Sent: 10 August 2017 08:26
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

HI,

 

Tried that and got below which seems OK. Still only showing one record in xpa but 7 in MSSQL Studio

 

 

<158285391664954432> 10/08/2017 08:19:11.271     [Action ] -     >>Starts load Batch Task - 'C:Get User Count' in Modify mode (Task Instance: 6631, Resident)

<158285391664954432> 10/08/2017 08:19:11.271     [Action ] -     Ends Load Task

<158285391664954432> 10/08/2017 08:19:12.597     [Action ] -     Task Mode Change - Modify

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Load records

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Read Transaction 0

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Commit Transaction 0

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Starts Record Suffix

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -       Flow - Call SubTask :: Get count

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -         Write Physical Transaction 6632

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -         2,99398  SET IMPLICIT_TRANSACTIONS ON

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -          ,99398  

                STMT: SELECT distinct

    loginame as LoginName

FROM

    sys.sysprocesses

WHERE

    DB_NAME(dbid)='Javelin'

GROUP BY

 loginame

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -          ,99398  

                STMT: SELECT distinct

    loginame as LoginName

FROM

    sys.sysprocesses

WHERE

    DB_NAME(dbid)='Javelin'

GROUP BY

 loginame

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -          ,99398  logical cursor: using COMMAND :Default result Set

<158285391664954432> 10/08/2017 08:19:12.643     [Action ] -          ,99414              FETCH Read0

<158285391664954432> 10/08/2017 08:19:12.643     [Action ] -          ,99414  SET IMPLICIT_TRANSACTIONS OFF

<158285391664954432> 10/08/2017 08:19:12.643     [Action ] -         Commit Transaction 6632

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Open DB Table - 'C:\Users\adam.jackson\AppData\Local\Temp\MG1761615828539166495443070.mem (#0) (W,N)'

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         >>Starts load Online Task - 'Get count' in Query mode (Task Instance: 6632)

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Ends Load Task

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Task Mode Change - Query

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Read Transaction 0

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Load records

<158285391664954432> 10/08/2017 08:19:12.721     [Action ] -         Commit Transaction 0

<158285391664954432> 10/08/2017 08:19:12.721     [Action ] -         Flow - Variable Column  'LoginName' (Step Forward) 

 <158285391664954432> 10/08/2017 08:19:14.967     [Action ] -         >>  Processing Event  [Close]  Control Name :  [ N/A ]

 <158285391664954432> 10/08/2017 08:19:14.983     [Action ] -         >>  Processing Event  [Exit]  Control Name :  [ N/A ]

 <158285391664954432> 10/08/2017 08:19:14.983     [Action ] -         Starts Closing Online Task - 'Get count' (Task Instance: 6632)

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       <<Ends Close Task

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       Task Mode Change - Modify

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       Flow - Condition: Exp = 78, Result = False

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       Flow - Call SubTask :: Update [Not Executed]

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -     Ends Record Suffix

<158285391664954432> 10/08/2017 08:19:16.043     [Action ] -     Starts Closing Batch Task - 'C:Get User Count' (Task Instance: 6631)

<158285391664954432> 10/08/2017 08:19:16.075     [Action ] -   <<Ends Close Task

<158285391664954432> 10/08/2017 08:19:16.075     [Action ] -   >>  Processing Event  [Exit System]  Control Name :  [ N/A ]

 <158285391664954432> 10/08/2017 08:19:16.075     [Info   ] -   Context released :

 

 

 

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Tim Downie
Sent: 09 August 2017 22:09
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Hi
Turn on the sql gateway logging - the answer to your problem will be in there


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
Sent: Wednesday, 9 August 2017 2:57:33 PM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

No, it is online query with no/before as end task conditions. I literally just pasted query into direct SQL screen, pressed APG option and chose browse then run program. The direct sql task is a sub task of a yes/after batch task that calls the direct sql task in TP but I would expect the online direct SQL task to show me all records

 

Adam Jackson|Project Manager - Business Systems|McLaren Racing Limited


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Erwin van den Assem via Groups.Io <erwin.assem@...>
Sent: Wednesday, August 9, 2017 9:08:45 AM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Hi Adam

May be End task condition is set to Yes and Evaluate condition is set to After updating record in Task properties.
What does the Magic logfile tells you ?

 

Erwin


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


Re: Direct SQL

Tim Downie
 

Did you apg the magic task that has your sql statement - if not try this.

Are you using trusted sql security...or user name/password in magic.ini?


Next thing is run and sql magic task to get sql pid.
Sql.task with exec sp_who...from memory
Then sql profile this session.

Im thinking somehow magic is connnecting with a different user/permission


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
Sent: Thursday, 10 August 2017 11:00:32 AM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL
 

Change of tack – moved to trying:

 

select distinct count(loginame) as 'user_count' from sys.sysprocesses

 

 

 

In MSSQL get 75, in excel get 75 in xpa get 1

 

As before I just cut and pasted the query from MSSQL into both excel and xpa. In xpa I just ran APG and then program. Little or no interference from me as possible yet the simplest of programs does not work – beyond frustrated.

 

In log with customer setting I get below and when I copy back into MSSQL it works ok.

 

<106109614830671264> 10/08/2017 11:57:22.265     [Action ] -      ,89021  SET IMPLICIT_TRANSACTIONS ON

<106109614830671264> 10/08/2017 11:57:22.265     [Action ] -      ,89021  

                STMT: select distinct count(loginame) as 'user_count' from sys.sysprocesses

<106109614830671264> 10/08/2017 11:57:22.265     [Action ] -      ,89021  

                STMT: select distinct count(loginame) as 'user_count' from sys.sysprocesses

<106109614830671264> 10/08/2017 11:57:22.265     [Action ] -      ,89021  logical cursor: using COMMAND :Default result Set

<106109614830671264> 10/08/2017 11:57:22.281     [Action ] -      ,89037                  FETCH Read0

<106109614830671264> 10/08/2017 11:57:22.281     [Action ] -      ,89037  SET IMPLICIT_TRANSACTIONS OFF

 

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Jackson, Adam
Sent: 10 August 2017 08:52
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Tried with full developer trace and the only RESULT line was the one record I am getting which BTW is for my connection so could this be a permissions thing? Our DBA says not and all the time my record was the first record I did not question it but now the first record according to MSSQL studio is a NULL/blank record so if my results set was limited to 1 record then surely I would get that?

 

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Jackson, Adam
Sent: 10 August 2017 08:26
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

HI,

 

Tried that and got below which seems OK. Still only showing one record in xpa but 7 in MSSQL Studio

 

 

<158285391664954432> 10/08/2017 08:19:11.271     [Action ] -     >>Starts load Batch Task - 'C:Get User Count' in Modify mode (Task Instance: 6631, Resident)

<158285391664954432> 10/08/2017 08:19:11.271     [Action ] -     Ends Load Task

<158285391664954432> 10/08/2017 08:19:12.597     [Action ] -     Task Mode Change - Modify

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Load records

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Read Transaction 0

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Commit Transaction 0

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Starts Record Suffix

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -       Flow - Call SubTask :: Get count

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -         Write Physical Transaction 6632

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -         2,99398  SET IMPLICIT_TRANSACTIONS ON

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -          ,99398  

                STMT: SELECT distinct

    loginame as LoginName

FROM

    sys.sysprocesses

WHERE

    DB_NAME(dbid)='Javelin'

GROUP BY

 loginame

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -          ,99398  

                STMT: SELECT distinct

    loginame as LoginName

FROM

    sys.sysprocesses

WHERE

    DB_NAME(dbid)='Javelin'

GROUP BY

 loginame

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -          ,99398  logical cursor: using COMMAND :Default result Set

<158285391664954432> 10/08/2017 08:19:12.643     [Action ] -          ,99414              FETCH Read0

<158285391664954432> 10/08/2017 08:19:12.643     [Action ] -          ,99414  SET IMPLICIT_TRANSACTIONS OFF

<158285391664954432> 10/08/2017 08:19:12.643     [Action ] -         Commit Transaction 6632

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Open DB Table - 'C:\Users\adam.jackson\AppData\Local\Temp\MG1761615828539166495443070.mem (#0) (W,N)'

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         >>Starts load Online Task - 'Get count' in Query mode (Task Instance: 6632)

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Ends Load Task

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Task Mode Change - Query

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Read Transaction 0

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Load records

<158285391664954432> 10/08/2017 08:19:12.721     [Action ] -         Commit Transaction 0

<158285391664954432> 10/08/2017 08:19:12.721     [Action ] -         Flow - Variable Column  'LoginName' (Step Forward) 

 <158285391664954432> 10/08/2017 08:19:14.967     [Action ] -         >>  Processing Event  [Close]  Control Name :  [ N/A ]

 <158285391664954432> 10/08/2017 08:19:14.983     [Action ] -         >>  Processing Event  [Exit]  Control Name :  [ N/A ]

 <158285391664954432> 10/08/2017 08:19:14.983     [Action ] -         Starts Closing Online Task - 'Get count' (Task Instance: 6632)

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       <<Ends Close Task

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       Task Mode Change - Modify

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       Flow - Condition: Exp = 78, Result = False

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       Flow - Call SubTask :: Update [Not Executed]

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -     Ends Record Suffix

<158285391664954432> 10/08/2017 08:19:16.043     [Action ] -     Starts Closing Batch Task - 'C:Get User Count' (Task Instance: 6631)

<158285391664954432> 10/08/2017 08:19:16.075     [Action ] -   <<Ends Close Task

<158285391664954432> 10/08/2017 08:19:16.075     [Action ] -   >>  Processing Event  [Exit System]  Control Name :  [ N/A ]

 <158285391664954432> 10/08/2017 08:19:16.075     [Info   ] -   Context released :

 

 

 

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Tim Downie
Sent: 09 August 2017 22:09
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Hi
Turn on the sql gateway logging - the answer to your problem will be in there


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
Sent: Wednesday, 9 August 2017 2:57:33 PM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

No, it is online query with no/before as end task conditions. I literally just pasted query into direct SQL screen, pressed APG option and chose browse then run program. The direct sql task is a sub task of a yes/after batch task that calls the direct sql task in TP but I would expect the online direct SQL task to show me all records

 

Adam Jackson|Project Manager - Business Systems|McLaren Racing Limited


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Erwin van den Assem via Groups.Io <erwin.assem@...>
Sent: Wednesday, August 9, 2017 9:08:45 AM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Hi Adam

May be End task condition is set to Yes and Evaluate condition is set to After updating record in Task properties.
What does the Magic logfile tells you ?

 

Erwin


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


Re: Direct SQL

Jackson, Adam
 

Change of tack – moved to trying:

 

select distinct count(loginame) as 'user_count' from sys.sysprocesses

 

 

 

In MSSQL get 75, in excel get 75 in xpa get 1

 

As before I just cut and pasted the query from MSSQL into both excel and xpa. In xpa I just ran APG and then program. Little or no interference from me as possible yet the simplest of programs does not work – beyond frustrated.

 

In log with customer setting I get below and when I copy back into MSSQL it works ok.

 

<106109614830671264> 10/08/2017 11:57:22.265     [Action ] -      ,89021  SET IMPLICIT_TRANSACTIONS ON

<106109614830671264> 10/08/2017 11:57:22.265     [Action ] -      ,89021  

                STMT: select distinct count(loginame) as 'user_count' from sys.sysprocesses

<106109614830671264> 10/08/2017 11:57:22.265     [Action ] -      ,89021  

                STMT: select distinct count(loginame) as 'user_count' from sys.sysprocesses

<106109614830671264> 10/08/2017 11:57:22.265     [Action ] -      ,89021  logical cursor: using COMMAND :Default result Set

<106109614830671264> 10/08/2017 11:57:22.281     [Action ] -      ,89037                  FETCH Read0

<106109614830671264> 10/08/2017 11:57:22.281     [Action ] -      ,89037  SET IMPLICIT_TRANSACTIONS OFF

 

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Jackson, Adam
Sent: 10 August 2017 08:52
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Tried with full developer trace and the only RESULT line was the one record I am getting which BTW is for my connection so could this be a permissions thing? Our DBA says not and all the time my record was the first record I did not question it but now the first record according to MSSQL studio is a NULL/blank record so if my results set was limited to 1 record then surely I would get that?

 

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Jackson, Adam
Sent: 10 August 2017 08:26
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

HI,

 

Tried that and got below which seems OK. Still only showing one record in xpa but 7 in MSSQL Studio

 

 

<158285391664954432> 10/08/2017 08:19:11.271     [Action ] -     >>Starts load Batch Task - 'C:Get User Count' in Modify mode (Task Instance: 6631, Resident)

<158285391664954432> 10/08/2017 08:19:11.271     [Action ] -     Ends Load Task

<158285391664954432> 10/08/2017 08:19:12.597     [Action ] -     Task Mode Change - Modify

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Load records

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Read Transaction 0

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Commit Transaction 0

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Starts Record Suffix

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -       Flow - Call SubTask :: Get count

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -         Write Physical Transaction 6632

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -         2,99398  SET IMPLICIT_TRANSACTIONS ON

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -          ,99398  

                STMT: SELECT distinct

    loginame as LoginName

FROM

    sys.sysprocesses

WHERE

    DB_NAME(dbid)='Javelin'

GROUP BY

 loginame

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -          ,99398  

                STMT: SELECT distinct

    loginame as LoginName

FROM

    sys.sysprocesses

WHERE

    DB_NAME(dbid)='Javelin'

GROUP BY

 loginame

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -          ,99398  logical cursor: using COMMAND :Default result Set

<158285391664954432> 10/08/2017 08:19:12.643     [Action ] -          ,99414              FETCH Read0

<158285391664954432> 10/08/2017 08:19:12.643     [Action ] -          ,99414  SET IMPLICIT_TRANSACTIONS OFF

<158285391664954432> 10/08/2017 08:19:12.643     [Action ] -         Commit Transaction 6632

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Open DB Table - 'C:\Users\adam.jackson\AppData\Local\Temp\MG1761615828539166495443070.mem (#0) (W,N)'

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         >>Starts load Online Task - 'Get count' in Query mode (Task Instance: 6632)

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Ends Load Task

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Task Mode Change - Query

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Read Transaction 0

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Load records

<158285391664954432> 10/08/2017 08:19:12.721     [Action ] -         Commit Transaction 0

<158285391664954432> 10/08/2017 08:19:12.721     [Action ] -         Flow - Variable Column  'LoginName' (Step Forward) 

 <158285391664954432> 10/08/2017 08:19:14.967     [Action ] -         >>  Processing Event  [Close]  Control Name :  [ N/A ]

 <158285391664954432> 10/08/2017 08:19:14.983     [Action ] -         >>  Processing Event  [Exit]  Control Name :  [ N/A ]

 <158285391664954432> 10/08/2017 08:19:14.983     [Action ] -         Starts Closing Online Task - 'Get count' (Task Instance: 6632)

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       <<Ends Close Task

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       Task Mode Change - Modify

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       Flow - Condition: Exp = 78, Result = False

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       Flow - Call SubTask :: Update [Not Executed]

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -     Ends Record Suffix

<158285391664954432> 10/08/2017 08:19:16.043     [Action ] -     Starts Closing Batch Task - 'C:Get User Count' (Task Instance: 6631)

<158285391664954432> 10/08/2017 08:19:16.075     [Action ] -   <<Ends Close Task

<158285391664954432> 10/08/2017 08:19:16.075     [Action ] -   >>  Processing Event  [Exit System]  Control Name :  [ N/A ]

 <158285391664954432> 10/08/2017 08:19:16.075     [Info   ] -   Context released :

 

 

 

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Tim Downie
Sent: 09 August 2017 22:09
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Hi
Turn on the sql gateway logging - the answer to your problem will be in there


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
Sent: Wednesday, 9 August 2017 2:57:33 PM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

No, it is online query with no/before as end task conditions. I literally just pasted query into direct SQL screen, pressed APG option and chose browse then run program. The direct sql task is a sub task of a yes/after batch task that calls the direct sql task in TP but I would expect the online direct SQL task to show me all records

 

Adam Jackson|Project Manager - Business Systems|McLaren Racing Limited


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Erwin van den Assem via Groups.Io <erwin.assem@...>
Sent: Wednesday, August 9, 2017 9:08:45 AM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Hi Adam

May be End task condition is set to Yes and Evaluate condition is set to After updating record in Task properties.
What does the Magic logfile tells you ?

 

Erwin


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


Re: Direct SQL

Tim Downie
 

You need to get to a point you can find the concise sql its running in the magic logs...paste this into sql studio

I only check gateway logging, put a log filename the selected the sql dbms log level to customer. With this you can cut and paste sql.directly from the log to run it

The other option use sql profiler to profile the connection
From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Stanko Karlovčec <stane@...>
Sent: Thursday, 10 August 2017 7:55:37 AM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL
 

HI Adam,

 

It would be good to look in your DB log file and also check the index settings!?

 

BR

 

Stane


Stanko Karlovčec
Direktor
- EPOS
Krčkova 15, 2204 Miklavž na D.p.
Telephone: +38626290110 / Fax: +386 26290104 / Mobile: +386 41770095

Izjava o omejitvi odgovornosti
To elektronsko sporočilo in vse njegove morebitne priloge lahko vsebujejo zaupne in/ali privilegirane informacije in so last EPOS s.p. ali EPOS PRO d.o.o. ter namenjene izključno naslovniku. Kolikor ste sporočilo prejeli pomotoma, vas prosimo, da o tem obvestite pošiljatelja, sporočilo pa takoj uničite. Kakršnokoli nepooblaščeno razkritje, distribucija ali kopiranje vsebine sporočila je izrecno prepovedano. Mnenja, vsebovana v tem elektronskem sporočilu, ne odražajo nujno tudi stališč EPOS s.p. ali EPOS PRO d.o.o.

Legal disclaimer statement
This e-mail and any attachments may contain confidential and/or privileged information that is a property of EPOS s.p. ali EPOS PRO d.o.o. and intended solely for the addressee. If you are not the intended recipient (or have received this e-mail by mistake), please notify the sender immediately and destroy this e-mail. Any unauthorized reproduction, disclosure or distribution of the material in this e-mail is strictly forbidden. Opinions contained in this e-mail do not necessarily reflect the opinions of EPOS s.p. ali EPOS PRO d.o.o.


Re: Using Font Awesome

Peter Ashworth
 

Hi Jim

I can't see how you could use Font Awesome natively in magic, because in the font editor you can only zoom and pick fonts installed on windows. (as long as they are true type fonts as they dropped support for some others). Although if anyone else knows differently I would be interested to know.

Depending on how many of the icons you want to use, and how many you want to be able to resize/recolour on the fly.

If you only have 5 icons of static size and 1 or maybe 2 colours, you could always render them on a web page, screen shot it, edit the photo to give it transparancy (can't remember if transparency is supported 1.9 onwards as we still use 9.4 and it isn't.), and then just render them as local images as and when you want to use them. Although if its wanted in the middle of dynamic length text that's not really workable.

Otherwise if you need the resizing and colour, or you want to use lots of them, you could try and find a control (probably a third party dll as I don't think magic has a native control to display web content in the client/server apps, just an rtf control. Although in xpa3.2 you could possibly leverage .net to render some html) to render a small amount of html, and in the header of the html include the links to load font awesome.

Neither of these are nice or neat and come across a bit hacky (and I'm not 100% sure how viable the second option is), but depending on your use case might be of some relevance.

Hope this helps

Peter


Re: Direct SQL

Stanko Karlovčec
 

HI Adam,

 

It would be good to look in your DB log file and also check the index settings!?

 

BR

 

Stane


Stanko Karlovčec
Direktor
- EPOS
Krčkova 15, 2204 Miklavž na D.p.
Telephone: +38626290110 / Fax: +386 26290104 / Mobile: +386 41770095

Izjava o omejitvi odgovornosti
To elektronsko sporočilo in vse njegove morebitne priloge lahko vsebujejo zaupne in/ali privilegirane informacije in so last EPOS s.p. ali EPOS PRO d.o.o. ter namenjene izključno naslovniku. Kolikor ste sporočilo prejeli pomotoma, vas prosimo, da o tem obvestite pošiljatelja, sporočilo pa takoj uničite. Kakršnokoli nepooblaščeno razkritje, distribucija ali kopiranje vsebine sporočila je izrecno prepovedano. Mnenja, vsebovana v tem elektronskem sporočilu, ne odražajo nujno tudi stališč EPOS s.p. ali EPOS PRO d.o.o.

Legal disclaimer statement
This e-mail and any attachments may contain confidential and/or privileged information that is a property of EPOS s.p. ali EPOS PRO d.o.o. and intended solely for the addressee. If you are not the intended recipient (or have received this e-mail by mistake), please notify the sender immediately and destroy this e-mail. Any unauthorized reproduction, disclosure or distribution of the material in this e-mail is strictly forbidden. Opinions contained in this e-mail do not necessarily reflect the opinions of EPOS s.p. ali EPOS PRO d.o.o.


Re: Direct SQL

Jackson, Adam
 

Tried with full developer trace and the only RESULT line was the one record I am getting which BTW is for my connection so could this be a permissions thing? Our DBA says not and all the time my record was the first record I did not question it but now the first record according to MSSQL studio is a NULL/blank record so if my results set was limited to 1 record then surely I would get that?

 

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Jackson, Adam
Sent: 10 August 2017 08:26
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

HI,

 

Tried that and got below which seems OK. Still only showing one record in xpa but 7 in MSSQL Studio

 

 

<158285391664954432> 10/08/2017 08:19:11.271     [Action ] -     >>Starts load Batch Task - 'C:Get User Count' in Modify mode (Task Instance: 6631, Resident)

<158285391664954432> 10/08/2017 08:19:11.271     [Action ] -     Ends Load Task

<158285391664954432> 10/08/2017 08:19:12.597     [Action ] -     Task Mode Change - Modify

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Load records

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Read Transaction 0

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Commit Transaction 0

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Starts Record Suffix

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -       Flow - Call SubTask :: Get count

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -         Write Physical Transaction 6632

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -         2,99398  SET IMPLICIT_TRANSACTIONS ON

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -          ,99398  

                STMT: SELECT distinct

    loginame as LoginName

FROM

    sys.sysprocesses

WHERE

    DB_NAME(dbid)='Javelin'

GROUP BY

 loginame

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -          ,99398  

                STMT: SELECT distinct

    loginame as LoginName

FROM

    sys.sysprocesses

WHERE

    DB_NAME(dbid)='Javelin'

GROUP BY

 loginame

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -          ,99398  logical cursor: using COMMAND :Default result Set

<158285391664954432> 10/08/2017 08:19:12.643     [Action ] -          ,99414              FETCH Read0

<158285391664954432> 10/08/2017 08:19:12.643     [Action ] -          ,99414  SET IMPLICIT_TRANSACTIONS OFF

<158285391664954432> 10/08/2017 08:19:12.643     [Action ] -         Commit Transaction 6632

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Open DB Table - 'C:\Users\adam.jackson\AppData\Local\Temp\MG1761615828539166495443070.mem (#0) (W,N)'

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         >>Starts load Online Task - 'Get count' in Query mode (Task Instance: 6632)

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Ends Load Task

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Task Mode Change - Query

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Read Transaction 0

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Load records

<158285391664954432> 10/08/2017 08:19:12.721     [Action ] -         Commit Transaction 0

<158285391664954432> 10/08/2017 08:19:12.721     [Action ] -         Flow - Variable Column  'LoginName' (Step Forward) 

 <158285391664954432> 10/08/2017 08:19:14.967     [Action ] -         >>  Processing Event  [Close]  Control Name :  [ N/A ]

 <158285391664954432> 10/08/2017 08:19:14.983     [Action ] -         >>  Processing Event  [Exit]  Control Name :  [ N/A ]

 <158285391664954432> 10/08/2017 08:19:14.983     [Action ] -         Starts Closing Online Task - 'Get count' (Task Instance: 6632)

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       <<Ends Close Task

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       Task Mode Change - Modify

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       Flow - Condition: Exp = 78, Result = False

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       Flow - Call SubTask :: Update [Not Executed]

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -     Ends Record Suffix

<158285391664954432> 10/08/2017 08:19:16.043     [Action ] -     Starts Closing Batch Task - 'C:Get User Count' (Task Instance: 6631)

<158285391664954432> 10/08/2017 08:19:16.075     [Action ] -   <<Ends Close Task

<158285391664954432> 10/08/2017 08:19:16.075     [Action ] -   >>  Processing Event  [Exit System]  Control Name :  [ N/A ]

 <158285391664954432> 10/08/2017 08:19:16.075     [Info   ] -   Context released :

 

 

 

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Tim Downie
Sent: 09 August 2017 22:09
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Hi
Turn on the sql gateway logging - the answer to your problem will be in there


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
Sent: Wednesday, 9 August 2017 2:57:33 PM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

No, it is online query with no/before as end task conditions. I literally just pasted query into direct SQL screen, pressed APG option and chose browse then run program. The direct sql task is a sub task of a yes/after batch task that calls the direct sql task in TP but I would expect the online direct SQL task to show me all records

 

Adam Jackson|Project Manager - Business Systems|McLaren Racing Limited


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Erwin van den Assem via Groups.Io <erwin.assem@...>
Sent: Wednesday, August 9, 2017 9:08:45 AM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Hi Adam

May be End task condition is set to Yes and Evaluate condition is set to After updating record in Task properties.
What does the Magic logfile tells you ?

 

Erwin


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


GigaSpace license mechanish

Gábor Bor
 

Dear Magic Developers!

I would like to ask you, please explain me, how the GigaSpace license management works contrary to Broker's mechanism. (I mean the network broadcast packages)

Best regards, Gábor


Re: Direct SQL

Jackson, Adam
 

HI,

 

Tried that and got below which seems OK. Still only showing one record in xpa but 7 in MSSQL Studio

 

 

<158285391664954432> 10/08/2017 08:19:11.271     [Action ] -     >>Starts load Batch Task - 'C:Get User Count' in Modify mode (Task Instance: 6631, Resident)

<158285391664954432> 10/08/2017 08:19:11.271     [Action ] -     Ends Load Task

<158285391664954432> 10/08/2017 08:19:12.597     [Action ] -     Task Mode Change - Modify

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Load records

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Read Transaction 0

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Commit Transaction 0

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -     Starts Record Suffix

<158285391664954432> 10/08/2017 08:19:12.612     [Action ] -       Flow - Call SubTask :: Get count

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -         Write Physical Transaction 6632

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -         2,99398  SET IMPLICIT_TRANSACTIONS ON

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -          ,99398  

                STMT: SELECT distinct

    loginame as LoginName

FROM

    sys.sysprocesses

WHERE

    DB_NAME(dbid)='Javelin'

GROUP BY

 loginame

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -          ,99398  

                STMT: SELECT distinct

    loginame as LoginName

FROM

    sys.sysprocesses

WHERE

    DB_NAME(dbid)='Javelin'

GROUP BY

 loginame

<158285391664954432> 10/08/2017 08:19:12.628     [Action ] -          ,99398  logical cursor: using COMMAND :Default result Set

<158285391664954432> 10/08/2017 08:19:12.643     [Action ] -          ,99414              FETCH Read0

<158285391664954432> 10/08/2017 08:19:12.643     [Action ] -          ,99414  SET IMPLICIT_TRANSACTIONS OFF

<158285391664954432> 10/08/2017 08:19:12.643     [Action ] -         Commit Transaction 6632

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Open DB Table - 'C:\Users\adam.jackson\AppData\Local\Temp\MG1761615828539166495443070.mem (#0) (W,N)'

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         >>Starts load Online Task - 'Get count' in Query mode (Task Instance: 6632)

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Ends Load Task

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Task Mode Change - Query

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Read Transaction 0

<158285391664954432> 10/08/2017 08:19:12.706     [Action ] -         Load records

<158285391664954432> 10/08/2017 08:19:12.721     [Action ] -         Commit Transaction 0

<158285391664954432> 10/08/2017 08:19:12.721     [Action ] -         Flow - Variable Column  'LoginName' (Step Forward) 

 <158285391664954432> 10/08/2017 08:19:14.967     [Action ] -         >>  Processing Event  [Close]  Control Name :  [ N/A ]

 <158285391664954432> 10/08/2017 08:19:14.983     [Action ] -         >>  Processing Event  [Exit]  Control Name :  [ N/A ]

 <158285391664954432> 10/08/2017 08:19:14.983     [Action ] -         Starts Closing Online Task - 'Get count' (Task Instance: 6632)

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       <<Ends Close Task

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       Task Mode Change - Modify

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       Flow - Condition: Exp = 78, Result = False

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -       Flow - Call SubTask :: Update [Not Executed]

<158285391664954432> 10/08/2017 08:19:14.998     [Action ] -     Ends Record Suffix

<158285391664954432> 10/08/2017 08:19:16.043     [Action ] -     Starts Closing Batch Task - 'C:Get User Count' (Task Instance: 6631)

<158285391664954432> 10/08/2017 08:19:16.075     [Action ] -   <<Ends Close Task

<158285391664954432> 10/08/2017 08:19:16.075     [Action ] -   >>  Processing Event  [Exit System]  Control Name :  [ N/A ]

 <158285391664954432> 10/08/2017 08:19:16.075     [Info   ] -   Context released :

 

 

 

 

From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of Tim Downie
Sent: 09 August 2017 22:09
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Hi
Turn on the sql gateway logging - the answer to your problem will be in there


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
Sent: Wednesday, 9 August 2017 2:57:33 PM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

No, it is online query with no/before as end task conditions. I literally just pasted query into direct SQL screen, pressed APG option and chose browse then run program. The direct sql task is a sub task of a yes/after batch task that calls the direct sql task in TP but I would expect the online direct SQL task to show me all records

 

Adam Jackson|Project Manager - Business Systems|McLaren Racing Limited


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Erwin van den Assem via Groups.Io <erwin.assem@...>
Sent: Wednesday, August 9, 2017 9:08:45 AM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL

 

Hi Adam

May be End task condition is set to Yes and Evaluate condition is set to After updating record in Task properties.
What does the Magic logfile tells you ?

 

Erwin


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


Re: Direct SQL

Tim Downie
 

Hi
Turn on the sql gateway logging - the answer to your problem will be in there
From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...>
Sent: Wednesday, 9 August 2017 2:57:33 PM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL
 
No, it is online query with no/before as end task conditions. I literally just pasted query into direct SQL screen, pressed APG option and chose browse then run program. The direct sql task is a sub task of a yes/after batch task that calls the direct sql task in TP but I would expect the online direct SQL task to show me all records

Adam Jackson|Project Manager - Business Systems|McLaren Racing Limited


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Erwin van den Assem via Groups.Io <erwin.assem@...>
Sent: Wednesday, August 9, 2017 9:08:45 AM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL
 

Hi Adam

May be End task condition is set to Yes and Evaluate condition is set to After updating record in Task properties.
What does the Magic logfile tells you ?

 

Erwin


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


Re: Direct SQL

Jackson, Adam
 

No, it is online query with no/before as end task conditions. I literally just pasted query into direct SQL screen, pressed APG option and chose browse then run program. The direct sql task is a sub task of a yes/after batch task that calls the direct sql task in TP but I would expect the online direct SQL task to show me all records

Adam Jackson|Project Manager - Business Systems|McLaren Racing Limited


From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Erwin van den Assem via Groups.Io <erwin.assem@...>
Sent: Wednesday, August 9, 2017 9:08:45 AM
To: main@magicu-l.groups.io
Subject: Re: [magicu-l] Direct SQL
 

Hi Adam

May be End task condition is set to Yes and Evaluate condition is set to After updating record in Task properties.
What does the Magic logfile tells you ?

 

Erwin


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


Re: Direct SQL

Erwin van den Assem
 

Hi Adam

May be End task condition is set to Yes and Evaluate condition is set to After updating record in Task properties.
What does the Magic logfile tells you ?

 

Erwin


Direct SQL

Jackson, Adam
 

Hi,

 

I have a query that returns me 4 records in SQL server but only one when I use it as direct sql. I just coped and pasted query into direct sql screen and used APG option then ran it. I have a return database as Memory. What am I doing wrong?

 

Xpa 2.5

 

Adam

 

 


The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited | McLaren Technology Centre | Chertsey Road | Woking | Surrey | GU21 4YH | UK | Company Number: 01517478


Re: Android context menu

Todd Baremore
 

Thanks Newton


On 8/8/2017 6:23 AM, Lawrence Fisher via Groups.Io wrote:
Law of conservation of bugs
 
Regards

Lawrence
Author of the award winning book, "Kill Me Now!", amusing stories from the world of dating



From: Todd Baremore <tbaremor@...>
To: main@magicu-l.groups.io
Sent: Monday, August 7, 2017 4:12 PM
Subject: Re: [magicu-l] Android context menu

Thanks Lawrence.  Unfortunately it does not work for any controls placed on a Tab control. :-(
Todd

On 8/7/2017 5:01 AM, Lawrence Fisher via Groups.Io wrote:
The Long Press raises the Press event. I believe you have to handle it yourself

 
Regards

Lawrence
Author of the award winning book, "Kill Me Now!", amusing stories from the world of dating



From: Todd Baremore <tbaremor@...>
To: main@magicu-l.groups.io
Sent: Sunday, August 6, 2017 8:36 PM
Subject: [magicu-l] Android context menu

XPA 3.2c, Android 6/7

Rich Client - Interactive - Offline Task in Query mode
Table with 2 columns.  On the variable for column 2, I have assigned a
context menu.  F8 and all is well.

On an Android device, when I long press on the field above nothing happens.
Not supported?  I'm doing something wrong?

Todd











Re: Android context menu

Lawrence Fisher
 

Law of conservation of bugs
 
Regards

Lawrence
Author of the award winning book, "Kill Me Now!", amusing stories from the world of dating



From: Todd Baremore <tbaremor@...>
To: main@magicu-l.groups.io
Sent: Monday, August 7, 2017 4:12 PM
Subject: Re: [magicu-l] Android context menu

Thanks Lawrence.  Unfortunately it does not work for any controls placed on a Tab control. :-(
Todd

On 8/7/2017 5:01 AM, Lawrence Fisher via Groups.Io wrote:
The Long Press raises the Press event. I believe you have to handle it yourself

 
Regards

Lawrence
Author of the award winning book, "Kill Me Now!", amusing stories from the world of dating



From: Todd Baremore <tbaremor@...>
To: main@magicu-l.groups.io
Sent: Sunday, August 6, 2017 8:36 PM
Subject: [magicu-l] Android context menu

XPA 3.2c, Android 6/7

Rich Client - Interactive - Offline Task in Query mode
Table with 2 columns.  On the variable for column 2, I have assigned a
context menu.  F8 and all is well.

On an Android device, when I long press on the field above nothing happens.
Not supported?  I'm doing something wrong?

Todd










Re: Displaying image from website in a 9.4 application

sherman levine
 

Steve,

First time's the charm. Many thanks. Didn't even need the header.

Sherm

On 08/07/2017 07:34 PM, Steven Blank wrote:
Sherm,

Try this at home: Update a BLOB variable with the following expression:

HTTPGet('https://www.myclient.com/etc/image.jpg', '','')

You might have to include a header like 'Content-Type: image/jpg'.

But that function should return the file in a blob, which you could then display in a regular image control.

I think.

Steve Blank


At 04:23 PM 8/7/2017, you wrote:
I'd like to display an image from a website on a form and/or in a table.

https://www.myclient.com/etc/image.jpg

Is there a straightforward way to accomplish this?

Everything else is traditional client-server

Thanks

Sherm





Re: Displaying image from website in a 9.4 application

Steven Blank
 

Sherm,

Try this at home: Update a BLOB variable with the following expression:

HTTPGet('https://www.myclient.com/etc/image.jpg', '','')

You might have to include a header like 'Content-Type: image/jpg'.

But that function should return the file in a blob, which you could then display in a regular image control.

I think.

Steve Blank

At 04:23 PM 8/7/2017, you wrote:
I'd like to display an image from a website on a form and/or in a table.

https://www.myclient.com/etc/image.jpg

Is there a straightforward way to accomplish this?

Everything else is traditional client-server

Thanks

Sherm




Displaying image from website in a 9.4 application

sherman levine
 

I'd like to display an image from a website on a form and/or in a table.

https://www.myclient.com/etc/image.jpg

Is there a straightforward way to accomplish this?

Everything else is traditional client-server

Thanks

Sherm

10441 - 10460 of 195968