Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Adding element to an array in data association simple expression

Chris MaggiulliApr 11 2018

I have a human activity that sequences into a service activity. The service activity has the following array as input: body.creditLine[]. In data association I have a transformation between claimFromDataObject.claim.claimLine[] to body.creditLine[]. However, there are some additional values I need to add to creditLine[] array after I add the claimLine[] data. I've tried the following:

"1" -----> body.creditLine[body.creditLine.length+1].quantity

However I dont think this works because how when its evaluated. I think body.creditLine.length is evaluating to 1 even though I map 5 claim lines to credit lines before that. See images below

pastedImage_0.png

and the transofmration from claimLine to creditLine is as follows

pastedImage_2.png

Any thoughts on this? I think if I could get the size of the claimLine on the right hand side maybe that would work?

Comments

Alex Keh-Oracle

I tried your C# app with a table using a DATE column and TIMESTAMP column. In both cases with either ODP.NET Core 2.19.80 or 2.19.70, I didn't hit an error. I used DB 19c. Which DB version did you use?

4252326

I found out that there must be at least one record in the table. For example:

Table Design:

Name
Type
Size
IDNumber0
DateDATE7
TimeTIMESTAMP0
Time2INTERVAL DAY TO SECOND0

Table Data:

ID
DateTimeTime2
1(Null)(Null)(Null)

Then replace the [column] in the sql below:

var sql = $"select(CASE WHEN 1 = 0 THEN a.\"[column]\" ELSE NULL END) as C0 from \"YOUR TABLE NAME\" a ";

 

[Date]: reproduced

[Time]: can't reproduce

[Time2]: reproduced

DB version: 11/12/18/19c

Alex Keh-Oracle

I added the interval column and added one row of data, but still can't reproduce the problem with the 2.19.80 version against the data or interval column. Do you want to send us your trace? Just add these two lines and run your app.

OracleConfiguration.TraceFileLocation = @"D:\traces";

OracleConfiguration.TraceLevel = 7;

You can send the trace file to dotnet_us (at) oracle.com.

4252326

Thank you. The email has been sent. I hope it's useful to you.

Alex Keh-Oracle

This bug appears to be the same as Bug 26123054.

4252326

Will this problem be fixed recently?

Alex Keh-Oracle

The bug hasn't been fixed yet. We're still evaluating the root cause.

Alex Keh-Oracle
Answer

The bug has been fixed in our main code line. My expectation is that the fix will be in the ODP.NET Core 19.10 release.

Marked as Answer by 4252326 · Sep 27 2020
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 9 2018
Added on Apr 11 2018
0 comments
93 views