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

Error when parsing/analyzing table name containing a forward slash #352

Open
arnovdk opened this issue Aug 25, 2023 · 0 comments
Open

Error when parsing/analyzing table name containing a forward slash #352

arnovdk opened this issue Aug 25, 2023 · 0 comments
Assignees

Comments

@arnovdk
Copy link

arnovdk commented Aug 25, 2023

Description:
When connecting to an Oracle Database schema to create a SIARD export file from it, an exception occurs when it encounters a table that contains a forward slash (/) in its name.

Context:

  • DBPTK Desktop: Windows 10 22H2
  • Oracle Database schema (tested in DB 11 and DB 19)

Steps required to reproduce the bug:

  1. Make sure that the schema contains a table with a name like SYS_NTjkfjdjsdf/fsdkjdfhjks (these are generated automatically by the RDBMS)
  2. Connect to the schema and let DBPTK analyze it
  3. Wait till the error occurs

Relevant log lines:

2023-08-25 07:55:50,694 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.RESERVERINGSREGELS
2023-08-25 07:55:51,690 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.RRL_ORDER_STATUSSEN
2023-08-25 07:55:52,580 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.RRL_STATUSSEN
2023-08-25 07:55:53,518 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.RRL_VERZOEKEN
2023-08-25 07:55:54,498 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SCHERMAKTIES
2023-08-25 07:55:55,409 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SOORTEN_ONDER_SOORT
2023-08-25 07:55:56,300 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SOORTEN_PER_BLOK
2023-08-25 07:55:57,222 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SOORTEN_PER_UITVOERDOCUMENT
2023-08-25 07:55:58,151 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SORTEERMETHODEN
2023-08-25 07:55:59,112 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SORTEERVELDEN
2023-08-25 07:56:00,009 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.STANDARD_AUTH
2023-08-25 07:56:00,929 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYNC_FVD_AWE
2023-08-25 07:56:01,841 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTAPNEA4R49N#1GHEN$8BRMS=N
2023-08-25 07:56:02,725 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTARK=2=3U0TVNO9TY$8BRMS=N
2023-08-25 07:56:03,582 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTC813E0N-+UP2#PCT$8BRMS=N
2023-08-25 07:56:04,482 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NT+DGCAXK6NE5$J-_R$8BRMS=N
2023-08-25 07:56:05,418 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTEJDSXK_LFWJBV#0N$8BRMS=N
2023-08-25 07:56:06,303 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTG2RB2G+SG32BLFZT$8BRMS=N
2023-08-25 07:56:07,211 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTG4O#NSFJ$8L3S7_4$8BRMS=N
2023-08-25 07:56:08,236 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTID95E7U9Q4WQ91HO$8BRMS=N
2023-08-25 07:56:09,120 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTKWHPJ3QAS-=RZ+FU$8BRMS=N
2023-08-25 07:56:10,024 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTM$YD2NBR2#95HR4O$8BRMS=N
2023-08-25 07:56:10,985 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTOQ$26J$X3DN6$Z2U$8BRMS=N
2023-08-25 07:56:11,891 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NT_$-PXD7NZMCNY0VS$8BRMS=N
2023-08-25 07:56:12,788 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTqxArxXLiTLjgU8oAqMAFHw==
2023-08-25 07:56:13,699 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTqxArxXLjTLjgU8oAqMAFHw==
2023-08-25 07:56:14,641 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTqxArxXLkTLjgU8oAqMAFHw==
2023-08-25 07:56:15,547 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTqxArxXLlTLjgU8oAqMAFHw==
2023-08-25 07:56:16,453 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTqxArxXLmTLjgU8oAqMAFHw==
2023-08-25 07:56:17,318 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTqxArxXLnTLjgU8oAqMAFHw==
2023-08-25 07:56:18,187 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTqxArxXLoTLjgU8oAqMAFHw==
2023-08-25 07:56:19,073 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTqxArxXLpTLjgU8oAqMAFHw==
2023-08-25 07:56:19,983 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTqxArxXLqTLjgU8oAqMAFHw==
2023-08-25 07:56:20,869 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTqxArxXLrTLjgU8oAqMAFHw==
2023-08-25 07:56:21,773 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTqxArxXLsTLjgU8oAqMAFHw==
2023-08-25 07:56:22,732 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTqxArxXL+TLjgU8oAqMAFHw==
2023-08-25 07:56:23,615 [http-nio-auto-1-exec-3] INFO  c.d.modules.jdbc.in.JDBCImportModule - Obtaining table structure for ONTWFLEXIS.SYS_NTqxArxXL/TLjgU8oAqMAFHw==
2023-08-25 07:56:23,655 [http-nio-auto-1-exec-7] ERROR c.d.c.c.c.utils.AsyncCallbackUtils - [0:0:0:0:0:0:0:1] AsyncCallback error - RESTException: Remote exception caused by GenericException: ORA-01424: Na het Escapeteken ontbreekt een teken of volgt een ongeldig teken.2023-08-25 07:56:23,655 [http-nio-auto-1-exec-7] ERROR c.d.c.c.c.utils.AsyncCallbackUtils - [0:0:0:0:0:0:0:1] AsyncCallback error - RESTException: Remote exception caused by GenericException: ORA-01424: missing or illegal character following the escape character.

As you can see, the process appears to stop at the table containing a / in its name. I have tried to reproduce this in various schemas, all of which contain various SYS_NT-tables, all with a random name. Every time the process seems to stop at the first table it encounters, that has a / in its name.

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

No branches or pull requests

2 participants