Databasimport wrong with bigint?

[womisa]

Hi all,

i have a SQL Server 2005 Database table with a column from Type bigint (Timeticks c#). It is not possible to import this in Diadem 10.1. (BUG or Feature?)
...Navigate to Database Table.....Context Menue===>...Daten laden
Error MessageBox:
Allgemeiner Fehler im Befehl StorageImport
DDIADATA IMPORTCOPY PARTIAL OBJECT FAILED

Can anybody help me?

Thanks Achim

[Brad_Turpin]

Hi Achim,

By "bigint" do you mean 64 bit integer?  If so, is it signed (I64) or unsigned (U64)?  I am not aware of a data type limitation for importing data base columns into DIAdem, but I also don't think I've ever personally tried a 64 bit integer column with DIAdem.  Do you succeed if you only drag the SGL or DBL columns into DIAdem, or does that also give you an error?

Brad Turpin
DIAdem Product Support Engineer
National Instruments

[womisa]

Hi Brad,

thanks for your answer. I create my table with

CREATE TABLE [mda].[WtImportFiles](
    [WsTID] [bigint] IDENTITY(1,1) NOT NULL,
    [WsDateTime] [datetime] NULL DEFAULT (getdate()),
    [WsFileDateTime] [datetime] NULL,
    [WsFileDateTimeTicks] [bigint] NULL,
    [WsFileSize] [bigint] NULL,
    [WsFullFileName] [varchar](256) COLLATE Latin1_General_CI_AS NOT NULL,
    [WsDirectoryName] [varchar](256) COLLATE Latin1_General_CI_AS NOT NULL,
    [WsName] [varchar](256) COLLATE Latin1_General_CI_AS NULL,
    [WsExtension] [varchar](256) COLLATE Latin1_General_CI_AS NULL,
    [WsMdTableName] [varchar](256) COLLATE Latin1_General_CI_AS NULL,
    [WsKanalCount] [smallint] NULL
) ON [PRIMARY]


I can load the table without the bigint with a ERROR Message.... Ican not drag and drop a [bigint] column to import...
ERROR-Message BOX : ====>Allgemeiner Fehler im Befehl StorageImport

Achim