Question Adrian Izadpanah · Aug 22, 2022 Input XML into SQL server table Hi, I am trying to input an entire xml into a sql server table. I am doing this via an operation in Ensemble. I keep getting the following error [SQL Server]XML parsing: line 0, character 0, unrecognized input signature I have setup the table with a column parameter XML. Here is the request object that is being sent to the store procedure #SQL #XML #Ensemble 0 0 0 434
Question Adrian Izadpanah · Jul 25, 2022 Process XML document Hi all, I am looking at a task which involves processing an XML file. Picking the file up from a folder (c:\test.xml) reading the data out of the XML and archiving the xml after it has been processed. I was wondering what the best way of doing this would be? I have got as far as creating a service in Ensemble. The Service I have created uses the class name EnsLib.XML.Object.Service.FileService. Any advice or tutorials/guides would be much appreciated. Many Thanks #XML #Ensemble 0 3 0 331
Question Adrian Izadpanah · Jun 6, 2022 How to resolve proDOCMAN BPL Error: 5002 : Cache error: <MAXSTRING>zS2+72^pacDOCMAN.proDOCMAN.Thread1.1 Hi All, I am taking a look at some legacy coding as it seems to be generating an error when processing the messaging. The message being process contains a PDF which we are transforming into a stream and sending to another system. I have noticed this issue only occurs with PDFS that are roughly 2800kbs in size or above. All other PDFS process fine. The error that it is generating is proDOCMAN BPL Error: 5002 : Cache error: <MAXSTRING>zS2+72^pacDOCMAN.proDOCMAN.Thread1.1 #Caché 0 8 0 322
Question Adrian Izadpanah · Apr 19, 2021 Create a variable to check if on test or live environment Hi all, I need some help in studio. Is there a way to create a variable to determine if it is in the test or live environment? Thanks Adrian #Caché 0 7 0 317