Deployment Data with a timestamp column (failed)


Author
Message
Tony Charpentier
Tony Charpentier
StrataFrame Novice (52 reputation)StrataFrame Novice (52 reputation)StrataFrame Novice (52 reputation)StrataFrame Novice (52 reputation)StrataFrame Novice (52 reputation)StrataFrame Novice (52 reputation)StrataFrame Novice (52 reputation)StrataFrame Novice (52 reputation)StrataFrame Novice (52 reputation)
Group: StrataFrame Users
Posts: 10, Visits: 81
Hello,

i would like to use a Deployment Data on DDT,
to copy a reference table source on destination table.

But i have timestamp column and i can't choose each column i want .

Have you an idea to force the export ?
Replies
Michel Levy
Michel Levy
Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)
Group: StrataFrame Users
Posts: 193, Visits: 9K
Salut Tony,

je ne vois que la possibilité de supprimer cette colonne TimeStamp avant le déploiement (avec un script pre-Deploy dans ton projet DDT), et de la recréer après avoir déployé les data (script post-deploy).

Attention, je n'ai pas testé!

Au fait, si tu as essayé avec la colonne Timestamp, est-ce que tu as levé une erreur? si oui, laquelle?




Hi Tony,

I can see only one way in this case: delete this Timestamp column before data deployment, using a pre-deploy script in your DDT project, and create it after data deployment (with a post-deply script).

Be aware I've not tested!

BTW, it you attempt to deploy with the timestamp column, did you throw an error? if yes, wich one?
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Hi guys.

Check the thread from this post and see if it helps:

http://forum.strataframe.net/FindPost13440.aspx


Michel Levy
Michel Levy
Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)
Group: StrataFrame Users
Posts: 193, Visits: 9K
Hi Ivan,

do you mean that the real issue could be in some related FK, and not in the timestamp column?
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
According to those posts, there could be an issue if the TimeStamp were a field in a table being deployed which had children related to it.
Have a look at the 2 last posts from George and Trent.
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