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

New to bytebase. Error when getting database schema on sync schema #12001

Open
urheil opened this issue May 15, 2024 · 1 comment
Open

New to bytebase. Error when getting database schema on sync schema #12001

urheil opened this issue May 15, 2024 · 1 comment
Labels
bug Something isn't working

Comments

@urheil
Copy link

urheil commented May 15, 2024

Provide the Bytebase version you are using

v2.16.0

Describe the bug

Hi. New to bytebase and new to this bugs submit. Please forgive me if i don't use it correctly.

I followed the tutorial adapting it to two databases i have. i have the free version of bytebase.
I tried to sync schemas for the first time and got this error:

/bytebase.v1.DatabaseService/GetDatabaseSchema INTERNAL: failed to get concise schema, error Syntax error at line 5757:120
related text: ASC, SYS_EXTRACT_UTC("END_DATE") ASC, ASC

It seems to be a part of an index related to a timestamp(6) column called end_date.

Is it a known issue? Am i doing something wrong?

Steps to reproduce

Create two databases with the bytebase user in oracle.
Those databases already have data in the same schemas (that are different from bytebase).

Have (i suppose) an index with a timestamp(6) column in it in one schema.

Try to sync schemas.

Expected behavior

When putting the source schema throws the error and don't let you click next.
image

Provide the database you are using

Oracle 19c

Provide the version control system you are using

No response

Additional context

No response

@urheil urheil added the bug Something isn't working label May 15, 2024
@urheil
Copy link
Author

urheil commented May 15, 2024

Error pic:
image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant