Currently in production environment we create a backup of the database every evening and we truncate the logfile.In a test environment database mirroring has been setup and we want to truncate the logfile every evening here as well. However that does...
I had an issue with a webservice used to upload documents into the database. I was trying to figure out what was happening by enabling inbound HTTP logging.
In the end I figured out what was wrong in the code and solved it. However when uploading a d...
When calling an external webservice to download a file in the database the server becomes unresponsive after a certain time for about 1 minute. The following messages are shown in the server console:
2024-03-26 11:04:55.54716 ISQL - Start downloading...
Is it possible to parse the XML below using OpenXML()?
<fields>
<field id="orderid">
<value>3212124</value>
</field>
<field id="damagePic">
<values>
<value-item mimetype="image/jpeg">c0f92afe-f688-49f1-9946-b70...
SQL Anywhere 17 build 6933
We're calling an external webservice from within the database to send data to an external web application. We are using the below procedure to establish this:
create or replace procedure ShuntPlan_API_PostLinkEquipment(in i...
This should do the trick
select distinct
S.MatricNo
,S.Name
,M.Semester
,(select Marks from #Marks where MatricNo = S.MatricNo and Semester = M.Semester and TestID = (select TestID from (select TestID,row_number() over (order by TestID) as R...
Tanks for your input.
If I stop inbound HTTP logging everything is running OK and the error does not occur and the documents are uploaded only once. That's my issue.
So as far I can conclude enabling the logging is causing the error.
Does it matter?
It is an external .NET application where an user is able to upload documents. These documents are uploaded in batch every hour. However when the document could not be uploaded the application will retry it the next time. Because of th...
I fully agree.
Yesterday I spent 1,5 hours to figure out how to be able to only get SQL Anywhere related messages. I gave up.
Besides the personal community content that is missing even the latest questions are not even in there.
Really disappointi...