question

Jeeva-6453 avatar image
0 Votes"
Jeeva-6453 asked KranthiPakala-MSFT commented

Azure Data Warehouse secret key leads to base-64 error-Databricks

When I try to execute from databricks with storage access key either it fails with

42000: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters.

or

'42S22', "[42S22] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name

azure-databricks
· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @jeeva-6453,

Thanks for reaching out and sorry for the delay in response. Could you please confirm if this is a transient issue or are you seeing this consistently?

We look forward to your confirmation.

0 Votes 0 ·

Hi @KranthiPakala-MSFT

Thanks for looking into this. I see this consistently. Below is the error from this morning.

ProgrammingError: ('42000', '[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters. (110813) (SQLExecDirectW)')

0 Votes 0 ·

Hi @jeeva-6453,

Thanks for your response. This issue requires a deeper investigation. I would suggest to file a support ticket so that a support engineer can take deeper to figure out the root case and possible solution. In case if you don't have a support plan do let us know here.

Thank you

0 Votes 0 ·

Hi @jeeva-6453,

Following up to see if you have got a chance to file a support ticket? If yes, could you please share the SR# with us for internal tracking? In case if you don't have a support plan, do let us know here.

THanks

0 Votes 0 ·

Here is the tracking number I have.

TrackingID#2105050040005098

0 Votes 0 ·

Thank you. Please do share the resolution details here once you got the solution from support engineer, as it could be beneficial to other community member who read this thread.

0 Votes 0 ·

0 Answers