Dustin Knudsen · Aug 5, 2021
DTL record testing error

In the Data Transformation Builder, I have a source record with several values that is connected to a target record with several properties. In the Tools tab, clicking on Test, I have an xml format set up to test the data transformation but I'm getting this error:


ERROR <Ens>ErrNoObjFromString: Failed to find element Record / class BI.process.prodTest.Record in String

Do you know what might be causing this error to happen?

0 1
0 54

In a data transformation, when creating a "set" action, I have a value that looks like this:


..If(..NotIn(source.Records.(k1).Property4,"Learn & Dev Supervisor,Director of Learn & Dev, Clinical Trainer Lead, Learning and Development Specialist Lead"),"TL","3")


Is there a way to target keywords such as "Trainer", or "Learning" so I don't have to keep adding specific job titles? 

Similar to a LIKE statement in SQL, if that makes sense.

0 2
0 91
Dustin Knudsen · Jul 15, 2021
Parsing error

After calling an API with


Do request.Get("/api/address/listing")

Set data = {}.%FromJSON(request.HttpResponse.Data)


I get this error: 


<THROW>%FromJSON+37^%Library.DynamicAbstractObject.1 *%Exception.General Premature end of data 12 Line 1 Offset 0


any clue what might be causing this?


0 9
0 181

Currently have an SFTP server setup to deliver a CSV file to a company "Company XYZ"

Failed to move '\\dir-01\files\Company XYZ\Outbound\To Be Processed\Company XYZ data v1.csv' to Archive file '\\dir-01\files\Company XYZ\Outbound\Archive\Company_XYZ_v1.csv'

The Business Service File Spec : Company XYZ v1.csv

archive path same as listed above

Is it the File Spec that needs to be changed for this to prevent erroring out? 

0 2
0 84
Dustin Knudsen · Jun 22, 2021
content assist

Currently we're using InterSystems Cache Studio Client 2017.2.2 Build 865

I'm currently going through training and one of the videos mentioned using Control+Space to bring up the content assist window.

It's in reference to Atelier IDE, but I'm curious if Studio also might have a tool similar to that?

0 2
0 98
Dustin Knudsen · Jun 7, 2021
File error

Getting this error:

ERROR <Ens>ErrFTPPutFailed: FTP: Failed to Put file 'TestsDaily.xlsx.xlsx' 
(msg='Error in SFTP Put('\\Reporting\reports\Daily-Weekly\TestsDaily\To Be Processed\TestsDaily.xlsx','/TestsDaily.xlsx.xlsx') 
ERROR #7500: SSH Put Error '-2147024894': The system cannot find the file specified. [80070002]',code=0)

is this due to the file extension? Also, if its just because the file isn't there, how to fix that? 

0 2
0 89


I'm quite new at InterSystems. I have a business process that's pointing two different business operations, but one of them I don't want it to point to.

I went through the FileSystem settings, data transformations, classes, and code to see what it could be, but I don't see why its connecting to this second operation. 

What other inner-system mechanics would I need to consider? What have might I have missed? 

0 6
0 82