Question Dustin Knudsen · Aug 5, 2021

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?

1
0 141
Question Dustin Knudsen · Jul 27, 2021

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.

2
0 202
Question Dustin Knudsen · Jul 15, 2021

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?

9
0 741
Question Dustin Knudsen · Jun 28, 2021

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? 

2
0 234
Question Dustin Knudsen · Jun 22, 2021

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?

2
0 180
Question Dustin Knudsen · Jun 7, 2021

One of the business operations recently errored out, and keeps spitting this message:

ERROR <Ens>ErrFailureTimeout: FailureTimeout of 15 seconds exceeded in EnsLib.FTP.PassthroughOperation; status from last attempt was 
ERROR <Ens>ErrOutConnectFailed: SFTP Connect failed for ftp.[censored].com:2222/[censored]/SSL='!SFTP'/PubKey='C:\InterSystems\HealthShare\Keys\pub\[censored]'/PrivKey='C:\InterSystems\HealthShare\Keys\priv\[censored].pem'
with error ERROR #7500: SSH Connect Error '-2146430963': SSH Error [8010100D]: Failed getting banner [8010100d] at Session.cpp:238,0 (alert request ID=45956)

2
0 408
Question Dustin Knudsen · Jun 7, 2021

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? 

2
0 298
Question Dustin Knudsen · May 27, 2021

Hello,

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? 

6
0 220