E9.2 Logic Extension Dates

[Kylee.berger]

Help!

I'm working on my first logic extension where I'm trying to use the table IO feature to write into F06116Z1. I have all the required fields completed, but my date is switching from MM/DD/YYYY to ISO date from the array to where it writes into the table & I cannot seem to find a way to make it stay MM/DD/YYYY, which is required for EDDT & DWK.

 

[Kevin Long]

Hi Kylee,

Could you take a screenshot of your logic extension?

Kevin

 

[Kylee.berger]

Please see attached.

 

[Kevin Long]

Thanks for the pdf. This is helpful, but I do have more questions. What error are you getting? The thing that I'm wondering about is you go through a couple iterations to build out the data for the Final Array, but it is not being used to update the F06116Z1. Do you need to iterate through your Final Array, get each row, and then do the update?

 

[AdrianKaly]

Hi Kylee,

I haven't had much time to look into this, but I've used B34A1000 - Get Date String or Format Mask From UDC Format BSFN previously to manipulate date info with success.

The parameters of the BSFN allow you to select a specific date format output based on UDC values stored in 00/DF.

Hope this is of some help!

 

[Kylee.berger]

Hey Kevin,
So I wasn't getting an error as it was, the table just wasn't updating. I tried moving the table IO to here, and hung my AIS server. Suggestions?

 

[Kylee.berger]

This one also hung my server.

 

[alfredorz]

Hi @Kylee.berger

Could be an infinite loop in TechAIDs or TechCombos while? could you show more details of it? Could you watch AIS logs if there is some errors?

REgards.

 

[JohnDanter2]

I had a very odd issue with dates recently in that the ORCH crashed when called externally but worked in the ORCH studio fine. No errors communicted, but JAS and AIS logs gave a clue (ask CNC what they see)

I traced it back to the callers JDE User ID date formatting. I changed my output from ISO to DD MM YYYY and made the user profile preference match and all errors went away

 

[Kevin Long]

Hi Kylee,

I would start with verifying the values you are passing into your update step. To troubleshoot this, I would start by disabling your update statement (right click and disable) and adding a condition to the Final while loop to limit the number of iterations to 1. Then you can debug the logic extension and see the values you are passing in on that first iteration. Make sure they are correct, and that the fields that are identifying which records to update are correctly mapped. If everything looks good, then re-enable the step. If it hangs your ais server again, you will need to contact your CNC team and see what is going on in the logs.

Kevin

 

[Kylee.berger]

Thanks for the tip on disabling, Kevin! I did build into my LEX to have the arrays be both input/output so I was pretty certain the date formatting is what is causing my issue as all the required fields for the table are met. Its just the last step where it writes to the table that my server gets hung.

 

[Kevin Long]

As I understand it, you are setting the date using the SL Date Today inside of the Logic Extension. The data type of a variable (i.e. string, number, date, etc) is determined by the data dictionary alias you select when you define the variable. When it executes the update statement it is not trying to convert 2024-09-03 to a date. It is actually using the Julian Date value of 124247. The debug is converting 124247 to 2024-09-03.

If calling an update statement is crashing your AIS server, then I would work with your JDE technical team to identify and resolve the issue.