I had a schema that I edited a bit – rearranging columns, changing column sources, and deleting other columns – and then it broke inexplicably. Then I simply cloned the schema without any changes, but the clone works correctly, similar to the original!
The two schemas are these:
Facility Inpatient Claim Line (BROKEN)
Facility Inpatient Claim Line (CLONE)
The “BROKEN” one is the one I edited that stopped working. The “CLONE” is an exact copy it, bit it behaves correctly, just like the original before the breaking changes.
In the broken copy, the claimId and lineNumber columns always have the same value, while in the clone, the lineNumber correctly alternates between values 1 and 2, and the claimId correctly changes value after every second lineNumber.
I am hoping you can compare these two schemas to determine what is internally different that would make them behave so differently.
Thank you.