hainguyen007 / power-architect Goto Github PK

It will be very interessting to allow the creation and the manipulation of 
normal dimension. That is to say dimension directly available in a cube. Fow 
now only shared dimension is supported.

Best regards.

Hi!

Thanks for your interest in filing a bug report or enhancement request
against the Power*Architect.

We don't currently use this issue tracker provided by Google Code
Hosting--we have our own issue tracker that we've been using since before
moving the Architect here. You can access it at:

http://trillian.sqlpower.ca/bugzilla/

We also have a user support forum, which you can access at:

http://www.sqlpower.ca/forum

Once again, please don't post bugs here. We do not monitor this issue
tracker. Use one of the above resources instead.

-Jonathan

1. Open a Power Architect file.
2. Click Save (not Save As)
3. It prompts you for a location.

I think that if you just click "Save" it shouldn't ask you for a file location.

What steps will reproduce the problem?
1. connect to a SQL Server Database
2. create a table and document its fields using MS SQL Server Management Studio 
(via the Description Field)
3. import the table into SQL Power Architect

What is the expected output? What do you see instead?

The column descriptions should be imported as "remarks". Instead there are no 
remarks imported but everything is empty.

What version of the product are you using? On what operating system?

MS Sql server 2008 R2 on Windows, SQL Power Architect on Mac OSX 10.8 (dont 
think it matters though).

Please provide any additional information below.

What steps will reproduce the problem?
1. Create a new project 
2. Connect to a database
3. Import tables from a database to the new model

What is the expected output? What do you see instead?
Would be interesting a ordering option in the Data Model List, so we could 
order the tables that was imported by name for example.

For me the order of the list is the one that the table was imported 

What version of the product are you using? On what operating system?
SQL-Power-Architect-Setup-Windows-jdbc-1.0.6

Please provide any additional information below.

This is more of an enhancement

It would be nice if these features can be added.
Show/hide 
1. Columns 
2. Column Data Types

Also if Remarks on a table, relationship link if can be shown on the 
playpen it would be nice. That would enable to describe on the roles that 
a table plays in a relation or any implementation notes that developers 
can share between them 

What steps will reproduce the problem?
1. Launch architect from Eclipse
2. Load test environment connection 
3. select HR database
4. select either Employees or Location table

What is the expected output? What do you see instead?
The expected out out is Employees or Location table is in PlayPen. But instead 
it displays 'NullPointerException' as below:

java.lang.RuntimeException: java.lang.RuntimeException: 
java.lang.NullPointerException
    at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.cleanup(PlayPen.java:1700)
    at ca.sqlpower.swingui.SPSwingWorker$1.run(SPSwingWorker.java:114)
    at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
    at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:702)
    at java.awt.EventQueue.access$400(EventQueue.java:82)
    at java.awt.EventQueue$2.run(EventQueue.java:663)
    at java.awt.EventQueue$2.run(EventQueue.java:661)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:672)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:201)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:196)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:188)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Caused by: java.lang.RuntimeException: java.lang.NullPointerException
    at ca.sqlpower.sqlobject.SQLTable.populateRelationshipsWithList(SQLTable.java:820)
    at ca.sqlpower.sqlobject.SQLTable$5.run(SQLTable.java:737)
    at ca.sqlpower.architect.swingui.ArchitectSwingSessionImpl.runInForeground(ArchitectSwingSessionImpl.java:1166)
    at ca.sqlpower.object.AbstractSPObject.runInForeground(AbstractSPObject.java:669)
    at ca.sqlpower.sqlobject.SQLTable.populateRelationships(SQLTable.java:732)
    at ca.sqlpower.sqlobject.SQLTable.createTableFromSource(SQLTable.java:300)
    at ca.sqlpower.sqlobject.SQLTable.createInheritingInstance(SQLTable.java:287)
    at ca.sqlpower.architect.swingui.PlayPen.importTableCopy(PlayPen.java:1258)
    at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.cleanup(PlayPen.java:1621)
    ... 15 more
Caused by: java.lang.NullPointerException
    at ca.sqlpower.sqlobject.SQLRelationship.attachRelationship(SQLRelationship.java:578)
    at ca.sqlpower.sqlobject.SQLRelationship.attachRelationship(SQLRelationship.java:531)
    at ca.sqlpower.sqlobject.SQLTable.populateRelationshipsWithList(SQLTable.java:796)
    ... 23 more
19341 [AWT-EventQueue-0] ERROR ca.sqlpower.swingui.SPSUtils  - dialog parent 
component null is neither JFrame nor JDialog

So far, I can only "forward a database" by recreating it. Would be nice if 
possible to just apply the changes to existing schema.

For example, if user rename a column, when generating forward script, if the 
column already exists in the old name, then it shall provide the 

alter table XXXX rename column YYYY to PPPP

etc.

Regards,

Edson

What steps will reproduce the problem?
1. Create a model
2. Sync the model with the MySQL database
3. Add an index
4. Use tools compare DM to update the database to the most recent model

What is the expected output? What do you see instead?
I would expect a create index statement, however the compare DM tool reports no 
differences


What version of the product are you using? On what operating system?
1.0.7 on OSX 10.9.4

Please provide any additional information below.
Using MySQL 5.5.21

What steps will reproduce the problem?
Power-architect will be a very good mondrian schema designer when we can 
create, and manage view 

as that

<Dimension name="ProductFood" primaryKey="product_id" primaryKeyTable="product">

                      <Hierarchy hasAll="true" allMemberName="All Products" primaryKey="product_id">

                        <View alias="Product">

                          <SQL dialect="generic">

                            select 

                                  pc.product_family as product_family,

                                  p.product_id as product_id,

                                  p.product_name as product_name,

                                  p.brand_name as brand_name,

                                  pc.product_subcategory as product_subcategory,

                                  pc.product_category as product_category,

                                  pc.product_department as product_department

                            from 

                                  product as p, product_class as pc

                            where 

                                  p.product_class_id = pc.product_class_id

                                  and pc.product_family = 'food'
                          </SQL>

                        </View>

                        <Level name="Product Family" column="product_family" uniqueMembers="false"/>

                        <Level name="Product Department" column="product_department" uniqueMembers="false"/>

                        <Level name="Product Category" column="product_category" uniqueMembers="false"/>

                        <Level name="Product Subcategory" column="product_subcategory" uniqueMembers="false"/>

                        <Level name="Brand Name" column="brand_name" uniqueMembers="false"/>

                        <Level name="Product Name" column="product_name" uniqueMembers="true"/>

                      </Hierarchy>

                    </Dimension>

What steps will reproduce the problem?

I have a connection with POSTGRESQL and database with tables, and many tables 
have on data type   = "TEXT"

So if I

1. Open design table
2. Sayme Choose a type for xcolumn, but I dont want change data type, because 
postgresql 9.1 support type text.


What is the expected output? What do you see instead?

Open design table with type "TEXT"

What version of the product are you using? On what operating system?
1.06

What steps will reproduce the problem?
1. Launch test_environment database
2. explore OE schema
3. select & drop ACTION_TABLE

it draw Action_Table into playpen with following error message.

java.lang.IllegalArgumentException: Table ACTION_TABLE is not in this rowset
    at ca.sqlpower.sql.jdbcwrapper.IndexedCachedRowSet.extractSingleTable(IndexedCachedRowSet.java:87)
    at ca.sqlpower.sql.jdbcwrapper.OracleDatabaseMetaDataDecorator.getColumns(OracleDatabaseMetaDataDecorator.java:661)
    at ca.sqlpower.sqlobject.SQLColumn.fetchColumnsForTable(SQLColumn.java:482)
    at ca.sqlpower.sqlobject.SQLTable.populateAllColumns(SQLTable.java:407)
    at ca.sqlpower.sqlobject.SQLTable.populateColumns(SQLTable.java:365)
    at ca.sqlpower.sqlobject.SQLTable.populateImpl(SQLTable.java:1335)
    at ca.sqlpower.sqlobject.SQLObject.populate(SQLObject.java:186)
    at ca.sqlpower.sqlobject.SQLTable.getChildren(SQLTable.java:1963)
    at ca.sqlpower.sqlobject.SQLObject.getChildren(SQLObject.java:285)
    at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.ensurePopulated(PlayPen.java:1577)
    at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.doStuff(PlayPen.java:1552)
    at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:104)
    at java.lang.Thread.run(Thread.java:680)



Please use labels and text to provide additional information.

When a new column is added to a table, in the play pen the scale value is 
displayed for all types. 

It would be nice if 
1. Precision is alone displayed for character types
2. For int types none of precision or scale are displayed. 
3. For numeric types both the precision and scale are displayed 

Version being used: 0.9.10

What is the expected output? What do you see instead?
I can't find a way to update remote database table structure.

What version of the product are you using? On what operating system?
0.9.10 on Leopard OSX

Please provide any additional information below.
If I create a db connection (to MySQL in my case), and then I edit tables via 
Power Architect 
submitting new fields/tables via Compare tool, I don't get remote structure 
updated.
Same problem if I update something on DB not via Power Architect, it doesn't 
see any modification 
and the only way is creating a new project reimporting all data in the new 
project.