TaxConnect Bulk Address Validation fails with System.FormatException

Evan_Purdy · July 22, 2024, 5:27pm

We are trying to get tax connect set up. One of the steps is to do a bulk validation. No matter how narrow we make the filter, it takes about 2 hours and then fails with this error message:

Program Ice.Services.Lib.RunTask when executing task 110298 raised an unexpected exception with the following message: RunTask:
System.FormatException: The input string 'LLC' was not in a correct format.
   at System.Number.ThrowFormatException[TChar](ReadOnlySpan`1 value)
   at Erp.Internal.SI.BulkAddrValLogic.printLog() in C:\_releases\ERP\ERP11.3.100.0\Source\Server\Internal\SI\SILib\BulkAddrValLogic\BulkAddrValLogic.cs:line 316
   at Erp.Internal.SI.BulkAddrValLogic.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:\_releases\ERP\ERP11.3.100.0\Source\Server\Internal\SI\SILib\BulkAddrValLogic\BulkAddrValLogic.cs:line 184
   at Ice.Core.TaskBase`1.StartProcess(Int64 instanceTaskNum, String outputFileName) in F:\_Releases\11.3.100\UD11.3.100.8\Source\Server\Internal\Lib\TaskLib\TaskBase\TaskBase.cs:line 83
   at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:\_releases\ICE\ICE4.3.100.8\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 113
   at Ice.Hosting.TaskCaller.ExecuteTask() in C:\_releases\ICE\ICE4.3.100.8\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 61
   at Ice.Hosting.TaskCaller.ExecuteTask(IceDataContext dataContext, Boolean suppressTransaction) in C:\_releases\ICE\ICE4.3.100.8\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 41
   at Ice.Services.Lib.RunTaskSvc.<>c__DisplayClass30_2.<InnerRunTask>b__1() in C:\_releases\ICE\ICE4.3.100.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 460
   at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in C:\_releases\ICE\ICE4.3.100.0\Source\Server\Services\Lib\RunTask\BpmFriendlyTaskLauncher.cs:line 57
   at Ice.Services.Lib.RunTaskSvc.InnerRunTask(Int64 ipTaskNum, Boolean suppressTransaction) in C:\_releases\ICE\ICE4.3.100.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 457

I don’t understand why the process takes the same amount of time to fail regardless if we tell it only do x addresses, and I don’t know how to find what record its failing on. So far support hasn’t been any help.

I made a BAQ to check if any addresses had ‘LLC’ in the state, zip, or country. Didn’t find any.

klincecum · July 22, 2024, 5:43pm

Check Name, Address1, Address2

aosemwengie1 · July 22, 2024, 9:05pm

I would guess the problem is a special character that precedes ‘LLC’ in one of the customer names.

Evan_Purdy · July 23, 2024, 11:36am

I’m thinking that as well. Gonna look for % sign first.

Does anyone have a magic BAQ/SQL trick for finding characters outside a-z and 1-0?

aosemwengie1 · July 23, 2024, 11:38am

Chatgpt is great at writing this

Evan_Purdy · July 23, 2024, 12:40pm

ughh so I have discovered sometimes sales used C/O for “in care of” but in other cases they used a % instead of C/O

klincecum · July 23, 2024, 12:42pm

I think a little cleanup and a new allowed character bpm is in order…

Evan_Purdy · July 23, 2024, 12:44pm

I already know addresses need A LOT of cleanup. There wasn’t enough will power to go as far as I wanted, but hopefully this TaxConnect project will get us 50% there.

The addresses are junk, but I still find it lame that and address verification process fails on a bad address, cmon.

Ernie · July 23, 2024, 1:43pm

Wow… that used to be fairly common… but I haven’t seen it for probably a dozen years or so.

Evan_Purdy · July 23, 2024, 5:11pm

Hmm removed all % same error… removed all LLC from address 1 and address 2, same error. Tried manually validating suspicious ship to’s manually from customer entry and they work fine. I think its the filtering that is dying, not the address verifying part.

@Olga By looking at the source code line number, can you tell me what field it is looking at when throws the exception?

Olga · July 23, 2024, 5:18pm

                        string[] addrSource = ttETCAddress.AddrSourceID.Split(',');

and then
custNum = int.Parse(addrSource[2].Trim());
where it fails

So apparenly you have some address with , LLC. Remove comma

Evan_Purdy · July 23, 2024, 5:26pm

I can’t change a Ship To ID or delete ones that have been used on an invoice/order/etc.

Do I request a datafix?

Evan_Purdy · July 23, 2024, 5:36pm

I marked all Ship To ID’s with a comma as exclude from validation, and started the process again. We will see if that works.

Evan_Purdy · July 23, 2024, 8:13pm

Well, it ran for a few hours and then marked itself as canceled.

Trying again with a filter to try and reduce the number of records processed…

klincecum · July 23, 2024, 8:22pm

Make the filter do like 10 records lol.

Evan_Purdy · July 23, 2024, 8:24pm

We did, no matter what we pick it takes at least 1.5 hours. I have no idea what its doing.

Evan_Purdy · July 24, 2024, 11:52am

Okay, it finally ran but now we can’t download the file

Edit: Its forming the path wrong, missing a \ …

Evan_Purdy · July 24, 2024, 12:11pm

Trying to download it myself thru swagger:

Not quite there… Not sure what part of the path is wrong now

Evan_Purdy · July 24, 2024, 1:26pm

Kinetic in the browser was able to download the file.

sus