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

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 -

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

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

Change of tack – moved to trying: selectdistinctcount(loginame)as'user_count'fromsys.sysprocesses In MSSQL get 75, in excel get 75 in xpa get 1 As before I just cut and pasted the

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

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

HI Adam, It would be good to look in your DB log file and also check the index settings!? BR StaneStanko Karlovčec Direktor - EPOS Krčkova 15, 2204 Miklavž na D.p. Telephone:

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

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,

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

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,

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

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

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

Thanks Newton

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

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

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:

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