Your feedback is highly appreciated! Let's make Vertabelo even better.

  1. Forum: Vertabelo
0
Fixed

​​reverse engineering fails if any function-based index exists

Ilya Kharlamov 9 years ago • updated by anonymous 9 years ago • 2

Dzień dobry

  1. get reverse-engineering-1_6_9.jar
  2. oracle 11.2.0.4.0
  3. create a table that uses fbi (a function based index)


create table

AAA

(

x number

);

create index aaa_idx1 on AAA(upper(x));


4. call the reverse-engineering-tool

Exception in thread "main" com.vertabelo.reverse.nr: Column SYS_NC00002$ not found in AAA

at com.vertabelo.reverse.ns.a(:1413)
at com.vertabelo.reverse.ns.a(:1392)
at com.vertabelo.reverse.ny.a(:317)
at com.vertabelo.reverse.ns.b(:550)
at com.vertabelo.reverse.ns.c(:412)
at com.vertabelo.reverse.ns.b(:185)
at com.vertabelo.reverse.Main.main(:491)


Solution:

You use in your code


paramDatabaseMetaData.getString("COLUMN_NAME");


but you'll need to check if this column really exists via DatabaseMetaData.getColumns before doing that



Answer
anonymous 9 years ago

Unfortunately, Vertabelo doesn't support this construction now - indexes may have only columns from the table. We have this feature on our roadmap, but it's not available yet.


I've fixed the problem in the reverse-engineering tool so that such indexes were ignored and listed at the end of the reverse-engineering operation. Here is a link to the JAR with this issue fixed: reverse-engineering-1_6_10.jar
Please, check if it works well now.


Regarding indexes with expressions, I'd suggest placing them manually in the "Additional SQL scripts" section in table properties. This way, they'll be present in the output SQL script.


I look forward to your feedback.

0
Answered

Vertabelo tutorial

Mario Nardi 9 years ago • updated by Jack Polkowski 9 years ago • 2
How can I watch Vertabelo tutorial again, I accidentally cancelled it!
Answer
Jack Polkowski 9 years ago
For other users who also need to run the tutorial:

1. Go to the diagram (open any of your models or create a new one).
2. In the top menu bar, click Help.
3. From the drop-down menu, choose Take application tour.




You can also watch our video tutorials:

How to manage large database diagrams in Vertabelo



How to create a reference in Vertabelo



0
Answered

How do I place a table in a subject area by editing the xml from the reverse engineering tool

Jason Ethridge 9 years ago • updated by Jarosław Błąd (CEO) 9 years ago • 3
I have a large database that I would like to pre-group via subject areas before I import the xml into Vertabelo. Is it possible to hand edit the reverse engineer xml to add several subject areas and then associate tables with those subject areas?
0
Completed

Get versioned models using API

Raymond Roelands 10 years ago • updated by Rafał Strzaliński (Senior Engineer) 9 years ago • 5
It would be nice if the API also supports retrieving a specific version or tag of a model
0
Answered

How to move a column up or down within a table

Tanuj Nayanam 9 years ago • updated 9 years ago • 4
Suppose I have 10 columns in my vertabelo table diagram. Now by mistake I have put the last column as Primary Key. Is there any way to move up that primary key column in the table diagram?
0
Answered

Please, switch my trial account to academic account

Venkata Siva Sandeep Maddali 9 years ago • updated by Jack Polkowski 9 years ago • 2
I am not able to convert my account to an academic one. Please help me.
0
Not a bug

Copy relationships along with table shortcut

Kent Graziano 9 years ago • updated by Jack Polkowski 9 years ago • 5
When I do a copy and past shortcut for multiple tables that are related, it should automatically show the relationships between those tables. Now it looks like I must create a 2nd relationship between the shortcut tables.
0
Answered

Share button is not active

Ganbayar Gansukh 9 years ago • updated by Jack Polkowski 9 years ago • 2
I have an academic plan, and the share button is not active. Does academic plans not able to share the model?

I do believe this button was active at some point time ago
Answer
Jack Polkowski 9 years ago
Hi!
Inactive "share" button means that you are not the owner of the model and you can't invite new persons to share it.
If you'd like to check your role in the model, go to the "Model details" panel. For that particular model, your role is set as an editor.

I noticed that in your case the model had been shared with you by the owner who then closed his/her account. So at the moment the model doesn't have its owner.

If you would like to share it with other persons, first you must clone it. Once again, go to the "Model details" panel, then click the button "Clone model" on the right. Since you are the owner of the cloned model, you can share it with other persons.

I hope I helped you.

Best regards and enjoy Vertabelo!
0
Under review

Error in view builder using LEAD function

Kent Graziano 9 years ago • updated by Jack Polkowski 9 years ago • 3
When I try to create a view using this SQL I get a parsing error:
SELECT
dbms_obfuscation_toolkit.md5(upper(trim(HC.COUNTRY_ABBRV))
|| '^'
|| TO_CHAR(SC.SAT_Load_DTS, 'YYYY-MM-DD')) AS DIM2_COUNTRY_KEY,
HC.COUNTRY_ABBRV,
SC.COUNTRY_NAME,
SC.SAT_Load_DTS AS EFFECTIVE_DTS,
LEAD(SC.SAT_Load_DTS) OVER (PARTITION BY SC.HUB_COUNTRY_KEY ORDER BY
SC.SAT_Load_DTS) AS EXPIRE_DTS,
SC.SAT_Rec_SRC AS REC_SRC
FROM
HUB_COUNTRY HC,
SAT_COUNTRIES SC
WHERE
HC.HUB_COUNTRY_KEY = SC.HUB_COUNTRY_KEY
0
Answered

request for switching my account to the academic one

Wenyuan Gao 9 years ago • updated by Jack Polkowski 9 years ago • 1
Answer
Jack Polkowski 9 years ago
Hi! Your account has been switched to the academic one. After logging in, you'll be requested to complete the registration form.
Best regards and enjoy Vertabelo!


Customer support service by UserEcho