DDT Database Import


Author
Message
Govinda Berrio
Govinda Berrio
StrataFrame User (240 reputation)StrataFrame User (240 reputation)StrataFrame User (240 reputation)StrataFrame User (240 reputation)StrataFrame User (240 reputation)StrataFrame User (240 reputation)StrataFrame User (240 reputation)StrataFrame User (240 reputation)StrataFrame User (240 reputation)
Group: StrataFrame Users
Posts: 94, Visits: 481
I'm having this problem too. I have SF ver1.6.6.



Also, in the DDT Modify Table Structure screen, why isn't there a Numeric type in the Data Type drop down?



Thanks
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
Larry,

Sorry for the delay here.  Our responses are generally much quicker than this but we are not in the office this week.  I will add this to the list and check into it next week.  Thanks for the heads up! Smile

Larry McIntosh
Larry McIntosh
StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)
Group: StrataFrame Users
Posts: 5, Visits: 543
I have found the DDT Import database structure converted all my numeric data types to "int".  It imported decimal types properly but not numeric.  For example, the DDT import for numeric(10,2) shows the data type as "Int" but the detail shows Size: 9, Precision: 10, Scale: 2 as for a numeric data type.  The import was from an SQL 2005 database.
Dustin Taylor
Dustin Taylor
StrataFrame Team Member (652 reputation)
Group: StrataFrame Users
Posts: 364, Visits: 771
Bastian,

I've been trying to reproduce the issue you are describing but so far everything I've tried has come accross without issue. Creating and outlining a new table in the DDT with two decimal fields (one 18,4 and one 18,5) comes accross just fine after deployment.

Are you on the latest version of the framework? The 1.6.6 beta listed here is actually very stable (it will be released officially as soon as the documentation updates are completed.)

Dustin Taylor
Dustin Taylor
StrataFrame Team Member (652 reputation)
Group: StrataFrame Users
Posts: 364, Visits: 771
Sorry for the delay on this Bastian, we were all out of the office for labor day this weekend.

I believe we handled the above on an import a while back, but I'll need to reproduce the scenario you are describing on a deployment so we can work through it (if it still manifests.) I know you are in a rush for this so it is high on the priority list. I'll get back to you once I know more.

Thanks,

Dustin

Bastian Töpfer
Bastian Töpfer
StrataFrame Beginner (46 reputation)StrataFrame Beginner (46 reputation)StrataFrame Beginner (46 reputation)StrataFrame Beginner (46 reputation)StrataFrame Beginner (46 reputation)StrataFrame Beginner (46 reputation)StrataFrame Beginner (46 reputation)StrataFrame Beginner (46 reputation)StrataFrame Beginner (46 reputation)
Group: Forum Members
Posts: 32, Visits: 107
Oh, ... that was in the wrong topic.

I actually meant that this happens when I deploy a ddt package not when I import a database
Bastian Töpfer
Bastian Töpfer
StrataFrame Beginner (46 reputation)StrataFrame Beginner (46 reputation)StrataFrame Beginner (46 reputation)StrataFrame Beginner (46 reputation)StrataFrame Beginner (46 reputation)StrataFrame Beginner (46 reputation)StrataFrame Beginner (46 reputation)StrataFrame Beginner (46 reputation)StrataFrame Beginner (46 reputation)
Group: Forum Members
Posts: 32, Visits: 107
Hi,



any news about that? I have the same issue with decimal(18,4) and decimal(18,5)

This is very important and urgent to me. Planned to roll out to the first customer tomorrow and I cant if that doesnt work.



thanks for your help,





Bastian
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
We'll look into this.  Thanks.
Richard Keller
Richard Keller
StrataFrame User (132 reputation)StrataFrame User (132 reputation)StrataFrame User (132 reputation)StrataFrame User (132 reputation)StrataFrame User (132 reputation)StrataFrame User (132 reputation)StrataFrame User (132 reputation)StrataFrame User (132 reputation)StrataFrame User (132 reputation)
Group: Forum Members
Posts: 84, Visits: 324
DDT Database Import converts Decimal(18,6) to Int.

Richard

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search