· 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 67

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 113
· 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 359

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 122
· 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 121
· 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 147


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 99