Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ST Table failing to import #4

Open
djon3s90 opened this issue Oct 5, 2022 · 1 comment
Open

ST Table failing to import #4

djon3s90 opened this issue Oct 5, 2022 · 1 comment

Comments

@djon3s90
Copy link

djon3s90 commented Oct 5, 2022

ST Table is failing to import again, looking at the previous bug i suspect it is the same issue that occurred mid 2021
When i add $Error[0].Exception.InnerException.InnerExceptions to the powershell script i get the following;

Received an invalid column length from the bcp client for colid 92

I have also shot you a DM on slack

@djon3s90 djon3s90 changed the title ST failing to import ST Table failing to import Oct 6, 2022
@djon3s90
Copy link
Author

djon3s90 commented Oct 6, 2022

An option "not provided" appears to have been added to the Emergency contacts field in CASES, this is over the 11 character parameter set on the local ST table in SQL. We opted to change this to varchar(max)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant